blob: 247638f05a98ad97a1ad773511ac0dbe3d336152 (
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),
ext VARCHAR(10),
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'
]
|
