Differences

This shows you the differences between two versions of the page.

--- resources:morph-it [2018/05/03 12:49] – eros
+++ resources:morph-it [2018/05/03 12:55] (current) – eros
@@ Line 1: / Line 1: @@
-====== Morph-IT ======
+====== Morph-it! ======
 **A Free Morphological Lexicon for the Italian Language**
@@ Line 24: / Line 24: @@
 The remainder of this document contains a commented list of the morphological features used in the lexicon, licensing information and aknowledgments.
+===== Download =====
+{{ :resources:morph-it.tgz |Morph-IT}}
+{{ :resources:morph-it_automata.tgz |Compiled Automata}}
 ===== Features =====
@@ Line 227: / Line 233: @@
 ''cela/cele/celi/celo/cene/ci/gli/gliela/gliele/glieli/glielo/gliene/la/''
 ''le/li/lo/mela/mele/meli/melo/mene/mi/ne/sela/sele/seli/selo/sene/si/''
 ''tela/tele/teli/telo/tene/ti/vela/vele/veli/velo/vene/vi''
@@ Line 239: / Line 247: @@
 "Che" as a wh element (e.g., "l'uomo che hai visto", "hai detto che").
+===== Creating a MySQL version =====
+This mini-howto guides you through the creation of a mysql version of Morph-it!
+You need a working installation of MySQL on your server and CREATE privileges
+Step 1: create a new database:
+<code sql>
+CREATE DATABASE morphit;
+</code>
+Step 2: change to the newly created database:
+<code sql>
+USE morphit;
+</code>
+Step 3: create a new table (adjust version number in COMMENT):
+<code sql>
+CREATE TABLE `morphit` (
+  `form` varchar(255) NOT NULL default '',
+  `lemma` varchar(255) NOT NULL default '',
+  `features` varchar(255) NOT NULL default ''
+) TYPE=MyISAM COMMENT='Version X.XX';
+</code>
+Step 4: load data into table:
+<code sql>
+LOAD DATA LOCAL INFILE '/home/user/filename.txt'
+INTO TABLE morphit
+FIELDS TERMINATED BY '\t';
+</code>
+Step 5: add a primary key:
+<code sql>
+ALTER TABLE `morphit`.`morphit`
+ADD COLUMN `id` INT(11) NOT NULL AUTO_INCREMENT FIRST,
+ADD PRIMARY KEY(`id`);
+</code>
 ===== Licensing information =====