Chris@909: CREATE TABLE 'companies' (
Chris@909:   'id' INTEGER PRIMARY KEY NOT NULL,
Chris@909:   'name' TEXT DEFAULT NULL,
Chris@909:   'rating' INTEGER DEFAULT 1
Chris@909: );
Chris@909: 
Chris@909: CREATE TABLE 'replies' (
Chris@909:   'id' INTEGER PRIMARY KEY NOT NULL, 
Chris@909:   'content' text, 
Chris@909:   'created_at' datetime, 
Chris@909:   'updated_at' datetime, 
Chris@909:   'topic_id' integer
Chris@909: );
Chris@909: 
Chris@909: CREATE TABLE 'topics' (
Chris@909:   'id' INTEGER PRIMARY KEY NOT NULL, 
Chris@909:   'title' varchar(255), 
Chris@909:   'subtitle' varchar(255), 
Chris@909:   'content' text, 
Chris@909:   'created_at' datetime, 
Chris@909:   'updated_at' datetime
Chris@909: );
Chris@909: 
Chris@909: CREATE TABLE 'developers' (
Chris@909:   'id' INTEGER PRIMARY KEY NOT NULL,
Chris@909:   'name' TEXT DEFAULT NULL,
Chris@909:   'salary' INTEGER DEFAULT 70000,
Chris@909:   'created_at' DATETIME DEFAULT NULL,
Chris@909:   'updated_at' DATETIME DEFAULT NULL
Chris@909: );
Chris@909: 
Chris@909: CREATE TABLE 'projects' (
Chris@909:   'id' INTEGER PRIMARY KEY NOT NULL,
Chris@909:   'name' TEXT DEFAULT NULL
Chris@909: );
Chris@909: 
Chris@909: CREATE TABLE 'developers_projects' (
Chris@909:   'developer_id' INTEGER NOT NULL,
Chris@909:   'project_id' INTEGER NOT NULL,
Chris@909:   'joined_on' DATE DEFAULT NULL,
Chris@909:   'access_level' INTEGER DEFAULT 1
Chris@909: );