Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Tree: cebb358b7e
Fetching contributors…

Cannot retrieve contributors at this time

92 lines (70 sloc) 2.236 kB
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
CREATE FUNCTION unix_timestamp() RETURNS integer
AS $$ SELECT ROUND(EXTRACT( EPOCH FROM abstime(now()) ))::int4 AS result;$$
LANGUAGE sql;
CREATE FUNCTION unix_timestamp(timestamp with time zone) RETURNS integer
AS $_$
SELECT
ROUND(EXTRACT( EPOCH FROM ABSTIME($1) ))::int4 AS result;
$_$
LANGUAGE sql;
CREATE SEQUENCE px_categories_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
SET default_tablespace = '';
SET default_with_oids = false;
CREATE TABLE px_categories (
id integer DEFAULT nextval('px_categories_id_seq'::regclass) NOT NULL,
name text,
unread_cnt integer DEFAULT 0 NOT NULL,
user_id integer DEFAULT 0 NOT NULL
);
CREATE SEQUENCE px_feeds_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
CREATE TABLE px_feeds (
id integer DEFAULT nextval('px_feeds_id_seq'::regclass) NOT NULL,
url character varying(250) DEFAULT ''::character varying NOT NULL,
title character varying(250) DEFAULT ''::character varying NOT NULL,
link character varying(250),
description character varying(250),
total_count integer,
new_count integer,
cat_id integer DEFAULT 0 NOT NULL
);
CREATE SEQUENCE px_items_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
CREATE TABLE px_items (
id integer DEFAULT nextval('px_items_id_seq'::regclass) NOT NULL,
feed_id integer DEFAULT 0 NOT NULL,
"timestamp" timestamp without time zone DEFAULT now() NOT NULL,
link text,
title character varying(250),
content text,
dcdate text,
dccreator text,
dcsubject text,
read smallint
);
ALTER TABLE ONLY px_feeds
ADD CONSTRAINT px_feeds_pkey PRIMARY KEY (id);
ALTER TABLE ONLY px_items
ADD CONSTRAINT px_items_pkey PRIMARY KEY (id);
CREATE INDEX px_items_feed_id_idx ON px_items USING btree (feed_id);
CREATE INDEX px_items_link_idx ON px_items USING btree (link);
CREATE INDEX px_items_read_idx ON px_items USING btree (read);
Jump to Line
Something went wrong with that request. Please try again.