sNCCkqpE

1CREATE TABLE IF NOT EXISTS `msgboard` (
2  `id` smallint(6) NOT NULL auto_increment,
3  `senderid` tinyint(4) NOT NULL default '0',
4  `channel` smallint(6) NOT NULL default '1',
5  `received` datetime default NULL,
6  `msgtext` mediumtext,
7  PRIMARY KEY  (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
9
10CREATE TABLE IF NOT EXISTS `players` (
11  `id` mediumint(8) unsigned NOT NULL auto_increment,
12  `lname` text NOT NULL,
13  `fname` text NOT NULL,
14  `email1` text NOT NULL,
15  PRIMARY KEY  (`id`)
16) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
17
18CREATE TABLE IF NOT EXISTS `temp_one` (
19  `id` mediumint(9) NOT NULL default '0',
20  `lname` text,
21  `fname` text,
22  `status` smallint(6) NOT NULL default '0',
23  `numguests` smallint(6) NOT NULL default '0',
24  `lastmodified` datetime NOT NULL default '0000-00-00 00:00:00',
25  `notes` varchar(255) NOT NULL default '',
26  PRIMARY KEY  (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=latin1;
28
29CREATE TABLE IF NOT EXISTS `tracker` (
30  `id` smallint(6) NOT NULL auto_increment,
31  `num` smallint(6) NOT NULL default '0',
32  `modified` datetime default NULL,
33  PRIMARY KEY  (`id`)
34) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
35
36CREATE TABLE IF NOT EXISTS `variables` (
37  `id` mediumint(9) NOT NULL default '0',
38  `playerid` mediumint(9) NOT NULL default '0',
39  `default_status` tinyint(4) NOT NULL default '0',
40  `serialvar` longtext NOT NULL,
41  PRIMARY KEY  (`id`,`playerid`)
42) ENGINE=MyISAM DEFAULT CHARSET=latin1;