[PHP] Webmall with Paypal & IPN

/*
Navicat SQL Server Data Transfer

Source Server         : SQL
Source Server Version : 100000
Source Host           : localhost\SQLEXPRESS:1433
Source Database       : WebsiteDB
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 100000
File Encoding         : 65001

Date: 2016-02-13 07:54:26
*/


-- ----------------------------
-- Table structure for _donateItems
-- ----------------------------
DROP TABLE [dbo].[_donateItems]
GO
CREATE TABLE [dbo].[_donateItems] (
[itemname] varchar(50) NOT NULL ,
[itemCode] varchar(50) NOT NULL ,
[itemPrice] varchar(10) NULL ,
[itemImage] varchar(8000) NULL ,
[itemDescription] varchar(200) NOT NULL ,
[itemPlus] int NULL ,
[uniqueID] varchar(50) NULL ,
[quantity] varchar(50) NULL 
)


GO

-- ----------------------------
-- Table structure for _donateItemsLog
-- ----------------------------
DROP TABLE [dbo].[_donateItemsLog]
GO
CREATE TABLE [dbo].[_donateItemsLog] (
[id] int NOT NULL IDENTITY(1,1) ,
[username] varchar(50) NOT NULL ,
[txnID] varchar(50) NOT NULL ,
[PAID] varchar(50) NOT NULL ,
[Status] varchar(50) NOT NULL ,
[payerEmail] varchar(50) NOT NULL ,
[charname] varchar(50) NOT NULL ,
[datepaid] datetime NOT NULL ,
[itemCode] varchar(50) NOT NULL ,
[itemUniqueID] varchar(50) NOT NULL ,
[itemPlus] varchar(50) NOT NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[_donateItemsLog]', RESEED, 8)
GO

-- ----------------------------
-- Indexes structure for table _donateItemsLog
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table _donateItemsLog
-- ----------------------------
ALTER TABLE [dbo].[_donateItemsLog] ADD PRIMARY KEY ([id])
GO