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