Here are the scripts of creation of these tables

From Armarius

CREATE TABLE armarius_view (
view_id mediumint(8) unsigned NOT NULL auto_increment,
view_col_id mediumint(8) unsigned NOT NULL,
view_user_id mediumint(6) unsigned NOT NULL,
view_visibility smallint(1) unsigned NOT NULL,
 PRIMARY KEY(view_id),
 FOREIGN KEY(view_col_id)
 REFERENCES armarius_collections(col_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
 FOREIGN KEY(view_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_view_content (
vc_view_id mediumint(8) unsigned NOT NULL,
vc_pg_id mediumint(8) unsigned NOT NULL,
 PRIMARY KEY(vc_view_id,vc_pg_id),
 FOREIGN KEY(vc_view_id)
 REFERENCES armarius_view(view_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
 FOREIGN KEY(vc_pg_id)
 REFERENCES armarius_pages(pg_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci;

Return to the propositions page [[1]]