diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/20220822142548_add-users-table.sql | 6 | ||||
| -rw-r--r-- | migrations/20220903093057_add-users-table.sql | 7 |
2 files changed, 7 insertions, 6 deletions
diff --git a/migrations/20220822142548_add-users-table.sql b/migrations/20220822142548_add-users-table.sql deleted file mode 100644 index 4798d7e..0000000 --- a/migrations/20220822142548_add-users-table.sql +++ /dev/null @@ -1,6 +0,0 @@ -create table users ( - id serial unique, - email varchar(100) unique not null, - password varchar(100) not null, - is_staff boolean default false -); diff --git a/migrations/20220903093057_add-users-table.sql b/migrations/20220903093057_add-users-table.sql new file mode 100644 index 0000000..0fb83c4 --- /dev/null +++ b/migrations/20220903093057_add-users-table.sql @@ -0,0 +1,7 @@ +CREATE TABLE USERS ( + id SERIAL UNIQUE PRIMARY KEY, + email VARCHAR(100) UNIQUE NOT NULL, + username VARCHAR(100) UNIQUE NOT NULL, + password VARCHAR(100) NOT NULL, + is_staff BOOLEAN DEFAULT FALSE +); |
