From: ivan Date: Fri, 21 Jun 2002 08:29:42 +0000 (+0000) Subject: uid search on main menu, updated upgrade docs X-Git-Tag: freeside_1_4_0_beta1~79 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=fb98e91566e72bc3adb823b706529002af487c09;ds=sidebyside uid search on main menu, updated upgrade docs --- diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index b0d1e3fe2..11b80e390 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -7,7 +7,7 @@
  • If migrating from less than 1.3.1, see these instructions first.
  • Backup your database and current Freeside installation. (with PostgreSQL) (with MySQL)
  • mod_perl is now required. -
  • Install Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers. +
  • Install Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers (minimum version 0.02).
  • Install Apache::ASP or HTML::Mason.
  • Install rsync @@ -216,6 +216,7 @@ CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( taxnum, year, month ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; +ALTER TABLE cust_main ADD comments text NULL; ALTER TABLE cust_pay ADD custnum integer; ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; @@ -276,7 +277,6 @@ CREATE UNIQUE INDEX svc_acct_pop_pkey ON svc_acct_pop ( popnum ); CREATE UNIQUE INDEX svc_acct_sm_pkey ON svc_acct_sm ( svcnum ); CREATE UNIQUE INDEX svc_domain_pkey ON svc_domain ( svcnum ); CREATE UNIQUE INDEX svc_www_pkey ON svc_www ( svcnum ); -CREATE UNIQUE INDEX type_pkgs_pkey ON type_pkgs ( typenum );
  • If you wish to enable service/shipping addresses, apply the following changes to your database: @@ -294,23 +294,18 @@ ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL; ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL; -CREATE INDEX cust_main1 ON cust_main ( ship_last ); -CREATE INDEX cust_main2 ON cust_main ( ship_company ); - -
  • If you wish to enable customer comments, apply the following change to - your database: -
    -ALTER TABLE cust_main ADD COLUMN comments text NULL;
+CREATE INDEX cust_main4 ON cust_main ( ship_last );
+CREATE INDEX cust_main5 ON cust_main ( ship_company );
  • If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x. -
  • Run bin/dbdef-create. +
  • Run bin/dbdef-create username
  • If you have svc_acct_sm records or service definitions: -
  • Run bin/fs-migrate-payref -
  • Run bin/fs-migrate-part_svc +
  • Run bin/fs-migrate-payrefusername +
  • Run bin/fs-migrate-part_svcusername
  • After running bin/fs-migrate-payref, apply the following changes to your database:
    PostgreSQLMySQL, others
    @@ -322,9 +317,10 @@ CREATE TABLE cust_pay_temp ( _date int null, payby char(4) not null, payinfo varchar(16) null, - paybatch varchar(80) null + paybatch varchar(80) null, + closed char(1) null ); -INSERT INTO cust_pay_temp SELECT * from cust_pay; +INSERT INTO cust_pay_temp SELECT paynum, custnum, paid, _date, payby, payinfo, paybatch, closed FROM cust_pay; DROP TABLE cust_pay; ALTER TABLE cust_pay_temp RENAME TO cust_pay; CREATE UNIQUE INDEX cust_pay1 ON cust_pay (paynum); @@ -337,9 +333,10 @@ CREATE TABLE cust_refund_temp ( reason varchar(80) not null, payby char(4) not null, payinfo varchar(16) null, - paybatch varchar(80) null + paybatch varchar(80) null, + closed char(1) null ); -INSERT INTO cust_refund_temp SELECT * from cust_refund; +INSERT INTO cust_refund_temp SELECT refundnum, custnum, _date, refund, otaker, reason, payby, payinfo, '', closed from cust_refund; DROP TABLE cust_refund; ALTER TABLE cust_refund_temp RENAME TO cust_refund; CREATE UNIQUE INDEX cust_refund1 ON cust_refund (refundnum); @@ -350,16 +347,11 @@ ALTER TABLE cust_pay DROP COLUMN invnum; ALTER TABLE cust_refund DROP COLUMN crednum;
    -
  • IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again. -
  • IMPORTANT: run bin/create-history-tables -
  • IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create again. -
  • As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog, passing the username of a Freeside user you c -reated above: -
    -$ su freeside
-$ bin/populate-msgcat username
-
    +
  • IMPORTANT: After applying the second set of database changes, run bin/dbdef-create username again. +
  • IMPORTANT: run bin/create-history-tables username +
  • IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create username again. +
  • As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog
  • set the user_policy configuration value as appropriate for your site.
  • set the locale configuration value to en_US.
  • the mxmachines, nsmachines, arecords and cnamerecords configuration values have been deprecated. Set the defaultrecords configuration value instead. diff --git a/httemplate/index.html b/httemplate/index.html index 8710b1798..29dd3b471 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -32,7 +32,7 @@
    Company or all customers by company
    Phone #
    -
    Username or all accounts by username
    +
    Username or all accounts by username or uid

    Domain or all domains