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
);