-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathADBL.sql
executable file
·107 lines (84 loc) · 6.48 KB
/
ADBL.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
/*
For more information write to Richard Alexander Castro Mamani rcastro AT hinant.in
cd /cygdrive/c/Users/rcastro/Documents/Navicat/MySQL/Servers/hinantin/HNTMedia
cd /cygdrive/c/Users/rcastro/Documents/Navicat/MySQL/Servers/192.168.43.79/ADBL
cp *.sql /cygdrive/c/Users/rcastro/Documents/RCastroq/CloudStorage/DropBox00001/Dropbox/05_Ashaninca/10_Base_de_Datos_Lexica
CREATE USER 'rcastro'@'localhost' IDENTIFIED BY '#rcastro?';
GRANT ALL ON *.* TO 'rcastro'@'%' IDENTIFIED BY '#rcastro?';
FLUSH PRIVILEGES;
*/
DROP DATABASE IF EXISTS `ADBL`;
CREATE DATABASE `ADBL` CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `ADBL`;
DROP TABLE IF EXISTS `Lexical_Unit`;
CREATE TABLE `Lexical_Unit`
(
`Id_Lexical_Unit` INT NOT NULL AUTO_INCREMENT,
`Is_Loan_Word` BIT(1) NOT NULL,
`Is_Dictionary_Entry` BIT(1) NOT NULL,
`Is_OWLU` BIT(1) NOT NULL,
PRIMARY KEY (`Id_Lexical_Unit`)
);
DROP TABLE IF EXISTS `Spelling`;
CREATE TABLE `Spelling`
(
`Id_Spelling` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`Word` TEXT NOT NULL,
`Spelling_System` VARCHAR(100) NOT NULL,
`Source` TEXT NOT NULL,
`Definition_EN` TEXT NOT NULL,
`Gloss_EN` TEXT NOT NULL,
`Definition_ES` TEXT,
`Gloss_ES` TEXT,
`Definition_PT` TEXT,
`Gloss_PT` TEXT,
`Morphological_Values` TEXT,
`Example` TEXT,
`Frequency` INT,
PRIMARY KEY (`Id_Spelling`)
);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('1', 'eeee', '', '\\cite[pag. 110]{hvalkof:cjo:15} \\cite[pag. 84]{anderson:cuentos:85}', 'sound.of.fear/anguish', 'Ideo', 'sonido.de.miedo/angustia', NULL, NULL, NULL, '+whistle.lang.+mono.syl.', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('2', 'eee', '', '\\cite[pag. 84]{anderson:cuentos:85}', 'sound.of.fear/anguish', 'Ideo', 'sonido.de.miedo/angustia', '', '', '', '+whistle.lang.+mono.syl.', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('3', 'shikerek', '', '\\cite[pag. 96]{anderson:cuentos:85}', 'animal.cry.made.by.a.bear/maini', 'Ideo', NULL, NULL, NULL, NULL, '+tri.syl.', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('4', 'toom', '', '\\cite[pag. 96]{anderson:cuentos:85}', 'sound.of.a.rock.being.moved', 'Ideo', 'sonido.de.una.roca.siendo.movida', NULL, NULL, NULL, '+mono.syl.', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('6', 'aaa', '', '\\cite[pag. 105]{anderson:cuentos:85}', 'parrot/savaro.squawking.sound', 'Ideo', 'sonido.del.garritar.del.papagayo/savaro', NULL, NULL, NULL, '+mono.syl.+s.redup.word', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('7', 'chempok', '', '\\cite[pag. 112]{anderson:cuentos:85}', 'action.of.a.shrimp.jumping/mitaantsi', 'Ideo', 'acción.de.el.saltar/mitaantsi.de.un.camarón', NULL, NULL, NULL, '+di.syl.+s.redup.word', NULL, NULL);
INSERT INTO `ADBL`.`Spelling` (`Id_Spelling`, `Word`, `Spelling_System`, `Source`, `Definition_EN`, `Gloss_EN`, `Definition_ES`, `Gloss_ES`, `Definition_PT`, `Gloss_PT`, `Morphological_Values`, `Example`, `Frequency`) VALUES ('8', 'satak', '', '\\cite[pag. 114]{anderson:cuentos:85}', 'action.of.chewing.ivenki', 'Ideo', 'acción.de.masticar.ivenki', NULL, NULL, NULL, NULL, NULL, NULL);
DROP TABLE IF EXISTS `Paradigm`;
CREATE TABLE `Paradigm`
(
`Id_Paradigm` INT NOT NULL AUTO_INCREMENT,
`Source` VARCHAR(1000) NOT NULL,
PRIMARY KEY (`Id_Paradigm`)
);
INSERT INTO `ADBL`.`Paradigm` (`Id_Paradigm`, `Source`) VALUES ('1', '\\cite[pag. 84]{anderson:cuentos:85}');
DROP TABLE IF EXISTS `Spelling_Paradigm`;
CREATE TABLE `Spelling_Paradigm`
(
`Id_Paradigm` INT NOT NULL,
`Id_Spelling` INT UNSIGNED NOT NULL UNIQUE,
`Source` VARCHAR(1000) NOT NULL,
FOREIGN KEY (`Id_Paradigm`) REFERENCES `Paradigm`(`Id_Paradigm`),
FOREIGN KEY (`Id_Spelling`) REFERENCES `Spelling`(`Id_Spelling`)
);
INSERT INTO `ADBL`.`Spelling_Paradigm` (`Id_Paradigm`, `Id_Spelling`, `Source`) VALUES ('1', '1', '');
INSERT INTO `ADBL`.`Spelling_Paradigm` (`Id_Paradigm`, `Id_Spelling`, `Source`) VALUES ('1', '2', '');
DROP TABLE IF EXISTS `Dialect`;
CREATE TABLE `Dialect`
(
`Id_Dialect` INT NOT NULL AUTO_INCREMENT,
`Dialect_Name` VARCHAR(100) NOT NULL,
`Short_Dialect_Name` VARCHAR(10) NOT NULL,
`Source` VARCHAR(1000) NOT NULL,
PRIMARY KEY (`Id_Dialect`)
);
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Spanish Loan Words/Préstamos lingüísticos del español', 'ES', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ashéninka Perené', 'PRQ', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ajyíninka Apurucayali', 'CPC', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Asháninka', 'CNI', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ashéninka Pajonal', 'CJO', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ashéninka Pichis', 'CPU', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ashéninka Sur de Ucayali', 'CPY', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Ashéninka Ucayali-Yurúa', 'CPB', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Inglés/English', 'EN', 'NONE');
INSERT INTO `ADBL`.`Dialect` (`Dialect_Name`, `Short_Dialect_Name`, `Source`) VALUES ('Quechua', 'QU', 'NONE');