Author: lucas
Date: 2008-08-08 20:13:47 +0000 (Fri, 08 Aug 2008)
New Revision: 1016
Modified:
udd/src/setup-db.sql
Log:
remove DROPs from setup-db.sql
Modified: udd/src/setup-db.sql
===================================================================
--- udd/src/setup-db.sql 2008-08-08 20:05:06 UTC (rev 1015)
+++ udd/src/setup-db.sql 2008-08-08 20:13:47 UTC (rev 1016)
@@ -1,32 +1,3 @@
-DROP TABLE packages CASCADE;
-DROP TABLE ubuntu_packages CASCADE;
-DROP TABLE sources CASCADE;
-DROP TABLE ubuntu_sources CASCADE;
-DROP TABLE migrations CASCADE;
-DROP TABLE popcon CASCADE;
-DROP TABLE popcon_src_max CASCADE;
-DROP TABLE popcon_src_average CASCADE;
-DROP TABLE ubuntu_popcon CASCADE;
-DROP TABLE ubuntu_popcon_src_max CASCADE;
-DROP TABLE ubuntu_popcon_src_average CASCADE;
-DROP TABLE bugs_unarchived CASCADE;
-DROP TABLE bugs_archived CASCADE;
-DROP TABLE bug_merged_with CASCADE;
-DROP TABLE bug_user_tags CASCADE;
-DROP TABLE bug_found_in CASCADE;
-DROP TABLE bug_fixed_in CASCADE;
-DROP TABLE bug_tags CASCADE;
-DROP TABLE upload_history CASCADE;
-DROP VIEW bugs;
-DROP INDEX packages_source_idx;
-DROP INDEX sources_distribution_idx;
-DROP INDEX sources_release_idx;
-DROP INDEX sources_component_idx;
-DROP INDEX ubuntu_packages_source_idx;
-DROP INDEX ubuntu_sources_distribution_idx;
-DROP INDEX ubuntu_sources_release_idx;
-DROP INDEX ubuntu_sources_component_idx;
-
CREATE TABLE packages
(package text, version text, architecture text, maintainer text, description
text, source text, source_version text, essential text, depends text,
_______________________________________________
Collab-qa-commits mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/collab-qa-commits
