blob: 38b934fe80c22d7e126f49afa12f514c2ad1e07b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
schema_up = [
'''
CREATE TABLE IF NOT EXISTS pics (
id SERIAL PRIMARY KEY UNIQUE,
src_url VARCHAR(1024),
content_type VARCHAR(256),
deleted BOOLEAN
);
''',
'''
CREATE TABLE IF NOT EXISTS tags (
id SERIAL NOT NULL PRIMARY KEY,
tag_name VARCHAR(128)
);
''',
'''
CREATE TABLE IF NOT EXISTS tags_pics (
pic_id INT NOT NULL,
tag_id INT NOT NULL,
PRIMARY KEY (pic_id, tag_id),
FOREIGN KEY (pic_id) REFERENCES pics(id) ON UPDATE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON UPDATE CASCADE
);
'''
]
schema_down = [
'DROP TABLE tags_pics',
'DROP TABLE tags',
'DROP TABLE pics'
]
schema_delete = [
'DELETE * FROM tags_pics'
'DELETE * FROM tags'
'DELETE * FROM pics'
]
|
