DashBot/db/migrations/20160823170358_users.sql
Arthur Poulet c9fde074c0
Change to Postgresql
* Remove mongodb (this database and the lib suck so much)
* Update in the readme the database installation
* Add migrations for users, points, messages, groups
  Note: Must be improved (FK, IX, ...)
* Update database and add Sql requests
2016-08-23 18:52:49 +02:00

10 lines
159 B
SQL

-- +micrate Up
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name TEXT NOT NULL,
CONSTRAINT name_uniq UNIQUE (name)
);
-- +micrate Down
DROP TABLE users;