yoesoff

table users

Jul 15th, 2017
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.67 KB | None | 0 0
  1. -- +goose Up
  2.   -- SQL in this section is executed when the migration is applied.
  3.   CREATE TABLE users(
  4.       name        BIGINT      PRIMARY KEY     NOT NULL,
  5.       username    CHAR(255)                   NOT NULL,
  6.       email       CHAR(255)                   NOT NULL,
  7.       password    CHAR(255)                   NOT NULL,
  8.       is_active   BOOLEAN                     NOT NULL,
  9.       timezone    CHAR(100)                   NOT NULL,
  10.       LANGUAGE    CHAR(100)                   NOT NULL,
  11.       signature   TEXT                        NOT NULL
  12.   );
  13.  
  14.   -- +goose Down
  15.   -- SQL in this section is executed when the migration is rolled back.
  16.   DROP TABLE users;
Advertisement
Add Comment
Please, Sign In to add comment