--schday (alter)
CREATE TABLE _schday (
sch INTEGER NOT NULL, 
num INTEGER NOT NULL,
wk INTEGER NOT NULL,
wdnum INTEGER NOT NULL,
PRIMARY KEY (sch, num));

INSERT INTO _schday (sch, num, wk, wdnum)
SELECT DISTINCT 1, sd.num, s.wk, sd.wdnum FROM sch AS s, schday AS sd;

DROP TABLE schday;

ALTER TABLE _schday RENAME TO schday;

--schwk (create)
CREATE TABLE schwk (
sch INTEGER NOT NULL,
wk INTEGER NOT NULL,
PRIMARY KEY (sch, wk));

INSERT INTO schwk (sch, wk)
SELECT DISTINCT 1, wk FROM sch;

--sch (alter)
CREATE TABLE _sch (
id INTEGER NOT NULL PRIMARY KEY,
stype INTEGER NOT NULL);

INSERT INTO _sch (id, stype)
SELECT DISTINCT 1, stype FROM sch;

DROP TABLE sch;

ALTER TABLE _sch RENAME TO sch;

--supsetopt (alter)
ALTER TABLE wmove ADD COLUMN supsetopt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE edt_wmove ADD COLUMN supsetopt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE exlog ADD COLUMN supsetopt INTEGER NOT NULL DEFAULT 0;
