xref: /plugin/structnotification/db/update0002.sql (revision e4050f96b6dcfab785452ad4f1478151d79238be)
1CREATE TABLE predicateTemp (
2    id INTEGER PRIMARY KEY AUTOINCREMENT,
3    schema TEXT NOT NULL,
4    field TEXT NOT NULL,
5    operator TEXT NOT NULL,
6    value TEXT NOT NULL,
7    users_and_groups TEXT NOT NULL,
8    message TEXT NOT NULL
9);
10
11INSERT INTO predicateTemp(id,schema,field,operator,value,users_and_groups,message)
12    SELECT id,schema,field,operator,days,users_and_groups,message FROM predicate;
13
14DROP TABLE predicate;
15ALTER TABLE predicateTemp RENAME TO predicate;
16