use [% mysql.gl.sqldb %];
SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
ALTER TABLE [% table_prefix %]_blocks
    ADD allow_autotags tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER content,
    MODIFY help varchar(255) NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    [% table_prefix %]_blocks.help changed from varchar(128) NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE [% table_prefix %]_pollanswers
    ADD remark varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER votes;


ALTER TABLE [% table_prefix %]_staticpage
    ADD sp_help varchar(255) NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER sp_centerblock,
    ADD postmode varchar(16) NOT NULL DEFAULT 'html' COMMENT '' COLLATE latin1_swedish_ci AFTER sp_inblock;


ALTER TABLE [% table_prefix %]_stories
    ADD advanced_editor_mode tinyint(1) unsigned NULL DEFAULT '0' COMMENT '' AFTER postmode;

REPLACE INTO [% table_prefix %]_features (ft_id,ft_name,ft_descr,ft_gl_core) VALUES ('25','syndication.edit','Access to Content Syndication','1');

REPLACE INTO [% table_prefix %]_group_assignments (ug_main_grp_id,ug_uid,ug_grp_id) VALUES ('17','','1');

REPLACE INTO [% table_prefix %]_groups (grp_id,grp_name,grp_descr,grp_gl_core) VALUES ('17','Syndication Admin','Can create and modify web feeds for the site','1');

EPLACE INTO [% table_prefix %]_plugins (pi_name,pi_version,pi_gl_version,pi_enabled,pi_homepage) VALUES ('calendar','1.0.0','1.4.1','1','http://www.geeklog.net/');

#
# DDL END
#
