diff options
Diffstat (limited to 'migrations/2018-02-15-031841_create_memes')
| -rw-r--r-- | migrations/2018-02-15-031841_create_memes/down.sql | 3 | ||||
| -rw-r--r-- | migrations/2018-02-15-031841_create_memes/up.sql | 14 |
2 files changed, 17 insertions, 0 deletions
diff --git a/migrations/2018-02-15-031841_create_memes/down.sql b/migrations/2018-02-15-031841_create_memes/down.sql new file mode 100644 index 0000000..8de6d95 --- /dev/null +++ b/migrations/2018-02-15-031841_create_memes/down.sql @@ -0,0 +1,3 @@ +DROP TABLE text_memes;
+DROP TABLE image_memes;
+DROP TABLE audio_memes;
diff --git a/migrations/2018-02-15-031841_create_memes/up.sql b/migrations/2018-02-15-031841_create_memes/up.sql new file mode 100644 index 0000000..38097e7 --- /dev/null +++ b/migrations/2018-02-15-031841_create_memes/up.sql @@ -0,0 +1,14 @@ +CREATE TABLE text_memes (
+ id SERIAL PRIMARY KEY,
+ title varchar UNIQUE NOT NULL,
+ content TEXT NOT NULL,
+ pic_related varchar NULL,
+ UNIQUE(content, pic_related)
+);
+
+CREATE TABLE audio_memes (
+ id SERIAL PRIMARY KEY,
+ title varchar UNIQUE NOT NULL,
+ link varchar UNIQUE NOT NULL
+);
+
|