1.2.0
  ALTER TABLE `cms_layouts` ADD `smart_phone_head` TEXT NULL;
  ALTER TABLE `cms_layouts` ADD `smart_phone_body` LONGTEXT NULL;
  ALTER TABLE `cms_layouts` ADD `smart_phone_stylesheet` LONGTEXT NULL; 

1.1.9
  CREATE TABLE bbs_items (
    id int(11) NOT NULL AUTO_INCREMENT,
    parent_id int(11) DEFAULT NULL,
    thread_id int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    email varchar(255) DEFAULT NULL,
    uri varchar(255) DEFAULT NULL,
    title text,
    body longtext,
    password varchar(15) DEFAULT NULL,
    ipaddr varchar(255) DEFAULT NULL,
    user_agent varchar(255) DEFAULT NULL,
    PRIMARY KEY (id)
  );
  CREATE TABLE tool_simple_captcha_data (
    id int(11) NOT NULL AUTO_INCREMENT,
    `key` varchar(40) DEFAULT NULL,
    value varchar(6) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    PRIMARY KEY (id)
  );

1.1.8
  CREATE TABLE IF NOT EXISTS calendar_events (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    published_at datetime DEFAULT NULL,
    event_date date DEFAULT NULL,
    event_uri varchar(255) DEFAULT NULL,
    title text,
    body longtext,
    PRIMARY KEY (id)
  );

1.1.5
  CREATE TABLE sys_unid_relations (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) NOT NULL,
    rel_unid int(11) NOT NULL,
    rel_type varchar(255) NOT NULL,
    PRIMARY KEY (id),
    KEY unid (unid),
    KEY rel_unid (rel_unid)
  );

1.1.4
  ALTER TABLE article_areas ADD concept_id INT NULL AFTER parent_id;
  ALTER TABLE article_attributes ADD concept_id INT NULL AFTER unid;
  ALTER TABLE article_categories ADD concept_id INT NULL AFTER parent_id;
  CREATE TABLE cms_map_markers (
    id int(11) NOT NULL AUTO_INCREMENT,
    map_id int(11) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    sort_no int(11) DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    lat varchar(255) DEFAULT NULL,
    lng varchar(255) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY map_id (map_id)
  );

1.1.3
  CREATE TABLE cms_site_settings (
    id int(11) NOT NULL AUTO_INCREMENT,
    site_id int(11) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(32) DEFAULT NULL,
    value text,
    sort_no int(11) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY concept_id (site_id,name)
  );

1.1.2
  CREATE TABLE newsletter_delivery_logs (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    doc_id int(11) DEFAULT NULL,
    letter_type varchar(15) DEFAULT NULL,
    title text,
    body longtext,
    delivery_state varchar(15) DEFAULT NULL,
    delivered_count int(11) DEFAULT NULL,
    deliverable_count int(11) DEFAULT NULL,
    last_member_id int(11) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY content_id (content_id,doc_id,letter_type)
  );
  CREATE TABLE newsletter_docs (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    delivery_state varchar(15) DEFAULT NULL,
    delivered_at datetime DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    title text,
    body longtext,
    mobile_title text,
    mobile_body longtext,
    PRIMARY KEY (id),
    KEY content_id (content_id,updated_at)
  );
  CREATE TABLE newsletter_members (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    letter_type varchar(15) DEFAULT NULL,
    email text,
    delivered_doc_id int(11) DEFAULT NULL,
    delivered_at datetime DEFAULT NULL,
    PRIMARY KEY (id),
    KEY content_id (content_id,letter_type,created_at)
  );
  CREATE TABLE newsletter_requests (
    id int(11) NOT NULL AUTO_INCREMENT,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    request_state varchar(15) DEFAULT NULL,
    request_type varchar(15) DEFAULT NULL,
    letter_type varchar(15) DEFAULT NULL,
    subscribe_email text,
    unsubscribe_email text,
    token text,
    PRIMARY KEY (id),
    KEY content_id (content_id,request_state,request_type)
  );
  CREATE TABLE newsletter_tests (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    agent_state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name text,
    email text,
    PRIMARY KEY (id)
  );

1.1.1
  CREATE TABLE cms_piece_link_items (
    id int(11) NOT NULL AUTO_INCREMENT,
    piece_id int(11) NOT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    body text DEFAULT NULL,
    uri varchar(255) DEFAULT NULL,
    sort_no int(11) DEFAULT NULL,
    target varchar(255) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY piece_id (piece_id)
  );

1.1.0
  CREATE TABLE cms_feeds (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state text,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(255) NOT NULL,
    uri text,
    title text,
    feed_id varchar(255) DEFAULT NULL,
    feed_type varchar(255) DEFAULT NULL,
    feed_updated datetime DEFAULT NULL,
    feed_title text,
    link_alternate text,
    entry_count int(11) DEFAULT NULL,
    PRIMARY KEY (id)
  );
  CREATE TABLE cms_feed_entries (
    id int(11) NOT NULL AUTO_INCREMENT,
    feed_id int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state text,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    entry_id varchar(255) DEFAULT NULL,
    entry_updated datetime DEFAULT NULL,
    event_date date DEFAULT NULL,
    title text,
    summary mediumtext,
    link_alternate text,
    link_enclosure text,
    categories text,
    author_name text,
    author_email varchar(255) DEFAULT NULL,
    author_uri text,
    PRIMARY KEY (id),
    KEY feed_id (feed_id,content_id,entry_updated)
  );
  CREATE TABLE portal_categories (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    parent_id int(11) NOT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    level_no int(11) NOT NULL,
    sort_no int(11) DEFAULT NULL,
    layout_id int(11) DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    title text,
    entry_categories mediumtext,
    PRIMARY KEY (id),
    KEY parent_id (parent_id,content_id,state)
  );
  CREATE TABLE cms_content_settings (
    id int(11) NOT NULL AUTO_INCREMENT,
    content_id int(11) NOT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    value text,
    sort_no int(11) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY content_id (content_id)
  );
  CREATE TABLE cms_piece_settings (
    id int(11) NOT NULL AUTO_INCREMENT,
    piece_id int(11) NOT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    value text,
    sort_no int(11) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY piece_id (piece_id)
  );
  DROP TABLE cms_talk_tasks;
  CREATE TABLE cms_talk_tasks (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    dependent varchar(64) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    path text,
    content_hash varchar(255) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY unid (unid,dependent)
  );
  DROP TABLE sys_publishers;
  CREATE TABLE sys_publishers (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    dependent varchar(64) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    path varchar(255) DEFAULT NULL,
    content_hash varchar(255) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY unid (unid,dependent)
  );
  ALTER TABLE sys_groups ADD unid INT NULL AFTER id;

1.0.8
  ALTER TABLE cms_pieces ADD view_title VARCHAR( 255 ) NULL AFTER title;
  CREATE TABLE enquete_answers (
    id int(11) NOT NULL AUTO_INCREMENT,
    content_id int(11) DEFAULT NULL,
    form_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    ipaddr varchar(255) DEFAULT NULL,
    user_agent text,
    PRIMARY KEY (id),
    KEY content_id (content_id,form_id)
  );
  CREATE TABLE enquete_answer_columns (
    id int(11) NOT NULL AUTO_INCREMENT,
    answer_id int(11) DEFAULT NULL,
    form_id int(11) DEFAULT NULL,
    column_id int(11) DEFAULT NULL,
    value longtext,
    PRIMARY KEY (id),
    KEY answer_id (answer_id,form_id,column_id)
  );
  CREATE TABLE enquete_forms (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    content_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    sort_no int(11) DEFAULT NULL,
    name text,
    body longtext,
    summary text,
    sent_body longtext,
    PRIMARY KEY (id),
    KEY content_id (content_id,sort_no)
  );
  CREATE TABLE enquete_form_columns (
    id int(11) NOT NULL AUTO_INCREMENT,
    unid int(11) DEFAULT NULL,
    form_id int(11) DEFAULT NULL,
    state varchar(15) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    sort_no int(11) DEFAULT NULL,
    name text,
    body text,
    column_type varchar(255) DEFAULT NULL,
    column_style varchar(255) DEFAULT NULL,
    required int(11) DEFAULT NULL,
    options longtext,
    PRIMARY KEY (id),
    KEY form_id (form_id,sort_no)
  );

1.0.7
  ALTER TABLE article_docs ADD agent_state VARCHAR( 15 ) NULL AFTER state;

1.0.6
  CREATE TABLE sys_ldap_synchros (
    id int(11) NOT NULL AUTO_INCREMENT,
    parent_id int(11) DEFAULT NULL,
    created_at datetime DEFAULT NULL,
    updated_at datetime DEFAULT NULL,
    version varchar(10) DEFAULT NULL,
    entry_type varchar(15) DEFAULT NULL,
    code varchar(255) DEFAULT NULL,
    sort_no int(11) DEFAULT NULL,
    name varchar(255) DEFAULT NULL,
    name_en varchar(255) DEFAULT NULL,
    email varchar(255) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY version (version,parent_id,entry_type)
  );

1.0.3
  ALTER TABLE cms_nodes ADD mobile_title TEXT NULL AFTER body;
  ALTER TABLE cms_nodes ADD mobile_body LONGTEXT NULL AFTER mobile_title;

1.0.2
  ALTER TABLE cms_data_texts ADD site_id INTEGER NULL AFTER unid;