MySQL Create Table SQL
Table Structure: okayapi_studyabc_tinyenglish：/tablelist/okayapi_studyabc_tinyenglish.html
-- MySQL Table okayapi_studyabc_tinyenglish
-- From: OkayAPI.com
CREATE TABLE `okayapi_studyabc_tinyenglish` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`idate` int(10) NOT NULL COMMENT '',
`md5hash` varchar(64) NOT NULL COMMENT '英语语句的hash数值用以保证不会重复采集',
`econtent` text NOT NULL COMMENT '英文内容',
`zcontent` text NOT NULL COMMENT '中文内容',
`imguri` varchar(255) NOT NULL COMMENT '图片地址',
`innermguri` varchar(100) NOT NULL DEFAULT '''' COMMENT '',
`createtime` int(10) NOT NULL COMMENT '采集时间',
KEY `idate` (`idate`),
KEY `md5hash` (`md5hash`),
KEY `econtent` (`econtent`),
KEY `zcontent` (`zcontent`),
KEY `imguri` (`imguri`),
KEY `innermguri` (`innermguri`),
KEY `createtime` (`createtime`),
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-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| idate | int(10) | 否 | ||||
| md5hash | varchar(64) | 否 | 英语语句的hash数值用以保证不会重复采集 | Unique Index | ||
| econtent | text | 否 | 英文内容 | |||
| zcontent | text | 否 | 中文内容 | |||
| imguri | varchar(255) | 否 | 图片地址 | |||
| innermguri | varchar(100) | '' | 否 | '' | ||
| createtime | int(10) | 否 | 采集时间 |
