diff options
| author | Nathan Perry <avaglir@gmail.com> | 2018-02-15 00:03:32 -0500 |
|---|---|---|
| committer | Nathan Perry <avaglir@gmail.com> | 2018-02-15 00:03:51 -0500 |
| commit | d410d75ca967d476784eaca22d6e49f21ca318dd (patch) | |
| tree | 77d1c364e075e6f6123d7fcd238a04496664e66b /migrations/2018-02-15-031841_create_memes | |
| parent | 66eeaaab1777c6bb85627c2a41fd5234a7576f84 (diff) | |
start adding in diesel
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
+);
+
|