MySQL Create Table SQL
Table Structure: okayapi_shopxo_s_payment:/tablelist/okayapi_shopxo_s_payment.html
-- MySQL Table okayapi_shopxo_s_payment
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_payment` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_shopxo_s_payment_name` char(30) NOT NULL COMMENT '名称',
`payment` char(60) NOT NULL COMMENT '唯一标记',
`logo` char(255) NOT NULL COMMENT 'logo',
`version` char(255) NOT NULL COMMENT '插件版本',
`apply_version` char(255) NOT NULL COMMENT '适用系统版本',
`okayapi_shopxo_s_payment_desc` char(255) NOT NULL COMMENT '插件描述',
`author` char(255) NOT NULL COMMENT '作者',
`author_url` char(255) NOT NULL COMMENT '作者主页',
`element` text NOT NULL COMMENT '配置项规则',
`config` text NOT NULL COMMENT '配置数据',
`apply_terminal` char(255) NOT NULL COMMENT '适用终端 php一维数组json字符串存储(pc, wap, ios, android, alipay, weixin, baidu)',
`is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用(0否,1是)',
`is_open_user` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否对用户开放',
`sort` tinyint(3) NOT NULL DEFAULT '0' COMMENT '顺序',
`upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
KEY `okayapi_shopxo_s_payment_name` (`okayapi_shopxo_s_payment_name`),
KEY `payment` (`payment`),
KEY `logo` (`logo`),
KEY `version` (`version`),
KEY `apply_version` (`apply_version`),
KEY `okayapi_shopxo_s_payment_desc` (`okayapi_shopxo_s_payment_desc`),
KEY `author` (`author`),
KEY `author_url` (`author_url`),
KEY `element` (`element`),
KEY `config` (`config`),
KEY `apply_terminal` (`apply_terminal`),
KEY `is_enable` (`is_enable`),
KEY `is_open_user` (`is_open_user`),
KEY `sort` (`sort`),
KEY `upd_time` (`upd_time`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-支付方式';
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 |
---|---|---|---|---|---|---|
okayapi_shopxo_s_payment_name | char(30) | 否 | 名称 | |||
payment | char(60) | 否 | 唯一标记 | Unique Index | ||
logo | char(255) | 否 | logo | |||
version | char(255) | 否 | 插件版本 | |||
apply_version | char(255) | 否 | 适用系统版本 | |||
okayapi_shopxo_s_payment_desc | char(255) | 否 | 插件描述 | |||
author | char(255) | 否 | 作者 | |||
author_url | char(255) | 否 | 作者主页 | |||
element | text | 是 | 配置项规则 | |||
config | text | 是 | 配置数据 | |||
apply_terminal | char(255) | 否 | 适用终端 php一维数组json字符串存储(pc, wap, ios, android, alipay, weixin, baidu) | |||
is_enable | tinyint(1) | 1 | 否 | 是否启用(0否,1是) | Normal Index | 1 |
is_open_user | tinyint(1) | 0 | 否 | 是否对用户开放 | 0 | |
sort | tinyint(3) | 0 | 否 | 顺序 | 0 | |
upd_time | int(11) | 0 | 否 | 更新时间 | 0 |