Commits

Luke Plant committed 7695c03

Added 'user' table

  • Participants
  • Parent commits 257db03

Comments (0)

Files changed (1)

schema/install.sql

     format_id INTEGER REFERENCES format(id)
   );
 
+CREATE TABLE users (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    username TEXT,
+    password TEXT,
+    superuser INTEGER
+);
 
 CREATE UNIQUE INDEX post_slug_index ON posts (slug);
 CREATE UNIQUE INDEX post_id_index ON posts (id);