From: ivan Date: Sat, 26 Feb 2005 21:29:04 +0000 (+0000) Subject: less cracktastic version numbering X-Git-Tag: BEFORE_FINAL_MASONIZE~694 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=5ab9170358e085b26752d19a05b382680108384e;ds=sidebyside less cracktastic version numbering --- diff --git a/ANNOUNCE.1.5 b/ANNOUNCE.1.5 new file mode 100644 index 000000000..a28a19326 --- /dev/null +++ b/ANNOUNCE.1.5 @@ -0,0 +1,39 @@ +- broadband (dsl/wireless) tracking, etc etc +- Extended description on invoice for time/data charges +- Multiple, named taxes +- */*FIX +- extended reported and graphing +- integrated RT ticketing system +- one-time payments (in signup server too). DCRD and DCHK on-demand payment types +- credit report +- reseller interface + +1.5.0pre6: +- RADIUS session viewing +- Major updates for reseller interface +- Credit card and ACH refunds (w/supported processor module) +- Proper email payment receipts (not invoice copies) +- modular price plans, rewrote package add/edit page +- fixed up tax report - should be correct for edge cases with named taxes, + tax classes, etc. +- Documentation updates + +1.5.7: +- version numbering change, now even/odd like Perl or Linux +- fix bug that could cause mis-billing on upgrades! (new installs ok) +- updated install documentation +- historical late notice viewing in web interface +- VoIP billing for CDRs from RADIUS +- promotional codes for signup +- lots of RT integration, integrated RT upgraded to 3.2.2 +- one-time referral credits +- invoices now use history records (don't lose details) +- option to credit for remaining service upon cancel (peter bowen) +- one-time registration codes +- "selfservice_server-session_module" config value can be set to + "Cache::FileCache" on FreeBSD or elsewhere IPC::ShareLite has trouble. + +notyet (1.5.8?): +- account merging UI in exports (for example, to consolidate passwd files from + multiple servers) + diff --git a/ANNOUNCE.1.5.0 b/ANNOUNCE.1.5.0 deleted file mode 100644 index 507728c16..000000000 --- a/ANNOUNCE.1.5.0 +++ /dev/null @@ -1,36 +0,0 @@ -- broadband (dsl/wireless) tracking, etc etc -- Extended description on invoice for time/data charges -- Multiple, named taxes -- */*FIX -- extended reported and graphing -- integrated RT ticketing system -- one-time payments (in signup server too). DCRD and DCHK on-demand payment types -- credit report -- reseller interface - -1.5.0pre6: -- RADIUS session viewing -- Major updates for reseller interface -- Credit card and ACH refunds (w/supported processor module) -- Proper email payment receipts (not invoice copies) -- modular price plans, rewrote package add/edit page -- fixed up tax report - should be correct for edge cases with named taxes, - tax classes, etc. -- Documentation updates - -1.5.0pre7: -- fix bug that could cause mis-billing on upgrades! (new installs ok) -- update install documentation for 1.5 HTML::Mason or Apache::ASP install -- historical late notice viewing in web interface -- VoIP billing for CDRs from RADIUS -- promotional codes for signup -- lots of RT integration, integrated RT upgraded to 3.2.2 -- one-time referral credits -- invoices now use history records (don't lose details) -- option to credit for remaining service upon cancel (peter bowen) -- one-time registration codes - -notyet (1.5.0pre8?): -- account merging UI in exports (for example, to consolidate passwd files from - multiple servers) - diff --git a/README.1.5.0pre7 b/README.1.5.0pre7 deleted file mode 100644 index 67554c8d3..000000000 --- a/README.1.5.0pre7 +++ /dev/null @@ -1,109 +0,0 @@ -CREATE TABLE rate ( - ratenum serial NOT NULL, - ratename varchar(80) NOT NULL, - PRIMARY KEY (ratenum) -); - -CREATE TABLE rate_detail ( - ratenum int NOT NULL, - orig_regionnum int NULL, - dest_regionnum int NOT NULL, - min_included int NOT NULL, - min_charge decimal(10,2) NOT NULL, - sec_granularity int NOT NULL -); -CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum ); - -CREATE TABLE rate_region ( - regionnum serial NOT NULL, - regionname varchar(80) NOT NULL, - PRIMARY KEY (regionnum) -); - -CREATE TABLE rate_prefix ( - prefixnum serial NOT NULL, - regionnum int NOT NULL, - countrycode varchar(3) NOT NULL, - npa varchar(6) NULL, - nxx varchar(3) NULL, - PRIMARY KEY (prefixnum) -); -CREATE INDEX rate_prefix1 ON rate_prefix ( countrycode ); -CREATE INDEX rate_prefix2 ON rate_prefix ( regionnum ); - -CREATE TABLE reg_code ( - codenum serial NOT NULL, - code varchar(80) NOT NULL, - agentnum int NOT NULL, - PRIMARY KEY (codenum) -); -CREATE UNIQUE INDEX reg_code1 ON reg_code ( agentnum, code ); -CREATE INDEX reg_code2 ON reg_code ( agentnum ); - -CREATE TABLE reg_code_pkg ( - codenum int NOT NULL, - pkgpart int NOT NULL -); -CREATE UNIQUE INDEX reg_code_pkg1 ON reg_code_pkg ( codenum, pkgpart ); -CREATE INDEX reg_code_pkg2 ON reg_code_pkg ( codenum ); - -CREATE TABLE clientapi_session ( - sessionnum serial NOT NULL, - sessionid varchar(80) NOT NULL, - namespace varchar(80) NOT NULL, - PRIMARY KEY (sessionnum) -); -CREATE UNIQUE INDEX clientapi_session1 ON clientapi_session ( sessionid, namespace ); - -CREATE TABLE clientapi_session_field ( - fieldnum serial NOT NULL, - sessionnum int NOT NULL, - fieldname varchar(80) NOT NULL, - fieldvalue text NULL, - PRIMARY KEY (fieldnum) -); -CREATE UNIQUE INDEX clientapi_session_field1 ON clientapi_session_field ( sessionnum, fieldname ); - -ALTER TABLE part_pkg ADD promo_code varchar(80) NULL; -ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL; -CREATE INDEX part_pkg2 ON part_pkg ( promo_code ); -CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); - -ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL; -ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL; - -Installs w/integrated RT: - CREATE SEQUENCE attributes_id_seq; - - CREATE TABLE Attributes ( - id INTEGER DEFAULT nextval('attributes_id_seq'), - Name varchar(255) NOT NULL , - Description varchar(255) NULL , - Content text, - ContentType varchar(16), - ObjectType varchar(64), - ObjectId integer, -- foreign key to anything - Creator integer NOT NULL DEFAULT 0 , - Created TIMESTAMP NULL , - LastUpdatedBy integer NOT NULL DEFAULT 0 , - LastUpdated TIMESTAMP NULL , - PRIMARY KEY (id) - - ); - - CREATE INDEX Attributes1 on Attributes(Name); - CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); - - -dbdef-create username -create-history-tables username rate rate_detail rate_region rate_prefix reg_code reg_code_pkg -dbdef-create username - -install Javascript::RPC (JavaScript::RPC::Server::CGI) - -afterwords (for installs w/integrated RT): -make configure-rt -make deploy -/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.15 -/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.17 - diff --git a/README.1.5.7 b/README.1.5.7 new file mode 100644 index 000000000..ff70961b3 --- /dev/null +++ b/README.1.5.7 @@ -0,0 +1,114 @@ +NOTE: Version numbering has been simplified. 1.5.7 is the version after +1.5.0pre6. It is still a development version - releases with odd numbered +middle parts (NN in x.NN.x) are development versions, like Perl or Linux. + + +CREATE TABLE rate ( + ratenum serial NOT NULL, + ratename varchar(80) NOT NULL, + PRIMARY KEY (ratenum) +); + +CREATE TABLE rate_detail ( + ratenum int NOT NULL, + orig_regionnum int NULL, + dest_regionnum int NOT NULL, + min_included int NOT NULL, + min_charge decimal(10,2) NOT NULL, + sec_granularity int NOT NULL +); +CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum ); + +CREATE TABLE rate_region ( + regionnum serial NOT NULL, + regionname varchar(80) NOT NULL, + PRIMARY KEY (regionnum) +); + +CREATE TABLE rate_prefix ( + prefixnum serial NOT NULL, + regionnum int NOT NULL, + countrycode varchar(3) NOT NULL, + npa varchar(6) NULL, + nxx varchar(3) NULL, + PRIMARY KEY (prefixnum) +); +CREATE INDEX rate_prefix1 ON rate_prefix ( countrycode ); +CREATE INDEX rate_prefix2 ON rate_prefix ( regionnum ); + +CREATE TABLE reg_code ( + codenum serial NOT NULL, + code varchar(80) NOT NULL, + agentnum int NOT NULL, + PRIMARY KEY (codenum) +); +CREATE UNIQUE INDEX reg_code1 ON reg_code ( agentnum, code ); +CREATE INDEX reg_code2 ON reg_code ( agentnum ); + +CREATE TABLE reg_code_pkg ( + codenum int NOT NULL, + pkgpart int NOT NULL +); +CREATE UNIQUE INDEX reg_code_pkg1 ON reg_code_pkg ( codenum, pkgpart ); +CREATE INDEX reg_code_pkg2 ON reg_code_pkg ( codenum ); + +CREATE TABLE clientapi_session ( + sessionnum serial NOT NULL, + sessionid varchar(80) NOT NULL, + namespace varchar(80) NOT NULL, + PRIMARY KEY (sessionnum) +); +CREATE UNIQUE INDEX clientapi_session1 ON clientapi_session ( sessionid, namespace ); + +CREATE TABLE clientapi_session_field ( + fieldnum serial NOT NULL, + sessionnum int NOT NULL, + fieldname varchar(80) NOT NULL, + fieldvalue text NULL, + PRIMARY KEY (fieldnum) +); +CREATE UNIQUE INDEX clientapi_session_field1 ON clientapi_session_field ( sessionnum, fieldname ); + +ALTER TABLE part_pkg ADD promo_code varchar(80) NULL; +ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL; +CREATE INDEX part_pkg2 ON part_pkg ( promo_code ); +CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); + +ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL; +ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL; + +Installs w/integrated RT: + CREATE SEQUENCE attributes_id_seq; + + CREATE TABLE Attributes ( + id INTEGER DEFAULT nextval('attributes_id_seq'), + Name varchar(255) NOT NULL , + Description varchar(255) NULL , + Content text, + ContentType varchar(16), + ObjectType varchar(64), + ObjectId integer, -- foreign key to anything + Creator integer NOT NULL DEFAULT 0 , + Created TIMESTAMP NULL , + LastUpdatedBy integer NOT NULL DEFAULT 0 , + LastUpdated TIMESTAMP NULL , + PRIMARY KEY (id) + + ); + + CREATE INDEX Attributes1 on Attributes(Name); + CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); + + +dbdef-create username +create-history-tables username rate rate_detail rate_region rate_prefix reg_code reg_code_pkg +dbdef-create username + +install Javascript::RPC (JavaScript::RPC::Server::CGI) + +afterwords (for installs w/integrated RT): +make configure-rt +make deploy +/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.15 +/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.17 +