diff options
Diffstat (limited to 'htdocs/docs')
-rw-r--r-- | htdocs/docs/schema.html | 10 | ||||
-rw-r--r-- | htdocs/docs/signup.html | 3 | ||||
-rw-r--r-- | htdocs/docs/upgrade5.html | 7 |
3 files changed, 17 insertions, 3 deletions
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html index 92965d795..3eea6f69d 100644 --- a/htdocs/docs/schema.html +++ b/htdocs/docs/schema.html @@ -154,8 +154,8 @@ </ul> <li><a name="part_referral">part_referral</a> - Referral listing <ul> - <li>refnum</li> - primary key - <li>referral</li> - referral + <li>refnum - primary key + <li>referral - referral </ul> <li><a name="part_svc">part_svc</a> - Service definitions <ul> @@ -176,6 +176,12 @@ <li>svcpart - <a href="#part_svc">Service definition</a> <li>quantity - quantity of this service that this package includes </ul> + <li><a name="prepay_credit">prepay_credit</a> + <ul> + <li>prepaynum - primary key + <li>identifier - text or numeric string used to receive this credit + <li>amount - amount of credit + </ul> <li><a name="svc_acct">svc_acct</a> - Accounts <ul> <li>svcnum - <a href="#cust_svc">primary key</a> diff --git a/htdocs/docs/signup.html b/htdocs/docs/signup.html index a00995994..c78d1362c 100644 --- a/htdocs/docs/signup.html +++ b/htdocs/docs/signup.html @@ -41,6 +41,7 @@ Optional: <li>$password <li>$email_name - first and last name </ul> -(an example file is included as <b>fs_signup/ieak.template</b>) + (an example file is included as <b>fs_signup/ieak.template</b>) + <li>If there are any entries in the <i>prepay_credit</i> table, a user can enter a string matching the <b>identifier</i> column to receive the credit specified in the <b>amount</b> column, after which that <b>identifier</b> is no longer valid. This can be used to implement pre-paid "calling card" type signups. </ul> </body> diff --git a/htdocs/docs/upgrade5.html b/htdocs/docs/upgrade5.html index 82a7602a3..fc4bf2c39 100644 --- a/htdocs/docs/upgrade5.html +++ b/htdocs/docs/upgrade5.html @@ -12,6 +12,13 @@ <li>Apply the following changes to your database: <pre> ALTER TABLE svc_acct_pop ADD loc CHAR(4); +CREATE TABLE prepay_credit ( + prepaynum int NOT NULL, + identifier varchar(80) NOT NULL, + amount decimal(10,2) NOT NULL, + PRIMARY KEY (prepaynum), + INDEX (identifier) +); </pre> <li>Copy or symlink htdocs to the new copy. <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS. |