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

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

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

Modified Files:
	initdb-postgres 
Log Message:
Applied Postgres fixes from Kristoffer Gleditsch <to...@pi...>


Index: initdb-postgres
===================================================================
RCS file: /cvsroot/lxr/lxr/initdb-postgres,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- initdb-postgres	2001/11/18 03:31:33	1.4
+++ initdb-postgres	2001/11/28 12:59:02	1.5
@@ -1,11 +1,13 @@
 drop sequence filenum;
 drop sequence symnum;
+drop sequence declnum;
 drop table files;
 drop table symbols;
 drop table indexes;
 drop table releases;
 drop table usage;
 drop table status;
+drop table declarations;
 
 create sequence filenum cache 50;
 create sequence symnum cache 50;
@@ -28,13 +30,21 @@
 
 );
 
+create table declarations (
+	declid     	smallint not null,
+	langid		smallint not null,
+	declaration	char(255) not null,
+	primary key (declid, langid)
+); 
+
 create table indexes (
 	symid		int		references symbols,
 	fileid		int		references files,
 	line		int,
-	langid		tinyint not null references declarations,
-	type		smallint not null references declarations,
-	relsym		int		references symbols
+	langid		smallint not null,
+	type		smallint not null,
+	relsym		int		references symbols,
+	foreign key (langid, type) references declarations (langid, declid)
 );
 
 create table releases 
@@ -54,12 +64,6 @@
 	status		smallint,
 	primary key	(fileid)
 );
-create table declarations
-	(declid     smallint not null,
-	langid		tinyint not null,
-	declaration	char(255) not null,
-	primary key (declid, langid)
-); 
 
 create index indexindex on indexes using btree (symid);
 create index symbolindex on symbols using btree (symname);
@@ -72,4 +76,4 @@
 grant select on releases to public;
 grant select on usage to public;
 grant select on status to public;
-
+grant select on declarations to public;
\ No newline at end of file