diff options
| author | Akshay <[email protected]> | 2020-10-04 08:53:46 +0100 |
|---|---|---|
| committer | Akshay <[email protected]> | 2020-10-04 08:53:46 +0100 |
| commit | 057382f8d138c63cdc48b0facd9bf4a4a229057a (patch) | |
| tree | b30ba227c49918e0e65fc14068307cf11a9248bc /migrations/2020-09-22-104623_create_users/up.sql | |
init
Diffstat (limited to 'migrations/2020-09-22-104623_create_users/up.sql')
| -rw-r--r-- | migrations/2020-09-22-104623_create_users/up.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/2020-09-22-104623_create_users/up.sql b/migrations/2020-09-22-104623_create_users/up.sql new file mode 100644 index 0000000..dfd27d9 --- /dev/null +++ b/migrations/2020-09-22-104623_create_users/up.sql | |||
| @@ -0,0 +1,8 @@ | |||
| 1 | -- Your SQL goes here | ||
| 2 | CREATE TABLE members ( | ||
| 3 | id INTEGER PRIMARY KEY AUTO_INCREMENT, | ||
| 4 | username VARCHAR(255) NOT NULL UNIQUE, | ||
| 5 | password VARCHAR(255) NOT NULL, | ||
| 6 | phone_number VARCHAR(10) NOT NULL, | ||
| 7 | email_id VARCHAR(255) NOT NULL | ||
| 8 | ) | ||