diff options
| author | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
| commit | 69a0a7504f84aa9bb1f204d1f3522e1520e0885e (patch) | |
| tree | de4cb175a70c7a7da58f84454fd29dfca55bd249 /README.1.4.0pre3-4 | |
| parent | e3f87d761538a0a21d26fc86b5bce7c9d737d590 (diff) | |
more schema changes: part_bill_event and cust_bill_event tables
remove old 1.4.0pre READMEs
Diffstat (limited to 'README.1.4.0pre3-4')
| -rw-r--r-- | README.1.4.0pre3-4 | 23 |
1 files changed, 0 insertions, 23 deletions
diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4 deleted file mode 100644 index 0027d3450..000000000 --- a/README.1.4.0pre3-4 +++ /dev/null @@ -1,23 +0,0 @@ -the following is necessary to upgrade from 1.4.0pre3 to pre4 or later. - -install the perl modules and httemplate as per install.html or upgrade8.html - -CREATE TABLE part_pop_local ( - localnum int primary key, - popnum int not null, - city varchar(80) null, - state char(2) null, - npa char(3) not null, - nxx char(3) not null -); -CREATE INDEX part_pop_local1 ON part_pop_local ( npa, nxx ); -ALTER TABLE cust_pkg ADD manual_flag char(1) NULL; -ALTER TABLE cust_pay_batch ADD paybatchnum integer; -CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum ); -ALTER TABLE part_pkg ADD plan varchar NULL; -ALTER TABLE part_pkg ADD plandata varchar NULL; -ALTER TABLE part_pkg ADD setuptax char(1) NULL; -ALTER TABLE part_pkg ADD recurtax char(1) NULL; - -Run bin/dbdef-create - |
