167 lines
3.4 KiB
Modula-2
167 lines
3.4 KiB
Modula-2
# Database definition file for 'glinks_Reviews' table
|
|
# Last updated: Sun May 17 15:36:17 2009
|
|
# Created by GT::SQL::Table $Revision: 1.255 $
|
|
{
|
|
'ai' => 'ReviewID',
|
|
'cols' => {
|
|
'ReviewID' => {
|
|
'form_display' => 'Review ID',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '1',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Review_LinkID' => {
|
|
'form_display' => 'Review Link ID',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '2',
|
|
'regex' => '^\d+$',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Review_Owner' => {
|
|
'form_display' => 'Review Owner',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '3',
|
|
'size' => '50',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Review_Rating' => {
|
|
'default' => '0',
|
|
'form_display' => 'Review Rating',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '4',
|
|
'regex' => '^\d+$',
|
|
'type' => 'SMALLINT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Review_Date' => {
|
|
'form_display' => 'Review Date',
|
|
'form_size' => '20',
|
|
'form_type' => 'DATE',
|
|
'not_null' => '1',
|
|
'pos' => '5',
|
|
'type' => 'DATETIME'
|
|
},
|
|
'Review_ModifyDate' => {
|
|
'form_display' => 'Review Modify Date',
|
|
'form_size' => '20',
|
|
'form_type' => 'DATE',
|
|
'not_null' => '1',
|
|
'pos' => '6',
|
|
'type' => 'DATETIME'
|
|
},
|
|
'Review_Subject' => {
|
|
'form_display' => 'Review Subject',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '7',
|
|
'size' => '100',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Review_Contents' => {
|
|
'form_display' => 'Review Contents',
|
|
'form_size' => '30',
|
|
'form_type' => 'TEXTAREA',
|
|
'not_null' => '1',
|
|
'pos' => '8',
|
|
'type' => 'TEXT'
|
|
},
|
|
'Review_ByLine' => {
|
|
'form_display' => 'Review By Line',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '9',
|
|
'size' => '50',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Review_WasHelpful' => {
|
|
'form_display' => 'Review Was Helpful',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '10',
|
|
'regex' => '^\d+$',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Review_WasNotHelpful' => {
|
|
'form_display' => 'Review Was Not Helpful',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '11',
|
|
'regex' => '^\d+$',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Review_Validated' => {
|
|
'default' => 'No',
|
|
'form_display' => 'Review Validated',
|
|
'form_type' => 'SELECT',
|
|
'not_null' => '1',
|
|
'pos' => '12',
|
|
'type' => 'ENUM',
|
|
'values' => [
|
|
'No',
|
|
'Yes'
|
|
]
|
|
},
|
|
'Review_GuestName' => {
|
|
'form_display' => 'Review Guest Name',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '13',
|
|
'size' => '75',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Review_GuestEmail' => {
|
|
'form_display' => 'Review Guest Email',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '14',
|
|
'regex' => '^(?:(?:.+\@.+\..+)|\s*)$',
|
|
'size' => '75',
|
|
'type' => 'CHAR'
|
|
}
|
|
},
|
|
'fk' => {
|
|
'glinks_Links' => {
|
|
'Review_LinkID' => 'ID'
|
|
},
|
|
'glinks_Users' => {
|
|
'Review_Owner' => 'Username'
|
|
}
|
|
},
|
|
'fk_tables' => [],
|
|
'index' => {
|
|
'rdatendx' => [
|
|
'Review_Date'
|
|
],
|
|
'rlinkndx' => [
|
|
'Review_LinkID'
|
|
],
|
|
'rownerndx' => [
|
|
'Review_Owner'
|
|
]
|
|
},
|
|
'pk' => [
|
|
'ReviewID'
|
|
],
|
|
'subclass' => {
|
|
'table' => {
|
|
'glinks_Reviews' => 'Links::Table::Reviews'
|
|
}
|
|
},
|
|
'unique' => {}
|
|
};
|
|
|
|
# vim:syn=perl:ts=4:noet
|