skyphp-0.1.4.sql

From SkyPHP

Jump to: navigation, search

PostgreSQL:

database description: 

{"skyphp":"version=0.1.4"}

CREATE TABLE "public"."address" (
  "id" SERIAL, 
  "person_id" INTEGER NOT NULL, 
  "address1" VARCHAR(64), 
  "address2" VARCHAR(64), 
  "apt" VARCHAR(32), 
  "city" VARCHAR(32), 
  "state" VARCHAR(2), 
  "zip" VARCHAR(10), 
  "_address_type" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__users_id" INTEGER, 
  "account_id" INTEGER, 
  "unit" VARCHAR(32), 
  "contact_name" VARCHAR(100), 
  CONSTRAINT "address_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."address"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."admin" (
  "id" SERIAL, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "person_id" INTEGER, 
  "access_group" VARCHAR(100), 
  "mod__person_id" INTEGER, 
  CONSTRAINT "admin_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."admin"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog" (
  "id" SERIAL, 
  "name" VARCHAR(255), 
  "url" VARCHAR, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "page_title" VARCHAR(100), 
  "keywords" VARCHAR, 
  "href" VARCHAR(250), 
  "num_articles" INTEGER, 
  "slug" VARCHAR(50), 
  "description" VARCHAR, 
  "copyright_name" VARCHAR, 
  "full_width" INTEGER, 
  "partial_width" INTEGER, 
  "has_markets" SMALLINT, 
  "notification_template" VARCHAR, 
  "notification_subject" VARCHAR, 
  "notification_from" VARCHAR, 
  "logo__media_item_id" INTEGER, 
  "category" VARCHAR, 
  "inverse__media_item_id" INTEGER, 
  "poll_embed_code" VARCHAR, 
  CONSTRAINT "blog_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_article" (
  "id" SERIAL, 
  "blog_id" INTEGER, 
  "author__person_id" INTEGER, 
  "approved__person_id" INTEGER, 
  "duplicate__blog_article_id" INTEGER, 
  "post_time" TIMESTAMP WITHOUT TIME ZONE, 
  "title" VARCHAR(255), 
  "content" VARCHAR, 
  "permalink" VARCHAR, 
  "blog_category_id" INTEGER, 
  "status" VARCHAR(1), 
  "comment_count" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "introduction" VARCHAR(255), 
  "market_id" INTEGER, 
  "featured" SMALLINT DEFAULT 0 NOT NULL, 
  "media_item_id" INTEGER, 
  "tweet_sent" TIMESTAMP WITHOUT TIME ZONE, 
  "venue_id" INTEGER, 
  "notification_to" VARCHAR, 
  "notification_name" VARCHAR, 
  "note" VARCHAR, 
  "notification_sent" TIMESTAMP WITHOUT TIME ZONE, 
  "pageviews" INTEGER DEFAULT 0 NOT NULL, 
  CONSTRAINT "blog_article_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_article"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_article_tag" (
  "id" SERIAL, 
  "blog_article_id" INTEGER, 
  "blog_tag_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "name" VARCHAR, 
  "iorder" INTEGER, 
  CONSTRAINT "blog_article_tag_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_article_tag"
IS '{"codebase":"skyphp"}';

CREATE INDEX "blog_article_tag_idx" ON "public"."blog_article_tag"
  USING btree ("name");

CREATE TABLE "public"."blog_article_video" (
  "id" SERIAL, 
  "blog_article_id" INTEGER, 
  "youtube_url" VARCHAR, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  "type" VARCHAR, 
  "title" VARCHAR, 
  CONSTRAINT "blog_article_video_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_article_video"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_author" (
  "id" SERIAL, 
  "person_id" INTEGER, 
  "blog_id" INTEGER, 
  "featured" SMALLINT, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "position" VARCHAR(50), 
  "iorder" INTEGER, 
  "website_id" INTEGER, 
  "status" VARCHAR(5), 
  "access_group" VARCHAR(100), 
  CONSTRAINT "blog_author_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_author"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_author_market" (
  "id" SERIAL, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  "blog_author_id" INTEGER DEFAULT 0 NOT NULL, 
  "market_id" INTEGER DEFAULT 0 NOT NULL, 
  CONSTRAINT "blog_author_market_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_author_market"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_category" (
  "id" SERIAL, 
  "blog_id" INTEGER, 
  "name" VARCHAR(50), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "slug" VARCHAR(50), 
  "iorder" INTEGER, 
  CONSTRAINT "blog_category_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_category"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_comment" (
  "id" SERIAL, 
  "blog_article_id" INTEGER, 
  "author__person_id" INTEGER, 
  "author_name" VARCHAR(50), 
  "author_email" VARCHAR(100), 
  "author_url" VARCHAR(100), 
  "author_ip" VARCHAR(15), 
  "comment_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "title" VARCHAR(50), 
  "content" VARCHAR, 
  "flag_count" INTEGER, 
  "status" VARCHAR(1), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  CONSTRAINT "blog_comment_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_comment"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_import" (
  "id" SERIAL, 
  "insert_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITHOUT TIME ZONE, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "name" VARCHAR, 
  "import_interval" INTERVAL(65535), 
  "last_import_time" TIMESTAMP WITHOUT TIME ZONE, 
  "blog_id" INTEGER, 
  "author__person_id" INTEGER, 
  "default_status" VARCHAR(1) DEFAULT 'P'::character varying NOT NULL, 
  CONSTRAINT "blog_import_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_import"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_import_keyword" (
  "id" SERIAL, 
  "insert_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITHOUT TIME ZONE, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "blog_import_id" INTEGER, 
  "keyword" VARCHAR, 
  CONSTRAINT "blog_import_keyword_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_import_keyword"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_import_rss" (
  "id" SERIAL, 
  "insert_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITHOUT TIME ZONE, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "blog_import_id" INTEGER, 
  "url" VARCHAR, 
  "malformed" SMALLINT DEFAULT 0 NOT NULL, 
  "last_import_time" TIMESTAMP WITHOUT TIME ZONE, 
  CONSTRAINT "blog_import_rss_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_import_rss"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_media" (
  "id" SERIAL, 
  "type" VARCHAR, 
  "media_item_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  "blog_article_id" INTEGER, 
  "approved" SMALLINT, 
  "title" VARCHAR, 
  CONSTRAINT "blog_media_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_media"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_roll" (
  "id" SERIAL, 
  "blog_id" INTEGER, 
  "name" VARCHAR(50), 
  "url" VARCHAR(50), 
  "contact_name" VARCHAR(50), 
  "contact_email" VARCHAR(50), 
  "contact_phone" VARCHAR(50), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "added_by__person_id" INTEGER, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "status" SMALLINT DEFAULT 1, 
  "pagerank" INTEGER, 
  CONSTRAINT "blog_roll_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_roll"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_tag" (
  "id" SERIAL, 
  "name" VARCHAR(50), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "tag_count" INTEGER, 
  "tag_date" DATE, 
  CONSTRAINT "blog_tag_idx" UNIQUE("name", "account_id"), 
  CONSTRAINT "blog_tag_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_tag"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_user" (
  "id" SERIAL, 
  "person_id" INTEGER, 
  "module" VARCHAR(32), 
  "access_group" VARCHAR(32), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "blog_id" INTEGER, 
  CONSTRAINT "blog_user_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_user"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."blog_website" (
  "id" SERIAL, 
  "blog_id" INTEGER, 
  "website_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "uri" VARCHAR(50), 
  "iorder" INTEGER, 
  "status" VARCHAR(1), 
  "rss_feed" VARCHAR(50), 
  CONSTRAINT "blog_website_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."blog_website"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."dev_codebase" (
  "id" SERIAL, 
  "name" VARCHAR(50), 
  "svn_url" VARCHAR(200), 
  "svn_username" VARCHAR(100), 
  "svn_password" VARCHAR(100), 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  CONSTRAINT "dev_codebase_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."dev_codebase"
IS '{"codebase":"skyphp"}';


CREATE TABLE "public"."media_distro" (
  "id" SERIAL, 
  "media_host_id" INTEGER, 
  "media_item_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "account_id" INTEGER, 
  CONSTRAINT "media_distro_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_distro"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."media_host" (
  "id" SERIAL, 
  "host_name" VARCHAR(50), 
  "domain_name" VARCHAR(50), 
  "ip" VARCHAR(15), 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  CONSTRAINT "media_host_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_host"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."media_instance" (
  "id" SERIAL, 
  "media_item_id" INTEGER, 
  "file_type" VARCHAR(5), 
  "instance" VARCHAR(15), 
  "file_size" INTEGER, 
  "width" INTEGER, 
  "height" INTEGER, 
  "aspect_ratio" NUMERIC(6,3), 
  "binary" BYTEA, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "media_overlay_id" INTEGER, 
  CONSTRAINT "media_instance_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_instance"
IS '{"codebase":"skyphp"}';

CREATE INDEX "media_instance_idx" ON "public"."media_instance"
  USING btree ("active", "media_item_id", "width", "height");

CREATE INDEX "media_instance_idx1" ON "public"."media_instance"
  USING btree ("id", "active");

CREATE TABLE "public"."media_item" (
  "id" SERIAL, 
  "name" VARCHAR(100), 
  "slug" VARCHAR(125), 
  "keywords" VARCHAR(250), 
  "caption" VARCHAR, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "media_vfolder_id" INTEGER, 
  "iorder" INTEGER, 
  "views" INTEGER DEFAULT 0 NOT NULL, 
  "comment_count" INTEGER, 
  "title" VARCHAR, 
  "credits" VARCHAR, 
  CONSTRAINT "media_item_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_item"
IS '{
"codebase":"skyphp"
}';

CREATE INDEX "media_item_idx" ON "public"."media_item"
  USING btree ("media_vfolder_id", "iorder", "views");

CREATE INDEX "media_item_idx1" ON "public"."media_item"
  USING btree ("id", "active");

CREATE TABLE "public"."media_item_comment" (
  "id" SERIAL, 
  "author__person_id" INTEGER, 
  "comment" VARCHAR, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "media_item_id" INTEGER, 
  CONSTRAINT "media_item_comment_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_item_comment"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."media_item_tag" (
  "id" SERIAL, 
  "name" VARCHAR, 
  "media_item_id" INTEGER, 
  "x" DOUBLE PRECISION, 
  "y" DOUBLE PRECISION, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  CONSTRAINT "media_item_tag_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_item_tag"
IS '{"codebase":"skyphp"}';

CREATE INDEX "media_item_tag_idx" ON "public"."media_item_tag"
  USING btree ("name");

CREATE TABLE "public"."media_overlay" (
  "id" SERIAL, 
  "name" VARCHAR(50), 
  "filename" VARCHAR(250), 
  "gravity" VARCHAR(10), 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "media_item_id" INTEGER, 
  "width" INTEGER, 
  "height" INTEGER, 
  "crop" VARCHAR, 
  CONSTRAINT "media_overlay_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_overlay"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."media_vfolder" (
  "id" SERIAL, 
  "vfolder_path" VARCHAR(200), 
  "name" VARCHAR(500), 
  "description" VARCHAR, 
  "album_date" DATE, 
  "venue_id" INTEGER, 
  "num_items" INTEGER DEFAULT 0 NOT NULL, 
  "num_vfolders" INTEGER DEFAULT 0 NOT NULL, 
  "parent__media_vfolder_id" INTEGER, 
  "tree" VARCHAR(250), 
  "access_group" VARCHAR(250), 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "quality" INTEGER, 
  CONSTRAINT "media_vfolder_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_vfolder"
IS '{"codebase":"skyphp"}';

CREATE INDEX "media_vfolder_idx" ON "public"."media_vfolder"
  USING btree ("parent__media_vfolder_id");

CREATE INDEX "media_vfolder_idx1" ON "public"."media_vfolder"
  USING btree ("id", "active");

CREATE UNIQUE INDEX "media_vfolder_path_idx" ON "public"."media_vfolder"
  USING btree ("vfolder_path");

CREATE TABLE "public"."media_zip" (
  "id" SERIAL, 
  "file_size" INTEGER, 
  "width" INTEGER, 
  "height" INTEGER, 
  "aspect_ratio" NUMERIC(6,3), 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "account_id" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "media_overlay_id" INTEGER, 
  "media_vfolder_id" INTEGER, 
  CONSTRAINT "media_zip_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."media_zip"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."phone" (
  "id" SERIAL, 
  "person_id" INTEGER NOT NULL, 
  "phone_number" VARCHAR(16), 
  "extension" VARCHAR(8), 
  "_phone_type" INTEGER DEFAULT 2, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__users_id" INTEGER, 
  "area_code" VARCHAR(3), 
  "account_id" INTEGER, 
  "exchange" VARCHAR(3), 
  "number" VARCHAR(4), 
  "digits" VARCHAR(15), 
  "phone_type" VARCHAR(20), 
  "mod__person_id" INTEGER, 
  "sms" SMALLINT, 
  "international" VARCHAR(20), 
  CONSTRAINT "phone_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."phone"
IS '{"codebase":"skyphp"}';

CREATE INDEX "phone_id_index" ON "public"."phone"
  USING btree ("id");

CREATE INDEX "phone_person_id_index" ON "public"."phone"
  USING btree ("person_id");

CREATE INDEX "phone_type_index" ON "public"."phone"
  USING btree ("_phone_type");

CREATE TABLE "public"."seo_keyword" (
  "id" SERIAL, 
  "website_id" INTEGER, 
  "market_id" INTEGER, 
  "keyword" VARCHAR(100), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "avg_traffic_index" NUMERIC(4,1), 
  "rank" INTEGER, 
  CONSTRAINT "seo_keyword_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."seo_keyword"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."seo_keyword_rank" (
  "id" SERIAL, 
  "website_id" INTEGER, 
  "search_engine" VARCHAR(25), 
  "keyword" VARCHAR(100), 
  "rank" INTEGER, 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  CONSTRAINT "seo_keyword_rank_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."seo_keyword_rank"
IS '{"codebase":"skyphp"}';


CREATE TABLE "public"."sessions2" (
  "sesskey" VARCHAR(64) DEFAULT ''::character varying NOT NULL, 
  "expiry" TIMESTAMP WITHOUT TIME ZONE NOT NULL, 
  "expireref" VARCHAR(250) DEFAULT ''::character varying, 
  "created" TIMESTAMP WITHOUT TIME ZONE NOT NULL, 
  "modified" TIMESTAMP WITHOUT TIME ZONE NOT NULL, 
  "sessdata" TEXT DEFAULT ''::text, 
  CONSTRAINT "sessions2_pkey" PRIMARY KEY("sesskey")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."sessions2"
IS '{"codebase":"skyphp"}';

CREATE INDEX "sess2_expireref" ON "public"."sessions2"
  USING btree ("expireref");

CREATE INDEX "sess2_expiry" ON "public"."sessions2"
  USING btree ("expiry");

CREATE TABLE "public"."tag" (
  "id" SERIAL, 
  "name" VARCHAR, 
  "url" VARCHAR, 
  "media_item_id" VARCHAR, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "insert_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "update_time" TIMESTAMP WITH TIME ZONE, 
  "mod__person_id" INTEGER, 
  CONSTRAINT "tag_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tag"
IS '{"codebase":"skyphp"}';

CREATE TABLE "public"."url" (
  "id" SERIAL, 
  "url" VARCHAR, 
  "count" INTEGER DEFAULT 0 NOT NULL, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  "mod_time" TIMESTAMP WITH TIME ZONE DEFAULT now(), 
  "mod__person_id" INTEGER, 
  "tinyid" VARCHAR, 
  "account_id" INTEGER, 
  CONSTRAINT "url_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."url"
IS '{"codebase":"skyphp"}';


CREATE TABLE "public"."website" (
  "id" SERIAL, 
  "name" VARCHAR(100), 
  "domain" VARCHAR(100), 
  "mod_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, 
  "mod__person_id" INTEGER, 
  "active" SMALLINT DEFAULT 1 NOT NULL, 
  CONSTRAINT "website_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."website"
IS '{"codebase":"skyphp"}';
Retrieved from "http://www.skyphp.org/doc/skyphp-0.1.4.sql"
Personal tools