MDL-69166 pg_paypal: Process after payment
[moodle.git] / payment / gateway / paypal / db / install.xml
CommitLineData
16099e40
SR
1<?xml version="1.0" encoding="UTF-8" ?>
2<XMLDB PATH="payment/gateway/paypal/db" VERSION="20200110" COMMENT="XMLDB file for PayPal payment gateway plugin"
3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4 xsi:noNamespaceSchemaLocation="../../../../lib/xmldb/xmldb.xsd"
5>
6 <TABLES>
7 <TABLE NAME="pg_paypal" COMMENT="Stores PayPal related information">
8 <FIELDS>
9 <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
10 <FIELD NAME="paymentid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
11 <FIELD NAME="pp_orderid" TYPE="char" LENGTH="255" NOTNULL="true" DEFAULT="The ID of the order in PayPal" SEQUENCE="false"/>
12 <FIELD NAME="pp_authorizationid" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
13 <FIELD NAME="pp_paymentid" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false" COMMENT="The PayPal-generated ID for the captured payment."/>
14 <FIELD NAME="pp_status" TYPE="char" LENGTH="32" NOTNULL="false" SEQUENCE="false"/>
15 </FIELDS>
16 <KEYS>
17 <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
18 <KEY NAME="paymentid" TYPE="foreign-unique" FIELDS="paymentid" REFTABLE="payment" REFFIELDS="id"/>
19 </KEYS>
20 </TABLE>
21 </TABLES>
22</XMLDB>