MySQL Create Table SQL
Table Structure: okayapi_xwx_chapter：/tablelist/okayapi_xwx_chapter.html
-- MySQL Table okayapi_xwx_chapter
-- From: OkayAPI.com
CREATE TABLE `okayapi_xwx_chapter` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`chapter_name` varchar(255) NOT NULL COMMENT '',
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '',
`book_id` int(10) NOT NULL COMMENT '',
`chapter_order` decimal(10,2) NOT NULL COMMENT '',
KEY `chapter_name` (`chapter_name`),
KEY `create_time` (`create_time`),
KEY `book_id` (`book_id`),
KEY `chapter_order` (`chapter_order`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'xiaoshuo小说-章节';
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 |
|---|---|---|---|---|---|---|
| chapter_name | varchar(255) | 否 | Normal Index | |||
| create_time | int(11) | 0 | 是 | 0 | ||
| book_id | int(10) | 否 | Normal Index | |||
| chapter_order | decimal(10,2) | 否 | Normal Index |
