(public).sospep.events ~ view task ~ DB-schema-v-013-rev-001

<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>

~ view task ~ TaskGroup] DB FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep