diff options
Diffstat (limited to 'db/migrate')
26 files changed, 0 insertions, 418 deletions
diff --git a/db/migrate/20090314092539_create_users.rb b/db/migrate/20090314092539_create_users.rb deleted file mode 100644 index c7eff5f..0000000 --- a/db/migrate/20090314092539_create_users.rb +++ /dev/null @@ -1,21 +0,0 @@ -class CreateUsers < ActiveRecord::Migration - def self.up - create_table :users do |t| - t.string :login - t.string :name - t.string :email - t.boolean :disabled, :default => false - t.boolean :jefe, :default => false - t.text :preferences - t.integer :access - t.timestamps - end - - add_index :users, :login, :unique => true - end - - def self.down - remove_index :users, :column => :login - drop_table :users - end -end diff --git a/db/migrate/20090314191650_create_glsas.rb b/db/migrate/20090314191650_create_glsas.rb deleted file mode 100644 index fd88029..0000000 --- a/db/migrate/20090314191650_create_glsas.rb +++ /dev/null @@ -1,22 +0,0 @@ -class CreateGlsas < ActiveRecord::Migration - def self.up - create_table :glsas do |t| - t.string :glsa_id - t.integer :requester - t.integer :submitter - t.integer :bugreadymaker - t.string :status - t.boolean :restricted, :default => false - t.timestamps - end - - add_index :glsas, :glsa_id, :unique => true - add_index :glsas, :status - end - - def self.down - remove_index :glsas, :status - remove_index :glsas, :glsa_id - drop_table :glsas - end -end diff --git a/db/migrate/20090314194257_add_glsa_user_constraints.rb b/db/migrate/20090314194257_add_glsa_user_constraints.rb deleted file mode 100644 index 51c35ac..0000000 --- a/db/migrate/20090314194257_add_glsa_user_constraints.rb +++ /dev/null @@ -1,13 +0,0 @@ -class AddGlsaUserConstraints < ActiveRecord::Migration - def self.up - execute "ALTER TABLE glsas ADD CONSTRAINT glsas_users_requesters FOREIGN KEY (requester) REFERENCES users (id)" - execute "ALTER TABLE glsas ADD CONSTRAINT glsas_users_submitters FOREIGN KEY (submitter) REFERENCES users (id)" - execute "ALTER TABLE glsas ADD CONSTRAINT glsas_users_bugreadymakers FOREIGN KEY (bugreadymaker) REFERENCES users (id)" - end - - def self.down - execute "ALTER TABLE glsas DROP FOREIGN KEY glsas_users_requesters" - execute "ALTER TABLE glsas DROP FOREIGN KEY glsas_users_submitters" - execute "ALTER TABLE glsas DROP FOREIGN KEY glsas_users_bugreadymakers" - end -end diff --git a/db/migrate/20090314194659_create_revisions.rb b/db/migrate/20090314194659_create_revisions.rb deleted file mode 100644 index dbea6ba..0000000 --- a/db/migrate/20090314194659_create_revisions.rb +++ /dev/null @@ -1,32 +0,0 @@ -class CreateRevisions < ActiveRecord::Migration - def self.up - create_table :revisions do |t| - t.integer :glsa_id - t.integer :revid - t.string :title - t.string :access, :default => "remote" - t.string :product - t.string :category - t.string :severity, :default => "normal" - t.text :synopsis - t.text :background - t.text :description - t.text :impact - t.text :workaround - t.text :resolution - t.timestamps - end - - add_index :revisions, :glsa_id - add_index :revisions, :revid - add_index :revisions, :title - end - - def self.down - remove_index :revisions, :synopsis - remove_index :revisions, :title - remove_index :revisions, :revid - remove_index :revisions, :glsa_id - drop_table :revisions - end -end diff --git a/db/migrate/20090314230516_create_references.rb b/db/migrate/20090314230516_create_references.rb deleted file mode 100644 index c7fff76..0000000 --- a/db/migrate/20090314230516_create_references.rb +++ /dev/null @@ -1,18 +0,0 @@ -class CreateReferences < ActiveRecord::Migration - def self.up - create_table :references do |t| - t.integer :revision_id - t.text :title - t.text :url - t.string :type - t.timestamps - end - - add_index :references, :revision_id - end - - def self.down - remove_index :references, :revision_id - drop_table :references - end -end diff --git a/db/migrate/20090315105049_create_bugs.rb b/db/migrate/20090315105049_create_bugs.rb deleted file mode 100644 index 21d6641..0000000 --- a/db/migrate/20090315105049_create_bugs.rb +++ /dev/null @@ -1,19 +0,0 @@ -class CreateBugs < ActiveRecord::Migration - def self.up - create_table :bugs do |t| - t.integer :bug_id - t.text :title - t.integer :revision_id - t.timestamps - end - - add_index :bugs, :revision_id - add_index :bugs, :bug_id - end - - def self.down - remove_index :bugs, :column => :revision_id - remove_index :bugs, :column => :bug_id - drop_table :bugs - end -end diff --git a/db/migrate/20090315105326_add_references_revisions_constraint.rb b/db/migrate/20090315105326_add_references_revisions_constraint.rb deleted file mode 100644 index 1fa4800..0000000 --- a/db/migrate/20090315105326_add_references_revisions_constraint.rb +++ /dev/null @@ -1,9 +0,0 @@ -class AddReferencesRevisionsConstraint < ActiveRecord::Migration - def self.up - execute "ALTER TABLE `references` ADD CONSTRAINT references_revisions_revisionid FOREIGN KEY (revision_id) REFERENCES revisions (id)" - end - - def self.down - execute "ALTER TABLE `references` DROP FOREIGN KEY references_revisions_revisionid" - end -end diff --git a/db/migrate/20090315110025_create_comments.rb b/db/migrate/20090315110025_create_comments.rb deleted file mode 100644 index bebb968..0000000 --- a/db/migrate/20090315110025_create_comments.rb +++ /dev/null @@ -1,18 +0,0 @@ -class CreateComments < ActiveRecord::Migration - def self.up - create_table :comments do |t| - t.integer :user_id - t.integer :glsa_id - t.text :text - t.string :type - t.boolean :read, :default => false - t.timestamps - end - - add_index :comments, :glsa_id - end - - def self.down - drop_table :comments - end -end diff --git a/db/migrate/20090315110119_add_comment_constraints.rb b/db/migrate/20090315110119_add_comment_constraints.rb deleted file mode 100644 index 49eabd4..0000000 --- a/db/migrate/20090315110119_add_comment_constraints.rb +++ /dev/null @@ -1,11 +0,0 @@ -class AddCommentConstraints < ActiveRecord::Migration - def self.up - execute "ALTER TABLE comments ADD CONSTRAINT comments_users_userid FOREIGN KEY (user_id) REFERENCES users (id)" - execute "ALTER TABLE comments ADD CONSTRAINT comments_glsas_glsaid FOREIGN KEY (glsa_id) REFERENCES glsas (id)" - end - - def self.down - execute "ALTER TABLE comments DROP FOREIGN KEY comments_users_userid" - execute "ALTER TABLE comments DROP FOREIGN KEY comments_glsas_glsaid" - end -end diff --git a/db/migrate/20090410212514_add_user_id_to_revisions.rb b/db/migrate/20090410212514_add_user_id_to_revisions.rb deleted file mode 100644 index f6c0254..0000000 --- a/db/migrate/20090410212514_add_user_id_to_revisions.rb +++ /dev/null @@ -1,9 +0,0 @@ -class AddUserIdToRevisions < ActiveRecord::Migration - def self.up - add_column :revisions, :user_id, :integer - end - - def self.down - remove_column :revisions, :user_id - end -end diff --git a/db/migrate/20090410212600_add_revisions_user_id_constraint.rb b/db/migrate/20090410212600_add_revisions_user_id_constraint.rb deleted file mode 100644 index 18597cb..0000000 --- a/db/migrate/20090410212600_add_revisions_user_id_constraint.rb +++ /dev/null @@ -1,9 +0,0 @@ -class AddRevisionsUserIdConstraint < ActiveRecord::Migration - def self.up - execute "ALTER TABLE `revisions` ADD CONSTRAINT revisions_user_userid FOREIGN KEY (user_id) REFERENCES users (id)" - end - - def self.down - execute "ALTER TABLE `revisions` DROP FOREIGN KEY revisions_user_userid" - end -end diff --git a/db/migrate/20090419140216_create_sessions.rb b/db/migrate/20090419140216_create_sessions.rb deleted file mode 100644 index 4ccc353..0000000 --- a/db/migrate/20090419140216_create_sessions.rb +++ /dev/null @@ -1,16 +0,0 @@ -class CreateSessions < ActiveRecord::Migration - def self.up - create_table :sessions do |t| - t.string :session_id, :null => false - t.text :data - t.timestamps - end - - add_index :sessions, :session_id - add_index :sessions, :updated_at - end - - def self.down - drop_table :sessions - end -end diff --git a/db/migrate/20090501114107_add_status_cache_to_bugs.rb b/db/migrate/20090501114107_add_status_cache_to_bugs.rb deleted file mode 100644 index 1600049..0000000 --- a/db/migrate/20090501114107_add_status_cache_to_bugs.rb +++ /dev/null @@ -1,11 +0,0 @@ -class AddStatusCacheToBugs < ActiveRecord::Migration - def self.up - add_column :bugs, :whiteboard, :string - add_column :bugs, :arches, :string - end - - def self.down - remove_column :bugs, :arches - remove_column :bugs, :whiteboard - end -end diff --git a/db/migrate/20100511192546_change_comment_type_to_rating.rb b/db/migrate/20100511192546_change_comment_type_to_rating.rb deleted file mode 100644 index c3ab83a..0000000 --- a/db/migrate/20100511192546_change_comment_type_to_rating.rb +++ /dev/null @@ -1,9 +0,0 @@ -class ChangeCommentTypeToRating < ActiveRecord::Migration - def self.up - rename_column :comments, :type, :rating - end - - def self.down - rename_column :comments, :rating, :type - end -end diff --git a/db/migrate/20100513183324_create_packages.rb b/db/migrate/20100513183324_create_packages.rb deleted file mode 100644 index 11ed193..0000000 --- a/db/migrate/20100513183324_create_packages.rb +++ /dev/null @@ -1,21 +0,0 @@ -class CreatePackages < ActiveRecord::Migration - def self.up - create_table :packages do |t| - t.integer :revision_id - t.string :my_type - t.string :atom - t.string :version - t.string :comp - t.string :arch - t.boolean :automatic, :default => true - t.timestamps - end - - add_index :packages, :revision_id - end - - def self.down - remove_index :packages, :column => :revision_id - drop_table :packages - end -end diff --git a/db/migrate/20100813183543_create_cves.rb b/db/migrate/20100813183543_create_cves.rb deleted file mode 100644 index 473e165..0000000 --- a/db/migrate/20100813183543_create_cves.rb +++ /dev/null @@ -1,19 +0,0 @@ -class CreateCves < ActiveRecord::Migration - def self.up - create_table :cves do |t| - t.string :cve_id - t.text :summary - t.string :cvss - t.string :state - t.datetime :published_at - t.datetime :last_changed_at - t.timestamps - end - - add_index :cves, :cve_id, :unique => true - end - - def self.down - drop_table :cves - end -end diff --git a/db/migrate/20100814103856_create_cve_references.rb b/db/migrate/20100814103856_create_cve_references.rb deleted file mode 100644 index ef3ef9b..0000000 --- a/db/migrate/20100814103856_create_cve_references.rb +++ /dev/null @@ -1,19 +0,0 @@ -class CreateCveReferences < ActiveRecord::Migration - def self.up - create_table :cve_references do |t| - t.string :source - t.text :title - t.text :uri - t.integer :cve_id - t.timestamps - end - - add_index :cve_references, :cve_id - execute "ALTER TABLE cve_references ADD CONSTRAINT cve_references_cve_id FOREIGN KEY (cve_id) REFERENCES cves (id)" - end - - def self.down - execute "ALTER TABLE cve_references DROP FOREIGN KEY cve_references_cve_id" - drop_table :cve_references - end -end diff --git a/db/migrate/20100814105152_create_cve_comments.rb b/db/migrate/20100814105152_create_cve_comments.rb deleted file mode 100644 index 73b1424..0000000 --- a/db/migrate/20100814105152_create_cve_comments.rb +++ /dev/null @@ -1,21 +0,0 @@ -class CreateCveComments < ActiveRecord::Migration - def self.up - create_table :cve_comments do |t| - t.integer :cve_id - t.integer :user_id - t.boolean :confidential, :default => false - t.text :comment - t.timestamps - end - - add_index :cve_comments, :cve_id - execute "ALTER TABLE cve_comments ADD CONSTRAINT cve_comments_cve_id FOREIGN KEY (cve_id) REFERENCES cves (id)" - execute "ALTER TABLE cve_comments ADD CONSTRAINT cve_comments_user_id FOREIGN KEY (user_id) REFERENCES users (id)" - end - - def self.down - execute "ALTER TABLE cve_comments DROP FOREIGN KEY cve_comments_cve_id" - execute "ALTER TABLE cve_comments DROP FOREIGN KEY cve_comments_user_id" - drop_table :cve_comments - end -end diff --git a/db/migrate/20100814105345_create_cve_changes.rb b/db/migrate/20100814105345_create_cve_changes.rb deleted file mode 100644 index 80e7db9..0000000 --- a/db/migrate/20100814105345_create_cve_changes.rb +++ /dev/null @@ -1,20 +0,0 @@ -class CreateCveChanges < ActiveRecord::Migration - def self.up - create_table :cve_changes do |t| - t.integer :cve_id - t.integer :user_id - t.string :action - t.string :object - t.timestamps - end - - execute "ALTER TABLE cve_changes ADD CONSTRAINT cve_changes_cve_id FOREIGN KEY (cve_id) REFERENCES cves (id)" - execute "ALTER TABLE cve_changes ADD CONSTRAINT cve_changes_user_id FOREIGN KEY (user_id) REFERENCES users (id)" - end - - def self.down - execute "ALTER TABLE cve_changes DROP FOREIGN KEY cve_changes_cve_id" - execute "ALTER TABLE cve_changes DROP FOREIGN KEY cve_changes_user_id" - drop_table :cve_changes - end -end diff --git a/db/migrate/20100814142647_create_cpes.rb b/db/migrate/20100814142647_create_cpes.rb deleted file mode 100644 index 439360a..0000000 --- a/db/migrate/20100814142647_create_cpes.rb +++ /dev/null @@ -1,27 +0,0 @@ -class CreateCpes < ActiveRecord::Migration - def self.up - create_table :cpes do |t| - t.string :cpe - t.timestamps - end - - create_table :cpes_cves, :id => false do |t| - t.integer :cpe_id - t.integer :cve_id - t.timestamps - end - - add_index :cpes_cves, [:cve_id, :cpe_id] - add_index :cpes, :cpe, :unique => true - - execute "ALTER TABLE cpes_cves ADD CONSTRAINT cpes_cves_cpe_id FOREIGN KEY (cpe_id) REFERENCES cpes (id)" - execute "ALTER TABLE cpes_cves ADD CONSTRAINT cpes_cves_cve_id FOREIGN KEY (cve_id) REFERENCES cves (id)" - end - - def self.down - execute "ALTER TABLE cpes_cves DROP FOREIGN KEY cpes_cves_cpe_id" - execute "ALTER TABLE cpes_cves DROP FOREIGN KEY cpes_cves_cve_id" - drop_table :cpes_cves - drop_table :cpes - end -end diff --git a/db/migrate/20100902093457_create_cve_assignments.rb b/db/migrate/20100902093457_create_cve_assignments.rb deleted file mode 100644 index 0950574..0000000 --- a/db/migrate/20100902093457_create_cve_assignments.rb +++ /dev/null @@ -1,23 +0,0 @@ -class CreateCveAssignments < ActiveRecord::Migration - def self.up - create_table :cve_assignments do |t| - t.integer :cve_id - t.integer :bug - t.timestamps - end - - add_index :cve_assignments, :cve_id - add_index :cve_assignments, :bug - - execute "ALTER TABLE cve_assignments ADD CONSTRAINT cve_assignments_cve_id FOREIGN KEY (cve_id) REFERENCES cves (id)" - end - - def self.down - execute "ALTER TABLE cve_assignments DROP FOREIGN KEY cve_assignments_cve_id" - - remove_index :cve_assignments, :bug - remove_index :cve_assignments, :cve_id - - drop_table :cve_assignments - end -end diff --git a/db/migrate/20100918223549_add_system_user.rb b/db/migrate/20100918223549_add_system_user.rb deleted file mode 100644 index b6058c9..0000000 --- a/db/migrate/20100918223549_add_system_user.rb +++ /dev/null @@ -1,12 +0,0 @@ -class AddSystemUser < ActiveRecord::Migration - def self.up - execute "INSERT INTO users (id, login, name, email, access, disabled, jefe) VALUES" + - "(1, 'system', 'Sytem Account', 'glsamaker@gentoo.org', 0, 0, 0)" - execute "UPDATE users SET id = 0 WHERE id = 1" - execute "ALTER TABLE users AUTO_INCREMENT = 1" - end - - def self.down - execute "DELETE FROM users WHERE id = 0" - end -end diff --git a/db/migrate/20110226204724_add_release_flag_to_revisions.rb b/db/migrate/20110226204724_add_release_flag_to_revisions.rb deleted file mode 100644 index 43d0b6d..0000000 --- a/db/migrate/20110226204724_add_release_flag_to_revisions.rb +++ /dev/null @@ -1,11 +0,0 @@ -class AddReleaseFlagToRevisions < ActiveRecord::Migration - def self.up - add_column :revisions, :is_release, :boolean, :default => false - add_column :revisions, :release_revision, :integer - end - - def self.down - remove_column :revisions, :release_revision - remove_column :revisions, :is_release - end -end diff --git a/db/migrate/20110827143514_create_templates.rb b/db/migrate/20110827143514_create_templates.rb deleted file mode 100644 index ef9729a..0000000 --- a/db/migrate/20110827143514_create_templates.rb +++ /dev/null @@ -1,12 +0,0 @@ -class CreateTemplates < ActiveRecord::Migration - def change - create_table :templates do |t| - t.string :name - t.text :text - t.string :target - t.boolean :enabled, :default => true - - t.timestamps - end - end -end diff --git a/db/migrate/20110829174909_add_first_release_date_to_glsa.rb b/db/migrate/20110829174909_add_first_release_date_to_glsa.rb deleted file mode 100644 index 74fb219..0000000 --- a/db/migrate/20110829174909_add_first_release_date_to_glsa.rb +++ /dev/null @@ -1,5 +0,0 @@ -class AddFirstReleaseDateToGlsa < ActiveRecord::Migration - def change - add_column :glsas, :first_released_at, :datetime - end -end diff --git a/db/migrate/20170418102638_add_slots_to_packages.rb b/db/migrate/20170418102638_add_slots_to_packages.rb deleted file mode 100644 index 73e21e9..0000000 --- a/db/migrate/20170418102638_add_slots_to_packages.rb +++ /dev/null @@ -1,11 +0,0 @@ -class AddSlotsToPackages < ActiveRecord::Migration - def change - add_column :packages, :slot, :string - Package.find_each do |package| - if package.slot.nil? - package.slot = '*' - package.save! - end - end - end -end |