if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ig_class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ig_class]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ig_image]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ig_image]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ig_site]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ig_site]
GO
CREATE TABLE [dbo].[ig_class] (
[Class_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Class_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Class_intro] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ig_image] (
[Img_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Img_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_path] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_intro] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_hw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_size] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Img_count] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Class_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[In_day] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ig_site] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Site_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Site_intro] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO