From 977c7c38ff4196f43c4784308d81fd7e6a471511 Mon Sep 17 00:00:00 2001 From: syn Date: Mon, 16 Mar 2020 22:17:48 +0300 Subject: Init commit --- app/schema.py | 37 +++++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 app/schema.py (limited to 'app/schema.py') diff --git a/app/schema.py b/app/schema.py new file mode 100644 index 0000000..247638f --- /dev/null +++ b/app/schema.py @@ -0,0 +1,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' +] -- cgit v1.2.1-18-gbd029