cs_default.sql

本系统是在asp版《在线文件管理器》的基础上设计制作

if not exists( select * from [dbo].[aspnet_SchemaVersions] where Feature = N'common' and CompatibleSchemaVersion = '1' )
	INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'common', N'1', 1)

if not exists( select * from [dbo].[aspnet_SchemaVersions] where Feature = N'membership' and CompatibleSchemaVersion = '1' )
	INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'membership', N'1', 1)

if not exists( select * from [dbo].[aspnet_SchemaVersions] where Feature = N'profile' and CompatibleSchemaVersion = '1' )
	INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'profile', N'1', 1)

if not exists( select * from [dbo].[aspnet_SchemaVersions] where Feature = N'role manager' and CompatibleSchemaVersion = '1' )
	INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'role manager', N'1', 1)

if not exists( select * from cs_SchemaVersion where Major = 1 and Minor = 0 and Patch = 0 )
	insert into cs_SchemaVersion values(1,0,0, getdate())

if not exists( select * from cs_ApplicationType where ApplicationType = 0 )
	insert into cs_ApplicationType values( 0, 'Forum')

if not exists( select * from cs_ApplicationType where ApplicationType = 1 )
	insert into cs_ApplicationType values( 1, 'Weblog')

if not exists( select * from cs_ApplicationType where ApplicationType = 2 )
	insert into cs_ApplicationType values( 2, 'Gallery')

if not exists( select * from cs_ApplicationType where ApplicationType = 3 )
	insert into cs_ApplicationType values( 3, 'GuestBook')

if not exists( select * from cs_ApplicationType where ApplicationType = 9999 )
	insert into cs_ApplicationType values( 9999, 'Unknown')