Show
Ignore:
Timestamp:
07/06/05 20:11:00 (19 years ago)
Author:
jerome
Message:

The pkbcodes command line tool now works fine with the PostgreSQL
backend. The dumpykota command can now dump billing codes too.
Still no code for LDAP though.
NB : a database upgrade is necessary AGAIN !
Severity : no need to play with this until there's LDAP support.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

    r2318 r2342  
    171171-- 
    172172CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL, 
    173                            label TEXT UNIQUE NOT NULL, 
     173                           billingcode TEXT UNIQUE NOT NULL, 
    174174                           description TEXT, 
    175175                           balance FLOAT DEFAULT 0.0,