diff -r a8891e108c95 -r 9c17aacd5515 upgrade.sql --- a/upgrade.sql Sun Aug 26 20:45:33 2007 -0400 +++ b/upgrade.sql Sun Aug 26 20:55:12 2007 -0400 @@ -5,6 +5,8 @@ DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version'; INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0.1' ); ---BEGIN 1.0--- +-- Added on advice from Neal +INSERT INTO {{TABLE_PREFIX}}acl(target_type,target_id,page_id,namespace,rules) VALUES(2,1,'Memberlist','Special','read=1;mod_misc=1;upload_files=1;upload_new_version=1;create_page=1;edit_acl=1;'); -- Bugfix for MySQL 5.0.45, see http://forum.enanocms.org/viewtopic.php?f=5&t=8 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN delvote_ips text NOT NULL DEFAULT ''; CREATE TABLE {{TABLE_PREFIX}}page_groups( pg_id mediumint(8) NOT NULL auto_increment, pg_type tinyint(2) NOT NULL DEFAULT 1, pg_name varchar(255) NOT NULL DEFAULT '', pg_target varchar(255) DEFAULT NULL, PRIMARY KEY ( pg_id ) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;