/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 80012
Source Host           : localhost:3306
Source Database       : writing

Target Server Type    : MYSQL
Target Server Version : 80012
File Encoding         : 65001

Date: 2022-11-27 20:50:36
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `lv_writing_dynastys`
-- ----------------------------
DROP TABLE IF EXISTS `lv_writing_dynastys`;
CREATE TABLE `lv_writing_dynastys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '朝代ID',
  `project_id` int(11) NOT NULL COMMENT '项目ID',
  `admin_id` int(11) NOT NULL COMMENT '管理员ID',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `name_tr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称繁体',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `content_tr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容繁体',
  `baidu_wiki` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '抓取地址',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='朝代表';

-- ----------------------------
-- Records of lv_writing_dynastys
-- ----------------------------
INSERT INTO `lv_writing_dynastys` VALUES ('1', '9', '1', '商', '商', null, null, null, '1', '1', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('2', '9', '1', '周', '周', null, null, null, '1', '2', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('3', '9', '1', '秦', '秦', null, null, null, '1', '3', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('4', '9', '1', '汉', '漢', null, null, null, '1', '4', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('5', '9', '1', '三国', '三國', null, null, null, '1', '5', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('6', '9', '1', '晋', '晉', null, null, null, '1', '6', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('7', '9', '1', '南北朝', '南北朝', null, null, null, '1', '7', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('8', '9', '1', '隋', '隋', null, null, null, '1', '8', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('9', '9', '1', '唐', '唐', null, null, null, '1', '9', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('10', '9', '1', '五代十国', '五代十國', null, null, null, '1', '10', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('11', '9', '1', '宋', '宋', null, null, null, '1', '11', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('12', '9', '1', '金', '金', null, null, null, '1', '12', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('13', '9', '1', '元', '元', null, null, null, '1', '13', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('14', '9', '1', '明', '明', null, null, null, '1', '14', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('15', '9', '1', '清', '清', null, null, null, '1', '15', '2022-10-12 18:29:57', null);
INSERT INTO `lv_writing_dynastys` VALUES ('16', '9', '1', '现代', '現代', null, null, null, '1', '16', '2022-10-12 18:29:57', null);