[luxor] luxor totally broken on postgresql ... :(

[Marc G. Fournier]

Attached is an SQL file translation from the MySQL ... but, even with 
that, the mysql and pgsql both define a luxor_files, but when I go to the 
page, it seems to be trying to find a luxor_file table ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664
-------------- next part --------------
CREATE TABLE luxor_declarations (
  declid SERIAL,
  langid smallint NOT NULL default '0',
  declaration char(255) NOT NULL default ''
);

CREATE TABLE luxor_files (
  fileid SERIAL,
  source varchar(255) NOT NULL default '',
  filename varchar(255) NOT NULL default '',
  tag varchar(255) NOT NULL default '',
  lastmodified int NOT NULL default '0'
);
CREATE INDEX luxor_files_source ON luxor_files USING btree ( source );
CREATE INDEX luxor_files_tag ON luxor_files USING btree ( tag );
CREATE INDEX luxor_files_filename ON luxor_files USING btree ( filename );

CREATE TABLE luxor_indexes (
  symid int NOT NULL default '0',
  fileid int NOT NULL default '0',
  line int NOT NULL default '0',
  declid smallint NOT NULL default '0'
);
CREATE INDEX luxor_indexes_symid ON luxor_indexes USING btree ( symid );
CREATE INDEX luxor_indexes_fileid ON luxor_indexes USING btree ( fileid );
CREATE INDEX luxor_indexes_declid ON luxor_indexes USING btree ( declid );

CREATE TABLE luxor_status (
  fileid int NOT NULL default '0' PRIMARY KEY,
  status smallint  NOT NULL default '0'
);

CREATE TABLE luxor_symbols (
  symid SERIAL,
  symname varchar(255) NOT NULL default '',
  source varchar(255) NOT NULL default ''
);
CREATE INDEX luxor_symbols_symname ON luxor_symbols USING btree ( symname );
CREATE INDEX luxor_symbols_source ON luxor_symbols USING btree ( source );

CREATE TABLE luxor_usage (
  symid int NOT NULL default '0',
  fileid int NOT NULL default '0',
  line int NOT NULL default '0'
);
CREATE INDEX luxor_usage_symid ON luxor_usage USING btree ( symid );
CREATE INDEX luxor_usage_fileid ON luxor_usage USING btree ( fileid );