diff options
| author | Jokler <jokler.contact@gmail.com> | 2017-12-16 18:13:02 +0100 |
|---|---|---|
| committer | Jokler <jokler.contact@gmail.com> | 2017-12-24 01:24:58 +0100 |
| commit | 4b5693d3c6781a5ca4ef32f43f3994a65020c933 (patch) | |
| tree | fcea35b595542661d1f6713d860d647832aabd47 /migrations | |
| parent | 5928afc3bf83661cd3b11130a31a2d97ef135a9e (diff) | |
| download | frippy-4b5693d3c6781a5ca4ef32f43f3994a65020c933.tar.gz frippy-4b5693d3c6781a5ca4ef32f43f3994a65020c933.zip | |
Add more info to factoids and save old versions
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/.gitkeep | 0 | ||||
| -rw-r--r-- | migrations/2017-11-03-164322_create_factoids/up.sql | 8 |
2 files changed, 6 insertions, 2 deletions
diff --git a/migrations/.gitkeep b/migrations/.gitkeep deleted file mode 100644 index e69de29..0000000 --- a/migrations/.gitkeep +++ /dev/null diff --git a/migrations/2017-11-03-164322_create_factoids/up.sql b/migrations/2017-11-03-164322_create_factoids/up.sql index 84e9f9d..784a3f4 100644 --- a/migrations/2017-11-03-164322_create_factoids/up.sql +++ b/migrations/2017-11-03-164322_create_factoids/up.sql @@ -1,4 +1,8 @@ CREATE TABLE factoids ( - name VARCHAR(32) PRIMARY KEY, - content VARCHAR(5000) NOT NULL + name VARCHAR(32) NOT NULL, + idx INTEGER NOT NULL, + content TEXT NOT NULL, + author VARCHAR(32) NOT NULL, + created TIMESTAMP NOT NULL, + PRIMARY KEY (name, idx) ) |