Diff #4 - trunk/etc/Migrations/updated_email_notifications_1637080580/install.sql

apex/webapp
4
trunk/etc/Migrations/updated_email_notifications_1637080580/install.sql
570 bytes
apex
January 20, 2025 at 08:20


Diff

Index: install.sql

--- install.sql (nonexistent) +++ install.sql (revision 4) @@ -0,0 +1,16 @@ + +ALTER TABLE internal_email_notifications CHANGE contents text_contents LONGTEXT NOT NULL; +ALTER TABLE internal_email_notifications ADD COLUMN html_contents LONGTEXT NOT NULL AFTER text_contents; +ALTER TABLE internal_email_notifications DROP COLUMN content_type; +ALTER TABLE cms_menus ADD COLUMN is_system BOOLEAN NOT NULL DEFAULT true AFTER is_active; + +CREATE TABLE cms_placeholders ( + id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, + package VARCHAR(100) NOT NULL, + uri VARCHAR(150) NOT NULL, + alias VARCHAR(150) NOT NULL, + contents TEXT NOT NULL +); + + +

Full Code

ALTER TABLE internal_email_notifications CHANGE contents text_contents LONGTEXT NOT NULL; ALTER TABLE internal_email_notifications ADD COLUMN html_contents LONGTEXT NOT NULL AFTER text_contents; ALTER TABLE internal_email_notifications DROP COLUMN content_type; ALTER TABLE cms_menus ADD COLUMN is_system BOOLEAN NOT NULL DEFAULT true AFTER is_active;

CREATE TABLE cms_placeholders ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, package VARCHAR(100) NOT NULL, uri VARCHAR(150) NOT NULL, alias VARCHAR(150) NOT NULL, contents TEXT NOT NULL );