[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    playground/office/kraft/database
From:       Klaas Freitag <freitag () suse ! de>
Date:       2006-09-18 21:13:34
Message-ID: 1158614014.036334.14265.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 586158 by freitag:

wordlists

 M  +7 -0      create_schema.sql  
 M  +12 -0     fill_schema_de.sql  
 A             fill_schema_en.sql  


--- trunk/playground/office/kraft/database/create_schema.sql #586157:586158
@@ -11,6 +11,13 @@
 	PRIMARY KEY( preisArtID )
 );
 
+CREATE TABLE wordLists(
+  category     VARCHAR(64),
+  word         VARCHAR(255),
+
+  PRIMARY KEY( category, word )
+);
+
 CREATE TABLE CatalogSet(
   catalogSetID INT NOT NULL AUTO_INCREMENT,
   name         VARCHAR(255),
--- trunk/playground/office/kraft/database/fill_schema_de.sql #586157:586158
@@ -48,3 +48,15 @@
 INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Helfer', 30.00, 4 );
 INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Auszubildender', 21.00, 3 );
 INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Maschinenfuehrer', 33.00, 5 );
+
+DELETE FROM wordLists;
+INSERT INTO wordLists ("greeting", "mit den besten Grüssen," );
+INSERT INTO wordLists ("greeting", "liebe Grüsse," );
+INSERT INTO wordLists ("greeting", "Hochachtungsvoll," );
+INSERT INTO wordLists ("greeting", "mit freundlichem Gruß," );
+
+INSERT INTO wordLists ("salut", "Sehr geehrter Herr %NAME" );
+INSERT INTO wordLists ("salut", "Sehr geehrte Frau %NAME" );
+INSERT INTO wordLists ("salut", "Sehr geehrte Frau %NAME, sehr geehrter Herr %NAME" );
+INSERT INTO wordLists ("salut", "Lieber %GIVEN_NAME" );
+INSERT INTO wordLists ("salut", "Liebe %GIVEN_NAME" );
[prev in list] [next in list] [prev in thread] [next in thread]