[Lxr-commits] CVS: lxr initdb-oracle.sql,NONE,1.1 CREDITS.txt,1.4,1.5 INSTALL,1.6,1.7

[Malcolm B. <mb...@us...>]

Update of /cvsroot/lxr/lxr
In directory usw-pr-cvs1:/tmp/cvs-serv31686

Modified Files:
	CREDITS.txt INSTALL 
Added Files:
	initdb-oracle.sql 
Log Message:
New database backend for Oracle, from Jens Heimann.


--- NEW FILE: initdb-oracle.sql ---
drop sequence filenum;
drop sequence symnum;
drop table indexes;
drop table usage;
drop table symbols;
drop table releases;
drop table status;
drop table files;

commit;

create sequence filenum;
create sequence symnum;

commit;

create table files ( 			

	filename	varchar2(250),

	revision	varchar2(250),

	fileid		number,
	constraint pk_files primary key (fileid)
);
alter table files add unique (filename, revision);
create index i_files on files(filename);

commit;

create table symbols (				
	symname		varchar2(250),
	symid		number,
	constraint pk_symbols primary key (symid)
);
alter table symbols add unique(symname);

commit;

create table indexes (
	symid		number,
	fileid		number,
	line		number,
	type		varchar2(250),
	relsym		number,
	constraint fk_indexes_fileid foreign key (fileid) references files(fileid),
	constraint fk_indexes_symid foreign key (symid) references symbols(symid),
	constraint fk_indexes_relsym foreign key (relsym) references symbols(symid)
);
create index i_indexes on indexes(symid);

commit;

create table releases (	
	fileid		number,
	release		varchar2(250),
	constraint pk_releases primary key (fileid,release),
	constraint fk_releases_fileid foreign key (fileid) references files(fileid)
);

commit;

create table status (
	fileid		number,
	status		number,
	constraint pk_status primary key (fileid),
	constraint fk_status_fileid foreign key (fileid) references files(fileid)
);

commit;

create table usage (				
	fileid		number,
	line		number,
	symid		number,
	constraint fk_usage_fileid foreign key (fileid) references files(fileid),
	constraint fk_usage_symid foreign key (symid) references symbols(symid)
);
create index i_usage on usage(symid);

commit;
Index: CREDITS.txt
===================================================================
RCS file: /cvsroot/lxr/lxr/CREDITS.txt,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- CREDITS.txt	23 Jan 2002 15:14:07 -0000	1.4
+++ CREDITS.txt	26 Feb 2002 16:18:46 -0000	1.5
@@ -23,7 +23,8 @@
 Jason Dorie Short <js...@de...>		File re-org
 Joseph Corral <jos...@hp...>
 Kristoffer Gleditsch <to...@pi...>		Postgres patches
-Guido Sohne										Updated INSTALL document
+Guido Sohne						Updated INSTALL document
+Jens Heimann <jen...@ma...>			Oracle database support
 
 
 

Index: INSTALL
===================================================================
RCS file: /cvsroot/lxr/lxr/INSTALL,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- INSTALL	23 Jan 2002 15:52:51 -0000	1.6
+++ INSTALL	26 Feb 2002 16:18:46 -0000	1.7
@@ -5,8 +5,10 @@
 1) A recent version of the exuberant ctags program.  Available from
    http://sf.net/projects/ctags
 
-2) A relational database - MySQL (http://www.mysql.com) and Postgresql
-   (http://www.postgresql.org) are supported.
+2) A relational database - MySQL (http://www.mysql.com), Postgresql
+   (http://www.postgresql.org) and Oracle are supported.
+   You will also need the right Perl DBI drivers for your particular database,
+   usually available from CPAN.
 
 3) Apache with mod_perl - http://www.apache.org
 
@@ -39,6 +41,13 @@
 Run 'mysql' and then read in the initdb-mysql file using
 '\. initdb-mysql'.  This will create the database and a user called
 lxr with access rights to the database.
+
+For Oracle
+
+Start script in sqlplus with:
+
+@/[pathTo]/initdb-oracle.sql;
+
 
 Create lxr installation directory
 ---------------------------------