CREATE TABLE `field` (
`tinyint` tinyint(4) NOT NULL auto_increment,
`SMALLINT` smallint(6) default NULL,
`MEDIUMINT` mediumint(9) default NULL,
`INTEGER` int(11) default NULL,
`BIGINT` bigint(20) default NULL,
`FLOAT` float(9,3) default NULL,
`DOUBLE` double(15,3) default NULL,
`DECIMAL` decimal(11,0) default NULL,
`DATE` date default NULL,
`DATETIME` datetime default NULL,
`TIMESTAMP` timestamp(14) NOT NULL,
`TIME` time default NULL,
`YEAR` year(4) default NULL,
`CHAR` char(1) default NULL,
`VARCHAR` char(1) default NULL,
`TINYBLOB` tinyblob,
`BLOB` blob,
`MEDIUMBLOB` mediumblob,
`LONGBLOB` longblob,
`TINYTEXT` tinytext,
`TEXT` text,
`MEDIUMTEXT` mediumtext,
`LONGTEXT` longtext,
`ENUM` enum('12','af','vb') default 'vb',
`SET` set('gh','bc','vc','ww') default 'ww',
PRIMARY KEY (`tinyint`),
UNIQUE KEY `tinyint` (`tinyint`)
) TYPE=MyISAM
