]>
Dogcows Code - chaz/chatty/blob - db/schema.sql
536b1f372cf74467248dd1c573a2f289676146b8
2 PRAGMA foreign_keys
= ON;
5 id INTEGER PRIMARY KEY,
7 created
TIMESTAMP DEFAULT CURRENT_TIMESTAMP
10 CREATE TABLE account (
11 id INTEGER PRIMARY KEY,
13 password TEXT NOT NULL,
14 status
TEXT DEFAULT 'active',
15 current_room
INTEGER REFERENCES room(id)
18 CREATE TABLE message (
19 id INTEGER PRIMARY KEY,
20 posted
TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
21 author
INTEGER REFERENCES account(id),
22 room
INTEGER REFERENCES room(id),
26 INSERT INTO account (username
, password) VALUES ('chaz', 'mypass');
27 INSERT INTO account (username
, password) VALUES ('jdoe', 'foobar');
This page took 0.035026 seconds and 3 git commands to generate.