MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_power:/tablelist/okayapi_jieqi_system_power.html
-- MySQL Table okayapi_jieqi_system_power
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_power` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`modname` varchar(50) NOT NULL COMMENT '',
`pname` varchar(50) NOT NULL COMMENT '',
`ptitle` varchar(50) NOT NULL COMMENT '',
`pdescription` text NOT NULL COMMENT '',
`pgroups` text NOT NULL COMMENT '',
KEY `modname` (`modname`),
KEY `pname` (`pname`),
KEY `ptitle` (`ptitle`),
KEY `pdescription` (`pdescription`),
KEY `pgroups` (`pgroups`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-power';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
modname | varchar(50) | 否 | ||||
pname | varchar(50) | 否 | ||||
ptitle | varchar(50) | 否 | ||||
pdescription | text | 否 | ||||
pgroups | text | 否 |