Changeset 2694

Timestamp:

02/15/06 14:50:23 (19 years ago)

Author:

matt

Message:

Make the quota table IDs INT8 (bigint) so that we never run out if there get to be lots of printers and/or users

Files:

• pykota/trunk/initscripts/mysql/pykota-mysql.sql (modified) (2 diffs)

pykota/trunk/initscripts/mysql/pykota-mysql.sql

@@ -78 +78 @@
 -- Create the print quota table for users
 --
-CREATE TABLE userpquota (id INT4 PRIMARY KEY NOT NULL AUTO_INCREMENT,
+CREATE TABLE userpquota (id INT8 PRIMARY KEY NOT NULL AUTO_INCREMENT,
                         userid INT4, 
                         printerid INT4, 
@@ -128 +128 @@
 -- Create the print quota table for groups
 --
-CREATE TABLE grouppquota(id INT4 PRIMARY KEY NOT NULL AUTO_INCREMENT,
+CREATE TABLE grouppquota(id INT8 PRIMARY KEY NOT NULL AUTO_INCREMENT,
                          groupid INT4, 
                          printerid INT4,