25 lines
1.3 KiB
SQL
25 lines
1.3 KiB
SQL
|
CREATE TABLE `wa_archives` (
|
||
|
|
`id` int unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`type` varchar(10) NOT NULL DEFAULT 'article',
|
||
|
|
`user_id` int unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
|
||
|
|
`category_id` int DEFAULT NULL COMMENT '分类ID',
|
||
|
|
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
|
||
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '标识',
|
||
|
|
`flag` varchar(100) DEFAULT '' COMMENT '标志',
|
||
|
|
`style` varchar(100) DEFAULT '' COMMENT '样式',
|
||
|
|
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
|
||
|
|
`images` varchar(1500) DEFAULT '' COMMENT '组图',
|
||
|
|
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
|
||
|
|
`intro` text,
|
||
|
|
`weigh` int NOT NULL DEFAULT '0' COMMENT '权重',
|
||
|
|
`views` int unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
|
||
|
|
`created_at` int DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` int DEFAULT NULL COMMENT '更新时间',
|
||
|
|
`publishtime` int DEFAULT NULL COMMENT '发布时间',
|
||
|
|
`deleted_at` int DEFAULT NULL COMMENT '删除时间',
|
||
|
|
`memo` varchar(100) DEFAULT '' COMMENT '备注',
|
||
|
|
`status` enum('normal','hidden','rejected','pulloff') NOT NULL DEFAULT 'normal' COMMENT '状态',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `weigh` (`weigh`,`publishtime`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=618 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='内容表';
|