defaultvalues.restoresettings

sqlserver异地备份原代码,经测试可用,sqlserver异地备份原代码,经测试可用

</ScriptSQL>
  </table>
  <table>
    <TableName>Lectures</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Lectures]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Lectures]
GO


CREATE TABLE [Lectures] (
	[LectureID] [int] NOT NULL ,
	[LectureStartDateTime] [datetime] NULL ,
	[LectureEndDateTime] [datetime] NULL ,
	[LectureDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SubjectID] [int] NULL ,
	[TeacherID] [int] NULL ,
	CONSTRAINT [PK_Lectures] PRIMARY KEY  CLUSTERED 
	(
		[LectureID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>OtherIncome</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[OtherIncome]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [OtherIncome]
GO


CREATE TABLE [OtherIncome] (
	[IncomeID] [int] NOT NULL ,
	[IncomeDate] [datetime] NOT NULL ,
	[IncomeDescription] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IncomeAmount] [float] NOT NULL ,
	CONSTRAINT [PK_OtherIncome] PRIMARY KEY  CLUSTERED 
	(
		[IncomeID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>PaymentTypes</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[PaymentTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [PaymentTypes]
GO


CREATE TABLE [PaymentTypes] (
	[PaymentTypes] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [PK_PaymentTypes] PRIMARY KEY  CLUSTERED 
	(
		[PaymentTypes]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Students</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Students]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Students]
GO


CREATE TABLE [Students] (
	[StudentID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Address] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Province] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ZipCode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[HomePhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[WorkPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CellNo] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BirthDate] [datetime] NULL ,
	[BirthPlace] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Religion] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[GradeID] [int] NULL ,
	[Age] [int] NULL ,
	[SocialSecurityNo] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[StudentLivesWith] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DateOfEnrollment] [datetime] NULL ,
	[DateOfWithdrawal] [datetime] NULL ,
	[ReasonForWithdrawal] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LastSchoolAttended] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Ethnicity] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Siblings] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Closed] [bit] NOT NULL ,
	[Guardian1RelationShip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1Address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1Province] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1Country] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1ZipCode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1HomePhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1WorkPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian1CellNo] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2RelationShip] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2Address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2Province] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2Country] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2ZipCode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2HomePhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2WorkPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Guardian2CellNo] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactRelationShip] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactCity] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactProvince] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactCountry] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactZipCode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactHomePhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactWorkPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmergencyContactCellNo] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Students] PRIMARY KEY  CLUSTERED 
	(
		[StudentID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>SubjectDetails</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[SubjectDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [SubjectDetails]
GO


CREATE TABLE [SubjectDetails] (
	[SubjectID] [int] NOT NULL ,
	[TeacherID] [int] NOT NULL ,
	[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Subjects</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Subjects]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Subjects]
GO


CREATE TABLE [Subjects] (
	[SubjectID] [int] NOT NULL ,
	[SubjectName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SubjectDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[GradeID] [int] NULL ,
	CONSTRAINT [PK_Subjects] PRIMARY KEY  CLUSTERED 
	(
		[SubjectID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>TeacherCategories</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[TeacherCategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [TeacherCategories]
GO


CREATE TABLE [TeacherCategories] (
	[TeacherCategoryID] [int] NOT NULL ,
	[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [PK_TeacherCategories] PRIMARY KEY  CLUSTERED 
	(
		[TeacherCategoryID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Teachers</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Teachers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Teachers]
GO


CREATE TABLE [Teachers] (
	[TeacherID] [int] NOT NULL ,
	[TeacherName] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TeacherCategoryID] [int] NULL ,
	[TeacherDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TeacherSpecilization] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TeacherEducation] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TeacherJoiningDate] [datetime] NULL ,
	[TeacherResignDate] [datetime] NULL ,
	[ReasonOfResign] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Staff] PRIMARY KEY  CLUSTERED 
	(
		[TeacherID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Terms</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Terms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Terms]
GO


CREATE TABLE [Terms] (
	[TermID] [int] NOT NULL ,
	[TermStartDate] [datetime] NULL ,
	[TermEndDate] [datetime] NULL ,
	[TermDescription] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Terms] PRIMARY KEY  CLUSTERED 
	(
		[TermID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
</NewDataSet>