mirror of
https://github.com/documize/community.git
synced 2025-07-19 21:29:42 +02:00
2336dab69f
Ground work for installing and upgrading database schema based upon DB provider (MySQL, PostgresSQL, SQL Server, etc.) Cleaned up legacy cruft, refactored, commented and made simpler for to support additional database providers.
10 lines
346 B
SQL
10 lines
346 B
SQL
/* community edition */
|
|
|
|
-- max tags per document setting
|
|
ALTER TABLE organization ADD COLUMN `maxtags` INT NOT NULL DEFAULT 3 AFTER `authconfig`;
|
|
|
|
-- support for network location link types
|
|
ALTER TABLE link ADD COLUMN `externalid` NVARCHAR(1000) NOT NULL DEFAULT '' AFTER `targetid`;
|
|
|
|
-- deprecations
|
|
ALTER TABLE organization DROP COLUMN `url`;
|