/*
Navicat MySQL Data Transfer
Source Server : dirsignage
Source Server Version : 50169
Source Host : 192.168.171.21:3306
Source Database : dirsignagedb
Target Server Type : MYSQL
Target Server Version : 50169
File Encoding : 65001
Date: 2015-03-20 09:39:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `company`
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`companyname_en` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`companyname_tc` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`companyaddress_en` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`companyaddress_tc` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`telephone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`logo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`floor` int(11) DEFAULT NULL,
`room_no` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`website` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`createdate` datetime DEFAULT NULL,
`createby` int(11) DEFAULT NULL,
`lastupdate` datetime DEFAULT NULL,
`lastupby` int(11) DEFAULT NULL,
`deleted` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('1', 'BBB Company', '三B公司', 'Room 301, Metropole Square, 2 On Yiu Street, Shatin, NT', '香港新界沙田安耀街2號新都廣場301室', '11223355', 'bbb@demo.com', '6LLTBX52_id_1.gif', '29', '29A', '61231231', 'demo.com', '1', '2015-01-02 15:45:11', '1', '2015-01-29 10:41:07', '2', '0');
INSERT INTO `company` VALUES ('2', 'AAA Company', '', 'Room 101, Metropole Square, 2 On Yiu Street, Shatin, NT', '香港新界沙田安耀街2號新都廣場101室', '11223344', '', 'BmADKm7q_id_2.jpg', '2', '2', '', '', '0', '2015-01-02 17:34:54', '2', '2015-02-09 11:53:09', '2', '0');
INSERT INTO `company` VALUES ('3', 'CCC1', 'CCC1', 'ccc1', 'ccc1', '612312311', 'ccc@demo.com1', 'N6Z4NrPW_id_3.jpg', '21', '201A1', '612312311', '1', '1', '2015-01-08 10:48:47', '1', '2015-01-08 16:36:44', '1', '1');
INSERT INTO `company` VALUES ('4', 'DDD', 'DDD', 'DDD', 'DDD', '6123123', 'kevin00001@livemail.tw', '', '3', 'D001', '61231231', 'test', '1', '2015-01-08 16:32:59', '1', '2015-01-08 16:32:59', '1', '1');
INSERT INTO `company` VALUES ('5', '1', '', '', '', '0', '', '', '1', '', '', '', '1', '2015-01-21 12:15:17', '1', '2015-01-21 12:20:04', '1', '1');
INSERT INTO `company` VALUES ('6', 'CCCCompany', 'CCCCompany', '111', '111', '111', '111', 'qI2GYrgb_id_6.gif', '1', '1', '111', '111', '1', '2015-01-27 16:07:59', '2', '2015-01-27 16:07:59', '2', '1');
INSERT INTO `company` VALUES ('7', '3C Company', '', '', '', '0', '', '', '2', '209', '', '', '1', '2015-02-09 12:00:02', '2', '2015-02-11 16:12:40', '1', '0');
INSERT INTO `company` VALUES ('8', 'DDD', 'DDDDDD', '', '', '0', '', '', '4', '401', '', '', '1', '2015-02-13 09:30:25', '1', '2015-02-13 09:32:15', '1', '1');
INSERT INTO `company` VALUES ('9', '13', '1313', '', '', '0', '', '', '2', '1301', '', '', '1', '2015-02-13 09:34:21', '1', '2015-02-13 09:34:21', '1', '1');
-- ----------------------------
-- Table structure for `config`
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module` varchar(20) DEFAULT NULL,
`config_name` varchar(100) DEFAULT NULL,
`config_value` varchar(100) DEFAULT NULL,
`config_desc` varchar(100) DEFAULT NULL,
`lastupdate` datetime DEFAULT NULL,
`lastupby` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'slideshow', '幻燈片速度', '5', '秒', '2015-01-08 11:34:59', '1');
INSERT INTO `config` VALUES ('2', 'slideshow', '空閒時間', '20', '秒', '2015-02-11 11:05:32', '1');
INSERT INTO `config` VALUES ('3', 'disable_floor', '隱藏樓層設定', '1,4,13,14,24', null, '2015-01-20 15:07:18', '1');
INSERT INTO `config` VALUES ('4', 'clear_text', '清空搜尋關鍵字', '15', '秒', '2015-02-17 09:37:25', '1');
-- ----------------------------
-- Table structure for `rolling_text`
-- ----------------------------
DROP TABLE IF EXISTS `rolling_text`;
CREATE TABLE `rolling_text` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content_en` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`content_tc` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`content_sc` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`sort` int(11) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`deleted` int(1) NOT NULL DEFAULT '0',
`createby` int(11) NOT NULL,
`createdate` datetime NOT NULL,
`lastupby` int(11) NOT NULL,
`lastupdate` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of rolling_text
-- ----------------------------
INSERT INTO `rolling_text` VALUES ('1', 'Rolling Text Demo 1: text', 'Rolling Text Demo 1: 中文', null, '1', '1', '0', '1', '2014-11-25 12:26:44', '2', '2015-01-21 17:38:30');
INSERT INTO `rolling_text` VALUES ('2', 'Rolling Text Demo 2: text', 'Rolling Text Demo 2: 中文', null, '2', '1', '0', '1', '2014-11-25 14:24:05', '1', '2015-01-08 10:39:29');
INSERT INTO `rolling_text` VALUES ('7', 'Testing 123456', null, null, '1', '0', '1', '2', '2015-01-21 12:21:13', '2', '2015-01-21 17:35:48');
INSERT INTO `rolling_text` VALUES ('3', 'Rolling Text Demo 3: text', 'Rolling Text Demo 3: 中文', null, '3', '1', '0', '1', '2014-11-25 14:24:18', '1', '2015-01-08 10:39:38');
INSERT INTO `rolling_text` VALUES ('6', '123', '23', null, '1', '1', '1', '1', '2015-01-08 10:37:31', '1', '2015-01-08 10:38:43');
INSERT INTO `rolling_text` VALUES ('9', 'Rolling Text 4: Testing 123', '', null, '4', '1', '0', '2', '2015-01-21 17:38:49', '2', '2015-01-21 17:38:49');
INSERT INTO `rolling_text` VALUES ('8', 'test', '', null, '1', '1', '1', '1', '2015-01-21 14:29:15', '1', '2015-01-21 14:29:15');
INSERT INTO `rolling_text` VALUES ('4', null, null, null, '1', '1', '1', '1', '2015-01-02 16:19:49', '1', '2015-01-02 16:20:01');
INSERT INTO `rolling_text` VALUES ('5', 'ehdfh222', 'hdfhgfg222', null, '1', '1', '1', '1', '2015-01-02 16:28:20', '1', '2015-01-02 16:33:14');
INSERT INTO `rolling_text` VALUES ('10', '', '', null, '1', '1', '1', '2', '2015-01-27 16:32:59', '2', '2015-01-27 16:32:59');
-- ----------------------------
-- Table structure for `slideshow`
-- ----------------------------
DROP TABLE IF EXISTS `slideshow`;
CREATE TABLE `slideshow` (
`slideid` int(10) NOT NULL AUTO_INCREMENT,
`slidetype` int(2) DEFAULT NULL,
`slidelink_en` varchar(200) DEFAULT NULL,
`slidelink_tc` varchar(200) DEFAULT NULL,
`slideimg_en` varchar(200) DEFAULT NULL,
`slideimg_tc` varchar(200) DEFAULT NULL,
`sort` int(10) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`deleted` int(1) NOT NULL DEFAULT '0',
`createdate` datetime DEFAULT NULL,
`createby` int(11) DEFAULT NULL,
`lastupdate` datetime DEFAULT NULL,
`lastupby` int(11) DEFAULT NULL,
PRIMARY KEY (`slideid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of slideshow
-- ----------------------------
INSERT INTO `slideshow` VALUES ('1', null, '', '', 'jXD9vK5C_slideid_1.jpg', 'nWXNxHgf_slideid_1.jpg', '1', '1', '1', '2015-01-08 09:57:14', '1', '2015-01-08 09:57:14', '1');
INSERT INTO `slideshow` VALUES ('2', null, '', '', 'SVptqyPD_slideid_2.jpg', 'FdEWPGVr_slideid_2.jpg', '1', '1', '0', '2015-01-08 10:19:59', '1', '2015-01-27 21:35:10', '2');
INSERT INTO `slideshow` VALUES ('3', null, '', '', 'qTcA72G8_slideid_3.jpg', 'IwQKueJU_slideid_3.jpg', '2', '1', '0', '2015-01-08 10:20:16', '1', '2015-01-27 21:35:11', '2');
INSERT INTO `slideshow` VALUES ('4', null, '', '', 'ctGFJnkB_slideid_4.jpg', 't6tbamrG_slideid_4.jpg', '3', '1', '1', '2015-01-12 10:17:29', '1', '2015-01-12 10:17:40', '1');
INSERT INTO `slideshow` VALUES ('5', null, '', '', 'MS7Ep5JX_slideid_5.png', 'thBKf3k5_slideid_5.png', '3', '1', '1', '2015-01-28 11:29:42', '2', '2015-01-28 11:29:42', '2');
-- ----------------------------
-- Table structure for `sys_cms_login`
-- ----------------------------
DROP TABLE IF EXISTS `sys_cms_login`;
CREATE TABLE `sys_cms_login` (
`cmsloginid` int(11) NOT NULL AUTO_INCREMENT,
`cmsusername` varchar(100) DEFAULT NULL,
`cmsloginname` varchar(50) DEFAULT NULL,
`cmsloginpw` varchar(200) DEFAULT NULL,
`cmsrole` varchar(50) DEFAULT '0',
`cmsstatus` int(1) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`createby` int(11) DEFAULT NULL,
`lastupdate` datetime DEFAULT NULL,
`lastupby` int(11) DEFAULT NULL,
`password_expirydate` datetime DEFAULT NULL,
PRIMARY KEY (`cmsloginid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_cms_login
-- ----------------------------
INSERT INTO `sys_cms_login` VALUES ('1', 'sky', 'skyadmin', '11c9c89bd1df9bc32a20b0a0dd9684895d2a4dd1a7b8b2b95c50fefd84b3a5f6', 'super_admin', '1', '2011-11-24 17:45:29', null, '2014-05-27 12:39:13', null, '2025-06-13 00:00:00');
INSERT INTO `sys_cms_login` VALUES ('2', 'User Admin', 'admin', 'de91048653d78d4e8460e24abb1a4ccd02d07cd587d5f1bb67ccd6672375ca39', 'admin', '1', '2013-11-13 15:51:46', null, '2015-01-02 16:36:22', null, '2015-06-13 00:00:00');
-- ----------------------------
-- Table structure for `sys_lang`
-- ----------------------------
DROP TABLE IF EXISTS `sys_lang`;
CREATE TABLE `sys_lang` (
`langid` int(10) NOT NULL AUTO_INCREMENT,
`langname` varchar(10) DEFAULT NULL,
`langcode` varchar(10) DEFAULT NULL,
`langsort` int(1) DEFAULT NULL,
`langstatus` int(1) DEFAULT NULL,
`createby` int(10) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`lastupby` int(10) DEFAULT NULL,
`lastupdate` datetime DEFAULT NULL,
PRIMARY KEY (`langid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_lang
-- ----------------------------
INSERT INTO `sys_lang` VALUES ('1', '英文', 'en', '1', '1', '1', '2013-07-05 11:31:49', '2', '2013-07-08 09:31:10');
INSERT INTO `sys_lang` VALUES ('2', '繁體中文', 'tc', '2', '1', '1', null, '2', null);
INSERT INTO `sys_lang` VALUES ('3', '简体中文', 'sc', '3', '0', '1', null, '2', null);
-- ----------------------------
-- Table structure for `sys_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`create_on` datetime NOT NULL,
`ip_address` varchar(500) NOT NULL,
`user_name` varchar(500) DEFAULT NULL,
`is_success` tinyint(1) NOT NULL,
`is_block` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `login_log_ix_create_on` (`create_on`),
KEY `login_log_ix_ip_address` (`ip_address`(255)),
KEY `login_log_ix_is_block` (`is_block`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
INSERT INTO `sys_login_log` VALUES ('1', '2015-01-02 11:42:32', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('2', '2015-01-02 16:36:31', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('3', '2015-01-02 16:36:47', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('4', '2015-01-02 16:36:59', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('5', '2015-01-02 17:17:33', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('6', '2015-01-02 17:28:35', '223.255.164.254', 'admin', '0', '0');
INSERT INTO `sys_login_log` VALUES ('7', '2015-01-02 17:28:53', '223.255.164.254', 'admin', '0', '0');
INSERT INTO `sys_login_log` VALUES ('8', '2015-01-02 17:29:58', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('9', '2015-01-05 12:01:19', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('10', '2015-01-05 16:14:28', '203.174.54.138', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('11', '2015-01-06 14:19:17', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('12', '2015-01-07 10:13:12', '::1', 'skyadmin', '0', '0');
INSERT INTO `sys_login_log` VALUES ('13', '2015-01-08 09:16:35', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('14', '2015-01-09 14:26:29', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('15', '2015-01-09 17:49:17', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('16', '2015-01-12 09:20:07', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('17', '2015-01-12 10:17:19', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('18', '2015-01-12 11:18:22', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('19', '2015-01-20 14:51:00', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('20', '2015-01-21 12:10:29', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('21', '2015-01-21 12:12:16', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('22', '2015-01-21 12:20:15', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('23', '2015-01-21 14:28:23', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('24', '2015-01-21 17:35:29', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('25', '2015-01-23 10:36:13', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('26', '2015-01-27 15:26:24', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('27', '2015-01-27 15:37:17', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('28', '2015-01-27 15:38:29', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('29', '2015-01-27 15:39:43', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('30', '2015-01-27 15:42:56', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('31', '2015-01-27 17:40:23', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('32', '2015-01-28 09:44:07', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('33', '2015-01-28 14:13:34', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('34', '2015-01-29 10:23:08', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('35', '2015-02-09 11:51:51', '223.255.164.254', 'admin', '0', '0');
INSERT INTO `sys_login_log` VALUES ('36', '2015-02-09 11:52:18', '223.255.164.254', 'admin', '0', '0');
INSERT INTO `sys_login_log` VALUES ('37', '2015-02-09 11:52:33', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('38', '2015-02-11 11:03:48', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('39', '2015-02-11 16:01:52', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('40', '2015-02-11 16:14:59', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('41', '2015-02-13 09:21:49', '223.255.164.254', 'skyadmin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('42', '2015-02-16 09:27:19', '223.255.164.254', 'admin', '1', '0');
INSERT INTO `sys_login_log` VALUES ('43', '2015-02-17 09:37:31', '223.255.164.254', 'skyadmin', '1', '0');