Changeset 2037
- Timestamp:
- 01/23/05 11:58:22 (20 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/pykota-postgresql.sql
r2028 r2037 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.15 2005/01/23 10:58:22 jalet 23 -- Added a few indexes for the database 24 -- 22 25 -- Revision 1.14 2005/01/17 08:44:24 jalet 23 26 -- Modified copyright years … … 133 136 datelimit TIMESTAMP, 134 137 warned INT4 DEFAULT 0); -- not a boolean, will help stats 138 CREATE INDEX userpquota_u_id_ix ON userpquota (userid); 139 CREATE INDEX userpquota_p_id_ix ON userpquota (printerid); 135 140 CREATE UNIQUE INDEX userpquota_up_id_ix ON userpquota (userid, printerid); 136 141 … … 157 162 jobdate TIMESTAMP DEFAULT now(), 158 163 CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid)); 164 CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid); 159 165 CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid); 160 166 CREATE INDEX jobhistory_pd_id_ix ON jobhistory (printerid, jobdate);