makedb

CREATE TABLE users ( 
	'user_id' 	INTEGER Primary key,
	'name'  	TEXT,
	'screenName'  	TEXT,
	'email'  	TEXT,
	'location' 	TEXT,
	'meetsCount' 	INTEGER,
	'profileImageUrl' 	TEXT
);

CREATE INDEX users_name on users(name);

CREATE TABLE meets (
	'id'        INTEGER,
	'postId'    INTEGER,
	'userId'    INTEGER,
	'type'	    INTEGER,
	'timeAt'    INTEGER,
	'updateAt'  INTEGER,
	'longitude' TEXT,
	'latitude'  TEXT,
	'description'	TEXT,
	'source'     TEXT,
	'user_count' INTEGER,
PRIMARY KEY(id,postid,type)
);

CREATE INDEX meet_ids on meets(id);
CREATE INDEX post_ids on meets(postId);

CREATE TABLE news (
        'id'      INTEGER,
        'odd'     INTEGER,
        'uid'     INTEGER,
        'cid'     INTEGER,
        'data'    TEXT,
PRIMARY KEY(id)
);
CREATE INDEX news_ids on news(id);
CREATE INDEX news_odds on news(odd);
CREATE INDEX cirkle_uids on news(uid);
CREATE INDEX cirkle_cids on news(cid);

CREATE TABLE cirkles (
        'id'      INTEGER,
        'odd'     INTEGER,
        'data'    TEXT,
PRIMARY KEY(id)
);
CREATE INDEX cirkle_ids on cirkles(id);
CREATE INDEX cirkle_odds on cirkles(odd);

CREATE TABLE statistics (
        'id'      INTEGER,
        'odd'     INTEGER,
        'cirkle'  TEXT,
        'news'    TEXT,
        'misc'    TEXT,
PRIMARY KEY(id)
);
CREATE INDEX statistics_ids on statistics(id);