ASD database
USE [ASD]
GO
/****** Object: Table [dbo].[charac0] Script Date: 04/29/2012 23:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[charac0]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[charac0](
[c_id] [varchar](50) NOT NULL,
[c_sheadera] [varchar](255) NOT NULL,
[c_sheaderb] [varchar](255) NOT NULL,
[c_sheaderc] [int] NOT NULL,
[c_headera] [varchar](255) NOT NULL,
[c_headerb] [varchar](255) NOT NULL,
[c_headerc] [varchar](255) NOT NULL,
[d_cdate] [smalldatetime] NULL,
[d_udate] [smalldatetime] NULL,
[c_status] [varchar](50) NOT NULL,
[m_body] [varchar](4000) NOT NULL,
[rb] [int] NOT NULL CONSTRAINT [DF_charac0_rb] DEFAULT (0),
[times_rb] [int] NOT NULL CONSTRAINT [DF_charac0_times_rb] DEFAULT (0)
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[temp_account] Script Date: 04/29/2012 23:03:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[temp_account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[temp_account](
[username] [varchar](50) NULL,
[password] [varchar](50) NULL,
[email] [varchar](50) NULL,
[passkey] [varchar](50) NULL,
[date] [smalldatetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Account] Script Date: 04/29/2012 23:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[Account](
[c_id] [varchar](50) NOT NULL,
[c_sheadera] [varchar](255) NOT NULL,
[c_sheaderb] [varchar](255) NOT NULL,
[c_sheaderc] [varchar](255) NOT NULL,
[c_headera] [varchar](255) NOT NULL,
[c_headerb] [varchar](255) NOT NULL,
[c_headerc] [varchar](255) NOT NULL,
[d_cdate] [smalldatetime] NULL,
[d_udate] [smalldatetime] NULL,
[c_status] [char](10) NOT NULL,
[m_body] [varchar](4000) NULL,
[acc_status] [varchar](50) NULL,
[salary] [smalldatetime] NULL,
[last_salary] [smalldatetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[A3Web_HTML] Script Date: 04/29/2012 23:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_HTML]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[A3Web_HTML](
[Bil] [int] IDENTITY(1,1) NOT NULL,
[Author] [varchar](50) NULL,
[Category] [varchar](50) NULL,
[Subject] [varchar](50) NULL,
[HTML] [varchar](4000) NULL,
[Date] [smalldatetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[captcha] Script Date: 04/29/2012 23:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[captcha]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[captcha](
[captcha_id] [bigint] IDENTITY(1,1) NOT NULL,
[captcha_time] [int] NOT NULL,
[ip_address] [varchar](50) NOT NULL,
[word] [varchar](50) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[A3Web_Comment] Script Date: 04/29/2012 23:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_Comment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[A3Web_Comment](
[bil] [int] IDENTITY(1,1) NOT NULL,
[bil_post] [int] NOT NULL,
[author] [varchar](50) NOT NULL,
[html] [varchar](max) NOT NULL,
[date] [smalldatetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
