SysModule.sql 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. /*
  2. Navicat SQL Server Data Transfer
  3. Source Server : 9000
  4. Source Server Version : 105000
  5. Source Host : .\sqlexpress:1433
  6. Source Database : LHBMS
  7. Source Schema : dbo
  8. Target Server Type : SQL Server
  9. Target Server Version : 105000
  10. File Encoding : 65001
  11. Date: 2021-05-11 15:34:18
  12. */
  13. -- ----------------------------
  14. -- Table structure for SysModule
  15. -- ----------------------------
  16. DROP TABLE [dbo].[SysModule]
  17. GO
  18. CREATE TABLE [dbo].[SysModule] (
  19. [ID] uniqueidentifier NOT NULL DEFAULT (newid()) ,
  20. [Name] nvarchar(50) NOT NULL ,
  21. [Remark] nvarchar(100) NULL
  22. )
  23. GO
  24. -- ----------------------------
  25. -- Records of SysModule
  26. -- ----------------------------
  27. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'13D20B7E-8EDE-4136-BC18-0323B75F2F53', N'密码修改', null)
  28. GO
  29. GO
  30. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'55EF263B-56BE-41F7-AD42-18082171D1B4', N'主机管理', null)
  31. GO
  32. GO
  33. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'8EF6A150-EB86-4518-B768-2FC24A3B0477', N'用户信息', null)
  34. GO
  35. GO
  36. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'3483A808-5498-4B88-BFA8-3CF19FF63830', N'数据备份', null)
  37. GO
  38. GO
  39. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'F1D890B7-1E00-4EBF-B184-4725F61B21F8', N'组织结构', null)
  40. GO
  41. GO
  42. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'848ECD0F-F2F9-4D99-B82B-4DFBB6DAAD1A', N'系统编码', null)
  43. GO
  44. GO
  45. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'81D9B11A-BDA5-4BC1-82E6-5E69FABF0B09', N'主机控制', null)
  46. GO
  47. GO
  48. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'CFE8E006-2EFD-453E-A6E1-817926994A08', N'报警预处理', null)
  49. GO
  50. GO
  51. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'F9E612B1-865A-4954-A54D-8458CCDFAC50', N'报警事件', null)
  52. GO
  53. GO
  54. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'5C671763-70E3-4044-963A-9A1EC434F714', N'电子地图', null)
  55. GO
  56. GO
  57. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'0E79E0CC-AD2B-4710-BC3B-9D0BD5BEC2BD', N'主机类型', null)
  58. GO
  59. GO
  60. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'43A875D7-5892-4A6B-AF8D-A6738CE97134', N'系统日志', null)
  61. GO
  62. GO
  63. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'217AD55A-7E23-46EF-AA76-C058FBAD36B1', N'系统角色', null)
  64. GO
  65. GO
  66. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'F873C4AF-2F8C-4980-8826-C761D96AF15A', N'布撤防事件', null)
  67. GO
  68. GO
  69. INSERT INTO [dbo].[SysModule] ([ID], [Name], [Remark]) VALUES (N'3AC5EC40-0636-4F97-B061-E45913CCF5EC', N'系统用户', null)
  70. GO
  71. GO
  72. -- ----------------------------
  73. -- Indexes structure for table SysModule
  74. -- ----------------------------
  75. -- ----------------------------
  76. -- Primary Key structure for table SysModule
  77. -- ----------------------------
  78. ALTER TABLE [dbo].[SysModule] ADD PRIMARY KEY ([ID])
  79. GO