Yii2 Gii – Table Update

ALTER TABLE `tablename`
  ADD `lock` int(5) NOT NULL,
  ADD `created_at` date DEFAULT NULL,
  ADD `created_by` int(11) NOT NULL DEFAULT 0,
  ADD `deleted_by` int(11) NOT NULL DEFAULT 0,
  ADD `deleted_at` date DEFAULT NULL,
  ADD `updated_at` date DEFAULT NULL,
  ADD `updated_by` int(11) NOT NULL DEFAULT 0
  AFTER branch_status;

Leave a Reply