PK7RrVSw

1CREATE TABLE IF NOT EXISTS wp_solar_system (
2                id mediumint(9) NOT NULL AUTO_INCREMENT KEY,
3                size decimal(10,3) NOT NULL,
4                panel_size int NOT NULL,
5                panel_num int NOT NULL,
6                equipment_cost varchar(7) NOT NULL,
7                recs int NOT NULL,
8                rebate varchar(7) NOT NULL,
9                contract_price varchar(7) NOT NULL,
10                inverter varchar(10) NOT NULL,
11                extra varchar(1) NOT NULL,
12                description varchar(255) NOT NULL,
13                brand varchar(110) NOT NULL,
14                bill_min decimal(10,3) NOT NULL,
15                bill_max decimal(10,3) NOT NULL
16            ) ENGINE=INNODB;
17
18
19             CREATE TABLE IF NOT EXISTS wp_solar_company (
20                id mediumint(9)  NOT NULL AUTO_INCREMENT KEY, 
21                name varchar(60) NOT NULL,
22                states varchar(20) NOT NULL,
23                url varchar(128),
24                phone varchar(128),
25                qld boolean not null default 0,
26                nsw boolean not null default 0,
27                act boolean not null default 0,
28                vic boolean not null default 0,
29                sa boolean not null default 0,
30                wa boolean not null default 0,
31                nt boolean not null default 0,
32                tas boolean not null default 0
33            ) ENGINE=INNODB;
34   
35            CREATE TABLE IF NOT EXISTS wp_solar_rel(
36               id mediumint(9) NOT NULL AUTO_INCREMENT KEY,
37                system mediumint(9) NOT NULL ,
38                company mediumint(9) NOT NULL , 
39
40                CONSTRAINT fk_system FOREIGN KEY (system)
41                REFERENCES  wp_solar_system(id),
42                CONSTRAINT fk_company FOREIGN KEY (company)
43                REFERENCES wp_solar_company(id)
44            ) ENGINE=INNODB;