File: sqlite-update-14-4.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 (20 lines) | stat: -rw-r--r-- 487 bytes parent folder | download | duplicates (10)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
UPDATE _format SET version='14.4'; 

BEGIN;

ALTER TABLE Prelude_AdditionalData RENAME TO Prelude_AdditionalDataOld;

CREATE TABLE Prelude_AdditionalData (
 _message_ident INTEGER NOT NULL,
 _parent_type TEXT NOT NULL,
 _index INTEGER NOT NULL,
 type TEXT NOT NULL,
 meaning TEXT NULL,
 data BLOB NOT NULL,
 PRIMARY KEY (_parent_type, _message_ident, _index)
) ;

INSERT INTO Prelude_AdditionalData SELECT * FROM Prelude_AdditionalDataOld;
DROP TABLE Prelude_AdditionalDataOld;

COMMIT;