sourceforge_2_5.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 1,286 行 · 第 1/5 页

);
CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_group_list" (
	"group_project_id" integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"project_name" text DEFAULT '' NOT NULL,
	"is_public" integer DEFAULT '0' NOT NULL,
	"description" text,
	PRIMARY KEY ("group_project_id")
);
CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_history" (
	"project_history_id" integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
	"project_task_id" integer DEFAULT '0' NOT NULL,
	"field_name" text DEFAULT '' NOT NULL,
	"old_value" text DEFAULT '' NOT NULL,
	"mod_by" integer DEFAULT '0' NOT NULL,
	"date" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("project_history_id")
);
CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_metric" (
	"ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
	"percentile" double precision,
	"group_id" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("ranking")
);
CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_metric_tmp1" (
	"ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"value" double precision,
	PRIMARY KEY ("ranking")
);
CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_metric_weekly_tmp1" (
	"ranking" integer DEFAULT nextval('project_metric_weekly_tm_pk_seq'::text) NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"value" double precision,
	PRIMARY KEY ("ranking")
);
CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_status" (
	"status_id" integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
	"status_name" text DEFAULT '' NOT NULL,
	PRIMARY KEY ("status_id")
);
CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_task" (
	"project_task_id" integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
	"group_project_id" integer DEFAULT '0' NOT NULL,
	"summary" text DEFAULT '' NOT NULL,
	"details" text DEFAULT '' NOT NULL,
	"percent_complete" integer DEFAULT '0' NOT NULL,
	"priority" integer DEFAULT '0' NOT NULL,
	"hours" double precision DEFAULT '0.00' NOT NULL,
	"start_date" integer DEFAULT '0' NOT NULL,
	"end_date" integer DEFAULT '0' NOT NULL,
	"created_by" integer DEFAULT '0' NOT NULL,
	"status_id" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("project_task_id")
);
CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "project_weekly_metric" (
	"ranking" integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
	"percentile" double precision,
	"group_id" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("ranking")
);
CREATE TABLE "session" (
	"user_id" integer DEFAULT '0' NOT NULL,
	"session_hash" character(32) DEFAULT '' NOT NULL,
	"ip_addr" character(15) DEFAULT '' NOT NULL,
	"time" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("session_hash")
);
CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "snippet" (
	"snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
	"created_by" integer DEFAULT '0' NOT NULL,
	"name" text,
	"description" text,
	"type" integer DEFAULT '0' NOT NULL,
	"language" integer DEFAULT '0' NOT NULL,
	"license" text DEFAULT '' NOT NULL,
	"category" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("snippet_id")
);
CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "snippet_package" (
	"snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
	"created_by" integer DEFAULT '0' NOT NULL,
	"name" text,
	"description" text,
	"category" integer DEFAULT '0' NOT NULL,
	"language" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("snippet_package_id")
);
CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "snippet_package_item" (
	"snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
	"snippet_package_version_id" integer DEFAULT '0' NOT NULL,
	"snippet_version_id" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("snippet_package_item_id")
);
CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "snippet_package_version" (
	"snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
	"snippet_package_id" integer DEFAULT '0' NOT NULL,
	"changes" text,
	"version" text,
	"submitted_by" integer DEFAULT '0' NOT NULL,
	"date" integer DEFAULT '0' NOT NULL,
	PRIMARY KEY ("snippet_package_version_id")
);
CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "snippet_version" (
	"snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
	"snippet_id" integer DEFAULT '0' NOT NULL,
	"changes" text,
	"version" text,
	"submitted_by" integer DEFAULT '0' NOT NULL,
	"date" integer DEFAULT '0' NOT NULL,
	"code" text,
	PRIMARY KEY ("snippet_version_id")
);
CREATE TABLE "stats_agg_logo_by_day" (
	"day" integer,
	"count" integer
);
CREATE TABLE "stats_agg_logo_by_group" (
	"day" integer,
	"group_id" integer,
	"count" integer
);
CREATE TABLE "stats_agg_pages_by_browser" (
	"browser" character varying(8),
	"count" integer
);
CREATE TABLE "stats_agg_pages_by_day" (
	"day" integer DEFAULT '0' NOT NULL,
	"count" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_agg_pages_by_day_old" (
	"day" integer,
	"count" integer
);
CREATE TABLE "stats_agg_site_by_day" (
	"day" integer DEFAULT '0' NOT NULL,
	"count" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_agg_site_by_group" (
	"day" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"count" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_agr_filerelease" (
	"filerelease_id" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_agr_project" (
	"group_id" integer DEFAULT '0' NOT NULL,
	"group_ranking" integer DEFAULT '0' NOT NULL,
	"group_metric" double precision DEFAULT '0.00000' NOT NULL,
	"developers" integer DEFAULT '0' NOT NULL,
	"file_releases" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL,
	"site_views" integer DEFAULT '0' NOT NULL,
	"logo_views" integer DEFAULT '0' NOT NULL,
	"msg_posted" integer DEFAULT '0' NOT NULL,
	"msg_uniq_auth" integer DEFAULT '0' NOT NULL,
	"bugs_opened" integer DEFAULT '0' NOT NULL,
	"bugs_closed" integer DEFAULT '0' NOT NULL,
	"support_opened" integer DEFAULT '0' NOT NULL,
	"support_closed" integer DEFAULT '0' NOT NULL,
	"patches_opened" integer DEFAULT '0' NOT NULL,
	"patches_closed" integer DEFAULT '0' NOT NULL,
	"tasks_opened" integer DEFAULT '0' NOT NULL,
	"tasks_closed" integer DEFAULT '0' NOT NULL,
	"help_requests" integer DEFAULT '0' NOT NULL,
	"cvs_checkouts" integer DEFAULT '0' NOT NULL,
	"cvs_commits" integer DEFAULT '0' NOT NULL,
	"cvs_adds" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_ftp_downloads" (
	"day" integer DEFAULT '0' NOT NULL,
	"filerelease_id" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_http_downloads" (
	"day" integer DEFAULT '0' NOT NULL,
	"filerelease_id" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_project" (
	"month" integer DEFAULT '0' NOT NULL,
	"week" integer DEFAULT '0' NOT NULL,
	"day" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"group_ranking" integer DEFAULT '0' NOT NULL,
	"group_metric" double precision DEFAULT '0.00000' NOT NULL,
	"developers" integer DEFAULT '0' NOT NULL,
	"file_releases" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL,
	"site_views" integer DEFAULT '0' NOT NULL,
	"subdomain_views" integer DEFAULT '0' NOT NULL,
	"msg_posted" integer DEFAULT '0' NOT NULL,
	"msg_uniq_auth" integer DEFAULT '0' NOT NULL,
	"bugs_opened" integer DEFAULT '0' NOT NULL,
	"bugs_closed" integer DEFAULT '0' NOT NULL,
	"support_opened" integer DEFAULT '0' NOT NULL,
	"support_closed" integer DEFAULT '0' NOT NULL,
	"patches_opened" integer DEFAULT '0' NOT NULL,
	"patches_closed" integer DEFAULT '0' NOT NULL,
	"tasks_opened" integer DEFAULT '0' NOT NULL,
	"tasks_closed" integer DEFAULT '0' NOT NULL,
	"help_requests" integer DEFAULT '0' NOT NULL,
	"cvs_checkouts" integer DEFAULT '0' NOT NULL,
	"cvs_commits" integer DEFAULT '0' NOT NULL,
	"cvs_adds" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_project_tmp" (
	"month" integer DEFAULT '0' NOT NULL,
	"week" integer DEFAULT '0' NOT NULL,
	"day" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"group_ranking" integer DEFAULT '0' NOT NULL,
	"group_metric" double precision DEFAULT '0.00000' NOT NULL,
	"developers" integer DEFAULT '0' NOT NULL,
	"file_releases" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL,
	"site_views" integer DEFAULT '0' NOT NULL,
	"subdomain_views" integer DEFAULT '0' NOT NULL,
	"msg_posted" integer DEFAULT '0' NOT NULL,
	"msg_uniq_auth" integer DEFAULT '0' NOT NULL,
	"bugs_opened" integer DEFAULT '0' NOT NULL,
	"bugs_closed" integer DEFAULT '0' NOT NULL,
	"support_opened" integer DEFAULT '0' NOT NULL,
	"support_closed" integer DEFAULT '0' NOT NULL,
	"patches_opened" integer DEFAULT '0' NOT NULL,
	"patches_closed" integer DEFAULT '0' NOT NULL,
	"tasks_opened" integer DEFAULT '0' NOT NULL,
	"tasks_closed" integer DEFAULT '0' NOT NULL,
	"help_requests" integer DEFAULT '0' NOT NULL,
	"cvs_checkouts" integer DEFAULT '0' NOT NULL,
	"cvs_commits" integer DEFAULT '0' NOT NULL,
	"cvs_adds" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "stats_site" (
	"month" integer DEFAULT '0' NOT NULL,
	"week" integer DEFAULT '0' NOT NULL,
	"day" integer DEFAULT '0' NOT NULL,
	"site_views" integer DEFAULT '0' NOT NULL,
	"subdomain_views" integer DEFAULT '0' NOT NULL,
	"downloads" integer DEFAULT '0' NOT NULL,