MySQL Create Table SQL
Table Structure: okayapi_material_goods：/tablelist/okayapi_material_goods.html
-- MySQL Table okayapi_material_goods
-- From: OkayAPI.com
CREATE TABLE `okayapi_material_goods` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tool_id` varchar(100) NOT NULL COMMENT '素材id',
`tag` varchar(300) NOT NULL COMMENT '素材名称',
`price` int(11) NOT NULL DEFAULT '1' COMMENT '物品单价单位分',
`display_price` int(11) NOT NULL DEFAULT '1' COMMENT '物品单价单位分',
`state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '物品上下架(1:上架， 0:下架)',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
KEY `tool_id` (`tool_id`),
KEY `tag` (`tag`),
KEY `price` (`price`),
KEY `display_price` (`display_price`),
KEY `state` (`state`),
KEY `create_time` (`create_time`),
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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| tool_id | varchar(100) | 否 | 素材id | Normal Index | ||
| tag | varchar(300) | 否 | 素材名称 | |||
| price | int(11) | 1 | 否 | 物品单价单位分 | 1 | |
| display_price | int(11) | 1 | 否 | 物品单价单位分 | 1 | |
| state | tinyint(1) | 0 | 否 | 物品上下架(1:上架， 0:下架) | 0 | |
| create_time | timestamp | CURRENT_TIMESTAMP | 否 | 创建时间 | CURRENT_TIMESTAMP |
