1UPDATE _format SET version='14.2'; 2 3ALTER TABLE Prelude_Alertident ADD COLUMN _index INT4; 4ALTER TABLE Prelude_Alertident ALTER COLUMN _index SET NOT NULL; 5ALTER TABLE Prelude_Alertident ADD PRIMARY KEY (_parent_type, _message_ident, _index); 6DROP INDEX prelude_alert_ident; 7 8DROP INDEX prelude_analyzer_index_model; 9CREATE INDEX prelude_analyzer_index_model ON Prelude_Analyzer (_parent_type,_index,model); 10 11/* Update the data type of the column _index from Prelude_Analyzer */ 12ALTER TABLE Prelude_Analyzer ADD COLUMN temp_useless_column INT4; 13UPDATE Prelude_Analyzer SET temp_useless_column = CAST(_index AS INT4); 14ALTER TABLE Prelude_Analyzer DROP COLUMN _index; 15ALTER TABLE Prelude_Analyzer RENAME temp_useless_column to _index; 16/* Prelude_Analyzer->_index data type updated*/ 17 18DROP INDEX prelude_classification_index; 19CREATE INDEX prelude_classification_index_text ON Prelude_Classification (text); 20 21ALTER TABLE Prelude_Reference ADD PRIMARY KEY (_message_ident, _index); 22DROP INDEX prelude_reference_index_message_ident; 23 24/* Update the data type of the column _index from Prelude_Reference */ 25ALTER TABLE Prelude_Reference ADD COLUMN temp_useless_column INT4; 26UPDATE Prelude_Reference SET temp_useless_column = CAST(_index AS INT4); 27ALTER TABLE Prelude_Reference DROP COLUMN _index; 28ALTER TABLE Prelude_Reference RENAME temp_useless_column to _index; 29/* Prelude_Reference->_index data type updated*/ 30 31/* Update the data type of the column _index from Prelude_Source */ 32ALTER TABLE Prelude_Source ADD COLUMN temp_useless_column INT4; 33UPDATE Prelude_Source SET temp_useless_column = CAST(_index AS INT4); 34ALTER TABLE Prelude_Source DROP COLUMN _index; 35ALTER TABLE Prelude_Source RENAME temp_useless_column to _index; 36/* Prelude_Source->_index data type updated*/ 37 38/* Update the data type of the column _index from Prelude_Target */ 39ALTER TABLE Prelude_Target ADD COLUMN temp_useless_column INT4; 40UPDATE Prelude_Target SET temp_useless_column = CAST(_index AS INT4); 41ALTER TABLE Prelude_Target DROP COLUMN _index; 42ALTER TABLE Prelude_Target RENAME temp_useless_column to _index; 43/* Prelude_Target->_index data type updated*/ 44 45ALTER TABLE Prelude_File ADD COLUMN file_type VARCHAR(255) NULL; 46/* Update the data type of the column _parent0_index from Prelude_File */ 47ALTER TABLE Prelude_File ADD COLUMN temp_useless_column INT4; 48UPDATE Prelude_File SET temp_useless_column = CAST(_parent0_index AS INT4); 49ALTER TABLE Prelude_File DROP COLUMN _parent0_index; 50ALTER TABLE Prelude_File RENAME temp_useless_column to _parent0_index; 51/* Prelude_File->_parent0_index data type updated*/ 52/* Update the data type of the column _index from Prelude_File */ 53ALTER TABLE Prelude_File ADD COLUMN temp_useless_column INT4; 54UPDATE Prelude_File SET temp_useless_column = CAST(_index AS INT4); 55ALTER TABLE Prelude_File DROP COLUMN _index; 56ALTER TABLE Prelude_File RENAME temp_useless_column to _index; 57/* Prelude_File->_index data type updated*/ 58 59/* Update the data type of the column _parent0_index from Prelude_FileAccess */ 60ALTER TABLE Prelude_FileAccess ADD COLUMN temp_useless_column INT4; 61UPDATE Prelude_FileAccess SET temp_useless_column = CAST(_parent0_index AS INT4); 62ALTER TABLE Prelude_FileAccess DROP COLUMN _parent0_index; 63ALTER TABLE Prelude_FileAccess RENAME temp_useless_column to _parent0_index; 64/* Prelude_FileAccess->_parent0_index data type updated*/ 65/* Update the data type of the column _parent1_index from Prelude_FileAccess */ 66ALTER TABLE Prelude_FileAccess ADD COLUMN temp_useless_column INT4; 67UPDATE Prelude_FileAccess SET temp_useless_column = CAST(_parent1_index AS INT4); 68ALTER TABLE Prelude_FileAccess DROP COLUMN _parent1_index; 69ALTER TABLE Prelude_FileAccess RENAME temp_useless_column to _parent1_index; 70/* Prelude_FileAccess->_parent1_index data type updated*/ 71/* Update the data type of the column _index from Prelude_FileAccess */ 72ALTER TABLE Prelude_FileAccess ADD COLUMN temp_useless_column INT4; 73UPDATE Prelude_FileAccess SET temp_useless_column = CAST(_index AS INT4); 74ALTER TABLE Prelude_FileAccess DROP COLUMN _index; 75ALTER TABLE Prelude_FileAccess RENAME temp_useless_column to _index; 76/* Prelude_FileAccess->_index data type updated*/ 77 78/* Update the data type of the column _parent0_index from Prelude_FileAccess_Permission */ 79ALTER TABLE Prelude_FileAccess_Permission ADD COLUMN temp_useless_column INT4; 80UPDATE Prelude_FileAccess_Permission SET temp_useless_column = CAST(_parent0_index AS INT4); 81ALTER TABLE Prelude_FileAccess_Permission DROP COLUMN _parent0_index; 82ALTER TABLE Prelude_FileAccess_Permission RENAME temp_useless_column to _parent0_index; 83/* Prelude_FileAccess_Permission->_parent0_index data type updated*/ 84/* Update the data type of the column _parent1_index from Prelude_FileAccess_Permission */ 85ALTER TABLE Prelude_FileAccess_Permission ADD COLUMN temp_useless_column INT4; 86UPDATE Prelude_FileAccess_Permission SET temp_useless_column = CAST(_parent1_index AS INT4); 87ALTER TABLE Prelude_FileAccess_Permission DROP COLUMN _parent1_index; 88ALTER TABLE Prelude_FileAccess_Permission RENAME temp_useless_column to _parent1_index; 89/* Prelude_FileAccess_Permission->_parent1_index data type updated*/ 90/* Update the data type of the column _parent2_index from Prelude_FileAccess_Permission */ 91ALTER TABLE Prelude_FileAccess_Permission ADD COLUMN temp_useless_column INT4; 92UPDATE Prelude_FileAccess_Permission SET temp_useless_column = CAST(_parent2_index AS INT4); 93ALTER TABLE Prelude_FileAccess_Permission DROP COLUMN _parent2_index; 94ALTER TABLE Prelude_FileAccess_Permission RENAME temp_useless_column to _parent2_index; 95/* Prelude_FileAccess_Permission->_parent2_index data type updated*/ 96/* Update the data type of the column _index from Prelude_FileAccess_Permission */ 97ALTER TABLE Prelude_FileAccess_Permission ADD COLUMN temp_useless_column INT4; 98UPDATE Prelude_FileAccess_Permission SET temp_useless_column = CAST(_index AS INT4); 99ALTER TABLE Prelude_FileAccess_Permission DROP COLUMN _index; 100ALTER TABLE Prelude_FileAccess_Permission RENAME temp_useless_column to _index; 101/* Prelude_FileAccess_Permission->_index data type updated*/ 102 103/* Update the data type of the column _parent0_index from Prelude_Linkage */ 104ALTER TABLE Prelude_Linkage ADD COLUMN temp_useless_column INT4; 105UPDATE Prelude_Linkage SET temp_useless_column = CAST(_parent0_index AS INT4); 106ALTER TABLE Prelude_Linkage DROP COLUMN _parent0_index; 107ALTER TABLE Prelude_Linkage RENAME temp_useless_column to _parent0_index; 108/* Prelude_Linkage->_parent0_index data type updated*/ 109/* Update the data type of the column _parent1_index from Prelude_Linkage */ 110ALTER TABLE Prelude_Linkage ADD COLUMN temp_useless_column INT4; 111UPDATE Prelude_Linkage SET temp_useless_column = CAST(_parent1_index AS INT4); 112ALTER TABLE Prelude_Linkage DROP COLUMN _parent1_index; 113ALTER TABLE Prelude_Linkage RENAME temp_useless_column to _parent1_index; 114/* Prelude_Linkage->_parent1_index data type updated*/ 115/* Update the data type of the column _index from Prelude_Linkage */ 116ALTER TABLE Prelude_Linkage ADD COLUMN temp_useless_column INT4; 117UPDATE Prelude_Linkage SET temp_useless_column = CAST(_index AS INT4); 118ALTER TABLE Prelude_Linkage DROP COLUMN _index; 119ALTER TABLE Prelude_Linkage RENAME temp_useless_column to _index; 120/* Prelude_Linkage->_index data type updated*/ 121 122/* Update the data type of the column _parent0_index from Prelude_Inode */ 123ALTER TABLE Prelude_Inode ADD COLUMN temp_useless_column INT4; 124UPDATE Prelude_Inode SET temp_useless_column = CAST(_parent0_index AS INT4); 125ALTER TABLE Prelude_Inode DROP COLUMN _parent0_index; 126ALTER TABLE Prelude_Inode RENAME temp_useless_column to _parent0_index; 127/* Prelude_Inode->_parent0_index data type updated*/ 128/* Update the data type of the column _parent1_index from Prelude_Inode */ 129ALTER TABLE Prelude_Inode ADD COLUMN temp_useless_column INT4; 130UPDATE Prelude_Inode SET temp_useless_column = CAST(_parent1_index AS INT4); 131ALTER TABLE Prelude_Inode DROP COLUMN _parent1_index; 132ALTER TABLE Prelude_Inode RENAME temp_useless_column to _parent1_index; 133/* Prelude_Inode->_parent1_index data type updated*/ 134 135/* Update the data type of the column _parent0_index from Prelude_Checksum */ 136ALTER TABLE Prelude_Checksum ADD COLUMN temp_useless_column INT4; 137UPDATE Prelude_Checksum SET temp_useless_column = CAST(_parent0_index AS INT4); 138ALTER TABLE Prelude_Checksum DROP COLUMN _parent0_index; 139ALTER TABLE Prelude_Checksum RENAME temp_useless_column to _parent0_index; 140/* Prelude_Checksum->_parent0_index data type updated*/ 141/* Update the data type of the column _parent1_index from Prelude_Checksum */ 142ALTER TABLE Prelude_Checksum ADD COLUMN temp_useless_column INT4; 143UPDATE Prelude_Checksum SET temp_useless_column = CAST(_parent1_index AS INT4); 144ALTER TABLE Prelude_Checksum DROP COLUMN _parent1_index; 145ALTER TABLE Prelude_Checksum RENAME temp_useless_column to _parent1_index; 146/* Prelude_Checksum->_parent1_index data type updated*/ 147/* Update the data type of the column _index from Prelude_Checksum */ 148ALTER TABLE Prelude_Checksum ADD COLUMN temp_useless_column INT4; 149UPDATE Prelude_Checksum SET temp_useless_column = CAST(_index AS INT4); 150ALTER TABLE Prelude_Checksum DROP COLUMN _index; 151ALTER TABLE Prelude_Checksum RENAME temp_useless_column to _index; 152/* Prelude_Checksum->_index data type updated*/ 153 154/* Update the data type of the column _index from Prelude_Action */ 155ALTER TABLE Prelude_Action ADD COLUMN temp_useless_column INT4; 156UPDATE Prelude_Action SET temp_useless_column = CAST(_index AS INT4); 157ALTER TABLE Prelude_Action DROP COLUMN _index; 158ALTER TABLE Prelude_Action RENAME temp_useless_column to _index; 159/* Prelude_Action->_index data type updated*/ 160 161/* Update the data type of the column _index from Prelude_AdditionalData */ 162ALTER TABLE Prelude_AdditionalData ADD COLUMN temp_useless_column INT4; 163UPDATE Prelude_AdditionalData SET temp_useless_column = CAST(_index AS INT4); 164ALTER TABLE Prelude_AdditionalData DROP COLUMN _index; 165ALTER TABLE Prelude_AdditionalData RENAME temp_useless_column to _index; 166/* Prelude_AdditionalData->_index data type updated*/ 167 168/* Update the data type of the column _parent0_index from Prelude_Node */ 169ALTER TABLE Prelude_Node ADD COLUMN temp_useless_column INT4; 170UPDATE Prelude_Node SET temp_useless_column = CAST(_parent0_index AS INT4); 171ALTER TABLE Prelude_Node DROP COLUMN _parent0_index; 172ALTER TABLE Prelude_Node RENAME temp_useless_column to _parent0_index; 173/* Prelude_Node->_parent0_index data type updated*/ 174 175/* Update the data type of the column _parent0_index from Prelude_Address */ 176ALTER TABLE Prelude_Address ADD COLUMN temp_useless_column INT4; 177UPDATE Prelude_Address SET temp_useless_column = CAST(_parent0_index AS INT4); 178ALTER TABLE Prelude_Address DROP COLUMN _parent0_index; 179ALTER TABLE Prelude_Address RENAME temp_useless_column to _parent0_index; 180/* Prelude_Address->_parent0_index data type updated*/ 181/* Update the data type of the column _index from Prelude_Address */ 182ALTER TABLE Prelude_Address ADD COLUMN temp_useless_column INT4; 183UPDATE Prelude_Address SET temp_useless_column = CAST(_index AS INT4); 184ALTER TABLE Prelude_Address DROP COLUMN _index; 185ALTER TABLE Prelude_Address RENAME temp_useless_column to _index; 186/* Prelude_Address->_index data type updated*/ 187 188/* Update the data type of the column _parent0_index from Prelude_User */ 189ALTER TABLE Prelude_User ADD COLUMN temp_useless_column INT4; 190UPDATE Prelude_User SET temp_useless_column = CAST(_parent0_index AS INT4); 191ALTER TABLE Prelude_User DROP COLUMN _parent0_index; 192ALTER TABLE Prelude_User RENAME temp_useless_column to _parent0_index; 193/* Prelude_User->_parent0_index data type updated*/ 194 195/* Update the data type of the column _parent0_index from Prelude_UserId */ 196ALTER TABLE Prelude_UserId ADD COLUMN temp_useless_column INT4; 197UPDATE Prelude_UserId SET temp_useless_column = CAST(_parent0_index AS INT4); 198ALTER TABLE Prelude_UserId DROP COLUMN _parent0_index; 199ALTER TABLE Prelude_UserId RENAME temp_useless_column to _parent0_index; 200/* Prelude_UserId->_parent0_index data type updated*/ 201/* Update the data type of the column _parent1_index from Prelude_UserId */ 202ALTER TABLE Prelude_UserId ADD COLUMN temp_useless_column INT4; 203UPDATE Prelude_UserId SET temp_useless_column = CAST(_parent1_index AS INT4); 204ALTER TABLE Prelude_UserId DROP COLUMN _parent1_index; 205ALTER TABLE Prelude_UserId RENAME temp_useless_column to _parent1_index; 206/* Prelude_UserId->_parent1_index data type updated*/ 207/* Update the data type of the column _parent2_index from Prelude_UserId */ 208ALTER TABLE Prelude_UserId ADD COLUMN temp_useless_column INT4; 209UPDATE Prelude_UserId SET temp_useless_column = CAST(_parent2_index AS INT4); 210ALTER TABLE Prelude_UserId DROP COLUMN _parent2_index; 211ALTER TABLE Prelude_UserId RENAME temp_useless_column to _parent2_index; 212/* Prelude_UserId->_parent2_index data type updated*/ 213/* Update the data type of the column _index from Prelude_UserId */ 214ALTER TABLE Prelude_UserId ADD COLUMN temp_useless_column INT4; 215UPDATE Prelude_UserId SET temp_useless_column = CAST(_index AS INT4); 216ALTER TABLE Prelude_UserId DROP COLUMN _index; 217ALTER TABLE Prelude_UserId RENAME temp_useless_column to _index; 218/* Prelude_UserId->_index data type updated*/ 219 220/* Update the data type of the column _parent0_index from Prelude_Process */ 221ALTER TABLE Prelude_Process ADD COLUMN temp_useless_column INT4; 222UPDATE Prelude_Process SET temp_useless_column = CAST(_parent0_index AS INT4); 223ALTER TABLE Prelude_Process DROP COLUMN _parent0_index; 224ALTER TABLE Prelude_Process RENAME temp_useless_column to _parent0_index; 225/* Prelude_Process->_parent0_index data type updated*/ 226 227/* Update the data type of the column _parent0_index from Prelude_ProcessArg */ 228ALTER TABLE Prelude_ProcessArg ADD COLUMN temp_useless_column INT4; 229UPDATE Prelude_ProcessArg SET temp_useless_column = CAST(_parent0_index AS INT4); 230ALTER TABLE Prelude_ProcessArg DROP COLUMN _parent0_index; 231ALTER TABLE Prelude_ProcessArg RENAME temp_useless_column to _parent0_index; 232/* Prelude_ProcessArg->_parent0_index data type updated*/ 233/* Update the data type of the column _index from Prelude_ProcessArg */ 234ALTER TABLE Prelude_ProcessArg ADD COLUMN temp_useless_column INT4; 235UPDATE Prelude_ProcessArg SET temp_useless_column = CAST(_index AS INT4); 236ALTER TABLE Prelude_ProcessArg DROP COLUMN _index; 237ALTER TABLE Prelude_ProcessArg RENAME temp_useless_column to _index; 238/* Prelude_ProcessArg->_index data type updated*/ 239 240/* Update the data type of the column _parent0_index from Prelude_ProcessEnv */ 241ALTER TABLE Prelude_ProcessEnv ADD COLUMN temp_useless_column INT4; 242UPDATE Prelude_ProcessEnv SET temp_useless_column = CAST(_parent0_index AS INT4); 243ALTER TABLE Prelude_ProcessEnv DROP COLUMN _parent0_index; 244ALTER TABLE Prelude_ProcessEnv RENAME temp_useless_column to _parent0_index; 245/* Prelude_ProcessEnv->_parent0_index data type updated*/ 246/* Update the data type of the column _index from Prelude_ProcessEnv */ 247ALTER TABLE Prelude_ProcessEnv ADD COLUMN temp_useless_column INT4; 248UPDATE Prelude_ProcessEnv SET temp_useless_column = CAST(_index AS INT4); 249ALTER TABLE Prelude_ProcessEnv DROP COLUMN _index; 250ALTER TABLE Prelude_ProcessEnv RENAME temp_useless_column to _index; 251/* Prelude_ProcessEnv->_index data type updated*/ 252 253/* Update the data type of the column _parent0_index from Prelude_WebService */ 254ALTER TABLE Prelude_WebService ADD COLUMN temp_useless_column INT4; 255UPDATE Prelude_WebService SET temp_useless_column = CAST(_parent0_index AS INT4); 256ALTER TABLE Prelude_WebService DROP COLUMN _parent0_index; 257ALTER TABLE Prelude_WebService RENAME temp_useless_column to _parent0_index; 258/* Prelude_WebService->_parent0_index data type updated*/ 259 260/* Update the data type of the column _parent0_index from Prelude_WebServiceArg */ 261ALTER TABLE Prelude_WebServiceArg ADD COLUMN temp_useless_column INT4; 262UPDATE Prelude_WebServiceArg SET temp_useless_column = CAST(_parent0_index AS INT4); 263ALTER TABLE Prelude_WebServiceArg DROP COLUMN _parent0_index; 264ALTER TABLE Prelude_WebServiceArg RENAME temp_useless_column to _parent0_index; 265/* Prelude_WebServiceArg->_parent0_index data type updated*/ 266/* Update the data type of the column _index from Prelude_WebServiceArg */ 267ALTER TABLE Prelude_WebServiceArg ADD COLUMN temp_useless_column INT4; 268UPDATE Prelude_WebServiceArg SET temp_useless_column = CAST(_index AS INT4); 269ALTER TABLE Prelude_WebServiceArg DROP COLUMN _index; 270ALTER TABLE Prelude_WebServiceArg RENAME temp_useless_column to _index; 271/* Prelude_WebServiceArg->_index data type updated*/ 272 273/* Update the data type of the column _parent0_index from Prelude_SNMPService */ 274ALTER TABLE Prelude_SNMPService ADD COLUMN temp_useless_column INT4; 275UPDATE Prelude_SNMPService SET temp_useless_column = CAST(_parent0_index AS INT4); 276ALTER TABLE Prelude_SNMPService DROP COLUMN _parent0_index; 277ALTER TABLE Prelude_SNMPService RENAME temp_useless_column to _parent0_index; 278/* Prelude_SNMPService->_parent0_index data type updated*/ 279 280ALTER TABLE Prelude_Linkage ADD PRIMARY KEY (_message_ident, _parent0_index, _parent1_index, _index); 281 282ALTER TABLE Prelude_Impact ADD CHECK (severity IN ('info', 'low', 'medium', 'high')); 283 284DROP INDEX prelude_node_index_name; 285DROP INDEX prelude_node_index_location; 286CREATE INDEX prelude_node_index_location ON Prelude_Node (_parent_type,_parent0_index,location); 287CREATE INDEX prelude_node_index_name ON Prelude_Node (_parent_type,_parent0_index,name); 288DROP INDEX prelude_address_index_address; 289CREATE INDEX prelude_address_index_address ON Prelude_Address (_parent_type,_parent0_index,_index,address); 290 291DROP INDEX prelude_service_index_protocol_port; 292DROP INDEX prelude_service_index_protocol_name; 293CREATE INDEX prelude_service_index_protocol_port ON Prelude_Service (_parent_type,_parent0_index,protocol, port); 294CREATE INDEX prelude_service_index_protocol_name ON Prelude_Service (_parent_type,_parent0_index,protocol, name); 295 296