Here is the new Armarius database (scripts to create tables)

From Armarius

CREATE TABLE armarius_metacontent (
metacontent_id MEDIUMINT(6) UNSIGNED NOT NULL auto_increment,
metacontent_value VARCHAR(100) collate latin2_hungarian_ci NOT NULL,
metacontent_lang VARCHAR(2) collate latin2_hungarian_ci NOT NULL default 'en',
PRIMARY KEY(metacontent_id),
INDEX metacontent_value(metacontent_value)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_groups (
group_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
group_name VARCHAR(100) NULL,
PRIMARY KEY(group_id)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_meta_pages (
pg_id MEDIUMINT UNSIGNED NOT NULL,
pg_parent_pg MEDIUMINT(8) unsigned default NULL,
pg_title VARCHAR(255) collate latin2_hungarian_ci NOT NULL,
pg_text LONGTEXT collate latin2_hungarian_ci NOT NULL,
pg_show_in_menu TINYINT(1) NOT NULL,
pg_lang VARCHAR(5) collate latin2_hungarian_ci NOT NULL,
PRIMARY KEY(pg_id),
INDEX pg_title(pg_title),
INDEX pg_lang(pg_lang)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_users (
user_id MEDIUMINT(6) UNSIGNED NOT NULL auto_increment,
user_login VARCHAR(254) NOT NULL,
user_password VARCHAR(254) NOT NULL,
user_name VARCHAR(30) collate latin2_hungarian_ci NOT NULL,
user_email VARCHAR(254) character set latin2 collate latin2_bin NOT NULL,
user_lastlogin DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
user_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
user_activated SMALLINT(1) UNSIGNED NOT NULL,
PRIMARY KEY(user_id),
INDEX Username(user_login)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_pages (
pg_id MEDIUMINT UNSIGNED NOT NULL auto_increment,
pg_filename VARCHAR(50) collate latin2_hungarian_ci NOT NULL,
pg_title VARCHAR(30) collate latin2_hungarian_ci NOT NULL,
PRIMARY KEY(pg_id),
INDEX pg_title(pg_title)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE `armarius_collections` (
 `col_id` mediumint(8) unsigned NOT NULL auto_increment,
 `col_name` varchar(50) collate latin2_hungarian_ci NOT NULL,
 `col_date` datetime NOT NULL,
 PRIMARY KEY  (`col_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_config (
cfg_name VARCHAR(20) character set latin2 collate latin2_bin NOT NULL,
cfg_lang VARCHAR(2) collate latin2_hungarian_ci NOT NULL ,
cfg_value VARCHAR(255) collate latin2_hungarian_ci NOT NULL,
PRIMARY KEY(cfg_name, cfg_lang))ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_collections_content (
cc_col_id MEDIUMINT(8) UNSIGNED NOT NULL,
cc_content MEDIUMINT UNSIGNED NOT NULL,
cc_content_type SMALLINT NOT NULL,
PRIMARY KEY(cc_col_id,cc_content),
FOREIGN KEY(cc_col_id)
  REFERENCES armarius_collections(col_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_du (
du_id MEDIUMINT(6) NOT NULL auto_increment,
du_page_id MEDIUMINT(8) UNSIGNED NOT NULL,
du_left DOUBLE NOT NULL,
du_top DOUBLE NOT NULL,
du_width DOUBLE NOT NULL,
du_height DOUBLE NOT NULL,
PRIMARY KEY(du_id),
INDEX du_page_id(du_page_id),
FOREIGN KEY(du_page_id)
  REFERENCES armarius_pages(pg_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_rights (
rg_col_id MEDIUMINT(8) UNSIGNED NOT NULL,
rg_group_id MEDIUMINT(8) UNSIGNED NOT NULL,
rg_rights MEDIUMINT(8) NULL,
PRIMARY KEY(rg_col_id, rg_group_id),
FOREIGN KEY(rg_group_id)
  REFERENCES armarius_groups(group_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
FOREIGN KEY(rg_col_id)
  REFERENCES armarius_collections(col_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_comment (
comment_id MEDIUMINT(9) NOT NULL auto_increment,
comment_DATE DATETIME NOT NULL,
comment_du MEDIUMINT(6) NOT NULL,
comment_text longtext character set latin2 collate latin2_hungarian_ci NOT NULL,
comment_user MEDIUMINT(8) UNSIGNED NOT NULL,
PRIMARY KEY(comment_id),
FOREIGN KEY(comment_user)
  REFERENCES armarius_users(user_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
FOREIGN KEY(comment_du)
  REFERENCES armarius_du(du_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE armarius_groups_content (
gc_group_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
gc_user_id MEDIUMINT(6) UNSIGNED NOT NULL,
PRIMARY KEY(gc_group_id, gc_user_id),
FOREIGN KEY(gc_group_id)
  REFERENCES armarius_groups(group_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
FOREIGN KEY(gc_user_id)
  REFERENCES armarius_users(user_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

CREATE TABLE armarius_annotation (
anno_auID MEDIUMINT(8) UNSIGNED NOT NULL,
anno_metacontentID MEDIUMINT(6) UNSIGNED NOT NULL,
anno_duID MEDIUMINT(6) NOT NULL,
anno_date DATETIME NOT NULL,
anno_meta_type MEDIUMINT(9) NOT NULL,
PRIMARY KEY(anno_auID, anno_metacontentID, anno_duID),
FOREIGN KEY(anno_auID)
  REFERENCES armarius_users(user_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
FOREIGN KEY(anno_metacontentID)
  REFERENCES armarius_metacontent(metacontent_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
FOREIGN KEY(anno_duID)
  REFERENCES armarius_du(du_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;