tables.sql 853 Bytes
Newer Older
David Morley's avatar
David Morley committed
1 2 3
CREATE TABLE pods (
 id serial8 UNIQUE PRIMARY KEY,
 domain text UNIQUE NOT NULL,
David Morley's avatar
David Morley committed
4
 score int DEFAULT 10,
5 6
 adminrating decimal DEFAULT 10,
 userrating decimal DEFAULT 10,
David Morley's avatar
David Morley committed
7
 whois text,
8
 hidden text DEFAULT 'yes',
David Morley's avatar
David Morley committed
9 10
 ip cidr,
 ptr text,
11
 country text,
David Morley's avatar
David Morley committed
12
 email text,
13
 ipv6 text,
David Morley's avatar
David Morley committed
14 15 16 17 18 19
 secure text,
 sslvalid text,
 Hgitdate text,
 Hgitref text,
 Hruntime text,
 Hencoding text,
20 21
 pingdomurl text,
 pingdomlast text,
David Morley's avatar
David Morley committed
22 23 24 25 26 27 28
 monthsmonitored int,
 uptimelast7 text,
 status text,
 responsetimelast7 text,
 dateUpdated timestamp DEFAULT current_timestamp,
 dateLaststats timestamp DEFAULT current_timestamp,
 dateCreated timestamp DEFAULT current_timestamp
David Morley's avatar
David Morley committed
29 30 31 32 33 34 35
);
CREATE TABLE rating_comments (
 id serial8 UNIQUE PRIMARY KEY,
 domain text NOT NULL,
 comment text,
 admin text, 
 pod_id int,
36 37
 rating int,
 username text,
David Morley's avatar
David Morley committed
38 39
 userurl text,
 date timestamp DEFAULT current_timestamp
David Morley's avatar
David Morley committed
40
);