www.servertanitimi.net

CREATE TABLE [b4tu] (
    [title] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [ipadresi] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [savas] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [event] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [adminmsn] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [duyuru] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [forum] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [serveradi] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO


insert into b4tu values ('XxX Empire' , '127.0.0.1' , 'Henüz  Belirlenmemis.' , 'Henüz Belirlenmemis.' , 'adminiletisim@hotmail.com' ,  'Admin Panelinden Duzenleyınız' , 'http://www.forumadresiniz.com/' , 7)


CREATE TABLE [b4tumodul] (
    [login] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [b4tudetay] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [ticket] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [usergoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [clangoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [cezagoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

insert into b4tumodul values ( 'acik' , 'acik' , 'acik' , 50 , 50 , 50 )




SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ticket](
[TicketNumara] [nvarchar](999) NULL,
[Oyuncu] [nvarchar](999) NULL,
[Ticketi] [nvarchar](999) NULL,
[durumu] [nvarchar](999) NULL,
[seviye] [nvarchar](999) NULL,
[Cevap] [nvarchar](999) NULL,
[admin] [nvarchar](999) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Haber] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[konu] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[news] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[gonderen] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[MYKOL](
    [StrAccountID] [varchar](50) NULL,
    [MyKOLSoru] [varchar](50) NULL,
    [MyKOLCevap] [varchar](50) NULL
) ON [PRIMARY]



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



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


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


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

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

CREATE TABLE [dbo].[_ANKETS] (
    [id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
    [AnketName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[_DOWNLOADS] (
    [id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
    [strTitle] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [strLink] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[_VOTELOGS] (
    [StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [oyid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[_VOTES] (
    [oyid] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
    [anketid] [int] NULL ,
    [Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [oysayisi] [int] NULL 
) ON [PRIMARY]
GO