diff options
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index 2295444..f2445f0 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -36,7 +36,8 @@ CREATE TABLE `adjectives` ( | |||
36 | `base_form` VARCHAR(32) NOT NULL, | 36 | `base_form` VARCHAR(32) NOT NULL, |
37 | `comparative` VARCHAR(32), | 37 | `comparative` VARCHAR(32), |
38 | `superlative` VARCHAR(32), | 38 | `superlative` VARCHAR(32), |
39 | `position` CHAR(1) | 39 | `position` CHAR(1), |
40 | `complexity` INTEGER NOT NULL | ||
40 | ); | 41 | ); |
41 | 42 | ||
42 | DROP TABLE IF EXISTS `adverbs`; | 43 | DROP TABLE IF EXISTS `adverbs`; |
@@ -44,7 +45,8 @@ CREATE TABLE `adverbs` ( | |||
44 | `adverb_id` INTEGER PRIMARY KEY, | 45 | `adverb_id` INTEGER PRIMARY KEY, |
45 | `base_form` VARCHAR(32) NOT NULL, | 46 | `base_form` VARCHAR(32) NOT NULL, |
46 | `comparative` VARCHAR(32), | 47 | `comparative` VARCHAR(32), |
47 | `superlative` VARCHAR(32) | 48 | `superlative` VARCHAR(32), |
49 | `complexity` INTEGER NOT NULL | ||
48 | ); | 50 | ); |
49 | 51 | ||
50 | DROP TABLE IF EXISTS `nouns`; | 52 | DROP TABLE IF EXISTS `nouns`; |
@@ -52,7 +54,8 @@ CREATE TABLE `nouns` ( | |||
52 | `noun_id` INTEGER PRIMARY KEY, | 54 | `noun_id` INTEGER PRIMARY KEY, |
53 | `singular` VARCHAR(32) NOT NULL, | 55 | `singular` VARCHAR(32) NOT NULL, |
54 | `plural` VARCHAR(32), | 56 | `plural` VARCHAR(32), |
55 | `proper` INTEGER(1) NOT NULL | 57 | `proper` INTEGER(1) NOT NULL, |
58 | `complexity` INTEGER NOT NULL | ||
56 | ); | 59 | ); |
57 | 60 | ||
58 | DROP TABLE IF EXISTS `hypernymy`; | 61 | DROP TABLE IF EXISTS `hypernymy`; |