MediaWiki/archive/extensions/Special/SiteSubscribe/tables

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MediaWiki‎ | archive‎ | extensions‎ | Special‎ | SiteSubscribe
Revision as of 11:30, 3 April 2009 by Woozle (talk | contribs) (extracted from main SiteSubscribe page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

<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>

ssub_subscrs

About

Subscription status

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>

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

<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>

ssub_post_line

About

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

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>