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

Timestamp:

04/14/03 21:58:59 (22 years ago)

Author:

jalet

Message:

New database schema for users' account balance

Files:

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

pykota/trunk/initscripts/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.11  2003/04/14 19:58:59  jalet
+-- New database schema for users' account balance
+--
 -- Revision 1.10  2003/04/10 21:47:20  jalet
 -- Job history added. Upgrade script neutralized for now !
@@ -84 +87 @@
 --
 CREATE TABLE users(id SERIAL PRIMARY KEY NOT NULL,
-                   username TEXT UNIQUE NOT NULL);
+                   username TEXT UNIQUE NOT NULL,
+                   balance FLOAT DEFAULT 0.0,
+                   lieftimepaid FLOAT DEFAULT 0.0,
+                   limitby TEXT DEFAULT 'quota');
                    
 --
@@ -96 +102 @@
 --
 CREATE TABLE printers(id SERIAL PRIMARY KEY NOT NULL,
-                      printername TEXT UNIQUE NOT NULL);
+                      printername TEXT UNIQUE NOT NULL,
+                      priceperpage FLOAT DEFAULT 0.0,
+                      priceperjob FLOAT DEFAULT 0.0);
                     
 --