diff options
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index 8e1e822..2295444 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -11,8 +11,7 @@ CREATE TABLE `verbs` ( | |||
11 | DROP TABLE IF EXISTS `groups`; | 11 | DROP TABLE IF EXISTS `groups`; |
12 | CREATE TABLE `groups` ( | 12 | CREATE TABLE `groups` ( |
13 | `group_id` INTEGER PRIMARY KEY, | 13 | `group_id` INTEGER PRIMARY KEY, |
14 | `parent_id` INTEGER, | 14 | `data` BLOB NOT NULL |
15 | FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`) | ||
16 | ); | 15 | ); |
17 | 16 | ||
18 | DROP TABLE IF EXISTS `frames`; | 17 | DROP TABLE IF EXISTS `frames`; |
@@ -251,3 +250,16 @@ CREATE TABLE `adverb_adverb_derivation` ( | |||
251 | FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), | 250 | FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), |
252 | FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) | 251 | FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) |
253 | ); | 252 | ); |
253 | |||
254 | DROP TABLE IF EXISTS `prepositions`; | ||
255 | CREATE TABLE `prepositions` ( | ||
256 | `preposition_id` INTEGER PRIMARY KEY, | ||
257 | `form` VARCHAR(32) NOT NULL | ||
258 | ); | ||
259 | |||
260 | DROP TABLE IF EXISTS `preposition_groups`; | ||
261 | CREATE TABLE `preposition_groups` ( | ||
262 | `preposition_id` INTEGER NOT NULL, | ||
263 | `groupname` VARCHAR(32) NOT NULL, | ||
264 | FOREIGN KEY (`preposition_id`) REFERENCES `prepositions`(`preposition_id`) | ||
265 | ); | ||