tables.sql

CREATE TABLE pods (
 id serial8 UNIQUE PRIMARY KEY,
 domain text UNIQUE NOT NULL,
 name text,
 softwarename text,
 masterversion text,
 shortversion text,
 score int DEFAULT 10,
 weightedscore numeric(5,2) DEFAULT 10,
 adminrating decimal DEFAULT 10,
 userrating decimal DEFAULT 10,
 whois text,
 hidden boolean DEFAULT 'yes',
 ip text,
 country text,
 city text,
 state text, 
 lat text,
 long text,
 email text,
 ipv6 boolean,
 secure boolean,
 sslvalid text,
 Hgitdate text,
 Hgitref text,
 Hruntime text,
 Hencoding text,
 statsurl text,
 monthsmonitored int,
 signup boolean,
 total_users int, 
 active_users_halfyear int,
 active_users_monthly int,
 local_posts int,
 uptime_alltime numeric(5,2),
 uptime_custom text,
 status text,
 responsetimems text,
 service_facebook boolean,
 service_twitter boolean,
 service_tumblr boolean,
 service_wordpress boolean,
 service_xmpp boolean,
 token text,
 tokenexpire timestamp,
 terms text,
 sslexpire timestamp,
 dnssec boolean,
 comment_counts int,
 weight int DEFAULT 50,
 dateUpdated timestamp DEFAULT current_timestamp,
 dateLaststats timestamp DEFAULT current_timestamp,
 dateCreated timestamp DEFAULT current_timestamp
);
CREATE TABLE rating_comments (
 id serial8 UNIQUE PRIMARY KEY,
 domain text NOT NULL,
 comment text,
 admin text, 
 pod_id int,
 rating int,
 username text,
 userurl text,
 date timestamp DEFAULT current_timestamp
);