· 6 years ago · Oct 07, 2019, 07:58 PM
1CREATE TABLE IF NOT EXISTS `gym` (
2 `id` mediumint(8) unsigned NOT NULL auto_increment,
3 `gymdate` date default NULL,
4 `start` time default NULL,
5 `length` smallint(5) unsigned NOT NULL default '0',
6 `expiration` date default NULL,
7 `status` smallint(5) unsigned NOT NULL default '0',
8 `type` smallint(5) unsigned NOT NULL default '0',
9 `facility` smallint(5) unsigned NOT NULL default '0',
10 `title` varchar(100) default NULL,
11 `description` varchar(1024) default NULL,
12 `serialvar` longtext NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;