migrations/2018-02-15-031841_create_memes/up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
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
);