/usr/share/kde4/apps/kraft/dbmigrate/mysql/14_dbmigrate.sql is in kraft 0.45-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 | # message Add tax table
CREATE TABLE taxes (
id INT NOT NULL AUTO_INCREMENT,
fullTax DECIMAL(5,1),
reducedTax DECIMAL(5,1),
startDate DATE,
PRIMARY KEY( id )
);
INSERT INTO taxes ( fullTax, reducedTax, startDate ) VALUES (16.0, 7.0, '1998-04-01' );
INSERT INTO taxes ( fullTax, reducedTax, startDate ) VALUES (19.0, 7.0, '2007-01-01' );
|