/* Navicat Premium Data Transfer Source Server : 本机 Source Server Type : MySQL Source Server Version : 50721 Source Host : localhost:3306 Source Schema : ci Target Server Type : MySQL Target Server Version : 50721 File Encoding : 65001 Date: 06/02/2018 15:52:21 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for s_enterprises -- ---------------------------- DROP TABLE IF EXISTS `s_enterprises`; CREATE TABLE `s_enterprises` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `uri` varchar(255) NOT NULL DEFAULT '', `title_logo` varchar(255) NOT NULL DEFAULT '', `logo` varchar(255) NOT NULL DEFAULT '', `content` text NOT NULL, `status` int(11) NOT NULL DEFAULT '1', `free_access` int(11) NOT NULL DEFAULT '0', `is_register` int(11) NOT NULL DEFAULT '0', `category_ids` varchar(255) NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of s_enterprises -- ---------------------------- BEGIN; INSERT INTO `s_enterprises` VALUES (1, '我的关爱', 'icarejoy', '/assets/uploadfile/image/20180205/20180205160738_24090.png', '/assets/uploadfile/image/20180205/20180205160722_87341.png', '', 1, 0, 1, '1|2|3|4|5|6', '2018-02-05 16:08:30', '2018-02-05 16:08:30'); INSERT INTO `s_enterprises` VALUES (2, '中国电信', 'telecom', '/assets/uploadfile/image/20180205/20180202105850_87339.png', '/assets/uploadfile/image/20180205/20180126142501_66223.png', '\"\"', 1, 0, 0, '1|2|3|4|5|6', '2018-02-05 16:16:34', '2018-02-05 16:36:00'); INSERT INTO `s_enterprises` VALUES (3, '中国东方航空', 'ceair', '/assets/uploadfile/image/20180206/20180206154619_34076.png', '/assets/uploadfile/image/20180206/20180206154609_11295.png', '\"\"', 1, 0, 0, '1|2|3|4|5|6', '2018-02-06 15:46:55', '2018-02-06 15:51:17'); COMMIT; SET FOREIGN_KEY_CHECKS = 1;