CREATE TABLE mr_mrec_tbl 

(

    mrec_id                                int  auto_increment,

    mrec_collection_flag                CHAR(1) default ‘N’,

    mrec_item_flag                            CHAR(1) default ‘Y’,

    mrec_annotation_flag                CHAR(1) default ‘N’,

    mrec_allow_harvest_flag               CHAR(1) default ‘N’,

    mrec_edit_flag              CHAR(1) default ‘Y’,

    mrec_cache_flag                      CHAR(1) default ‘N’,

    mrec_create_date                DATETIME default NOW(),

    mrec_last_mod_date            TIMESTAMP,

    mrec_acl_id                          int,

    mrec_source             varchar(100),

    mrec_blob_id               int,

    mrec_handle             varchar(30),

    primary key             (mrec_id)

);

 

CREATE TABLE mr_ cache_tbl

{

    mrec_id                                int,

    cache_mime_type_id    int,

    cache_time                              datetime,

    primary key             mrec_id    

};

 

CREATE TABLE mr_mod_history_tbl

{

    mrec_id                                int,

    mod_datetime               TIMESTAMP,

    mod_user_id                        varchar(20),

    primary key                          (mrec_id, mod_datetime)

};

 

CREATE TABLE mr_element_tbl

(

    element_id                            int auto_increment,

    mrec_id                               int,

    element_name               varchar(50),

    element_type                        varchar(20),

    element_scheme                      varchar(50),

    element_value               text,

    primary key             (element_id)

);

 

CREATE TABLE mr_acl_tbl 

(

    acl_id                                   int,

    acl_user_list              text,

    acl_edit_flag             CHAR(1) default ‘N’,

    acl_view_flag                CHAR(1) default ‘Y’,

    primary key                          acl_id

);

 

CREATE TABLE mr_link_tbl

(

    link_id                                  int auto_increment,

    parent_mrec_id                          int,

    child_mrec_id                 int,

    link_annotation_id                   int,

    primary key             (link_id)

);

 

CREATE TABLE mr_blob_tbl

{

    mrec_id                                int,

    mrec_format_id                        int,

    blob_text                              blob,

    primary key             mrec_id

};

 

CREATE TABLE mr_mrec_format_tbl

{

    mrec__format_id                      int,

    mrec_format_name                  varchar(30),

    primary key                          mrec_format_id

};