spos_schema.sql

幼儿园管理软件aspSPOS幼儿园办公管理系统2.00普及版安装说明： 一. 安装前提条件： 1. 在安装SPOS幼儿园办公管理系统2.00普及版之前

	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[parent_idea] WITH NOCHECK ADD 
	CONSTRAINT [PK_parent_idea] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[parenttemp] WITH NOCHECK ADD 
	CONSTRAINT [PK_parenttemp] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[recruit] WITH NOCHECK ADD 
	CONSTRAINT [PK_recruit] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[register_money] WITH NOCHECK ADD 
	CONSTRAINT [PK_register_money] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[statistic] WITH NOCHECK ADD 
	CONSTRAINT [PK_statistic] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student] WITH NOCHECK ADD 
	CONSTRAINT [PK_student] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_base] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_base] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_parents] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_parents] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_pic] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_pic] PRIMARY KEY  CLUSTERED 
	(
		[pic_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_quit] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_quit] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_temp] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_temp] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[student_time] WITH NOCHECK ADD 
	CONSTRAINT [PK_student_time] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[study_info] WITH NOCHECK ADD 
	CONSTRAINT [PK_study_info] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[teach_book] WITH NOCHECK ADD 
	CONSTRAINT [PK_teach_book] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[teach_tools] WITH NOCHECK ADD 
	CONSTRAINT [PK_teach_tools] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[teacher_base] WITH NOCHECK ADD 
	CONSTRAINT [PK_teacher_base] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[teacher_info] WITH NOCHECK ADD 
	CONSTRAINT [PK_teacher_info] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[term] WITH NOCHECK ADD 
	CONSTRAINT [PK_term] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[users] WITH NOCHECK ADD 
	CONSTRAINT [PK_users] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[work] WITH NOCHECK ADD 
	CONSTRAINT [PK_work] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[xgroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_xgroup] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Stu_Card_Money] WITH NOCHECK ADD 
	CONSTRAINT [DF_Stu_Card_Money_FreeMoney] DEFAULT (0) FOR [FreeMoney]
GO



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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