[DB Add Field] hrm_mp_job_sites - 3 Columns

Coordinator
Feb 1, 2013 at 4:21 AM
Edited Feb 1, 2013 at 10:32 AM
hrm_mp_job_sites

เพิ่มคอลัมน์
address2 VARCHAR 255
webaddress VARCHAR 255
head_pos_seq INT 11
ALTER TABLE `hrm_mp_job_sites`
ADD COLUMN `address2`  varchar(255) NULL AFTER `updated_when`,
ADD COLUMN `webaddress`  varchar(255) NULL AFTER `address2`,
ADD COLUMN `head_pos_seq`  int(11) NULL AFTER `webaddress`;