diff options
| author | mo khan <mo@mokhan.ca> | 2022-05-15 14:05:12 -0600 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2022-05-15 14:05:12 -0600 |
| commit | 3d6dd877a8ac212a8ff622060be78fc226476498 (patch) | |
| tree | 07322a147649169e1b8ccf2da2634a2e6509fe47 /db | |
| parent | 200dd197c30467d5f9739c24c6095460ad31b2ea (diff) | |
create database
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/000001_create_clients_table.down.sql | 1 | ||||
| -rw-r--r-- | db/migrate/000001_create_clients_table.up.sql | 4 |
2 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/000001_create_clients_table.down.sql b/db/migrate/000001_create_clients_table.down.sql new file mode 100644 index 0000000..1100f5d --- /dev/null +++ b/db/migrate/000001_create_clients_table.down.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS clients; diff --git a/db/migrate/000001_create_clients_table.up.sql b/db/migrate/000001_create_clients_table.up.sql new file mode 100644 index 0000000..e5af07b --- /dev/null +++ b/db/migrate/000001_create_clients_table.up.sql @@ -0,0 +1,4 @@ +CREATE TABLE IF NOT EXISTS clients( + id serial PRIMARY KEY, + name VARCHAR(255) NOT NULL +); |