replication-slave.sql

GForge 3.0 协作开发平台 支持CVS, mailing lists, bug tracking, message boards/forums, task management, perman

--
--	SourceForge: Breaking Down the Barriers to Open Source Development
--	Copyright 1999-2001 (c) VA Linux Systems
--	http://sourceforge.net
--
--	$Id: replication-slave.sql,v 1.1 2003/01/01 00:57:41 cbayle Exp $	
--

CREATE TABLE "stats_site" (
        "month" integer,
        "day" integer,
        "uniq_users" integer,
        "sessions" integer,
        "total_users" integer,
        "new_users" integer,
        "new_projects" integer
);
CREATE UNIQUE INDEX "statssite_month_day" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );


CREATE TABLE "stats_project" (
        "month" integer DEFAULT 0 NOT NULL,
        "day" integer DEFAULT 0 NOT NULL,
        "group_id" integer DEFAULT 0 NOT NULL,
        "file_releases" integer DEFAULT 0,
        "msg_posted" integer DEFAULT 0,
        "msg_uniq_auth" integer DEFAULT 0,
        "bugs_opened" integer DEFAULT 0,
        "bugs_closed" integer DEFAULT 0,
        "support_opened" integer DEFAULT 0,
        "support_closed" integer DEFAULT 0,
        "patches_opened" integer DEFAULT 0,
        "patches_closed" integer DEFAULT 0,
        "artifacts_opened" integer DEFAULT 0,
        "artifacts_closed" integer DEFAULT 0,
        "tasks_opened" integer DEFAULT 0,
        "tasks_closed" integer DEFAULT 0,
        "help_requests" integer DEFAULT 0
);
CREATE UNIQUE INDEX "statsproject_month_day_group" on "stats_project" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_project_developers" (
        "month" integer DEFAULT 0 NOT NULL,
        "day" integer DEFAULT 0 NOT NULL,
        "group_id" integer DEFAULT 0 NOT NULL,
        "developers" integer DEFAULT 0 NOT NULL
);
CREATE UNIQUE INDEX "statsprojectdev_month_day_group" on "stats_project_developers" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_project_metric" (
        "month" integer DEFAULT 0 NOT NULL,
        "day" integer DEFAULT 0 NOT NULL,
        "ranking" integer DEFAULT 0 NOT NULL,
        "percentile" double precision DEFAULT 0 NOT NULL,
        "group_id" integer DEFAULT 0 NOT NULL
);
CREATE UNIQUE INDEX "statsprojectmetric_month_day_gr" on "stats_project_metric" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "frs_dlstats_file_agg" (
        "month" integer,
        "day" integer,
        "file_id" integer,
        "downloads" integer
);
CREATE UNIQUE INDEX "frsdlfileagg_month_day_file" on "frs_dlstats_file_agg" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "file_id" "int4_ops" );


CREATE TABLE "stats_subd_pages" (
        "month" integer DEFAULT 0 NOT NULL,
        "day" integer DEFAULT 0 NOT NULL,
        "group_id" integer DEFAULT 0 NOT NULL,
        "pages" integer DEFAULT 0 NOT NULL
);
CREATE UNIQUE INDEX "statssubdpages_month_day_group" on "stats_subd_pages" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_agg_logo_by_group" (
        "month" integer,
        "day" integer,
        "group_id" integer,
        "count" integer
);
CREATE UNIQUE INDEX "statslogobygroup_month_day_grou" on "stats_agg_logo_by_group" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_cvs_group" (
        "month" integer DEFAULT 0 NOT NULL,
        "day" integer DEFAULT 0 NOT NULL,
        "group_id" integer DEFAULT 0 NOT NULL,
        "checkouts" integer DEFAULT 0 NOT NULL,
        "commits" integer DEFAULT 0 NOT NULL,
        "adds" integer DEFAULT 0 NOT NULL
);
CREATE UNIQUE INDEX "statscvsgroup_month_day_group" on "stats_cvs_group" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_agg_site_by_group" (
        "month" integer,
        "day" integer,
        "group_id" integer,
        "count" integer
);
CREATE UNIQUE INDEX "statssitebygroup_month_day_grou" on "stats_agg_site_by_group" 
	using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );


CREATE TABLE "stats_site_pages_by_day" (
        "month" integer,
        "day" integer,
        "site_page_views" integer
);
CREATE  INDEX "statssitepagesbyday_month_day" on "stats_site_pages_by_day" 
	using btree ( "month" "int4_ops", "day" "int4_ops" );


CREATE TABLE "frs_package" (
        "package_id" integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
        "group_id" integer DEFAULT '0' NOT NULL,
        "name" text,
        "status_id" integer DEFAULT '0' NOT NULL,
        Constraint "frs_package_pkey" Primary Key ("package_id")
);
CREATE  INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );


CREATE TABLE "frs_release" (
        "release_id" integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
        "package_id" integer DEFAULT '0' NOT NULL,
        "name" text,
        "notes" text,
        "changes" text,
        "status_id" integer DEFAULT '0' NOT NULL,
        "preformatted" integer DEFAULT '0' NOT NULL,
        "release_date" integer DEFAULT '0' NOT NULL,
        "released_by" integer DEFAULT '0' NOT NULL,
        Constraint "frs_release_pkey" Primary Key ("release_id")
);
CREATE  INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );


CREATE TABLE "frs_file" (
        "file_id" integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
        "filename" text,
        "release_id" integer DEFAULT '0' NOT NULL,
        "type_id" integer DEFAULT '0' NOT NULL,
        "processor_id" integer DEFAULT '0' NOT NULL,
        "release_time" integer DEFAULT '0' NOT NULL,
        "file_size" integer DEFAULT '0' NOT NULL,
        "post_date" integer DEFAULT '0' NOT NULL,
        Constraint "frs_file_pkey" Primary Key ("file_id")
);
CREATE  INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
CREATE  INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );


CREATE TABLE "users" (
        "user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
        "user_name" text DEFAULT '' NOT NULL,
        "email" text DEFAULT '' NOT NULL,
        "user_pw" character varying(32) DEFAULT '' NOT NULL,
        "realname" character varying(32) DEFAULT '' NOT NULL,
        "status" character(1) DEFAULT 'A' NOT NULL,
        "shell" character varying(20) DEFAULT '/bin/bash' NOT NULL,
        "unix_pw" character varying(40) DEFAULT '' NOT NULL,
        "unix_status" character(1) DEFAULT 'N' NOT NULL,