X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fchatty;a=blobdiff_plain;f=db%2Fschema.sql;fp=db%2Fschema.sql;h=0b8a7104b91534d25e9344df343a33fbd7f166c5;hp=0000000000000000000000000000000000000000;hb=d4c693d621d476e20ea670aad267c60960963826;hpb=ce10e1dfe911071e99c51edbcd34b74b2615f847

diff --git a/db/schema.sql b/db/schema.sql
new file mode 100644
index 0000000..0b8a710
--- /dev/null
+++ b/db/schema.sql
@@ -0,0 +1,20 @@
+
+PRAGMA foreign_keys = ON;
+
+CREATE TABLE account (
+	id				INTEGER PRIMARY KEY,
+	username	TEXT,
+	password	TEXT,
+	status		TEXT DEFAULT 'active'
+);
+
+CREATE TABLE message (
+	id				INTEGER PRIMARY KEY,
+	posted		TIMESTAMP,
+	author		INTEGER REFERENCES account(id),
+	content		TEXT
+);
+
+INSERT INTO account (username, password) VALUES ('chaz', 'mypass');
+INSERT INTO account (username, password) VALUES ('jdoe', 'foobar');
+