Commit | Line | Data |
0494e672 |
1 | CREATE TABLE ad ( |
d8fdd087 |
2 | id varchar(32) NOT NULL DEFAULT '', |
3 | vendor_id varchar(32) NOT NULL DEFAULT '', |
4 | realtor_id int(11) NOT NULL DEFAULT 0, |
5 | location_id int(11) NOT NULL DEFAULT 0, |
6 | origin_id int(11) NOT NULL DEFAULT 0, |
7 | style_id int(11) NOT NULL DEFAULT 0, |
8 | style varchar(42) NOT NULL DEFAULT '', |
9 | media_code_id int(11) NOT NULL DEFAULT 0, |
10 | priority int(11) NOT NULL DEFAULT 1, |
0494e672 |
11 | listing_date date, |
d8fdd087 |
12 | price int(11) NOT NULL DEFAULT 0, |
13 | rooms int(11) NOT NULL DEFAULT 0, |
14 | bedrooms int(11) NOT NULL DEFAULT 0, |
15 | fullbaths int(11) NOT NULL DEFAULT 0, |
16 | halfbaths int(11) NOT NULL DEFAULT 0, |
17 | amenities varchar(255) NOT NULL DEFAULT '', |
18 | lotsize int(11) NOT NULL DEFAULT 0, |
19 | openhouse tinyint(4) NOT NULL DEFAULT 0, |
20 | street varchar(255) NOT NULL DEFAULT '', |
21 | no_units tinyint NOT NULL DEFAULT 1, |
0494e672 |
22 | ad_text text, |
23 | original_ad_text text, |
d8fdd087 |
24 | photo varchar(255) NOT NULL DEFAULT '', |
25 | thumbnail varchar(255) NOT NULL DEFAULT '', |
0494e672 |
26 | PRIMARY KEY (id), |
0494e672 |
27 | KEY vendor_id_idx (vendor_id), |
0494e672 |
28 | KEY amenities_idx (amenities), |
d8fdd087 |
29 | KEY listing_date_idx (listing_date) |
0494e672 |
30 | ); |
0494e672 |
31 | |
0494e672 |
32 | CREATE TABLE ad_to_amenity ( |
0494e672 |
33 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
34 | ad_id char(32) NOT NULL DEFAULT '', |
35 | amenity_id int(11) NOT NULL DEFAULT 0, |
0494e672 |
36 | PRIMARY KEY (id), |
0494e672 |
37 | KEY ad_id_idx (ad_id) |
0494e672 |
38 | ); |
0494e672 |
39 | |
0494e672 |
40 | CREATE TABLE amenity ( |
41 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
42 | amenity varchar(42) NOT NULL DEFAULT '', |
43 | abbrev varchar(4) NOT NULL DEFAULT '', |
0494e672 |
44 | PRIMARY KEY (id) |
0494e672 |
45 | ); |
0494e672 |
46 | |
0494e672 |
47 | CREATE TABLE email ( |
48 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
49 | realtor_id int(11) NOT NULL DEFAULT 0, |
50 | property_id int(11) NOT NULL DEFAULT 0, |
51 | firstname varchar(42) NOT NULL DEFAULT '', |
52 | lastname varchar(42) NOT NULL DEFAULT '', |
53 | phone varchar(10) NOT NULL DEFAULT '', |
54 | timeframe varchar(255) NOT NULL DEFAULT '', |
55 | schedule_appt tinyint(4) NOT NULL DEFAULT 0, |
0494e672 |
56 | date_sent timestamp(14), |
57 | comments text, |
58 | PRIMARY KEY (id) |
0494e672 |
59 | ); |
0494e672 |
60 | |
0494e672 |
61 | CREATE TABLE history ( |
62 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
63 | type varchar(42) NOT NULL DEFAULT '', |
64 | value varchar(255) NOT NULL DEFAULT '', |
0494e672 |
65 | ts timestamp(14), |
66 | PRIMARY KEY (id) |
0494e672 |
67 | ); |
0494e672 |
68 | |
0494e672 |
69 | CREATE TABLE location ( |
70 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
71 | abbrev varchar(4) NOT NULL DEFAULT '', |
72 | city varchar(42) NOT NULL DEFAULT '', |
73 | state char(2) NOT NULL DEFAULT 'MA', |
74 | fullstate varchar(42) NOT NULL DEFAULT 'Massachusetts', |
0494e672 |
75 | PRIMARY KEY (id), |
0494e672 |
76 | KEY city_idx (city), |
77 | KEY abbrev_idx (abbrev), |
78 | KEY state_idx (state) |
79 | ); |
0494e672 |
80 | |
d8fdd087 |
81 | CREATE TABLE mediacode ( |
82 | media_code int(11) NOT NULL DEFAULT 700, |
83 | classification varchar(42) NOT NULL DEFAULT '', |
0494e672 |
84 | PRIMARY KEY (media_code) |
0494e672 |
85 | ); |
0494e672 |
86 | |
0494e672 |
87 | CREATE TABLE origin ( |
88 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
89 | origin varchar(24) NOT NULL DEFAULT '', |
90 | display varchar(42) NOT NULL DEFAULT '', |
0494e672 |
91 | PRIMARY KEY (id) |
0494e672 |
92 | ); |
0494e672 |
93 | |
0494e672 |
94 | CREATE TABLE realtor ( |
95 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
96 | vendor_id varchar(6) NOT NULL DEFAULT '', |
97 | name varchar(255) NOT NULL DEFAULT '', |
98 | phone varchar(24) NOT NULL DEFAULT '', |
99 | location_id int(11) NOT NULL DEFAULT 0, |
100 | email varchar(255) NOT NULL DEFAULT '', |
101 | url varchar(255) NOT NULL DEFAULT '', |
0494e672 |
102 | tagline text, |
d8fdd087 |
103 | logo_url varchar(255) NOT NULL DEFAULT '', |
104 | upsell tinyint(4) DEFAULT 0, |
0494e672 |
105 | start_date date, |
106 | end_date date, |
107 | PRIMARY KEY (id), |
0494e672 |
108 | KEY name_idx (name), |
109 | KEY phone_idx (phone) |
110 | ); |
0494e672 |
111 | |
0494e672 |
112 | CREATE TABLE style ( |
113 | id int(11) NOT NULL auto_increment, |
d8fdd087 |
114 | style varchar(42) NOT NULL DEFAULT '', |
115 | abbrev varchar(42) NOT NULL DEFAULT '', |
0494e672 |
116 | PRIMARY KEY (id), |
0494e672 |
117 | KEY style_idx (style) |
118 | ); |