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.
18 lines
605 B
SQL
18 lines
605 B
SQL
/* enterprise edition */
|
|
|
|
-- consistency of table engines
|
|
ALTER TABLE config ENGINE = InnoDB;
|
|
ALTER TABLE permission ENGINE = InnoDB;
|
|
ALTER TABLE category ENGINE = InnoDB;
|
|
ALTER TABLE categorymember ENGINE = InnoDB;
|
|
ALTER TABLE role ENGINE = InnoDB;
|
|
ALTER TABLE rolemember ENGINE = InnoDB;
|
|
|
|
-- content analytics
|
|
ALTER TABLE useractivity ADD COLUMN `metadata` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `activitytype`;
|
|
|
|
-- new role for viewing content analytics
|
|
ALTER TABLE account ADD COLUMN `analytics` BOOL NOT NULL DEFAULT 0 AFTER `users`;
|
|
UPDATE account SET analytics=1 WHERE `admin`=1;
|
|
|
|
-- deprecations
|