MySQL Create Table SQL
Table Structure: okayapi_saixs_ad_site:/tablelist/okayapi_saixs_ad_site.html
-- MySQL Table okayapi_saixs_ad_site
-- From: OkayAPI.com
CREATE TABLE `okayapi_saixs_ad_site` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`site_name` tinytext NULL COMMENT '站点名称',
`site_describe` varchar(500) NULL COMMENT '站点描述',
`site_url` tinytext NULL COMMENT '站点网址_根目录 如http://www.xsnet.cn',
`site_code` text NULL COMMENT '站点代码',
KEY `site_name` (`site_name`),
KEY `site_describe` (`site_describe`),
KEY `site_url` (`site_url`),
KEY `site_code` (`site_code`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'saixs广告管理-站点';
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 |
---|---|---|---|---|---|---|
site_name | tinytext | 是 | 站点名称 | |||
site_describe | varchar(500) | 是 | 站点描述 | |||
site_url | tinytext | 是 | 站点网址_根目录 如http://www.xsnet.cn | |||
site_code | text | 是 | 站点代码 |