· 6 years ago · Oct 07, 2019, 07:54 PM
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;