173 lines
3.3 KiB
Modula-2
173 lines
3.3 KiB
Modula-2
# Database definition file for 'glinks_Users' table
|
|
# Last updated: Tue Aug 26 09:27:10 2008
|
|
# Created by GT::SQL::Table $Revision: 1.255 $
|
|
{
|
|
'ai' => '',
|
|
'cols' => {
|
|
'Username' => {
|
|
'form_display' => 'Username',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '1',
|
|
'size' => '50',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Password' => {
|
|
'binary' => '1',
|
|
'form_display' => 'Password',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '2',
|
|
'size' => '25',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Email' => {
|
|
'form_display' => 'Email',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '3',
|
|
'regex' => '^(?:.+\@.+\..+|\s*)$',
|
|
'size' => '75',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Name' => {
|
|
'form_display' => 'Name',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '4',
|
|
'size' => '75',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Validation' => {
|
|
'form_display' => 'Validation Code',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'pos' => '5',
|
|
'size' => '20',
|
|
'type' => 'CHAR'
|
|
},
|
|
'Status' => {
|
|
'default' => 'Registered',
|
|
'file_max_size' => '',
|
|
'file_save_in' => '',
|
|
'file_save_scheme' => 'HASHED',
|
|
'file_save_url' => '',
|
|
'form_display' => 'Status',
|
|
'form_names' => [
|
|
'Not Validated',
|
|
'Registered',
|
|
'Administrator',
|
|
'Editor'
|
|
],
|
|
'form_size' => '0',
|
|
'form_type' => 'SELECT',
|
|
'form_values' => [
|
|
'Not Validated',
|
|
'Registered',
|
|
'Administrator',
|
|
'Editor'
|
|
],
|
|
'not_null' => '1',
|
|
'pos' => '6',
|
|
'regex' => '',
|
|
'type' => 'ENUM',
|
|
'values' => [
|
|
'Not Validated',
|
|
'Registered',
|
|
'Administrator',
|
|
'Editor'
|
|
]
|
|
},
|
|
'ReceiveMail' => {
|
|
'default' => 'Yes',
|
|
'form_display' => 'Receive Mailings',
|
|
'form_type' => 'SELECT',
|
|
'not_null' => '1',
|
|
'pos' => '7',
|
|
'type' => 'ENUM',
|
|
'values' => [
|
|
'No',
|
|
'Yes'
|
|
]
|
|
},
|
|
'SortField' => {
|
|
'default' => 'Title',
|
|
'form_display' => 'Bookmark sort field',
|
|
'form_size' => '20',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '8',
|
|
'regex' => '^[\s\w]+$',
|
|
'size' => '255',
|
|
'type' => 'VARCHAR'
|
|
},
|
|
'SortOrd' => {
|
|
'default' => 'ASC',
|
|
'form_display' => 'Bookmark sort order',
|
|
'form_type' => 'SELECT',
|
|
'not_null' => '1',
|
|
'pos' => '9',
|
|
'type' => 'ENUM',
|
|
'values' => [
|
|
'ASC',
|
|
'DESC'
|
|
]
|
|
},
|
|
'PerPage' => {
|
|
'default' => '15',
|
|
'form_display' => 'Bookmarks per page',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '10',
|
|
'type' => 'INT',
|
|
'unsigned' => '1'
|
|
},
|
|
'Grouping' => {
|
|
'default' => '0',
|
|
'form_display' => 'Bookmark grouping',
|
|
'form_size' => '10',
|
|
'form_type' => 'TEXT',
|
|
'not_null' => '1',
|
|
'pos' => '11',
|
|
'type' => 'TINYINT',
|
|
'unsigned' => '1'
|
|
}
|
|
},
|
|
'fk' => {},
|
|
'fk_tables' => [
|
|
'glinks_Links',
|
|
'glinks_Changes',
|
|
'glinks_Reviews',
|
|
'glinks_Editors',
|
|
'glinks_Sessions',
|
|
'glinks_Bookmark_Folders',
|
|
'glinks_Bookmark_Links',
|
|
'glinks_NewsletterSubscription'
|
|
],
|
|
'index' => {
|
|
'emailndx' => [
|
|
'Email'
|
|
]
|
|
},
|
|
'pk' => [
|
|
'Username'
|
|
],
|
|
'search_driver' => 'NONINDEXED',
|
|
'subclass' => {
|
|
'html' => {
|
|
'glinks_Users' => 'Links::HTML::Users'
|
|
},
|
|
'relation' => {},
|
|
'table' => {
|
|
'glinks_Users' => 'Links::Table::Users'
|
|
}
|
|
},
|
|
'unique' => {}
|
|
};
|
|
|
|
# vim:syn=perl:ts=4:noet
|