Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [KN_Online]
- GO
- /****** Object: Table [dbo].[STORE_TRANSACTIONS] Script Date: 02/13/2011 09:31:48 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[STORE_TRANSACTIONS](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [strClientIP] [varchar](15) NULL,
- [dDate] [datetime] NOT NULL,
- [strAccountID] [varchar](21) NOT NULL,
- [strCharID] [varchar](21) NOT NULL,
- [nKCPackage] [int] NOT NULL,
- [nKCAmount] [int] NOT NULL,
- [nPrice] [float] NOT NULL,
- [strProvider] [varchar](50) NOT NULL,
- [bStatus] [tinyint] NOT NULL,
- [payment_processed] [datetime] NULL,
- [payment_status] [varchar](255) NULL,
- [txn_id] [varchar](255) NULL,
- [receiver_id] [varchar](13) NULL,
- [residence_country] [varchar](2) NULL,
- [first_name] [varchar](64) NULL,
- [last_name] [varchar](64) NULL,
- [payer_email] [varchar](127) NULL,
- [payment_gross] [float] NULL,
- [payment_fee] [float] NULL,
- [pending_reason] [varchar](255) NULL,
- [payment_type] [varchar](20) NULL,
- [forum_username] [varchar](50) NULL
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement