Woozle: Woozle moved page MediaWiki/Special/SiteSubscribe/tables to MediaWiki/archive/extensions/Special/SiteSubscribe/tables without leaving a redirect: obsolete, but may contain useful bits

2017-12-15T00:23:01Z

Woozle moved page MediaWiki/Special/SiteSubscribe/tables to MediaWiki/archive/extensions/Special/SiteSubscribe/tables without leaving a redirect: obsolete, but may contain useful bits

← Older revision	Revision as of 00:23, 15 December 2017
(No difference)

Woozle: extracted from main SiteSubscribe page

2009-04-03T11:30:26Z

extracted from main SiteSubscribe page

New page

==ssub_paymts==
===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===
<section begin=sql /><mysql>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;</mysql>
<section end=sql />
==ssub_subscrs==
===About===
Subscription status
===SQL===
<section begin=sql /><mysql>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;</mysql>
<section end=sql />
==ssub_post==
===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===
<section begin=sql /><mysql>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;</mysql>
<section end=sql />
==ssub_post_line==
===About===
* '''Purpose''': Data received via POST - child of ssub_post
* '''History''':
** '''2009-02-15''' Created
===SQL===
<section begin=sql /><mysql>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;</mysql>
<section end=sql />

MediaWiki/archive/extensions/Special/SiteSubscribe/tables - Revision history

Woozle: Woozle moved page MediaWiki/Special/SiteSubscribe/tables to MediaWiki/archive/extensions/Special/SiteSubscribe/tables without leaving a redirect: obsolete, but may contain useful bits

Woozle: extracted from main SiteSubscribe page