创建mysql数据表简单示例

Create Table: CREATE TABLE `yq_annotated_company_tag_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `batch_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `oid` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `idx_keyword` smallint(6) NOT NULL DEFAULT '0',
  `idx_sent` smallint(6) NOT NULL DEFAULT '0',
  `idx_insent` smallint(6) NOT NULL DEFAULT '0',
  `sentence` varchar(2048) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `result` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `batch_id_key` (`batch_id`),
  KEY `oid_key` (`oid`),
  KEY `idx_sent_key` (`idx_sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Create Table: CREATE TABLE `yq_annotated_company_news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `oid` varchar(24) COLLATE utf8_unicode_ci DEFAULT '',
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `content` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `oid_key` (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Create Table: CREATE TABLE `yq_annotated_company_keywords` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `comp_name` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `full` tinyint(4) NOT NULL DEFAULT '0',
  `eid` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `last_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `company_name` (`comp_name`(16))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci