/ [runasimi] / trunk / rawdata / struct.sql
To checkout: svn checkout http://svn.gnu.org.ua/sources/runasimi/trunk/rawdata/struct.sql
Puszcza

Contents of /trunk/rawdata/struct.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 33 - (show annotations)
Fri Jun 20 08:40:55 2008 UTC (13 years, 3 months ago) by gray
File size: 7340 byte(s)
Fix error handling. Use  UTF-8.

* rawdata/struct.sql: New file.
* rawdata/Makefile: Use UTF-8
* cgi-bin/dict.cgi.in: Use sql-catch-failure to handle SQL errors.

1 -- MySQL dump 10.9
2 --
3 -- Host: localhost Database: runasimi
4 -- ------------------------------------------------------
5 -- Server version 4.1.10-log
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15 --
16 -- Table structure for table `ayacucho`
17 --
18
19 DROP TABLE IF EXISTS `ayacucho`;
20 CREATE TABLE `ayacucho` (
21 `serial` int(10) NOT NULL default '0',
22 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
23 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
24 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
25 UNIQUE KEY `serial` (`serial`),
26 KEY `com_pos` (`common`,`part_of_speech`),
27 KEY `com` (`common`),
28 KEY `ent` (`entry`)
29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
30
31 --
32 -- Table structure for table `cochabamba`
33 --
34
35 DROP TABLE IF EXISTS `cochabamba`;
36 CREATE TABLE `cochabamba` (
37 `serial` int(10) NOT NULL default '0',
38 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
39 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
40 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
41 UNIQUE KEY `serial` (`serial`),
42 KEY `com_pos` (`common`,`part_of_speech`),
43 KEY `com` (`common`),
44 KEY `ent` (`entry`)
45 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
46
47 --
48 -- Table structure for table `cozco`
49 --
50
51 DROP TABLE IF EXISTS `cozco`;
52 CREATE TABLE `cozco` (
53 `serial` int(10) NOT NULL default '0',
54 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
55 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
56 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
57 UNIQUE KEY `serial` (`serial`),
58 KEY `com_pos` (`common`,`part_of_speech`),
59 KEY `com` (`common`),
60 KEY `ent` (`entry`)
61 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
62
63 --
64 -- Table structure for table `deutsch`
65 --
66
67 DROP TABLE IF EXISTS `deutsch`;
68 CREATE TABLE `deutsch` (
69 `serial` int(10) NOT NULL default '0',
70 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
71 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
72 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
73 UNIQUE KEY `serial` (`serial`),
74 KEY `com_pos` (`common`,`part_of_speech`),
75 KEY `com` (`common`),
76 KEY `ent` (`entry`)
77 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
78
79 --
80 -- Table structure for table `deutsch_key`
81 --
82
83 DROP TABLE IF EXISTS `deutsch_key`;
84 CREATE TABLE `deutsch_key` (
85 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
86 `serial` int(10) NOT NULL default '0',
87 KEY `ent` (`entry`)
88 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
89
90 --
91 -- Table structure for table `english`
92 --
93
94 DROP TABLE IF EXISTS `english`;
95 CREATE TABLE `english` (
96 `serial` int(10) NOT NULL default '0',
97 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
98 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
99 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
100 UNIQUE KEY `serial` (`serial`),
101 KEY `com_pos` (`common`,`part_of_speech`),
102 KEY `com` (`common`),
103 KEY `ent` (`entry`)
104 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
105
106 --
107 -- Table structure for table `english_key`
108 --
109
110 DROP TABLE IF EXISTS `english_key`;
111 CREATE TABLE `english_key` (
112 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
113 `serial` int(10) NOT NULL default '0',
114 KEY `ent` (`entry`)
115 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
116
117 --
118 -- Table structure for table `espanol`
119 --
120
121 DROP TABLE IF EXISTS `espanol`;
122 CREATE TABLE `espanol` (
123 `serial` int(10) NOT NULL default '0',
124 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
125 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
126 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
127 UNIQUE KEY `serial` (`serial`),
128 KEY `com_pos` (`common`,`part_of_speech`),
129 KEY `com` (`common`),
130 KEY `ent` (`entry`)
131 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
132
133 --
134 -- Table structure for table `espanol_key`
135 --
136
137 DROP TABLE IF EXISTS `espanol_key`;
138 CREATE TABLE `espanol_key` (
139 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
140 `serial` int(10) NOT NULL default '0',
141 KEY `ent` (`entry`)
142 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
143
144 --
145 -- Table structure for table `huaylas`
146 --
147
148 DROP TABLE IF EXISTS `huaylas`;
149 CREATE TABLE `huaylas` (
150 `serial` int(10) NOT NULL default '0',
151 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
152 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
153 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
154 UNIQUE KEY `serial` (`serial`),
155 KEY `com_pos` (`common`,`part_of_speech`),
156 KEY `com` (`common`),
157 KEY `ent` (`entry`)
158 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
159
160 --
161 -- Table structure for table `imbabura`
162 --
163
164 DROP TABLE IF EXISTS `imbabura`;
165 CREATE TABLE `imbabura` (
166 `serial` int(10) NOT NULL default '0',
167 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
168 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
169 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
170 UNIQUE KEY `serial` (`serial`),
171 KEY `com_pos` (`common`,`part_of_speech`),
172 KEY `com` (`common`),
173 KEY `ent` (`entry`)
174 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
175
176 --
177 -- Table structure for table `quechua`
178 --
179
180 DROP TABLE IF EXISTS `quechua`;
181 CREATE TABLE `quechua` (
182 `serial` int(10) NOT NULL default '0',
183 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
184 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
185 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
186 UNIQUE KEY `serial` (`serial`),
187 KEY `com_pos` (`common`,`part_of_speech`),
188 KEY `com` (`common`),
189 KEY `ent` (`entry`)
190 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
191
192 --
193 -- Table structure for table `tucuman`
194 --
195
196 DROP TABLE IF EXISTS `tucuman`;
197 CREATE TABLE `tucuman` (
198 `serial` int(10) NOT NULL default '0',
199 `common` varchar(128) collate utf8_general_ci NOT NULL default '',
200 `part_of_speech` varchar(10) collate utf8_general_ci NOT NULL default '',
201 `entry` varchar(128) collate utf8_general_ci NOT NULL default '',
202 UNIQUE KEY `serial` (`serial`),
203 KEY `com_pos` (`common`,`part_of_speech`),
204 KEY `com` (`common`),
205 KEY `ent` (`entry`)
206 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
207
208 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
209 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
210 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
211 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Send suggestions and bug reports to Sergey Poznyakoff
ViewVC Help
Powered by ViewVC 1.1.20