CU MDT Ultimate
Migrations

Migrations

If you already have a database, add the weapon registry columns:

ALTER TABLE mdt_weapons
  ADD COLUMN purchase_source VARCHAR(64) NULL,
  ADD COLUMN purchased_at DATETIME NULL,
  ADD COLUMN registered_by VARCHAR(64) NULL,
  ADD COLUMN registered_by_name VARCHAR(128) NULL,
  ADD COLUMN registered_at DATETIME NULL,
  ADD KEY idx_status (status),
  ADD KEY idx_registered_by (registered_by),
  ADD KEY idx_purchased_at (purchased_at);
ExportsNotes