less cracktastic version numbering

diff --git a/ANNOUNCE.1.5 b/ANNOUNCE.1.5
new file mode 100644 (file)
index 0000000..a28a193
--- /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 (file)
index 507728c..0000000
--- 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 (file)
index 67554c8..0000000
--- 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 (file)
index 0000000..ff70961
--- /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
+