/usr/share/kde4/apps/kraft/dbinit/sqlite3/fill_schema_en.sql is in kraft 0.59-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | DELETE FROM preisArten;
INSERT INTO preisArten VALUES (0, 'open');
INSERT INTO preisArten VALUES (1, 'manual');
INSERT INTO preisArten VALUES (2, 'calculated');
DELETE FROM CatalogSet;
INSERT INTO CatalogSet (name, description, catalogType, sortKey) VALUES
( "Standard Templates",
"A set of templates suitable for business", "TemplCatalog", 1 );
-- (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates")
DELETE FROM CatalogChapters;
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Work', 1, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Machine', 2, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Material', 3, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Service', 4, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Transportation', 5, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogChapters (chapter, sortKey, catalogSetID) VALUES
('Misc', 6, (SELECT catalogSetID FROM CatalogSet WHERE name="Standard Templates"));
INSERT INTO CatalogSet( name, description, catalogType, sortKey) VALUES ("Material",
"Material Catalog to Use in Calculations in Templates", "MaterialCatalog", 2 );
-- (SELECT catalogSetID FROM CatalogSet WHERE name="Material")
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Bulk Solids', 3, (SELECT catalogSetID FROM CatalogSet WHERE name="Material") );
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Stones', 2, (SELECT catalogSetID FROM CatalogSet WHERE name="Material"));
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Concrete', 1, (SELECT catalogSetID FROM CatalogSet WHERE name="Material"));
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Pipes', 4, (SELECT catalogSetID FROM CatalogSet WHERE name="Material"));
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Wood', 5, (SELECT catalogSetID FROM CatalogSet WHERE name="Material"));
INSERT INTO CatalogChapters ( chapter, sortKey, catalogSetID ) VALUES
('Art and Furnitures', 6, (SELECT catalogSetID FROM CatalogSet WHERE name="Material"));
DELETE FROM units;
INSERT INTO units VALUES (0, 'm', 'Meter', 'm', 'Meter' );
INSERT INTO units VALUES (1, 'sm', 'Squaremeter', 'qm', 'Squaremeter' );
INSERT INTO units VALUES (2, 'cbm', 'Cubikmeter', 'cbm', 'Cubikmeter' );
INSERT INTO units VALUES (3, 'Bag.', 'Bag', 'Bag', 'Bags' );
INSERT INTO units VALUES (4, 'l', 'Liter', 'l', 'Liter' );
INSERT INTO units VALUES (5, 'kg', 'Kilogramm', 'kg', 'Kilogramm' );
INSERT INTO units VALUES (6, 'Pcs.', 'Piece', 'Pcs.', 'Pieces' );
INSERT INTO units VALUES (7, 't', 'Ton', 't', 'Tons' );
INSERT INTO units VALUES (8, 'pausch.', 'pauschal', 'pausch.', 'pauschal' );
INSERT INTO units VALUES (9, 'Hour', 'Hour', 'Hours', 'Hours' );
DELETE FROM stdSaetze;
INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Worker', 34.00, 1 );
INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Master', 39.00, 2 );
INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Assistant', 30.00, 4 );
INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Trainee', 21.00, 3 );
INSERT INTO stdSaetze (name, price, sortKey) VALUES ('Machine Operator', 33.00, 5 );
DELETE FROM wordLists;
INSERT INTO wordLists VALUES ('greeting', 'with kind regards,' );
INSERT INTO wordLists VALUES ('greeting', 'with best regards,' );
INSERT INTO wordLists VALUES ('greeting', 'yours faithfully,' );
INSERT INTO wordLists VALUES ('greeting', 'goodbye and thanks for the fish,' );
INSERT INTO wordLists VALUES ('greeting', 'goodbye' );
INSERT INTO wordLists VALUES ('salut', 'Dear Mr. %NAME' );
INSERT INTO wordLists VALUES ('salut', 'Dear Mrs. %NAME' );
INSERT INTO wordLists VALUES ('salut', 'Dear Mrs. %NAME, dear Mr. %NAME' );
INSERT INTO wordLists VALUES ('salut', 'Dear %GIVEN_NAME' );
|