# frozen_string_literal: true

class Projects < ActiveRecord::Migration[7.1]
  def change
    create_table :projects, if_not_exists: true do |t|
      t.string :public_id, null: false # This is a slug, not a uuid
      t.string :name, null: false
      t.string :os_path, null: false
      t.bigint :role_visibility, null: false
      t.json :allowed_paths, default: []
      t.json :disallowed_paths, default: []
      t.text :description, default: ""
      t.json :links, default: {}
      t.date :start_date
      t.date :end_date
      t.timestamps

      t.index :public_id, unique: true
      t.index :name, unique: true
    end
  end
end