extraction-interface: Gazetteers_funcTables

annotate Gazetteers_funcTables_20150306.sql @ 98:5bea390e7ca9 extractapp

new: short tag in front of long tag

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 14 Mar 2016 14:43:42 +0100
parents	4b3da4802998
children

rev	line source
38 4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1 # ************************************************************
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	2 # Sequel Pro SQL dump
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	3 # Version 4096
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4 #
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 # http://www.sequelpro.com/
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6 # http://code.google.com/p/sequel-pro/
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7 #
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 # Host: 127.0.0.1 (MySQL 5.5.38)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 # Database: Gazetteers
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	10 # Generation Time: 2015-03-06 15:59:34 +0000
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	11 # ************************************************************
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	14 /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17 /!40101 SET NAMES utf8 /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 /!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19 /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20 /!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23 # Dump of table taglist
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 # ------------------------------------------------------------
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 DROP TABLE IF EXISTS `taglist`;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	28 CREATE TABLE `taglist` (
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	29 `id` int(10) NOT NULL AUTO_INCREMENT,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	30 `name` varchar(100) NOT NULL,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	31 `tag` varchar(100) NOT NULL,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	32 `color` varchar(30) NOT NULL,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	33 `systemName` varchar(255) NOT NULL,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	34 PRIMARY KEY (`id`),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	35 UNIQUE KEY `tag` (`tag`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38 LOCK TABLES `taglist` WRITE;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 /!40000 ALTER TABLE `taglist` DISABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 INSERT INTO `taglist` (`id`, `name`, `tag`, `color`, `systemName`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 VALUES
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 (2,'人名','person','rgb(8, 148, 255)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44 (19,'入仕時間','entry_time','rgb(174, 179, 39)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 (13,'字','zi','rgb(123, 128, 235)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 (14,'年號','nianhao','rgb(3, 235, 30)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 (15,'朝代','dy','rgb(67, 148, 95)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 (16,'官職','office','rgb(204, 0, 204)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 (17,'無意義','null','rgb(219, 219, 219)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 (18,'籍貫','jiguan','rgb(235, 57, 26)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 (20,'入仕方法','entry_way','rgb(100, 209, 194)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52 (21,'任職時間','post_time','rgb(252, 0, 151)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 (22,'任職種類','post_type','rgb(240, 40, 240)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 (23,'號','hao','rgb(0, 204, 255)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	55 (24,'入仕地點','entry_addr','rgb(179, 156, 6)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56 (25,'親屬關係','kins','rgb(101, 138, 214)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 (26,'別名','othername','rgb(141, 212, 224)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58 (27,'任官地點','post_address','rgb(230, 161, 192)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 (28,'出處','source_tag','rgb(122, 122, 122)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 (29,'前官','prev_office','rgb(110, 11, 98)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 (30,'後官','next_office','rgb(168, 57, 168)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 (31,'物產名稱','product_name','rgb(227, 63, 227)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 (32,'屬','shu','rgb(143, 14, 143)','interface'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 (34,'物產產地','product_place','rgb(7, 64, 209)','interface');
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 /!40000 ALTER TABLE `taglist` ENABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67 UNLOCK TABLES;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70 # Dump of table topic_regex_relation
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71 # ------------------------------------------------------------
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73 DROP TABLE IF EXISTS `topic_regex_relation`;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75 CREATE TABLE `topic_regex_relation` (
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	76 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77 `topic_id` int(11) NOT NULL DEFAULT '0',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 `regex_filename` varchar(100) NOT NULL DEFAULT '',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79 PRIMARY KEY (`id`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 LOCK TABLES `topic_regex_relation` WRITE;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 /!40000 ALTER TABLE `topic_regex_relation` DISABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85 INSERT INTO `topic_regex_relation` (`id`, `topic_id`, `regex_filename`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 VALUES
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87 (1,1,'Basic_Address.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88 (2,1,'entry_method_student.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89 (3,1,'hao.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 (4,1,'kin_name_relation.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91 (5,1,'post_year_month_day_former_post.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 (6,1,'post_year_month_day_type.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 (7,1,'post_year_month_day_with former post.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 (8,1,'post_year_type.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 (9,1,'source.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	96 (10,1,'test regex.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97 (11,1,'Zi.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98 (12,2,'zhishu.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99 (13,2,'product_name.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 (14,2,'product_name.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 (15,2,'product_name_place.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 (16,2,'product_name_place.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 (17,2,'product_name_started_with_space.txt'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 (18,1,'test2.txt');
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	106 /!40000 ALTER TABLE `topic_regex_relation` ENABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107 UNLOCK TABLES;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 # Dump of table topic_tag_relation
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 # ------------------------------------------------------------
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 DROP TABLE IF EXISTS `topic_tag_relation`;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	114
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115 CREATE TABLE `topic_tag_relation` (
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117 `topic_id` int(11) NOT NULL DEFAULT '0',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 `tag_id` int(10) NOT NULL DEFAULT '0',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 PRIMARY KEY (`id`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 LOCK TABLES `topic_tag_relation` WRITE;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 /!40000 ALTER TABLE `topic_tag_relation` DISABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 INSERT INTO `topic_tag_relation` (`id`, `topic_id`, `tag_id`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	126 VALUES
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127 (1,1,2),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 (2,1,13),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129 (3,1,14),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	130 (4,1,15),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 (5,1,16),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	132 (6,1,17),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	133 (7,1,18),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134 (8,1,19),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135 (9,1,20),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	136 (10,1,21),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 (11,1,22),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	138 (12,1,23),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	139 (13,1,24),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	140 (14,1,25),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	141 (15,1,26),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	142 (16,1,27),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	143 (17,1,28),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144 (18,1,29),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	145 (19,1,30),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 (20,2,31),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 (21,2,32),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 (22,2,17),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 (23,2,34),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	150 (24,2,26);
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	151
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 /!40000 ALTER TABLE `topic_tag_relation` ENABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 UNLOCK TABLES;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156 # Dump of table topics
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157 # ------------------------------------------------------------
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159 DROP TABLE IF EXISTS `topics`;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 CREATE TABLE `topics` (
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 `name` varchar(100) NOT NULL DEFAULT '',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164 `tag` varchar(100) NOT NULL DEFAULT '',
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	165 PRIMARY KEY (`id`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	167
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	168 LOCK TABLES `topics` WRITE;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	169 /!40000 ALTER TABLE `topics` DISABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171 INSERT INTO `topics` (`id`, `name`, `tag`)
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 VALUES
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	173 (1,'人物','person'),
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 (2,'物產','product_name');
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 /!40000 ALTER TABLE `topics` ENABLE KEYS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177 UNLOCK TABLES;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	178
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	179
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 /!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182 /!40101 SET SQL_MODE=@OLD_SQL_MODE /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;

Mercurial > hg > extraction-interface

annotate Gazetteers_funcTables_20150306.sql @ 98:5bea390e7ca9 extractapp