2RmxEPA5

1CREATE TABLE IF NOT EXISTS `categories` (
2  `id` int(10) NOT NULL AUTO_INCREMENT,
3  `name` varchar(255) NOT NULL,
4  PRIMARY KEY (`id`)
5) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
6
7INSERT INTO `categories` (`id`, `name`) VALUES
8(2, 'Loft & wall insulation'),
9(4, 'Gas & Electricity'),
10(6, 'Boilers'),
11(8, 'Appliances'),
12(13, 'Microgeneration'),
13(14, 'Windows'),
14(15, 'Solar Panels');
15
16CREATE TABLE IF NOT EXISTS `companies` (
17  `id` int(10) NOT NULL AUTO_INCREMENT,
18  `company_name` varchar(255) NOT NULL,
19  `business` varchar(255) NOT NULL,
20  `contact_name` varchar(255) NOT NULL,
21  `address` varchar(255) NOT NULL,
22  `address_line_2` varchar(255) NOT NULL,
23  `city` varchar(255) NOT NULL,
24  `country` varchar(255) NOT NULL,
25  `email` varchar(255) NOT NULL,
26  `url` varchar(255) NOT NULL,
27  `durl` varchar(255) NOT NULL,
28  `description` text NOT NULL,
29  `postal` varchar(255) NOT NULL,
30  `lng` varchar(255) NOT NULL,
31  `lat` varchar(255) NOT NULL,
32  `telephone` varchar(255) NOT NULL,
33  `categories` varchar(255) NOT NULL,
34  `photo` varchar(255) NOT NULL,
35  `pid` varchar(255) NOT NULL,
36  PRIMARY KEY (`id`)
37) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
38
39
40
41CREATE TABLE IF NOT EXISTS `countries` (
42  `ccode` varchar(2) NOT NULL DEFAULT '',
43  `country` varchar(200) NOT NULL DEFAULT '',
44  PRIMARY KEY (`ccode`)
45) ENGINE=MyISAM DEFAULT CHARSET=utf8;
46
47-
48
49CREATE TABLE IF NOT EXISTS `relations` (
50  `id` int(10) NOT NULL AUTO_INCREMENT,
51  `company_id` int(10) NOT NULL,
52  `category_id` int(10) NOT NULL,
53  PRIMARY KEY (`id`)
54) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;