This repository has been archived on 2024-07-22. You can view files and clone it, but cannot push or open issues or pull requests.
Zaimki/migrations/007-entry-authors.sql

13 lines
403 B
MySQL
Raw Permalink Normal View History

-- Up
ALTER TABLE nouns ADD COLUMN author_id TEXT NULL REFERENCES users(id);
ALTER TABLE nouns ADD COLUMN deleted INTEGER NOT NULL DEFAULT 0;
ALTER TABLE inclusive ADD COLUMN author_id TEXT NULL REFERENCES users(id);
ALTER TABLE inclusive ADD COLUMN categories TEXT NULL;
ALTER TABLE inclusive ADD COLUMN links TEXT NULL;
ALTER TABLE inclusive ADD COLUMN deleted INTEGER NOT NULL DEFAULT 0;
-- Down