8g4ed0WT

1CREATE TABLE `calendar` (
2  `calendar_id` mediumint(8) unsigned NOT NULL auto_increment,
3  `when` date default NULL,
4  `year` mediumint(8) unsigned default NULL,
5  `season` varchar(50) collate latin1_general_ci NOT NULL default '',
6  `week_ending_month` varchar(20) collate latin1_general_ci NOT NULL default '',
7  `week_ending_date` smallint(5) unsigned default NULL,
8  `state` varchar(30) collate latin1_general_ci NOT NULL default '',
9  `descrip` varchar(255) collate latin1_general_ci NOT NULL default '',
10  `title` varchar(255) collate latin1_general_ci NOT NULL default '',
11  `event_location` varchar(200) collate latin1_general_ci NOT NULL default '',
12  `event_dates` varchar(150) collate latin1_general_ci NOT NULL default '',
13  `event_pos` float NOT NULL default '0',
14  `location` varchar(50) collate latin1_general_ci NOT NULL default '',
15  `website_intro` varchar(100) collate latin1_general_ci NOT NULL default '',
16  `website_url` varchar(200) collate latin1_general_ci NOT NULL default '',
17  `website_name` varchar(100) collate latin1_general_ci NOT NULL default '',
18  `contact1_intro` varchar(50) collate latin1_general_ci NOT NULL default '',
19  `contact1_email` varchar(100) collate latin1_general_ci NOT NULL default '',
20  `contact1_name` varchar(50) collate latin1_general_ci NOT NULL default '',
21  `contact1_phone` varchar(50) collate latin1_general_ci NOT NULL default '',
22  `contact2_intro` varchar(50) collate latin1_general_ci NOT NULL default '',
23  `contact2_email` varchar(100) collate latin1_general_ci NOT NULL default '',
24  `contact2_name` varchar(50) collate latin1_general_ci NOT NULL default '',
25  `contact2_phone` varchar(50) collate latin1_general_ci NOT NULL default '',
26  `featured_event` tinyint(1) NOT NULL default '0',
27  `featured_image` varchar(255) collate latin1_general_ci NOT NULL default '',
28  `featured_square` varchar(255) collate latin1_general_ci NOT NULL default '',
29  `featured_pos` float NOT NULL default '0',
30  `hide` tinyint(1) NOT NULL default '0',
31  `archive` tinyint(1) NOT NULL default '0',
32  `notes` varchar(255) collate latin1_general_ci NOT NULL default '',
33  `featured_meet` tinyint(1) NOT NULL default '0',
34  `logo_image` varchar(255) collate latin1_general_ci NOT NULL default '',
35  PRIMARY KEY  (`calendar_id`)
36) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
37COLLATE=latin1_general_ci;
38
39/*Table structure for table `camps` */
40
41DROP TABLE IF EXISTS `camps`;
42
43CREATE TABLE `camps` (
44  `camp_id` mediumint(8) unsigned NOT NULL auto_increment,
45  `campname` varchar(255) collate latin1_general_ci NOT NULL default '',
46  `state` varchar(20) collate latin1_general_ci NOT NULL default '',
47  `year` mediumint(8) unsigned default NULL,
48  `month` varchar(100) collate latin1_general_ci NOT NULL default '',
49  `dates_sort` varchar(100) collate latin1_general_ci NOT NULL,
50  `startdate` date default NULL,
51  `enddate` date default NULL,
52  `title` varchar(100) collate latin1_general_ci NOT NULL default '',
53  `logo_image` varchar(255) collate latin1_general_ci NOT NULL default '',
54  `location` varchar(100) collate latin1_general_ci NOT NULL default '',
55  `dates_text` varchar(255) collate latin1_general_ci NOT NULL default '',
56  `description` mediumblob NOT NULL,
57  `cost` varchar(20) collate latin1_general_ci NOT NULL default '',
58  `ages` varchar(20) collate latin1_general_ci NOT NULL default '',
59  `website_intro` varchar(50) collate latin1_general_ci NOT NULL default '',
60  `website_url` varchar(255) collate latin1_general_ci NOT NULL default '',
61  `website_name` varchar(100) collate latin1_general_ci NOT NULL default '',
62  `contact1_intro` varchar(100) collate latin1_general_ci NOT NULL default '',
63  `contact1_name` varchar(100) collate latin1_general_ci NOT NULL default '',
64  `contact1_email` varchar(255) collate latin1_general_ci NOT NULL default '',
65  `contact2_intro` varchar(100) collate latin1_general_ci NOT NULL default '',
66  `contact2_name` varchar(100) collate latin1_general_ci NOT NULL default '',
67  `contact2_email` varchar(255) collate latin1_general_ci NOT NULL default '',
68  `featured_camp` tinyint(1) NOT NULL default '0',
69  `featured_pos` float NOT NULL default '0',
70  `featured_image` varchar(255) collate latin1_general_ci NOT NULL default '',
71  `featured_startdate` datetime NOT NULL default '0000-00-00 00:00:00',
72  `featured_enddate` datetime NOT NULL default '0000-00-00 00:00:00',
73  `hide` tinyint(1) NOT NULL default '0',
74  `archive` tinyint(1) NOT NULL default '0',
75  PRIMARY KEY  (`camp_id`)
76) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
77COLLATE=latin1_general_ci;