Changeset 2342 for pykota/trunk/initscripts

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.

Location:

pykota/trunk/initscripts/postgresql

Files:

• pykota-postgresql.sql (modified) (1 diff)
• upgrade-to-1.23.sql (modified) (2 diffs)

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

@@ -171 +171 @@
 --
 CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL,
-                           label TEXT UNIQUE NOT NULL,
+                           billingcode TEXT UNIQUE NOT NULL,
                            description TEXT,
                            balance FLOAT DEFAULT 0.0,

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

@@ -58 +58 @@
                            balance FLOAT DEFAULT 0.0,
                            pagecounter INT4 DEFAULT 0);
+ALTER TABLE billingcodes RENAME COLUMN label TO billingcode;
 
 REVOKE ALL ON billingcodes FROM public;                        
@@ -64 +65 @@
 GRANT SELECT, UPDATE ON billingcodes_id_seq TO pykotaadmin;
 GRANT SELECT ON billingcodes TO pykotauser;
+
+