task

title

-- ALIGN all photos field to varchar(4096), sospep WAS OK, local was using previous field sizes

] SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
] ALTER TABLE `sospep`.`items` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL ;
] ALTER TABLE `sospep`.`people` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL ;
] ALTER TABLE `sospep`.`locations` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL ;
] ALTER TABLE `sospep`.`tasks` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL ;
] ALTER TABLE `sospep`.`articles` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL ;
] SET SQL_MODE=@OLD_SQL_MODE;SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

-- ADD photo feild to L2(books,...) DB = sospep, local

ALTER TABLE `inventories` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;
ALTER TABLE `books` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;
ALTER TABLE ``procedures` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;
ALTER TABLE `members` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;
ALTER TABLE `plans` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;
ALTER TABLE `maps` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL AFTER `parent_id` ;

Details Photos Edit more

ID: 3489

NAME: DB-schema-v-013-rev-001

DESCRIPTION: ] NEW FIELD - photo FOR l2 {book, inventory, ...} ] ALIGN FIELD - photo FOR l5 ]

START DATE TIME: 2014-02-18 08:49:04

EST DURATION: 01:00:00

END DATE TIME: 2014-02-18 09:49:04

STATUS: To-Do

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more