86 lines
1.6 KiB
Modula-2
86 lines
1.6 KiB
Modula-2
# Database definition file for 'glinks_Links_Files' table
|
|
# Last updated: Tue Sep 4 09:35:44 2007
|
|
# Created by GT::SQL::Table $Revision: 1.255 $
|
|
{
|
|
'ai' => 'ID',
|
|
'cols' => {
|
|
'ID' => {
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '1',
|
|
'regex' => '^\d+$',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'ForeignColName' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '2',
|
|
'size' => '50',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'ForeignColKey' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '3',
|
|
'size' => '50',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'File_Name' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '4',
|
|
'size' => '255',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'File_Directory' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '5',
|
|
'size' => '255',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'File_MimeType' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '6',
|
|
'size' => '50',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'File_Size' => {
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '7',
|
|
'regex' => '^\d+$',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'File_URL' => {
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '8',
|
|
'size' => '255',
|
|
'type' => 'VARCHAR'
|
|
}
|
|
},
|
|
'fk' => {},
|
|
'fk_tables' => [],
|
|
'index' => {
|
|
'fk_lookup' => [
|
|
'ForeignColName',
|
|
'ForeignColKey'
|
|
]
|
|
},
|
|
'pk' => [
|
|
'ID'
|
|
],
|
|
'subclass' => {},
|
|
'unique' => {}
|
|
};
|
|
|
|
# vim:syn=perl:ts=4:noet
|