CREATE TABLE MESSAGES (
    id,parent_id,parent_type,author_id,title,contents,view_count,rating,date_created,date_modified
);


CREATE TABLE FORUMS (
    id,type_name,parent_id,num_children,title,description
);


CREATE TABLE FORUM_TYPES (
    type_name,description
);


CREATE TABLE ACCOUNTS (
    id,primary_contact_id,primary_login_id,account_type,userinfo_id,name,composite_bio,nickname,karma_rating
);


CREATE TABLE LOGINS (
    id,account_id,username,password
);


CREATE TABLE CONTACTS (
    id,account_id,primary_address_id,contact_type,email,first,last,bio,bday
);


CREATE TABLE ADDRESSES (
    id,contact_id,address_line_1,address_line_2,city,state,zip_us,zip_us4,zip_intl,country
);


CREATE TABLE STATES (
    abbreviation,name
);


CREATE TABLE COUNTRIES (
    abbreviation,name
);


CREATE TABLE GROUPS (
    id,name,description,contact_id,created_by_account_id
);


CREATE TABLE GROUP_MEMBERS (
    account_id,group_id
);


CREATE TABLE FILES (
    id,title,description,filename,mime_type,view_count,download_count
);


CREATE TABLE ATTACHMENTS (
    id,message_id,file_id
);


CREATE TABLE VOTES (
    id,rating_scale,vote,account_id
);


CREATE TABLE CONTESTS (
    id,name,description,entry_deadline
);


CREATE TABLE CONTEST_ENTRIES (
    id,contest_id,account_id,file_id
);


CREATE TABLE CONTEST_RESULTS (
    id,entry_id,rank,overall_rating
);


CREATE TABLE PERMISSION_CHAIN (
    id,parent_id,signature_lock
);


CREATE TABLE PERMISSION_LEVEL_TYPES (
    id,level,name
);


CREATE TABLE PERMISSIONS (
    id,chain_id,level_id,permissions_granted
);


CREATE TABLE PRIVILEGES (
    id,user_id,signature_key
);


CREATE TABLE USER_LEVELS (
    id,user_id,level_id,
);