pGyJ0ARy

1DROP TABLE IF EXISTS Screens;
2CREATE TABLE IF NOT EXISTS Screens (
3    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, 
4    Video TEXT NOT NULL, 
5    TopicId INTEGER NOT NULL, 
6    Instructions TEXT, 
7    ScreenTypeId INTEGER, 
8    SortOrder INTEGER DEFAULT (10), 
9    Image TEXT, 
10    NewColumn INTEGER, 
11    FOREIGN KEY (TopicId) REFERENCES Topics (id), 
12    FOREIGN KEY (ScreenTypeId) REFERENCES ScreenTypes (id)
13    )
14;
15
16DROP TABLE IF EXISTS Topics;
17CREATE TABLE IF NOT EXISTS Topics (ID INTEGER PRIMARY KEY, name TEXT);
18DROP TABLE IF EXISTS ScreenTypes;
19CREATE TABLE IF NOT EXISTS ScreenTypes (ID INTEGER PRIMARY KEY, name TEXT);
20
21INSERT INTO Topics (name) VALUES ('Topic1'),('Topic2'),('Topic3'),('Topic4');
22INSERT INTO ScreenTypes (name) VALUES ('SreenType1'),('ScreenType2'),('ScreenType3'),('ScreenType4');
23INSERT INTO Screens (Video,TopicId,Instructions,ScreenTypeId,Image,NewColumn) VALUES
24    ('Video1',2,'do this 001',3,'Image1','blah'),
25    ('Video2',2,'do this 002',3,'Image2','blah'),
26    ('Video3',1,'do this 002',1,'Image3','blah'),
27    ('Video4',3,'do this 004',4,'Image4','blah'),
28    ('Video5',4,'do this 005',1,'Image5','blah')
29; 
30     
31ALTER TABLE Screens ADD COLUMN ScreenNumber INTEGER DEFAULT 100; 
32     
33ALTER TABLE Screens ADD COLUMN ScreenNumber INTEGER DEFAULT 100
34  OK
35  Time: 0.083s``` 
36     
37SELECT * FROM Screens;