about summary refs log tree commit diff stats
path: root/verbly/generator/schema.sql
diff options
context:
space:
mode:
authorKelly Rauchenberger <fefferburbia@gmail.com>2016-03-16 22:57:15 -0400
committerKelly Rauchenberger <fefferburbia@gmail.com>2016-03-16 22:57:15 -0400
commit29c6d78edb88a38c2bfde54fc7ecccc691bbef30 (patch)
tree21d458d02337420dfb1fd5eda4cffada38f9642a /verbly/generator/schema.sql
parent8b1333d0e6e2b9a5014bdbff2987d899f5413fee (diff)
downloadfurries-29c6d78edb88a38c2bfde54fc7ecccc691bbef30.tar.gz
furries-29c6d78edb88a38c2bfde54fc7ecccc691bbef30.tar.bz2
furries-29c6d78edb88a38c2bfde54fc7ecccc691bbef30.zip
Added verbly submodule
Diffstat (limited to 'verbly/generator/schema.sql')
-rw-r--r--verbly/generator/schema.sql252


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

@@ -1,252 +0,0 @@

1DROP TABLE IF EXISTS `verbs`;


2CREATE 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


11DROP TABLE IF EXISTS `groups`;


12CREATE TABLE `groups` (


13  `group_id` INTEGER PRIMARY KEY,


14  `parent_id` INTEGER,


15  FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`)


16);


17


18DROP TABLE IF EXISTS `frames`;


19CREATE 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


26DROP TABLE IF EXISTS `verb_groups`;


27CREATE 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


34DROP TABLE IF EXISTS `adjectives`;


35CREATE 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


43DROP TABLE IF EXISTS `adverbs`;


44CREATE 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


51DROP TABLE IF EXISTS `nouns`;


52CREATE TABLE `nouns` (


53  `noun_id` INTEGER PRIMARY KEY,


54  `singular` VARCHAR(32) NOT NULL,


55  `plural` VARCHAR(32)


56);


57


58DROP TABLE IF EXISTS `hypernymy`;


59CREATE 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


66DROP TABLE IF EXISTS `instantiation`;


67CREATE 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


74DROP TABLE IF EXISTS `member_meronymy`;


75CREATE 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


82DROP TABLE IF EXISTS `part_meronymy`;


83CREATE 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


90DROP TABLE IF EXISTS `substance_meronymy`;


91CREATE 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


98DROP TABLE IF EXISTS `variation`;


99CREATE 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


106DROP TABLE IF EXISTS `noun_antonymy`;


107CREATE 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


114DROP TABLE IF EXISTS `adjective_antonymy`;


115CREATE 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


122DROP TABLE IF EXISTS `adverb_antonymy`;


123CREATE 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


130DROP TABLE IF EXISTS `specification`;


131CREATE 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


138DROP TABLE IF EXISTS `pertainymy`;


139CREATE 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


146DROP TABLE IF EXISTS `mannernymy`;


147CREATE 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


154DROP TABLE IF EXISTS `noun_synonymy`;


155CREATE 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


162DROP TABLE IF EXISTS `adjective_synonymy`;


163CREATE 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


170DROP TABLE IF EXISTS `adverb_synonymy`;


171CREATE 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


178DROP TABLE IF EXISTS `noun_pronunciations`;


179CREATE 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


185DROP TABLE IF EXISTS `verb_pronunciations`;


186CREATE 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


192DROP TABLE IF EXISTS `adjective_pronunciations`;


193CREATE 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


199DROP TABLE IF EXISTS `adverb_pronunciations`;


200CREATE 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


206DROP TABLE IF EXISTS `noun_noun_derivation`;


207CREATE 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


214DROP TABLE IF EXISTS `noun_adjective_derivation`;


215CREATE 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


222DROP TABLE IF EXISTS `noun_adverb_derivation`;


223CREATE 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


230DROP TABLE IF EXISTS `adjective_adjective_derivation`;


231CREATE 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


238DROP TABLE IF EXISTS `adjective_adverb_derivation`;


239CREATE 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


246DROP TABLE IF EXISTS `adverb_adverb_derivation`;


247CREATE 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);

 

generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-24 10:15:08 +0000