ZsHmh6Gk

1CREATE TABLE IF NOT EXISTS `attendance` (
2  `id` smallint(5) unsigned NOT NULL default '0',
3  `dateid` mediumint(9) NOT NULL default '0',
4  `status` smallint(5) unsigned NOT NULL default '0',
5  `numguests` smallint(5) unsigned NOT NULL default '0',
6  `lastmodified` datetime NOT NULL default '0000-00-00 00:00:00',
7  `notes` text NOT NULL,
8  PRIMARY KEY  (`id`,`dateid`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11-- --------------------------------------------------------
12
13--
14-- Table structure for table `gym`
15--
16
17CREATE TABLE IF NOT EXISTS `gym` (
18  `id` mediumint(8) unsigned NOT NULL auto_increment,
19  `gymdate` date default NULL,
20  `start` time default NULL,
21  `length` smallint(5) unsigned NOT NULL default '0',
22  `expiration` date default NULL,
23  `status` smallint(5) unsigned NOT NULL default '0',
24  `type` smallint(5) unsigned NOT NULL default '0',
25  `facility` smallint(5) unsigned NOT NULL default '0',
26  `title` varchar(100) default NULL,
27  `description` varchar(1024) default NULL,
28  `serialvar` longtext NOT NULL,
29  PRIMARY KEY  (`id`)
30) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;