PHP Classes

File: global.sql

Recommend this page to a friend!
  Classes of Leigh Edwards  >  PHP GlobalPay API  >  global.sql  >  Download  
File: global.sql
Role: Auxiliary data
Content type: text/plain
Description: sql to create needed tables
Class: PHP GlobalPay API
Process credit card payments using GlobalPay
Author: By
Last change:
Date: 9 years ago
Size: 1,174 bytes
 

Contents

Class file image Download
CREATE TABLE [dbo].[global_transactions]( [transactionID] [int] IDENTITY(1,1) NOT NULL, [Ref] [int] NULL, [Invoice] [varchar](50) NULL, [Date] [datetime] NULL, [Result] [varchar](50) NULL, [PaymentType] [varchar](50) NULL, [AccountType] [varchar](50) NULL, [Account] [varchar](50) NULL, [Name] [varchar](50) NULL, [Type] [varchar](50) NULL, [Status] [varchar](128) NULL, [ApprovalCode] [varchar](50) NULL, [AuthAmt] [money] NULL, [ReqAmt] [money] NULL, [MerchantID] [int] NULL, [BatchNumber] [int] NULL, [ExtData] [varchar](1024) NULL, [UserName] [varchar](50) NULL ) ON [PRIMARY] CREATE TABLE [dbo].[global_merchants]( [id] [int] IDENTITY(1,1) NOT NULL, [merchant] [varchar](50) NOT NULL, [shortname] [varchar](4) NULL, [username] [varchar](50) NOT NULL, [password] [varchar](50) NOT NULL, [termType] [varchar](50) NULL, [RPNum] [varchar](50) NULL, [ResellerKey] [varchar](50) NULL, [SEC] [varchar](50) NULL ) ON [PRIMARY] CREATE TABLE [dbo].[global_void_lookup]( [id] [int] IDENTITY(1,1) NOT NULL, [PNRef] [varchar](50) NULL, [VoidedPNRef] [varchar](50) NULL ) ON [PRIMARY] SET ANSI_PADDING OFF GO