IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[CSAPP_PAYMENT_VERIFICATION]'))
CREATE TABLE [dbo].[CSAPP_PAYMENT_VERIFICATION](
    pk INT PRIMARY KEY IDENTITY(1,1) NOT NULL,
    payment_customer varchar(255)  NOT NULL,
    payment_success	BIT NULL,
    payment_type INT NOT NULL
   )

IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[CSAPP_PAYMENT_TYPES]'))
BEGIN
	CREATE TABLE [dbo].[CSAPP_PAYMENT_TYPES](
	    pk INT PRIMARY KEY IDENTITY(1,1) NOT NULL,
	    payment_type varchar(255)  NOT NULL,
	    check_verification BIT NULL
	   )
	INSERT INTO CSAPP_PAYMENT_TYPES
	(
		payment_type,
		check_verification
	)
	VALUES
	(
		'PAYPAL',
		1
	)
END

