1 files changed, 252 insertions, 0 deletions
diff --git a/generator/schema.sql b/generator/schema.sql
new file mode 100644
index 0000000..b4efe0a
--- /dev/null
+++ b/generator/schema.sql

@@ -0,0 +1,252 @@
+DROP TABLE IF EXISTS `verbs`;
+CREATE TABLE `verbs` (
+  `verb_id` INTEGER PRIMARY KEY,
+  `infinitive` VARCHAR(32) NOT NULL,
+  `past_tense` VARCHAR(32) NOT NULL,
+  `past_participle` VARCHAR(32) NOT NULL,
+  `ing_form` VARCHAR(32) NOT NULL,
+  `s_form` VARCHAR(32) NOT NULL
+);
+DROP TABLE IF EXISTS `groups`;
+CREATE TABLE `groups` (
+  `group_id` INTEGER PRIMARY KEY,
+  `parent_id` INTEGER,
+  FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`)
+);
+DROP TABLE IF EXISTS `frames`;
+CREATE TABLE `frames` (
+  `frame_id` INTEGER PRIMARY KEY,
+  `group_id` INTEGER NOT NULL,
+  `data` BLOB NOT NULL,
+  FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)
+);
+DROP TABLE IF EXISTS `verb_groups`;
+CREATE TABLE `verb_groups` (
+  `verb_id` INTEGER NOT NULL,
+  `group_id` INTEGER NOT NULL,
+  FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`),
+  FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)
+);
+DROP TABLE IF EXISTS `adjectives`;
+CREATE TABLE `adjectives` (
+  `adjective_id` INTEGER PRIMARY KEY,
+  `base_form` VARCHAR(32) NOT NULL,
+  `comparative` VARCHAR(32),
+  `superlative` VARCHAR(32),
+  `position` CHAR(1)
+);
+DROP TABLE IF EXISTS `adverbs`;
+CREATE TABLE `adverbs` (
+  `adverb_id` INTEGER PRIMARY KEY,
+  `base_form` VARCHAR(32) NOT NULL,
+  `comparative` VARCHAR(32),
+  `superlative` VARCHAR(32)
+);
+DROP TABLE IF EXISTS `nouns`;
+CREATE TABLE `nouns` (
+  `noun_id` INTEGER PRIMARY KEY,
+  `singular` VARCHAR(32) NOT NULL,
+  `plural` VARCHAR(32)
+);
+DROP TABLE IF EXISTS `hypernymy`;
+CREATE TABLE `hypernymy` (
+  `hypernym_id` INTEGER NOT NULL,
+  `hyponym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`hypernym_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`hyponym_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `instantiation`;
+CREATE TABLE `instantiation` (
+  `class_id` INTEGER NOT NULL,
+  `instance_id` INTEGER NOT NULL,
+  FOREIGN KEY (`class_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`instance_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `member_meronymy`;
+CREATE TABLE `member_meronymy` (
+  `meronym_id` INTEGER NOT NULL,
+  `holonym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `part_meronymy`;
+CREATE TABLE `part_meronymy` (
+  `meronym_id` INTEGER NOT NULL,
+  `holonym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `substance_meronymy`;
+CREATE TABLE `substance_meronymy` (
+  `meronym_id` INTEGER NOT NULL,
+  `holonym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `variation`;
+CREATE TABLE `variation` (
+  `noun_id` INTEGER NOT NULL,
+  `adjective_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `noun_antonymy`;
+CREATE TABLE `noun_antonymy` (
+  `noun_1_id` INTEGER NOT NULL,
+  `noun_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `adjective_antonymy`;
+CREATE TABLE `adjective_antonymy` (
+  `adjective_1_id` INTEGER NOT NULL,
+  `adjective_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `adverb_antonymy`;
+CREATE TABLE `adverb_antonymy` (
+  `adverb_1_id` INTEGER NOT NULL,
+  `adverb_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
+  FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
+);
+DROP TABLE IF EXISTS `specification`;
+CREATE TABLE `specification` (
+  `general_id` INTEGER NOT NULL,
+  `specific_id` INTEGER NOT NULL,
+  FOREIGN KEY (`general_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`specific_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `pertainymy`;
+CREATE TABLE `pertainymy` (
+  `noun_id` INTEGER NOT NULL,
+  `pertainym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`pertainym_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `mannernymy`;
+CREATE TABLE `mannernymy` (
+  `adjective_id` INTEGER NOT NULL,
+  `mannernym_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`mannernym_id`) REFERENCES `adverbs`(`adverb_id`)
+);
+DROP TABLE IF EXISTS `noun_synonymy`;
+CREATE TABLE `noun_synonymy` (
+  `noun_1_id` INTEGER NOT NULL,
+  `noun_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`nouns_id`),
+  FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`nouns_id`)
+);
+DROP TABLE IF EXISTS `adjective_synonymy`;
+CREATE TABLE `adjective_synonymy` (
+  `adjective_1_id` INTEGER NOT NULL,
+  `adjective_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `adverb_synonymy`;
+CREATE TABLE `adverb_synonymy` (
+  `adverb_1_id` INTEGER NOT NULL,
+  `adverb_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
+  FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
+);
+DROP TABLE IF EXISTS `noun_pronunciations`;
+CREATE TABLE `noun_pronunciations` (
+  `noun_id` INTEGER NOT NULL,
+  `pronunciation` VARCHAR(64) NOT NULL,
+  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `verb_pronunciations`;
+CREATE TABLE `verb_pronunciations` (
+  `verb_id` INTEGER NOT NULL,
+  `pronunciation` VARCHAR(64) NOT NULL,
+  FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`)
+);
+DROP TABLE IF EXISTS `adjective_pronunciations`;
+CREATE TABLE `adjective_pronunciations` (
+  `adjective_id` INTEGER NOT NULL,
+  `pronunciation` VARCHAR(64) NOT NULL,
+  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `adverb_pronunciations`;
+CREATE TABLE `adverb_pronunciations` (
+  `adverb_id` INTEGER NOT NULL,
+  `pronunciation` VARCHAR(64) NOT NULL,
+  FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)
+);
+DROP TABLE IF EXISTS `noun_noun_derivation`;
+CREATE TABLE `noun_noun_derivation` (
+  `noun_1_id` INTEGER NOT NULL,
+  `noun_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`noun_id`)
+);
+DROP TABLE IF EXISTS `noun_adjective_derivation`;
+CREATE TABLE `noun_adjective_derivation` (
+  `noun_id` INTEGER NOT NULL,
+  `adjective_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `noun_adverb_derivation`;
+CREATE TABLE `noun_adverb_derivation` (
+  `noun_id` INTEGER NOT NULL,
+  `adverb_id` INTEGER NOT NULL,
+  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
+  FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)
+);
+DROP TABLE IF EXISTS `adjective_adjective_derivation`;
+CREATE TABLE `adjective_adjective_derivation` (
+  `adjective_1_id` INTEGER NOT NULL,
+  `adjective_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `adjective_adverb_derivation`;
+CREATE TABLE `adjective_adverb_derivation` (
+  `adjective_id` INTEGER NOT NULL,
+  `adverb_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`),
+  FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adjective_id`)
+);
+DROP TABLE IF EXISTS `adverb_adverb_derivation`;
+CREATE TABLE `adverb_adverb_derivation` (
+  `adverb_1_id` INTEGER NOT NULL,
+  `adverb_2_id` INTEGER NOT NULL,
+  FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
+  FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
+);

diff --git a/generator/schema.sql b/generator/schema.sql new file mode 100644 index 0000000..b4efe0a --- /dev/null +++ b/generator/schema.sql
@@ -0,0 +1,252 @@
	1	DROP TABLE IF EXISTS `verbs`;
	2	CREATE TABLE `verbs` (
	3	`verb_id` INTEGER PRIMARY KEY,
	4	`infinitive` VARCHAR(32) NOT NULL,
	5	`past_tense` VARCHAR(32) NOT NULL,
	6	`past_participle` VARCHAR(32) NOT NULL,
	7	`ing_form` VARCHAR(32) NOT NULL,
	8	`s_form` VARCHAR(32) NOT NULL
	9	);
	10
	11	DROP TABLE IF EXISTS `groups`;
	12	CREATE TABLE `groups` (
	13	`group_id` INTEGER PRIMARY KEY,
	14	`parent_id` INTEGER,
	15	FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`)
	16	);
	17
	18	DROP TABLE IF EXISTS `frames`;
	19	CREATE TABLE `frames` (
	20	`frame_id` INTEGER PRIMARY KEY,
	21	`group_id` INTEGER NOT NULL,
	22	`data` BLOB NOT NULL,
	23	FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)
	24	);
	25
	26	DROP TABLE IF EXISTS `verb_groups`;
	27	CREATE TABLE `verb_groups` (
	28	`verb_id` INTEGER NOT NULL,
	29	`group_id` INTEGER NOT NULL,
	30	FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`),
	31	FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)
	32	);
	33
	34	DROP TABLE IF EXISTS `adjectives`;
	35	CREATE TABLE `adjectives` (
	36	`adjective_id` INTEGER PRIMARY KEY,
	37	`base_form` VARCHAR(32) NOT NULL,
	38	`comparative` VARCHAR(32),
	39	`superlative` VARCHAR(32),
	40	`position` CHAR(1)
	41	);
	42
	43	DROP TABLE IF EXISTS `adverbs`;
	44	CREATE TABLE `adverbs` (
	45	`adverb_id` INTEGER PRIMARY KEY,
	46	`base_form` VARCHAR(32) NOT NULL,
	47	`comparative` VARCHAR(32),
	48	`superlative` VARCHAR(32)
	49	);
	50
	51	DROP TABLE IF EXISTS `nouns`;
	52	CREATE TABLE `nouns` (
	53	`noun_id` INTEGER PRIMARY KEY,
	54	`singular` VARCHAR(32) NOT NULL,
	55	`plural` VARCHAR(32)
	56	);
	57
	58	DROP TABLE IF EXISTS `hypernymy`;
	59	CREATE TABLE `hypernymy` (
	60	`hypernym_id` INTEGER NOT NULL,
	61	`hyponym_id` INTEGER NOT NULL,
	62	FOREIGN KEY (`hypernym_id`) REFERENCES `nouns`(`noun_id`),
	63	FOREIGN KEY (`hyponym_id`) REFERENCES `nouns`(`noun_id`)
	64	);
	65
	66	DROP TABLE IF EXISTS `instantiation`;
	67	CREATE TABLE `instantiation` (
	68	`class_id` INTEGER NOT NULL,
	69	`instance_id` INTEGER NOT NULL,
	70	FOREIGN KEY (`class_id`) REFERENCES `nouns`(`noun_id`),
	71	FOREIGN KEY (`instance_id`) REFERENCES `nouns`(`noun_id`)
	72	);
	73
	74	DROP TABLE IF EXISTS `member_meronymy`;
	75	CREATE TABLE `member_meronymy` (
	76	`meronym_id` INTEGER NOT NULL,
	77	`holonym_id` INTEGER NOT NULL,
	78	FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
	79	FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
	80	);
	81
	82	DROP TABLE IF EXISTS `part_meronymy`;
	83	CREATE TABLE `part_meronymy` (
	84	`meronym_id` INTEGER NOT NULL,
	85	`holonym_id` INTEGER NOT NULL,
	86	FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
	87	FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
	88	);
	89
	90	DROP TABLE IF EXISTS `substance_meronymy`;
	91	CREATE TABLE `substance_meronymy` (
	92	`meronym_id` INTEGER NOT NULL,
	93	`holonym_id` INTEGER NOT NULL,
	94	FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),
	95	FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)
	96	);
	97
	98	DROP TABLE IF EXISTS `variation`;
	99	CREATE TABLE `variation` (
	100	`noun_id` INTEGER NOT NULL,
	101	`adjective_id` INTEGER NOT NULL,
	102	FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
	103	FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
	104	);
	105
	106	DROP TABLE IF EXISTS `noun_antonymy`;
	107	CREATE TABLE `noun_antonymy` (
	108	`noun_1_id` INTEGER NOT NULL,
	109	`noun_2_id` INTEGER NOT NULL,
	110	FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`noun_id`),
	111	FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`noun_id`)
	112	);
	113
	114	DROP TABLE IF EXISTS `adjective_antonymy`;
	115	CREATE TABLE `adjective_antonymy` (
	116	`adjective_1_id` INTEGER NOT NULL,
	117	`adjective_2_id` INTEGER NOT NULL,
	118	FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
	119	FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
	120	);
	121
	122	DROP TABLE IF EXISTS `adverb_antonymy`;
	123	CREATE TABLE `adverb_antonymy` (
	124	`adverb_1_id` INTEGER NOT NULL,
	125	`adverb_2_id` INTEGER NOT NULL,
	126	FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
	127	FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
	128	);
	129
	130	DROP TABLE IF EXISTS `specification`;
	131	CREATE TABLE `specification` (
	132	`general_id` INTEGER NOT NULL,
	133	`specific_id` INTEGER NOT NULL,
	134	FOREIGN KEY (`general_id`) REFERENCES `adjectives`(`adjective_id`),
	135	FOREIGN KEY (`specific_id`) REFERENCES `adjectives`(`adjective_id`)
	136	);
	137
	138	DROP TABLE IF EXISTS `pertainymy`;
	139	CREATE TABLE `pertainymy` (
	140	`noun_id` INTEGER NOT NULL,
	141	`pertainym_id` INTEGER NOT NULL,
	142	FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
	143	FOREIGN KEY (`pertainym_id`) REFERENCES `adjectives`(`adjective_id`)
	144	);
	145
	146	DROP TABLE IF EXISTS `mannernymy`;
	147	CREATE TABLE `mannernymy` (
	148	`adjective_id` INTEGER NOT NULL,
	149	`mannernym_id` INTEGER NOT NULL,
	150	FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`),
	151	FOREIGN KEY (`mannernym_id`) REFERENCES `adverbs`(`adverb_id`)
	152	);
	153
	154	DROP TABLE IF EXISTS `noun_synonymy`;
	155	CREATE TABLE `noun_synonymy` (
	156	`noun_1_id` INTEGER NOT NULL,
	157	`noun_2_id` INTEGER NOT NULL,
	158	FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`nouns_id`),
	159	FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`nouns_id`)
	160	);
	161
	162	DROP TABLE IF EXISTS `adjective_synonymy`;
	163	CREATE TABLE `adjective_synonymy` (
	164	`adjective_1_id` INTEGER NOT NULL,
	165	`adjective_2_id` INTEGER NOT NULL,
	166	FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
	167	FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
	168	);
	169
	170	DROP TABLE IF EXISTS `adverb_synonymy`;
	171	CREATE TABLE `adverb_synonymy` (
	172	`adverb_1_id` INTEGER NOT NULL,
	173	`adverb_2_id` INTEGER NOT NULL,
	174	FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
	175	FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
	176	);
	177
	178	DROP TABLE IF EXISTS `noun_pronunciations`;
	179	CREATE TABLE `noun_pronunciations` (
	180	`noun_id` INTEGER NOT NULL,
	181	`pronunciation` VARCHAR(64) NOT NULL,
	182	FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`)
	183	);
	184
	185	DROP TABLE IF EXISTS `verb_pronunciations`;
	186	CREATE TABLE `verb_pronunciations` (
	187	`verb_id` INTEGER NOT NULL,
	188	`pronunciation` VARCHAR(64) NOT NULL,
	189	FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`)
	190	);
	191
	192	DROP TABLE IF EXISTS `adjective_pronunciations`;
	193	CREATE TABLE `adjective_pronunciations` (
	194	`adjective_id` INTEGER NOT NULL,
	195	`pronunciation` VARCHAR(64) NOT NULL,
	196	FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
	197	);
	198
	199	DROP TABLE IF EXISTS `adverb_pronunciations`;
	200	CREATE TABLE `adverb_pronunciations` (
	201	`adverb_id` INTEGER NOT NULL,
	202	`pronunciation` VARCHAR(64) NOT NULL,
	203	FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)
	204	);
	205
	206	DROP TABLE IF EXISTS `noun_noun_derivation`;
	207	CREATE TABLE `noun_noun_derivation` (
	208	`noun_1_id` INTEGER NOT NULL,
	209	`noun_2_id` INTEGER NOT NULL,
	210	FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`noun_id`),
	211	FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`noun_id`)
	212	);
	213
	214	DROP TABLE IF EXISTS `noun_adjective_derivation`;
	215	CREATE TABLE `noun_adjective_derivation` (
	216	`noun_id` INTEGER NOT NULL,
	217	`adjective_id` INTEGER NOT NULL,
	218	FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
	219	FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
	220	);
	221
	222	DROP TABLE IF EXISTS `noun_adverb_derivation`;
	223	CREATE TABLE `noun_adverb_derivation` (
	224	`noun_id` INTEGER NOT NULL,
	225	`adverb_id` INTEGER NOT NULL,
	226	FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),
	227	FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)
	228	);
	229
	230	DROP TABLE IF EXISTS `adjective_adjective_derivation`;
	231	CREATE TABLE `adjective_adjective_derivation` (
	232	`adjective_1_id` INTEGER NOT NULL,
	233	`adjective_2_id` INTEGER NOT NULL,
	234	FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),
	235	FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)
	236	);
	237
	238	DROP TABLE IF EXISTS `adjective_adverb_derivation`;
	239	CREATE TABLE `adjective_adverb_derivation` (
	240	`adjective_id` INTEGER NOT NULL,
	241	`adverb_id` INTEGER NOT NULL,
	242	FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`),
	243	FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adjective_id`)
	244	);
	245
	246	DROP TABLE IF EXISTS `adverb_adverb_derivation`;
	247	CREATE TABLE `adverb_adverb_derivation` (
	248	`adverb_1_id` INTEGER NOT NULL,
	249	`adverb_2_id` INTEGER NOT NULL,
	250	FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),
	251	FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)
	252	);