511560 - Perform database updates to Creative Collective Stage

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Please perform the following queries on the creative_collective database on stage:

ALTER TABLE `designs` ADD `thumbnail_coord_x1` smallint(5) unsigned default '0' AFTER `thumbnail`;
ALTER TABLE `designs` ADD `thumbnail_coord_y1` smallint(5) unsigned default '0' AFTER `thumbnail_coord_x1`;
ALTER TABLE `designs` ADD `thumbnail_coord_x2` smallint(5) unsigned default '0' AFTER `thumbnail_coord_y1`;
ALTER TABLE `designs` ADD `thumbnail_coord_y2` smallint(5) unsigned default '0' AFTER `thumbnail_coord_x2`;

Comment 1

[Michael Morgan [:morgamic]]

a=morgamic; adding new cols for improved thumbnail experience.

Comment 2

[Shyam Mani [:fox2mike]]

mysql> ALTER TABLE `designs` ADD `thumbnail_coord_x1` smallint(5) unsigned default '0'
    -> AFTER `thumbnail`;
Query OK, 152 rows affected (0.22 sec)
Records: 152  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `designs` ADD `thumbnail_coord_y1` smallint(5) unsigned default '0'
    -> AFTER `thumbnail_coord_x1`;
Query OK, 152 rows affected (0.02 sec)
Records: 152  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `designs` ADD `thumbnail_coord_x2` smallint(5) unsigned default '0'
    -> AFTER `thumbnail_coord_y1`;
Query OK, 152 rows affected (0.09 sec)
Records: 152  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `designs` ADD `thumbnail_coord_y2` smallint(5) unsigned default '0'
    -> AFTER `thumbnail_coord_x2`;
Query OK, 152 rows affected (0.06 sec)
Records: 152  Duplicates: 0  Warnings: 0

Done.