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/up.sql | |
| parent | 66eeaaab1777c6bb85627c2a41fd5234a7576f84 (diff) | |
start adding in diesel
Diffstat (limited to 'migrations/2018-02-15-031841_create_memes/up.sql')
| -rw-r--r-- | migrations/2018-02-15-031841_create_memes/up.sql | 14 |
1 files changed, 14 insertions, 0 deletions
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
+);
+
|