modules/oai2/oai2.mysql

# $Id: $

CREATE TABLE `oai2_metadata_formats` (
                              `name` varchar(100) NOT NULL default '',
                              `metadata_prefix` varchar(100) NOT NULL default '',
                              `schema` varchar(255) NOT NULL default '',
                              `metadata_namespace` varchar(255) NOT NULL default '',
                              `record_prefix` varchar(100) NOT NULL default '',
                              `record_namespace` varchar(255) NOT NULL default '',
                              PRIMARY KEY  (`name`)
                              ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
                              
INSERT INTO `oai2_metadata_formats` (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`) VALUES 
                              ('oai_dc','oai_dc','http://www.openarchives.org/OAI/2.0/oai_dc.xsd','http://www.openarchives.org/OAI/2.0/oai_dc/','dc','http://purl.org/dc/elements/1.1/');
                              ;
                          
CREATE TABLE `oai2_tokens` (
                            `id` bigint(20) NOT NULL default '0',
                            `deliveredrecords` int(11) NOT NULL default '0',
                            `extquery` varchar(255) default '',
                            `queryargs` varchar(255) default '',
                            `metadata_prefix` varchar(255) default '',
                            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
                            PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1	# $Id: $
2
3	CREATE TABLE `oai2_metadata_formats` (
4	`name` varchar(100) NOT NULL default '',
5	`metadata_prefix` varchar(100) NOT NULL default '',
6	`schema` varchar(255) NOT NULL default '',
7	`metadata_namespace` varchar(255) NOT NULL default '',
8	`record_prefix` varchar(100) NOT NULL default '',
9	`record_namespace` varchar(255) NOT NULL default '',
10	PRIMARY KEY (`name`)
11	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
12
13	INSERT INTO `oai2_metadata_formats` (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`) VALUES
14	('oai_dc','oai_dc','http://www.openarchives.org/OAI/2.0/oai_dc.xsd','http://www.openarchives.org/OAI/2.0/oai_dc/','dc','http://purl.org/dc/elements/1.1/');
15	;
16
17	CREATE TABLE `oai2_tokens` (
18	`id` bigint(20) NOT NULL default '0',
19	`deliveredrecords` int(11) NOT NULL default '0',
20	`extquery` varchar(255) default '',
21	`queryargs` varchar(255) default '',
22	`metadata_prefix` varchar(255) default '',
23	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
24	PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;