API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
158
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JavaScript 33.34 KB | None | 0 0
raw download clone embed print report
  1. SET 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.  
  9. DROP TABLE IF EXISTS `address`;
  10. CREATE 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.  
  24. INSERT INTO `address` VALUES(1, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  25. INSERT INTO `address` VALUES(2, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  26. INSERT INTO `address` VALUES(3, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  27. INSERT INTO `address` VALUES(4, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  28. INSERT INTO `address` VALUES(5, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  29. INSERT INTO `address` VALUES(6, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  30. INSERT INTO `address` VALUES(7, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  31. INSERT INTO `address` VALUES(8, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  32. INSERT INTO `address` VALUES(9, NULL, NULL, 'vvccccc', 'jlkkjkj', 'kjkjkjkjk', 'yuyuyuy', 'United States', NULL, NULL);
  33. INSERT INTO `address` VALUES(10, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  34. INSERT INTO `address` VALUES(11, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  35. INSERT INTO `address` VALUES(12, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  36. INSERT INTO `address` VALUES(13, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  37. INSERT INTO `address` VALUES(14, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  38. INSERT INTO `address` VALUES(15, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  39. INSERT INTO `address` VALUES(16, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  40. INSERT INTO `address` VALUES(17, '23', 'aaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  41. INSERT INTO `address` VALUES(18, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', 'sdgsdgs', 'sdgsdgsdg');
  42. INSERT INTO `address` VALUES(19, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
  43. INSERT INTO `address` VALUES(20, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
  44. INSERT INTO `address` VALUES(21, NULL, NULL, 'dff', 'sgs', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
  45. INSERT INTO `address` VALUES(22, NULL, NULL, NULL, 'asd', 'asdf', 'asdf', 'United States', NULL, NULL);
  46. INSERT INTO `address` VALUES(23, NULL, NULL, NULL, 'asd', 'sdf', 'sdf', 'United States', NULL, NULL);
  47. INSERT INTO `address` VALUES(24, NULL, NULL, NULL, 'asd', 'sdf', 'sdf', 'United States', NULL, NULL);
  48. INSERT INTO `address` VALUES(25, NULL, NULL, 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
  49. INSERT INTO `address` VALUES(26, NULL, NULL, 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'United States', NULL, NULL);
  50. INSERT INTO `address` VALUES(27, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  51. INSERT INTO `address` VALUES(28, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  52. INSERT INTO `address` VALUES(29, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  53. INSERT INTO `address` VALUES(30, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  54. INSERT INTO `address` VALUES(31, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  55. INSERT INTO `address` VALUES(32, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  56. INSERT INTO `address` VALUES(33, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  57. INSERT INTO `address` VALUES(34, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  58. INSERT INTO `address` VALUES(35, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  59. INSERT INTO `address` VALUES(36, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  60. INSERT INTO `address` VALUES(37, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  61. INSERT INTO `address` VALUES(38, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  62. INSERT INTO `address` VALUES(39, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  63. INSERT INTO `address` VALUES(40, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  64. INSERT INTO `address` VALUES(41, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  65. INSERT INTO `address` VALUES(42, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  66. INSERT INTO `address` VALUES(43, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  67. INSERT INTO `address` VALUES(44, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  68. INSERT INTO `address` VALUES(45, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  69. INSERT INTO `address` VALUES(46, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  70. INSERT INTO `address` VALUES(47, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  71. INSERT INTO `address` VALUES(48, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  72. INSERT INTO `address` VALUES(49, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  73. INSERT INTO `address` VALUES(50, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  74. INSERT INTO `address` VALUES(51, NULL, NULL, 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'aaaaaaa', 'United States', NULL, NULL);
  75. INSERT INTO `address` VALUES(52, '23', '22gfsdg', 'dffdg', 'sgsg', 'sgsdgf', 'sgsdgds', 'sgsdg', 'sdgsdgs', 'sdgsdgsdg');
  76. INSERT INTO `address` VALUES(53, NULL, NULL, '22gfsdg   ', 'dffdg', 'sgsg', 'sgsdgf', 'United States', NULL, NULL);
  77. INSERT INTO `address` VALUES(54, NULL, NULL, 'dffdg', 'sgsg', 'sgs', 'sgsdgds', 'United States', NULL, NULL);
  78. INSERT INTO `address` VALUES(55, NULL, NULL, 'dffdg', 'sgsg', 'sgs', 'sgsdgds', 'United States', NULL, NULL);
  79. INSERT INTO `address` VALUES(56, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  80. INSERT INTO `address` VALUES(57, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  81. INSERT INTO `address` VALUES(58, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  82. INSERT INTO `address` VALUES(59, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  83. INSERT INTO `address` VALUES(60, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  84. INSERT INTO `address` VALUES(61, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  85. INSERT INTO `address` VALUES(62, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  86. INSERT INTO `address` VALUES(63, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  87. INSERT INTO `address` VALUES(64, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  88. INSERT INTO `address` VALUES(65, 'dsf', 'sfdf', NULL, NULL, 'dfdfd', 'fdfdf', 'Zambia', NULL, NULL);
  89. INSERT INTO `address` VALUES(66, '34', 'vbd', 'daft', 'sgsg', 'sgsdg', 'sdgsg', 'Bahrain', 'sdfd', NULL);
  90. INSERT INTO `address` VALUES(67, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  91. INSERT INTO `address` VALUES(68, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  92. INSERT INTO `address` VALUES(69, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  93. INSERT INTO `address` VALUES(70, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  94. INSERT INTO `address` VALUES(71, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  95. INSERT INTO `address` VALUES(72, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  96. INSERT INTO `address` VALUES(73, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  97. INSERT INTO `address` VALUES(74, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  98. INSERT INTO `address` VALUES(75, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  99. INSERT INTO `address` VALUES(76, NULL, NULL, 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  100. INSERT INTO `address` VALUES(77, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  101. INSERT INTO `address` VALUES(78, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  102. INSERT INTO `address` VALUES(79, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  103. INSERT INTO `address` VALUES(80, NULL, NULL, 'aaa', 'aaaa', 'aaaa', 'aaaa', 'United States', NULL, NULL);
  104.  
  105. DROP TABLE IF EXISTS `discussion`;
  106. CREATE 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.  
  124. INSERT INTO `discussion` VALUES(19, 1, 0, '1111', 'vzvzv', 0, 1, '2010-09-29 14:43:35', 1, NULL, 1);
  125. INSERT INTO `discussion` VALUES(20, 1, 0, '1111', 'gtyu', 0, 1, '2010-09-29 15:14:21', 1, NULL, 0);
  126.  
  127. DROP TABLE IF EXISTS `flagged_post`;
  128. CREATE 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.  
  143. INSERT INTO `flagged_post` VALUES(2, 1, NULL, NULL, 0, 'other', NULL, 0);
  144. INSERT INTO `flagged_post` VALUES(3, 1, NULL, 1, 0, 'other', 'khjl', 0);
  145. INSERT INTO `flagged_post` VALUES(4, 1, NULL, 1, 0, 'notshared', 'khjl', 0);
  146. INSERT INTO `flagged_post` VALUES(5, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
  147. INSERT INTO `flagged_post` VALUES(6, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
  148. INSERT INTO `flagged_post` VALUES(7, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
  149. INSERT INTO `flagged_post` VALUES(8, 1, NULL, 1, 0, 'spam', 'gaa\r\n', 0);
  150. INSERT INTO `flagged_post` VALUES(9, 1, NULL, 3, 0, 'notaccur', 'hello\r\n', 0);
  151. INSERT INTO `flagged_post` VALUES(10, 1, NULL, 1, 0, 'copyright', 'adf', 0);
  152. INSERT INTO `flagged_post` VALUES(11, 1, NULL, 1, 0, 'copyright', 'adf', 0);
  153. INSERT INTO `flagged_post` VALUES(12, 1, NULL, 16, 0, 'other', 'qwerty\r\n', 0);
  154. INSERT INTO `flagged_post` VALUES(13, 1, NULL, 17, 0, 'spam', 'this is a spam\r\n', 0);
  155. INSERT INTO `flagged_post` VALUES(14, 1, NULL, 3, 0, 'copyright', 'qwertyuiop', 0);
  156. INSERT INTO `flagged_post` VALUES(15, 1, NULL, 19, 0, 'copyright', NULL, 0);
  157. INSERT INTO `flagged_post` VALUES(16, 1, NULL, 1, 0, 'other', NULL, 0);
  158. INSERT INTO `flagged_post` VALUES(17, 1, NULL, 19, 0, 'notshared', NULL, 0);
  159. INSERT INTO `flagged_post` VALUES(18, 1, 19, NULL, 0, 'notshared', NULL, 0);
  160. INSERT INTO `flagged_post` VALUES(19, 1, 19, NULL, 0, 'notaccur', 'qasdf\r\n', 0);
  161. INSERT INTO `flagged_post` VALUES(20, 1, NULL, 19, 0, 'copyright', NULL, 0);
  162. INSERT INTO `flagged_post` VALUES(21, 1, NULL, NULL, 26, 'offensive', NULL, 0);
  163. INSERT INTO `flagged_post` VALUES(22, 1, NULL, NULL, 26, 'notaccur', 'hey this is not accurate', 0);
  164. INSERT INTO `flagged_post` VALUES(23, 1, NULL, NULL, 28, 'notaccur', NULL, 0);
  165. INSERT INTO `flagged_post` VALUES(24, 1, NULL, NULL, 28, 'notshared', NULL, 0);
  166. INSERT INTO `flagged_post` VALUES(25, 1, NULL, NULL, 27, 'notaccur', NULL, 0);
  167. INSERT INTO `flagged_post` VALUES(26, 1, NULL, NULL, 29, 'notshared', 'not shared', 0);
  168. INSERT INTO `flagged_post` VALUES(27, 1, NULL, 10, 0, 'notshared', NULL, 0);
  169. INSERT INTO `flagged_post` VALUES(30, 1, 19, NULL, 0, 'notshared', 'dsf', 0);
  170.  
  171. DROP TABLE IF EXISTS `invitation`;
  172. CREATE 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.  
  184. DROP TABLE IF EXISTS `Message`;
  185. CREATE 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.  
  199. INSERT INTO `Message` VALUES(1, 1, 0, 'hello buddies', 0, 0, '2010-09-30 10:49:47', 'hey hello how r u ???');
  200. INSERT INTO `Message` VALUES(3, 23, 42, 'sdfgrte', 0, 0, '2010-10-01 11:13:56', 'dsfsdfsdf');
  201. INSERT INTO `Message` VALUES(4, 25, 42, 'sasdfaf', 0, 0, '2010-10-01 11:13:56', 'sdffd');
  202. INSERT INTO `Message` VALUES(26, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
  203. INSERT INTO `Message` VALUES(27, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
  204. INSERT INTO `Message` VALUES(28, 23, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
  205. INSERT INTO `Message` VALUES(29, 42, 1, 'sfgsg', 0, 1, '2010-10-01 14:38:36', 'gdgdsdg');
  206. INSERT INTO `Message` VALUES(46, 1, 42, 'sdgdsgdsg', 0, 0, '2010-10-05 11:08:15', 'sgdfsd');
  207. INSERT INTO `Message` VALUES(47, 1, 23, 'how r u ??', 0, 0, '2010-10-05 11:23:54', 'hai');
  208. INSERT INTO `Message` VALUES(48, 1, 23, 'how r u ????', 0, 0, '2010-10-05 11:24:32', 'hello');
  209.  
  210. DROP TABLE IF EXISTS `request`;
  211. CREATE 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.  
  228. INSERT INTO `request` VALUES(3, 1, 3, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:22', NULL, 0);
  229. INSERT INTO `request` VALUES(4, 1, 4, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:23', NULL, 0);
  230. INSERT INTO `request` VALUES(5, 1, 5, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:24', NULL, 0);
  231. INSERT INTO `request` VALUES(6, 1, 6, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:24', NULL, 0);
  232. INSERT INTO `request` VALUES(7, 1, 7, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:25', NULL, 0);
  233. INSERT INTO `request` VALUES(8, 1, 8, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:25', NULL, 0);
  234. INSERT INTO `request` VALUES(9, 1, 9, 12, 65.00, 300.00, 1, 1, '2010-09-22 11:45:26', NULL, 0);
  235. INSERT INTO `request` VALUES(10, 1, 22, 12, 65.00, 7652.00, NULL, NULL, '2010-09-22 12:31:05', NULL, 0);
  236. INSERT INTO `request` VALUES(11, 1, 23, 1, 65.00, 300.00, NULL, NULL, '2010-09-22 12:32:07', NULL, 0);
  237. INSERT INTO `request` VALUES(12, 1, 24, 1, 65.00, 300.00, NULL, NULL, '2010-09-22 12:32:24', NULL, 1);
  238. INSERT INTO `request` VALUES(13, 1, 25, 33, 65.00, 8045.00, NULL, NULL, '2010-09-22 12:34:18', NULL, 0);
  239. INSERT INTO `request` VALUES(14, 1, 26, 33, 65.00, 8045.00, NULL, NULL, '2010-09-22 12:34:56', NULL, 0);
  240. INSERT INTO `request` VALUES(15, 1, 27, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:36:43', NULL, 0);
  241. INSERT INTO `request` VALUES(16, 1, 28, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:39:58', NULL, 0);
  242. INSERT INTO `request` VALUES(17, 1, 29, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:40:23', NULL, 0);
  243. INSERT INTO `request` VALUES(18, 1, 30, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:42:05', NULL, 0);
  244. INSERT INTO `request` VALUES(19, 1, 31, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:42:53', NULL, 0);
  245. INSERT INTO `request` VALUES(20, 1, 32, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:43:36', NULL, 0);
  246. INSERT INTO `request` VALUES(21, 1, 33, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:44:21', NULL, 0);
  247. INSERT INTO `request` VALUES(22, 1, 34, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:44:46', NULL, 0);
  248. INSERT INTO `request` VALUES(23, 1, 35, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:45:34', NULL, 0);
  249. INSERT INTO `request` VALUES(24, 1, 36, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:45:55', NULL, 0);
  250. INSERT INTO `request` VALUES(25, 1, 37, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:06', NULL, 0);
  251. INSERT INTO `request` VALUES(26, 1, 38, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:35', NULL, 0);
  252. INSERT INTO `request` VALUES(27, 1, 39, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:52:58', NULL, 0);
  253. INSERT INTO `request` VALUES(28, 1, 40, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:53:19', NULL, 0);
  254. INSERT INTO `request` VALUES(29, 1, 41, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:54:06', NULL, 0);
  255. INSERT INTO `request` VALUES(30, 1, 42, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:54:46', NULL, 0);
  256. INSERT INTO `request` VALUES(31, 1, 43, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:55:15', NULL, 0);
  257. INSERT INTO `request` VALUES(32, 1, 44, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:56:21', NULL, 0);
  258. INSERT INTO `request` VALUES(33, 1, 45, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:58:39', NULL, 0);
  259. INSERT INTO `request` VALUES(34, 1, 46, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:59:22', NULL, 0);
  260. INSERT INTO `request` VALUES(35, 1, 47, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 12:59:43', NULL, 0);
  261. INSERT INTO `request` VALUES(36, 1, 48, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:00:01', NULL, 0);
  262. INSERT INTO `request` VALUES(37, 1, 49, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:01:26', NULL, 0);
  263. INSERT INTO `request` VALUES(38, 1, 50, 5, 60.00, 10000.00, NULL, NULL, '2010-09-22 13:02:20', NULL, 0);
  264. INSERT INTO `request` VALUES(39, 1, 51, 12, 65.00, 1865.00, NULL, NULL, '2010-09-22 13:59:19', NULL, 0);
  265. INSERT INTO `request` VALUES(40, 1, 53, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:19:37', NULL, 0);
  266. INSERT INTO `request` VALUES(41, 1, 54, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:21:04', NULL, 0);
  267. INSERT INTO `request` VALUES(42, 1, 55, 12, 65.00, 300.00, NULL, NULL, '2010-09-22 14:21:19', NULL, 0);
  268. INSERT INTO `request` VALUES(43, 1, 67, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:11:46', NULL, 0);
  269. INSERT INTO `request` VALUES(44, 1, 68, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:14:15', NULL, 0);
  270. INSERT INTO `request` VALUES(45, 1, 69, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:14:42', NULL, 0);
  271. INSERT INTO `request` VALUES(46, 1, 70, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:15:34', NULL, 0);
  272. INSERT INTO `request` VALUES(47, 1, 71, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:15:55', NULL, 0);
  273. INSERT INTO `request` VALUES(48, 1, 72, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:16:11', NULL, 0);
  274. INSERT INTO `request` VALUES(49, 1, 73, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:16:40', NULL, 0);
  275. INSERT INTO `request` VALUES(50, 1, 74, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:17:08', NULL, 0);
  276. INSERT INTO `request` VALUES(51, 1, 75, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:18:15', NULL, 0);
  277. INSERT INTO `request` VALUES(52, 1, 76, 12, 260.00, 10000.00, NULL, NULL, '2010-09-22 17:18:35', NULL, 0);
  278.  
  279. DROP TABLE IF EXISTS `space`;
  280. CREATE 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.  
  313. INSERT 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);
  314. INSERT 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);
  315. INSERT 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);
  316. INSERT 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);
  317. INSERT 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);
  318. INSERT 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);
  319. INSERT 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);
  320. INSERT 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);
  321. INSERT 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);
  322. INSERT 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);
  323. INSERT 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);
  324. INSERT 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);
  325. INSERT 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);
  326. INSERT 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);
  327. INSERT 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);
  328. INSERT 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);
  329. INSERT 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);
  330. INSERT 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);
  331. INSERT 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);
  332. INSERT 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);
  333. INSERT 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.  
  335. DROP TABLE IF EXISTS `space_interest`;
  336. CREATE 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.  
  348. DROP TABLE IF EXISTS `space_photo`;
  349. CREATE 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.  
  360. DROP TABLE IF EXISTS `user`;
  361. CREATE 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.  
  381. INSERT INTO `user` VALUES(1, 'dani', '', 'dani@gmail.com', 'dani', 1, NULL, NULL, '', '', NULL, NULL, NULL, '23423423');
  382. INSERT INTO `user` VALUES(21, 'karthick', 'muthu', 'mkartic@gmail.com', 'karthick', 1, NULL, NULL, 'chennai', 'Outsmart', NULL, NULL, 'karthick', '23423424');
  383. INSERT INTO `user` VALUES(23, '23name', '', 'karthi@gmail.com', 'karthi', 1, NULL, NULL, '', '', NULL, NULL, NULL, '123');
  384. INSERT INTO `user` VALUES(25, '25name', '', 'dheeraj@gmail.com', 'dheeraj', 1, NULL, NULL, '', '', NULL, NULL, NULL, '12345');
  385. INSERT INTO `user` VALUES(36, '', '', 'a@a.com', 'a', 1, NULL, NULL, '', '', NULL, NULL, NULL, '9009');
  386. INSERT INTO `user` VALUES(37, '', '', 'dani@g.com', 'dani', 1, NULL, NULL, '', '', NULL, NULL, NULL, '678');
  387. INSERT INTO `user` VALUES(40, '', '', 'c@c.com', 'c', 0, NULL, NULL, '', '', NULL, NULL, NULL, '4f79e4e535e8c29e3c726dfc19cfda4e1172771c');
  388. INSERT INTO `user` VALUES(41, '41name', '', 'd@d.com', 'd', 0, NULL, NULL, '', '', NULL, NULL, NULL, '38ea9ae8ae28421f0a8bc667b37177e6e2fbc453');
  389. INSERT INTO `user` VALUES(42, 'karthi', '', 'e@e.com', 'e', 1, NULL, NULL, '', '', NULL, NULL, NULL, '63f1573d8b3be0852ac3865590ad8c57194fcb41');
  390. INSERT INTO `user` VALUES(43, '', '', 'f@f.com', 'f', 0, NULL, NULL, '', '', NULL, NULL, NULL, 'b2647110721699f245785a64297dc9fe0791cf09');
  391. INSERT INTO `user` VALUES(44, '', '', 's@s.com', 's', 1, NULL, NULL, '', '', NULL, NULL, NULL, '233814e53500a089b21483bf034d7682190b419f');
  392. INSERT INTO `user` VALUES(45, '', '', 'q@q.com', 'q', 0, NULL, NULL, '', '', NULL, NULL, NULL, 'dbccfe365a729ec3591943af84a97205464fa949');
  393. INSERT INTO `user` VALUES(46, '', '', 'g@g.com', 'g', 0, NULL, NULL, '', '', NULL, NULL, NULL, '295cb336848b2f49355ead0a1370528a1cb24176');
  394. INSERT INTO `user` VALUES(47, '', '', 'm@m.com', 'm', 1, NULL, NULL, '', '', NULL, NULL, NULL, '6bd2a9f611b127c7b9cdbdc00789342cf4c19989');
  395.  
  396.  
  397. ALTER 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.  
  402. ALTER 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.  
  407. ALTER TABLE `invitation`
  408.   ADD CONSTRAINT `fk_invitation_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  409.  
  410. ALTER 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.  
  414. ALTER 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.  
  418. ALTER 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.  
  422. ALTER 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!