# 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
