# Database definition file for 'glinks_Links' table
# Last updated: Sat Dec 12 15:28:06 2009
# Created by GT::SQL::Table $Revision: 1.251 $
{
	'ai' => 'ID',
	'cols' => {
		'ID' => {
			'form_display' => 'ID',
			'form_size' => '10',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '1',
			'regex' => '^\d+$',
			'type' => 'INT',
			'unsigned' => '1'
		},
		'Title' => {
			'form_display' => 'Title',
			'form_size' => '20',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '2',
			'size' => '100',
			'type' => 'CHAR',
			'weight' => '3'
		},
		'URL' => {
			'default' => 'http://',
			'form_display' => 'URL',
			'form_size' => '20',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '3',
			'regex' => '^\w+:',
			'size' => '255',
			'type' => 'CHAR',
			'weight' => '1'
		},
		'LinkOwner' => {
			'default' => 'admin',
			'form_display' => 'LinkOwner',
			'form_size' => '20',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '4',
			'size' => '50',
			'type' => 'CHAR'
		},
		'Add_Date' => {
			'form_display' => 'Add Date',
			'form_size' => '20',
			'form_type' => 'DATE',
			'not_null' => '1',
			'pos' => '5',
			'type' => 'DATE'
		},
		'Mod_Date' => {
			'form_display' => 'Mod Date',
			'form_size' => '20',
			'form_type' => 'DATE',
			'not_null' => '1',
			'pos' => '6',
			'type' => 'DATE'
		},
		'Description' => {
			'form_display' => 'Description',
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'pos' => '7',
			'type' => 'TEXT',
			'weight' => '1'
		},
		'Contact_Name' => {
			'form_display' => 'Contact Name',
			'form_size' => '20',
			'form_type' => 'TEXT',
			'pos' => '8',
			'size' => '255',
			'type' => 'CHAR'
		},
		'Contact_Email' => {
			'form_display' => 'Contact Email',
			'form_size' => '20',
			'form_type' => 'TEXT',
			'pos' => '9',
			'size' => '255',
			'type' => 'CHAR'
		},
		'Hits' => {
			'default' => '0',
			'form_display' => 'Hits',
			'form_size' => '10',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '10',
			'regex' => '^\d+$',
			'type' => 'INT'
		},
		'isNew' => {
			'default' => 'No',
			'form_display' => 'isNew',
			'form_type' => 'SELECT',
			'not_null' => '1',
			'pos' => '11',
			'type' => 'ENUM',
			'values' => [
				'No',
				'Yes'
			]
		},
		'isChanged' => {
			'default' => 'No',
			'form_display' => 'isChanged',
			'form_type' => 'SELECT',
			'not_null' => '1',
			'pos' => '12',
			'type' => 'ENUM',
			'values' => [
				'No',
				'Yes'
			]
		},
		'isPopular' => {
			'default' => 'No',
			'form_display' => 'isPopular',
			'form_type' => 'SELECT',
			'not_null' => '1',
			'pos' => '13',
			'type' => 'ENUM',
			'values' => [
				'No',
				'Yes'
			]
		},
		'isValidated' => {
			'default' => 'Yes',
			'form_display' => 'isValidated',
			'form_type' => 'SELECT',
			'not_null' => '1',
			'pos' => '14',
			'type' => 'ENUM',
			'values' => [
				'No',
				'Yes'
			]
		},
		'Rating' => {
			'default' => '0',
			'form_display' => 'Rating',
			'not_null' => '1',
			'pos' => '15',
			'precision' => '4',
			'regex' => '^(?:10(?:\.0*)?|\d(?:\.\d*)?)$',
			'scale' => '2',
			'type' => 'DECIMAL'
		},
		'Votes' => {
			'default' => '0',
			'form_display' => 'Votes',
			'form_size' => '10',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '16',
			'regex' => '^\d+$',
			'type' => 'SMALLINT',
			'unsigned' => '1'
		},
		'Status' => {
			'default' => '0',
			'form_display' => 'Status',
			'form_size' => '10',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '17',
			'regex' => '^-?\d+$',
			'type' => 'SMALLINT'
		},
		'Date_Checked' => {
			'form_display' => 'Date Checked',
			'form_size' => '20',
			'form_type' => 'DATE',
			'pos' => '18',
			'type' => 'DATETIME'
		},
		'Timestmp' => {
			'form_display' => 'Timestamp',
			'form_size' => '20',
			'form_type' => 'DATE',
			'pos' => '19',
			'time_check' => '1',
			'type' => 'TIMESTAMP'
		},
		'ExpiryDate' => {
			'default' => '2147483647',
			'form_display' => 'Expiry Date',
			'form_size' => '35',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '20',
			'type' => 'INT'
		},
		'ExpiryCounted' => {
			'default' => '0',
			'form_display' => 'Expiry optimization',
			'form_size' => '10',
			'form_type' => 'hidden',
			'not_null' => '1',
			'pos' => '21',
			'type' => 'TINYINT'
		},
		'ExpiryNotify' => {
			'default' => '0',
			'form_display' => 'Expiry notification sent',
			'form_size' => '10',
			'form_type' => 'hidden',
			'not_null' => '1',
			'pos' => '22',
			'type' => 'TINYINT'
		}
	},
	'fk' => {
		'glinks_Users' => {
			'LinkOwner' => 'Username'
		}
	},
	'fk_tables' => [
		'glinks_Changes',
		'glinks_Reviews',
		'glinks_CatLinks',
		'glinks_Verify',
		'glinks_Payments',
		'glinks_Bookmark_Links'
	],
	'index' => {
		'expcntndx' => [
			'ExpiryCounted',
			'ExpiryDate'
		],
		'expiryndx' => [
			'ExpiryDate',
			'ExpiryNotify'
		],
		'newndx' => [
			'isNew'
		],
		'popndx' => [
			'isPopular'
		],
		'stndx' => [
			'Status'
		],
		'urlndx' => [
			'URL'
		],
		'userndx' => [
			'LinkOwner'
		],
		'valexpndx' => [
			'isValidated',
			'ExpiryDate'
		]
	},
	'pk' => [
		'ID'
	],
	'subclass' => {
		'html' => {
			'glinks_Links' => 'Links::HTML::Links'
		},
		'table' => {
			'glinks_Links' => 'Links::Table::Links'
		}
	},
	'unique' => {}
};

# vim:syn=perl:ts=4:noet