diff options
Diffstat (limited to 'db')
28 files changed, 0 insertions, 664 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 diff --git a/db/schema.rb b/db/schema.rb deleted file mode 100644 index 1d2a6e1..0000000 --- a/db/schema.rb +++ /dev/null @@ -1,239 +0,0 @@ -# encoding: UTF-8 -# This file is auto-generated from the current state of the database. Instead -# of editing this file, please use the migrations feature of Active Record to -# incrementally modify your database, and then regenerate this schema definition. -# -# Note that this schema.rb definition is the authoritative source for your -# database schema. If you need to create the application database on another -# system, you should be using db:schema:load, not running all the migrations -# from scratch. The latter is a flawed and unsustainable approach (the more migrations -# you'll amass, the slower it'll run and the greater likelihood for issues). -# -# It's strongly recommended that you check this file into your version control system. - -ActiveRecord::Schema.define(version: 20170418102638) do - - create_table "bugs", force: :cascade do |t| - t.integer "bug_id", limit: 4 - t.text "title", limit: 65535 - t.integer "revision_id", limit: 4 - t.datetime "created_at" - t.datetime "updated_at" - t.string "whiteboard", limit: 255 - t.string "arches", limit: 255 - end - - add_index "bugs", ["bug_id"], name: "index_bugs_on_bug_id", using: :btree - add_index "bugs", ["revision_id"], name: "index_bugs_on_revision_id", using: :btree - - create_table "comments", force: :cascade do |t| - t.integer "user_id", limit: 4 - t.integer "glsa_id", limit: 4 - t.text "text", limit: 65535 - t.string "rating", limit: 255 - t.boolean "read", limit: 1, default: false - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "comments", ["glsa_id"], name: "index_comments_on_glsa_id", using: :btree - add_index "comments", ["user_id"], name: "comments_users_userid", using: :btree - - create_table "cpes", force: :cascade do |t| - t.string "cpe", limit: 255 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cpes", ["cpe"], name: "index_cpes_on_cpe", unique: true, using: :btree - - create_table "cpes_cves", id: false, force: :cascade do |t| - t.integer "cpe_id", limit: 4 - t.integer "cve_id", limit: 4 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cpes_cves", ["cpe_id"], name: "cpes_cves_cpe_id", using: :btree - add_index "cpes_cves", ["cve_id", "cpe_id"], name: "index_cpes_cves_on_cve_id_and_cpe_id", using: :btree - - create_table "cve_assignments", force: :cascade do |t| - t.integer "cve_id", limit: 4 - t.integer "bug", limit: 4 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cve_assignments", ["bug"], name: "index_cve_assignments_on_bug", using: :btree - add_index "cve_assignments", ["cve_id"], name: "index_cve_assignments_on_cve_id", using: :btree - - create_table "cve_changes", force: :cascade do |t| - t.integer "cve_id", limit: 4 - t.integer "user_id", limit: 4 - t.string "action", limit: 255 - t.string "object", limit: 255 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cve_changes", ["cve_id"], name: "cve_changes_cve_id", using: :btree - add_index "cve_changes", ["user_id"], name: "cve_changes_user_id", using: :btree - - create_table "cve_comments", force: :cascade do |t| - t.integer "cve_id", limit: 4 - t.integer "user_id", limit: 4 - t.boolean "confidential", limit: 1, default: false - t.text "comment", limit: 65535 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cve_comments", ["cve_id"], name: "index_cve_comments_on_cve_id", using: :btree - add_index "cve_comments", ["user_id"], name: "cve_comments_user_id", using: :btree - - create_table "cve_references", force: :cascade do |t| - t.string "source", limit: 255 - t.text "title", limit: 65535 - t.text "uri", limit: 65535 - t.integer "cve_id", limit: 4 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cve_references", ["cve_id"], name: "index_cve_references_on_cve_id", using: :btree - - create_table "cves", force: :cascade do |t| - t.string "cve_id", limit: 255 - t.text "summary", limit: 65535 - t.string "cvss", limit: 255 - t.string "state", limit: 255 - t.datetime "published_at" - t.datetime "last_changed_at" - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "cves", ["cve_id"], name: "index_cves_on_cve_id", unique: true, using: :btree - - create_table "glsas", force: :cascade do |t| - t.string "glsa_id", limit: 255 - t.integer "requester", limit: 4 - t.integer "submitter", limit: 4 - t.integer "bugreadymaker", limit: 4 - t.string "status", limit: 255 - t.boolean "restricted", limit: 1, default: false - t.datetime "created_at" - t.datetime "updated_at" - t.datetime "first_released_at" - end - - add_index "glsas", ["bugreadymaker"], name: "glsas_users_bugreadymakers", using: :btree - add_index "glsas", ["glsa_id"], name: "index_glsas_on_glsa_id", unique: true, using: :btree - add_index "glsas", ["requester"], name: "glsas_users_requesters", using: :btree - add_index "glsas", ["status"], name: "index_glsas_on_status", using: :btree - add_index "glsas", ["submitter"], name: "glsas_users_submitters", using: :btree - - create_table "packages", force: :cascade do |t| - t.integer "revision_id", limit: 4 - t.string "my_type", limit: 255 - t.string "atom", limit: 255 - t.string "version", limit: 255 - t.string "comp", limit: 255 - t.string "arch", limit: 255 - t.boolean "automatic", limit: 1, default: true - t.datetime "created_at" - t.datetime "updated_at" - t.string "slot", limit: 255 - end - - add_index "packages", ["atom"], name: "atom", using: :btree - add_index "packages", ["comp"], name: "comp", using: :btree - add_index "packages", ["revision_id"], name: "index_packages_on_revision_id", using: :btree - add_index "packages", ["slot"], name: "slot", using: :btree - - create_table "references", force: :cascade do |t| - t.integer "revision_id", limit: 4 - t.text "title", limit: 65535 - t.text "url", limit: 65535 - t.string "type", limit: 255 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "references", ["revision_id"], name: "index_references_on_revision_id", using: :btree - - create_table "revisions", force: :cascade do |t| - t.integer "glsa_id", limit: 4 - t.integer "revid", limit: 4 - t.string "title", limit: 255 - t.string "access", limit: 255, default: "remote" - t.string "product", limit: 255 - t.string "category", limit: 255 - t.string "severity", limit: 255, default: "normal" - t.text "synopsis", limit: 65535 - t.text "background", limit: 65535 - t.text "description", limit: 65535 - t.text "impact", limit: 65535 - t.text "workaround", limit: 65535 - t.text "resolution", limit: 65535 - t.datetime "created_at" - t.datetime "updated_at" - t.integer "user_id", limit: 4 - t.boolean "is_release", limit: 1, default: false - t.integer "release_revision", limit: 4 - end - - add_index "revisions", ["glsa_id"], name: "index_revisions_on_glsa_id", using: :btree - add_index "revisions", ["revid"], name: "index_revisions_on_revid", using: :btree - add_index "revisions", ["title"], name: "index_revisions_on_title", using: :btree - add_index "revisions", ["user_id"], name: "revisions_user_userid", using: :btree - - create_table "sessions", force: :cascade do |t| - t.string "session_id", limit: 255, null: false - t.text "data", limit: 65535 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree - add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree - - create_table "templates", force: :cascade do |t| - t.string "name", limit: 255 - t.text "text", limit: 65535 - t.string "target", limit: 255 - t.boolean "enabled", limit: 1, default: true - t.datetime "created_at" - t.datetime "updated_at" - end - - create_table "users", force: :cascade do |t| - t.string "login", limit: 255 - t.string "name", limit: 255 - t.string "email", limit: 255 - t.boolean "disabled", limit: 1, default: false - t.boolean "jefe", limit: 1, default: false - t.text "preferences", limit: 65535 - t.integer "access", limit: 4 - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "users", ["login"], name: "index_users_on_login", unique: true, using: :btree - - add_foreign_key "comments", "glsas", name: "comments_glsas_glsaid" - add_foreign_key "comments", "users", name: "comments_users_userid" - add_foreign_key "cpes_cves", "cpes", name: "cpes_cves_cpe_id" - add_foreign_key "cpes_cves", "cves", name: "cpes_cves_cve_id" - add_foreign_key "cve_assignments", "cves", name: "cve_assignments_cve_id" - add_foreign_key "cve_changes", "cves", name: "cve_changes_cve_id" - add_foreign_key "cve_changes", "users", name: "cve_changes_user_id" - add_foreign_key "cve_comments", "cves", name: "cve_comments_cve_id" - add_foreign_key "cve_comments", "users", name: "cve_comments_user_id" - add_foreign_key "cve_references", "cves", name: "cve_references_cve_id" - add_foreign_key "glsas", "users", column: "bugreadymaker", name: "glsas_users_bugreadymakers" - add_foreign_key "glsas", "users", column: "requester", name: "glsas_users_requesters" - add_foreign_key "glsas", "users", column: "submitter", name: "glsas_users_submitters" - add_foreign_key "references", "revisions", name: "references_revisions_revisionid" - add_foreign_key "revisions", "users", name: "revisions_user_userid" -end diff --git a/db/seeds.rb b/db/seeds.rb deleted file mode 100644 index d34dfa0..0000000 --- a/db/seeds.rb +++ /dev/null @@ -1,7 +0,0 @@ -# This file should contain all the record creation needed to seed the database with its default values. -# The data can then be loaded with the rake db:seed (or created alongside the db with db:setup). -# -# Examples: -# -# cities = City.create([{ :name => 'Chicago' }, { :name => 'Copenhagen' }]) -# Mayor.create(:name => 'Emanuel', :city => cities.first) |