Knight Online 1299 Pus İndir

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

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