· 8 years ago · May 19, 2018, 11:02 AM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5DROP SCHEMA IF EXISTS `verbivoredb` ;
6CREATE SCHEMA IF NOT EXISTS `verbivoredb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
7USE `verbivoredb`;
8
9-- -----------------------------------------------------
10-- Table `verbivoredb`.`words`
11-- -----------------------------------------------------
12DROP TABLE IF EXISTS `verbivoredb`.`words` ;
13
14CREATE TABLE IF NOT EXISTS `verbivoredb`.`words` (
15 `id` INT NOT NULL AUTO_INCREMENT ,
16 `word` VARCHAR(45) NULL ,
17 `first_seen` TIMESTAMP NULL ,
18 `last_seen` TIMESTAMP NULL ,
19 `frequency` INT NOT NULL DEFAULT 0 ,
20 PRIMARY KEY (`id`) )
21ENGINE = InnoDB;
22
23
24-- -----------------------------------------------------
25-- Table `verbivoredb`.`following_words`
26-- -----------------------------------------------------
27DROP TABLE IF EXISTS `verbivoredb`.`following_words` ;
28
29CREATE TABLE IF NOT EXISTS `verbivoredb`.`following_words` (
30 `id` INT NOT NULL AUTO_INCREMENT ,
31 `frequency` INT NOT NULL DEFAULT 0 ,
32 `root_word_id` INT NOT NULL ,
33 `following_word_id` INT NOT NULL ,
34 PRIMARY KEY (`id`) ,
35 INDEX `fk_following_words_root` (`root_word_id` ASC) ,
36 INDEX `fk_following_words_end` (`following_word_id` ASC) ,
37 CONSTRAINT `fk_following_words_root`
38 FOREIGN KEY (`root_word_id` )
39 REFERENCES `verbivoredb`.`words` (`id` )
40 ON DELETE NO ACTION
41 ON UPDATE NO ACTION,
42 CONSTRAINT `fk_following_words_end`
43 FOREIGN KEY (`following_word_id` )
44 REFERENCES `verbivoredb`.`words` (`id` )
45 ON DELETE NO ACTION
46 ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `verbivoredb`.`pos`
52-- -----------------------------------------------------
53DROP TABLE IF EXISTS `verbivoredb`.`pos` ;
54
55CREATE TABLE IF NOT EXISTS `verbivoredb`.`pos` (
56 `id` INT NOT NULL AUTO_INCREMENT ,
57 `tag_name` VARCHAR(16) NULL ,
58 PRIMARY KEY (`id`) )
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `verbivoredb`.`following_pos`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `verbivoredb`.`following_pos` ;
66
67CREATE TABLE IF NOT EXISTS `verbivoredb`.`following_pos` (
68 `id` INT NOT NULL AUTO_INCREMENT ,
69 `frequency` INT NOT NULL DEFAULT 0 ,
70 `following_pos_id` INT NOT NULL ,
71 `root_word_id` INT NOT NULL ,
72 PRIMARY KEY (`id`) ,
73 INDEX `fk_linkTableFollowingPos_pos` (`following_pos_id` ASC) ,
74 INDEX `fk_linkTableFollowingPos_words1` (`root_word_id` ASC) ,
75 CONSTRAINT `fk_linkTableFollowingPos_pos`
76 FOREIGN KEY (`following_pos_id` )
77 REFERENCES `verbivoredb`.`pos` (`id` )
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION,
80 CONSTRAINT `fk_linkTableFollowingPos_words1`
81 FOREIGN KEY (`root_word_id` )
82 REFERENCES `verbivoredb`.`words` (`id` )
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `verbivoredb`.`preceding_pos`
90-- -----------------------------------------------------
91DROP TABLE IF EXISTS `verbivoredb`.`preceding_pos` ;
92
93CREATE TABLE IF NOT EXISTS `verbivoredb`.`preceding_pos` (
94 `id` INT NOT NULL AUTO_INCREMENT ,
95 `frequency` INT NOT NULL DEFAULT 0 ,
96 `root_word_id` INT NOT NULL ,
97 `preceding_pos_id` INT NOT NULL ,
98 PRIMARY KEY (`id`) ,
99 INDEX `fk_linkTablePrecedingPos_words1` (`root_word_id` ASC) ,
100 INDEX `fk_linkTablePrecedingPos_pos1` (`preceding_pos_id` ASC) ,
101 CONSTRAINT `fk_linkTablePrecedingPos_words1`
102 FOREIGN KEY (`root_word_id` )
103 REFERENCES `verbivoredb`.`words` (`id` )
104 ON DELETE NO ACTION
105 ON UPDATE NO ACTION,
106 CONSTRAINT `fk_linkTablePrecedingPos_pos1`
107 FOREIGN KEY (`preceding_pos_id` )
108 REFERENCES `verbivoredb`.`pos` (`id` )
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION)
111ENGINE = InnoDB;
112
113
114-- -----------------------------------------------------
115-- Table `verbivoredb`.`preceding_words`
116-- -----------------------------------------------------
117DROP TABLE IF EXISTS `verbivoredb`.`preceding_words` ;
118
119CREATE TABLE IF NOT EXISTS `verbivoredb`.`preceding_words` (
120 `id` INT NOT NULL AUTO_INCREMENT ,
121 `frequency` INT NOT NULL DEFAULT 0 ,
122 `root_word_id` INT NOT NULL ,
123 `preceding_word_id` INT NOT NULL ,
124 PRIMARY KEY (`id`) ,
125 INDEX `fk_preceding_word_root` (`root_word_id` ASC) ,
126 INDEX `fk_preceding_word_end` (`preceding_word_id` ASC) ,
127 CONSTRAINT `fk_preceding_word_root`
128 FOREIGN KEY (`root_word_id` )
129 REFERENCES `verbivoredb`.`words` (`id` )
130 ON DELETE NO ACTION
131 ON UPDATE NO ACTION,
132 CONSTRAINT `fk_preceding_word_end`
133 FOREIGN KEY (`preceding_word_id` )
134 REFERENCES `verbivoredb`.`words` (`id` )
135 ON DELETE NO ACTION
136 ON UPDATE NO ACTION)
137ENGINE = InnoDB;
138
139
140-- -----------------------------------------------------
141-- Table `verbivoredb`.`verbivore_internals`
142-- -----------------------------------------------------
143DROP TABLE IF EXISTS `verbivoredb`.`verbivore_internals` ;
144
145CREATE TABLE IF NOT EXISTS `verbivoredb`.`verbivore_internals` (
146 `id` INT NOT NULL AUTO_INCREMENT ,
147 `record_name` VARCHAR(16) NULL ,
148 `record_value` VARCHAR(45) NULL ,
149 PRIMARY KEY (`id`) )
150ENGINE = InnoDB;
151
152
153-- -----------------------------------------------------
154-- Table `verbivoredb`.`pos_frequency`
155-- -----------------------------------------------------
156DROP TABLE IF EXISTS `verbivoredb`.`pos_frequency` ;
157
158CREATE TABLE IF NOT EXISTS `verbivoredb`.`pos_frequency` (
159 `id` INT NOT NULL AUTO_INCREMENT ,
160 `word_id` INT NOT NULL ,
161 `pos_id` INT NOT NULL ,
162 `frequency` INT NULL DEFAULT 0 ,
163 PRIMARY KEY (`id`) ,
164 INDEX `fk_pos_frequencies_words1` (`word_id` ASC) ,
165 INDEX `fk_pos_frequencies_pos1` (`pos_id` ASC) ,
166 CONSTRAINT `fk_pos_frequencies_words1`
167 FOREIGN KEY (`word_id` )
168 REFERENCES `verbivoredb`.`words` (`id` )
169 ON DELETE NO ACTION
170 ON UPDATE NO ACTION,
171 CONSTRAINT `fk_pos_frequencies_pos1`
172 FOREIGN KEY (`pos_id` )
173 REFERENCES `verbivoredb`.`pos` (`id` )
174 ON DELETE NO ACTION
175 ON UPDATE NO ACTION)
176ENGINE = InnoDB;
177
178
179
180SET SQL_MODE=@OLD_SQL_MODE;
181SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
182SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;