IRview/sql/mysql.sql

#  $Revision: 1.3 $                                                        
#  ------------------------------------------------------------------------
#                                                                          
#  OAI-PMH based Institutional Repository Introduction Module              
#  Copyright (C) 2005 Kazutsuna YAMAJI. All rights reserved.               
#                                                                          
#  ------------------------------------------------------------------------
#
# Table structure for table `irview_data`
#

#CREATE TABLE irview_data (
#  irview_id int unsigned NOT NULL auto_increment,
#  irview_name tinytext NOT NULL default '',
#  PRIMARY KEY  (irview_id)
#) TYPE=MyISAM;

CREATE TABLE `irview_resumption_token` (
    `resumption_token` varchar(255) NOT NULL default '',
    `metadata_prefix` varchar(255) default NULL,
    `verb` varchar(32) default NULL,
    `args` text,
    `last_item_id` int(11) default NULL,
    `limit_row` int(11) default NULL,
    `publish_date` int(11) default NULL,
    `expire_date` int(11) default NULL,
    PRIMARY KEY  (`resumption_token`)
);


CREATE TABLE `irview_repositories` (
    `repository_id` int(11) unsigned NOT NULL auto_increment,
    `repository_name` varchar(255) default NULL,
    `URL` varchar(255) default NULL,
    `metadata_formats` varchar(255) default NULL,
    `last_access_date` int(11) unsigned default NULL,
    `last_success_date` int(11) unsigned default NULL,
    `last_access_result` text,
    `sort` int(10) unsigned NOT NULL default '0',
    `enabled` int(1) unsigned NOT NULL default '1',
    `deleted` int(1) unsigned NOT NULL default '0',
    `record_graph` blob,
    PRIMARY KEY  (`repository_id`),
    UNIQUE KEY `url` (`URL`)
);

CREATE TABLE `irview_metadata` (
    `identifier` varchar(255) NOT NULL default '',
    `repository_id` int(11) unsigned NOT NULL default '0',
    `format` varchar(255) NOT NULL default '',
    `metadata` blob,
    `title` text,
    `search_text` text,
    `datestamp` int(11) unsigned default NULL,
    PRIMARY KEY  (`identifier`),
    FULLTEXT KEY `search` (`search_text`)
);

