MySQL Create Table SQL
Table Structure: okayapi_box_currency：/tablelist/okayapi_box_currency.html
-- MySQL Table okayapi_box_currency
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_currency` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(50) NULL COMMENT '',
`code` varchar(3) NULL COMMENT '',
`is_default` tinyint(1) NULL DEFAULT '0' COMMENT '',
`conversion_rate` decimal(13,6) NULL DEFAULT '1.000000' COMMENT '',
`format` varchar(30) NULL COMMENT '',
`price_format` varchar(50) NULL DEFAULT '1' COMMENT '',
KEY `title` (`title`),
KEY `code` (`code`),
KEY `is_default` (`is_default`),
KEY `conversion_rate` (`conversion_rate`),
KEY `format` (`format`),
KEY `price_format` (`price_format`),
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 |
|---|---|---|---|---|---|---|
| title | varchar(50) | 是 | ||||
| code | varchar(3) | 是 | ||||
| is_default | tinyint(1) | 0 | 是 | 0 | ||
| conversion_rate | decimal(13,6) | 1.000000 | 是 | 1.000000 | ||
| format | varchar(30) | 是 | ||||
| price_format | varchar(50) | 1 | 是 | 1 |
