Added goose for migrations, refactored SQL schema, server and client

are broken

1 files changed, 13 insertions, 0 deletions

diff --git a/internal/server/api/migrations/20250109135310_networks.sql b/internal/server/api/migrations/20250109135310_networks.sql
new file mode 100644
index 0000000..c3332c8
--- /dev/null
+++ b/internal/server/api/migrations/20250109135310_networks.sql
@@ -0,0 +1,13 @@
+-- +goose Up
+CREATE TABLE IF NOT EXISTS networks (
+  id INTEGER PRIMARY KEY,
+  owner_id INT NOT NULL REFERENCES users (id),
+  name TEXT NOT NULL,
+  icon TEXT NOT NULL,
+  bg_hex_color TEXT NOT NULL,
+  fg_hex_color TEXT NOT NULL,
+  is_public BOOLEAN NOT NULL CHECK (is_public IN (false, true))
+);
+
+-- +goose Down
+DROP TABLE IF EXISTS networks;