CREATE TABLE `contact` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL default '',
`email` varchar(250) NOT NULL default '',
`tel_no` varchar(250) NOT NULL default '',
`message` varchar(250) NOT NULL default '',
`last_modified` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
CREATE TABLE `events` (
`id` int(250) NOT NULL auto_increment,
`start_date` date NOT NULL default '0000-00-00',
`end_date` date NOT NULL default '0000-00-00',
`start_time` time NOT NULL default '00:00:00',
`end_time` time NOT NULL default '00:00:00',
`title` varchar(250) NOT NULL default '',
`location` varchar(250) NOT NULL default '',
`teaser` text NOT NULL,
`content` text NOT NULL,
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`active` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
CREATE TABLE `modules` (
`id` int(13) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`active` int(13) NOT NULL default '0',
`sort_order` int(13) NOT NULL default '0',
`header_title` varchar(250) NOT NULL default '',
`header_text` text NOT NULL,
`footer_help` text NOT NULL,
`orderby` varchar(250) NOT NULL default '',
`print_order` varchar(250) NOT NULL default '',
`col1` varchar(250) NOT NULL default '',
`col2` varchar(250) NOT NULL default '',
`col1_type` varchar(250) NOT NULL default '',
`col2_type` varchar(250) NOT NULL default '',
`col1_th` varchar(250) NOT NULL default '',
`col2_th` varchar(250) NOT NULL default '',
`add` int(1) NOT NULL default '0',
`delete` int(1) NOT NULL default '0',
`edit` int(1) NOT NULL default '0',
`edit_sort` int(1) NOT NULL default '0',
`print` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `modules` (`id`, `title`, `active`, `sort_order`, `header_title`, `header_text`, `footer_help`, `orderby`, `print_order`, `col1`, `col2`, `col1_type`, `col2_type`, `col1_th`, `col2_th`, `add`, `delete`, `edit`, `edit_sort`, `print`) VALUES (1, 'news', 1, 3, 'News', 'You can add an unlimited number of news articles to your website. Articles older than one month will automatically be archived both in the administration section and on your website.', '<h4>What do the buttons do?</h4>\r\n<ul>\r\n<li><span class=''blue''>Add record</span> - Allows you to create a new page</li>\r\n<li><span class=''blue''>Print List</span> - Opens a browser window containing a printer friendly list of the news articles </li>\r\n<li><span class=''blue''>Edit(Pencil icon)</span> - Click on the pencil icon next to the news article you would like to edit</li>\r\n<li><span class=''blue''>Delete(Cross icon)</span> - Click on the cross icon next to the news you would like to delete</li>\r\n</ul>', 'ORDER BY date DESC', 'date', 'date', 'title', 'date', 'text', 'Date', 'Title', 1, 1, 1, 0, 1),
(2, 'events', 1, 4, 'Events', 'You can add an unlimited number of events to your site. Past events will automatically be archived both in the admin section and on the website.', '<h4>What do the buttons do?</h4>\r\n<ul>\r\n<li><span class=''blue''>Add record</span> - Allows you to create a new event</li>\r\n<li><span class=''blue''>Print List</span> - Opens a browser window containing a printer friendly list of the events</li>\r\n<li><span class=''blue''>Edit (Pencil icon)</span> - Click on the pencil icon next to the event you would like to edit</li>\r\n<li><span class=''blue''>Delete(Cross icon)</span> - Click on the cross icon next to the event you would like to delete</li>\r\n</ul>', 'ORDER BY start_date ASC', 'start_date', 'start_date', 'title', 'date', 'text', 'Date', 'Title', 1, 1, 1, 0, 1),
(3, 'pages', 1, 5, 'Custom Pages', 'You can add as many custom pages to your website as you would like. Using our simple "Word style" custom page editor you can add a new page to your site within minutes.', '<h4>What do the buttons do?</h4>\r\n<ul>\r\n<li><span class=''blue''>Add record </span> - Allows you to create a new page</li>\r\n<li><span class=''blue''>Edit Order</span> - Allows you to sort the order in which the pages will appear on your website.</li>\r\n<li><span class=''blue''>Print List</span> - Opens a browser window containing a printer friendly list of the pages</li>\r\n<li><span class=''blue''>Edit (Pencil icon)</span> - Click on the pencil icon next to the page you would like to edit</li>\r\n<li>Delete(Cross icon)</span> - Click on the cross icon next to the page you would like to delete</li>\r\n</ul>', 'ORDER BY sort_order ASC', 'sort_order', 'sort_order', 'navtitle', 'text', 'text', 'Page Order', 'Title', 1, 1, 1, 1, 1),
(4, 'media', 1, 6, 'My Media', 'Use this module to upload media to your website. This includes Word Docs, Excel Spreadsheets, Pdf Files, Images, Audio Files, Movie Clips and much more.', '<ul>\r\n<li>1. Select the media type from the drop down</li>\r\n<li>2. Enter a name for the media in the <span class=''green''>Title</span></li>\r\n<li>3. Click on the <span class=''green''>Choose</span> button and select the file you want to upload</li>\r\n<li>4.Click the <span class=''green''>Update </span>button and wait for your media to be uploaded. You will be taken back to media when the upload is complete</li>\r\n</ul>', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0);
CREATE TABLE `news` (
`id` int(250) NOT NULL auto_increment,
`start_date` date NOT NULL default '0000-00-00',
`end_date` date NOT NULL default '0000-00-00',
`date` date NOT NULL default '0000-00-00',
`title` varchar(250) NOT NULL default '',
`author` varchar(250) NOT NULL default '',
`teaser` text NOT NULL,
`content` text NOT NULL,
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`active` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
CREATE TABLE `pages` (
`id` int(13) NOT NULL auto_increment,
`navtitle` varchar(250) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`sort_order` int(13) NOT NULL default '0',
`active` int(13) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`last_modified` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`content` text NOT NULL,
`pagetype` varchar(250) NOT NULL default '0',
`meta_title` varchar(250) NOT NULL default '',
`meta_keywords` varchar(250) NOT NULL default '',
`meta_desc` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
CREATE TABLE `site_config` (
`id` int(12) NOT NULL default '0',
`site_name` varchar(250) NOT NULL default '',
`site_email` varchar(250) NOT NULL default '',
`site_url` varchar(250) NOT NULL default '',
`contact` int(13) NOT NULL default '0',
`terms` int(13) NOT NULL default '0',
`privacy` int(13) NOT NULL default '0',
`accessibility` int(13) NOT NULL default '0',
`home` int(13) NOT NULL default '0',
`sitemap` int(13) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;