File: pgsql-update-14-5.sql

package info (click to toggle)
libpreludedb 5.2.0-2.2
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 9,232 kB
  • sloc: ansic: 29,652; cpp: 16,567; sh: 12,736; sql: 1,436; python: 449; makefile: 291; yacc: 227; lex: 106; xml: 36
file content (10 lines) | stat: -rw-r--r-- 325 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
 
BEGIN;

UPDATE _format SET version='14.5';
ALTER TABLE Prelude_SnmpService DROP COLUMN community;
ALTER TABLE Prelude_SnmpService ADD COLUMN message_processing_model INT8 NULL;
ALTER TABLE Prelude_SnmpService ADD COLUMN security_model INT8 NULL;
ALTER TABLE Prelude_SnmpService ADD COLUMN security_level INT8 NULL;


COMMIT;