Schema changes

2 files changed, 20 insertions, 6 deletions

diff --git a/internal/client/ui/networks/networks.go b/internal/client/ui/networks/networks.go
index b146ae0..05f8b27 100644
--- a/internal/client/ui/networks/networks.go
+++ b/internal/client/ui/networks/networks.go
@@ -33,15 +33,20 @@ var (
 
 	label1 = lipgloss.NewStyle().
 		Background(lipgloss.Color("#20999D")).Foreground(lipgloss.Color("#000000")).
-		// Padding(0, 1).
+		Padding(0, 1).
 		Bold(true).
-		Render("Dev")
+		Render("󰜈")
 	label2 = reverse.Render("") + label1 + reverse.Render("")
+	label3 = ""
+	label4 = lipgloss.NewStyle().
+		Foreground(lipgloss.Color("#20999D")).
+		Bold(true).
+		Render("󰜈")
 
 	name = lipgloss.NewStyle().
 		Bold(true).
 		Render("Kyren223")
-	user = lipgloss.JoinHorizontal(lipgloss.Center, label2, " ", name)
+	user = lipgloss.JoinHorizontal(lipgloss.Center, label4, " ", name)
 )
 
 type Model struct {
diff --git a/migrations/20241026174345_init.sql b/migrations/20241026174345_init.sql
index ad1f65f..8f3e8a1 100644
--- a/migrations/20241026174345_init.sql
+++ b/migrations/20241026174345_init.sql
@@ -3,6 +3,7 @@ CREATE TABLE messages (
   id INTEGER PRIMARY KEY,
   sender_id INT NOT NULL REFERENCES users (id),
   content TEXT NOT NULL,
+  edited BOOLEAN NOT NULL CHECK (edited IN (0, 1)),
 
   frequency_id INT REFERENCES frequencies (id),
   receiver_id INT REFERENCES users (id),
@@ -16,24 +17,32 @@ CREATE TABLE messages (
 CREATE TABLE users (
   id INTEGER PRIMARY KEY,
   name TEXT NOT NULL,
-  public_key BLOB NOT NULL
+  public_key BLOB NOT NULL,
+  bio TEXT
 );
 
 CREATE TABLE networks (
   id INTEGER PRIMARY KEY,
+  owner_id INT NOT NULL REFERENCES users (id),
   name TEXT NOT NULL,
-  owner_id INT NOT NULL REFERENCES users (id)
+  icon TEXT NOT NULL,
+  bg TEXT NULL,
+  fg TEXT NOT NULL
 );
 
 CREATE TABLE frequencies (
   id INTEGER PRIMARY KEY,
   network_id INT NOT NULL REFERENCES networks (id),
-  name TEXT NOT NULL
+  name TEXT NOT NULL,
+  color TEXT,
+  perms INT NOT NULL CHECK (perms IN (0, 1, 2)),
+  position INT NOT NULL
 );
 
 CREATE TABLE users_networks (
   user_id INT NOT NULL REFERENCES users (id),
   network_id INT NOT NULL REFERENCES networks (id),
+  is_admin BOOLEAN NOT NULL CHECK (is_admin IN (0, 1)),
   PRIMARY KEY (user_id, network_id)
 );