/usr/share/libpreludedb/classic/pgsql-update-14-6.sql is in libpreludedb7-pgsql 4.1.0-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 | -- you can safely ignore error if the following action fails:
ALTER TABLE Prelude_Checksum DROP CONSTRAINT prelude_checksum_algorithm_check;
BEGIN;
UPDATE _format SET version='14.6';
ALTER TABLE Prelude_Alertident ALTER COLUMN _index TYPE INT4;
ALTER TABLE Prelude_Service ALTER COLUMN _parent0_index TYPE INT2;
ALTER TABLE Prelude_Service ALTER COLUMN ip_version TYPE INT2;
ALTER TABLE Prelude_Service ALTER COLUMN iana_protocol_number TYPE INT2;
ALTER TABLE Prelude_Service ALTER COLUMN port TYPE INT4;
ALTER TABLE Prelude_Checksum ADD CHECK ( algorithm IN ('MD4', 'MD5', 'SHA1', 'SHA2-256', 'SHA2-384', 'SHA2-512', 'CRC-32', 'Haval', 'Tiger', 'Gost'));
ALTER TABLE Prelude_Alertident ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_ToolAlert ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_CorrelationAlert ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_OverflowAlert ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Analyzer ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Classification ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Reference ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Source ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Target ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_File ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_FileAccess ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_FileAccess_Permission ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Linkage ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Inode ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Checksum ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Impact ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Action ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Confidence ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Assessment ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_AdditionalData ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_CreateTime ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_DetectTime ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_AnalyzerTime ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Node ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Address ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_User ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_UserId ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Process ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_ProcessArg ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_ProcessEnv ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_Service ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_WebService ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_WebServiceArg ALTER COLUMN _message_ident TYPE INT8;
ALTER TABLE Prelude_SnmpService ALTER COLUMN _message_ident TYPE INT8;
COMMIT;
|