X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.7;h=db654ca5d9035d2f283c9ff2549d04d55f775fb2;hp=59699e97139b5e36c8b78cab0265f2790238229a;hb=c2146ae32fdef80049abfa13098db2d45f3ebdd5;hpb=71d7d7881aa44061b9dac239d539e5ed3340e8a6 diff --git a/README.1.5.7 b/README.1.5.7 index 59699e971..db654ca5d 100644 --- a/README.1.5.7 +++ b/README.1.5.7 @@ -87,8 +87,7 @@ ALTER TABLE h_prepay_credit ADD agentnum integer NULL; ALTER TABLE type_pkgs ADD typepkgnum int; ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('public.type_pkgs_typepkgnum_seq'::text); CREATE SEQUENCE type_pkgs_typepkgnum_seq; -UPDATE type_pkgs SET typepkgnum = nextval('public.type_pkgs_typepkgnum_seq'::tex -t) WHERE typepkgnum IS NULL; +UPDATE type_pkgs SET typepkgnum = nextval('public.type_pkgs_typepkgnum_seq'::text) WHERE typepkgnum IS NULL; ALTER TABLE type_pkgs ALTER typepkgnum SET NOT NULL; ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum); ALTER TABLE h_type_pkgs ADD typepkgnum int; @@ -96,8 +95,7 @@ ALTER TABLE h_type_pkgs ADD typepkgnum int; ALTER TABLE cust_bill_pkg ADD billpkgnum int; ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('public.cust_bill_pkg_billpkgnum_seq'::text); CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq; -UPDATE cust_bill_pkg SET billpkgnum = nextval('public.cust_bill_pkg_billpkgnum_s -eq'::text) WHERE billpkgnum IS NULL; +UPDATE cust_bill_pkg SET billpkgnum = nextval('public.cust_bill_pkg_billpkgnum_seq'::text) WHERE billpkgnum IS NULL; ALTER TABLE cust_bill_pkg ALTER billpkgnum SET NOT NULL; ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum); ALTER TABLE h_cust_bill_pkg ADD billpkgnum int; @@ -105,8 +103,7 @@ ALTER TABLE h_cust_bill_pkg ADD billpkgnum int; ALTER TABLE pkg_svc ADD pkgsvcnum int; ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('public.pkg_svc_pkgsvcnum_seq'::text); CREATE SEQUENCE pkg_svc_pkgsvcnum_seq; -UPDATE pkg_svc SET pkgsvcnum = nextval('public.pkg_svc_pkgsvcnum_seq'::text) WHE -RE pkgsvcnum IS NULL; +UPDATE pkg_svc SET pkgsvcnum = nextval('public.pkg_svc_pkgsvcnum_seq'::text) WHERE pkgsvcnum IS NULL; ALTER TABLE pkg_svc ALTER pkgsvcnum SET NOT NULL; ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum); ALTER TABLE h_pkg_svc ADD pkgsvcnum int; @@ -114,8 +111,7 @@ ALTER TABLE h_pkg_svc ADD pkgsvcnum int; ALTER TABLE part_svc_router ADD svcrouternum int; ALTER TABLE part_svc_router ALTER COLUMN svcrouternum SET DEFAULT nextval('public.part_svc_router_svcrouternum_seq'::text); CREATE SEQUENCE part_svc_router_svcrouternum_seq; -UPDATE part_svc_router SET svcrouternum = nextval('public.part_svc_router_svcrou -ternum_seq'::text) WHERE svcrouternum IS NULL; +UPDATE part_svc_router SET svcrouternum = nextval('public.part_svc_router_svcrouternum_seq'::text) WHERE svcrouternum IS NULL; ALTER TABLE part_svc_router ALTER svcrouternum SET NOT NULL; ALTER TABLE part_svc_router ADD PRIMARY KEY (svcrouternum); ALTER TABLE h_part_svc_router ADD svcrouternum int; @@ -142,8 +138,15 @@ Installs w/integrated RT: CREATE INDEX Attributes1 on Attributes(Name); CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); + Add these lines to /opt/rt3/etc/RT_SiteConfig.pm (before the "1;"): + $RT::URI::freeside::IntegrationType = 'Internal'; + $RT::URI::freeside::URL = 'http://path/to/your/freeside/'; + Set($DatabaseHost , ''); -(make sure you have upgrade DBIx::DBSchema to 0.24) +(End of Installs w/integrated RT) + + +(make sure you have upgraded DBIx::DBSchema to 0.26) dbdef-create username create-history-tables username rate rate_detail rate_region rate_prefix reg_code reg_code_pkg dbdef-create username