CREATE TABLE object ( id INT AUTO_INCREMENT PRIMARY KEY );
CREATE TABLE group ( id INT PRIMARY KEY );
CREATE TABLE user ( id INT PRIMARY KEY, name VARCHAR(40), salt VARCHAR(8), pass VARCHAR(32), theme VARCHAR(16) );
CREATE TABLE groupXuser ( gid INT, uid INT, PRIMARY KEY (gid, uid) );
CREATE TABLE post ( id INT PRIMARY KEY, creator INT );
CREATE TABLE claimant ( id INT PRIMARY KEY, name VARCHAR(16) );
CREATE TABLE case ( id INT PRIMARY KEY, claimant_id INT, user_id INT, content ID brief VARCHAR(256), claim TEXT, veracity INT, analysis TEXT );
CREATE TABLE content ( id INT PRIMARY KEY, );
CREATE TABLE case_content ( case INT, content INT, PRIMARY KEY(case, content) );
CREATE TABLE tag ( id INT PRIMARY KEY, name VARCHAR(16) );
CREATE TABLE postXtag ( pid INT, tid INT, PRIMARY KEY (pid, tid) );
CREATE TABLE rating ( uid INT, pid INT, value INT, PRIMARY KEY (uid, pid) );
CREATE TABLE ssn ( id VARCHAR(32) PRIMARY KEY, ctime INT UNSIGNED );
CREATE TABLE access ( agent INT, target INT, can_modify BOOL, PRIMARY KEY( agent, target ) ); # agent→object.id ; target→object.id
CREATE TABLE comment ( id INT, parent INT, uid INT, subject VARCHAR(32), content TEXT ); # id→post.id