[Lxr-commits] CVS: lxr initdb-postgres,1.5,1.5.2.1

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

Update of /cvsroot/lxr/lxr
In directory sc8-pr-cvs1:/tmp/cvs-serv28106

Modified Files:
      Tag: rolling-cleanup
	initdb-postgres 
Log Message:
This branch is for experimental work on making LXR able to cope with an 
evolving source base.  The aim is that re-indexing the same file will remove 
previous entries created for that file, keeping the database clean.:wq



Index: initdb-postgres
===================================================================
RCS file: /cvsroot/lxr/lxr/initdb-postgres,v
retrieving revision 1.5
retrieving revision 1.5.2.1
diff -u -d -r1.5 -r1.5.2.1
--- initdb-postgres	28 Nov 2001 12:59:02 -0000	1.5
+++ initdb-postgres	21 Mar 2003 23:54:41 -0000	1.5.2.1
@@ -39,7 +39,7 @@
 
 create table indexes (
 	symid		int		references symbols,
-	fileid		int		references files,
+	fileid		int		references files(fileid) on delete cascade,
 	line		int,
 	langid		smallint not null,
 	type		smallint not null,
@@ -54,13 +54,13 @@
 );
 
 create table usage
-	(fileid		int		references files,
+	(fileid		int		references files(fileid) on delete cascade,
 	line		int,
-	symid		int		references symbols
+	symid		int		references symbols(symid) on delete cascade
 );
 
 create table status
-	(fileid		int		references files,
+	(fileid		int		references files(fileid) on delete cascade,
 	status		smallint,
 	primary key	(fileid)
 );