HbgD44p1

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