Newer
Older
Digital_Repository / Old / pysocks / pysocks.sql
nstanger on 12 Nov 2005 738 bytes - Second attempt at importing!
create table pages (
    page_id int,
    page_type int, -- is this a top level page or a component
    has_subparts int, -- is this a leaf node
    parent int, -- backlink to the parent if we are not a top level page
    template_id int, -- link into the templates table
    auth_level int -- all page parts have an auth level
);

-- this form has only 5 items
--  and id to the page id it belongs to
--  an auth_level
--  a name which can be used for a meaningful name or as a display item
--  the actual data

create table page_data_simple (
    page_id int,
    auth_level int,
    item_name int,
    item_data mediumtext
);

create table page_templates (
    template_id int,
    template_name char(255),
    template mediumtext
);