MySQL Create Table SQL
Table Structure: okayapi_box_promo:/tablelist/okayapi_box_promo.html
-- MySQL Table okayapi_box_promo
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_promo` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(100) NULL COMMENT '',
`description` text NULL COMMENT '',
`type` varchar(30) NULL DEFAULT 'percentage' COMMENT 'absolute, percentage, trial',
`value` decimal(18,2) NULL COMMENT '',
`maxuses` int(11) NULL DEFAULT '0' COMMENT '',
`used` int(11) NULL DEFAULT '0' COMMENT '',
`freesetup` tinyint(1) NULL DEFAULT '0' COMMENT '',
`once_per_client` tinyint(1) NULL DEFAULT '0' COMMENT '',
`recurring` tinyint(1) NULL DEFAULT '0' COMMENT '',
`active` tinyint(1) NULL DEFAULT '0' COMMENT '',
`products` text NULL COMMENT '',
`periods` text NULL COMMENT '',
`client_groups` text NULL COMMENT '',
`start_at` datetime NULL COMMENT '',
`end_at` datetime NULL COMMENT '',
KEY `code` (`code`),
KEY `description` (`description`),
KEY `type` (`type`),
KEY `value` (`value`),
KEY `maxuses` (`maxuses`),
KEY `used` (`used`),
KEY `freesetup` (`freesetup`),
KEY `once_per_client` (`once_per_client`),
KEY `recurring` (`recurring`),
KEY `active` (`active`),
KEY `products` (`products`),
KEY `periods` (`periods`),
KEY `client_groups` (`client_groups`),
KEY `start_at` (`start_at`),
KEY `end_at` (`end_at`),
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-15 of 15 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
code | varchar(100) | 是 | Normal Index | |||
description | text | 是 | ||||
type | varchar(30) | percentage | 否 | absolute, percentage, trial | percentage | |
value | decimal(18,2) | 是 | ||||
maxuses | int(11) | 0 | 是 | 0 | ||
used | int(11) | 0 | 是 | 0 | ||
freesetup | tinyint(1) | 0 | 是 | 0 | ||
once_per_client | tinyint(1) | 0 | 是 | 0 | ||
recurring | tinyint(1) | 0 | 是 | 0 | ||
active | tinyint(1) | 0 | 是 | Normal Index | 0 | |
products | text | 是 | ||||
periods | text | 是 | ||||
client_groups | text | 是 | ||||
start_at | datetime | 是 | Normal Index | |||
end_at | datetime | 是 | Normal Index |