-- phpMyAdmin SQL Dump -- version 2.6.4-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 15, 2006 at 11:50 AM -- Server version: 4.1.12 -- PHP Version: 5.0.4 -- -- Database: `zm` -- -- -------------------------------------------------------- -- -- Table structure for table `Groups` -- -- Creation: Jun 11, 2006 at 12:04 AM -- Last update: Jul 01, 2006 at 04:14 PM -- -- -- Dumping data for table `Groups` -- -- INSERT INTO `Groups` VALUES (1, 'Intruder Approaching', '4,5,6,8'); -- INSERT INTO `Groups` VALUES (2, 'Monitoring', '1,2,3,4,5,6'); -- -------------------------------------------------------- -- -- Table structure for table `Monitors` -- -- Creation: Jun 11, 2006 at 12:04 AM -- Last update: Aug 06, 2006 at 08:07 PM -- -- -- Dumping data for table `Monitors` -- INSERT INTO `Monitors` VALUES (1, 'Inside', 'Remote', 'None', 1, '', '', '/dev/video0', 0, 1, 'guest:100ramon@192.168.0.7', '8008', '/cgi-bin/video.jpg?cam=1', 352, 288, 4, '0', -1, -1, -1, -1, 'Inside-', '%%s - %d/%m/%y %H:%M:%S', 195, 280, 40, 25, 10, 10, 1, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 1); INSERT INTO `Monitors` VALUES (10, 'Yard', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.7', '8008', '/cgi-bin/video.jpg?cam=2', 352, 288, 4, '0', -1, -1, -1, -1, 'Yard-', '%%s - %d/%m/%y %H:%M:%S', 207, 280, 40, 25, 8, 4, 2, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 8); INSERT INTO `Monitors` VALUES (3, 'Entry', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.7', '8008', '/cgi-bin/video.jpg?cam=3', 288, 352, 4, '90', -1, -1, -1, -1, 'Entry-', '%%s - %d/%m/%y %H:%M:%S', 201, 344, 40, 25, 4, 4, 1, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 2); INSERT INTO `Monitors` VALUES (4, 'Drive', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.7', '8008', '/cgi-bin/video.jpg?cam=4', 352, 288, 4, '0', -1, -1, -1, -1, 'Drive-', '%%s - %d/%m/%y %H:%M:%S', 201, 280, 40, 25, 8, 8, 2, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 3); INSERT INTO `Monitors` VALUES (5, 'House', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.8', '8080', '/cgi-bin/video.jpg?cam=1', 352, 288, 4, '0', -1, -1, -1, -1, 'House-', '%%s - %d/%m/%y %H:%M:%S', 201, 280, 40, 25, 8, 8, 2, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 4); INSERT INTO `Monitors` VALUES (6, 'Shed', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.8', '8080', '/cgi-bin/video.jpg?cam=2', 352, 288, 4, '0', -1, -1, -1, -1, 'Shed-', '%%s - %d/%m/%y %H:%M:%S', 207, 280, 40, 25, 4, 4, 2, 600, 0, 3.00, 4.00, 1000, 7, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 5); INSERT INTO `Monitors` VALUES (7, 'Weather', 'Remote', 'Monitor', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.8', '8080', '/cgi-bin/video.jpg?cam=3', 352, 288, 4, '0', -1, -1, -1, -1, 'Weather-', '%%s - %d/%m/%y %H:%M:%S', 0, 0, 40, 25, 10, 10, 2, 600, 0, 0.50, 1.00, 1000, 10, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 6); INSERT INTO `Monitors` VALUES (8, 'Gate', 'Remote', 'Modect', 1, '', '', '/dev/video', 0, 0, 'guest:100ramon@192.168.0.8', '8080', '/cgi-bin/video.jpg?cam=4', 352, 288, 4, '0', -1, -1, -1, -1, 'Gate-', '%%s - %d/%m/%y %H:%M:%S', 207, 280, 40, 25, 10, 10, 1, 600, 0, 5.00, 5.00, 1000, 5, 0, 0, NULL, NULL, NULL, 0, 0, -1, 0, 'Events', 100, 100, 'red', 7); -- -------------------------------------------------------- -- -- Table structure for table `States` -- -- Creation: Jun 11, 2006 at 12:04 AM -- Last update: Jul 13, 2006 at 09:20 PM -- -- -- Dumping data for table `States` -- INSERT INTO `States` VALUES ('ALL_MONITOR', '1:Monitor:1,3:Monitor:1,4:Monitor:1,5:Monitor:1,6:Monitor:1,7:Monitor:1,8:Monitor:1,10:Monitor:1'); INSERT INTO `States` VALUES ('DAY_IN', '1:None:1,3:Modect:1,4:Monitor:1,5:Monitor:1,6:Monitor:1,7:Monitor:1,8:Modect:1,10:Monitor:1'); INSERT INTO `States` VALUES ('DAY_OUT', '1:Modect:1,3:Modect:1,4:Modect:1,5:Modect:1,6:Modect:1,7:Monitor:1,8:Modect:1,10:Modect:1'); INSERT INTO `States` VALUES ('NIGHT_OUT', '1:Modect:1,3:Monitor:1,4:Monitor:1,5:Monitor:1,6:Modect:1,7:Monitor:1,8:Modect:1,10:Monitor:1'); INSERT INTO `States` VALUES ('NIGHT_IN', '1:None:1,3:Monitor:1,4:Monitor:1,5:Monitor:1,6:Modect:1,7:Monitor:1,8:Modect:1,10:Monitor:1'); -- -------------------------------------------------------- -- -- Table structure for table `Zones` -- -- Creation: Jun 11, 2006 at 12:04 AM -- Last update: Aug 02, 2006 at 11:35 AM -- Last check: Jun 11, 2006 at 12:04 AM -- -- -- Dumping data for table `Zones` -- INSERT INTO `Zones` VALUES (1, 1, 'General', 'Active', 'Percent', 26, '27,198 56,181 55,141 87,135 116,127 125,92 116,31 163,25 164,65 175,112 191,99 206,97 206,63 221,47 208,14 282,11 283,49 298,48 300,112 344,114 345,179 330,237 253,275 172,274 194,234 36,207', 51203, 16711680, 'Blobs', 25, 0, 1024, 0, 3, 3, 1024, 0, 512, 7680, 1, 2); INSERT INTO `Zones` VALUES (13, 4, 'DriveFar', 'Inactive', 'Pixels', 8, '299,131 281,132 276,115 292,108 293,84 323,79 321,96 331,112', 1621, 16711680, 'Blobs', 20, NULL, 60, 0, 3, 3, 60, NULL, 60, 100, 1, 2); INSERT INTO `Zones` VALUES (3, 3, 'General', 'Active', 'Percent', 9, '4,163 80,101 224,103 228,125 267,123 260,337 131,338 132,349 3,349', 60142, 16711680, 'Blobs', 25, NULL, 902, 0, 3, 3, 902, 0, 902, 9021, 1, 2); INSERT INTO `Zones` VALUES (4, 4, 'Shed', 'Active', 'Pixels', 4, '19,104 147,95 149,125 23,136', 3878, 16711680, 'Blobs', 30, NULL, 65, 0, 3, 3, 65, 0, 65, 200, 1, 2); INSERT INTO `Zones` VALUES (5, 5, 'House', 'Active', 'Percent', 9, '43,77 187,72 276,67 287,99 292,130 196,158 4,169 3,101 43,100', 22180, 16711680, 'Blobs', 30, NULL, 443, 0, 3, 3, 443, 0, 443, 4436, 1, 2); INSERT INTO `Zones` VALUES (6, 6, 'Shed', 'Active', 'Percent', 4, '192,40 314,32 318,78 169,75', 5238, 16711680, 'Blobs', 20, NULL, 78, 0, 3, 3, 51, 0, 51, 261, 1, 2); INSERT INTO `Zones` VALUES (7, 7, 'All', 'Active', 'Percent', 4, '0,0 351,0 351,287 0,287', 101376, 16711680, 'Blobs', 25, NULL, 3041, 76032, 3, 3, 3041, 76032, 2027, NULL, 1, NULL); INSERT INTO `Zones` VALUES (8, 8, 'General', 'Active', 'Percent', 7, '2,19 159,17 159,4 349,5 349,149 206,144 3,163', 49212, 16711680, 'Blobs', 30, NULL, 3444, 0, 3, 3, 3444, 0, 3444, 29527, 1, 4); INSERT INTO `Zones` VALUES (12, 10, 'Gate', 'Active', 'Pixels', 9, '15,13 25,12 26,38 89,38 91,76 124,119 73,130 60,78 17,76', 5192, 16711680, 'Blobs', 20, NULL, 160, 0, 3, 3, 160, 0, 160, 300, 1, 2); INSERT INTO `Zones` VALUES (14, 4, 'DriveNew', 'Active', 'Percent', 7, '153,127 231,120 230,132 197,137 190,160 7,217 8,139', 10836, 16711680, 'Blobs', 25, NULL, 188, 0, 3, 3, 188, NULL, 188, 541, 1, 2); INSERT INTO `Zones` VALUES (15, 4, 'Foreground', 'Active', 'Percent', 6, '7,220 183,164 166,238 348,234 350,275 7,276', 21417, 16711680, 'Blobs', 45, NULL, 1070, NULL, 3, 3, 642, NULL, 642, 1713, 1, 2); INSERT INTO `Zones` VALUES (16, 5, 'Foreground', 'Active', 'Percent', 7, '6,175 197,164 302,133 349,137 348,276 201,274 3,277', 40241, 16711680, 'Blobs', 30, NULL, 1609, 0, 3, 3, 1609, 0, 1609, 8048, 1, 2); INSERT INTO `Zones` VALUES (17, 6, 'Foreground', 'Active', 'Percent', 5, '9,132 167,80 349,81 348,275 8,277', 62272, 16711680, 'Blobs', 30, NULL, 3113, 0, 3, 3, 2490, NULL, 2490, 31136, 1, 2); INSERT INTO `Zones` VALUES (18, 10, 'Door', 'Active', 'Percent', 11, '86,220 117,212 77,134 125,125 233,275 206,275 205,285 28,283 7,78 20,78 30,178', 23179, 16711680, 'Blobs', 26, NULL, 1158, NULL, 3, 3, 1158, NULL, 695, 2317, 1, 2); INSERT INTO `Zones` VALUES (19, 1, 'Desk', 'Inclusive', 'Percent', 4, '302,48 349,48 349,111 305,111', 2976, 16711680, 'Blobs', 15, NULL, 59, NULL, 3, 3, 59, NULL, 29, 446, 1, 2); INSERT INTO `Zones` VALUES (21, 10, 'Lawn', 'Active', 'Percent', 6, '96,77 159,74 261,111 349,106 349,274 237,273', 32409, 16711680, 'Blobs', 25, NULL, 1944, NULL, 3, 3, 1620, NULL, 1620, 2916, 1, 2); INSERT INTO `Zones` VALUES (20, 1, 'Wall', 'Inclusive', 'Pixels', 5, '169,71 186,75 203,68 205,97 175,100', 931, 16711680, 'Blobs', 15, 0, 2, NULL, 3, 3, 2, NULL, 1, 15, 1, 2);