Changeset 2318 for pykota/trunk/initscripts/postgresql

Timestamp:

06/17/05 09:03:19 (19 years ago)

Author:

jerome

Message:

I forgot the description attribute for billing codes...
Severity : I'm severely stupid !

Location:

pykota/trunk/initscripts/postgresql

Files:

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

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

@@ -172 +172 @@
 CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL,
                            label TEXT UNIQUE NOT NULL,
+                           description TEXT,
                            balance FLOAT DEFAULT 0.0,
                            pagecounter INT4 DEFAULT 0);

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

@@ -55 +55 @@
 CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL,
                            label TEXT UNIQUE NOT NULL,
+                           description TEXT,
                            balance FLOAT DEFAULT 0.0,
                            pagecounter INT4 DEFAULT 0);