← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-40-05-0.sql

  • Committer: Canonical.com Patch Queue Manager
  • Date: 2005-11-23 14:52:26 UTC
  • mfrom: (2837.1.7 trivial)
  • Revision ID: pqm@pqm.ubuntu.com-20051123145226-49bd69d9e1090a55
[trivial] Renumber BranchDataStorage DB patch and db tweaks

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-40-05-0.sql
6
6
DELETE FROM ManifestEntry;
7
7
DELETE FROM ArchConfigEntry;
8
8
 
 
9
-- Drop some obsolete tables
 
10
DROP TABLE ChangesetFileHash;
 
11
DROP TABLE ChangesetFile;
 
12
DROP TABLE ChangesetFilename;
 
13
 
9
14
-- Remove everything. Will be repopulated.
10
15
DELETE FROM Changeset; 
11
16
DELETE FROM Branch;
180
185
DROP TABLE ArchArchiveLocationSigner;
181
186
DROP TABLE ArchArchiveLocation;
182
187
DROP TABLE ArchArchive;
183
 
DROP TABLE ChangesetFileHash;
184
 
DROP TABLE ChangesetFile;
185
 
DROP TABLE ChangesetFilename;
186
188
DROP TABLE ProductBkBranch;
187
189
 
188
190
-- Tidy up some foreign keys
201
203
    FOREIGN KEY (gpgkey) REFERENCES GPGKey;
202
204
 
203
205
-- Shazzham!
204
 
INSERT INTO LaunchpadDatabaseRevision VALUES (25, 99, 0);
 
206
INSERT INTO LaunchpadDatabaseRevision VALUES (40, 5, 0);