edit-task

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

Start Date:

Start Time:

Duration:

Priority:

Status: To Do Completed In Process

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">title</h1> <h2>[previously]</h2> <ol> <li>] on&nbsp;</li> </ol> <h2>[currently]</h2> <p><strong>-- ALIGN all photos field to varchar(4096), sospep WAS OK, local was using previous field sizes</strong></p> <ol> <li>] 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';</li> <li>] ALTER TABLE `sospep`.`items` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL &nbsp;;</li> <li>] ALTER TABLE `sospep`.`people` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL &nbsp;;</li> <li>] ALTER TABLE `sospep`.`locations` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL &nbsp;;</li> <li>] ALTER TABLE `sospep`.`tasks` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL &nbsp;;</li> <li>] ALTER TABLE `sospep`.`articles` CHANGE COLUMN `photo` `photo` VARCHAR(4096) NULL DEFAULT NULL &nbsp;;</li> <li>] SET SQL_MODE=@OLD_SQL_MODE;SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;</li> </ol> <div> <div><strong>-- ADD photo feild to L2(books,...) &nbsp;DB = sospep, local</strong></div> <div><ol> <li>ALTER TABLE `inventories` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> <li>ALTER TABLE `books` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> <li>ALTER TABLE ``procedures` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> <li>ALTER TABLE `members` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> <li>ALTER TABLE `plans` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> <li>ALTER TABLE `maps` ADD COLUMN `photo` VARCHAR(1024) NULL DEFAULT NULL &nbsp;AFTER `parent_id` ;</li> </ol></div> </div> <h2>[next]</h2> <ol> <li>]</li> </ol>