Changeset 2037 for pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

Timestamp:

01/23/05 11:58:22 (19 years ago)

Author:

jalet

Message:

Added a few indexes for the database

Files:

• pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) (3 diffs)

pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.15  2005/01/23 10:58:22  jalet
+-- Added a few indexes for the database
+--
 -- Revision 1.14  2005/01/17 08:44:24  jalet
 -- Modified copyright years
@@ -133 +136 @@
                         datelimit TIMESTAMP,
                         warned INT4 DEFAULT 0); -- not a boolean, will help stats
+CREATE INDEX userpquota_u_id_ix ON userpquota (userid);
+CREATE INDEX userpquota_p_id_ix ON userpquota (printerid);
 CREATE UNIQUE INDEX userpquota_up_id_ix ON userpquota (userid, printerid);
                         
@@ -157 +162 @@
                         jobdate TIMESTAMP DEFAULT now(),
                         CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid));
+CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid);
 CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid);
 CREATE INDEX jobhistory_pd_id_ix ON jobhistory (printerid, jobdate);