MediaWiki/Special/SiteSubscribe/tables

About

 * Purpose: Log of payments received
 * Fields:
 * IDS_Trx: transaction ID assigned by processing service
 * i.e. at present, txn_id from PayPal
 * History:
 * 2009-02-23 Added IDS_Trx field
 * 2009-02-26 Added isTest field - same as ssub_post.isTest

SQL
CREATE TABLE `ssub_paymts` (   ID       INT          NOT NULL AUTO_INCREMENT,    ID_User  INT          NOT NULL COMMENT "user.user_id of user making the payment",    WhenRecd DATETIME     NOT NULL COMMENT "when the payment was received",    AmtRecd  DECIMAL(9,2) NOT NULL COMMENT "dollar amount received",    IDS_Trx  VARCHAR(63)  NOT NULL COMMENT "transaction ID from processing service",    isTest   BOOL         DEFAULT NULL COMMENT "TRUE = test transaction (sandbox), not a real payment",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;

About
Subscription status

SQL
CREATE TABLE `ssub_subscrs` (  ID_User  INT          NOT NULL COMMENT "user.user_id of user making the payment",   WhenExp  DATETIME     NOT NULL COMMENT "when the subscription expires",  PRIMARY KEY(`ID_User`) ) ENGINE = MYISAM;

About

 * Purpose: Http POSTs received by this extension -- partly for debugging, and partly as a fallback in case of technical problems or data loss
 * History:
 * 2009-02-15 Created
 * 2009-02-22 WhenRepl, isOkay fields
 * 2009-02-26 isTest field
 * Fields:
 * ConfText should be status text from PayPal - "VERIFIED" or "INVALID" - unless WhenRepl is NULL, in which case it is the http error message
 * isTest flags whether the post was from a PayPal Sandbox transaction (TRUE) or a regular transaction (FALSE), as determined by the test_ipn field in the POST data

SQL
CREATE TABLE `ssub_post` (  ID       INT          NOT NULL AUTO_INCREMENT,   RmtAddr  VARCHAR(15)  NOT NULL COMMENT "IP address of POST sender",   WhenRecd DATETIME     NOT NULL COMMENT "when the POST was received",   WhenConf DATETIME     DEFAULT NULL COMMENT "when a confirmation was sent back, if any",   WhenRepl DATETIME     DEFAULT NULL COMMENT "when a reply to the confirmation was received, if any",   isOkay   BOOL         DEFAULT NULL COMMENT "FALSE = reply was not received",   isTest   BOOL         DEFAULT NULL COMMENT "TRUE = sandbox transaction, for testing",   ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;

About

 * Purpose: Data received via POST - child of ssub_post
 * History:
 * 2009-02-15 Created

SQL
CREATE TABLE `ssub_post_line` (  ID_Post       INT          NOT NULL COMMENT "ssub_post.ID",   DataKey       VARCHAR(255) NOT NULL COMMENT "name of data item",   DataVal       VARCHAR(255) NOT NULL COMMENT "value of data item",  PRIMARY KEY(`ID_Post`,`DataKey`) ) ENGINE = MYISAM;