Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Dbsql Tables

Quote Reply
Dbsql Tables
Hi,

Could someone please explain the following -

Table Name: Dbsql

What are the possible values of the “Type” field and what do they mean?



Table Name: Dbsql_EmailMailings

Can you give me a short description of what this table is used for?

What are the possible values of the “Sent” field and what do they mean?



Table Name: Dbsql_MailingIndex

Can you give me a short description of what this table is used for?

Is the “done” field for the date? What does “done” mean?

What kind of a date is this – “1061262431”



Table Name: Dbsql_MailingListIndex

Can you give me a short description of what this table is used for?



Table Name: Dbsql_Relationships

What are the possible values of the “oselect” and “fn” field and what do they mean?



Thank you.

Simon.
Quote Reply
Re: [jai] Dbsql Tables In reply to
Simon,

AFAIK these tables are used by DBManSQL to keep track of all the other tables, etc.

The Stone would probably be able to give a more detailed answer.

All the best
Shaun
Quote Reply
Re: [qango] Dbsql Tables In reply to
Thanks Shaun,

I know what the tables are for but it"s some of the contents I am not sure about.

Could someone from GT please answer my questions.

Thank you.
Quote Reply
Re: [jai] Dbsql Tables In reply to
Fot those who are interested I got the answers to my questions via GT support (thanks Jean).


Table Name: Dbsql
What are the possible values of the [Type] field and what do they mean?

Type => {type => 'ENUM', values =>
['0', '1','2'], default => '2'},

0: default Dbsql tables ..i.e Dbsql,Dbsql_EmailMailings,Sample_Log ...
1: user tables. This type of table is used for storing users information who
can access to a user created table.
2: user created tables.

Table Name: Dbsql_EmailMailings
Can you give me a short description of what this table is used for?
What are the possible values of the [Sent] field and what do they mean?

This table is used for checking whether all the emails in the associated
mailing are sent or not. The [Sent] field can be either 0 (false) or 1 (true)
and it means the email has been sent to the email address if the [Sent] value
is true.

Table Name: Dbsql_MailingIndex
Can you give me a short description of what this table is used for?
Is the [done] field for the date? What does [done] mean?
What kind of a date is this [1061262431]

This table is used for storing the email message which will be sent to a
mailing list. Yes, the [done] field is for the date and that's unix timestamp
of date.

Table Name: Dbsql_MailingListIndex
Can you give me a short description of what this table is used for?

This table is used for storing the mailing list information : ID,name of
mailing list, date created and date modified.

Table Name: Dbsql_Relationships
What are the possible values of the [oselect] and [fn] field and what do
they mean?

oselect => { type => 'ENUM', values => ['0', '1']},
fn => { type => 'CHAR', size => 30},

[oselect] can get value 1 (true) or 0 (false). If it is true, a dropdown from
primary table will be create on the form of related table. [fn] is for form
name which will be displayed on the form above. These two items can be found
on the Admin panel >> Relationships >> Relationship form.