Support/Database Changes: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
(New page: = Database Changes = Remember to update [http://svn.mozilla.org/projects/sumo/trunk/db/tiki_mysql.sql tiki_mysql.sql] when you make schema changes! == To be run in production == * 2008-0...)
 
Line 1: Line 1:
= Database Changes =
= Database Changes =


Remember to update [http://svn.mozilla.org/projects/sumo/trunk/db/tiki_mysql.sql tiki_mysql.sql] when you make schema changes!
Remember to update
 
[http://svn.mozilla.org/projects/sumo/trunk/db/tiki.sql tiki.sql] and
[http://svn.mozilla.org/projects/sumo/trunk/db/tiki_1.9to1.10.sql tiki_1.9to1.10.sql] when you make schema changes!
 
Changes to the db-specific .sql files in the same path are generated as part of scripts etc... during a release process and therefore do not need to be changed directly.
 


== To be run in production ==
== To be run in production ==

Revision as of 02:59, 17 April 2008

Database Changes

Remember to update

tiki.sql and tiki_1.9to1.10.sql when you make schema changes!

Changes to the db-specific .sql files in the same path are generated as part of scripts etc... during a release process and therefore do not need to be changed directly.


To be run in production

 alter table users_permissions add unique(permName);


Ran In Production