Changeset 1556 for pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql

Timestamp:

06/20/04 18:15:21 (20 years ago)

Author:

jalet

Message:

Added "description" attribute for printers

Files:

• pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql (modified) (2 diffs)

pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.3  2004/06/20 16:15:21  jalet
+-- Added "description" attribute for printers
+--
 -- Revision 1.2  2004/06/03 23:14:10  jalet
 -- Now stores the job's size in bytes in the database.
@@ -45 +48 @@
 -- Modify the old database schema
 --
+ALTER TABLE printers ADD COLUMN description TEXT;
 ALTER TABLE jobhistory ADD COLUMN jobsizebytes INT8;
 ALTER TABLE jobhistory ADD COLUMN hostname TEXT;