idmax.sql

来自「这是一个关于论坛的一点小的源代码」· SQL 代码 · 共 1,958 行 · 第 1/5 页

SQL
1,958 行
字号
12345
GO
PRINT N'正在 [dbo].[System_Max_Permissions] 上创建主键 [PK_System_Max_Permissions]'
GO
ALTER TABLE [dbo].[System_Max_Permissions] ADD CONSTRAINT [PK_System_Max_Permissions] PRIMARY KEY CLUSTERED  ([SchemeID], [RoleID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_PasswordRecoveryLogs]'
GO
CREATE TABLE [dbo].[Max_PasswordRecoveryLogs]
(
[LogID] [int] NOT NULL IDENTITY(1, 1),
[UserID] [int] NOT NULL,
[UserName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[CreateDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[Max_PasswordRecoveryLogs] 上创建主键 [PK_PasswordRecoveryLogs]'
GO
ALTER TABLE [dbo].[Max_PasswordRecoveryLogs] ADD CONSTRAINT [PK_PasswordRecoveryLogs] PRIMARY KEY CLUSTERED  ([LogID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_CreatePasswordRecoveryLog]'
GO
CREATE PROCEDURE [dbo].[Max_CreatePasswordRecoveryLog]
	@UserID int,
	@UserName nvarchar(64),
	@CreateDate datetime
AS
	insert into Max_PasswordRecoveryLogs(UserID,UserName,CreateDate)
	values(@UserID,@UserName,@CreateDate)
	
	IF(@@ROWCOUNT>0)
	RETURN 0
	ELSE
	RETURN 1
GO
PRINT N'正在创建 [dbo].[Max_GetUserProfilesByCreateDate]'
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[Max_GetUserProfilesByCreateDate]
	@PageIndex int,
	@PageSize int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	EXECUTE Max_Common_GetRecordsByPage @PageIndex,
				@PageSize,
				N'Max_UserProfiles',
				N'*',
				N'',
				N'UserID',
				1;
END
GO
PRINT N'正在创建 [dbo].[Max_MedalLogs]'
GO
CREATE TABLE [dbo].[Max_MedalLogs]
(
[LogID] [int] NOT NULL IDENTITY(1, 1),
[UserID] [int] NOT NULL,
[MedalID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[IP] [nvarchar] (64) NULL,
[Handlers] [int] NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[Max_MedalLogs] 上创建主键 [PK_Max_MedalLogs]'
GO
ALTER TABLE [dbo].[Max_MedalLogs] ADD CONSTRAINT [PK_Max_MedalLogs] PRIMARY KEY CLUSTERED  ([LogID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_GetUsers]'
GO
CREATE PROCEDURE [dbo].[Max_GetUsers]
	@PageIndex INT,
	@PageSize INT,
	@Keyword VARCHAR(64),
	@SortField VARCHAR(100),
	@IsDesc int
AS
	SET NOCOUNT ON
	
	IF @SortField='1'
		SET @SortField='UserID'
	ELSE
		SET @SortField='NickName'

	IF(@Keyword<>'') BEGIN
		DECLARE @Condition NVARCHAR(200)
		SET @Condition= 'UserID<>0 AND NickName=''' + @Keyword+'''';
		EXEC Max_Common_GetRecordsByPage @PageIndex,@PageSize,'Max_UserProfiles','*',@Condition,@SortField,@IsDesc
		EXEC('SELECT COUNT(*) FROM Max_UserProfiles AS P 
			 INNER JOIN Max_Users AS U 
			 ON P.UserID=U.UserID
			 WHERE NickName=''' + @Keyword+''' AND U.IsActive=1 AND U.UserID<>0')
	END
	ELSE BEGIN
		EXEC Max_Common_GetRecordsByPage @PageIndex,@PageSize,'Max_UserProfiles','*','UserID<>0',@SortField,@IsDesc
		EXEC('SELECT COUNT(*) FROM Max_Users WHERE IsActive=1 AND UserID<>0')
	END
GO
PRINT N'正在创建 [dbo].[Max_UpdateMedal]'
GO
-- =============================================
-- Author:		<sek>
-- Create date: <2006/12/18>
-- Description:	<修改一个勋章>
-- =============================================
CREATE PROCEDURE [dbo].[Max_UpdateMedal]
	@MedalID INT,
	@MedalName NVARCHAR(64),
	@LogoUrl NVARCHAR(512),
	@IsEnabled BIT,
	@MappedRoleID INT
AS
	SET NOCOUNT ON 
	IF EXISTS (SELECT * FROM [Max_Medals] WITH (NOLOCK) WHERE MedalName=@MedalName AND MedalID<>@MedalID) 
		RETURN (3)
	ELSE IF EXISTS (SELECT * FROM [Max_Medals] WITH (NOLOCK) WHERE LogoUrl=@LogoUrl AND MedalID<>@MedalID) 
		RETURN (6)
	ELSE
	BEGIN
		UPDATE [Max_Medals] SET MedalName=@MedalName,LogoUrl=@LogoUrl,IsEnabled=@IsEnabled,MappedRoleID=@MappedRoleID
		WHERE MedalID=@MedalID
		RETURN (0)
	END
GO
PRINT N'正在创建 [dbo].[Max_ErrorPasswordLogs]'
GO
CREATE TABLE [dbo].[Max_ErrorPasswordLogs]
(
[LogID] [int] NOT NULL IDENTITY(1, 1),
[UserID] [int] NOT NULL,
[UserName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[ErrorPassword] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[CreateDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[Max_ErrorPasswordLogs] 上创建主键 [PK_Max_ErrorPasswordLogs]'
GO
ALTER TABLE [dbo].[Max_ErrorPasswordLogs] ADD CONSTRAINT [PK_Max_ErrorPasswordLogs] PRIMARY KEY CLUSTERED  ([LogID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_CreateErrorPasswordLog]'
GO
CREATE PROCEDURE [dbo].[Max_CreateErrorPasswordLog]
	@UserID int,
	@UserName nvarchar(64),
	@ErrorPassword nvarchar(64),
	@CreateDate datetime
AS
	insert into Max_ErrorPasswordLogs(UserID,UserName,ErrorPassword,CreateDate)
	values(@UserID,@UserName,@ErrorPassword,@CreateDate)
	
	IF(@@ROWCOUNT>0)
	RETURN 0
	ELSE
	RETURN 1
GO
PRINT N'正在创建 [dbo].[Max_CreateMedal]'
GO
-- =============================================
-- Author:		<sek>
-- Create date: <2006/12/18>
-- Description:	<创建一个勋章>
-- =============================================
CREATE PROCEDURE [dbo].[Max_CreateMedal] 
	@MedalName NVARCHAR(64),
	@LogoUrl NVARCHAR(512),
	@IsEnabled BIT,
	@MappedRoleID INT
AS
	SET NOCOUNT ON 
	IF EXISTS (SELECT * FROM [Max_Medals] WITH (NOLOCK) WHERE MedalName=@MedalName) 
		RETURN (3)
	ELSE IF EXISTS (SELECT * FROM [Max_Medals] WITH (NOLOCK) WHERE LogoUrl=@LogoUrl) 
		RETURN (6)
	ELSE
	BEGIN
		INSERT INTO [Max_Medals](
		MedalName,
		LogoUrl,
		IsEnabled,
		MappedRoleID
		) values(
		@MedalName,
		@LogoUrl,
		@IsEnabled,
		@MappedRoleID
		)
		RETURN (0)
	END
GO
PRINT N'正在创建 [dbo].[Max_CreateAdminLoginLog]'
GO
CREATE PROC [dbo].[Max_CreateAdminLoginLog]
	@UserID int,
	@UserIP nvarchar(15),
	@ErrorPassword nvarchar(64),
	@CreateDate datetime
AS
	INSERT INTO Max_AdminLoginLogs(UserID,UserIP,ErrorPassword,CreateDate)
	values(@UserID,@UserIP,@ErrorPassword,@CreateDate)
	
	IF(@@ROWCOUNT>0)
	RETURN 0
	ELSE
	RETURN 1
GO
PRINT N'正在创建 [dbo].[Max_GetEmoticonsBySearch]'
GO
CREATE PROCEDURE [dbo].[Max_GetEmoticonsBySearch]
	@PageIndex int,
	@PageSize int,
	@Keyword nvarchar(64),
	@ActionType tinyint
AS
	DECLARE @Condition nvarchar(256)
	IF(@Keyword='')
		SET @Condition ='e.GroupID = g.GroupID';
	ELSE
		BEGIN
			IF(@ActionType=0)--无选择
				SET @Condition = 'e.GroupID = g.GroupID'
			ELSE IF(@ActionType=1)--GroupName
				SET @Condition ='e.GroupID = g.GroupID and g.GroupName LIKE ''%'+@Keyword+'%'''
			ELSE IF(@ActionType=2)--FileName
				SET @Condition ='e.GroupID = g.GroupID and e.FileName LIKE ''%' + @Keyword +'%'''
			ELSE IF(@ActionType=3)--ShortCut
				SET @Condition ='e.GroupID = g.GroupID and e.ShortCut LIKE ''%' + @Keyword +'%'''
			ELSE IF(@ActionType=4)--UserName
				SET @Condition ='e.GroupID = g.GroupID and g.UserID = '+ @Keyword
		END
	EXECUTE Max_Common_GetRecordsByPage @PageIndex,@PageSize,'Max_Emoticons e ,Max_EmoticonGroups g','e.EmoticonID, e.GroupID, e.Shortcut, e.FileName, e.FileSize, g.GroupName, g.UserID',@Condition,'EmoticonID',1
	

	EXEC('SELECT COUNT(1) TotalRecord FROM Max_Emoticons e,Max_EmoticonGroups g WHERE ' +@Condition)
GO
PRINT N'正在创建 [dbo].[Max_UpdateDefaultEmoticon]'
GO
-- =============================================
-- Author:		sek
-- Create date: 2007/5/21
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[Max_UpdateDefaultEmoticon]
	@EmoticonID int,
	@Shortcut nvarchar(64), 
	@FileName nvarchar(256)
AS
	SET NOCOUNT ON
	IF EXISTS (SELECT * FROM [Max_DefaultEmoticons] WITH(NOLOCK) WHERE ((Shortcut=@Shortcut AND @Shortcut<>'') OR FileName=@FileName) AND EmoticonID<>@EmoticonID)
		RETURN (5)
	
	UPDATE [Max_DefaultEmoticons] SET Shortcut=@Shortcut,FileName=@FileName WHERE EmoticonID=@EmoticonID
GO
PRINT N'正在创建 [dbo].[Max_CreateLinkedApplication]'
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[Max_CreateLinkedApplication]
	@ApplicationID NVARCHAR(64),
	@ApplicationUrl NVARCHAR(256),
	@ApplicationName NVARCHAR(256)
AS

INSERT INTO Max_LinkedApplications(ApplicationID,[Url],DisplayName)
VALUES (@ApplicationID,@ApplicationUrl,@ApplicationName)
IF @@ROWCOUNT>0
RETURN 0
ELSE 
RETURN (-1)
GO
PRINT N'正在创建 [dbo].[Max_GetMedals]'
GO
-- =============================================
-- Author:		<sek>
-- Create date: <2006/12/18>
-- Description:	<获取所有勋章>
-- =============================================
CREATE PROCEDURE [dbo].[Max_GetMedals]
AS
	SET NOCOUNT ON
	SELECT * FROM [Max_Medals] WITH (NOLOCK) 
	RETURN
GO
PRINT N'正在创建 [dbo].[Max_RoleLogs]'
GO
CREATE TABLE [dbo].[Max_RoleLogs]
(
[LogID] [int] NOT NULL IDENTITY(1, 1),
[UserID] [int] NOT NULL,
[RoleID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[IP] [nvarchar] (64) NULL,
[Handlers] [int] NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[Max_RoleLogs] 上创建主键 [PK_Max_RoleLogs]'
GO
ALTER TABLE [dbo].[Max_RoleLogs] ADD CONSTRAINT [PK_Max_RoleLogs] PRIMARY KEY CLUSTERED  ([LogID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_DeleteContacts]'
GO
-- =============================================
-- Author:		<sek>
-- Create date: <2006/12/11>
-- Description:	<批量删除联系人>
-- =============================================
CREATE PROCEDURE [dbo].[Max_DeleteContacts]
	@GroupID int,
	@UserID int,
	@ContactIdentities varchar(8000)
AS
	SET NOCOUNT ON
	IF EXISTS (SELECT * FROM [Max_ContactGroups] WITH (NOLOCK) WHERE UserID=@UserID and GroupID=@GroupID)
	BEGIN
		EXEC ('DELETE [Max_Contacts] WHERE [ContactID] IN (' + @ContactIdentities + ') AND [GroupID] = ' + @GroupID)
		RETURN (0)
	END
	ELSE
	  RETURN (-1)
GO
PRINT N'正在创建 [dbo].[System_Max_FaqCatalogs]'
GO
CREATE TABLE [dbo].[System_Max_FaqCatalogs]
(
[FaqCatalogID] [int] NOT NULL IDENTITY(1, 1),
[FaqCatalogName] [nvarchar] (50) NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[System_Max_FaqCatalogs] 上创建主键 [PK_System_Max_FaqCatalogs]'
GO
ALTER TABLE [dbo].[System_Max_FaqCatalogs] ADD CONSTRAINT [PK_System_Max_FaqCatalogs] PRIMARY KEY CLUSTERED  ([FaqCatalogID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[System_Max_FaqCatalogs] 的索引 [IX_System_Max_FaqCatalogs]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_System_Max_FaqCatalogs] ON [dbo].[System_Max_FaqCatalogs] ([SortOrder]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[System_Max_Faqs]'
GO
CREATE TABLE [dbo].[System_Max_Faqs]
(
[FaqID] [int] NOT NULL IDENTITY(1, 1),
[FaqCatalogID] [int] NOT NULL,
[FaqTitle] [nvarchar] (500) NOT NULL,
[FaqContent] [ntext] NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
PRINT N'正在 [dbo].[System_Max_Faqs] 上创建主键 [PK_System_Max_Faqs]'
GO
ALTER TABLE [dbo].[System_Max_Faqs] ADD CONSTRAINT [PK_System_Max_Faqs] PRIMARY KEY CLUSTERED  ([FaqID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[System_Max_Faqs] 的索引 [IX_System_Max_Faqs]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_System_Max_Faqs] ON [dbo].[System_Max_Faqs] ([FaqCatalogID], [SortOrder]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[Max_CreateOrUpdateUserInvite]'
GO
-- =============================================
-- Author:		<zzbird>
-- Create date: <2007/3/15>
-- Description:	<>
-- =============================================
CREATE PROCEDURE [dbo].[Max_CreateOrUpdateUserInvite]
	@UserID int,
	@InvitedCount int,
	@SpareInviteCount int
AS
	SET NOCOUNT ON;
	IF EXISTS (SELECT * FROM Max_UserInvites WITH (NOLOCK) WHERE UserID = @UserID)
		UPDATE Max_UserInvites SET InvitedCount = @InvitedCount, SpareInviteCount = @SpareInviteCount WHERE UserID = @UserID;
	ELSE
		INSERT INTO Max_UserInvites(
			UserID,
			InvitedCount,
			SpareInviteCount)
		VALUES(
			@UserID,
			@InvitedCount,
			@SpareInviteCount)
GO
PRINT N'正在创建 [dbo].[Max_GetLinkedApplications]'
12345

idmax.sql - 源码说明

本页面展示了「这是一个关于论坛的一点小的源代码」中的 idmax.sql 源码文件，采用 SQL 编程语言编写，共 1,958 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与源代码相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?