upd: new server fieldsHEADmaster

1 files changed, 6 insertions, 4 deletions

diff --git a/database.sql b/database.sql
index c15b2f2..9b46753 100644
--- a/database.sql
+++ b/database.sql
@@ -1,10 +1,12 @@
 CREATE TABLE IF NOT EXISTS servers (
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
     host TEXT NOT NULL UNIQUE,
-    port INTEGER NOT NULL,
-    nick TEXT NOT NULL,
-    pass TEXT NOT NULL,
-    capabilities TEXT NOT NULL
+    port SMALLINT UNSIGNED NOT NULL,
+    nick TEXT,
+    pass TEXT,
+    capabilities TEXT,
+    added_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP(),
+    UNIQUE (host, port)
 );
 
 CREATE TABLE IF NOT EXISTS rooms (