USE [Work]
GO
/****** Object: Table [dbo].[Wplan] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Wplan](
[Id] [int] NOT NULL,
[ParentId] [int] NULL,
[Description] [nvarchar](max) NULL,
[CreateDate] [datetime] NULL,
[NeedDay] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Type] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Type](
[Id] [int] NOT NULL,
[FileId] [int] NULL,
[Guid] [nvarchar](max) NULL,
[Name] [nvarchar](max) NULL,
[FullName] [nvarchar](max) NULL,
[Assembly] [nvarchar](max) NULL,
[Module] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SysInfo] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysInfo](
[Id] [int] NOT NULL,
[Name] [nvarchar](max) NULL,
[FieldName] [nvarchar](max) NULL,
[CurValue] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Sequence] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sequence](
[Name] [nvarchar](max) NULL,
[CurId] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Resource] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Resource](
[Id] [int] NOT NULL,
[Address] [nvarchar](max) NULL,
[Tag] [nvarchar](max) NULL,
[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ReadWord] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReadWord](
[Id] [int] NOT NULL,
[Word] [nvarchar](max) NULL,
[Guess] [nvarchar](max) NULL,
[ReadDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Problem] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Problem](
[Id] [int] NULL,
[Description] [nvarchar](max) NULL,
[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[OparateLog] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OparateLog](
[Id] [int] NOT NULL,
[PositionId] [int] NULL,
[Description] [nvarchar](50) NULL,
[CreateDate] [datetime] NULL,
CONSTRAINT [PK_OparateLog] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[IWant] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IWant](
[Id] [int] NOT NULL,
[What] [nvarchar](max) NULL,
[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DropDownList] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DropDownList](
[Id] [int] NOT NULL,
[DataSourceId] [int] NULL,
[DataTextField] [nvarchar](max) NULL,
[DataValueField] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Directory] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Directory](
[Id] [int] NOT NULL,
[Description] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DifWord2] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DifWord2](
[Id] [int] NULL,
[Words] [nvarchar](max) NULL,
[Meaning] [nvarchar](max) NULL,
[Tyc] [nvarchar](max) NULL,
[Fyc] [nvarchar](max) NULL,
[Xj] [nvarchar](max) NULL,
[Yj] [nvarchar](max) NULL,
[Lx] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DifWord1] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DifWord1](
[Id] [int] NULL,
[Word] [nvarchar](max) NULL,
[Meaning] [nvarchar](max) NULL,
[Tyc] [nvarchar](max) NULL,
[Fyc] [nvarchar](max) NULL,
[Xj] [nvarchar](max) NULL,
[Yj] [nvarchar](max) NULL,
[Lx] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DevFile] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DevFile](
[Id] [int] NOT NULL,
[DirId] [int] NOT NULL,
[FileName] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DataSource] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataSource](
[Id] [int] NOT NULL,
[SQLStr] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ControlRelation] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ControlRelation](
[Id] [nvarchar](max) NULL,
[ParentId] [nvarchar](max) NULL,
[Level] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Control] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Control](
[Id] [nvarchar](max) NULL,
[Type] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[CetSixReaded] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CetSixReaded](
[Id] [int] NOT NULL,
[CetSixId] [int] NULL,
[ReadDate] [datetime] NULL,
[Wanted] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[CetSix] Script Date: 03/02/2011 17:00:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CetSix](
[Id] [int] NULL,
[Words] [nvarchar](max) NULL,
[Meaning] [nvarchar](max) NULL,
[Tyc] [nvarchar](max) NULL,
[Fyc] [nvarchar](max) NULL,
[Xj] [nvarchar](max) NULL,
[Yj] [nvarchar](max) NULL,
[Lx] [nvarchar](max) NULL
) ON [PRIMARY]
GO
