MySQL Create Table SQL
Table Structure: okayapi_appver_apk_download_record：/tablelist/okayapi_appver_apk_download_record.html
-- MySQL Table okayapi_appver_apk_download_record
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_apk_download_record` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`app_id` int(11) NOT NULL DEFAULT '0' COMMENT 'AppId',
`version_id` int(11) NOT NULL DEFAULT '0' COMMENT '版本ID',
`channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '渠道ID',
`apk_id` int(11) NOT NULL DEFAULT '0' COMMENT 'apkId',
`download_num` int(11) NOT NULL DEFAULT '0' COMMENT 'apk下载量',
`download_date` date NOT NULL COMMENT '',
KEY `app_id` (`app_id`),
KEY `version_id` (`version_id`),
KEY `channel_id` (`channel_id`),
KEY `apk_id` (`apk_id`),
KEY `download_num` (`download_num`),
KEY `download_date` (`download_date`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-APK下载纪录';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| app_id | int(11) | 0 | 否 | AppId | Normal Index | 0 |
| version_id | int(11) | 0 | 否 | 版本ID | 0 | |
| channel_id | int(11) | 0 | 否 | 渠道ID | 0 | |
| apk_id | int(11) | 0 | 否 | apkId | Normal Index | 0 |
| download_num | int(11) | 0 | 否 | apk下载量 | 0 | |
| download_date | date | 否 | Normal Index |
