· 9 years ago · Jun 19, 2017, 08:02 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
5/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
6/*!40101 SET NAMES utf8 */;
7
8
9DROP TABLE IF EXISTS `address`;
10CREATE TABLE `address` (
11 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
12 `address_1` varchar(45) DEFAULT NULL,
13 `address_2` varchar(45) DEFAULT NULL,
14 `locality` varchar(45) DEFAULT NULL,
15 `area` varchar(45) DEFAULT NULL,
16 `city` varchar(45) NOT NULL,
17 `state` varchar(45) NOT NULL,
18 `country` varchar(45) NOT NULL,
19 `directions` varchar(45) DEFAULT NULL,
20 `map_data` varchar(45) DEFAULT NULL COMMENT 'gps coordinates to the location entered by the user via the map in the UI',
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24INSERT INTO `address` VALUES(1, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
25INSERT INTO `address` VALUES(2, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
26INSERT INTO `address` VALUES(3, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
27INSERT INTO `address` VALUES(4, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
28INSERT INTO `address` VALUES(5, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
29INSERT INTO `address` VALUES(6, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
30INSERT INTO `address` VALUES(7, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
31INSERT INTO `address` VALUES(8, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
32INSERT INTO `address` VALUES(9, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
33INSERT INTO `address` VALUES(10, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
34INSERT INTO `address` VALUES(11, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
35INSERT INTO `address` VALUES(12, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
36INSERT INTO `address` VALUES(13, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
37INSERT INTO `address` VALUES(14, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
38INSERT INTO `address` VALUES(15, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
39INSERT INTO `address` VALUES(16, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
40INSERT INTO `address` VALUES(17, '23', 'aaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', 'sdgsdgs', 'sdgsdgsdg');
41INSERT INTO `address` VALUES(18, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
42INSERT INTO `address` VALUES(19, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
43INSERT INTO `address` VALUES(20, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
44INSERT INTO `address` VALUES(21, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
45INSERT INTO `address` VALUES(22, NULL, NULL, NULL, 'asd', 'asdf', 'asdf', 'United States', NULL, NULL);
46INSERT INTO `address` VALUES(23, NULL, NULL, NULL, 'asd', 'sdf', 'sdf', 'United States', NULL, NULL);
47INSERT INTO `address` VALUES(24, NULL, NULL, NULL, 'asd', 'sdf', 'sdf', 'United States', NULL, NULL);
48INSERT INTO `address` VALUES(25, NULL, NULL, 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
49INSERT INTO `address` VALUES(26, NULL, NULL, 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
50INSERT INTO `address` VALUES(27, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
51INSERT INTO `address` VALUES(28, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
52INSERT INTO `address` VALUES(29, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
53INSERT INTO `address` VALUES(30, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
54INSERT INTO `address` VALUES(31, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
55INSERT INTO `address` VALUES(32, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
56INSERT INTO `address` VALUES(33, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
57INSERT INTO `address` VALUES(34, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
58INSERT INTO `address` VALUES(35, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
59INSERT INTO `address` VALUES(36, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
60INSERT INTO `address` VALUES(37, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
61INSERT INTO `address` VALUES(38, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
62INSERT INTO `address` VALUES(39, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
63INSERT INTO `address` VALUES(40, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
64INSERT INTO `address` VALUES(41, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
65INSERT INTO `address` VALUES(42, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
66INSERT INTO `address` VALUES(43, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
67INSERT INTO `address` VALUES(44, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
68INSERT INTO `address` VALUES(45, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
69INSERT INTO `address` VALUES(46, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
70INSERT INTO `address` VALUES(47, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
71INSERT INTO `address` VALUES(48, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
72INSERT INTO `address` VALUES(49, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
73INSERT INTO `address` VALUES(50, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
74INSERT INTO `address` VALUES(51, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
75INSERT INTO `address` VALUES(52, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'sgsdg', 'sdgsdgs', 'sdgsdgsdg');
76INSERT INTO `address` VALUES(53, NULL, NULL, '22gfsdg ', 'dffdg', 'sgsg', 'sgsdgf', 'United States', NULL, NULL);
77INSERT INTO `address` VALUES(54, NULL, NULL, 'dffdg', 'sgsg', 'sgs', 'sgsdgds', 'United States', NULL, NULL);
78INSERT INTO `address` VALUES(55, NULL, NULL, 'dffdg', 'sgsg', 'sgs', 'sgsdgds', 'United States', NULL, NULL);
79INSERT INTO `address` VALUES(56, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
80INSERT INTO `address` VALUES(57, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
81INSERT INTO `address` VALUES(58, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
82INSERT INTO `address` VALUES(59, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
83INSERT INTO `address` VALUES(60, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
84INSERT INTO `address` VALUES(61, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
85INSERT INTO `address` VALUES(62, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
86INSERT INTO `address` VALUES(63, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
87INSERT INTO `address` VALUES(64, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
88INSERT INTO `address` VALUES(65, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
89INSERT INTO `address` VALUES(66, '34', 'vbd', 'daft', 'sgsg', 'sgsdg', 'sdgsg', 'Bahrain', 'sdfd', NULL);
90INSERT INTO `address` VALUES(67, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
91INSERT INTO `address` VALUES(68, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
92INSERT INTO `address` VALUES(69, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
93INSERT INTO `address` VALUES(70, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
94INSERT INTO `address` VALUES(71, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
95INSERT INTO `address` VALUES(72, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
96INSERT INTO `address` VALUES(73, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
97INSERT INTO `address` VALUES(74, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
98INSERT INTO `address` VALUES(75, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
99INSERT INTO `address` VALUES(76, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
100INSERT INTO `address` VALUES(77, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
101INSERT INTO `address` VALUES(78, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
102INSERT INTO `address` VALUES(79, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
103INSERT INTO `address` VALUES(80, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
104
105DROP TABLE IF EXISTS `discussion`;
106CREATE TABLE `discussion` (
107 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
108 `space_id` int(10) unsigned NOT NULL,
109 `response_to` int(11) NOT NULL,
110 `type` varchar(45) NOT NULL COMMENT 'Type of message of type:\nPrices, Features, t&c, Other',
111 `message` varchar(45) NOT NULL,
112 `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the message read?',
113 `created_by` int(10) unsigned NOT NULL,
114 `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
115 `last_updated_by` int(10) unsigned DEFAULT NULL,
116 `last_updated_on` varchar(45) DEFAULT NULL,
117 `is_flagged` tinyint(4) NOT NULL DEFAULT '0',
118 PRIMARY KEY (`id`),
119 KEY `fk_discussion_space1` (`space_id`),
120 KEY `fk_discussion_user1` (`created_by`),
121 KEY `fk_discussion_user2` (`last_updated_by`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123
124INSERT INTO `discussion` VALUES(19, 1, 0, '1111', 'vzvzv', 0, 1, '2010-09-29 14:43:35', 1, NULL, 1);
125INSERT INTO `discussion` VALUES(20, 1, 0, '1111', 'gtyu', 0, 1, '2010-09-29 15:14:21', 1, NULL, 0);
126
127DROP TABLE IF EXISTS `flagged_post`;
128CREATE TABLE `flagged_post` (
129 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
130 `user_id` int(10) unsigned NOT NULL,
131 `discussion_id` int(10) unsigned DEFAULT NULL,
132 `space_id` int(10) unsigned DEFAULT NULL,
133 `message_id` tinyint(2) NOT NULL,
134 `type` varchar(45) NOT NULL,
135 `description` varchar(45) DEFAULT NULL,
136 `is_reviewed` tinyint(1) DEFAULT '0' COMMENT 'Has the admin reviewed the flagged post',
137 PRIMARY KEY (`id`),
138 KEY `fk_space_flag_user1` (`user_id`),
139 KEY `fk_space_flag_space1` (`space_id`),
140 KEY `fk_flagged_post_discussion1` (`discussion_id`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores either flagged spaces or discussion messages';
142
143INSERT INTO `flagged_post` VALUES(2, 1, NULL, NULL, 0, 'other', NULL, 0);
144INSERT INTO `flagged_post` VALUES(3, 1, NULL, 1, 0, 'other', 'khjl', 0);
145INSERT INTO `flagged_post` VALUES(4, 1, NULL, 1, 0, 'notshared', 'khjl', 0);
146INSERT INTO `flagged_post` VALUES(5, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
147INSERT INTO `flagged_post` VALUES(6, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
148INSERT INTO `flagged_post` VALUES(7, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
149INSERT INTO `flagged_post` VALUES(8, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
150INSERT INTO `flagged_post` VALUES(9, 1, NULL, 3, 0, 'notaccur', 'hello\r\n', 0);
151INSERT INTO `flagged_post` VALUES(10, 1, NULL, 1, 0, 'copyright', 'adf', 0);
152INSERT INTO `flagged_post` VALUES(11, 1, NULL, 1, 0, 'copyright', 'adf', 0);
153INSERT INTO `flagged_post` VALUES(12, 1, NULL, 16, 0, 'other', 'qwerty\r\n', 0);
154INSERT INTO `flagged_post` VALUES(13, 1, NULL, 17, 0, 'spam', 'this is a spam\r\n', 0);
155INSERT INTO `flagged_post` VALUES(14, 1, NULL, 3, 0, 'copyright', 'qwertyuiop', 0);
156INSERT INTO `flagged_post` VALUES(15, 1, NULL, 19, 0, 'copyright', NULL, 0);
157INSERT INTO `flagged_post` VALUES(16, 1, NULL, 1, 0, 'other', NULL, 0);
158INSERT INTO `flagged_post` VALUES(17, 1, NULL, 19, 0, 'notshared', NULL, 0);
159INSERT INTO `flagged_post` VALUES(18, 1, 19, NULL, 0, 'notshared', NULL, 0);
160INSERT INTO `flagged_post` VALUES(19, 1, 19, NULL, 0, 'notaccur', 'qasdf\r\n', 0);
161INSERT INTO `flagged_post` VALUES(20, 1, NULL, 19, 0, 'copyright', NULL, 0);
162INSERT INTO `flagged_post` VALUES(21, 1, NULL, NULL, 26, 'offensive', NULL, 0);
163INSERT INTO `flagged_post` VALUES(22, 1, NULL, NULL, 26, 'notaccur', 'hey this is not accurate', 0);
164INSERT INTO `flagged_post` VALUES(23, 1, NULL, NULL, 28, 'notaccur', NULL, 0);
165INSERT INTO `flagged_post` VALUES(24, 1, NULL, NULL, 28, 'notshared', NULL, 0);
166INSERT INTO `flagged_post` VALUES(25, 1, NULL, NULL, 27, 'notaccur', NULL, 0);
167INSERT INTO `flagged_post` VALUES(26, 1, NULL, NULL, 29, 'notshared', 'not shared', 0);
168INSERT INTO `flagged_post` VALUES(27, 1, NULL, 10, 0, 'notshared', NULL, 0);
169INSERT INTO `flagged_post` VALUES(30, 1, 19, NULL, 0, 'notshared', 'dsf', 0);
170
171DROP TABLE IF EXISTS `invitation`;
172CREATE TABLE `invitation` (
173 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
174 `user_id` int(10) unsigned NOT NULL,
175 `email` varchar(255) NOT NULL COMMENT 'friend''s email address. This field is not unique because he can be invited by any number of friends. Having multiple invitations to the same email id increases the probability for a registration.\n',
176 `sent_on` timestamp NULL DEFAULT NULL,
177 `source` varchar(45) DEFAULT NULL COMMENT 'either gmail, yahoo, aol etc',
178 `accepted_on` timestamp NULL DEFAULT NULL,
179 PRIMARY KEY (`id`),
180 KEY `fk_invitation_user1` (`user_id`)
181) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182
183
184DROP TABLE IF EXISTS `Message`;
185CREATE TABLE `Message` (
186 `id` int(10) NOT NULL AUTO_INCREMENT,
187 `from_user` int(10) NOT NULL,
188 `to_user` int(10) NOT NULL,
189 `message_body` varchar(250) NOT NULL,
190 `is_read` tinyint(1) NOT NULL,
191 `is_flagged` tinyint(2) NOT NULL,
192 `message_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
193 `message_subject` varchar(45) NOT NULL,
194 PRIMARY KEY (`id`),
195 KEY `fk_from_user` (`from_user`),
196 KEY `fk_to_user` (`to_user`)
197) ENGINE=MyISAM DEFAULT CHARSET=utf8;
198
199INSERT INTO `Message` VALUES(1, 1, 0, 'hello buddies', 0, 0, '2010-09-30 10:49:47', 'hey hello how r u ???');
200INSERT INTO `Message` VALUES(3, 23, 42, 'sdfgrte', 0, 0, '2010-10-01 11:13:56', 'dsfsdfsdf');
201INSERT INTO `Message` VALUES(4, 25, 42, 'sasdfaf', 0, 0, '2010-10-01 11:13:56', 'sdffd');
202INSERT INTO `Message` VALUES(26, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
203INSERT INTO `Message` VALUES(27, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
204INSERT INTO `Message` VALUES(28, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
205INSERT INTO `Message` VALUES(29, 42, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
206INSERT INTO `Message` VALUES(46, 1, 42, 'sdgdsgdsg', 0, 0, '2010-10-05 11:08:15', 'sgdfsd');
207INSERT INTO `Message` VALUES(47, 1, 23, 'how r u ??', 0, 0, '2010-10-05 11:23:54', 'hai');
208INSERT INTO `Message` VALUES(48, 1, 23, 'how r u ????', 0, 0, '2010-10-05 11:24:32', 'hello');
209
210DROP TABLE IF EXISTS `request`;
211CREATE TABLE `request` (
212 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
213 `user_id` int(10) unsigned NOT NULL,
214 `address_id` int(10) unsigned DEFAULT NULL COMMENT 'If null, then requester just wants a space anywhere and is not particular about location',
215 `required_desks` smallint(5) unsigned NOT NULL,
216 `min_budget` decimal(7,2) DEFAULT '0.00',
217 `max_budget` decimal(7,2) DEFAULT '99999.99',
218 `is_public` tinyint(1) DEFAULT NULL COMMENT 'can it be indexed by google?',
219 `is_searchable` tinyint(1) DEFAULT NULL COMMENT 'Can it appear on searches made on opencommune',
220 `created_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
221 `last_updated_on` timestamp NULL DEFAULT NULL,
222 `is_flagged` tinyint(4) NOT NULL,
223 PRIMARY KEY (`id`),
224 KEY `fk_request_user1` (`user_id`),
225 KEY `fk_request_address1` (`address_id`)
226) ENGINE=InnoDB DEFAULT CHARSET=utf8;
227
228INSERT INTO `request` VALUES(3, 1, 3, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:22', NULL, 0);
229INSERT INTO `request` VALUES(4, 1, 4, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:23', NULL, 0);
230INSERT INTO `request` VALUES(5, 1, 5, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:24', NULL, 0);
231INSERT INTO `request` VALUES(6, 1, 6, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:24', NULL, 0);
232INSERT INTO `request` VALUES(7, 1, 7, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:25', NULL, 0);
233INSERT INTO `request` VALUES(8, 1, 8, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:25', NULL, 0);
234INSERT INTO `request` VALUES(9, 1, 9, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:26', NULL, 0);
235INSERT INTO `request` VALUES(10, 1, 22, 12, 65.00, 7652.00, NULL, NULL, '2010-09-22 12:31:05', NULL, 0);
236INSERT INTO `request` VALUES(11, 1, 23, 1, 65.00, 300.00, NULL, NULL, '2010-09-22 12:32:07', NULL, 0);
237INSERT INTO `request` VALUES(12, 1, 24, 1, 65.00, 300.00, NULL, NULL, '2010-09-22 12:32:24', NULL, 1);
238INSERT INTO `request` VALUES(13, 1, 25, 33, 65.00, 8045.00, NULL, NULL, '2010-09-22 12:34:18', NULL, 0);
239INSERT INTO `request` VALUES(14, 1, 26, 33, 65.00, 8045.00, NULL, NULL, '2010-09-22 12:34:56', NULL, 0);
240INSERT INTO `request` VALUES(15, 1, 27, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:36:43', NULL, 0);
241INSERT INTO `request` VALUES(16, 1, 28, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:39:58', NULL, 0);
242INSERT INTO `request` VALUES(17, 1, 29, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:40:23', NULL, 0);
243INSERT INTO `request` VALUES(18, 1, 30, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:42:05', NULL, 0);
244INSERT INTO `request` VALUES(19, 1, 31, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:42:53', NULL, 0);
245INSERT INTO `request` VALUES(20, 1, 32, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:43:36', NULL, 0);
246INSERT INTO `request` VALUES(21, 1, 33, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:44:21', NULL, 0);
247INSERT INTO `request` VALUES(22, 1, 34, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:44:46', NULL, 0);
248INSERT INTO `request` VALUES(23, 1, 35, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:45:34', NULL, 0);
249INSERT INTO `request` VALUES(24, 1, 36, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:45:55', NULL, 0);
250INSERT INTO `request` VALUES(25, 1, 37, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:06', NULL, 0);
251INSERT INTO `request` VALUES(26, 1, 38, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:35', NULL, 0);
252INSERT INTO `request` VALUES(27, 1, 39, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:58', NULL, 0);
253INSERT INTO `request` VALUES(28, 1, 40, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:53:19', NULL, 0);
254INSERT INTO `request` VALUES(29, 1, 41, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:54:06', NULL, 0);
255INSERT INTO `request` VALUES(30, 1, 42, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:54:46', NULL, 0);
256INSERT INTO `request` VALUES(31, 1, 43, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:55:15', NULL, 0);
257INSERT INTO `request` VALUES(32, 1, 44, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:56:21', NULL, 0);
258INSERT INTO `request` VALUES(33, 1, 45, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:58:39', NULL, 0);
259INSERT INTO `request` VALUES(34, 1, 46, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:59:22', NULL, 0);
260INSERT INTO `request` VALUES(35, 1, 47, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:59:43', NULL, 0);
261INSERT INTO `request` VALUES(36, 1, 48, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:00:01', NULL, 0);
262INSERT INTO `request` VALUES(37, 1, 49, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:01:26', NULL, 0);
263INSERT INTO `request` VALUES(38, 1, 50, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:02:20', NULL, 0);
264INSERT INTO `request` VALUES(39, 1, 51, 12, 65.00, 1865.00, NULL, NULL, '2010-09-22 13:59:19', NULL, 0);
265INSERT INTO `request` VALUES(40, 1, 53, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:19:37', NULL, 0);
266INSERT INTO `request` VALUES(41, 1, 54, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:21:04', NULL, 0);
267INSERT INTO `request` VALUES(42, 1, 55, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:21:19', NULL, 0);
268INSERT INTO `request` VALUES(43, 1, 67, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:11:46', NULL, 0);
269INSERT INTO `request` VALUES(44, 1, 68, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:14:15', NULL, 0);
270INSERT INTO `request` VALUES(45, 1, 69, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:14:42', NULL, 0);
271INSERT INTO `request` VALUES(46, 1, 70, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:15:34', NULL, 0);
272INSERT INTO `request` VALUES(47, 1, 71, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:15:55', NULL, 0);
273INSERT INTO `request` VALUES(48, 1, 72, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:16:11', NULL, 0);
274INSERT INTO `request` VALUES(49, 1, 73, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:16:40', NULL, 0);
275INSERT INTO `request` VALUES(50, 1, 74, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:17:08', NULL, 0);
276INSERT INTO `request` VALUES(51, 1, 75, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:18:15', NULL, 0);
277INSERT INTO `request` VALUES(52, 1, 76, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:18:35', NULL, 0);
278
279DROP TABLE IF EXISTS `space`;
280CREATE TABLE `space` (
281 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
282 `user_id` int(10) unsigned NOT NULL,
283 `desks_count` smallint(6) NOT NULL,
284 `address_id` int(10) unsigned NOT NULL,
285 `has_internet` tinyint(1) DEFAULT NULL,
286 `has_nightsecurity` tinyint(1) DEFAULT NULL,
287 `has_aircondition` tinyint(1) DEFAULT NULL,
288 `has_kitchen` tinyint(1) DEFAULT NULL,
289 `has_meetingroom` tinyint(1) DEFAULT NULL,
290 `allows_extended_hours` tinyint(1) DEFAULT NULL,
291 `rent` varchar(45) DEFAULT NULL,
292 `deposit` varchar(45) DEFAULT NULL,
293 `available_on` varchar(45) NOT NULL,
294 `contract_period` varchar(45) NOT NULL,
295 `use_registered_addr` tinyint(1) NOT NULL COMMENT 'Can your coworkers use your space as their registered office address?',
296 `has_lease_agreement` tinyint(1) DEFAULT NULL,
297 `terms` varchar(1000) DEFAULT NULL,
298 `contact_email` varchar(45) NOT NULL,
299 `contact_phone` varchar(45) DEFAULT NULL,
300 `summary` varchar(45) NOT NULL,
301 `detailed_information` text,
302 `is_public` tinyint(1) DEFAULT '0' COMMENT 'can it be indexed by google?',
303 `is_searchable` tinyint(1) DEFAULT '1' COMMENT 'Can it appear on searches made on opencommune',
304 `created_on` timestamp NULL DEFAULT NULL,
305 `last_updated_on` timestamp NULL DEFAULT NULL,
306 `contact_mobile` varchar(45) DEFAULT NULL,
307 `is_flagged` tinyint(10) NOT NULL,
308 PRIMARY KEY (`id`),
309 KEY `fk_space_User` (`user_id`),
310 KEY `fk_space_address1` (`address_id`)
311) ENGINE=InnoDB DEFAULT CHARSET=utf8;
312
313INSERT INTO `space` VALUES(1, 1, 33, 10, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:24', NULL, NULL, 1);
314INSERT INTO `space` VALUES(2, 1, 33, 11, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:26', NULL, NULL, 1);
315INSERT INTO `space` VALUES(3, 1, 33, 12, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:27', NULL, NULL, 1);
316INSERT INTO `space` VALUES(4, 1, 33, 13, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:27', NULL, NULL, 1);
317INSERT INTO `space` VALUES(5, 1, 33, 14, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:28', NULL, NULL, 1);
318INSERT INTO `space` VALUES(6, 1, 33, 15, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:28', NULL, NULL, 1);
319INSERT INTO `space` VALUES(7, 1, 33, 16, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:28', NULL, NULL, 1);
320INSERT INTO `space` VALUES(8, 1, 33, 17, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:29', NULL, NULL, 0);
321INSERT INTO `space` VALUES(9, 1, 33, 18, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 11:47:29', NULL, NULL, 0);
322INSERT INTO `space` VALUES(10, 1, 33, 52, 0, 0, 1, 0, 0, 0, '254', '3555', 'Immediate', '0.5 months', 1, 1, 'gfgfdsg', 'abc@abc.com', NULL, 'jhfddjfjlh', 'jlkidsjldshfl', 0, 0, '2010-09-22 14:00:47', NULL, NULL, 1);
323INSERT INTO `space` VALUES(11, 1, 23, 56, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:37:32', NULL, NULL, 0);
324INSERT INTO `space` VALUES(12, 1, 23, 57, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:39:12', NULL, NULL, 0);
325INSERT INTO `space` VALUES(13, 1, 23, 58, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:39:26', NULL, NULL, 1);
326INSERT INTO `space` VALUES(14, 1, 23, 59, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:39:58', NULL, NULL, 1);
327INSERT INTO `space` VALUES(15, 1, 23, 60, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:40:24', NULL, NULL, 1);
328INSERT INTO `space` VALUES(16, 1, 23, 61, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:41:37', NULL, NULL, 1);
329INSERT INTO `space` VALUES(17, 1, 23, 62, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:42:17', NULL, NULL, 1);
330INSERT INTO `space` VALUES(18, 1, 23, 63, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:44:37', NULL, NULL, 0);
331INSERT INTO `space` VALUES(19, 1, 23, 64, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:46:01', NULL, NULL, 1);
332INSERT INTO `space` VALUES(20, 1, 23, 65, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Immediate', '4.5 months', 1, NULL, NULL, 'abc@abc.com', NULL, 'sd', 'sadffsw', 0, 0, '2010-09-22 15:46:10', NULL, NULL, 0);
333INSERT INTO `space` VALUES(21, 1, 23, 66, 0, 0, 1, 0, 0, 0, '234', '2222', 'Immediate', '4 months', 1, 1, NULL, 'abc@abc.com', NULL, 'sdfsadf', 'sfgdsg', 0, 0, '2010-09-22 15:50:51', NULL, NULL, 0);
334
335DROP TABLE IF EXISTS `space_interest`;
336CREATE TABLE `space_interest` (
337 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
338 `user_id` int(10) unsigned NOT NULL,
339 `space_id` int(10) unsigned NOT NULL,
340 `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
341 PRIMARY KEY (`id`),
342 UNIQUE KEY `uniq_user_space` (`user_id`,`space_id`),
343 KEY `fk_space_interest_user1` (`user_id`),
344 KEY `fk_space_interest_space1` (`space_id`)
345) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Capture the interest in the space expressed by co workers';
346
347
348DROP TABLE IF EXISTS `space_photo`;
349CREATE TABLE `space_photo` (
350 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
351 `space_id` int(10) unsigned NOT NULL,
352 `url` varchar(45) DEFAULT NULL COMMENT 'Flickr/picasa/ hosted url',
353 `comment` varchar(45) DEFAULT NULL COMMENT 'Description of the photo',
354 `view_count` varchar(45) DEFAULT NULL COMMENT 'Number of times the photo has been viewed',
355 PRIMARY KEY (`id`),
356 KEY `fk_space_photo_space1` (`space_id`)
357) ENGINE=InnoDB DEFAULT CHARSET=utf8;
358
359
360DROP TABLE IF EXISTS `user`;
361CREATE TABLE `user` (
362 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
363 `first_name` varchar(45) NOT NULL,
364 `last_name` varchar(45) NOT NULL,
365 `email` varchar(45) NOT NULL,
366 `password` varchar(45) NOT NULL,
367 `is_email_confirmed` tinyint(1) NOT NULL DEFAULT '0',
368 `last_login_at` datetime DEFAULT NULL,
369 `photo_path` varchar(45) DEFAULT NULL,
370 `city` varchar(45) NOT NULL,
371 `company` varchar(45) NOT NULL,
372 `website` varchar(45) DEFAULT NULL,
373 `primary_service` varchar(45) DEFAULT NULL,
374 `profile_name` varchar(45) DEFAULT NULL COMMENT 'Will be used to create the vanity \nprofile url. Ex: domain.com/foobar\n',
375 `email_token` varchar(100) NOT NULL,
376 PRIMARY KEY (`id`),
377 UNIQUE KEY `email` (`email`),
378 UNIQUE KEY `email_2` (`email`)
379) ENGINE=InnoDB DEFAULT CHARSET=utf8;
380
381INSERT INTO `user` VALUES(1, 'dani', '', 'dani@gmail.com', 'dani', 1, NULL, NULL, '', '', NULL, NULL, NULL, '23423423');
382INSERT INTO `user` VALUES(21, 'karthick', 'muthu', 'mkartic@gmail.com', 'karthick', 1, NULL, NULL, 'chennai', 'Outsmart', NULL, NULL, 'karthick', '23423424');
383INSERT INTO `user` VALUES(23, '23name', '', 'karthi@gmail.com', 'karthi', 1, NULL, NULL, '', '', NULL, NULL, NULL, '123');
384INSERT INTO `user` VALUES(25, '25name', '', 'dheeraj@gmail.com', 'dheeraj', 1, NULL, NULL, '', '', NULL, NULL, NULL, '12345');
385INSERT INTO `user` VALUES(36, '', '', 'a@a.com', 'a', 1, NULL, NULL, '', '', NULL, NULL, NULL, '9009');
386INSERT INTO `user` VALUES(37, '', '', 'dani@g.com', 'dani', 1, NULL, NULL, '', '', NULL, NULL, NULL, '678');
387INSERT INTO `user` VALUES(40, '', '', 'c@c.com', 'c', 0, NULL, NULL, '', '', NULL, NULL, NULL, '4f79e4e535e8c29e3c726dfc19cfda4e1172771c');
388INSERT INTO `user` VALUES(41, '41name', '', 'd@d.com', 'd', 0, NULL, NULL, '', '', NULL, NULL, NULL, '38ea9ae8ae28421f0a8bc667b37177e6e2fbc453');
389INSERT INTO `user` VALUES(42, 'karthi', '', 'e@e.com', 'e', 1, NULL, NULL, '', '', NULL, NULL, NULL, '63f1573d8b3be0852ac3865590ad8c57194fcb41');
390INSERT INTO `user` VALUES(43, '', '', 'f@f.com', 'f', 0, NULL, NULL, '', '', NULL, NULL, NULL, 'b2647110721699f245785a64297dc9fe0791cf09');
391INSERT INTO `user` VALUES(44, '', '', 's@s.com', 's', 1, NULL, NULL, '', '', NULL, NULL, NULL, '233814e53500a089b21483bf034d7682190b419f');
392INSERT INTO `user` VALUES(45, '', '', 'q@q.com', 'q', 0, NULL, NULL, '', '', NULL, NULL, NULL, 'dbccfe365a729ec3591943af84a97205464fa949');
393INSERT INTO `user` VALUES(46, '', '', 'g@g.com', 'g', 0, NULL, NULL, '', '', NULL, NULL, NULL, '295cb336848b2f49355ead0a1370528a1cb24176');
394INSERT INTO `user` VALUES(47, '', '', 'm@m.com', 'm', 1, NULL, NULL, '', '', NULL, NULL, NULL, '6bd2a9f611b127c7b9cdbdc00789342cf4c19989');
395
396
397ALTER TABLE `discussion`
398 ADD CONSTRAINT `fk_discussion_space1` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
399 ADD CONSTRAINT `fk_discussion_user1` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
400 ADD CONSTRAINT `fk_discussion_user2` FOREIGN KEY (`last_updated_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
401
402ALTER TABLE `flagged_post`
403 ADD CONSTRAINT `fk_flagged_post_discussion1` FOREIGN KEY (`discussion_id`) REFERENCES `discussion` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
404 ADD CONSTRAINT `fk_space_flag_space1` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
405 ADD CONSTRAINT `fk_space_flag_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
406
407ALTER TABLE `invitation`
408 ADD CONSTRAINT `fk_invitation_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
409
410ALTER TABLE `request`
411 ADD CONSTRAINT `fk_request_address1` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
412 ADD CONSTRAINT `fk_request_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
413
414ALTER TABLE `space`
415 ADD CONSTRAINT `fk_space_address1` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
416 ADD CONSTRAINT `fk_space_User` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
417
418ALTER TABLE `space_interest`
419 ADD CONSTRAINT `fk_space_interest_space1` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
420 ADD CONSTRAINT `fk_space_interest_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
421
422ALTER TABLE `space_photo`
423 ADD CONSTRAINT `fk_space_photo_space1` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;