· 8 years ago · May 01, 2018, 01:48 PM
1DROP TABLE IF EXISTS `data`;
2CREATE TABLE `data` (
3 `filename` char(100) NOT NULL,
4 `datatype` mediumint(10) unsigned NOT NULL,
5 `entry` bigint(11) unsigned NOT NULL,
6 `text` char(100) NOT NULL,
7 `ver` tinyint(3) unsigned NOT NULL DEFAULT '1',
8 PRIMARY KEY (`filename`,`datatype`,`entry`,`ver`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;