MySQL Create Table SQL
Table Structure: okayapi_admanage_adlog:/tablelist/okayapi_admanage_adlog.html
-- MySQL Table okayapi_admanage_adlog
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_adlog` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`AdID` int(10) NOT NULL DEFAULT '0' COMMENT '',
`OptTime` varchar(20) NOT NULL COMMENT '操作时间',
`OptHour` varchar(5) NOT NULL COMMENT '操作时的小时',
`OptDay` varchar(5) NOT NULL COMMENT '操作时是几号',
`OptMonth` varchar(5) NOT NULL COMMENT '操作时的月份',
`OptYear` varchar(5) NOT NULL COMMENT '操作时的年份',
`OptType` varchar(10) NOT NULL COMMENT '操作类型show/click/conver',
KEY `AdID` (`AdID`),
KEY `OptTime` (`OptTime`),
KEY `OptHour` (`OptHour`),
KEY `OptDay` (`OptDay`),
KEY `OptMonth` (`OptMonth`),
KEY `OptYear` (`OptYear`),
KEY `OptType` (`OptType`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告管理-广告日志表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
AdID | int(10) | 0 | 否 | 0 | ||
OptTime | varchar(20) | 否 | 操作时间 | |||
OptHour | varchar(5) | 否 | 操作时的小时 | |||
OptDay | varchar(5) | 否 | 操作时是几号 | |||
OptMonth | varchar(5) | 否 | 操作时的月份 | |||
OptYear | varchar(5) | 否 | 操作时的年份 | |||
OptType | varchar(10) | 否 | 操作类型show/click/conver |