MediaWiki/archive/extensions/Special/SiteSubscribe/tables

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>