diff options
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 33 |
1 files changed, 23 insertions, 10 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index c3e54d8..33ebc28 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -186,19 +186,32 @@ CREATE TABLE `forms_pronunciations` ( | |||
186 | CREATE INDEX `pronunciation_of` ON `forms_pronunciations`(`form_id`); | 186 | CREATE INDEX `pronunciation_of` ON `forms_pronunciations`(`form_id`); |
187 | CREATE INDEX `spelling_of` ON `forms_pronunciations`(`pronunciation_id`); | 187 | CREATE INDEX `spelling_of` ON `forms_pronunciations`(`pronunciation_id`); |
188 | 188 | ||
189 | CREATE TABLE `groups` ( | 189 | CREATE TABLE `frames` ( |
190 | `group_id` INTEGER PRIMARY KEY, | 190 | `frame_id` INTEGER NOT NULL, |
191 | `data` BLOB NOT NULL | 191 | `group_id` INTEGER NOT NULL, |
192 | 'length' INTEGER NOT NULL | ||
192 | ); | 193 | ); |
193 | 194 | ||
194 | CREATE TABLE `frames` ( | 195 | CREATE INDEX `frames_in` ON `frames`(`group_id`); |
195 | `frame_id` INTEGER PRIMARY KEY, | 196 | |
196 | `data` BLOB NOT NULL | 197 | CREATE TABLE `parts` ( |
198 | `part_id` INTEGER PRIMARY KEY, | ||
199 | `frame_id` INTEGER NOT NULL, | ||
200 | `part_index` INTEGER NOT NULL, | ||
201 | `type` INTEGER NOT NULL, | ||
202 | `role` VARCHAR(16), | ||
203 | `selrestrs` BLOB, | ||
204 | `prepositions` BLOB, | ||
205 | `preposition_literality` SMALLINT, | ||
206 | `literal_value` VARCHAR(64) | ||
197 | ); | 207 | ); |
198 | 208 | ||
199 | CREATE TABLE `groups_frames` ( | 209 | CREATE INDEX `parts_of` ON `parts`(`frame_id`); |
200 | `group_id` INTEGER NOT NULL, | 210 | CREATE UNIQUE INDEX `part_by_frame_index` ON `parts`(`frame_id`, `part_index`); |
201 | `frame_id` INTEGER NOT NULL | 211 | |
212 | CREATE TABLE `synrestrs` ( | ||
213 | `part_id` INTEGER NOT NULL, | ||
214 | `synrestr` VARCHAR(32) NOT NULL | ||
202 | ); | 215 | ); |
203 | 216 | ||
204 | CREATE INDEX `frames_in` ON `groups_frames`(`group_id`); | 217 | CREATE INDEX `synrestrs_for` ON `synrestrs`(`part_id`); |