ALTER TABLE `client` ADD `customer_no_template` VARCHAR( 255 ) NULL DEFAULT 'C[CUSTOMER_NO]' AFTER `ssh_rsa` ,
|
ADD `customer_no_start` INT NOT NULL DEFAULT '1' AFTER `customer_no_template` ,
|
ADD `customer_no_counter` INT NOT NULL DEFAULT '0' AFTER `customer_no_start` ,
|
ADD `added_date` DATE NOT NULL default '0000-00-00' AFTER `customer_no_counter` ,
|
ADD `added_by` VARCHAR( 255 ) NULL AFTER `added_date` ;
|
ALTER TABLE `web_domain` ADD `added_date` DATE NOT NULL default '0000-00-00' AFTER `rewrite_rules` ,
|
ADD `added_by` VARCHAR( 255 ) NULL AFTER `added_date` ;
|
ALTER TABLE `sys_session` ADD `permanent` ENUM('n','y') NOT NULL DEFAULT 'n' AFTER `last_updated`;
|
