use [% mambo %];
SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
CREATE TABLE [% table_prefix %]_comment (
    id int(11) NOT NULL COMMENT '' auto_increment,
    articleid int(11) NOT NULL COMMENT '',
    ip varchar(15) NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    name varchar(30) NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    comments text NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    startdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    published tinyint(1) NOT NULL COMMENT '',
    PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE [% table_prefix %]_menu
    MODIFY params text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    [% table_prefix %]_menu.params changed from text NOT NULL COMMENT '' COLLATE latin1_swedish_ci to text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE [% table_prefix %]_modules
    ADD groups text NOT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER client_id;


#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;
