# Database definition file for 'glinks_EmailTemplates' table
# Last updated: Fri Aug 31 13:04:08 2007
# Created by GT::SQL::Table $Revision: 1.255 $
{
	'ai' => '',
	'cols' => {
		'Name' => {
			'form_size' => '20',
			'form_type' => 'TEXT',
			'not_null' => '1',
			'pos' => '1',
			'regex' => '\S',
			'size' => '50',
			'type' => 'CHAR'
		},
		'MsgFrom' => {
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'not_null' => '1',
			'pos' => '2',
			'regex' => '\A(?:\S+\@[a-zA-Z0-9][a-zA-Z0-9-]*(?:\.[a-zA-Z0-9][a-zA-Z0-9-]*)+)\Z',
			'type' => 'TEXT'
		},
		'MsgFromName' => {
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'not_null' => '1',
			'pos' => '3',
			'type' => 'TEXT'
		},
		'Subject' => {
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'not_null' => '1',
			'pos' => '4',
			'type' => 'TEXT'
		},
		'Message' => {
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'not_null' => '1',
			'pos' => '5',
			'type' => 'MEDIUMTEXT'
		},
		'MessageFormat' => {
			'default' => 'text',
			'form_type' => 'SELECT',
			'not_null' => '1',
			'pos' => '6',
			'type' => 'ENUM',
			'values' => [
				'text',
				'html'
			]
		},
		'LinkTemplate' => {
			'form_size' => '30',
			'form_type' => 'TEXTAREA',
			'pos' => '7',
			'type' => 'MEDIUMTEXT'
		}
	},
	'fk' => {},
	'fk_tables' => [],
	'index' => {},
	'pk' => [
		'Name'
	],
	'subclass' => {},
	'unique' => {}
};

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