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




