--
-- Host: localhost    Database: integricast
-- ------------------------------------------------------


--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (4,'TransGlobal'),(2,'Love\'s Yogurt'),(3,'Thalia Spice'),(1,'Integrisys Group'),(5,'Jones Lang Lasalle'),(6,'REX');

--
-- Table structure for table `concept`
--

CREATE TABLE `concept` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `concept`
--

INSERT INTO `concept` VALUES (1,'Plano Tavern'),(2,'Bennigan\'s'),(3,'Thalia Spice'),(4,'Love\'s Yogurt'),(5,'Tilted Kilt'),(6,'Integricast'),(7,'Integrisys'),(8,'225 West Wacker'),(9,'Bermans Auto Group'),(10,'REX Electric');

--
-- Table structure for table `intermezzo_slide_slideshow`
--

CREATE TABLE `intermezzo_slide_slideshow` (
  `slide` int(11) NOT NULL,
  `slideshow` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `duration` int(11) NOT NULL DEFAULT '5',
  `transition` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `intermezzo_slide_slideshow`
--

INSERT INTO `intermezzo_slide_slideshow` VALUES (5,1,3,15,3),(1,1,2,5,1),(2,1,1,5,2),(1,4,1,5,1),(2,4,2,5,1),(5,4,3,10,2),(14,4,4,20,1),(15,4,5,10,1),(53,6,1,15,1),(1,8,1,5,0),(81,8,2,30,0),(104,2,1,5,0),(50,8,3,20,0),(76,7,1,5,1),(87,7,2,10,1),(87,7,4,10,1),(6,2,3,10,1),(12,2,6,15,1),(116,9,1,5,1),(333,10,1,5,0),(112,5,2,5,0),(139,9,2,15,1);

--
-- Table structure for table `intermezzo_slideshow_playlist`
--

CREATE TABLE `intermezzo_slideshow_playlist` (
  `slideshow` int(11) NOT NULL,
  `playlist` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `time_start` time NOT NULL DEFAULT '00:00:00',
  `time_end` time NOT NULL DEFAULT '23:59:59'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `intermezzo_slideshow_playlist`
--

INSERT INTO `intermezzo_slideshow_playlist` VALUES (2,2,1,'00:00:00','23:59:59'),(3,3,1,'00:00:00','23:59:59'),(4,4,1,'00:00:00','23:59:59'),(5,5,1,'00:00:00','23:59:59'),(1,1,2,'00:00:00','23:59:59'),(7,6,1,'00:00:00','23:59:59'),(8,7,1,'00:00:00','23:59:59'),(9,8,1,'00:00:00','23:59:59');

--
-- Table structure for table `playlist`
--

CREATE TABLE `playlist` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `site` int(11) NOT NULL,
  `last_update` datetime NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `playlist`
--

INSERT INTO `playlist` VALUES (1,'Integricast Default',8,'2016-03-18 18:39:40'),(2,'Integrisys Corporate',5,'2013-06-12 17:38:17'),(3,'Thalia Main',2,'2010-06-17 10:47:07'),(4,'Brad\'s Laptop Demo',8,'2016-03-18 18:39:40'),(5,'225 Playlist Main',9,'2014-01-15 13:43:00'),(6,'832 West Superior',5,'2013-06-17 17:31:25'),(7,'Test',8,'2016-03-18 18:39:40'),(8,'REX Chicago Playlist',11,'2019-01-09 19:24:19');

--
-- Table structure for table `session`
--

CREATE TABLE `session` (
  `id` varchar(32) NOT NULL,
  `user` int(11) DEFAULT NULL,
  `IP_addr` varchar(16) NOT NULL,
  `start` datetime NOT NULL,
  `last_hit` datetime NOT NULL,
  `msg` varchar(100) DEFAULT NULL,
  `error_msg` varchar(100) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `session`
--

INSERT INTO `session` VALUES ('kci17kc9m0g6dm8ff8jfi1asf3',1,'75.146.121.149','2013-02-13 22:51:46','2013-02-13 22:54:41','',''),('3saijsssshj8mhpf3kp7v8ooj0',6,'99.73.12.62','2013-02-27 21:33:28','2013-02-27 21:33:34','',''),('e7fsk1l1ifc8hqt7atfmkb0jd7',2,'75.146.121.149','2013-05-09 14:49:25','2013-05-09 15:00:42',NULL,NULL),('qgb6bq30cuj4f5m8i335jcq7q7',1,'75.146.121.149','2013-04-25 23:01:41','2013-04-25 23:04:59',NULL,NULL),('2gerq4if6q04arvk7dh4d3rl10',2,'75.146.121.149','2013-05-31 17:48:23','2013-05-31 17:48:36','',''),('dnhpggrr1ulbp804bif0cithd1',2,'75.146.121.149','2013-06-03 16:21:19','2013-06-03 16:21:22','',''),('avcl9uccc3igroor04aac4ads3',1,'75.146.121.149','2013-06-12 17:20:20','2013-06-12 17:20:28','',''),('34b949srofk4ska1s4fl1bjt54',2,'75.146.121.149','2013-06-17 17:31:13','2013-06-17 17:31:25',NULL,NULL),('40hrt0a36p71qfpbl4hc1h3sg4',2,'75.146.121.149','2013-06-17 16:27:03','2013-06-17 16:27:09','',''),('iv6ug8taghhjr98jccihdb5ou4',1,'38.104.98.254','2013-08-12 19:33:02','2013-08-12 19:34:30','',''),('oseg5tbm5h3gk8p6r3qbmm3cb6',6,'208.100.40.45','2013-08-13 12:28:22','2013-08-13 12:28:26','',''),('ehqkdiftc5m1fh7sk93l43n6i7',2,'38.104.98.254','2013-08-15 19:52:23','2013-08-15 20:13:07',NULL,NULL),('gom300kfm0hvnhvt4oj43vobf0',2,'38.104.98.254','2013-08-15 20:51:29','2013-08-15 20:51:33','',''),('ioneu8r8rfqhvllfaulimtftu2',2,'75.146.121.149','2013-08-20 23:33:34','2013-08-20 23:49:32',NULL,NULL),('vg74kn22dt87i5l98bt58uce46',7,'75.146.121.149','2013-08-20 23:35:38','2013-08-20 23:55:31',NULL,NULL),('msv954ht5elfh2qjr182pq9ou0',1,'38.104.98.254','2013-08-26 14:14:39','2013-08-26 14:20:30','',''),('g1r06r61bdtpuhpj8nrv88mp36',6,'208.100.40.59','2013-08-26 18:32:44','2013-08-26 18:35:12',NULL,NULL),('kedjg317c57vg7qt32db3t7ub7',6,'50.158.116.142','2013-08-26 21:37:10','2013-08-26 21:54:29',NULL,NULL),('30unqi09i63ghr6ovjae5krra1',2,'38.104.98.254','2013-09-03 14:20:47','2013-09-03 14:21:14',NULL,NULL),('s11gb08ihf0fppgtdtu3kacad3',7,'38.104.98.254','2013-08-27 21:48:24','2013-08-27 21:48:45','',''),('ndbofmkp9r4qck9r90hvhqc0s3',1,'38.104.98.254','2013-09-09 18:23:27','2013-09-09 18:34:16',NULL,NULL),('nd59gdm8ejrf1qnarkt8eg4tj5',2,'38.104.98.254','2013-09-09 23:12:59','2013-09-09 23:13:16',NULL,NULL),('q319jbg8jk1j10679kqvi2ulf1',2,'38.104.98.254','2013-09-18 13:23:30','2013-09-18 13:25:42',NULL,NULL),('ejrosmj2oqj6qnhemaarqdeta1',6,'208.100.40.45','2013-09-19 13:12:10','2013-09-19 13:15:56','',''),('dse5bktsvdo870quoglj64iql4',6,'208.100.40.59','2013-09-24 18:31:20','2013-09-24 18:32:50','',''),('aiuefq2159cssdo5da85quf2q2',6,'208.100.40.59','2013-09-24 18:44:52','2013-09-24 18:46:12',NULL,NULL),('jashv37u4bm4q23qdms0h9gke0',2,'38.104.98.254','2013-10-10 13:59:45','2013-10-10 14:16:51',NULL,NULL),('0g05ltvl12p0uhhab57ptkjv07',2,'38.104.98.254','2013-10-25 18:54:15','2013-10-25 18:56:44',NULL,NULL),('t29kijhluf96uiqb5vgvsaur10',1,'38.104.98.254','2013-10-29 21:18:25','2013-10-29 21:19:17','',''),('aqn04sm6347c4p15v0nfqfuat2',2,'38.104.98.254','2013-10-31 14:43:15','2013-10-31 15:06:30',NULL,NULL),('39e9hgq576rqtjq8qnb5msvcj0',2,'38.104.98.254','2013-11-05 15:20:12','2013-11-05 15:21:50',NULL,NULL),('qejfpmq0h25jd000giv7pspv65',2,'38.104.98.254','2013-11-12 16:21:59','2013-11-12 16:25:26',NULL,NULL),('l2if0op8u7mrgmoobc98gsers3',2,'38.104.98.254','2013-11-14 16:10:57','2013-11-14 16:25:33',NULL,NULL),('qgft8ag87k9l6hl3h5nkojql77',2,'38.104.98.254','2013-12-16 15:50:26','2013-12-16 15:51:57',NULL,NULL),('d7tt0ikif81qlui853921t0t54',2,'38.104.98.254','2014-01-08 16:28:07','2014-01-08 16:40:47',NULL,NULL),('b3dkd0tlevvje2rgb3kvie5tv4',6,'208.100.40.48','2014-01-14 19:23:06','2014-01-14 19:25:30',NULL,NULL),('qi0r41ikv02kqtf6ul77qa3td7',1,'38.104.98.254','2014-01-14 18:06:03','2014-01-14 18:12:57',NULL,NULL),('sr5nl81ai8502rv5jdlgtmn433',1,'38.104.98.254','2014-01-14 19:18:50','2014-01-14 19:29:51',NULL,NULL),('h9jbm2e897ev8gl3og2buml654',6,'208.100.40.48','2014-01-15 13:42:25','2014-01-15 13:43:04',NULL,NULL),('vgk3semn2mh6fecaqqqc3pug64',2,'38.104.98.254','2014-02-04 15:58:12','2014-02-04 16:23:38',NULL,NULL),('fuj4kp9gf4jccfha9jdem090b2',2,'38.104.98.254','2014-03-03 18:07:52','2014-03-03 18:08:58',NULL,NULL),('8vese6kvc13jm4eukalsl75c92',2,'38.104.98.254','2014-04-01 22:00:32','2014-04-01 22:01:41',NULL,NULL),('q50bkp04johkr13cu0n3d0lsf4',2,'38.104.98.254','2014-04-03 14:17:49','2014-04-03 14:19:04',NULL,NULL),('ifclh7km5klgnajnkfgecbfjm0',2,'38.104.98.254','2014-04-21 21:42:33','2014-04-21 22:12:24',NULL,NULL),('da8eo5efv5upj62gci0vs0u501',2,'38.104.98.254','2014-05-01 21:29:07','2014-05-01 21:30:36',NULL,NULL),('3mldqb5nih201kp2dlr5nf0rt7',2,'38.104.98.254','2014-05-07 20:36:13','2014-05-07 20:37:02',NULL,NULL),('gpl516kiogg8hcg000r0ve42s5',2,'38.104.98.254','2014-05-28 15:51:17','2014-05-28 15:51:25',NULL,NULL),('fu2iuibf6c70ohecfo8h64qdf4',2,'38.104.98.254','2014-06-03 17:38:38','2014-06-03 17:49:00',NULL,NULL),('iqpp99rva7o57luvlqk4sc6no7',2,'38.104.98.254','2014-07-01 19:48:31','2014-07-01 19:49:20',NULL,NULL),('5n17nnrb4hvalhikdj0nspha45',1,'38.104.98.254','2014-07-08 20:00:52','2014-07-08 20:01:29',NULL,NULL),('sptd32ib3l450pci9uie0q1fk1',2,'38.104.98.254','2014-07-28 18:55:35','2014-07-28 18:56:52',NULL,NULL),('oce54lcntkhl9ie4ppkfri6qi3',2,'38.104.98.254','2014-08-06 16:03:11','2014-08-06 16:03:21',NULL,NULL),('83opgkov5uuetpe3vs9pebd7s0',2,'38.104.98.254','2014-09-04 19:12:29','2014-09-04 19:13:00',NULL,NULL),('f20ksdpl1mccb0jcbv2nafmn02',2,'38.104.98.254','2014-10-02 21:33:25','2014-10-02 21:34:51',NULL,NULL),('33u1dsmd5upq92jpv2sknaa4g2',2,'38.104.98.254','2014-10-13 21:12:38','2014-10-13 21:15:26',NULL,NULL),('06ivk0am705isv8fqjef630uf3',7,'38.104.98.254','2014-10-15 14:26:40','2014-10-15 14:26:57','',''),('o6di3nbd3lf9hae6oj3eiuesk6',2,'38.104.98.254','2014-11-10 16:11:38','2014-11-10 16:13:55',NULL,NULL),('5ac3r3tp3h63n095bquo3mj1n5',2,'38.104.98.254','2014-11-18 15:56:15','2014-11-18 15:56:54',NULL,NULL),('6smsjilb2bgqqjcp4pddpufbg5',7,'38.104.98.254','2014-12-01 22:38:52','2014-12-01 22:48:10',NULL,NULL),('stu0l517c11v5ela7glhb87hm4',7,'38.104.98.254','2014-12-02 00:58:24','2014-12-02 01:13:46',NULL,NULL),('27rtj5ghjrplqu5mdi1gokggs7',7,'38.104.98.254','2014-12-16 17:30:51','2014-12-16 17:38:06',NULL,NULL),('jjpnotu0t5roh19qian5afmv86',7,'38.104.98.254','2014-12-23 14:22:11','2014-12-23 14:28:39',NULL,NULL),('q9ug4g1h5hacu3napadd7o1db2',7,'38.104.98.254','2014-12-31 15:29:39','2014-12-31 15:36:37',NULL,NULL),('eon20i6p1vrojb7g2e624f0o06',7,'38.104.98.254','2015-01-05 15:38:06','2015-01-05 15:41:44',NULL,NULL),('1nuarnl8rip201pj7iuvj8cof2',7,'38.104.98.254','2015-01-06 17:57:28','2015-01-06 17:59:06',NULL,NULL),('qdqeifjcij6j65e5vqgohgipo3',7,'38.104.98.254','2015-01-08 20:33:38','2015-01-08 20:42:02',NULL,NULL),('bkull7jlv1970hg82u7i6f4q27',7,'38.104.98.254','2015-01-13 22:16:30','2015-01-13 22:21:36',NULL,NULL),('6ptdrp62h0846fm3omkuun8gj2',7,'38.104.98.254','2015-03-06 21:32:10','2015-03-06 21:33:29',NULL,NULL),('799dt4g2us5ibdhnrafqa7b4a2',1,'38.104.98.254','2015-02-11 16:31:48','2015-02-11 16:35:51','',''),('r6lh7cgdbfop738f4np24sr8r7',7,'38.104.98.254','2015-03-17 18:34:39','2015-03-17 18:44:55',NULL,NULL),('9r2chpvk7ahtf5m8m8uo35rnp2',7,'38.104.98.254','2015-03-20 19:33:37','2015-03-20 19:33:41','',''),('itdo4ltclnq05fi0664474anm2',7,'38.104.98.254','2015-03-27 16:41:56','2015-03-27 16:44:17',NULL,NULL),('n8grpcml2s1udqvchh7jduihn6',7,'38.104.98.254','2015-03-31 21:39:54','2015-03-31 21:41:35',NULL,NULL),('cbiure9mhpu52bufavl7a3f163',7,'38.104.98.254','2015-04-01 21:42:24','2015-04-01 21:42:37',NULL,NULL),('o77t6nbito017govfnlina05s0',7,'38.104.98.254','2015-04-07 14:26:33','2015-04-07 14:40:34',NULL,NULL),('sktn3cao9b0gh64v36mn40fqd3',7,'38.104.98.254','2015-04-08 20:46:29','2015-04-08 20:47:55',NULL,NULL),('ir1dq7e8runhrls8734na73662',7,'38.104.98.254','2015-04-20 14:22:37','2015-04-20 14:27:01',NULL,NULL),('i2ls29dh7jf4nqqguirc449sq4',7,'38.104.98.254','2015-04-27 21:46:29','2015-04-27 21:49:31',NULL,NULL),('alrk1q6594u9ng4b4vpd0ubr35',7,'38.104.98.254','2015-05-04 18:37:27','2015-05-04 18:38:26',NULL,NULL),('1rderairkj9hofmokah8td2qs3',7,'38.104.98.254','2015-05-11 16:03:15','2015-05-11 16:18:00',NULL,NULL),('5u6qdchdq03an32g696bm9o2d1',7,'38.104.98.254','2015-05-13 14:03:27','2015-05-13 14:05:38',NULL,NULL),('m22p3tkbu175er2kds0qpqt1a7',7,'38.104.98.254','2015-05-28 01:31:50','2015-05-28 01:33:25',NULL,NULL),('8u7mebr5e7ohknc6sg8f696c11',7,'38.104.98.254','2015-06-01 22:01:12','2015-06-01 22:02:13',NULL,NULL),('365ddvvfdj2okge8l8g6uijg13',7,'38.104.98.254','2015-06-03 22:29:54','2015-06-03 22:37:44',NULL,NULL),('odig8brmq5bod8md1fkvflisd7',7,'38.104.98.254','2015-06-15 22:40:22','2015-06-15 22:54:08',NULL,NULL),('4n18o4akqqj68aunq8lohjsgi0',7,'38.104.98.254','2015-06-19 17:18:21','2015-06-19 17:24:23',NULL,NULL),('a5sgc1rli9opqf644q89pjg5e4',7,'38.104.98.254','2015-06-30 21:38:32','2015-06-30 21:40:03',NULL,NULL),('chv87nqemjfochtjkujacakvk2',7,'38.104.98.254','2015-07-01 13:53:08','2015-07-01 13:54:05',NULL,NULL),('b1kgqko4eolft2fl2040ndetb1',7,'38.104.98.254','2015-07-09 13:29:01','2015-07-09 13:34:04',NULL,NULL),('2gi7khoerc8gah4kk04tlmcvl5',7,'38.104.98.254','2015-07-23 15:33:43','2015-07-23 15:49:07',NULL,NULL),('h3a8ii12kso4uo3j3n5ctl02m5',7,'38.104.98.254','2015-08-06 13:07:00','2015-08-06 13:07:45',NULL,NULL),('ucfb8ti5hgc54cc6v96uhvbu85',7,'38.104.98.254','2015-08-20 18:39:04','2015-08-20 18:39:32',NULL,NULL),('0ir5toioie2pv8t6j3q1elc807',7,'38.104.98.254','2015-08-28 15:35:06','2015-08-28 15:36:11',NULL,NULL),('1rif88m5lklik3hsk2ukqlkda6',7,'38.104.98.254','2015-09-01 20:00:41','2015-09-01 20:02:47',NULL,NULL),('70fteil9tro6hg7qmirghm13c3',7,'38.104.98.254','2015-09-03 15:27:24','2015-09-03 15:28:07',NULL,NULL),('3hgeu6g327bnqsnl8li7t7u555',7,'38.104.98.254','2015-09-10 19:39:50','2015-09-10 19:40:46',NULL,NULL),('qf7cbpsm5b4pe0j1buk1j32fv0',7,'38.104.98.254','2015-09-24 21:26:35','2015-09-24 21:28:01',NULL,NULL),('ctunue33d1vbh176qomk81t2j3',7,'38.104.98.254','2015-10-01 14:36:33','2015-10-01 14:38:39',NULL,NULL),('gh57qa3slqc215dr8je4tvd6l2',7,'38.104.98.254','2015-10-05 14:39:11','2015-10-05 14:48:40',NULL,NULL),('i2hmroiab925emfr36iqdhee26',7,'38.104.98.254','2015-10-08 21:32:53','2015-10-08 21:34:53',NULL,NULL),('k1mnape66hra7s165uq2595g27',7,'38.104.98.254','2015-10-16 21:28:01','2015-10-16 21:28:55',NULL,NULL),('a0e444gte6m2nkqgb4tnldfr77',7,'38.104.98.254','2015-10-21 21:51:55','2015-10-21 21:55:32',NULL,NULL),('ctil2e318anagamcj9lqhn4uq7',7,'38.104.98.254','2015-10-23 13:34:53','2015-10-23 13:36:45',NULL,NULL),('fq8631j7fdnspjs0kr0mlja6h4',7,'38.104.98.254','2015-10-29 20:33:57','2015-10-29 20:38:33',NULL,NULL),('vjcv516ar7skjr519afrjuuij0',7,'38.104.98.254','2015-11-06 16:45:04','2015-11-06 16:46:32',NULL,NULL),('j5krhouq3bqcj0ilhm8ia9lru0',7,'38.104.98.254','2015-11-10 14:45:58','2015-11-10 14:47:48',NULL,NULL),('3egfvd58i4u2qo8midsquc1k75',7,'38.104.98.254','2015-11-10 17:56:04','2015-11-10 17:57:30',NULL,NULL),('bfombn2aidhltc7cu4nv1f1q47',7,'38.104.98.254','2015-11-19 16:21:15','2015-11-19 16:24:20',NULL,NULL),('8q81mcmnm547kh6eglg2s608h1',7,'38.104.98.254','2015-11-24 22:31:03','2015-11-24 22:51:03',NULL,NULL),('6lq7v2r54ejbnsv213itrldvu3',7,'38.104.98.254','2015-12-07 22:57:26','2015-12-07 22:58:25',NULL,NULL),('bid5vk2airb8gtll74elambi93',7,'38.104.98.254','2015-12-31 16:51:47','2015-12-31 17:27:50',NULL,NULL),('l9ovojv3mlte93uhokdu91lum3',7,'38.104.98.254','2016-01-20 22:33:32','2016-01-20 22:35:12',NULL,NULL),('vo9k3mq01u65dlf7m5jbln5lq2',7,'38.104.98.254','2016-02-03 21:52:41','2016-02-03 21:55:17',NULL,NULL),('uv2tcfhqmlkvm3bg6u7d2a89a1',7,'24.12.185.45','2016-03-16 23:53:33','2016-03-16 23:55:18','',''),('11os32e6um907mhorfg727lp93',7,'38.104.98.254','2016-03-18 15:51:11','2016-03-18 16:05:49','',''),('kdu9i6h5ar35n3jqhq39mkopt2',7,'38.104.98.254','2016-03-18 18:20:49','2016-03-18 18:43:25',NULL,NULL),('k8h48oecsm14k7ufnkrjs2nho2',7,'38.104.98.254','2016-03-21 14:22:25','2016-03-21 14:26:11',NULL,NULL),('ss47a9l9qf54prn1odr4h8th51',7,'38.104.98.254','2016-03-24 21:11:58','2016-03-24 21:27:50',NULL,NULL),('clnu6409u9541d4c4unvvmfv72',7,'38.104.98.254','2016-04-05 19:57:21','2016-04-05 19:58:56',NULL,NULL),('r3im40fpk0bu6e1j57muj1v8e6',7,'38.104.98.254','2016-04-15 15:06:43','2016-04-15 15:06:43','',''),('ojod2mub9uhd6oj6d10nvfp8n7',7,'38.104.98.254','2016-04-18 18:13:34','2016-04-18 18:24:59',NULL,NULL),('7afshqeaee97vbcev4svf05450',7,'38.104.98.254','2016-05-02 21:10:50','2016-05-02 21:21:42',NULL,NULL),('hn00r1f8bcnrdpka5bou0vp2t2',7,'38.104.98.254','2016-05-04 15:52:24','2016-05-04 16:11:12',NULL,NULL),('rl4kkp1c7r51evhl55etqjabj4',7,'38.104.98.254','2016-05-05 16:04:03','2016-05-05 16:04:03','',''),('hogmpkst5d665crf0r56b33n97',7,'38.104.98.254','2016-05-09 13:26:52','2016-05-09 13:27:00','',''),('qtb3c2kdkgtp4tb4uljk5lt3f2',7,'38.104.98.254','2016-05-09 21:01:50','2016-05-09 21:20:54',NULL,NULL),('1iot26mnq6b81rqrmrf0l99lq5',7,'38.104.98.254','2016-05-12 14:14:02','2016-05-12 14:14:02','',''),('503f1u453hdvnvjnoengakq6m2',7,'38.104.98.254','2016-05-17 14:29:08','2016-05-17 14:30:00','',''),('n7rqnpgr7utptti7na30tdrtj3',7,'38.104.98.254','2016-05-20 14:26:05','2016-05-20 14:26:25','',''),('d3mp9aec4p2fnabmdegsflgth2',7,'38.104.98.254','2016-06-01 15:55:54','2016-06-01 15:57:03',NULL,NULL),('etfep4hdkr5ttml9ug0asrbrn2',7,'38.104.98.254','2016-06-24 18:07:36','2016-06-24 18:09:12',NULL,NULL),('cqru3nl4h6c66hva91f1hqdgq4',7,'38.104.98.254','2016-06-29 13:17:52','2016-06-29 13:20:41',NULL,NULL),('689r6viro5veeqmr0gsmfolao1',7,'38.104.98.254','2016-07-06 15:40:28','2016-07-06 15:49:31',NULL,NULL),('825qsg2rfuitsomsuu7ohghkl2',7,'38.104.98.254','2016-07-28 13:43:08','2016-07-28 13:53:09',NULL,NULL),('la7ul5u9b94r8ul6nr0uaclb14',7,'38.104.98.254','2016-08-29 19:48:49','2016-08-29 20:01:20',NULL,NULL),('oh0skek4i7as48pnva3lgcd9d0',7,'38.104.98.254','2016-09-14 13:18:51','2016-09-14 13:33:48',NULL,NULL),('escd10tt2s26kuahcev0oluha3',7,'38.104.98.254','2016-09-29 14:17:26','2016-09-29 14:23:34',NULL,NULL),('bt4vijr8quova3rbtei1fm2nk3',7,'38.104.98.254','2016-10-03 21:40:20','2016-10-03 21:41:06',NULL,NULL),('ii627mtbqsgkvf6dqbpk6m43i3',7,'38.104.98.254','2016-11-07 19:37:46','2016-11-07 19:38:53',NULL,NULL),('8uqjfoi6612hl3crc07fpdpea0',7,'38.104.98.254','2016-11-28 15:58:45','2016-11-28 16:12:30',NULL,NULL),('ptho84fn12pcj40ounj22ag394',7,'38.104.98.254','2016-12-06 20:11:13','2016-12-06 20:12:05',NULL,NULL),('vihlrak334e4sqepb0hcm18v75',7,'38.104.98.254','2016-12-12 19:07:27','2016-12-12 19:08:40',NULL,NULL),('meukspkuoeunois552e099g9i2',7,'38.104.98.254','2017-01-03 20:07:58','2017-01-03 20:17:07',NULL,NULL),('ob9bjqnkhf1a3om6oaa4ssfmf1',7,'38.104.98.254','2017-01-30 19:08:21','2017-01-30 19:25:15',NULL,NULL),('6kurlh1a1ghkklf27gddagbna6',7,'38.104.98.254','2017-03-21 17:57:43','2017-03-21 18:00:52',NULL,NULL),('7hu83hbg2ki2pqraj6k5q0t0u0',7,'38.104.98.254','2017-04-06 14:33:23','2017-04-06 14:35:23',NULL,NULL),('oe7lm7q96mevig78rnobjvhtj2',7,'38.104.98.254','2017-04-17 18:00:34','2017-04-17 18:05:07',NULL,NULL),('kjcjtfmrs1star7goce9pmokj3',7,'38.104.98.254','2017-04-19 17:23:52','2017-04-19 17:24:58',NULL,NULL),('hmi5j6quqerra1s55nrubo0uq7',7,'38.104.98.254','2017-04-28 19:09:19','2017-04-28 19:11:22',NULL,NULL),('bsej0su0phdk13j2rqahbj4bi0',7,'38.104.98.254','2017-05-08 19:55:09','2017-05-08 19:55:19',NULL,NULL),('6tf5rh8nssmch6ahqk4fvkaeg6',7,'38.104.98.254','2017-05-15 20:49:06','2017-05-15 20:51:20',NULL,NULL),('btamlh9cf4dlvdne4g6gbq5vq2',7,'38.104.98.254','2017-05-24 14:12:42','2017-05-24 14:15:11',NULL,NULL),('62861g0i4sin3r770n7o4ovgt0',7,'38.104.98.254','2017-06-01 18:22:36','2017-06-01 18:23:35',NULL,NULL),('srshcums9nse94g1gce9npv9k1',7,'38.104.98.254','2017-07-05 17:57:24','2017-07-05 18:16:24',NULL,NULL),('p58mntb9us5hiimp1kvpb09ho1',7,'38.104.98.254','2017-07-12 14:23:33','2017-07-12 14:29:50',NULL,NULL),('1sduqcngb3mjoik0t68t9bl8b2',7,'38.104.98.254','2017-07-19 20:23:33','2017-07-19 20:26:06',NULL,NULL),('9uocoffjo8v1n9i1oa3d4fm6r0',7,'38.104.98.254','2017-07-21 17:08:49','2017-07-21 17:09:31',NULL,NULL),('lq23bh26vd7i4ai54vrmhbuun5',7,'38.104.98.254','2017-08-03 16:23:40','2017-08-03 16:33:49',NULL,NULL),('tf2npehcgmrb17j6tq6hnc5s45',7,'38.104.98.254','2017-08-22 20:41:09','2017-08-22 20:45:12',NULL,NULL),('nosvlejbnm26b6peq33b9hlmn6',7,'38.104.98.254','2017-09-07 15:41:48','2017-09-07 15:55:19',NULL,NULL),('qo7qj4a4ripnk90jlqp3l2ijk1',7,'38.104.98.254','2017-09-13 20:19:16','2017-09-13 20:23:58',NULL,NULL),('j4qmka437gi6240j5d99omokg4',7,'38.104.98.254','2017-10-02 21:01:45','2017-10-02 21:02:57',NULL,NULL),('6rr9qtbspnroaf54mgi3cf01h3',2,'12.39.75.186','2019-01-10 15:48:48','2019-01-10 15:48:48','',''),('22e87abs9rpc5fd57vhlsrejg4',1,'12.39.75.186','2019-01-09 22:36:03','2019-01-09 22:36:03','',''),('5s5n3a1elid5531u4kv6qb5dd3',1,'12.39.75.186','2019-01-09 22:41:54','2019-01-09 22:42:02','',''),('c1c77tsgjc8q4n0hjsisoffva2',2,'96.84.110.226','2019-01-24 23:17:17','2019-01-24 23:17:21','',''),('a096v9q4pfkne95kilv2dl0ih2',1,'12.39.75.186','2019-02-04 17:28:43','2019-02-04 17:28:51','',''),('a4cvmu2sr3t5r1ea6etvkp4q32',1,'174.207.35.162','2025-07-02 13:27:59','2025-07-02 13:36:49','','');

--
-- Table structure for table `sign`
--

CREATE TABLE `sign` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `ID` varchar(20) NOT NULL,
  `site` int(11) NOT NULL,
  `resolution` varchar(10) NOT NULL DEFAULT '1280x720',
  `has_audio` tinyint(1) NOT NULL DEFAULT '0',
  `dedicated` tinyint(1) NOT NULL DEFAULT '0',
  `is_led` tinyint(1) NOT NULL DEFAULT '0',
  `install_date` datetime DEFAULT NULL,
  `last_contact` datetime DEFAULT NULL,
  `ping_missing` datetime DEFAULT NULL,
  `void` tinyint(1) NOT NULL DEFAULT '0',
  `loc_within` varchar(25) DEFAULT NULL,
  `monitor_brand` varchar(25) DEFAULT NULL,
  `monitor_controlType` varchar(5) DEFAULT NULL,
  `playlist` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`index`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sign`
--

INSERT INTO `sign` VALUES (1,'a01b74350d2b132e27f0',8,'720x1280',0,0,0,'2009-03-10 15:53:49','2012-03-09 16:18:31','2013-01-28 16:52:24',0,'NOC','LG','RS232',7),(2,'26f4027740bc8cbb2934',5,'1280x720',0,0,0,'2009-03-10 16:56:09','2025-06-02 12:13:17','2025-06-02 12:45:01',0,'Lobby','Samsung','IR',2),(3,'12f8184ccdd49d796708',1,'1280x720',0,0,0,NULL,'2019-01-09 22:42:20',NULL,0,'None','None','None',0),(4,'5c444f16ca66a5e62ec8',2,'1280x720',0,1,0,NULL,NULL,NULL,0,'Dining Area','LG','IR',3),(5,'57cdbb96ebc91c34b1c4',8,'1280x720',0,1,0,'2009-04-15 17:16:53',NULL,NULL,0,'Brad\'s Laptop','HP','None',4),(6,'f359952e3b25d1e5ce34',9,'1280x720',0,0,0,'2009-11-10 15:09:36','2014-07-15 07:06:44','2014-07-15 07:45:01',0,'Amenities Floor Rack','Various','None',5),(7,'0428a0c56a48f8f16388',10,'1280x720',0,0,0,'0000-00-00 00:00:00','2012-03-09 16:15:37','0000-00-00 00:00:00',0,'Service Lobby','Unknown','None',0),(8,'abf22e454751a662b2ef',5,'720x1280',0,0,0,'0000-00-00 00:00:00','2015-06-25 15:41:45','2014-08-21 17:45:01',0,'1st Floor Elevator','LG','None',6),(9,'0d4a0d0fde58cecfb826',11,'1280x720',0,0,0,'0000-00-00 00:00:00','2019-03-09 23:39:36','2019-03-10 00:15:01',0,'Distrubuted TVs','Toshiba','None',8);

--
-- Table structure for table `site`
--

CREATE TABLE `site` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `concept` int(11) NOT NULL,
  `country` varchar(25) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zip` int(5) NOT NULL,
  `city` varchar(25) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `time_zone` varchar(6) NOT NULL DEFAULT '-00:00',
  `owner` int(11) NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site`
--

INSERT INTO `site` VALUES (1,'Plano Tavern',1,'USA','TX',22222,'Plano','555.555.5555','-01:00',4),(2,'Thalia Spice',3,'USA','IL',60642,'Chicago','555.555.5555','-00:00',3),(3,'Love\'s Yogurt Chicago',4,'USA','IL',60642,'Chicago','555.555.5555','-00:00',2),(4,'Bennigans Hinsdale',2,'USA','IL',66776,'Hinsdale','555.555.5555','-00:00',4),(5,'Integrisys Chicago',7,'USA','IL',60642,'Chicago','312.432.9800','-00:00',1),(6,'Integrisys Miami',7,'USA','FL',80800,'Miami','555.555.5555','+02:00',1),(7,'Integrisys Naples',7,'USA','FL',88088,'Naples','555.555.5555','+02:00',1),(8,'Integricast Demo',6,'USA','IL',48234,'Chicago','847.809.7641','-00:00',1),(9,'225 West Wacker',8,'USA','IL',60601,'Chicago','555.555.555','-06:00',5),(10,'Bermans Infinity',9,'USA','IL',60622,'Chicago','312-000-0000','-06:00',1),(11,'REX Chicago',10,'USA','IL',60606,'Chicago','312-251-3620','-06:00',6);

--
-- Table structure for table `slide`
--

CREATE TABLE `slide` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `site` int(11) NOT NULL,
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bgcolor` varchar(6) NOT NULL DEFAULT '000000',
  `fullscreen` tinyint(1) NOT NULL DEFAULT '0',
  `template` tinyint(1) NOT NULL,
  `created_from` int(11) NOT NULL,
  `twitter` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=437 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slide`
--

INSERT INTO `slide` VALUES (1,'A Black Slide',8,'2016-03-18 18:39:40','000000',0,0,0,NULL),(2,'A Green Slide',8,'2009-10-07 09:22:48','00FF00',0,0,0,NULL),(5,'Gift Cards',8,'2009-10-07 09:20:32','000000',1,0,0,NULL),(6,'Welcome Integrisys',5,'2009-10-05 16:58:59','000000',0,0,0,NULL),(7,'Integrisys Products',5,'2009-10-07 09:22:25','000000',0,0,0,NULL),(8,'Mart Dream Home Image Full',5,'2009-10-05 16:56:40','000000',1,0,0,NULL),(9,'Ritz Kitchen Image',5,'2009-10-05 16:54:45','000000',1,0,0,NULL),(10,'Residences at 900 Touchscreen',5,'2009-10-05 16:57:09','000000',1,0,0,NULL),(11,'Residences at 900 Bathroom',5,'2009-10-05 17:00:17','000000',1,0,0,NULL),(3,'Powered By Integricast',5,'2009-10-05 16:56:51','000000',0,0,0,NULL),(4,'Integrisys Welcomes',5,'2009-10-07 09:17:42','000000',0,0,0,NULL),(13,'Integrisys Commercial',5,'2009-10-05 16:59:34','FF3300',0,0,0,NULL),(14,'Purple Slide',8,'2009-10-27 18:54:45','FF00FF',0,0,0,NULL),(15,'American Sign and Lighting',8,'2009-10-27 18:55:11','0000FF',0,0,0,NULL),(20,'Welcome Fullscreen',9,'2009-10-05 16:53:13','FFFFFF',1,0,0,NULL),(21,'Basic Slide one Image',9,'2009-10-05 16:29:56','FFFFFF',0,1,0,NULL),(19,'Fitness Center',9,'2009-10-05 16:32:55','FFFFFF',0,0,21,NULL),(23,'Integrisys Gray',5,'2009-10-27 18:55:33','FFFFFF',0,0,0,NULL),(24,'Integrisys General A',5,'2009-10-27 18:56:30','333333',0,0,0,NULL),(25,'Conference Room',9,'2009-12-15 18:49:26','FFFFFF',0,0,21,NULL),(26,'Basic Slide no Image',9,'2009-12-23 12:15:19','0000FF',0,1,0,NULL),(27,'Fitness Studio',9,'2009-10-05 16:29:56','FFFFFF',0,0,21,NULL),(28,'Multi-Purpose Room',9,'2019-01-09 19:19:37','FFFFFF',0,0,21,NULL),(29,'Directory',9,'2009-10-27 18:06:13','FFFFFF',0,0,0,NULL),(30,'Kaplan Welcome',9,'2009-10-27 18:54:30','FFFFFF',0,0,0,NULL),(17,'Important Information 1',9,'2009-10-07 09:15:08','0000FF',0,0,26,NULL),(18,'225 Full - Center Img and Head',9,'2009-12-15 17:03:47','000000',1,1,0,NULL),(22,'225 Full Screen with Image 1',5,'2009-12-15 17:03:47','000000',1,0,18,NULL),(34,'BOMA Custom Slide',9,'2009-12-01 13:43:46','0000FF',1,0,0,NULL),(35,'OpenHouse',5,'2009-12-03 14:17:13','000000',1,0,0,NULL),(36,'Holiday09-1',5,'2009-12-14 14:30:27','000000',1,0,0,NULL),(37,'Holiday09-2',5,'2009-12-14 14:31:10','000000',1,0,0,NULL),(38,'IntegrisysHoliday09-3',5,'2009-12-14 14:31:34','000000',1,0,0,NULL),(39,'IntegrisysHoliday09-4',5,'2009-12-14 14:32:01','000000',1,0,0,NULL),(40,'225 Holiday ',9,'2009-12-15 14:29:13','FF0000',1,0,0,NULL),(41,'Holiday Candy Cane Background',9,'2009-12-15 15:18:40','FFFFFF',1,1,0,NULL),(43,'Holiday Snow Stars Background',9,'2009-12-15 15:51:32','FFFFFF',1,1,0,NULL),(32,'Holiday Snowflakes',9,'2009-12-15 17:14:41','FFFFFF',0,1,0,NULL),(45,'Center Image Only',9,'2009-12-15 17:21:53','FFFFFF',1,1,0,NULL),(46,'Full Screen Centered Image',9,'2009-12-16 00:21:24','333333',1,1,0,NULL),(47,'Holiday Candy Cane Background ',5,'2009-12-22 11:28:58','FFFFFF',1,0,41,NULL),(49,'White BG - Center Image',9,'2009-12-17 12:36:01','FFFFFF',1,1,0,NULL),(12,'Simplify - Fullscreen',5,'2010-06-17 10:50:25','FFFFFF',1,0,0,NULL),(53,'Test Berman One',10,'2010-05-25 15:49:13','FFFFFF',0,0,0,NULL),(54,'Tall Slide Test',5,'2010-12-30 13:40:42','333333',0,0,0,NULL),(62,'City of Hope 7',9,'2010-06-23 11:39:08','333333',1,0,46,NULL),(63,'City of Hope 8',9,'2010-06-23 11:39:57','333333',1,0,46,NULL),(64,'City of Hope 9',9,'2010-06-23 11:40:37','333333',1,0,46,NULL),(66,'City of Hope 11',9,'2010-06-23 11:41:51','333333',1,0,46,NULL),(67,'City of Hope 12',9,'2010-06-23 11:42:32','333333',1,0,46,NULL),(68,'City of Hope 13',9,'2010-06-23 11:43:23','333333',1,0,46,NULL),(70,'City of Hope 15',9,'2010-06-23 11:45:01','333333',1,0,46,NULL),(73,'Full Screen Centered Image 2',9,'2011-04-27 16:05:40','333333',1,0,46,NULL),(77,'Fall2010 - Final Event',5,'2010-10-13 09:49:00','333333',1,0,46,NULL),(78,'Holiday 2010-1',5,'2010-12-07 16:54:46','333333',1,0,46,NULL),(79,'Holiday 2010-2',5,'2010-12-07 16:55:36','333333',1,0,46,NULL),(80,'holiday',9,'2010-12-09 11:03:30','333333',1,0,46,NULL),(82,'jackson',9,'2010-12-09 16:07:51','333333',1,0,46,NULL),(83,'Jackson Insurance',9,'2010-12-09 17:13:00','333333',1,0,46,NULL),(84,'Vertical Template Test',5,'2010-12-30 13:45:24','FFFFFF',1,1,0,NULL),(85,'832-Welcome',5,'2010-12-30 14:00:07','FFFFFF',0,0,0,NULL),(86,'832 Holiday Greet 1',5,'2010-12-30 14:15:27','FFFFFF',0,0,0,NULL),(87,'832 Directory List Non-Full',5,'2013-05-09 15:00:37','000000',0,0,0,NULL),(76,'832 Welcome Vertical FULL',5,'2011-04-20 16:48:21','000000',1,0,0,NULL),(42,'BLACK Blank Normal size',5,'2011-01-03 17:31:50','000000',0,0,0,NULL),(33,'IntegrisysSimpliifyTallPgCover',5,'2011-01-03 18:54:46','000000',0,0,0,NULL),(16,'Twitter Feed',5,'2011-01-26 15:16:21','000000',0,1,0,'TEMPLATE'),(81,'CNN Breaking News',5,'2011-04-20 16:23:46','000000',0,0,16,'cnnbrk'),(74,'apple11',9,'2011-04-20 16:47:47','333333',1,0,46,NULL),(75,'Chicago Tribune News',5,'2011-09-13 15:04:17','000000',0,0,16,'chicagotribune'),(50,'Secondepoch Twitter',8,'2011-04-20 15:07:22','000000',0,0,16,'secondepoch'),(88,'san   miguel',9,'2011-03-30 10:24:56','333333',1,0,46,NULL),(89,'ML',9,'2011-04-01 08:40:54','333333',1,0,46,NULL),(71,'slide3',9,'2011-04-07 10:22:54','333333',1,0,46,NULL),(65,'slide6',9,'2011-04-07 11:22:57','333333',1,0,46,NULL),(56,'Twitter Feed Wide',5,'2011-04-20 15:18:43','000000',0,1,0,'TEMPLATE'),(55,'Wide-CNNBrk',5,'2013-04-25 23:04:43','000000',0,0,56,'cnnbrk'),(44,'Wide-ChicagoTribune',5,'2011-09-13 15:04:57','000000',0,0,56,'chicagotribune'),(57,'PowerHouse Welcome Wide',5,'2011-04-20 15:38:31','000000',0,0,0,NULL),(72,'PowerHouse Welcome Tall',5,'2011-04-20 15:41:16','000000',0,0,0,NULL),(59,'PowerHouseTallFull',5,'2011-04-20 21:19:14','000000',1,0,0,NULL),(97,'apple1',9,'2011-06-01 15:25:28','333333',1,0,46,NULL),(99,'Full Screen Centered Image 3',9,'2011-06-01 15:28:05','333333',1,0,46,NULL),(100,'Full Screen Centered Image 4',9,'2011-06-01 15:28:58','333333',1,0,46,NULL),(98,'Full Screen Centered Image 6',9,'2011-06-01 15:35:34','333333',1,0,46,NULL),(90,'Full Screen Centered Image 10',9,'2011-06-01 15:42:36','333333',1,0,46,NULL),(91,'Full Screen Centered Image 11',9,'2011-06-01 15:46:39','333333',1,0,46,NULL),(96,'Full Screen Centered Image 12',9,'2011-06-01 16:16:41','333333',1,0,46,NULL),(102,'Integrisys Twitter',5,'2011-06-27 14:23:08','000000',0,0,16,'integrisys'),(103,'Twitter Feed Wide Integrisys',5,'2011-06-27 14:23:54','000000',0,0,56,'integrisys'),(104,'Commercial Clients',5,'2011-07-08 18:06:31','FFFFFF',0,0,0,NULL),(105,'Corporate Concierge Services',9,'2011-09-14 09:26:08','000000',1,0,18,NULL),(101,'Integrisys Open House \\\'11 1',5,'2011-10-20 14:35:39','000000',1,0,0,NULL),(48,'Integrisys Open House 1',5,'2011-10-20 15:32:05','000000',1,0,0,NULL),(60,'Integrisys Open House \\\'11 2',5,'2011-10-20 14:36:32','000000',1,0,0,NULL),(58,'Integrisys Open House \\\'11 3',5,'2011-10-20 14:37:20','000000',1,0,0,NULL),(31,'Integrisys Open House 2',5,'2011-10-20 15:32:44','000000',1,0,0,NULL),(95,'Integrisys Open House 3',5,'2011-10-20 15:33:00','000000',1,0,0,NULL),(94,'Integrisys Open House 4',5,'2011-10-20 15:33:26','000000',1,0,0,NULL),(93,'Integrisys Open House 5',5,'2011-10-20 15:33:43','000000',1,0,0,NULL),(92,'Integrisys Open House 6',5,'2011-10-20 15:34:12','000000',1,0,0,NULL),(69,'Integrisys Open House 7',5,'2011-10-20 15:35:03','000000',1,0,0,NULL),(61,'Integrisys Open House 9',5,'2011-10-20 15:35:48','000000',1,0,0,NULL),(52,'New Slide',5,'2012-10-10 11:09:21','000000',0,0,0,NULL),(106,'PAD ACRED',9,'2013-08-12 22:46:48','333333',1,0,46,NULL),(107,'pad accredidation',9,'2013-08-12 22:49:14','333333',1,0,46,NULL),(108,'PAD ACCED REALLY',9,'2013-08-12 22:50:31','333333',1,0,46,NULL),(109,'aep acred',9,'2013-08-12 22:53:40','333333',1,0,46,NULL),(110,'aep main',9,'2014-01-14 17:09:45','333333',1,0,46,NULL),(111,'aep cubs',9,'2014-01-14 17:16:56','333333',1,0,46,NULL),(113,'aep affinity',9,'2013-08-12 22:56:51','333333',1,0,46,NULL),(114,'aep values',9,'2013-08-12 22:58:22','333333',1,0,46,NULL),(115,'August Bdays',11,'2013-08-15 20:12:09','FFFFFF',0,0,0,NULL),(116,'Rex Logo Full Blue BG',11,'2013-08-20 22:20:02','FFFFFF',1,0,0,NULL),(117,'TEST 1',11,'2013-08-20 22:30:48','333333',0,0,0,NULL),(118,'TEST 2',11,'2013-08-20 22:32:01','FFFFFF',0,0,0,NULL),(119,'August Bdays',11,'2013-08-20 23:40:20','FFFFFF',0,0,0,NULL),(120,'August 2013 Bdays',11,'2013-08-20 23:45:44','FFFFFF',0,0,0,NULL),(121,'REX-TV Standard',11,'2019-01-09 19:22:54','333333',0,1,0,NULL),(123,'Avon-REX Gives Back',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(124,'Quotes 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(125,'AAB-06AUG13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(126,'AAB-16AUG13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(127,'AAB-22AUG13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(128,'AUG13-Profile1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(129,'AUG13-Profile2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(130,'AUG13-Profile3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(132,'AUG13-Profile5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(133,'IT-Helpdesk',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(134,'AUG13-Profile6',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(135,'Rex Gives Back off the streets',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(131,'AUG13-Profile4-2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(136,'AUG13-Profile7a',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(137,'AUG13-Profile8',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(138,'AUG13-Profile9',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(139,'Safety First-Safety Always',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(140,'Rex Welcomes',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(141,'New Website',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(142,'AAB-05SEP13-Jeff Platt',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(143,'REX In The News SEPT13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(144,'Snapshots-EricS',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(145,'REX-Gives Back-BrightPromise',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(146,'AAB-31OCT-Denise-Jeff',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(147,'AAB-31OCT-JoeC',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(148,'AAB-31OCT-GV',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(149,'AAB-NOV13-JohnMcNulty',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(150,'AAB-NOV13-Jim Venegas',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(151,'AAB-NOV13-LandisWakefield',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(152,'NOV13-Milestone1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(153,'NOV13-Milestone2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(154,'NOV13-Milestone3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(155,'NOV13-Milestone4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(156,'NOV13-Milestone5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(157,'Recent Additions DEC2013',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(51,'SCN-Top 50',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(112,'225 Full - Center Img and Head',9,'2014-01-14 18:46:57','000000',1,0,18,NULL),(159,'JAN-2014 Joe-BOMA',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(158,'Snapshots-Jessica L FEB2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(160,'REX-ReACT 2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(161,'Snapshots-BradW-APR2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(162,'2014 Golf Classic',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(163,'04-14 Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(164,'REX-ReACT MAY 2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(165,'2014 May Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(166,'15MAY14-HappyHour-ReAct',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(167,'2014 Cinco De Mayo',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(168,'2014 June Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(169,'Golf Classic Photo',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(170,'AAB-June2014-Pullin',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(171,'AAB-June2014-LandisWakefield',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(172,'2014 July Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(173,'DuckyIceCream2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(174,'2014 August Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(175,'DuckyPhotos',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(176,'August Happy Hour',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(177,'2014 September Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(178,'2014-October-Bdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(179,'Welcome Oct 2014',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(180,'2014-November-Bdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(181,'2014 December Bdays-Coming Soo',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(182,'REX-TV Standard 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(183,'December2014-bdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(184,'SIDEDISH1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(185,'SIDEDISH2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(186,'SIDEDISH3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(187,'XMAS1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(188,'XMAS2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(189,'XMAS3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(190,'White Elephant',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(191,'White Elephant pic 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(192,'White Elephant pic 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(193,'January 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(194,'January 2015.2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(195,'SCN Award 15',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(196,'Marissa Bosco',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(197,'FEB Birthday 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(198,'Valentines Day',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(199,'FEB Trivia 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(200,'FEB Trivia 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(201,'FEB Trivia 3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(202,'FEB Trivia 4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(203,'FEB Trivia 5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(204,'Rolling Bean',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(205,'t 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(206,'t2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(207,'t3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(208,'t4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(209,'t5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(210,'t6',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(211,'2015 MARCH',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(212,'MT1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(213,'MT2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(214,'MT3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(215,'MT3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(216,'MT4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(217,'Daylight Savings Time',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(218,'March Birthdays 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(219,'REX-TV Standard 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(220,'March 17.1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(221,'March 17.2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(222,'March 17.3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(223,'March 17.4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(224,'March 17.5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(225,'Bingo Sheet',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(226,'slide 1 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(227,'tc zcolo',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(228,'Charity 1 to 5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(229,'April Birthdays 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(122,'NCAA Bracket Winner JDavidson',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(230,'testimonial.mmart',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(231,'ncaa tournament winner',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(232,'April Birthday 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(233,'sunstar',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(234,'sunstar 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(235,'Summer Hours ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(236,'Summer Hours 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(237,'may 2015 bday',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(238,'Jenna and Jake',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(239,'Employee of the Month',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(240,'Employee of the Month - Army G',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(241,'EOM Army Guy',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(242,'Customer Testimonial - CBRE',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(243,'Customer Testimonial #2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(244,'DROSE MEME',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(245,'drose 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(246,'Ermco ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(247,'June Birthdays 15',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(248,'2015 GOLF OUTING ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(249,'GROUP OUTING PHOTO 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(250,'retirement party 1 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(251,'RETIREMENT PARTY 1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(252,'RETIREMENT PARTY 2 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(253,'EOTM VINCE ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(254,'EOTM VINCE P.',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(255,'ct ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(256,'ct valenti',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(257,'ct',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(258,'ct.3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(259,'ct',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(260,'ct.4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(261,'ct.5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(262,'duck derby',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(263,'ice cream social',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(264,'July Birthdays 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(265,'duck derby 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(266,'BSPEARMAN EOM',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(267,'Town Hall Meeting ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(268,'town hall 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(269,'Duck Derby ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(270,'CLARK AFTER DARK',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(271,'CLARK AFTER DARK 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(272,'EOTM BRYAN KINGSLEY',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(273,'IT OFFICE 365',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(274,'August Birthdays ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(275,'DUCK DERBY WINNER ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(276,'August Birthdays . 2 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(277,'CPS Headquarters',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(278,'September BDAY 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(279,'sept bdays 2015',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(280,'Mark Cuban',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(281,'AUGUST EOM',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(282,'BOSCO TAILGATING ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(283,'BOSCO TAILGATING 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(284,'October Birthdays',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(285,'EOM-Shanna',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(286,'Turner Golf Outing',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(287,'1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(288,'2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(289,'3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(290,'12',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(291,'13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(292,'14',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(293,'215',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(294,'Holiday Party',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(295,'baseball',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(296,'Employee of the Month winning ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(297,'daylight savings time ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(298,'mlb playoffs ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(299,'CT.TONY',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(300,'CT TONY ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(301,'HALLOWEEN',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(302,'HALLOWEEN 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(303,'HALLOWEEN.32',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(304,'REX-TV Standard 3',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(305,'MLB 4 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(306,'REX-TV Standard 4',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(307,'REX-TV Standard 5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(308,'EOM DAN M. ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(309,'EOM MICHELE',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(310,'EOM MICHELE 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(311,'3.1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(312,'3.1',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(313,'eom 2',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(314,'5',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(315,'7',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(316,'rr',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(317,'DEC 15',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(318,'JANBDAYS16',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(319,'PROJECT-AMALGAMATED',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(320,'WELLS FARGO',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(321,'DEPAUL THEATRE',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(322,'ONE NORTH INTERACTIVE',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(323,'ONE NORTH INTERACTIVE',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(324,'KELLOG',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(325,'PRUDENTIAL PLAZA',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(326,'AMALGAMATED BANK.2 ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(327,'EOM GROUP',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(328,'EOM CARICATURES ALL ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(329,'EOM TOM PAYTON - JAN',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(330,'FEB BDAYS ',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(331,'junk slide',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(332,'another full screen slide',11,'2016-03-18 18:41:52','333333',0,0,46,NULL),(333,'REX-TV Standard 6',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(334,'REX-TV Standard 7',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(336,'REX-TV Standard 9',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(337,'REX-TV Standard 10',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(338,'REX-TV Standard 11',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(335,'REX-TV Standard 12',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(339,'REX-TV Standard 8',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(340,'REX-TV Standard 13',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(341,'REX-TV Standard 14',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(342,'REX-TV Standard 15',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(343,'REX-TV Standard 16',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(344,'REX-TV Standard 17',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(345,'REX-TV Standard 18',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(346,'REX-TV Standard 19',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(347,'REX-TV Standard 20',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(348,'REX-TV Standard 21',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(349,'REX-TV Standard 22',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(350,'REX-TV Standard 23',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(351,'REX-TV Standard 24',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(352,'REX-TV Standard 25',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(353,'REX-TV Standard 26',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(354,'REX-TV Standard 27',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(355,'REX-TV Standard 28',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(356,'REX-TV Standard 29',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(357,'REX-TV Standard 30',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(358,'REX-TV Standard 31',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(359,'REX-TV Standard 32',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(360,'REX-TV Standard 33',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(361,'REX-TV Standard 34',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(362,'REX-TV Standard 35',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(363,'REX-TV Standard 36',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(364,'REX-TV Standard 37',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(365,'REX-TV Standard 38',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(366,'REX-TV Standard 39',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(367,'REX-TV Standard 40',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(368,'REX-TV Standard 41',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(369,'REX-TV Standard 42',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(370,'REX-TV Standard 43',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(371,'REX-TV Standard 44',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(372,'REX-TV Standard 45',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(373,'REX-TV Standard 46',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(374,'REX-TV Standard 47',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(375,'REX-TV Standard 48',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(376,'REX-TV Standard 49',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(377,'REX-TV Standard 50',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(378,'REX-TV Standard 51',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(379,'REX-TV Standard 52',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(380,'REX-TV Standard 53',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(381,'REX-TV Standard 54',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(382,'REX-TV Standard 55',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(383,'REX-TV Standard 56',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(384,'REX-TV Standard 57',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(385,'REX-TV Standard 58',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(386,'REX-TV Standard 59',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(387,'REX-TV Standard 60',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(388,'REX-TV Standard 61',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(389,'REX-TV Standard 62',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(390,'REX-TV Standard 63',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(391,'REX-TV Standard 64',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(392,'REX-TV Standard 65',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(393,'REX-TV Standard 66',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(394,'REX-TV Standard 67',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(395,'REX-TV Standard 68',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(396,'REX-TV Standard 69',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(397,'REX-TV Standard 70',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(398,'REX-TV Standard 71',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(399,'REX-TV Standard 72',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(400,'REX-TV Standard 73',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(401,'REX-TV Standard 74',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(402,'Full Screen Centered Image 1',11,'2017-04-21 16:41:00','333333',1,0,46,NULL),(403,'REX-TV Standard 75',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(404,'REX-TV Standard 76',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(405,'REX-TV Standard 77',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(406,'REX-TV Standard 78',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(407,'REX-TV Standard 79',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(408,'REX-TV Standard 80',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(409,'REX-TV Standard 81',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(410,'REX-TV Standard 82',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(411,'REX-TV Standard 83',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(412,'REX-TV Standard 84',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(413,'REX-TV Standard 85',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(414,'REX-TV Standard 86',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(415,'REX-TV Standard 87',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(416,'REX-TV Standard 88',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(417,'REX-TV Standard 89',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(418,'REX-TV Standard 90',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(419,'REX-TV Standard 91',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(420,'REX-TV Standard 92',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(421,'REX-TV Standard 93',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(422,'REX-TV Standard 94',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(423,'REX-TV Standard 95',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(424,'REX-TV Standard 96',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(425,'REX-TV Standard 97',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(426,'REX-TV Standard 98',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(427,'REX-TV Standard 99',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(428,'REX-TV Standard 100',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(429,'REX-TV Standard 101',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(430,'REX-TV Standard 102',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(431,'REX-TV Standard 103',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(432,'REX-TV Standard 104',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(433,'REX-TV Standard 105',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(434,'REX-TV Standard 106',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(435,'REX-TV Standard 107',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL),(436,'REX-TV Standard 108',11,'2019-01-09 19:22:54','FFFFFF',0,0,121,NULL);

--
-- Table structure for table `slide_image`
--

CREATE TABLE `slide_image` (
  `slide` int(11) NOT NULL,
  `image` int(11) NOT NULL,
  `locx` int(11) NOT NULL,
  `locy` int(11) NOT NULL,
  `drawOrder` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slide_image`
--

INSERT INTO `slide_image` VALUES (2,1,0,0,0),(2,2,100,100,1),(5,3,0,0,0),(7,5,0,0,0),(6,4,0,0,0),(8,6,0,0,0),(9,7,0,0,0),(10,9,0,0,0),(11,8,0,0,0),(3,10,0,0,0),(4,11,0,0,0),(1,12,10,10,1),(13,13,0,0,1),(20,14,0,0,0),(21,15,0,0,0),(25,15,0,0,0),(19,15,0,0,0),(19,16,39,248,1),(28,15,0,0,0),(24,11,0,0,0),(21,17,39,248,2),(23,11,0,0,0),(25,18,39,248,2),(27,19,39,248,2),(26,23,0,0,0),(28,21,39,248,2),(27,15,0,0,0),(29,23,0,0,0),(29,22,0,183,1),(30,25,190,300,1),(30,23,0,0,0),(17,23,0,0,0),(18,26,0,0,0),(18,17,551,149,1),(22,27,450,280,1),(22,26,0,0,0),(45,17,550,150,1),(45,26,0,0,0),(34,31,0,0,0),(35,32,0,0,0),(36,33,0,0,0),(37,34,0,0,0),(38,35,0,0,0),(39,36,0,0,0),(40,38,0,0,0),(41,40,0,0,0),(43,39,0,0,0),(32,29,0,0,0),(47,40,0,0,0),(46,41,0,0,1),(49,17,420,173,1),(12,47,0,0,0),(62,56,0,0,1),(63,57,0,0,1),(64,58,0,0,1),(66,60,0,0,1),(67,61,0,0,1),(68,62,0,0,1),(110,103,0,0,1),(70,64,0,0,1),(114,107,0,0,1),(73,51,0,0,1),(77,69,0,0,1),(78,70,0,0,1),(79,71,0,0,1),(80,72,0,0,1),(82,74,0,0,1),(83,75,0,0,1),(86,78,0,0,1),(85,77,0,0,2),(87,46,0,0,1),(76,28,0,0,1),(33,30,0,0,1),(16,73,0,0,1),(81,73,0,0,1),(74,66,0,0,1),(88,79,0,0,1),(113,106,0,0,1),(89,80,0,0,1),(81,43,85,250,3),(16,43,85,250,3),(75,73,0,0,1),(75,43,85,250,3),(50,73,0,0,1),(50,43,85,250,3),(112,105,551,149,1),(71,65,0,0,1),(65,59,0,0,1),(55,43,163,88,1),(55,49,0,0,0),(56,49,0,0,0),(56,43,163,88,1),(44,49,0,0,0),(44,43,163,88,1),(57,50,0,0,1),(72,48,0,0,1),(59,53,0,0,1),(97,88,0,0,1),(99,90,0,0,1),(100,91,0,0,1),(107,100,0,0,1),(98,89,0,0,1),(109,102,0,0,1),(111,104,0,0,1),(90,81,0,0,1),(91,82,0,0,1),(96,87,0,0,1),(106,99,0,0,1),(102,73,0,0,1),(102,43,85,250,3),(103,49,0,0,0),(103,43,163,88,1),(104,93,0,0,1),(105,94,551,149,1),(105,26,0,0,0),(101,98,0,0,1),(60,85,0,0,1),(58,55,0,0,1),(48,63,0,0,0),(31,92,0,0,0),(95,54,0,0,0),(94,52,0,0,0),(93,42,0,0,0),(92,67,0,0,0),(69,86,0,0,0),(108,101,0,0,1),(61,84,0,0,0),(116,110,0,0,0),(115,109,0,0,1),(115,108,0,0,0),(120,113,0,0,1),(163,156,0,0,1),(119,112,0,0,2),(119,111,0,0,1),(121,113,0,0,1),(123,115,0,0,1),(124,116,0,0,1),(125,117,0,0,1),(126,118,0,0,1),(127,119,0,0,1),(128,120,0,0,1),(129,121,0,0,1),(130,122,0,0,1),(136,128,0,0,1),(132,124,0,0,1),(133,125,0,0,1),(134,126,0,0,1),(135,127,0,0,1),(131,123,0,0,1),(137,129,0,0,1),(138,130,0,0,1),(139,131,0,0,1),(140,132,0,0,1),(141,133,0,0,1),(142,134,0,0,1),(143,135,0,0,1),(144,136,0,0,1),(145,137,0,0,1),(146,138,0,0,1),(147,139,0,0,1),(148,140,0,0,1),(149,141,0,0,1),(150,142,0,0,1),(151,143,0,0,1),(152,144,0,0,1),(153,145,0,0,1),(154,146,0,0,1),(155,147,0,0,1),(156,148,0,0,1),(157,149,0,0,1),(51,44,0,0,1),(112,26,0,0,0),(160,153,0,0,1),(159,151,0,0,1),(158,152,0,0,1),(161,154,0,0,1),(162,155,0,0,1),(230,222,0,0,1),(164,157,0,0,1),(165,158,0,0,1),(166,159,0,0,1),(167,160,0,0,1),(168,161,0,0,1),(169,162,0,0,1),(170,163,0,0,1),(171,164,0,0,1),(172,165,0,0,1),(173,166,0,0,1),(174,167,0,0,1),(175,168,0,0,1),(176,169,0,0,1),(177,170,0,0,1),(178,171,0,0,1),(179,172,0,0,1),(180,173,0,0,1),(181,174,0,0,1),(182,175,0,0,1),(183,176,0,0,1),(184,177,0,0,1),(185,178,0,0,1),(186,179,0,0,1),(187,180,0,0,1),(188,181,0,0,1),(189,182,0,0,1),(190,183,0,0,1),(191,184,0,0,1),(192,185,0,0,1),(193,186,0,0,1),(194,187,0,0,1),(195,189,0,0,1),(196,190,0,0,1),(197,191,0,0,1),(198,192,0,0,1),(199,193,0,0,1),(200,194,0,0,1),(201,195,0,0,1),(202,196,0,0,1),(203,197,0,0,1),(204,198,0,0,1),(205,199,0,0,1),(206,200,0,0,1),(207,201,0,0,1),(208,202,0,0,1),(209,203,0,0,1),(210,204,0,0,1),(211,205,0,0,1),(212,206,0,0,1),(213,207,0,0,1),(214,113,0,0,1),(215,208,0,0,1),(216,209,0,0,1),(217,210,0,0,1),(218,211,0,0,1),(219,212,0,0,1),(220,113,0,0,1),(221,213,0,0,1),(222,214,0,0,1),(223,215,0,0,1),(224,216,0,0,1),(225,217,0,0,1),(226,218,0,0,1),(227,219,0,0,1),(228,220,0,0,1),(229,221,0,0,1),(231,223,0,0,1),(122,114,0,0,1),(232,224,0,0,1),(233,225,0,0,1),(234,226,0,0,1),(235,227,0,0,1),(236,228,0,0,1),(237,229,0,0,1),(238,230,0,0,1),(239,231,0,0,1),(240,232,0,0,1),(241,233,0,0,1),(242,234,0,0,1),(243,235,0,0,1),(244,236,0,0,1),(245,237,0,0,1),(246,238,0,0,1),(247,239,0,0,1),(248,240,0,0,1),(249,241,0,0,1),(250,242,0,0,1),(251,243,0,0,1),(252,244,0,0,1),(253,113,0,0,1),(254,245,0,0,1),(255,246,0,0,1),(256,247,0,0,1),(257,113,0,0,1),(258,248,0,0,1),(259,249,0,0,1),(260,250,0,0,1),(261,251,0,0,1),(262,252,0,0,1),(263,253,0,0,1),(264,254,0,0,1),(265,255,0,0,1),(266,256,0,0,1),(267,257,0,0,1),(268,258,0,0,1),(269,259,0,0,1),(270,260,0,0,1),(271,261,0,0,1),(272,262,0,0,1),(273,263,0,0,1),(274,264,0,0,1),(275,265,0,0,1),(276,266,0,0,1),(277,267,0,0,1),(278,268,0,0,1),(279,269,0,0,1),(280,270,0,0,1),(281,271,0,0,1),(282,113,0,0,1),(283,272,0,0,1),(284,273,0,0,1),(285,274,0,0,1),(286,275,0,0,1),(287,276,0,0,1),(288,277,0,0,1),(289,278,0,0,1),(290,279,0,0,1),(291,280,0,0,1),(292,281,0,0,1),(293,282,0,0,1),(294,283,0,0,1),(295,284,0,0,1),(296,285,0,0,1),(297,286,0,0,1),(298,287,0,0,1),(299,288,0,0,1),(300,289,0,0,1),(301,290,0,0,1),(302,291,0,0,1),(303,292,0,0,1),(304,293,0,0,1),(305,294,0,0,1),(306,295,0,0,1),(307,296,0,0,1),(308,297,0,0,1),(309,298,0,0,1),(310,299,0,0,1),(311,300,0,0,1),(312,301,0,0,1),(313,302,0,0,1),(314,303,0,0,1),(315,304,0,0,1),(316,305,0,0,1),(317,306,0,0,1),(318,307,0,0,1),(319,308,0,0,1),(320,309,0,0,1),(321,310,0,0,1),(322,354,0,0,1),(323,311,0,0,1),(324,312,0,0,1),(325,313,0,0,1),(326,314,0,0,1),(327,315,0,0,1),(328,316,0,0,1),(329,317,0,0,1),(330,318,0,0,1),(332,320,0,0,1),(331,319,0,0,1),(333,321,0,0,1),(334,322,0,0,1),(339,327,0,0,1),(336,324,0,0,1),(337,325,0,0,1),(338,326,0,0,1),(335,323,0,0,1),(340,328,0,0,1),(341,329,0,0,1),(342,330,0,0,1),(343,331,0,0,1),(344,332,0,0,1),(345,333,0,0,1),(346,334,0,0,1),(347,335,0,0,1),(348,336,0,0,1),(349,337,0,0,1),(350,338,0,0,1),(351,339,0,0,1),(352,340,0,0,1),(353,341,0,0,1),(354,342,0,0,1),(355,343,0,0,1),(356,344,0,0,1),(357,345,0,0,1),(358,346,0,0,1),(359,347,0,0,1),(360,348,0,0,1),(361,349,0,0,1),(362,350,0,0,1),(363,351,0,0,1),(364,352,0,0,1),(365,353,0,0,1),(366,355,0,0,1),(367,356,0,0,1),(368,357,0,0,1),(369,358,0,0,1),(370,359,0,0,1),(371,360,0,0,1),(372,361,0,0,1),(373,362,0,0,1),(374,363,0,0,1),(375,364,0,0,1),(376,365,0,0,1),(377,366,0,0,1),(378,367,0,0,1),(379,368,0,0,1),(380,369,0,0,1),(381,370,0,0,1),(382,371,0,0,1),(383,372,0,0,1),(384,373,0,0,1),(385,374,0,0,1),(386,375,0,0,1),(387,376,0,0,1),(388,377,0,0,1),(389,378,0,0,1),(390,379,0,0,1),(391,380,0,0,1),(392,381,0,0,1),(393,382,0,0,1),(394,383,0,0,1),(395,384,0,0,1),(396,385,0,0,1),(397,386,0,0,1),(398,387,0,0,1),(399,388,0,0,1),(400,389,0,0,1),(401,390,0,0,1),(402,391,0,0,1),(403,392,0,0,1),(404,393,0,0,1),(405,394,0,0,1),(406,395,0,0,1),(407,396,0,0,1),(408,397,0,0,1),(409,398,0,0,1),(410,399,0,0,1),(411,400,0,0,1),(412,401,0,0,1),(413,402,0,0,1),(414,403,0,0,1),(415,404,0,0,1),(416,405,0,0,1),(417,406,0,0,1),(418,407,0,0,1),(419,408,0,0,1),(420,409,0,0,1),(421,410,0,0,1),(422,411,0,0,1),(423,412,0,0,1),(424,413,0,0,1),(425,414,0,0,1),(426,415,0,0,1),(427,416,0,0,1),(428,417,0,0,1),(429,418,0,0,1),(430,419,0,0,1),(431,420,0,0,1),(432,421,0,0,1),(433,422,0,0,1),(434,423,0,0,1),(435,424,0,0,1),(436,425,0,0,1);

--
-- Table structure for table `slide_image_file`
--

CREATE TABLE `slide_image_file` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `concept` int(11) NOT NULL,
  `is_bg` tinyint(1) NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=426 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slide_image_file`
--

INSERT INTO `slide_image_file` VALUES (1,'Bennigans Green',6,1),(2,'A Beer',6,0),(3,'Gift Cards',0,1),(4,'Integrisys Welcome',7,0),(5,'Integrisys Products',7,0),(6,'Merchandise Mart Media Room',7,0),(7,'Ritz Kitchen Image',7,0),(8,'Residences at 900 Bath',7,0),(9,'Residences at 900 Touchscreen',7,0),(10,'Powered By Integricast Image',7,0),(11,'Integrisys Gradient Background',7,1),(12,'Firefox Crash',0,0),(13,'Commercial ',7,0),(14,'225 Welcome Slide',8,1),(15,'Template-1-BG',8,1),(16,'Spin Class Image',8,0),(17,'Placeholder',0,0),(18,'Meeting',0,0),(19,'spin-class',0,0),(20,'gym',0,0),(21,'meeting_room2',0,0),(22,'Amenities Floor Map',8,0),(23,'225 Basic Blue BG',8,1),(24,'Kaplan Logo',8,0),(25,'Kaplan 2',8,0),(26,'225 blank super',8,1),(27,'kaplan-logo2',0,0),(31,'Boma Fullscreen Custom',8,1),(32,'IG Open House 09',7,1),(33,'IntegrisysHoliday09-1',7,1),(34,'IntegrisysHoliday09-2',7,1),(35,'IntegrisysHoliday09-3',7,1),(36,'IntegrisysHoliday09-4',7,1),(37,'225 Happy Holidays',8,1),(38,'225WackerHoliday2',8,1),(39,'Snow Stars',0,1),(40,'Candy Canes',0,1),(29,'Snowflakes',0,1),(41,'Placeholder - Fullscreen',0,0),(45,'jones_lang_lasalle',0,0),(47,'Integrisys Simplify Full',7,1),(56,'Slide7',0,0),(57,'Slide8',0,0),(58,'Slide9',0,0),(60,'Slide11',0,0),(61,'Slide12',0,0),(62,'Slide13',0,0),(64,'Slide15',0,0),(69,'FINAL-Integrisys-Fall-2010-Eve',0,0),(70,'Digital-Sign-1',0,0),(71,'Digital-Sign-2',0,0),(72,'Office of the Building Holiday',0,0),(74,'JACKSON-NLIC-RGB (2)',0,0),(75,'225-jackson',0,0),(76,'New Image',7,0),(77,'832-Vertical-Welcome Logo',7,0),(78,'832 Holiday Greet 1 Orange',7,0),(68,'832 directory - Jan2011',7,0),(28,'832 Welcome Vertical FULL',7,0),(30,'IntegrisysSimpliifyTallPgCover',7,0),(73,'Integricast Twitter',0,0),(66,'rmm',0,0),(43,'45x45 Twitter',0,0),(79,'Logo',0,0),(80,'ML Logo (2)',0,0),(65,'Slide3',0,0),(59,'Slide6',0,0),(49,'Integrisys Twitter Widescreen',7,1),(50,'PowerHouse Welcome Wide',7,0),(48,'PowerHouse Welcome Tall',7,0),(53,'PowerHouseFullTall',7,0),(51,'MC',0,0),(88,'100_1159',0,0),(90,'100_2185',0,0),(91,'100_2292',0,0),(89,'XmFFRo5kk7B2H4CukMozMsDEmK21zr',0,0),(81,'100_1159',0,0),(82,'IMG_0540',0,0),(87,'IMG_0480',0,0),(93,'Integrisys Commercial Clients',7,0),(94,'CCS',0,0),(98,'Integrisys Open House Vert 1',7,0),(85,'Integrisys Open House Vert 2',7,0),(55,'Integrisys Open House Vert 3',7,0),(63,'Integrisys Open House 1',7,1),(92,'Integrisys Open House 2',7,1),(54,'Integrisys Open House 3',7,1),(52,'Integrisys Open House 4',7,1),(42,'Integrisys Open House 5',7,1),(67,'Integrisys Open House 6',7,1),(86,'Integrisys Open House 7',7,1),(84,'Integrisys Open House 9',7,1),(97,'832 Directory April 2012',7,0),(96,'832 Directory October 2012',7,0),(83,'832 Directory October 2012a',7,0),(95,'832 Directory Jan 2013',7,0),(46,'832 Vertical May 2013',7,0),(99,'PAD SLIDES acredidation',0,0),(100,'PAD SLIDES acredidation',0,0),(101,'PAD SLIDES acredidation',0,0),(102,'PAD SLIDES acredidation',0,0),(106,'PAD SLIDES affinity',0,0),(107,'PAD SLIDES values',0,0),(108,'REX Welcome Base Full',10,1),(109,'August Bdays',10,0),(110,'REX-TV-Full',10,1),(111,'Shade-Blue-BG',10,0),(112,'Style-1-Blue',0,0),(113,'Placeholder - REX',10,0),(115,'Avon',0,0),(116,'quotes1',0,0),(117,'AAB-06AUG13',0,0),(118,'AAB-16AUG13',0,0),(119,'AAB-22AUG13',0,0),(120,'Slide1',0,0),(121,'Slide2',0,0),(122,'Slide3',0,0),(124,'Slide5',0,0),(125,'Slide6',0,0),(126,'Style-3-Profiles',0,0),(127,'Off the streets',0,0),(123,'Slide4',0,0),(128,'Slide8',0,0),(129,'Slide9',0,0),(130,'Slide10',0,0),(132,'REXWelcomes-9SEP2013',0,0),(133,'new-website',0,0),(134,'AAB-05SEP2013',0,0),(131,'Safety2-REX',0,0),(135,'REXInTheNews-SEPT13',0,0),(136,'Snapshots-Eric S-Hannah',0,0),(137,'BrightPromise',0,0),(138,'AAB-31OCt-Denise-Jeff',0,0),(139,'AAB-31OCT-JoeC',0,0),(140,'AAB-31OCT-GV',0,0),(141,'AAB-NOV13-JohnMcNulty',0,0),(142,'AAB-NOV13-JimVenegas',0,0),(143,'AAB-NOV13-LandisWakefields',0,0),(144,'Slide4',0,0),(145,'Slide5',0,0),(146,'Slide6',0,0),(147,'Slide7',0,0),(148,'Slide8',0,0),(149,'Recent-Additions-DEC2013',0,0),(44,'SCN-top-50-rex',0,0),(103,'Sales_Launch_Agenda_v3',0,0),(104,'Sales_Launch_Agenda_v3',0,0),(105,'Sales_Launch_Agenda_v3',0,0),(151,'JAN2014-Joe-BOMA-Award',0,0),(150,'REX-ReAct-2014 Activities2',0,0),(152,'Snapshots-FEB14-JessicaL',0,0),(153,'REX-ReAct-2014 Activities2',0,0),(154,'Snapshots-APR14-BradW',0,0),(155,'APR2014-GolfClassic',0,0),(156,'April2014-Bdays4',0,0),(157,'REX ReACT MAY 2014-1',0,0),(158,'MAY2014-Bdays',0,0),(159,'15MAY14-HappyHourReAct',0,0),(160,'2014CincoDeMayo',0,0),(161,'2014JuneBdays',0,0),(162,'Rex-Golf-Team-Photo',0,0),(163,'02JUN14-AAB-Pullin',0,0),(164,'03JUN14-AAB-Wakefield-Landis',0,0),(165,'2014JulyBdays',0,0),(166,'Ducky2014',0,0),(167,'2014AUGUSTBdays',0,0),(168,'DuckyPics',0,0),(169,'HappyHourAug2014',0,0),(170,'2014SeptBirthdays',0,0),(171,'2014OctoberBdays',0,0),(172,'newemployees',0,0),(173,'2014-November-Bdays',0,0),(174,'december',0,0),(175,'December2014-Bdays',0,0),(176,'December2014-Bdays',0,0),(177,'side dish cook off 1',0,0),(178,'side dish cook off 2',0,0),(179,'side dish cook off 3',0,0),(180,'xmas1',0,0),(181,'xmas2',0,0),(182,'xmas3',0,0),(183,'White Elephant Gift Exchange',0,0),(184,'white elephant 1',0,0),(185,'white elephant 2',0,0),(186,'January-2015 Birthdays',0,0),(187,'January-2015 Birthdays',0,0),(188,'SCN Award 15',0,0),(189,'SCN Award 15',0,0),(190,'Marissa Bosco',0,0),(191,'FEB Birthday 2015',0,0),(192,'Valentines Day',0,0),(193,'Slide1',0,0),(194,'Slide2',0,0),(195,'Slide3',0,0),(196,'Slide4',0,0),(197,'Slide5',0,0),(198,'Rolling Bean',0,0),(199,'Slide1',0,0),(200,'Slide2',0,0),(201,'Slide3',0,0),(202,'Slide4',0,0),(203,'Slide5',0,0),(204,'Slide6',0,0),(205,'2015 MARCH',0,0),(206,'Slide1',0,0),(207,'Slide2',0,0),(208,'Slide3',0,0),(209,'Slide4',0,0),(210,'Daylight Savings Time',0,0),(211,'March Birthday 15',0,0),(212,'bingo winners',0,0),(213,'Slide2',0,0),(214,'Slide3',0,0),(215,'Slide4',0,0),(216,'Slide5',0,0),(217,'bingo winners',0,0),(218,'Slide1',0,0),(219,'Customer Testimonial zcolo',0,0),(220,'Charity',0,0),(221,'2015 April',0,0),(114,'NCAA Bracket Winner jdavidson',0,0),(222,'Customer Testimonial mmart',0,0),(223,'Customer Testimonial mmart',0,0),(224,'2015 April',0,0),(225,'Customer Testimonial sunstar',0,0),(226,'Customer Testimonial sunstar',0,0),(227,'Summer Hours',0,0),(228,'Summer Hours',0,0),(229,'May Birthdays 2015',0,0),(230,'Jenna and Jake',0,0),(231,'Employee of the Month ',0,0),(232,'Employee of the Month',0,0),(233,'Employee of the Month',0,0),(234,'Customer Testimonial CBRE',0,0),(235,'Customer Testimonial CBRE',0,0),(236,'DROSE Meme',0,0),(237,'drose meme 2',0,0),(238,'Welcome Ermco',0,0),(239,'June Birthdays',0,0),(240,'GOLF OUTING GROUP SHOT_ 2015',0,0),(241,'GOLF OUTING GROUP SHOT_ 2015',0,0),(242,'HH',0,0),(243,'HH',0,0),(244,'HH',0,0),(245,'EOTM_VINCE PIRRONE',0,0),(246,'Customer Testimonial VALENTI B',0,0),(247,'CUSTOMER TESTOMONIAL ICG',0,0),(248,'Will and Julie ',0,0),(249,'Customer Testimonial ',0,0),(250,'Customer Testimonial ',0,0),(251,'Customer Testimonial ',0,0),(252,'duck derby',0,0),(253,'ice cream social',0,0),(254,'July Birthdays 2015',0,0),(255,'duck derby',0,0),(256,'Employee of the Month BSPEARMA',0,0),(257,'town hall',0,0),(258,'town hall',0,0),(259,'duck derby',0,0),(260,'EVENT',0,0),(261,'EVENT',0,0),(262,'EOTM_BRYAN KINGSLEY',0,0),(263,'IT OFFICE 365',0,0),(264,'August Birthdays 2015',0,0),(265,'duck derby',0,0),(266,'August Birthdays 2015',0,0),(267,'CPS Headquarters',0,0),(268,'September Birthdays',0,0),(269,'September Birthdays',0,0),(270,'quote',0,0),(271,'AUGUST EOM',0,0),(272,'BOSCO TAILGATING',0,0),(273,'October Birthdays 2015',0,0),(274,'EOM Shanna',0,0),(275,'TURNER GOLF OUTING 15',0,0),(276,'eom',0,0),(277,'eom',0,0),(278,'mlb playoffs',0,0),(279,'eom2',0,0),(280,'eom1',0,0),(281,'mlb playoffs',0,0),(282,'eom3',0,0),(283,'holiday party 2015',0,0),(284,'baseball',0,0),(285,'employee of the month prize',0,0),(286,'Daylight Savings Time',0,0),(287,'mlb playoffs 2',0,0),(288,'CT',0,0),(289,'CT',0,0),(290,'HAPPY HALLOWEEN',0,0),(291,'HAPPY HALLOWEEN',0,0),(292,'HAPPY HALLOWEEN',0,0),(293,'mlb playoffs 3',0,0),(294,'mlb playoffs 3',0,0),(295,'dental',0,0),(296,'November Bdays',0,0),(297,'EOM DAN',0,0),(298,'EOM MICHELE',0,0),(299,'EOM MICHELE',0,0),(300,'bake off ',0,0),(301,'bk',0,0),(302,'vp',0,0),(303,'bs',0,0),(304,'sa',0,0),(305,'rr',0,0),(306,'DEC15',0,0),(307,'JANBDAYS-16',0,0),(308,'AMALGAMATED BANK',0,0),(309,'WELLS FARGO',0,0),(310,'DEPAUL THEATRE',0,0),(311,'ONE NORTH INTERACTIVE',0,0),(312,'KELLOG HALL',0,0),(313,'PRUDENTIAL PLAZA',0,0),(314,'AMALGAMATED BANK',0,0),(315,'2015EOMGROUP',0,0),(316,'EOM ALL',0,0),(317,'EOM TOM PAYTON',0,0),(318,'FEB-BDAYS',0,0),(319,'Tom Emerson',0,0),(320,'Tom Emerson',0,0),(321,'Style-5-REX',0,0),(322,'March Birthdays',0,0),(324,'Employee of the Month',0,0),(325,'volleyball',0,0),(326,'EOM slide',0,0),(323,'EOM slide',0,0),(327,'april birthdays',0,0),(328,'april birthdays',0,0),(329,'May Birthdays',0,0),(330,'Employee of the Month april',0,0),(331,'hops for humboldt',0,0),(332,'Grand Prize',0,0),(333,'Grand Prize',0,0),(334,'Shout out',0,0),(335,'EOM slide',0,0),(336,'june birthdays',0,0),(337,'EOM slide',0,0),(338,'Kara',0,0),(339,'july birthdays',0,0),(340,'EOM slide',0,0),(341,'Employee of the Month',0,0),(342,'Employee of the Month',0,0),(343,'AUGUST BIRTHDAYS',0,0),(344,'EOM slide',0,0),(345,'Employee of the Month',0,0),(346,'Employee of the Month',0,0),(347,'sept birthdays',0,0),(348,'EOM slide',0,0),(349,'Employee of the Month',0,0),(350,'birthdays',0,0),(351,'Presentation1',0,0),(352,'EOM slide',0,0),(353,'november birthdays ',0,0),(354,'REXplusCHUGACH-REXTV',0,0),(355,'REXplusCHUGACH-REXTV',0,0),(356,'november birthdays ',0,0),(357,'EOM slide',0,0),(358,'EOM slide',0,0),(359,'Employee of the Month november',0,0),(360,'December birthdays',0,0),(361,'Dec birthdays',0,0),(362,'Employee of the Month dEC',0,0),(363,'From the cooper\'s',0,0),(364,'Tom Payton Winner',0,0),(365,'EOM slide',0,0),(366,'january',0,0),(367,'DSC_0164',0,0),(368,'JANUARY 2017',0,0),(369,'JANUARY 2017',0,0),(370,'Feb',0,0),(371,'March Birthdays',0,0),(372,'Style-5-REXdfd',0,0),(373,'events',0,0),(374,'events',0,0),(375,'TCIR',0,0),(376,'LTIR',0,0),(377,'DART',0,0),(378,'last incident',0,0),(379,'SAEFTY 1',0,0),(380,'events',0,0),(381,'APril Birthdays',0,0),(382,'Safety Slides',0,0),(383,'m',0,0),(384,'events',0,0),(385,'Safety Slides',0,0),(386,'DART',0,0),(387,'TCIR',0,0),(388,'LTIR',0,0),(389,'last incident',0,0),(390,'events',0,0),(391,'Creating One Rex Slide-02',0,0),(392,'cinco de mayo',0,0),(393,'cinco de mayo',0,0),(394,'maybirthdays',0,0),(395,'events',0,0),(396,'Employee of the Month',0,0),(397,'DART',0,0),(398,'LTIR',0,0),(399,'TCIR',0,0),(400,'cabo ',0,0),(401,'REX Recognizes ',0,0),(402,'JUNE BIRTHDAYS',0,0),(403,'Employee of the Month MATT',0,0),(404,'July birtrhdays ',0,0),(405,'chugach alaska run',0,0),(406,'Employee of the Month- KELLY',0,0),(407,'Employee of the Month- KELLY',0,0),(408,'Employee of the Month- KELLY',0,0),(409,'DART',0,0),(410,'LTIR',0,0),(411,'TCIR',0,0),(412,'AUGUST BIRTHDAYS',0,0),(413,'Employee of the Month JULY ',0,0),(414,'LTIR',0,0),(415,'TCIR',0,0),(416,'DART',0,0),(417,'EOM slide 2017',0,0),(418,'september birthdays ',0,0),(419,'DART',0,0),(420,'LTIR',0,0),(421,'TCIR',0,0),(422,'Employee of the Month ken',0,0),(423,'Employee of the Month ken',0,0),(424,'oct birthdays ',0,0),(425,'EOM slide 2017',0,0);

--
-- Table structure for table `slide_text`
--

CREATE TABLE `slide_text` (
  `slide` int(11) NOT NULL,
  `text` varchar(150) NOT NULL,
  `locx` int(11) NOT NULL DEFAULT '0',
  `locy` int(11) NOT NULL DEFAULT '0',
  `font` varchar(20) NOT NULL DEFAULT 'Interstate',
  `size` smallint(2) NOT NULL DEFAULT '50',
  `width` int(11) NOT NULL DEFAULT '500',
  `align` varchar(10) NOT NULL DEFAULT 'left',
  `color` varchar(6) NOT NULL DEFAULT 'FFFFFF',
  `dropShadow` varchar(6) DEFAULT NULL,
  `drawOrder` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slide_text`
--

INSERT INTO `slide_text` VALUES (2,'Join us for amazing drink specials including two-for-one on all pints all day Thursday!',450,200,'Poor Richard',64,550,'right','FFFFFF','000000',7),(1,'* Void in states where outlawed.',5,700,'Verdana',12,500,'left','FFFFFF',NULL,1),(4,'Welcome!',36,20,'Verdana',48,990,'left','DDDDDD','000000',1),(4,'Welcome to Integrisys',50,330,'Verdana',48,950,'center','000000','',2),(2,'Two-for-Thursday!',350,20,'Poor Richard',68,650,'center','FFFFFF','000000',6),(13,'Look to Integrisys for your commercial system needs.',500,500,'Verdana',32,500,'left','000000','',2),(1,'This is a Black Slide',0,300,'Stencil',82,1000,'center','FF0000','',4),(13,'Integrisys Commercial Solutions',30,10,'Verdana',64,970,'left','FFFFFF','000000',1),(14,'Sale Today!',100,100,'Verdana',70,900,'center','000000','',1),(15,'American Sign and Lighting',100,100,'Verdana',68,900,'left','999999','333333',3),(21,'Title',48,48,'Interstate',82,952,'left','FFFFFF','',1),(21,'Main Content',608,237,'Interstate',32,300,'left','FFFFFF','',3),(27,'Fitness Studio',48,48,'Interstate',82,952,'left','FFFFFF','',1),(19,'Fitness Center',48,48,'Interstate',82,952,'left','FFFFFF','',1),(19,'The Fitness Center is available for your use during office hours and has a full compliment of the latest fitness equipment and locker room facilities.',608,237,'Interstate',32,300,'left','FFFFFF','',3),(25,'Conference Room',48,48,'Interstate',82,952,'left','FFFFFF','',1),(23,'Title',25,12,'Interstate',68,985,'left','FFFFFF','',1),(23,'Main Text Content',200,300,'Interstate',32,800,'center','000000','',2),(24,'Headline',12,25,'Interstate',64,988,'left','FFFFFF','',1),(24,'General Text',150,200,'Interstate',48,850,'center','000000','',2),(27,'The Fitness Studio features all of the technology necessary for an interactive workout. ',608,237,'Interstate',32,300,'left','FFFFFF','',3),(25,'The conference room is available for reservation and features advanced A/V capability.  It is conveniently located adjacent to the breakout area.',608,237,'Interstate',32,300,'left','FFFFFF','',3),(28,'Multipurpose Room',48,48,'Interstate',82,952,'left','FFFFFF','',1),(28,'The multipurpose room transforms to fit the size and needs of your meeting.  Use it for large presentations or smaller gatherings.',608,237,'Interstate',32,300,'left','FFFFFF','',3),(29,'Amenities Floor Directory',50,63,'Interstate',48,1000,'left','FFFFFF','',1),(30,'225 West Wacker Welcomes:',30,60,'Interstate',48,985,'left','FFFFFF',NULL,1),(26,'Main Text Headline',48,48,'Interstate',82,952,'left','FFFFFF','',1),(26,'Content Text',48,250,'Interstate',48,1000,'left','FFFFFF','',2),(17,'Important Information',48,48,'Interstate',82,952,'left','FFFFFF','',1),(17,'The fitness center will be closing early this Friday, September 25 for a special event.  Please plan your workouts accordingly!  Thank You!',48,250,'Interstate',48,1000,'left','FFFFFF','',2),(18,'Headline Text',333,60,'Verdana',50,865,'center','FFFFFF','',1),(22,'Headline Text',348,76,'Verdana',70,800,'left','FFFFFF','',1),(47,'Happy Holidays Tenants!',0,15,'Amienne',200,1280,'center','FFFFFF','999999',3),(41,'Headline Text',0,15,'Amienne',200,1280,'center','FFFFFF','999999',3),(41,'Subhead Text',0,190,'Amienne',75,1280,'center','FFFFFF','999999',4),(43,'Headline Text',0,100,'Papyrus',100,1280,'center','FFFFFF','333333',3),(43,'Subhead Text',0,300,'Papyrus',48,1280,'center','FFFFFF','',4),(32,'Headline Text',0,50,'Verdana',75,1005,'center','FFFFFF','000000',1),(32,'Subhead Text Box',0,200,'Verdana',48,1005,'center','FFFFFF','000000',2),(47,'from the office of the building',0,190,'Amienne',75,1280,'center','FFFFFF','999999',4),(53,'Test ',15,15,'Verdana',70,985,'left','000000','',1),(54,'Welcome to 832 W Superior',15,15,'Verdana',32,985,'left','FFFFFF','333333',1),(16,'Tweet 5',60,898,'Verdana',24,590,'left','000000','',15),(81,'cnnbrk',150,245,'Interstate',48,500,'left','000000','',3),(81,'Tweet 1',60,338,'Verdana',24,590,'left','000000','',9),(16,'Twitter Username',150,245,'Interstate',48,500,'left','000000','',3),(16,'Tweet 1',60,338,'Verdana',24,590,'left','000000','',9),(81,'Tweet 2',60,478,'Verdana',24,590,'left','000000','',11),(16,'Tweet 2',60,478,'Verdana',24,590,'left','000000','',11),(81,'Tweet 3',60,618,'Verdana',24,590,'left','000000','',13),(16,'Tweet 3',60,618,'Verdana',24,590,'left','000000','',13),(81,'Tweet 4',60,758,'Verdana',24,590,'left','000000','',14),(16,'Tweet 4',60,758,'Verdana',24,590,'left','000000','',14),(81,'Tweet 5',60,898,'Verdana',24,590,'left','000000','',15),(75,'chicagotribune',150,245,'Interstate',48,500,'left','000000','',3),(75,'Tweet 1',60,338,'Verdana',24,590,'left','000000','',9),(75,'Tweet 2',60,478,'Verdana',24,590,'left','000000','',11),(75,'Tweet 3',60,618,'Verdana',24,590,'left','000000','',13),(75,'Tweet 4',60,758,'Verdana',24,590,'left','000000','',14),(75,'Tweet 5',60,898,'Verdana',24,590,'left','000000','',15),(50,'secondepoch',150,245,'Interstate',48,500,'left','000000','',3),(50,'Tweet 1',60,338,'Verdana',24,590,'left','000000','',9),(50,'Tweet 2',60,478,'Verdana',24,590,'left','000000','',11),(50,'Tweet 3',60,618,'Verdana',24,590,'left','000000','',13),(50,'Tweet 4',60,758,'Verdana',24,590,'left','000000','',14),(50,'Tweet 5',60,898,'Verdana',24,590,'left','000000','',15),(55,'Tweet 4',156,498,'Verdana',24,790,'left','000000','',5),(55,'Tweet 3',156,385,'Verdana',24,790,'left','000000','',4),(55,'Tweet 2',156,273,'Verdana',24,790,'left','000000','',3),(55,'Tweet 1',156,165,'Verdana',24,790,'left','000000','',2),(55,'cnnbrk',243,87,'Interstate',48,703,'left','000000','',1),(56,'Twitter Username',243,87,'Interstate',48,703,'left','000000','',1),(56,'Tweet 1',156,165,'Verdana',24,790,'left','000000','',2),(56,'Tweet 2',156,273,'Verdana',24,790,'left','000000','',3),(56,'Tweet 3',156,385,'Verdana',24,790,'left','000000','',4),(56,'Tweet 4',156,498,'Verdana',24,790,'left','000000','',5),(56,'Tweet 5',156,607,'Verdana',24,790,'left','000000','',6),(55,'Tweet 5',156,607,'Verdana',24,790,'left','000000','',6),(44,'chicagotribune',243,87,'Interstate',48,703,'left','000000','',1),(44,'Tweet 1',156,165,'Verdana',24,790,'left','000000','',2),(44,'Tweet 2',156,273,'Verdana',24,790,'left','000000','',3),(44,'Tweet 3',156,385,'Verdana',24,790,'left','000000','',4),(44,'Tweet 4',156,498,'Verdana',24,790,'left','000000','',5),(44,'Tweet 5',156,607,'Verdana',24,790,'left','000000','',6),(102,'Integrisys',150,245,'Interstate',48,500,'left','000000','',3),(102,'Tweet 1',60,338,'Verdana',24,590,'left','000000','',9),(102,'Tweet 2',60,478,'Verdana',24,590,'left','000000','',11),(102,'Tweet 3',60,618,'Verdana',24,590,'left','000000','',13),(102,'Tweet 4',60,758,'Verdana',24,590,'left','000000','',14),(102,'Tweet 5',60,898,'Verdana',24,590,'left','000000','',15),(103,'Integrisys',243,87,'Interstate',48,703,'left','000000','',1),(103,'Tweet 1',156,165,'Verdana',24,790,'left','000000','',2),(103,'Tweet 2',156,273,'Verdana',24,790,'left','000000','',3),(103,'Tweet 3',156,385,'Verdana',24,790,'left','000000','',4),(103,'Tweet 4',156,498,'Verdana',24,790,'left','000000','',5),(103,'Tweet 5',156,607,'Verdana',24,790,'left','000000','',6),(105,'Corporate Concierge Services',333,60,'Verdana',50,865,'center','FFFFFF','',1),(117,'Test ONE',35,10,'Verdana',32,965,'left','000000','',1),(118,'TEST TWO',250,150,'Verdana',32,750,'left','000000','',1),(112,'AEP ENERGY 1.15.14',333,60,'Verdana',50,865,'center','FFFFFF','',1);

--
-- Table structure for table `slideshow`
--

CREATE TABLE `slideshow` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `site` int(11) NOT NULL,
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slideshow`
--

INSERT INTO `slideshow` VALUES (1,'Basic',8,'2016-03-18 18:39:40'),(2,'Lobby Slideshow',5,'2013-06-12 17:38:17'),(3,'Thalia Main',2,'2010-06-17 10:47:07'),(4,'Brad\'s Laptop Demo',8,'2016-03-18 18:39:40'),(5,'AEP',9,'2014-01-15 13:43:00'),(6,'Bermans Infinity Service Cente',10,'2010-05-25 15:49:13'),(7,'832 West Superior',5,'2013-06-17 17:31:25'),(8,'Test SS',8,'2016-03-18 18:39:40'),(9,'REX TV',11,'2019-01-09 19:24:19'),(10,'REX Welcomes',11,'2019-01-09 19:22:54');

--
-- Table structure for table `transition`
--

CREATE TABLE `transition` (
  `index` int(11) NOT NULL,
  `name` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transition`
--

INSERT INTO `transition` VALUES (0,'None'),(1,'Fade'),(2,'Push:Right'),(3,'Push:Down');

--
-- Table structure for table `userlevel`
--

CREATE TABLE `userlevel` (
  `index` tinyint(1) NOT NULL,
  `name` varchar(20) NOT NULL,
  `global_mod` tinyint(1) NOT NULL DEFAULT '0',
  `create_slides` tinyint(1) NOT NULL DEFAULT '0',
  `create_slideshows` tinyint(1) NOT NULL DEFAULT '0',
  `create_playlists` tinyint(1) NOT NULL DEFAULT '0',
  `create_signs` tinyint(1) NOT NULL DEFAULT '0',
  `edit_templates` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userlevel`
--

INSERT INTO `userlevel` VALUES (9,'Superuser',1,1,1,1,1,1),(8,'Admin',1,1,1,1,1,1),(7,'Moderator',1,1,1,1,1,0),(6,'Corporate',0,1,0,1,0,0),(3,'Manager',0,1,0,0,1,0),(1,'User',0,0,0,0,0,0);

--
-- Dumping events for database 'integricast'
--

--
-- Dumping routines for database 'integricast'
--


