summaryrefslogtreecommitdiff
path: root/db/migrate/20180305095250_create_internal_ids_table.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20180305095250_create_internal_ids_table.rb')
-rw-r--r--db/migrate/20180305095250_create_internal_ids_table.rb15
1 files changed, 15 insertions, 0 deletions
diff --git a/db/migrate/20180305095250_create_internal_ids_table.rb b/db/migrate/20180305095250_create_internal_ids_table.rb
new file mode 100644
index 00000000000..432086fe98b
--- /dev/null
+++ b/db/migrate/20180305095250_create_internal_ids_table.rb
@@ -0,0 +1,15 @@
+class CreateInternalIdsTable < ActiveRecord::Migration
+ include Gitlab::Database::MigrationHelpers
+
+ DOWNTIME = false
+
+ def change
+ create_table :internal_ids, id: :bigserial do |t|
+ t.references :project, null: false, foreign_key: { on_delete: :cascade }
+ t.integer :usage, null: false
+ t.integer :last_value, null: false
+
+ t.index [:usage, :project_id], unique: true
+ end
+ end
+end