2 -- SourceForge: Breaking Down the Barriers to Open Source Development
3 -- Copyright 1999-2001 (c) VA Linux Systems
4 -- http://sourceforge.net
6 -- $Id: replication-master.sql,v 1.7 2001/06/27 00:11:20 tperdue Exp $
9 COPY stats_site WITH OIDS TO '/home/tperdue/dumpfiles/stats_site.dump';
10 COPY stats_project WITH OIDS TO '/home/tperdue/dumpfiles/stats_project.dump';
11 COPY stats_project_developers WITH OIDS TO '/home/tperdue/dumpfiles/stats_project_developers.dump';
12 COPY stats_project_metric WITH OIDS TO '/home/tperdue/dumpfiles/stats_project_metric.dump';
13 COPY frs_dlstats_file_agg WITH OIDS TO '/home/tperdue/dumpfiles/frs_dlstats_file_agg.dump';
14 COPY stats_subd_pages WITH OIDS TO '/home/tperdue/dumpfiles/stats_subd_pages.dump';
15 COPY stats_agg_logo_by_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_agg_logo_by_group.dump';
16 COPY stats_cvs_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_cvs_group.dump';
17 COPY stats_agg_site_by_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_agg_site_by_group.dump';
18 COPY stats_site_pages_by_day WITH OIDS TO '/home/tperdue/dumpfiles/stats_site_pages_by_day.dump';
19 COPY frs_package WITH OIDS TO '/home/tperdue/dumpfiles/frs_package.dump';
20 COPY frs_release WITH OIDS TO '/home/tperdue/dumpfiles/frs_release.dump';
21 COPY frs_processor WITH OIDS TO '/home/tperdue/dumpfiles/frs_processor.dump';
22 COPY frs_filetype WITH OIDS TO '/home/tperdue/dumpfiles/frs_filetype.dump';
23 COPY frs_file WITH OIDS TO '/home/tperdue/dumpfiles/frs_file.dump';
24 COPY project_weekly_metric WITH OIDS TO '/home/tperdue/dumpfiles/project_weekly_metric.dump';
25 COPY trove_cat WITH OIDS TO '/home/tperdue/dumpfiles/trove_cat.dump';
26 COPY trove_group_link WITH OIDS TO '/home/tperdue/dumpfiles/trove_group_link.dump';
27 COPY users WITH OIDS TO '/home/tperdue/dumpfiles/users.dump';
28 COPY groups WITH OIDS TO '/home/tperdue/dumpfiles/groups.dump';
29 COPY foundry_projects WITH oids to '/home/tperdue/dumpfiles/foundry_projects.dump';
32 DROP INDEX frs_release_date;
33 DROP INDEX frs_file_name;
34 DROP INDEX frs_file_processor;
35 DROP INDEX frs_file_type;
36 DROP INDEX frs_release_by;
38 CREATE UNIQUE INDEX statssite_oid ON stats_site(oid);
39 CREATE UNIQUE INDEX statsproject_oid ON stats_project(oid);
40 CREATE UNIQUE INDEX statsprojectdevelop_oid ON stats_project_developers(oid);
41 CREATE UNIQUE INDEX statsprojectmetric_oid ON stats_project_metric(oid);
42 CREATE UNIQUE INDEX frsdlfileagg_oid ON frs_dlstats_file_agg(oid);
43 CREATE UNIQUE INDEX statssubdpages_oid ON stats_subd_pages(oid);
44 CREATE UNIQUE INDEX statsagglogobygrp_oid ON stats_agg_site_by_group(oid);
45 CREATE UNIQUE INDEX statscvsgrp_oid ON stats_cvs_group(oid);
46 CREATE UNIQUE INDEX statsaggsitebygrp_oid ON stats_agg_site_by_group(oid);
47 CREATE UNIQUE INDEX statssitepgsbyday_oid ON stats_site_pages_by_day(oid);
49 DROP TABLE frs_dlstats_filetotal_agg;
50 DROP TABLE frs_dlstats_grouptotal_agg;
51 DROP TABLE frs_dlstats_group_agg;
52 DROP TABLE stats_project_months;
53 DROP TABLE stats_project_all;
54 DROP TABLE stats_project_last_30;
55 DROP TABLE stats_project_developers_last30;
56 DROP TABLE stats_site_pages_by_month;
57 DROP TABLE stats_site_last_30;
58 DROP TABLE stats_site_months;
59 DROP TABLE stats_site_all;
61 DROP TABLE trove_treesums;
63 DROP TABLE foundry_project_rankings_agg;
64 DROP TABLE foundry_project_downloads_agg;