/usr/share/perl5/EB/migrate/001000012001000013.sql is in eekboek 2.00.03-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 | BEGIN WORK;
ALTER TABLE Standaardrekeningen
ADD COLUMN std_acc_btw_vp int references Accounts; -- BTW verkoop privé
ALTER TABLE Standaardrekeningen
ADD COLUMN std_acc_btw_ip int references Accounts; -- BTW inkoop privé
ALTER TABLE Standaardrekeningen
ADD COLUMN std_acc_btw_va int references Accounts; -- BTW verkoop anders
ALTER TABLE Standaardrekeningen
ADD COLUMN std_acc_btw_ia int references Accounts; -- BTW inkoop anders
INSERT INTO Constants (name, value) VALUES ('BTWTARIEF_PRIV', '3');
INSERT INTO Constants (name, value) VALUES ('BTWTARIEF_ANDERS', '4');
ALTER TABLE ONLY BTWTabel
DROP CONSTRAINT "btw_tariefgroep";
ALTER TABLE ONLY BTWTabel
ADD CONSTRAINT "btw_tariefgroep"
CHECK (btw_tariefgroep >= 0 AND btw_tariefgroep <= 4);
-- Bump version.
UPDATE Constants
SET value = '13'
WHERE name = 'SCM_REVISION' AND value = '12';
UPDATE Metadata
SET adm_scm_revision =
(SELECT int2(value) FROM Constants WHERE name = 'SCM_REVISION');
COMMIT WORK;
|