
@COMMENT:Tworzenie wpisu wersji
^
INSERT INTO EAC_APP_VERSION (DB_VERSION, BIN_VERSION, UPGRADE_DATE, USER_NAME, IS_FINISHED) VALUES (9, '1.0.2.1', CURRENT_TIMESTAMP, 'ADMIN', 0);
^
@COMMENT:Tworzenie uprawnień aplikacji
^
ALTER TABLE EAC_KSEF_CERT ADD ENC_ONL SMALLINT DEFAULT 0 NOT NULL;
^
ALTER TABLE EAC_KSEF_CERT ADD ENC_OFL SMALLINT DEFAULT 0 NOT NULL;
^
ALTER TABLE EAC_KSEF_CERT ALTER COLUMN HASLO TYPE VARCHAR(1000);
^
ALTER TABLE EAC_KSEF_CERT ALTER COLUMN HASLO_CERT_OFFLINE TYPE VARCHAR(1000);
^
@COMMENT:Odblokowanie bazy danych
^
UPDATE EAC_APP_VERSION SET IS_FINISHED = 1 WHERE DB_VERSION = 9;