1
0
Fork 0
mirror of https://we.phorge.it/source/phorge.git synced 2024-09-19 16:58:48 +02:00
phorge-phorge/resources/sql/patches/20131120.nuancesourcetype.sql
Bob Trahan 7b718bb033 Nuance - federate out the design of NuanceSource via NuanceSourceDefinition
Summary: ...and get the basic edit flow "working" for a new NuanceSourceDefinition - the Phabricator Form. ...and fix a dumb bug in the query class so when you redirect to the view page / try to edit an existing NuanceSource you don't fatal.

Test Plan: played around with the edit form and it worked!

Reviewers: epriestley

Reviewed By: epriestley

CC: Korvin, epriestley, aran

Differential Revision: https://secure.phabricator.com/D7585
2013-11-20 13:41:19 -08:00

11 lines
332 B
SQL

ALTER TABLE {$NAMESPACE}_nuance.nuance_source
DROP KEY key_type;
ALTER TABLE {$NAMESPACE}_nuance.nuance_source
DROP COLUMN type;
ALTER TABLE {$NAMESPACE}_nuance.nuance_source
ADD type VARCHAR(32) NOT NULL COLLATE utf8_bin AFTER name;
ALTER TABLE {$NAMESPACE}_nuance.nuance_source
ADD KEY `key_type` (type, dateModified);