Project

General

Profile

update_pg_types.sql

Upgrade script for PostgreSQL db - admin admin, 05/16/2007 11:53 AM

Download (2.32 KB)

 
1
BEGIN WORK;
2
ALTER TABLE Prelude_Alertident ALTER COLUMN _message_ident TYPE INT8;
3
ALTER TABLE Prelude_ToolAlert ALTER COLUMN _message_ident TYPE INT8;
4
ALTER TABLE Prelude_CorrelationAlert ALTER COLUMN _message_ident TYPE INT8;
5
ALTER TABLE Prelude_OverflowAlert ALTER COLUMN _message_ident TYPE INT8;
6
ALTER TABLE Prelude_Analyzer ALTER COLUMN _message_ident TYPE INT8;
7
ALTER TABLE Prelude_Classification ALTER COLUMN _message_ident TYPE INT8;
8
ALTER TABLE Prelude_Reference ALTER COLUMN _message_ident TYPE INT8;
9
ALTER TABLE Prelude_Source ALTER COLUMN _message_ident TYPE INT8;
10
ALTER TABLE Prelude_Target ALTER COLUMN _message_ident TYPE INT8;
11
ALTER TABLE Prelude_File ALTER COLUMN _message_ident TYPE INT8;
12
ALTER TABLE Prelude_FileAccess ALTER COLUMN _message_ident TYPE INT8;
13
ALTER TABLE Prelude_FileAccess_Permission ALTER COLUMN _message_ident TYPE INT8;
14
ALTER TABLE Prelude_Linkage ALTER COLUMN _message_ident TYPE INT8;
15
ALTER TABLE Prelude_Inode ALTER COLUMN _message_ident TYPE INT8;
16
ALTER TABLE Prelude_Checksum ALTER COLUMN _message_ident TYPE INT8;
17
ALTER TABLE Prelude_Impact ALTER COLUMN _message_ident TYPE INT8;
18
ALTER TABLE Prelude_Action ALTER COLUMN _message_ident TYPE INT8;
19
ALTER TABLE Prelude_Confidence ALTER COLUMN _message_ident TYPE INT8;
20
ALTER TABLE Prelude_Assessment ALTER COLUMN _message_ident TYPE INT8;
21
ALTER TABLE Prelude_AdditionalData ALTER COLUMN _message_ident TYPE INT8;
22
ALTER TABLE Prelude_CreateTime ALTER COLUMN _message_ident TYPE INT8;
23
ALTER TABLE Prelude_DetectTime ALTER COLUMN _message_ident TYPE INT8;
24
ALTER TABLE Prelude_AnalyzerTime ALTER COLUMN _message_ident TYPE INT8;
25
ALTER TABLE Prelude_Node ALTER COLUMN _message_ident TYPE INT8;
26
ALTER TABLE Prelude_Address ALTER COLUMN _message_ident TYPE INT8;
27
ALTER TABLE Prelude_User ALTER COLUMN _message_ident TYPE INT8;
28
ALTER TABLE Prelude_UserId ALTER COLUMN _message_ident TYPE INT8;
29
ALTER TABLE Prelude_Process ALTER COLUMN _message_ident TYPE INT8;
30
ALTER TABLE Prelude_ProcessArg ALTER COLUMN _message_ident TYPE INT8;
31
ALTER TABLE Prelude_ProcessEnv ALTER COLUMN _message_ident TYPE INT8;
32
ALTER TABLE Prelude_Service ALTER COLUMN _message_ident TYPE INT8;
33
ALTER TABLE Prelude_WebService ALTER COLUMN _message_ident TYPE INT8;
34
ALTER TABLE Prelude_WebServiceArg ALTER COLUMN _message_ident TYPE INT8;
35
ALTER TABLE Prelude_SnmpService ALTER COLUMN _message_ident TYPE INT8;
36
COMMIT;