Login   Register  
PHP Classes
elePHPant
Icontem

File: global.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 1 year 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