MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_report:/tablelist/okayapi_jieqi_system_report.html
-- MySQL Table okayapi_jieqi_system_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_report` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`reporttime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`reportuid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`reportname` varchar(30) NOT NULL COMMENT '',
`authtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`authuid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`authname` varchar(30) NOT NULL COMMENT '',
`reporttitle` varchar(100) NOT NULL COMMENT '',
`reporttext` mediumtext NOT NULL COMMENT '',
`reportsize` int(11) NOT NULL DEFAULT '0' COMMENT '',
`reportfield` varchar(250) NOT NULL COMMENT '',
`authnote` text NOT NULL COMMENT '',
`reportsort` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`reporttype` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`authflag` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
KEY `siteid` (`siteid`),
KEY `reporttime` (`reporttime`),
KEY `reportuid` (`reportuid`),
KEY `reportname` (`reportname`),
KEY `authtime` (`authtime`),
KEY `authuid` (`authuid`),
KEY `authname` (`authname`),
KEY `reporttitle` (`reporttitle`),
KEY `reporttext` (`reporttext`),
KEY `reportsize` (`reportsize`),
KEY `reportfield` (`reportfield`),
KEY `authnote` (`authnote`),
KEY `reportsort` (`reportsort`),
KEY `reporttype` (`reporttype`),
KEY `authflag` (`authflag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-报告';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-15 of 15 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
reporttime | int(11) | 0 | 否 | 0 | ||
reportuid | int(11) | 0 | 否 | 0 | ||
reportname | varchar(30) | 否 | Normal Index | |||
authtime | int(11) | 0 | 否 | 0 | ||
authuid | int(11) | 0 | 否 | 0 | ||
authname | varchar(30) | 否 | Normal Index | |||
reporttitle | varchar(100) | 否 | ||||
reporttext | mediumtext | 否 | ||||
reportsize | int(11) | 0 | 否 | 0 | ||
reportfield | varchar(250) | 否 | ||||
authnote | text | 否 | ||||
reportsort | smallint(6) | 0 | 否 | Normal Index | 0 | |
reporttype | smallint(6) | 0 | 否 | Normal Index | 0 | |
authflag | tinyint(3) | 0 | 否 | 0 |