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,
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,
23 original_ad_text text,
24 photo varchar(255) NOT NULL DEFAULT '',
25 thumbnail varchar(255) NOT NULL DEFAULT '',
27 KEY vendor_id_idx (vendor_id),
28 KEY amenities_idx (amenities),
29 KEY listing_date_idx (listing_date)
32 CREATE TABLE ad_to_amenity (
33 id int(11) NOT NULL auto_increment,
34 ad_id char(32) NOT NULL DEFAULT '',
35 amenity_id int(11) NOT NULL DEFAULT 0,
40 CREATE TABLE amenity (
41 id int(11) NOT NULL auto_increment,
42 amenity varchar(42) NOT NULL DEFAULT '',
43 abbrev varchar(4) NOT NULL DEFAULT '',
48 id int(11) NOT NULL auto_increment,
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,
56 date_sent timestamp(14),
61 CREATE TABLE history (
62 id int(11) NOT NULL auto_increment,
63 type varchar(42) NOT NULL DEFAULT '',
64 value varchar(255) NOT NULL DEFAULT '',
69 CREATE TABLE location (
70 id int(11) NOT NULL auto_increment,
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',
77 KEY abbrev_idx (abbrev),
81 CREATE TABLE mediacode (
82 media_code int(11) NOT NULL DEFAULT 700,
83 classification varchar(42) NOT NULL DEFAULT '',
84 PRIMARY KEY (media_code)
88 id int(11) NOT NULL auto_increment,
89 origin varchar(24) NOT NULL DEFAULT '',
90 display varchar(42) NOT NULL DEFAULT '',
94 CREATE TABLE realtor (
95 id int(11) NOT NULL auto_increment,
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 '',
103 logo_url varchar(255) NOT NULL DEFAULT '',
104 upsell tinyint(4) DEFAULT 0,
109 KEY phone_idx (phone)
113 id int(11) NOT NULL auto_increment,
114 style varchar(42) NOT NULL DEFAULT '',
115 abbrev varchar(42) NOT NULL DEFAULT '',
117 KEY style_idx (style)