DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:struct:rename

Struct Plugin

Rename

Schemas can be renamed by using the following code-snippet and replacing OLD with the old name of the schema and NEW with the new name of the schema and then executing it the struct-section of the administrative menu of the sqlite plugin.

UPDATE schemas SET tbl = 'NEW' WHERE tbl = 'OLD';
UPDATE schema_assignments SET tbl = 'NEW' WHERE tbl = 'OLD';
UPDATE schema_assignments_patterns SET tbl = 'NEW' WHERE tbl = 'OLD';
ALTER TABLE 'data_OLD' RENAME TO 'data_NEW';
ALTER TABLE 'multi_OLD' RENAME TO 'multi_NEW';

Please be aware that you still have to manually update all your aggregations.

plugin/struct/rename.txt · Last modified: 2016-07-28 13:24 by grosse

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki