MySQL Create Table SQL
Table Structure: okayapi_fie_slide:/tablelist/okayapi_fie_slide.html
-- MySQL Table okayapi_fie_slide
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_slide` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_fie_slide_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示',
`delete_time` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
`okayapi_fie_slide_name` varchar(50) NOT NULL COMMENT '幻灯片分类',
`remark` varchar(255) NOT NULL COMMENT '分类备注',
KEY `okayapi_fie_slide_status` (`okayapi_fie_slide_status`),
KEY `delete_time` (`delete_time`),
KEY `okayapi_fie_slide_name` (`okayapi_fie_slide_name`),
KEY `remark` (`remark`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-幻灯片表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_fie_slide_status | tinyint(3) | 1 | 否 | 状态,1:显示,0不显示 | 1 | |
delete_time | int(10) | 0 | 否 | 删除时间 | 0 | |
okayapi_fie_slide_name | varchar(50) | 否 | 幻灯片分类 | |||
remark | varchar(255) | 否 | 分类备注 |