Cevap: YourKO Panel ve Seven Panel Arşivi İçin Sorunsuz Functions.php 1886'dada kullanılabilir.
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_HABER]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_HABER]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[MYKOL]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[MYKOL]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_DOWNLOAD]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_DOWNLOAD]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_TICKET]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_TICKET]
CREATE TABLE [dbo].[_HABER] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[haberadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[haber] [varchar] (1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[views] [int] NULL ,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
insert into _HABER (haberadi, haber, date, views, type) VALUES (‘KOPanel Yenilendi’, ‘Merhaba, Bu KOPanel Orlando tarafından kocuce.com ve TÜRKKE için kodlanmıştır.’, ’19/11/2010′, ’1′, ’4′)
CREATE TABLE [dbo].[MYKOL](
[StrAccountID] [varchar](50) NULL,
[MyKOLSoru] [varchar](50) NULL,
[MyKOLCevap] [varchar](50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[_DOWNLOAD] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[linkadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[linkurl] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[_TICKET](
[TicketNumara] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Oyuncu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ticketi] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[durumu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[seviye] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cevap] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[admin] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[_TICKET] ADD CONSTRAINT [DF_Ticket_durumu] DEFAULT ((1)) FOR [durumu]
ALTER TABLE TB_USER
ADD CashPoint int
ALTER TABLE TB_USER
ADD StrSoru varchar(500)
ALTER TABLE TB_USER
ADD StrYanit varchar(500)
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_HABER]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_HABER]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[MYKOL]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[MYKOL]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_DOWNLOAD]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_DOWNLOAD]
if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[_TICKET]‘) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[_TICKET]
CREATE TABLE [dbo].[_HABER] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[haberadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[haber] [varchar] (1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[views] [int] NULL ,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
insert into _HABER (haberadi, haber, date, views, type) VALUES (‘KOPanel Yenilendi’, ‘Merhaba, Bu KOPanel Orlando tarafından kocuce.com ve TÜRKKE için kodlanmıştır.’, ’19/11/2010′, ’1′, ’4′)
CREATE TABLE [dbo].[MYKOL](
[StrAccountID] [varchar](50) NULL,
[MyKOLSoru] [varchar](50) NULL,
[MyKOLCevap] [varchar](50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[_DOWNLOAD] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[linkadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[linkurl] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[_TICKET](
[TicketNumara] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Oyuncu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ticketi] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[durumu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[seviye] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cevap] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[admin] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[_TICKET] ADD CONSTRAINT [DF_Ticket_durumu] DEFAULT ((1)) FOR [durumu]
ALTER TABLE TB_USER
ADD CashPoint int
ALTER TABLE TB_USER
ADD StrSoru varchar(500)
ALTER TABLE TB_USER
ADD StrYanit varchar(500)
