[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-11-05 22:12:18
Message-ID: 1162764738.872346.7741.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 602404 by freitag:

Fixes to the database creation scripts

 M  +1 -0      create_schema.sql  
 A             errorcodes.txt  
 M  +7 -7      fill_schema_de.sql  
 M  +4 -3      fill_schema_en.sql  


--- trunk/playground/office/kraft/database/create_schema.sql #602403:602404
@@ -240,4 +240,5 @@
     updateUser       VARCHAR(256)
 );
 
+INSERT INTO kraftsystem ( dbschemaversion ) VALUES ( 1 );
 
--- trunk/playground/office/kraft/database/fill_schema_de.sql #602403:602404
@@ -4,8 +4,8 @@
 INSERT INTO preisArten VALUES (2, 'kalkuliert');
 
 DELETE FROM CatalogSet;
-INSERT INTO CatalogSet (name, description, catalogType, sortKey) VALUES ( \
                "Mustertexte GALA-Bau", \
-  "Kalkulierte Musterposten für den Garten- und Landschaftsbau", "TemplCatalog", 1 \
); +INSERT INTO CatalogSet (name, description, catalogType, sortKey) VALUES 
+ ( "Mustertexte GALA-Bau", "Kalkulierte Musterposten für den Garten- und \
Landschaftsbau", "TemplCatalog", 1 );  SET @newCat := LAST_INSERT_ID();
 
 DELETE FROM CatalogChapters;
@@ -17,17 +17,17 @@
 INSERT INTO CatalogChapters (chapter, sortKey) VALUES ('Transport', 6 );
 UPDATE CatalogChapters SET catalogSetID=@newCat;
 
-INSERT INTO CatalogSet( name, description, catalogType, sortKey) VALUES ("Material", \
\ +INSERT INTO CatalogSet( name, description, catalogType, sortKey) VALUES \
("Material",  "Materialkatalog", "MaterialCatalog", 2 );
 SET @newCat := LAST_INSERT_ID();
 
-INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES \
+INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES 
   ('Schüttgüter', 3, @newCat);
-INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES \
+INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES 
   ('Naturstein', 2, @newCat);
-INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES \
+INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES 
   ('Beton', 1, @newCat);
-INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES \
+INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES 
   ('Rohre', 4, @newCat);
 
 DELETE FROM units;
--- trunk/playground/office/kraft/database/fill_schema_en.sql #602403:602404
@@ -4,8 +4,9 @@
 INSERT INTO preisArten VALUES (2, 'calculated');
 
 DELETE FROM CatalogSet;
-INSERT INTO CatalogSet (name, description, catalogType, sortKey) VALUES ( "Templates \
                for Landscaping", \
-  "Calculated Templates for Landscaping Business", "TemplCatalog", 1 );
+INSERT INTO CatalogSet (name, description, catalogType, sortKey) VALUES 
+( "Standard Templates", 
+  "A set of templates suitable for business", "TemplCatalog", 1 );
 SET @newCat := LAST_INSERT_ID();
 
 DELETE FROM CatalogChapters;
@@ -16,7 +17,7 @@
 INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES ('Misc', 5, \
@newCat  );  INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES \
('Transportation', 6, @newCat  );  
-INSERT INTO CatalogSet( name, description, catalogType, sortKey) VALUES ("Material", \
\ +INSERT INTO CatalogSet( name, description, catalogType, sortKey) VALUES \
("Material",   "Material Catalog to Use in Calculations in Templates", \
"MaterialCatalog", 2 );  SET @newCat := LAST_INSERT_ID();
 


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