/*
SQLyog Enterprise - MySQL GUI v8.12 
MySQL - 5.5.18 : Database - xlab
*********************************************************************
*/





ALTER TABLE `xlab`.`xportalclient` 
   CHANGE `ClientId` `ClientId` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Unique Client ID';
   

SET @newcols = "ALTER TABLE `portal`.`clients` 
   CHANGE `client_id` `client_id` VARCHAR(10)";

SET @exist := (SELECT COUNT(*) FROM information_schema.TABLES WHERE (TABLE_SCHEMA = 'portal' AND TABLE_NAME = 'clients'));
SET @sqlstmt := IF(@exist = 1, @newcols, 'select ''INFO: Portal.Clients does not exist.''');
PREPARE stmt FROM @sqlstmt;
EXECUTE stmt; 
   
   
INSERT IGNORE INTO `versions` SET ver_type = 0, ver_dt = NOW(), ver_who = 'Script Update', ver_major = '19', ver_minor = '10', ver_build = '3', ver_revision= '0';
   
 
