MySQL Create Table SQL
Table Structure: okayapi_wp_terms:/tablelist/okayapi_wp_terms.html
-- MySQL Table okayapi_wp_terms
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_terms` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`term_id` bigint(20) NOT NULL COMMENT '',
`okayapi_wp_terms_name` varchar(200) NOT NULL COMMENT '',
`slug` varchar(200) NOT NULL COMMENT '',
`term_group` bigint(10) NOT NULL DEFAULT '0' COMMENT '',
KEY `term_id` (`term_id`),
KEY `okayapi_wp_terms_name` (`okayapi_wp_terms_name`),
KEY `slug` (`slug`),
KEY `term_group` (`term_group`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WordPress-条款表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
term_id | bigint(20) | 否 | ||||
okayapi_wp_terms_name | varchar(200) | 否 | Normal Index | |||
slug | varchar(200) | 否 | Normal Index | |||
term_group | bigint(10) | 0 | 否 | 0 |