Sorunsuz Power UP STORE (SQL + FİLES)

Merhabalar arşivimde mevcuttu sorunsuz çalışır ESN Tablosu mevcut değil uyarlarsanız sorunsuz çalışır.


DOWNLOAD LINK : https://yadi.sk/d/v-4jPWIHhvoL3
rar pass : kfsamet


SQL CODE

Kod:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[PUS_ITEMLERI] DROP CONSTRAINT FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_CASH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PUS_CASH]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_ITEMLERI]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PUS_ITEMLERI]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_ITEMLERI_PAKET]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PUS_ITEMLERI_PAKET]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_PAYPAL_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PUS_PAYPAL_LOG]
GO

CREATE TABLE [dbo].[PUS_CASH] (
	[cashid] [int] IDENTITY (1, 1) NOT NULL ,
	[Total] [int] NOT NULL ,
	[Cash] [int] NOT NULL ,
	[Aciklama] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PUS_ITEMLERI] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[PID] [int] NULL ,
	[ExtraItem] [bit] NOT NULL ,
	[ItemIsmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ItemResmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[itemkodu] [int] NOT NULL ,
	[adet] [int] NOT NULL ,
	[ucret] [int] NULL ,
	[type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[alindi] [int] NOT NULL ,
	[aciklama] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[islev] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sure] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[kullanim] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[kosul] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[reqtitle] [tinyint] NOT NULL ,
	[ItemVer] [bit] NOT NULL ,
	[KomutCalistir] [bit] NOT NULL ,
	[Komut] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PUS_ITEMLERI_PAKET] (
	[PID] [int] IDENTITY (1, 1) NOT NULL ,
	[PItem1] [int] NOT NULL ,
	[Adet1] [int] NOT NULL ,
	[PItem2] [int] NOT NULL ,
	[Adet2] [int] NOT NULL ,
	[PItem3] [int] NOT NULL ,
	[Adet3] [int] NOT NULL ,
	[PItem4] [int] NOT NULL ,
	[Adet4] [int] NOT NULL ,
	[PItem5] [int] NOT NULL ,
	[Adet5] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PUS_PAYPAL_LOG] (
	[strAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strUserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[token] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[cashID] [int] NULL ,
	[eskiCash] [int] NULL ,
	[yeniCash] [int] NULL ,
	[tutar] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PUS_CASH] WITH NOCHECK ADD 
	CONSTRAINT [PK_PUS_CASH] PRIMARY KEY  CLUSTERED 
	(
		[cashid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PUS_ITEMLERI] WITH NOCHECK ADD 
	CONSTRAINT [PK_PUS_ITEMLERI] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PUS_ITEMLERI_PAKET] WITH NOCHECK ADD 
	CONSTRAINT [PK_PUS_ITEMLERI_PAKET] PRIMARY KEY  CLUSTERED 
	(
		[PID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PUS_CASH] ADD 
	CONSTRAINT [DF_PUS_CASH_Total] DEFAULT (0) FOR [Total],
	CONSTRAINT [DF_PUS_CASH_Cash] DEFAULT (0) FOR [Cash],
	CONSTRAINT [DF_PUS_CASH_PID] DEFAULT (0) FOR [PID]
GO

ALTER TABLE [dbo].[PUS_ITEMLERI] ADD 
	CONSTRAINT [DF_PUS_ITEMLERI_ExtraItem] DEFAULT (0) FOR [ExtraItem],
	CONSTRAINT [DF_PUS_ITEMLERI_adet] DEFAULT (1) FOR [adet],
	CONSTRAINT [DF_PUS_ITEMLERI_alindi] DEFAULT (0) FOR [alindi],
	CONSTRAINT [DF_PUS_ITEMLERI_reqtitle] DEFAULT (0) FOR [reqtitle],
	CONSTRAINT [DF_PUS_ITEMLERI_ItemVer] DEFAULT (1) FOR [ItemVer],
	CONSTRAINT [DF_PUS_ITEMLERI_KomutCalistir] DEFAULT (0) FOR [KomutCalistir]
GO

ALTER TABLE [dbo].[PUS_ITEMLERI_PAKET] ADD 
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item1] DEFAULT (0) FOR [PItem1],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet1] DEFAULT (0) FOR [Adet1],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item2] DEFAULT (0) FOR [PItem2],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet2] DEFAULT (0) FOR [Adet2],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item3] DEFAULT (0) FOR [PItem3],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet3] DEFAULT (0) FOR [Adet3],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item4] DEFAULT (0) FOR [PItem4],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet5] DEFAULT (0) FOR [Adet4],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item5] DEFAULT (0) FOR [PItem5],
	CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet5_1] DEFAULT (0) FOR [Adet5]
GO

ALTER TABLE [dbo].[PUS_ITEMLERI] ADD 
	CONSTRAINT [FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET] FOREIGN KEY 
	(
		[PID]
	) REFERENCES [dbo].[PUS_ITEMLERI_PAKET] (
		[PID]
	)
GO




if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WEB_ITEMMALL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WEB_ITEMMALL]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WEB_ITEMMALL_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WEB_ITEMMALL_LOG]
GO

CREATE TABLE [dbo].[WEB_ITEMMALL] (
	[strAccountID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[strCharID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ServerNo] [smallint] NOT NULL ,
	[ItemID] [int] NOT NULL ,
	[ItemCount] [smallint] NOT NULL ,
	[BuyTime] [smalldatetime] NOT NULL ,
	[img_file_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strItemName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[price] [int] NULL ,
	[pay_type] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WEB_ITEMMALL_LOG] (
	[strAccountID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[strCharID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ServerNo] [smallint] NOT NULL ,
	[ItemID] [int] NOT NULL ,
	[ItemCount] [smallint] NOT NULL ,
	[BuyTime] [smalldatetime] NOT NULL ,
	[img_file_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strItemName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[price] [int] NULL ,
	[pay_type] [int] NULL 
) ON [PRIMARY]
GO

TB USER EKLENECEK

Kod:

ALTER TABLE TB_USER
ADD CashPoint int,
Sepet varchar(250),
PusAdmin tinyint not null default 0

​

rar pass : kfsamet

 

saol kardeş harikasın

 

eyvallahhhhh

 

tamamdır bro

 

Süper Paylaşım Elinize Sağlık...