Changeset 1994 for pykota/trunk/initscripts

Timestamp:

12/23/04 19:40:18 (20 years ago)

Author:

jalet

Message:

Added the coefficient table, and many columns to existing tables

Files:

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

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

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.12  2004/12/23 18:40:18  jalet
+-- Added the coefficient table, and many columns to existing tables
+--
 -- Revision 1.11  2004/06/20 16:15:21  jalet
 -- Added "description" attribute for printers
@@ -93 +96 @@
                    balance FLOAT DEFAULT 0.0,
                    lifetimepaid FLOAT DEFAULT 0.0,
-                   limitby TEXT DEFAULT 'quota');
+                   limitby TEXT DEFAULT 'quota',
+                   coefficient FLOAT NOT NULL DEFAULT 1.0);
                    
 --
@@ -121 +125 @@
                         softlimit INT4,
                         hardlimit INT4,
-                        datelimit TIMESTAMP);
+                        datelimit TIMESTAMP,
+                        warned INT4 DEFAULT 0); -- not a boolean, will help stats
 CREATE UNIQUE INDEX userpquota_up_id_ix ON userpquota (userid, printerid);
                         
@@ -141 +146 @@
                         options TEXT,
                         hostname TEXT,
+                        md5sum TEXT,
+                        pages TEXT,
                         jobdate TIMESTAMP DEFAULT now(),
                         CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid));
@@ -180 +187 @@
 CREATE INDEX payments_date_ix ON payments (date);
 
+-- 
+-- Create the table for coefficients wrt paper sizes and the like
+--
+CREATE TABLE coefficients (id SERIAL PRIMARY KEY NOT NULL, 
+                           printerid INTEGER NOT NULL REFERENCES printers(id), 
+                           label TEXT NOT NULL, 
+                           coefficient FLOAT NOT NULL DEFAULT 1.0, 
+                           CONSTRAINT coeffconstraint UNIQUE (printerid, label));
+
 --                        
 -- Set some ACLs                        
@@ -186 +202 @@
 REVOKE ALL ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq, payments_id_seq FROM public;
 
-GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, printergroupsmembers, jobhistory, payments TO pykotaadmin;
-GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq, payments_id_seq TO pykotaadmin;
-GRANT SELECT ON users, groups, printers, userpquota, grouppquota, groupsmembers, printergroupsmembers, jobhistory, payments TO pykotauser;
-
+GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, printergroupsmembers, jobhistory, payments, coefficients TO pykotaadmin;
+GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq, payments_id_seq, coefficients_id_seq TO pykotaadmin;
+GRANT SELECT ON users, groups, printers, userpquota, grouppquota, groupsmembers, printergroupsmembers, jobhistory, payments, coefficients TO pykotauser;
+