[Lxr-commits] CVS: lxr initdb-postgres,1.6,1.7
Brought to you by:
ajlittoz
From: Jan-Benedict G. <jb...@us...> - 2006-12-20 19:54:34
|
Update of /cvsroot/lxr/lxr In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv2122 Modified Files: initdb-postgres Log Message: Cleanly indent the initdb-postgres SQL script. Index: initdb-postgres =================================================================== RCS file: /cvsroot/lxr/lxr/initdb-postgres,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- initdb-postgres 20 Jul 2004 15:31:24 -0000 1.6 +++ initdb-postgres 20 Dec 2006 19:54:31 -0000 1.7 @@ -19,7 +19,6 @@ fileid int, primary key (fileid), unique (filename, revision) - ); create table lxr_symbols ( @@ -27,15 +26,14 @@ symid int, primary key (symid), unique (symname) - ); create table lxr_declarations ( - declid smallint not null, + declid smallint not null, langid smallint not null, declaration char(255) not null, - primary key (declid, langid) -); + primary key (declid, langid) +); create table lxr_indexes ( symid int references lxr_symbols, @@ -44,10 +42,10 @@ langid smallint not null, type smallint not null, relsym int references lxr_symbols, - foreign key (langid, type) references lxr_declarations (langid, declid) + foreign key (langid, type) references lxr_declarations (langid, declid) ); -create table lxr_releases +create table lxr_releases (fileid int references lxr_files, release varchar, primary key (fileid,release) @@ -76,4 +74,4 @@ grant select on lxr_releases to public; grant select on lxr_usage to public; grant select on lxr_status to public; -grant select on lxr_declarations to public; \ No newline at end of file +grant select on lxr_declarations to public; |