API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 12th, 2016
78
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.62 KB | None | 0 0
raw download clone embed print report
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 4499
  4. #
  5. # http://www.sequelpro.com/
  6. # https://github.com/sequelpro/sequelpro
  7. #
  8. # Host: 127.0.0.1 (MySQL 5.7.10)
  9. # Database: eroom
  10. # Generation Time: 2016-03-12 15:59:47 +0000
  11. # ************************************************************
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  21.  
  22.  
  23. # Dump of table room
  24. # ------------------------------------------------------------
  25.  
  26. DROP TABLE IF EXISTS `room`;
  27.  
  28. CREATE TABLE `room` (
  29. `id` varchar(255) NOT NULL,
  30. `capacity` int(11) DEFAULT NULL,
  31. `created_by` varchar(255) DEFAULT NULL,
  32. `created_date` datetime DEFAULT NULL,
  33. `description` varchar(255) DEFAULT NULL,
  34. `floor_id` varchar(255) DEFAULT NULL,
  35. `has_microphone` bit(1) DEFAULT NULL,
  36. `has_monitor` bit(1) DEFAULT NULL,
  37. `has_phone` bit(1) DEFAULT NULL,
  38. `has_projector` bit(1) DEFAULT NULL,
  39. `has_video_cam` bit(1) DEFAULT NULL,
  40. `idx` int(11) DEFAULT NULL,
  41. `room_name` varchar(255) DEFAULT NULL,
  42. `updated_by` varchar(255) DEFAULT NULL,
  43. `updated_date` datetime DEFAULT NULL,
  44. `version` int(11) DEFAULT NULL,
  45. PRIMARY KEY (`id`)
  46. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  47.  
  48. LOCK TABLES `room` WRITE;
  49. /*!40000 ALTER TABLE `room` DISABLE KEYS */;
  50.  
  51. INSERT INTO `room` (`id`, `capacity`, `created_by`, `created_date`, `description`, `floor_id`, `has_microphone`, `has_monitor`, `has_phone`, `has_projector`, `has_video_cam`, `idx`, `room_name`, `updated_by`, `updated_date`, `version`)
  52. VALUES
  53. ('1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Conference Room',NULL,NULL,NULL);
  54.  
  55. /*!40000 ALTER TABLE `room` ENABLE KEYS */;
  56. UNLOCK TABLES;
  57.  
  58.  
  59. # Dump of table room_settings
  60. # ------------------------------------------------------------
  61.  
  62. DROP TABLE IF EXISTS `room_settings`;
  63.  
  64. CREATE TABLE `room_settings` (
  65. `id` varchar(255) NOT NULL,
  66. `description` varchar(255) DEFAULT NULL,
  67. `name` varchar(255) DEFAULT NULL,
  68. `var_value` varchar(255) DEFAULT NULL,
  69. `version` int(11) DEFAULT NULL,
  70. PRIMARY KEY (`id`)
  71. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  72.  
  73. LOCK TABLES `room_settings` WRITE;
  74. /*!40000 ALTER TABLE `room_settings` DISABLE KEYS */;
  75.  
  76. INSERT INTO `room_settings` (`id`, `description`, `name`, `var_value`, `version`)
  77. VALUES
  78. ('1','PIN_ADMIN','PIN_ADMIN','123456',1),
  79. ('2','ExchangeURL','ExchangeURL','mail.londonsumatra.com',1),
  80. ('3','RoomAdminName','RoomAdminName','PanelDev01',1),
  81. ('4','RoomAdminPassword','RoomAdminPassword','54321',1),
  82. ('5','RoomMailAddress','RoomMailAddress','Room.Dev01@londonsumatra.com',1),
  83. ('6','IsExchangeConnected','IsExchangeConnected','Y',1);
  84.  
  85. /*!40000 ALTER TABLE `room_settings` ENABLE KEYS */;
  86. UNLOCK TABLES;
  87.  
  88.  
  89. # Dump of table room_usage
  90. # ------------------------------------------------------------
  91.  
  92. DROP TABLE IF EXISTS `room_usage`;
  93.  
  94. CREATE TABLE `room_usage` (
  95. `id` varchar(255) NOT NULL,
  96. `created_by` varchar(255) DEFAULT NULL,
  97. `created_date` datetime DEFAULT NULL,
  98. `created_name` varchar(255) DEFAULT NULL,
  99. `description` varchar(255) DEFAULT NULL,
  100. `duration` int(11) DEFAULT NULL,
  101. `meeting_date` datetime DEFAULT NULL,
  102. `pin_number` varchar(255) DEFAULT NULL,
  103. `start_time` int(11) DEFAULT NULL,
  104. `updated_by` varchar(255) DEFAULT NULL,
  105. `updated_date` datetime DEFAULT NULL,
  106. `version` int(11) DEFAULT NULL,
  107. `room_id` varchar(255) DEFAULT NULL,
  108. `is_pin_sent` varchar(255) DEFAULT NULL,
  109. `appointment_uid` varchar(255) DEFAULT NULL,
  110. `is_delete` varchar(255) DEFAULT NULL,
  111. PRIMARY KEY (`id`),
  112. KEY `FK_1k63b9cwab4m964k1tnus464x` (`room_id`),
  113. CONSTRAINT `FK_1k63b9cwab4m964k1tnus464x` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
  114. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  115.  
  116. LOCK TABLES `room_usage` WRITE;
  117. /*!40000 ALTER TABLE `room_usage` DISABLE KEYS */;
  118.  
  119. INSERT INTO `room_usage` (`id`, `created_by`, `created_date`, `created_name`, `description`, `duration`, `meeting_date`, `pin_number`, `start_time`, `updated_by`, `updated_date`, `version`, `room_id`, `is_pin_sent`, `appointment_uid`, `is_delete`)
  120. VALUES
  121. ('0931e6e6-c27f-4723-b50b-749b49998668','Panel.Dev02@londonsumatra.com','2016-03-12 22:56:21','Panel Dev02','Panel Dev02 Test 11 Rapat Online 11',150,'2016-03-14 13:00:00','3850',780,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E00800000000255666F49A7AD10100000000000000001000000066ADDA207A0E3D47A2A3BCFCEAD9996D','N'),
  122. ('0e84be0a-85ac-4623-852c-76c88b2d99b3','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:22','Panel Dev03','Panel Dev03 Test 16 Rapat Online 16',120,'2016-03-16 14:00:00','6941',840,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E0080000000019F86BAA9E7AD101000000000000000010000000BE3C1559755C4942AF04CEBAFF5F7EB2','N'),
  123. ('1ad760cf-3a45-44cd-a5d9-d0028a3d2c76','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:20','Panel Dev03','Panel Dev03 Test 9 Rapat Online 9',300,'2016-03-12 14:00:00','7408',840,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E00800000000DDCE44EA977AD1010000000000000000100000008D6810841897154EA32135F831C91114','N'),
  124. ('25c8f2df-09c1-4879-83bb-72519d1a2c6f','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:23','Panel Dev03','Panel Dev03 Test 17 Rapat Online 17',180,'2016-03-16 17:00:00','6406',1020,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E008000000004B9101DB9E7AD1010000000000000000100000008D9C75D1F3766C449D2100FA2E45641B','N'),
  125. ('61fd4908-291b-4318-a343-5445ad7e43cb','Panel.Dev02@londonsumatra.com','2016-03-12 22:56:22','Panel Dev02','Panel Dev02 Test 14 Rapat Online 14',120,'2016-03-16 07:00:00','1882',420,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E0080000000065E037389E7AD1010000000000000000100000009EDC1319BBF08A419A83213A7DA374B6','N'),
  126. ('722e44f1-0520-4904-a863-11fc6d0f5eae','Panel.Dev02@londonsumatra.com','2016-03-12 22:56:23','Panel Dev02','Panel Dev02 Test 18 Rapat Online 18',120,'2016-03-16 21:00:00','2261',1260,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E00800000000E586E8079F7AD1010000000000000000100000007B49797F4BEA8649A7A6B9BEC1C7FEF6','N'),
  127. ('74d44141-7132-422d-a3d8-b8ef297cb3e6','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:21','Panel Dev03','Panel Dev03 Test 13 Rapat Online 13',720,'2016-03-15 09:00:00','6628',540,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E00800000000571CF8CE9D7AD101000000000000000010000000E05AAE9EBC38A2428C785FA2C2714B2A','N'),
  128. ('7bc9b91a-1056-450f-870a-de1a5eb0ab1d','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:21','Panel Dev03','Panel Dev03 Test 12 Rapat Online 12',60,'2016-03-14 17:00:00','5963',1020,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E0080000000063906D6E9C7AD1010000000000000000100000008C402027892E3440BC4D66D1B99E0153','N'),
  129. ('82eb5c99-82a0-4e3c-b134-5f189f9e708f','Panel.Dev02@londonsumatra.com','2016-03-12 22:56:20','Panel Dev02','Panel Dev02 Test 8 Rapat Online 8',300,'2016-03-12 07:00:00','0778',420,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E00800000000A50C5E14977AD101000000000000000010000000E40C462477001D41A7B3B6DF755A8300','N'),
  130. ('ad52bfd8-83d4-4959-b27f-d4462763fce1','Panel.Dev01@londonsumatra.com','2016-03-12 22:56:20','Panel Dev01','Panel Dev01 B Day Party by Leny',30,'2016-03-12 19:00:00','2740',1140,NULL,NULL,0,'1',NULL,'040000008200E00074C5B7101A82E00800000000850D7DEB507CD1010000000000000000100000008CBC2C2175E89C4395394CBF9702E438','N'),
  131. ('e47243bd-087b-4917-a572-fdc764c824ee','Panel.Dev02@londonsumatra.com','2016-03-12 22:56:22','Panel Dev02','Panel Dev02 Test 15 Rapat Online 15',180,'2016-03-16 10:00:00','2013',600,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E008000000007155C6689E7AD10100000000000000001000000066D02C72660E0C458D7EA1757D00E6E5','N'),
  132. ('fd1a41aa-a6c8-44ae-b835-3bcc5b06fbfb','Panel.Dev03@londonsumatra.com','2016-03-12 22:56:21','Panel Dev03','Panel Dev03 Test 10 Rapat Online 10',180,'2016-03-14 09:00:00','2928',540,NULL,NULL,0,'1','Y','040000008200E00074C5B7101A82E008000000002FBE8EC89A7AD101000000000000000010000000AD051DE0F6424D4486A2A7ED6200DCA0','N');
  133.  
  134. /*!40000 ALTER TABLE `room_usage` ENABLE KEYS */;
  135. UNLOCK TABLES;
  136.  
  137.  
  138. # Dump of table room_usage_participant
  139. # ------------------------------------------------------------
  140.  
  141. DROP TABLE IF EXISTS `room_usage_participant`;
  142.  
  143. CREATE TABLE `room_usage_participant` (
  144. `id` varchar(255) NOT NULL,
  145. `participant_email` varchar(255) DEFAULT NULL,
  146. `version` int(11) DEFAULT NULL,
  147. `room_usage_id` varchar(255) DEFAULT NULL,
  148. PRIMARY KEY (`id`),
  149. KEY `FK_e9crhgyjo687em55ggbi28t7o` (`room_usage_id`),
  150. CONSTRAINT `FK_e9crhgyjo687em55ggbi28t7o` FOREIGN KEY (`room_usage_id`) REFERENCES `room_usage` (`id`)
  151. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  152.  
  153. LOCK TABLES `room_usage_participant` WRITE;
  154. /*!40000 ALTER TABLE `room_usage_participant` DISABLE KEYS */;
  155.  
  156. INSERT INTO `room_usage_participant` (`id`, `participant_email`, `version`, `room_usage_id`)
  157. VALUES
  158. ('0deaf280-76e4-420d-b687-ba9bfc0339a7','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'25c8f2df-09c1-4879-83bb-72519d1a2c6f'),
  159. ('17b0acc4-adae-4857-b6e5-0c4f667d5a00','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'fd1a41aa-a6c8-44ae-b835-3bcc5b06fbfb'),
  160. ('1cf91169-db19-4df0-9944-838a5a815260','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'74d44141-7132-422d-a3d8-b8ef297cb3e6'),
  161. ('30b453e7-ff2e-4440-977b-4ed0e523eafe','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'0931e6e6-c27f-4723-b50b-749b49998668'),
  162. ('3726eaae-9034-4301-ab01-af507cce898a','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'0e84be0a-85ac-4623-852c-76c88b2d99b3'),
  163. ('38e5a769-1e8e-41ba-b4dd-51bb77b72526','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'1ad760cf-3a45-44cd-a5d9-d0028a3d2c76'),
  164. ('3ff015c2-d9be-4ff4-92fd-15be96b7d7d2','rudy@technetvision.com - rudy@technetvision.com',0,'25c8f2df-09c1-4879-83bb-72519d1a2c6f'),
  165. ('4024fe99-5f2b-4ddb-8e9a-1dac955c3a9b','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'0931e6e6-c27f-4723-b50b-749b49998668'),
  166. ('4d55ab72-12a6-45bf-9297-6c686d1b624c','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'82eb5c99-82a0-4e3c-b134-5f189f9e708f'),
  167. ('5b73393f-d042-4209-916c-0cdd8a9938a7','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'722e44f1-0520-4904-a863-11fc6d0f5eae'),
  168. ('64ab550f-1a15-4736-85d0-045fa6e354f8','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'0e84be0a-85ac-4623-852c-76c88b2d99b3'),
  169. ('65cda6ce-2da8-471b-801c-76e8de4de017','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'25c8f2df-09c1-4879-83bb-72519d1a2c6f'),
  170. ('6fef8102-5125-47d0-9433-0b89ef4fadca','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'1ad760cf-3a45-44cd-a5d9-d0028a3d2c76'),
  171. ('7ffb3c42-bf1b-4c8e-a5a7-f214405fb7a2','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'61fd4908-291b-4318-a343-5445ad7e43cb'),
  172. ('84ab60ad-b00a-43fe-90d5-4f877a0f337f','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'82eb5c99-82a0-4e3c-b134-5f189f9e708f'),
  173. ('8c480c1d-8167-4ac4-a644-849de1c75821','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'7bc9b91a-1056-450f-870a-de1a5eb0ab1d'),
  174. ('9ca7d669-1f13-43a6-9bc2-52d0435a52d9','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'25c8f2df-09c1-4879-83bb-72519d1a2c6f'),
  175. ('a194d8d2-ff49-4581-9cc0-7dffd733b0fb','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'e47243bd-087b-4917-a572-fdc764c824ee'),
  176. ('a981fd4e-3604-4a9c-86c0-b21185babd5d','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'fd1a41aa-a6c8-44ae-b835-3bcc5b06fbfb'),
  177. ('aa0a3861-95ab-4d4b-921f-e26fcfc52fca','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'0931e6e6-c27f-4723-b50b-749b49998668'),
  178. ('b582c052-384c-428b-988e-7e37c4fac684','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'e47243bd-087b-4917-a572-fdc764c824ee'),
  179. ('c03b855c-8b75-411b-bd9f-b4a1a82ab883','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'722e44f1-0520-4904-a863-11fc6d0f5eae'),
  180. ('c27feb09-2e1e-4cc7-bd52-2cddac04e8be','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'7bc9b91a-1056-450f-870a-de1a5eb0ab1d'),
  181. ('c37c2bbb-317f-4663-99b1-2938c1a2e08b','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'722e44f1-0520-4904-a863-11fc6d0f5eae'),
  182. ('c4156ae5-ded6-4755-9a7f-4de3d461bef4','oki@technetvision.com - oki@technetvision.com',0,'1ad760cf-3a45-44cd-a5d9-d0028a3d2c76'),
  183. ('c8694efe-2203-4060-851b-5f221a4effee','rudy@technetvision.com - rudy@technetvision.com',0,'e47243bd-087b-4917-a572-fdc764c824ee'),
  184. ('c9cad4a1-b558-4a3d-b03f-0fbe02e6dffa','Panel Dev03 - Panel.Dev03@londonsumatra.com',0,'fd1a41aa-a6c8-44ae-b835-3bcc5b06fbfb'),
  185. ('d7189937-ae08-484b-8015-67e878d89cd8','adyagungsp@gmail.com - adyagungsp@gmail.com',0,'74d44141-7132-422d-a3d8-b8ef297cb3e6'),
  186. ('dbb7ebdd-77b7-4d89-a7d1-e64f2684802b','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'74d44141-7132-422d-a3d8-b8ef297cb3e6'),
  187. ('dd8d11e8-018e-46d6-8303-2ece614e22d2','oki@technetvision.com - oki@technetvision.com',0,'0e84be0a-85ac-4623-852c-76c88b2d99b3'),
  188. ('e04174bd-4f48-4424-808b-f0f5dac84420','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'1ad760cf-3a45-44cd-a5d9-d0028a3d2c76'),
  189. ('f38bbea6-a599-4edd-8d5c-5288b3ec70ed','Panel Dev02 - Panel.Dev02@londonsumatra.com',0,'61fd4908-291b-4318-a343-5445ad7e43cb');
  190.  
  191. /*!40000 ALTER TABLE `room_usage_participant` ENABLE KEYS */;
  192. UNLOCK TABLES;
  193.  
  194.  
  195.  
  196. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  197. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  198. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  199. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  200. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  201. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
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!