]>
Dogcows Code - chaz/chatty/blob - db/schema.sql
2 PRAGMA foreign_keys
= ON;
5 id INTEGER PRIMARY KEY,
8 password TEXT NOT NULL,
9 status
TEXT DEFAULT 'active'
12 CREATE TABLE message (
13 id INTEGER PRIMARY KEY,
15 author
INTEGER REFERENCES account(id),
19 INSERT INTO account (username
, password) VALUES ('chaz', 'mypass');
20 INSERT INTO account (username
, password) VALUES ('jdoe', 'foobar');
This page took 0.037696 seconds and 5 git commands to generate.