--
-- Host: localhost    Database: digital
-- ------------------------------------------------------


--
-- Table structure for table `admin_logs`
--

CREATE TABLE `admin_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `op_code` varchar(30) NOT NULL,
  `op_content` varchar(50) NOT NULL,
  `op_ip` char(15) NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `admin_logs`
--

INSERT INTO `admin_logs` VALUES (1,1,'TERMINAL_ADD','終端機新增 ID: (51)','10.0.2.2',1,'2016-09-26 21:49:04'),(2,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 21:55:46'),(3,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 21:58:15'),(4,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 21:58:27'),(5,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 21:58:50'),(6,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 23:27:04'),(7,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 23:27:18'),(8,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-26 23:56:22'),(9,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-27 00:01:16'),(10,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-27 00:10:25'),(11,1,'TERMINAL_EDIT','終端機修改 ID: (51)','10.0.2.2',1,'2016-09-27 00:10:36'),(12,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2018-07-20 15:19:01'),(13,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-01-20 18:09:32'),(14,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-01-20 18:18:33'),(15,8,'TERMINAL_ADD','終端機新增 ID: (1)','10.0.2.2',1,'2020-01-20 18:21:53'),(16,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-02-04 16:24:11'),(17,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2020-02-19 15:16:41'),(18,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-03-03 11:36:42'),(19,8,'TERMINAL_ADD','終端機新增 ID: (2)','10.0.2.2',1,'2020-03-03 11:37:02'),(20,8,'VIDEO_ADD','影片新增 ID: (1)','10.0.2.2',1,'2020-03-03 11:37:32'),(21,8,'MARQUEE_ADD','跑馬燈新增 ID: (1)','10.0.2.2',1,'2020-03-03 11:37:49'),(22,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-03-03 11:38:11'),(23,8,'VIDEO_EDIT','影片修改 ID: (1)','10.0.2.2',1,'2020-03-03 11:38:47'),(24,8,'VIDEO_EDIT','影片修改 ID: (1)','10.0.2.2',1,'2020-03-03 11:39:08'),(25,8,'VIDEO_EDIT','影片修改 ID: (1)','10.0.2.2',1,'2020-03-03 11:39:37'),(26,8,'VIDEO_EDIT','影片修改 ID: (1)','10.0.2.2',1,'2020-03-03 11:39:41'),(27,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-04-30 13:23:24'),(28,8,'TERMINAL_EDIT','終端機修改 ID: (1)','10.0.2.2',1,'2020-04-30 13:24:31'),(29,8,'TERMINAL_EDIT','終端機修改 ID: (1)','10.0.2.2',1,'2020-04-30 15:31:22'),(30,0,'LOGIN_ERROR','登入失敗! (intercom_test)','10.0.2.2',1,'2020-05-04 11:40:59'),(31,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-05-05 11:16:15'),(32,8,'TERMINAL_EDIT','終端機修改 ID: (1)','10.0.2.2',1,'2020-05-05 11:17:21'),(33,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-05-22 14:09:41'),(34,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-03 15:25:34'),(35,8,'PIC_ADD','圖片新增 ID: (1)','10.0.2.2',1,'2020-06-03 15:45:33'),(36,8,'PIC_ADD','圖片新增 ID: (2)','10.0.2.2',1,'2020-06-03 15:45:39'),(37,8,'PIC_ADD','圖片新增 ID: (3)','10.0.2.2',1,'2020-06-03 15:45:46'),(38,8,'PIC_ADD','圖片新增 ID: (4)','10.0.2.2',1,'2020-06-03 15:45:55'),(39,8,'PIC_ADD','圖片新增 ID: (5)','10.0.2.2',1,'2020-06-03 15:46:01'),(40,8,'PIC_ADD','圖片新增 ID: (6)','10.0.2.2',1,'2020-06-03 15:46:09'),(41,8,'PIC_ADD','圖片新增 ID: (7)','10.0.2.2',1,'2020-06-03 15:46:19'),(42,8,'PIC_ADD','圖片新增 ID: (8)','10.0.2.2',1,'2020-06-03 15:46:23'),(43,8,'PIC_EDIT','圖片修改 ID: (8)','10.0.2.2',1,'2020-06-03 15:46:32'),(44,8,'PIC_ADD','圖片新增 ID: (9)','10.0.2.2',1,'2020-06-03 15:46:41'),(45,8,'PIC_ADD','圖片新增 ID: (10)','10.0.2.2',1,'2020-06-03 15:46:48'),(46,8,'PIC_ADD','圖片新增 ID: (11)','10.0.2.2',1,'2020-06-03 15:46:53'),(47,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 15:49:43'),(48,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 15:52:05'),(49,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 16:00:15'),(50,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 16:01:37'),(51,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 16:06:38'),(52,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-03 17:05:39'),(53,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-08 15:34:50'),(54,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-08 15:44:48'),(55,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-08 16:08:38'),(56,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-08 16:27:16'),(57,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-09 09:21:23'),(58,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-09 12:27:16'),(59,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-11 11:44:46'),(60,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-11 13:26:50'),(61,8,'PIC_EDIT','圖片修改 ID: (2)','10.0.2.2',1,'2020-06-11 13:39:31'),(62,8,'PIC_EDIT','圖片修改 ID: (2)','10.0.2.2',1,'2020-06-11 13:39:36'),(63,8,'PIC_DEL','圖片刪除 ID: (1)','10.0.2.2',1,'2020-06-11 13:39:50'),(64,8,'PIC_EDIT','圖片修改 ID: (3)','10.0.2.2',1,'2020-06-11 13:42:05'),(65,8,'PIC_EDIT','圖片修改 ID: (4)','10.0.2.2',1,'2020-06-11 13:44:28'),(66,8,'PIC_EDIT','圖片修改 ID: (5)','10.0.2.2',1,'2020-06-11 13:46:22'),(67,8,'PIC_EDIT','圖片修改 ID: (6)','10.0.2.2',1,'2020-06-11 13:53:57'),(68,8,'PIC_DEL','圖片刪除 ID: (7)','10.0.2.2',1,'2020-06-11 13:59:03'),(69,8,'PIC_DEL','圖片刪除 ID: (8)','10.0.2.2',1,'2020-06-11 13:59:08'),(70,8,'PIC_DEL','圖片刪除 ID: (9)','10.0.2.2',1,'2020-06-11 13:59:10'),(71,8,'PIC_DEL','圖片刪除 ID: (10)','10.0.2.2',1,'2020-06-11 13:59:14'),(72,8,'PIC_DEL','圖片刪除 ID: (11)','10.0.2.2',1,'2020-06-11 13:59:16'),(73,8,'MARQUEE_EDIT','跑馬燈修改 ID: (1)','10.0.2.2',1,'2020-06-11 14:05:42'),(74,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-11 14:06:09'),(75,8,'TERMINAL_EDIT','終端機修改 ID: (2)','10.0.2.2',1,'2020-06-11 14:06:27'),(76,8,'MARQUEE_EDIT','跑馬燈修改 ID: (1)','10.0.2.2',1,'2020-06-11 14:12:27'),(77,8,'MARQUEE_EDIT','跑馬燈修改 ID: (1)','10.0.2.2',1,'2020-06-11 14:12:52'),(78,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-11 14:38:53'),(79,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-06-17 15:51:10'),(80,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-07-06 10:32:20'),(81,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-07-09 15:47:06'),(82,8,'TERMINAL_ADD','終端機新增 ID: (3)','10.0.2.2',1,'2020-07-09 15:47:47'),(83,8,'TERMINAL_EDIT','終端機修改 ID: (3)','10.0.2.2',1,'2020-07-09 15:48:45'),(84,8,'TERMINAL_EDIT','終端機修改 ID: (3)','10.0.2.2',1,'2020-07-09 15:50:52'),(85,8,'TERMINAL_EDIT','終端機修改 ID: (3)','10.0.2.2',1,'2020-07-09 15:51:12'),(86,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-07-09 17:07:11'),(87,8,'TERMINAL_ADD','終端機新增 ID: (4)','10.0.2.2',1,'2020-07-09 17:07:54'),(88,8,'TERMINAL_EDIT','終端機修改 ID: (4)','10.0.2.2',1,'2020-07-09 17:08:52'),(89,8,'TERMINAL_EDIT','終端機修改 ID: (4)','10.0.2.2',1,'2020-07-09 17:09:38'),(90,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-07-09 17:30:10'),(91,8,'TERMINAL_ADD','終端機新增 ID: (5)','10.0.2.2',1,'2020-07-09 17:32:26'),(92,8,'TERMINAL_EDIT','終端機修改 ID: (5)','10.0.2.2',1,'2020-07-09 17:33:45'),(93,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2020-07-09 18:09:44'),(94,8,'TERMINAL_ADD','終端機新增 ID: (6)','10.0.2.2',1,'2020-07-09 18:10:42'),(95,8,'TERMINAL_ADD','終端機新增 ID: (7)','10.0.2.2',1,'2020-07-09 18:11:15'),(96,8,'TERMINAL_EDIT','終端機修改 ID: (7)','10.0.2.2',1,'2020-07-09 18:13:36'),(97,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2022-03-10 15:01:20'),(98,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2022-03-26 20:09:06'),(99,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2022-03-26 20:09:15'),(100,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2022-03-29 09:11:18'),(101,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2022-03-29 09:11:22'),(102,0,'LOGIN_ERROR','登入失敗! (admin)','10.0.2.2',1,'2022-04-13 17:54:45'),(103,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2022-04-18 16:42:52'),(104,8,'TERMINAL_ADD','終端機新增 ID: (8)','10.0.2.2',1,'2022-04-18 17:01:38'),(105,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2022-04-18 17:42:19'),(106,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2022-04-18 17:42:22'),(107,8,'LOGIN_SUCCESS','登入成功! (admin)','10.0.2.2',1,'2022-06-21 18:11:08'),(108,8,'LOGIN_SUCCESS','登入成功! (admin)','192.168.0.174',1,'2022-06-24 07:17:00'),(109,8,'LOGIN_SUCCESS','登入成功! (admin)','192.168.0.174',1,'2022-06-24 07:27:20'),(110,8,'TERMINAL_ADD','終端機新增 ID: (11)','192.168.0.174',1,'2022-06-24 07:33:06'),(111,8,'PIC_ADD','圖片新增 ID: (7)','192.168.0.174',1,'2022-06-24 07:35:50'),(112,8,'PIC_DEL','圖片刪除 ID: (7)','192.168.0.174',1,'2022-06-24 07:35:55'),(113,8,'PIC_ADD','圖片新增 ID: (8)','192.168.0.174',1,'2022-06-24 07:36:01'),(114,8,'PIC_ADD','圖片新增 ID: (9)','192.168.0.174',1,'2022-06-24 07:36:14'),(115,8,'VIDEO_DEL','影片刪除 ID: (1)','192.168.0.174',1,'2022-06-24 07:36:19'),(116,8,'TERMINAL_EDIT','終端機修改 ID: (11)','192.168.0.174',1,'2022-06-24 07:51:03'),(117,8,'CLASS_ADD','類型新增 ID: (87)','192.168.0.174',1,'2022-06-24 07:58:57'),(118,8,'LOGIN_SUCCESS','登入成功! (admin)','192.168.0.174',1,'2022-06-24 08:00:08'),(119,8,'FLOOR_ADD','樓層新增 ID: (88)','192.168.0.174',1,'2022-06-24 08:00:48'),(120,8,'MARQUEE_EDIT','跑馬燈修改 ID: (1)','192.168.0.174',1,'2022-06-24 08:01:54'),(121,8,'LOGIN_SUCCESS','登入成功! (admin)','192.168.0.174',1,'2022-06-24 08:04:41'),(122,8,'LOGIN_SUCCESS','登入成功! (admin)','192.168.0.174',1,'2022-06-24 08:12:14');

--
-- Table structure for table `admin_user_auth`
--

CREATE TABLE `admin_user_auth` (
  `id` int NOT NULL AUTO_INCREMENT,
  `admin_id` int NOT NULL,
  `prog_code` varchar(20) NOT NULL,
  `auth_code` varchar(10) NOT NULL COMMENT 'N無權限,R唯讀,A增修,E全開',
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `view_all` int NOT NULL DEFAULT '0',
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb3 COMMENT='使用者權限';

--
-- Dumping data for table `admin_user_auth`
--

INSERT INTO `admin_user_auth` VALUES (1,6,'TERMINAL','A',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,6,'DATA','A',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,6,'COMPANY','A',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,6,'LOCATION','A',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,7,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,7,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,7,'COMPANY','N',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,7,'LOCATION','N',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,8,'TERMINAL','E',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,8,'DATA','E',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,8,'COMPANY','E',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,8,'LOCATION','E',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,10,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,10,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,10,'COMPANY','A',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,10,'LOCATION','A',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,11,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,11,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,11,'COMPANY','A',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,11,'LOCATION','A',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,13,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,13,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,13,'COMPANY','E',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,13,'LOCATION','A',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,14,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,14,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,14,'COMPANY','E',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,14,'LOCATION','E',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,15,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,15,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,15,'COMPANY','A',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,15,'LOCATION','A',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,16,'TERMINAL','R',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,16,'DATA','R',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,16,'COMPANY','A',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,16,'LOCATION','E',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,17,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,17,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,17,'COMPANY','E',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,18,'TERMINAL','R',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,18,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,18,'COMPANY','A',3,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,18,'LOCATION','E',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,19,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,19,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,19,'COMPANY','E',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,19,'LOCATION','N',4,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,20,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(49,20,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,20,'COMPANY','R',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(51,20,'LOCATION','R',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(52,21,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(53,21,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(54,21,'COMPANY','A',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(55,21,'LOCATION','A',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(56,22,'TERMINAL','E',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(57,22,'DATA','E',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(58,22,'COMPANY','E',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(59,22,'LOCATION','E',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(60,23,'TERMINAL','A',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(61,23,'DATA','A',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(62,23,'COMPANY','A',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(63,23,'LOCATION','A',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(64,24,'TERMINAL','R',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(65,24,'DATA','R',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(66,24,'COMPANY','R',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(67,24,'LOCATION','R',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(68,25,'TERMINAL','N',1,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(69,25,'DATA','N',2,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(70,25,'COMPANY','N',3,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(71,25,'LOCATION','N',4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `clock`
--

CREATE TABLE `clock` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `clock_code` varchar(10) NOT NULL,
  `pic_w` int DEFAULT NULL,
  `pic_h` int NOT NULL,
  `pic_topic` varchar(200) NOT NULL,
  `pic_name` varchar(200) DEFAULT NULL,
  `pic_name_md5` varchar(50) DEFAULT NULL,
  `pic_type` varchar(20) DEFAULT NULL,
  `pic_size` varchar(50) DEFAULT NULL,
  `pic_desc` text,
  `code_id` int NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='時鐘列表';

--
-- Dumping data for table `clock`
--

INSERT INTO `clock` VALUES (4,1,1,'C0004',1024,768,'正式時鐘','Desert.jpg','20150103053936605926.jpg','image/jpeg','845941','0',70,1,1,'2014-12-20 09:18:18','2015-02-04 11:02:37');

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

CREATE TABLE `company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `company_code` varchar(10) NOT NULL,
  `company_name_tw` varchar(200) NOT NULL,
  `company_name_en` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `tel` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `web_site` varchar(200) NOT NULL,
  `business` varchar(200) NOT NULL,
  `invoice_no` varchar(8) NOT NULL,
  `charge_name` varchar(100) NOT NULL,
  `capital` varchar(100) NOT NULL,
  `admin_name` varchar(100) NOT NULL,
  `admin_ext` varchar(20) NOT NULL,
  `admin_mail` varchar(100) NOT NULL,
  `walfare_name` varchar(100) NOT NULL,
  `walfare_ext` varchar(20) NOT NULL,
  `walfare_mail` varchar(100) NOT NULL,
  `urgent_name_1` varchar(100) NOT NULL,
  `urgent_phone_1` varchar(50) NOT NULL,
  `urgent_name_2` varchar(100) NOT NULL,
  `urgent_phone_2` varchar(50) NOT NULL,
  `urgent_name_3` varchar(100) NOT NULL,
  `urgent_phone_3` varchar(50) NOT NULL,
  `floor_code_id` int NOT NULL,
  `class_code_id` int NOT NULL,
  `pic1` varchar(50) NOT NULL,
  `pic2` varchar(50) NOT NULL,
  `pic3` varchar(50) NOT NULL COMMENT '左下圖片',
  `pic4` varchar(50) NOT NULL COMMENT '中下圖片',
  `pic5` varchar(50) NOT NULL COMMENT '右下圖片',
  `pic6` varchar(50) NOT NULL,
  `pic7` varchar(50) NOT NULL,
  `pic8` varchar(50) NOT NULL,
  `pic9` varchar(50) NOT NULL,
  `company_desc` text NOT NULL,
  `keyword` text,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `time_start_1` varchar(50) NOT NULL,
  `time_end_1` varchar(50) NOT NULL,
  `time_start_2` varchar(50) NOT NULL,
  `time_end_2` varchar(50) NOT NULL,
  `time_start_3` varchar(50) NOT NULL,
  `time_end_3` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='公司資料';

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


--
-- Table structure for table `facility`
--

CREATE TABLE `facility` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `floor_code_id` int NOT NULL,
  `class_code_id` int NOT NULL,
  `topic` varchar(200) NOT NULL,
  `topic_en` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `detail` text NOT NULL,
  `pic1` varchar(50) NOT NULL,
  `pic2` varchar(50) NOT NULL COMMENT 'icon',
  `pic3` varchar(50) NOT NULL,
  `pic4` varchar(50) NOT NULL,
  `pic5` varchar(50) NOT NULL,
  `pic6` varchar(50) NOT NULL,
  `pic7` varchar(50) NOT NULL,
  `pic8` varchar(50) NOT NULL COMMENT '排程圖片2',
  `pic9` varchar(50) NOT NULL COMMENT '排程圖片3',
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `time_start_1` varchar(50) NOT NULL,
  `time_end_1` varchar(50) NOT NULL,
  `time_start_2` varchar(50) NOT NULL,
  `time_end_2` varchar(50) NOT NULL,
  `time_start_3` varchar(50) NOT NULL,
  `time_end_3` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COMMENT='設施列表';

--
-- Dumping data for table `facility`
--

INSERT INTO `facility` VALUES (11,1,1,76,75,'站牌查詢：F912','','<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n\r\n<table style=\"font-size: medium; border: 2px solid rgb(0, 153, 255); ; width: 100%\">\r\n	<tbody>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">起訖站</td>\r\n			<td colspan=\"2\">票價資訊</td>\r\n			<td width=\"23%\">服務專線</td>\r\n		</tr>\r\n		<tr>\r\n			<td width=\"13%\">起點：</td>\r\n			<td width=\"27%\">汐止公園</td>\r\n			<td width=\"18%\">票　價：</td>\r\n			<td width=\"19%\">&nbsp;</td>\r\n			<td>汐止區公所</td>\r\n		</tr>\r\n		<tr>\r\n			<td>迄點：</td>\r\n			<td>汐止火車站</td>\r\n			<td>緩衝區：</td>\r\n			<td>&nbsp;</td>\r\n			<td>(02)2641-1111</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">A線發車時間(平日)(假日)</td>\r\n			<td colspan=\"3\">A線發車間距(平日)(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n		  <td>頭班車：</td>\r\n		  <td>0620</td>\r\n		  <td colspan=\"3\" rowspan=\"2\">06:20 07:20 08:30 10:15 14:00 16:00 18:00 21:00</td>\r\n		</tr>\r\n		<tr>\r\n		  <td>末班車：</td>\r\n		  <td>2100</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n		  <td colspan=\"2\">B線發車時間(平日)(假日)</td>\r\n		  <td colspan=\"3\">A線發車間距(平日)(例假日)</td>\r\n	  </tr>\r\n		<tr>\r\n		  <td>頭班車：</td>\r\n		  <td>0650</td>\r\n		  <td colspan=\"3\" rowspan=\"2\">06:50 08:00 09:00 11:30 12:45 15:00 17:00 19:00</td>\r\n	  </tr>\r\n		<tr>\r\n		  <td>末班車：</td>\r\n		  <td>1900</td>\r\n	  </tr>\r\n	</tbody>\r\n</table>','20150408095220958557.jpg','20150408095307973388.jpg','20150408095235124939.jpg','20150408095256888061.jpg','20150408095302359680.jpg','20150408095229980468.jpg','','','',2,1,'2015-01-23 08:59:42','2015-04-08 09:53:24','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(12,1,1,76,75,'站牌查詢：F913','','<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n\r\n<table style=\"font-size: medium; border: 2px solid rgb(0, 153, 255); ; width: 100%\">\r\n	<tbody>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">起訖站</td>\r\n			<td colspan=\"2\">票價資訊</td>\r\n			<td width=\"23%\">服務專線</td>\r\n		</tr>\r\n		<tr>\r\n			<td width=\"12%\">起　點：</td>\r\n			<td width=\"15%\">崇義高中</td>\r\n			<td width=\"12%\">票　價：</td>\r\n			<td width=\"38%\">&nbsp;</td>\r\n			<td>汐止區公所</td>\r\n		</tr>\r\n		<tr>\r\n			<td>訖　點：</td>\r\n			<td>木南煤礦(瓏山林社區)</td>\r\n			<td>緩衝區：</td>\r\n			<td>&nbsp;</td>\r\n			<td>(02)2641-1111</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">發車時間(平日)(假日)</td>\r\n			<td colspan=\"3\">發車間距(平日)(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n		  <td>F913去</td>\r\n		  <td>0650-2120</td>\r\n		  <td colspan=\"3\">06:50 07:10 16:15 17:30 18:30 19:40 20:10 21:20</td>\r\n	  </tr>\r\n		<tr>\r\n		  <td>F913返</td>\r\n		  <td>0645-2155</td>\r\n		  <td colspan=\"3\">06:40 07:30 07:50 09:10 9:40 11:20 15:45 16:50 18:10 19:05 20:10 20:40 21:15 21:55</td>\r\n      </tr>\r\n		<tr>\r\n			<td>F913去延</td>\r\n		  <td>0605-2120</td>\r\n		  <td colspan=\"3\">06:05 06:50 07:10 07:25 08:35 09:15 09:50 10:50 11:50 13:30 15:20 15:50 16:15 16:55 17:30 18:00 18:30 19:40 20:10 20:45 21:20</td>\r\n		</tr>\r\n		<tr>\r\n			<td>F913返延</td>\r\n			<td>0645-2155</td>\r\n			<td colspan=\"3\">06:45 07:05 07:30 07:50 08:10 09:15 09:45 10:30 11:20 12:30 14:10 15:45 16:30 16:50 17:40 18:10 18:45 19:05 20:10 20:40 21:55</td>\r\n		</tr>\r\n	</tbody>\r\n</table>','20150408095333101075.jpg','2015040809541729480.jpg','2015040809535663355.jpg','20150408095404515442.jpg','2015040809540978370.jpg','20150408095349538513.jpg','','','',3,1,'2015-01-23 09:00:07','2015-04-08 09:54:35','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(13,1,1,76,75,'站牌查詢：F915','','<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n\r\n<table style=\"font-size: medium; border: 2px solid rgb(0, 153, 255); ; width: 100%\">\r\n	<tbody>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">起訖站</td>\r\n			<td colspan=\"2\">票價資訊</td>\r\n			<td width=\"23%\">服務專線</td>\r\n		</tr>\r\n		<tr>\r\n			<td width=\"13%\">去-起訖站：</td>\r\n			<td width=\"27%\">汐止公園－金龍國小</td>\r\n			<td width=\"18%\">票　價：</td>\r\n			<td width=\"19%\">&nbsp;</td>\r\n			<td>汐止區公所</td>\r\n		</tr>\r\n		<tr>\r\n		  <td width=\"13%\">返-起訖站：</td>\r\n			<td>金龍國小－汐止公園</td>\r\n			<td>緩衝區：</td>\r\n			<td>&nbsp;</td>\r\n			<td>(02)2641-1111</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">（去）發車時間(平日)(假日)</td>\r\n			<td colspan=\"3\">（去）發車間距(平日)(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n		  <td>頭班車：</td>\r\n		  <td>0610</td>\r\n		  <td colspan=\"3\" rowspan=\"2\">06:10 06:50 07:30 08:10 08:50 09:40 10:40 12:00 13:00 14:00 15:00 16:20 16:40 17:30 18:10 18:30 19:00 19:40 20:20</td>\r\n		</tr>\r\n		<tr>\r\n		  <td>末班車：</td>\r\n		  <td>2020</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n		  <td colspan=\"2\">（返）發車時間(平日)(假日)</td>\r\n		  <td colspan=\"3\">（返）發車間距(平日)(例假日)</td>\r\n	  </tr>\r\n		<tr>\r\n		  <td>頭班車：</td>\r\n		  <td>0645</td>\r\n		  <td colspan=\"3\" rowspan=\"2\">06:45 07:35 08:15 08:55 09:30 10:15 11:10 12:30 13:30 14:30 15:30 17:00 17:20 18:15 18:50 19:10 19:35 20:10 20:50</td>\r\n	  </tr>\r\n		<tr>\r\n		  <td>末班車：</td>\r\n		  <td>2050</td>\r\n	  </tr>\r\n	</tbody>\r\n</table>','20150408095446578613.jpg','20150408095536889282.jpg','20150408095512172669.jpg','20150408095520587158.jpg','20150408095527952331.jpg','20150408095506931518.jpg','','','',4,1,'2015-01-23 09:00:24','2015-04-08 09:55:51','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(14,1,1,76,75,'站牌查詢：內科通勤專車7','','<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n\r\n<table style=\"font-size: medium; border: 2px solid rgb(0, 153, 255); ; width: 100%\">\r\n	<tbody>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">起訖站</td>\r\n			<td colspan=\"2\">票價資訊</td>\r\n			<td width=\"23%\">服務專線</td>\r\n		</tr>\r\n		<tr>\r\n			<td width=\"12%\">起　點：</td>\r\n			<td width=\"15%\">汐止</td>\r\n			<td width=\"12%\">票　價：</td>\r\n			<td width=\"38%\">二段票</td>\r\n			<td>新北客運</td>\r\n		</tr>\r\n		<tr>\r\n			<td>訖　點：</td>\r\n			<td>內湖科技園區</td>\r\n			<td>緩衝區：</td>\r\n			<td>南港軟體園區北站</td>\r\n			<td>0800-002-277</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">發車時間(平日)</td>\r\n			<td colspan=\"3\">發車間距(平日)</td>\r\n		</tr>\r\n		<tr>\r\n			<td>頭班車：</td>\r\n		  <td>07:10</td>\r\n			<td colspan=\"3\" rowspan=\"2\">07:10 (汐止車站-內科)<br />\r\n			  18:10 (內科-汐止車站)</td>\r\n		</tr>\r\n		<tr>\r\n			<td>末班車：</td>\r\n			<td>18:10</td>\r\n		</tr>\r\n		<tr style=\"background-color: #D02F2F\">\r\n			<td colspan=\"2\">發車時間(假日)</td>\r\n			<td colspan=\"3\">發車間距(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n			<td>頭班車：</td>\r\n			<td>停駛</td>\r\n		  <td colspan=\"3\" rowspan=\"2\">停駛</td>\r\n		</tr>\r\n		<tr>\r\n			<td>末班車：</td>\r\n			<td>停駛</td>\r\n		</tr>\r\n	</tbody>\r\n</table>','20150408095614757965.jpg','20150408095656445404.jpg','2015040809563466437.jpg','20150408095640354706.jpg','20150408095648341705.jpg','20150408095625777679.jpg','','','',5,1,'2015-01-23 09:02:57','2015-04-08 09:57:20','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(28,1,1,76,75,'站牌查詢：F901','','<table style=\"border:2px solid rgb(0, 153, 255); font-size:medium; width:100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td colspan=\"2\">起訖站</td>\r\n			<td colspan=\"2\">票價資訊</td>\r\n			<td>服務專線</td>\r\n		</tr>\r\n		<tr>\r\n			<td>訖　點A：</td>\r\n			<td>汐碇路石頭公</td>\r\n			<td>票　價：</td>\r\n			<td>&nbsp;</td>\r\n			<td>汐止區公所</td>\r\n		</tr>\r\n		<tr>\r\n			<td>訖　點B：</td>\r\n			<td>汐止火車站</td>\r\n			<td>緩衝區：</td>\r\n			<td>&nbsp;</td>\r\n			<td>(02)2641-1111</td>\r\n		</tr>\r\n		<tr>\r\n			<td colspan=\"2\">發車時間(平日)</td>\r\n			<td colspan=\"3\">發車A間距(平日)(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n			<td>頭班車A：0605</td>\r\n			<td>頭班車B：0635</td>\r\n			<td colspan=\"3\" rowspan=\"2\">06:05 06:25 06:40 07:15 07:40 08:00 09:00 10:20 11:40 12:20 13:50 14:30 15:10 15:50 16:20 17:00 17:30 18:30 19:00 20:00 21:00</td>\r\n		</tr>\r\n		<tr>\r\n			<td>末班車A：2100</td>\r\n			<td>末班車B：2130</td>\r\n		</tr>\r\n		<tr>\r\n			<td colspan=\"2\">發車時間(假日)</td>\r\n			<td colspan=\"3\">發車B間距(平日)(例假日)</td>\r\n		</tr>\r\n		<tr>\r\n			<td>頭班車A：0605</td>\r\n			<td>頭班車B：0635</td>\r\n			<td colspan=\"3\" rowspan=\"2\">06:35 06:55 07:15 07:50 08:15 08:40 09:35 10:50 12:10 12:50 14:20 15:00 15:40 16:20 16:50 17:30 18:00 19:00 19:30 20:30 21:30</td>\r\n		</tr>\r\n		<tr>\r\n			<td>末班車A：2100</td>\r\n			<td>末班車B：2130</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n','20150408095055593140.jpg','20150408095147504944.jpg','20150408095120459717.jpg','20150408095128320984.jpg','20150408095137347778.jpg','20150408095113392883.jpg','20150812093219686004.png','20150812093254253083.png','',1,1,'2015-01-23 10:49:50','2015-08-12 09:33:09','08/12/2015 5:00pm','08/12/2015 6:00pm','08/12/2015 5:00pm','08/12/2015 7:00pm','',''),(41,1,8,115,13,'McDonald\'s 麥當勞','McDonald\'s ','<p><span style=\"color:rgb(20, 24, 35)\">i&#39;m lovin&#39; it是麥當勞的全新精神，這是ㄧ種盡興表現自己，享受生活其中的態度，從現在起只要誰說 i&#39;m lovin&#39; it，就表示他正熱愛、並享受此刻。</span></p>\r\n\r\n<p>營業時間：周一至周日　上午０６：００至晚間１２：００</p>\r\n','20150408100231866119.jpg','2015012604580226764.jpg','2015081205170660517.jpg','20150126051714659210.jpg','2015012605171995917.jpg','20150126051703366364.jpg','20150812065549223389.png','20150812072235833862.png','20150812072230988708.png',6,1,'2015-01-26 04:56:23','2015-08-12 08:23:47','08/12/2015 4:00pm','08/12/2015 4:30pm','08/12/2015 4:00pm','08/12/2015 4:30pm','08/12/2015 4:00pm','08/12/2015 4:30pm'),(42,1,8,115,155,'松青超市','MATSUSEI','<p><span style=\"color:rgb(31, 89, 73)\">松青超市隸屬於味全集團，於民國75年由味全食品工業股份有限公司與日本松青株式會社合資成立。 松青超市因應國內消費趨勢與生活型態的改變，引進國外超市經營新概念，以「達人嚴選」與「名地名產」的概念為出發點，堅持提供顧客新鮮、健康、有特色的生鮮食材與日常用品，以貼心的服務讓顧客在明亮舒適的環境中，享受最大的購物樂趣，讓生活多一點享受。</span></p>\r\n\r\n<p><span style=\"color:rgb(0, 0, 0)\">營業時間：周一至周日　上午０９：００至晚間１０：００</span><br />\r\n樓層位置：B1F</p>\r\n','20150408100206111298.jpg','20150126062533322418.jpg','20150408100215619964.jpg','20150408100219756378.jpg','2015040810022348554.jpg','20150408100210658844.jpg','','','',7,1,'2015-01-26 06:27:22','2015-04-08 10:02:26','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(43,1,8,47,13,'馬辣火鍋','Malaaaa','<p>午餐$545　AM 11:30 ~ PM 16:00<br />\r\n晚餐$635　PM 16:00 ~ AM 02:00<br />\r\n周六日/例假日$635　AM 11:30 ~ AM 02:00<br />\r\n兒童半價小一至小六、限一大配一小、用餐時間２小時</p>\r\n\r\n<p>10%清潔費另計，單人用餐需加100元</p>\r\n\r\n<p>4到6歲用餐，酌收清潔費100元</p>\r\n\r\n<p>歡迎自帶飲料、酒類，免收開瓶費</p>\r\n','20150408100146985748.jpg','20150126063949106415.jpg','201501260639357721.jpg','20150126063940377045.jpg','','20150126063844380097.jpg','','','',8,1,'2015-01-26 06:37:13','2015-04-09 09:05:04','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(44,1,8,12,13,'千葉火鍋','1000Leaf','<p><span style=\"color:rgb(20, 24, 35)\">因為用心，所以千葉火鍋有自信可以給您最好的！</span><br />\r\n<span style=\"color:rgb(20, 24, 35)\">一直秉持著「給您最好的」讓您盡情的「享受無拘束美食」</span></p>\r\n\r\n<p><span style=\"color:rgb(20, 24, 35)\">千葉火鍋堅守四大信條：</span><br />\r\n<span style=\"color:rgb(20, 24, 35)\">一、食材的新鮮</span><br />\r\n<span style=\"color:rgb(20, 24, 35)\">二、品項的豐富<br />\r\n三、衛生的環境&nbsp;<br />\r\n四、親切的服務</span></p>\r\n\r\n<p><span style=\"font-size:13px\">營業時間　週一 - 週日：11:00 到 23:00</span></p>\r\n','20150408100136256531.jpg','20150126064933768188.jpg','20150126064922332825.jpg','20150126064925403565.jpg','20150126064929674988.jpg','20150126064915685425.jpg','','','',9,1,'2015-01-26 06:51:07','2015-04-08 10:01:38','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(45,1,8,47,13,'北澤壽喜燒','Susi','<p><span style=\"color:rgb(78, 86, 101)\">～來自日本 ★最傳統的幸福美味★ 北澤壽喜燒～</span></p>\r\n\r\n<p><span style=\"color:rgb(78, 86, 101)\">營業時間 11:00 - 22:30</span></p>\r\n\r\n<p><span style=\"color:rgb(115, 77, 39)\">北澤壽喜燒採</span>桌邊式服務<span style=\"color:rgb(115, 77, 39)\">，限時九十分鐘，用餐方式為壽喜燒鍋，以及雙鍋兩種消費模式，您可以依照需求選擇。主餐之肉品、蔬食、菇類等食材均可無限量供應，無酒精飲料可無限暢飲，另提供一份餐後甜點。</span><br />\r\n&nbsp;</p>\r\n','20150408100123487030.jpg','20150126065643376557.jpg','20150126065631790558.jpg','20150126065635137421.jpg','20150126065639276764.jpg','20150126065624786957.jpg','','','',10,1,'2015-01-26 06:58:49','2015-04-08 10:01:26','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(46,1,8,47,13,'泰板燒',' Thaipanyaki ','<p><span style=\"color:rgb(78, 86, 101)\">羅阿明 廚藝總監 與 智群帷幄顧問公司堅強團隊 攜手打造全世界第一個泰式鐵板料理品牌。</span></p>\r\n\r\n<p><span style=\"color:rgb(78, 86, 101)\">本日營業時間 11:30 - 14:30, 17:30 - 22:00</span></p>\r\n','20150408100059684357.jpg','20150126070715113495.jpg','20150126070701649567.jpg','20150126070705895843.jpg','20150126070710973663.jpg','20150126070655223114.jpg','','','',11,1,'2015-01-26 07:07:51','2015-04-08 10:01:04','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(47,1,8,12,13,'驚嚇搖滾廚房','Rock Shock','<p><span style=\"color:rgb(20, 24, 35)\">老闆所堅持不拖泥帶水的手工創新料理! 把最道地的美式餐點,義式料理做結合, 帶給喜歡嘗鮮的</span><span style=\"color:rgb(20, 24, 35)\">饕客們不一樣的美食! 當然喜歡音樂和攝影的朋友們,也不要錯過老闆精心設計的拍照主題和所推薦的音樂喔!</span></p>\r\n','20150408100036803802.jpg','20150126071948723663.jpg','20150126071934973114.jpg','20150126071938399567.jpg','20150126071943645843.jpg','20150126071928823517.jpg','','','',12,1,'2015-01-26 07:20:57','2015-04-08 10:00:43','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(48,1,8,12,13,'香菜餐廳Bar','','<p><span style=\"color:rgb(78, 86, 101)\">香菜餐廳Bar ,不用昂貴的價格,卻有美味道地的泰式料理‧串燒及啤酒, 舒適整潔的環境, 和親切的服務, 不管兩人約會小酌.家庭聚會,員工聚餐都適合的最佳選擇! :)</span></p>\r\n','20150408100022864166.jpg','20150126072907624725.jpg','20150126072855719391.jpg','20150126072859977386.jpg','20150126072903285675.jpg','20150126072849749969.jpg','','','',13,1,'2015-01-26 07:29:36','2015-04-08 10:00:29','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(49,1,8,76,13,'澄日式精緻料理帝王蟹鍋物','','<p><span style=\"color:rgb(78, 86, 101)\">座落於熱鬧的台北東區巷弄內,交通便利外 在用餐環境方面更特聘日系設計師帶入以結合中日文化的&quot;竹&quot;為店內裝潢的主要元素 在大片落地窗及店內隔間玻璃中鑲入竹片呈現出在熱鬧的東區街頭罕見的寧靜,帶著些許禪意的氛圍&nbsp;</span><br />\r\n<span style=\"color:rgb(78, 86, 101)\">店內座位配置上有別於一般t吃到飽餐廳的擁擠,吵雜 採L行走道設計並在座位區加入隔間玻璃創造獨立空間效果讓賓客們都能輕鬆愉快的享受 澄 細心為您打造的精緻美食饗宴~</span><br />\r\n<span style=\"color:rgb(78, 86, 101)\">以豪華帝王蟹,台灣黃金蝦,東石鮮蚵,鮮凍大軟絲等嚴選食材加上頂級肉品(美國Prime 無骨牛小排,雪花牛.小羔羊等)吃到飽為店內主打 搭配精緻日本料理:各式手捲,每周不定期由基隆魚市新鮮直送的生魚片(老闆的堅持)</span><br />\r\n<span style=\"color:rgb(78, 86, 101)\">握壽司:日本生食干貝.比目魚緣側.炙燒星鰻.炙燒鮭魚.</span><br />\r\n<span style=\"color:rgb(78, 86, 101)\">並依季節性適時的調整以呈現食材的豐富變化性及用料的講究</span><br />\r\n<span style=\"color:rgb(78, 86, 101)\">(全店備有約可容納80人座位 可供公司團體宴會使用 歡迎預約訂位)</span></p>\r\n','20150408095938552521.jpg','20150126073952678467.jpg','20150408095950167633.jpg','20150408095955542816.jpg','20150408095959155793.jpg','20150408095944768524.jpg','','','',14,1,'2015-01-26 07:39:57','2015-04-08 10:00:02','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(50,1,8,76,13,'炙 酒食廚房','','<p>對食材的執著，新鮮的漁獲，以及對服務的熱忱。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>營業時間&nbsp;週一 - 週日：&nbsp;17:30 到 1:00</p>\r\n\r\n<p>&nbsp;</p>\r\n','20150127101405577118.jpg','20150126074804773773.jpg','20150127101350369049.jpg','20150127101354316498.jpg','2015012710135917365.jpg','20150127101342288300.jpg','','','',15,1,'2015-01-26 08:58:20','2015-01-27 10:14:10','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(51,1,8,76,13,'川.譜 渝派四川美饌','','<p>川。譜有吃到飽囉!!!!!!!!!!! 【想吃川菜，有譜了】 【川。譜訴求】: 。中菜西吃--&gt;菜色特別而美味、裝潢走時尚LOUNGE風，吃川菜原 來也可以是一種潮流、享受樂趣!川。譜希望將傳統與時尚做一個巧 妙的結合! 。口味獨特--&gt;行政主廚師承四川，學藝精湛，為大家帶來最特別又 美味的菜色，未來會持續推出新的拿手菜! 。川菜居酒屋--&gt;川。譜雖然以四川菜為主打，但是有一個美麗的吧 台，想喝點小酒又吃膩一般下酒菜的顧客，可以試試川菜配酒的絕 妙搭配! 想嚐鮮? 想享受台灣獨一無二的美食? 想喝點小酒? 川。譜永遠歡迎您。</p>\r\n','20150127082434636017.jpg','2015012609053245258.jpg','20150127082447212067.jpg','20150127082450958343.jpg','20150127082454536163.jpg','20150127082441285614.jpg','','','',16,1,'2015-01-26 09:05:13','2015-01-27 08:24:56','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(52,1,8,76,155,'全家FamilyMart','','<p><span style=\"color:rgb(78, 86, 101)\">☆全家。就是你家。☆&nbsp;</span>http://www.family.com.tw/<span style=\"color:rgb(78, 86, 101)\">&nbsp;全家與你親密在一起，讓生活更有意思！</span></p>\r\n','2015012708194358320.jpg','20150126093053531830.jpg','20150127082004165741.jpg','20150127082020608002.jpg','20150127082024875274.jpg','20150127082012750396.jpg','','','',17,1,'2015-01-26 09:50:11','2015-01-27 08:20:27','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(53,1,11,117,13,'TEST2新增設施','','','','','','','','','','','',18,1,'2015-08-18 11:38:31','2015-09-04 03:33:48','','','','','',''),(54,1,11,117,75,'TEST2新增設施2','','','','','','','','','','','',19,0,'2015-08-18 11:38:54','0000-00-00 00:00:00','','','','','',''),(55,1,1,110,162,'nsst 設施','nsst local','<p>nsst 設施nsst 設施nsst 設施nsst 設施nsst 設施nsst 設施nsst 設施ㄒ</p>\r\n','20150904033516101838.jpg','20150904033519696747.jpg','20150904033511351959.jpg','20150904033509704803.jpg','20150904033505162629.jpg','20150904033514772064.jpg','','','',20,1,'2015-09-04 03:35:21','2015-09-04 03:37:02','','','','','',''),(56,1,22,163,165,'level4 設施','','<p>吃資5555555555555555555555555</p>\r\n','20150904034612173371.jpg','20150904034639668426.jpg','20150904034629784576.jpg','20150904034632696869.jpg','20150904034635706329.jpg','20150904034626332733.jpg','','','',21,1,'2015-09-04 03:47:09','2015-09-04 03:47:46','','','','','',''),(57,1,23,103,75,'level3 設施','','<p>gggggggggg</p>\r\n','20150904040236951355.jpg','20150904040257965759.jpg','20150904040249286743.gif','20150904040251846252.gif','20150904040255688476.gif','','','','',22,0,'2015-09-04 04:03:19','0000-00-00 00:00:00','','','','','','');

--
-- Table structure for table `layout`
--

CREATE TABLE `layout` (
  `id` int NOT NULL AUTO_INCREMENT,
  `layout_type` varchar(10) NOT NULL,
  `topic` varchar(200) NOT NULL,
  `pic1` varchar(50) NOT NULL,
  `amount` int NOT NULL COMMENT '數量',
  `html_name` varchar(50) NOT NULL COMMENT '引用的HTML檔案',
  `layout_width` int NOT NULL,
  `layout_height` int NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COMMENT='版面主檔';

--
-- Dumping data for table `layout`
--

INSERT INTO `layout` VALUES (1,'hor','橫樣式1','1.png',2,'layout-01.html',1920,1040,1,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(2,'hor','橫樣式2','2.png',1,'layout-02.html',1920,1040,2,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(3,'hor','橫樣式3','3.png',2,'layout-03.html',1920,1040,3,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(4,'hor','橫樣式4','4.png',2,'layout-04.html',1920,1040,4,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(5,'hor','橫樣式5','5.png',4,'layout-05.html',1920,1040,5,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(6,'hor','橫樣式6','6.png',4,'layout-06.html',1920,1040,6,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(7,'hor','橫樣式7','7.png',5,'layout-07.html',1920,1040,7,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(8,'hor','橫樣式8','8.png',5,'layout-08.html',1920,1040,8,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(9,'hor','橫樣式9','9.png',5,'layout-09.html',1920,1040,9,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(10,'hor','橫樣式10','10.png',5,'layout-10.html',1920,1040,10,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(11,'hor','橫樣式11','11.png',2,'layout-11.html',1920,1040,11,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(12,'hor','橫樣式12','12.png',5,'layout-12.html',1920,1040,12,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(13,'hor','橫樣式13','13.png',5,'layout-13.html',1920,1040,13,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(14,'hor','橫樣式14','14.png',5,'layout-14.html',1920,1040,14,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(16,'hor','橫樣式16','16.png',0,'layout-16.html',1920,1040,16,0,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(17,'hor','橫樣式17','17.png',0,'layout-17.html',1920,1040,17,0,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(18,'vert','直樣式18','18.png',1,'layout-18.html',1080,1860,18,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(19,'vert','直樣式19','19.png',2,'layout-19.html',1080,1860,19,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(20,'vert','直樣式20','20.png',2,'layout-20.html',1080,1860,20,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(21,'vert','直樣式21','21.png',4,'layout-21.html',1080,1860,21,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(22,'vert','直樣式22','22.png',4,'layout-22.html',1080,1860,22,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(23,'vert','直樣式23','23.png',5,'layout-23.html',1080,1860,23,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(24,'vert','直樣式24','24.png',2,'layout-24.html',1080,1860,24,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(25,'vert','直樣式25','25.png',5,'layout-25.html',1080,1860,25,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(26,'vert','直樣式26','26.png',5,'layout-26.html',1080,1860,26,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(27,'vert','直樣式27','27.png',5,'layout-27.html',1080,1860,27,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(28,'vert','直樣式28','28.png',5,'layout-28.html',1080,1860,28,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(29,'vert','直樣式29','29.png',5,'layout-29.html',1080,1860,29,1,'2014-12-02 00:00:00','2014-12-02 00:00:00'),(30,'hor','樣式e2tv','2.png',1,'layout-e2tv.html',1920,1040,18,1,'2016-01-15 11:34:13','2016-01-15 11:34:17');

--
-- Table structure for table `layout_item`
--

CREATE TABLE `layout_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `layout_id` int NOT NULL,
  `width` int NOT NULL,
  `height` int NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb3 COMMENT='版面細項';

--
-- Dumping data for table `layout_item`
--

INSERT INTO `layout_item` VALUES (1,1,1138,1040,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(2,1,462,1040,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(3,2,1600,1040,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(4,3,1600,960,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(5,3,1600,80,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(6,4,1600,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(7,4,1600,960,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(8,5,426,480,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(9,5,426,480,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(10,5,1170,960,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(11,5,1600,80,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(12,6,1174,960,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(13,6,426,480,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(14,6,426,480,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(15,6,1600,80,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(16,7,284,320,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(17,7,284,320,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(18,7,284,320,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(19,7,1316,960,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(20,7,1600,80,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(21,8,1316,960,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(22,8,284,320,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(23,8,284,320,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(24,8,284,320,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(25,8,1600,80,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(26,9,284,320,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(27,9,284,192,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(28,9,284,448,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(29,9,1316,960,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(30,9,1600,80,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(31,10,1316,960,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(32,10,284,320,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(33,10,284,192,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(34,10,284,448,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(35,10,1600,80,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(36,11,462,1040,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(37,11,1138,1040,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(38,12,1600,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(39,12,284,320,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(40,12,284,320,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(41,12,284,320,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(42,12,1316,960,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(43,13,1600,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(44,13,1316,960,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(45,13,284,320,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(46,13,284,320,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(47,13,284,320,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(48,14,1600,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(49,14,284,320,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(50,14,284,192,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(51,14,284,448,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(52,14,1316,960,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(53,15,1600,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(54,15,1316,960,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(55,15,284,320,3,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(56,15,284,192,4,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(57,15,284,448,5,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(58,18,1060,1570,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(59,19,1060,1490,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(60,19,1060,80,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(61,20,1060,80,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(62,20,1060,1490,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(63,21,530,462,1,1,'2015-01-11 15:02:52','2015-01-11 15:02:52'),(64,21,530,462,2,1,'2015-01-11 15:02:52','2015-01-11 15:02:53'),(65,21,1060,1028,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(66,21,1060,80,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(67,22,1060,80,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(68,22,1060,1028,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(69,22,530,462,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(70,22,530,462,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(71,23,352,308,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(72,23,354,308,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(73,23,354,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(74,23,1060,1182,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(75,23,1060,80,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(76,24,1060,462,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(77,24,1060,1108,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(78,25,352,308,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(79,25,354,308,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(80,25,354,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(81,25,1060,1182,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(82,25,1060,80,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(83,26,1060,80,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(84,26,1060,1182,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(85,26,352,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(86,26,354,308,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(87,26,354,308,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(88,27,496,308,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(89,27,212,308,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(90,27,352,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(91,27,1060,1182,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(92,27,1060,80,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(93,28,1060,80,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(94,28,1060,1182,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(95,28,496,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(96,28,212,308,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(97,28,352,308,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(98,29,1060,80,1,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(99,29,1060,1182,2,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(100,29,352,308,3,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(101,29,354,308,4,1,'2015-01-11 15:02:53','2015-01-11 15:02:53'),(102,29,354,308,5,1,'2015-01-11 15:02:53','2015-01-11 15:02:53');

--
-- Table structure for table `marquee`
--

CREATE TABLE `marquee` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `marquee_code` varchar(10) NOT NULL,
  `topic` varchar(200) NOT NULL,
  `detail` text NOT NULL,
  `color_code` varchar(6) NOT NULL,
  `url_link` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='跑馬燈';

--
-- Dumping data for table `marquee`
--

INSERT INTO `marquee` VALUES (1,1,8,'Q0001','跑馬燈1','歡迎','e2ddcf','','',1,1,'2020-03-03 11:37:49','2022-06-24 08:01:54');

--
-- Table structure for table `meteoro_log`
--

CREATE TABLE `meteoro_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `value` varchar(255) NOT NULL,
  `content` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `meteoro_log`
--

INSERT INTO `meteoro_log` VALUES (24,'2020-05-04 06:00:00','30','晴時多雲'),(25,'2020-05-05 06:00:00','30','多雲午後短暫雷陣雨'),(26,'2020-05-22 06:00:00','24','陰陣雨或雷雨'),(27,'2020-07-06 06:00:00','32','多雲午後短暫雷陣雨'),(28,'2020-07-09 06:00:00','32','多雲午後短暫雷陣雨'),(29,'2020-07-09 18:00:00','29','多雲'),(30,'2022-04-18 06:00:00','23','陰時多雲短暫陣雨'),(31,'2022-04-18 18:00:00','23','陰時多雲短暫陣雨'),(32,'2022-04-19 06:00:00','23','陰時多雲短暫陣雨');

--
-- Table structure for table `monitor`
--

CREATE TABLE `monitor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `terminal_id` int NOT NULL,
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

--
-- Dumping data for table `monitor`
--

INSERT INTO `monitor` VALUES (5,1,1,2,'2014-12-20 06:09:31'),(4,1,1,1,'2014-12-20 06:09:31'),(6,1,1,7,'2015-01-11 07:38:14'),(7,1,1,10,'2015-01-11 07:38:14');

--
-- Table structure for table `news_log`
--

CREATE TABLE `news_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url_link` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `image` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `public_date` datetime NOT NULL,
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='新聞列表';

--
-- Dumping data for table `news_log`
--


--
-- Table structure for table `picture`
--

CREATE TABLE `picture` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `pic_code` varchar(10) NOT NULL,
  `pic_w` int DEFAULT NULL,
  `pic_h` int NOT NULL,
  `pic_topic` varchar(200) NOT NULL,
  `pic_name` varchar(200) DEFAULT NULL,
  `pic_name_md5` varchar(50) DEFAULT NULL,
  `pic_type` varchar(20) DEFAULT NULL,
  `pic_size` varchar(50) DEFAULT NULL,
  `pic_desc` text,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COMMENT='圖片列表';

--
-- Dumping data for table `picture`
--

INSERT INTO `picture` VALUES (8,1,8,'P0001',500,750,'123','123132123.jpg','20220624073601927948.jpg','image/jpeg','73887','',1,1,'2022-06-24 07:36:01',NULL),(9,1,8,'P0002',2048,1367,'1234','131313.jpg','20220624073614341970.jpg','image/jpeg','691639','',2,1,'2022-06-24 07:36:14',NULL);

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pic1` char(26) NOT NULL,
  `name1` varchar(50) NOT NULL,
  `point` mediumint unsigned NOT NULL,
  `sort_id` smallint unsigned NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `product`
--

INSERT INTO `product` VALUES (1,'20141030193338652191.jpg','MyCard-150點',1500,2,1,'2014-10-28 00:00:00','2014-10-31 00:09:20'),(2,'201410301951546897.jpg','MyCard-50點',500,1,1,'2014-10-28 00:00:00','2014-10-31 00:09:24'),(11,'20141030235705500885.jpg','MyCard-450點',4500,3,1,'2014-10-30 23:57:13','0000-00-00 00:00:00'),(12,'20141031000436548950.jpg','MyCard-500點',5000,4,1,'2014-10-31 00:04:46','0000-00-00 00:00:00'),(13,'20141031000531627991.jpg','MyCard-1000點',10000,5,1,'2014-10-31 00:05:39','0000-00-00 00:00:00'),(14,'2014103100061220997.jpg','MyCard-1150點',11500,6,1,'2014-10-31 00:06:21','0000-00-00 00:00:00'),(15,'20141031000647130310.jpg','MyCard-5000點',50000,7,1,'2014-10-31 00:06:52','0000-00-00 00:00:00');

--
-- Table structure for table `prog_list`
--

CREATE TABLE `prog_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int NOT NULL,
  `prog_code` varchar(20) NOT NULL,
  `prog_name` varchar(200) NOT NULL,
  `prog_url` varchar(100) NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COMMENT='程式清單';

--
-- Dumping data for table `prog_list`
--

INSERT INTO `prog_list` VALUES (1,0,'TERMINAL','終端管理','/cms_terminal/monitor_list',2,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(2,0,'DATA','資料管理','/cms_data/data_list',3,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(3,0,'CONTENT','內容管理','/cms_content/content_list',4,0,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(4,0,'COMPANY','廠戶管理','/cms_company/company_list',5,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(5,0,'LOCATION','廠區管理','/cms_location/floor_list',6,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(6,1,'MONITOR_LIST','監控列表','/cms_terminal/monitor_list',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(7,1,'MONITOR_SCREEN','監控畫面','/cms_terminal/monitor_screen',2,0,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(8,1,'TERMINAL','終端機列表','/cms_terminal/terminal',4,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(9,1,'TERMINAL_SET','終端機設定','/cms_terminal/terminal_set',3,0,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(10,2,'VIDEO_LIST','影片列表','/cms_data/video',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(11,2,'PIC_LIST','圖片列表','/cms_data/pic',2,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(12,2,'MARQUEE','跑馬燈列表','/cms_data/marquee',3,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(13,2,'METEORO','氣象編輯','/cms_data/meteoro',4,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(14,2,'NEWS','新聞編輯','/cms_data/news',5,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(15,2,'FINANCE','財經編輯','/cms_data/finance',6,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(16,2,'CLOCK','時鐘編輯','/cms_data/clock',7,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(17,2,'TIMER','計時器編輯','/cms_data/timer',8,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(18,3,'EDITION_TYPE','編輯列表','',1,0,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(19,4,'COMPANY_LIST','廠戶列表','/cms_company/company',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(20,5,'FLOOR_LIST','樓層列表','/cms_location/floor_list',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(21,5,'TYPE_LIST','類型列表','/cms_location/class_list',2,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(22,5,'FACILITY_LIST','設施列表','/cms_location/facility_list',3,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(23,2,'SET','其它設定編輯','/cms_data/set_edit',9,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(24,0,'AUTH','帳號管理','/cms_auth/user',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00'),(25,24,'AUTH','帳號列表','/cms_auth/user',1,1,'2014-11-22 00:00:00','2014-11-22 00:00:00');

--
-- Table structure for table `pub_code`
--

CREATE TABLE `pub_code` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `kind_id` int NOT NULL,
  `code_code` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `code_name` text NOT NULL,
  `pic1` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pub_code`
--

INSERT INTO `pub_code` VALUES (14,1,1,3,'Taipei_City','臺北市','',2,1,'2014-11-29 10:55:04','2014-11-29 12:19:10'),(15,1,1,3,'New_Taipei_City','新北市','',1,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(16,1,1,3,'Taichung_City','臺中市','',4,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(17,1,1,3,'Tainan_City','臺南市','',5,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(18,1,1,3,'Kaohsiung_City','高雄市','',7,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(19,1,1,3,'Keelung_City','基隆市','',8,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(20,1,1,3,'Taoyuan_County','桃園市','',9,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(21,1,1,3,'Hsinchu_City','新竹市','',10,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(22,1,1,3,'Hsinchu_County','新竹縣','',12,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(23,1,1,3,'Miaoli_County','苗栗縣','',13,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(24,1,1,3,'Changhua_County','彰化縣','',15,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(25,1,1,3,'Nantou_County','南投縣','',16,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(26,1,1,3,'Yunlin_County','雲林縣','',17,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(27,1,1,3,'Chiayi_City','嘉義市','',18,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(28,1,1,3,'Chiayi_County','嘉義縣','',19,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(29,1,1,3,'Pingtung_County','屏東縣','',20,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(30,1,1,3,'Yilan_County','宜蘭縣','',21,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(31,1,1,3,'Hualien_County','花蓮縣','',23,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(32,1,1,3,'Taitung_County','臺東縣','',24,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(33,1,1,3,'Penghu_County','澎湖縣','',25,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(34,1,1,3,'Kinmen_County','金門縣','',27,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(35,1,1,3,'Lienchiang_County','連江縣','',28,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(39,1,1,4,'google','http://news.google.com.tw/news?pz=1&cf=all&ned=tw&hl=zh-TW&output=rss','',14,1,'2014-11-29 12:36:10','2014-11-29 12:36:10'),(40,1,1,5,'華爾街','http://cn.wsj.com/big5/rss01.xml','',3,1,'2014-12-07 03:13:01','2014-12-07 03:13:01'),(50,1,1,6,'-12','國際換日線以西','',11,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(51,1,1,6,'-11','薩摩亞','',29,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(52,1,1,6,'-10','夏威夷','',31,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(53,1,1,6,'-9','阿拉斯加','',32,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(54,1,1,6,'-8','下加利福尼亞','',44,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(55,1,1,6,'-7','加拿大','',34,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(56,1,1,6,'-6','中美洲','',35,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(57,1,1,6,'-5','波哥大','',36,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(58,1,1,6,'-4','古雅巴','',37,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(59,1,1,6,'-3','紐芬蘭','',38,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(60,1,1,6,'-2','大西洋中部','',39,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(61,1,1,6,'-1','亞速爾群島','',40,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(62,1,1,6,'0','倫敦','',41,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(63,1,1,6,'+1','中西非','',42,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(64,1,1,6,'+2','巴黎','',43,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(65,1,1,6,'+3','巴格達','',45,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(66,1,1,6,'+4','巴庫','',46,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(67,1,1,6,'+5','伊斯蘭馬巴德','',47,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(68,1,1,6,'+6','新西伯利亞','',48,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(69,1,1,6,'+7','曼谷','',49,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(70,1,1,6,'+8','台北','',50,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(71,1,1,6,'+9','東京','',51,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(72,1,1,6,'+10','布里斯本','',52,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(73,1,1,6,'+11','索羅門群島','',53,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(74,1,1,6,'+12','斐濟','',54,1,'2014-11-29 10:55:04','2014-11-29 10:55:04'),(81,1,1,7,'logo','','',6,1,'2015-01-03 09:07:57','2015-01-03 09:07:57'),(82,1,1,7,'system_name1','','',22,1,'2015-01-03 09:07:57','2015-01-03 09:07:57'),(83,1,1,7,'system_name2','','',30,1,'2015-01-03 09:07:57','2015-01-03 09:07:57'),(84,1,1,7,'footer','','',33,1,'2015-01-03 09:07:57','2015-01-03 09:07:57'),(86,1,1,4,'民視','http://news.ftv.com.tw/hinetnews/ftvnews.xml','',26,1,'2014-11-29 12:36:10','2014-11-29 12:36:10'),(87,1,8,2,NULL,'123',NULL,1,1,'2022-06-24 07:58:57',NULL),(88,1,8,1,NULL,'1232',NULL,1,1,'2022-06-24 08:00:48',NULL);

--
-- Table structure for table `pub_kind`
--

CREATE TABLE `pub_kind` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kind_code` varchar(20) NOT NULL,
  `kind_name` varchar(100) NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pub_kind`
--

INSERT INTO `pub_kind` VALUES (1,'FLOOR','樓層',1,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(2,'CLASS','類型',2,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(3,'METEORO','氣象',3,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(4,'NEWS','新聞',4,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(5,'FINANCE','財經',5,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(6,'CLOCK_AREA','時區',6,1,'2014-11-23 00:00:00','2014-11-23 00:00:00'),(7,'SET','其它設定',7,1,'2014-11-23 00:00:00','2014-11-23 00:00:00');

--
-- Table structure for table `sys_config`
--

CREATE TABLE `sys_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sys_code` varchar(20) NOT NULL,
  `sys_key` varchar(20) NOT NULL,
  `sys_value` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sys_config`
--

INSERT INTO `sys_config` VALUES (1,'COMPANY_NAME','公司名稱','新保技'),(2,'SIDEBAR_SWITCH','查詢側欄','0'),(3,'PAGE_SWITCH','頁籤','0');

--
-- Table structure for table `terminal`
--

CREATE TABLE `terminal` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `layout_id` int NOT NULL,
  `terminal_code` varchar(20) NOT NULL,
  `topic` varchar(200) NOT NULL,
  `pic1` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `pic2` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `pic3` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `system_name` varchar(100) NOT NULL,
  `system_desc` varchar(100) NOT NULL,
  `version` varchar(100) NOT NULL,
  `amount` int DEFAULT NULL,
  `protect_type` varchar(50) NOT NULL COMMENT '螢幕保護類型',
  `protect_sec` int NOT NULL COMMENT '螢幕保護秒數',
  `protect_type_2` varchar(20) NOT NULL DEFAULT 'gohome',
  `protect_sec_2` int NOT NULL DEFAULT '0',
  `sort_id` int NOT NULL,
  `right_function` varchar(50) DEFAULT NULL,
  `duty_1` varchar(50) DEFAULT NULL,
  `duty_2` varchar(50) DEFAULT NULL,
  `duty_3` varchar(50) DEFAULT NULL,
  `duty_4` varchar(50) DEFAULT NULL,
  `duty_5` varchar(50) DEFAULT NULL,
  `duty_6` varchar(50) DEFAULT NULL,
  `func_weather` int DEFAULT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COMMENT='終端機資料';

--
-- Dumping data for table `terminal`
--

INSERT INTO `terminal` VALUES (1,1,8,2,'No.1','Company','','','','0','0','0',1,'refresh',120,'refresh',120,1,'search','','','','','','',14,1,'2020-01-20 18:21:53','2020-05-05 11:17:21'),(2,1,8,8,'','','','','','0','0','0',5,'refresh',130,'refresh',130,2,'search','','','','','','',0,1,'2020-03-03 11:37:02','2020-06-11 14:06:27'),(3,1,8,10,'test','test','','','','0','0','0',5,'refresh',120,'refresh',120,3,'other','','','1231231','','','',15,1,'2020-07-09 15:47:47','2020-07-09 15:51:12'),(4,1,8,1,'test2','test','','','','0','0','0',2,'refresh',120,'refresh',120,4,'other','','','','','','',0,1,'2020-07-09 17:07:54','2020-07-09 17:09:38'),(5,1,8,10,'test1','test','','','','0','0','0',5,'refresh',120,'refresh',120,5,'search','','','','','','',0,1,'2020-07-09 17:32:26','2020-07-09 17:33:45'),(6,1,8,8,'test','test','','','','0','0','0',0,'refresh',120,'refresh',120,6,'search',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(7,1,8,8,'test','test','','','','0','0','0',5,'refresh',120,'refresh',120,7,'search','','','','','','',15,1,'2020-07-09 18:11:15','2020-07-09 18:13:36'),(8,1,8,13,'1f','跑起來','','','','0','0','0',0,'refresh',120,'refresh',120,8,'search',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(9,1,8,1,'123','123',NULL,NULL,NULL,'0','0','0',NULL,'refresh',120,'refresh',120,9,'search',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2022-06-24 07:32:37',NULL),(10,1,8,1,'123','123',NULL,NULL,NULL,'0','0','0',NULL,'refresh',120,'refresh',120,10,'search',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2022-06-24 07:32:53',NULL),(11,1,8,1,'123','123',NULL,NULL,NULL,'0','0','0',2,'refresh',120,'refresh',120,11,'search','','','','','','',0,1,'2022-06-24 07:33:06','2022-06-24 07:51:03');

--
-- Table structure for table `terminal_item`
--

CREATE TABLE `terminal_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `terminal_id` int NOT NULL,
  `layout_item_id` int NOT NULL,
  `item_type` varchar(20) DEFAULT NULL,
  `play_type` tinyint DEFAULT NULL,
  `timer` int DEFAULT NULL,
  `moniter_type` tinyint DEFAULT NULL,
  `is_protect` tinyint DEFAULT NULL COMMENT '是否為營幕保護',
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb3 COMMENT='監視器細項';

--
-- Dumping data for table `terminal_item`
--

INSERT INTO `terminal_item` VALUES (1,51,3,'meteoro',0,0,1,0,1,1,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(2,51,0,'',0,0,1,0,2,0,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(3,51,0,'',0,0,1,0,3,0,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(4,51,0,'',0,0,1,0,4,0,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(5,51,0,'',0,0,1,0,5,0,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(6,51,0,'',0,0,1,1,1,0,'2016-09-26 21:49:04','0000-00-00 00:00:00'),(7,1,3,'video',0,0,1,0,1,1,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(8,1,0,'',0,0,1,0,2,0,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(9,1,0,'',0,0,1,0,3,0,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(10,1,0,'',0,0,1,0,4,0,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(11,1,0,'',0,0,1,0,5,0,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(12,1,0,'',0,0,1,1,1,0,'2020-01-20 18:21:53','0000-00-00 00:00:00'),(13,2,21,'pic',2,10,3,0,1,1,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(14,2,22,'',0,0,1,0,2,1,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(15,2,23,'',0,0,1,0,3,1,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(16,2,24,'',0,0,1,0,4,1,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(17,2,25,'marquee',0,0,1,0,5,1,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(18,2,0,'',0,0,1,1,1,0,'2020-03-03 11:37:02','0000-00-00 00:00:00'),(19,3,31,'video',0,0,1,0,1,1,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(20,3,32,'pic',0,0,3,0,2,1,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(21,3,33,'',0,0,1,0,3,1,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(22,3,34,'',0,0,1,0,4,1,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(23,3,35,'marquee',0,0,1,0,5,1,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(24,3,0,'',0,0,1,1,1,0,'2020-07-09 15:47:47','0000-00-00 00:00:00'),(25,4,1,'pic',2,5,2,0,1,1,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(26,4,2,'',0,0,1,0,2,1,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(27,4,0,'',0,0,1,0,3,0,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(28,4,0,'',0,0,1,0,4,0,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(29,4,0,'',0,0,1,0,5,0,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(30,4,0,'',0,0,1,1,1,0,'2020-07-09 17:07:54','0000-00-00 00:00:00'),(31,5,31,'video',0,0,1,0,1,1,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(32,5,32,'timer',0,0,1,0,2,1,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(33,5,33,'meteoro',0,0,1,0,3,1,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(34,5,34,'clock',0,0,1,0,4,1,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(35,5,35,'marquee',0,0,1,0,5,1,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(36,5,0,'',0,0,1,1,1,0,'2020-07-09 17:32:26','0000-00-00 00:00:00'),(37,6,21,NULL,NULL,NULL,NULL,0,1,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(38,6,22,NULL,NULL,NULL,NULL,0,2,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(39,6,23,NULL,NULL,NULL,NULL,0,3,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(40,6,24,NULL,NULL,NULL,NULL,0,4,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(41,6,25,NULL,NULL,NULL,NULL,0,5,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(42,6,0,NULL,NULL,NULL,NULL,1,1,1,'2020-07-09 18:10:42','0000-00-00 00:00:00'),(43,7,21,'pic',2,5,2,0,1,1,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(44,7,22,'',0,0,1,0,2,1,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(45,7,23,'',0,0,1,0,3,1,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(46,7,24,'',0,0,1,0,4,1,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(47,7,25,'marquee',0,0,1,0,5,1,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(48,7,0,'',0,0,1,1,1,0,'2020-07-09 18:11:15','0000-00-00 00:00:00'),(49,8,43,NULL,NULL,NULL,NULL,0,1,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(50,8,44,NULL,NULL,NULL,NULL,0,2,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(51,8,45,NULL,NULL,NULL,NULL,0,3,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(52,8,46,NULL,NULL,NULL,NULL,0,4,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(53,8,47,NULL,NULL,NULL,NULL,0,5,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(54,8,0,NULL,NULL,NULL,NULL,1,1,1,'2022-04-18 17:01:38','0000-00-00 00:00:00'),(55,11,1,'pic',0,NULL,1,NULL,1,1,'2022-06-24 07:33:06',NULL),(56,11,2,'pic',0,NULL,1,NULL,2,1,'2022-06-24 07:33:06',NULL),(57,11,0,'',0,NULL,1,NULL,3,0,'2022-06-24 07:33:06',NULL),(58,11,0,'',0,NULL,1,NULL,4,0,'2022-06-24 07:33:06',NULL),(59,11,0,'',0,NULL,1,NULL,5,0,'2022-06-24 07:33:06',NULL),(60,11,0,'',0,NULL,1,1,1,0,'2022-06-24 07:33:06',NULL);

--
-- Table structure for table `terminal_item_sub`
--

CREATE TABLE `terminal_item_sub` (
  `id` int NOT NULL AUTO_INCREMENT,
  `terminal_item_id` int NOT NULL,
  `code_id` int NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3 COMMENT='區塊選擇內容';

--
-- Dumping data for table `terminal_item_sub`
--

INSERT INTO `terminal_item_sub` VALUES (6,1,15,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,13,2,1,1,'2020-06-11 14:06:07','0000-00-00 00:00:00'),(28,13,3,2,1,'2020-06-11 14:06:07','0000-00-00 00:00:00'),(29,13,4,3,1,'2020-06-11 14:06:07','0000-00-00 00:00:00'),(30,13,5,4,1,'2020-06-11 14:06:07','0000-00-00 00:00:00'),(31,13,6,5,1,'2020-06-11 14:06:07','0000-00-00 00:00:00'),(33,17,1,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,20,2,1,1,'2020-07-09 15:48:03','0000-00-00 00:00:00'),(38,23,1,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,25,3,1,1,'2020-07-09 17:08:31','0000-00-00 00:00:00'),(40,25,4,2,1,'2020-07-09 17:08:31','0000-00-00 00:00:00'),(41,25,5,3,1,'2020-07-09 17:08:31','0000-00-00 00:00:00'),(42,25,6,4,1,'2020-07-09 17:08:31','0000-00-00 00:00:00'),(44,32,5,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,33,15,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,34,4,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,35,1,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,43,4,1,1,'2020-07-09 18:11:31','0000-00-00 00:00:00'),(49,47,1,1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,55,8,1,1,'2022-06-24 07:37:44',NULL),(51,56,9,1,1,'2022-06-24 07:37:55',NULL);

--
-- Table structure for table `timer`
--

CREATE TABLE `timer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `timer_code` varchar(10) NOT NULL,
  `topic` varchar(200) NOT NULL,
  `detail` text NOT NULL,
  `r_year` varchar(4) NOT NULL,
  `r_month` varchar(2) NOT NULL,
  `r_day` varchar(2) NOT NULL,
  `r_hour` varchar(2) NOT NULL,
  `r_min` varchar(2) NOT NULL,
  `r_sec` varchar(2) NOT NULL,
  `full_date` varchar(20) NOT NULL,
  `default_type` tinyint NOT NULL COMMENT '1加2減',
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COMMENT='倒數計時';

--
-- Dumping data for table `timer`
--

INSERT INTO `timer` VALUES (4,1,1,'T0004','倒數計時抬頭','倒數計時描述','2015','1','31','17','00','00','2015-01-31 17:00:00',1,1,1,'2014-12-07 14:50:18','2015-08-04 04:57:07'),(5,1,8,'T0005','加計時','13','2015','7','1','00','00','00','2015-07-01 00:00:00',1,2,1,'2015-02-04 11:03:00','0000-00-00 00:00:00');

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `device_id` varchar(255) NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--


--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_admin_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `video_code` varchar(10) NOT NULL,
  `default_play` varchar(10) NOT NULL,
  `video_w` int DEFAULT NULL,
  `video_h` int NOT NULL,
  `video_topic` varchar(200) NOT NULL,
  `video_name` varchar(200) DEFAULT NULL,
  `video_name_md5` varchar(50) DEFAULT NULL,
  `video_type` varchar(20) DEFAULT NULL,
  `video_size` varchar(50) DEFAULT NULL,
  `youtube_code` varchar(100) DEFAULT NULL,
  `video_desc` text,
  `start_hour` varchar(5) DEFAULT NULL,
  `start_min` varchar(5) DEFAULT NULL,
  `start_sec` int NOT NULL,
  `end_hour` varchar(5) DEFAULT NULL,
  `end_min` varchar(5) DEFAULT NULL,
  `end_sec` int NOT NULL,
  `sort_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='影片列表';

--
-- Dumping data for table `video`
--



