MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_promotions:/tablelist/okayapi_jieqi_system_promotions.html
-- MySQL Table okayapi_jieqi_system_promotions
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_promotions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(15) NOT NULL COMMENT '',
`uid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`username` varchar(30) NOT NULL COMMENT '',
KEY `ip` (`ip`),
KEY `uid` (`uid`),
KEY `username` (`username`),
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-3 of 3 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
ip | varchar(15) | 否 | ||||
uid | int(11) | 0 | 否 | 0 | ||
username | varchar(30) | 否 |