· 6 years ago · Sep 13, 2019, 02:22 PM
1-- ----------------------------
2-- Table structure for TblRoles
3-- ----------------------------
4IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TblRoles]') AND type IN ('U'))
5 DROP TABLE [dbo].[TblRoles]
6GO
7
8CREATE TABLE [dbo].[TblRoles] (
9 [Id] int IDENTITY(1,1) NOT NULL,
10 [Name] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
11 [level] varchar(3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
12)
13GO
14
15ALTER TABLE [dbo].[TblRoles] SET (LOCK_ESCALATION = TABLE)
16GO
17
18
19-- ----------------------------
20-- Records of TblRoles
21-- ----------------------------
22SET IDENTITY_INSERT [dbo].[TblRoles] ON
23GO
24
25INSERT INTO [dbo].[TblRoles] ([Id], [Name], [level]) VALUES (N'1', N'Programmer', N'PRG')
26GO
27
28INSERT INTO [dbo].[TblRoles] ([Id], [Name], [level]) VALUES (N'2', N'ADM - PPIC', N'ADM')
29GO
30
31INSERT INTO [dbo].[TblRoles] ([Id], [Name], [level]) VALUES (N'3', N'Pimpinan - PPIC', N'PMP')
32GO
33
34SET IDENTITY_INSERT [dbo].[TblRoles] OFF
35GO
36
37
38-- ----------------------------
39-- Table structure for TblUser
40-- ----------------------------
41IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TblUser]') AND type IN ('U'))
42 DROP TABLE [dbo].[TblUser]
43GO
44
45CREATE TABLE [dbo].[TblUser] (
46 [UserId] varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
47 [FirstName] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
48 [LastName] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
49 [PasswordHash] varbinary(200) NULL,
50 [PasswordSalt] varbinary(200) NULL,
51 [CreatedBy] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
52 [CreatedDate] datetime NULL,
53 [UpdatedBy] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
54 [UpdatedDate] datetime NULL,
55 [NotActive] bit NULL,
56 [Roles] int NULL
57)
58GO
59
60ALTER TABLE [dbo].[TblUser] SET (LOCK_ESCALATION = TABLE)
61GO
62
63
64-- ----------------------------
65-- Records of TblUser
66-- ----------------------------
67INSERT INTO [dbo].[TblUser] VALUES (N'fandy', N'Fandy', N'Chaniago', 0x9863715C27DF476C8DD6C9F28CC9E3A9B15C036CC09190F9CE482517ECF76B632579B368ACD224F3CBD9B5EA90C6339C72398D8F59264CAFDDFCD929150F1E68, 0x5C0F90ED0483658BBA9F198C189C072ACE3254E17234DD864754CB582FDDB2D441184AEAAFA4AE8502B25438DC6988C48BF5548AF690C05CC45EDB9C54855EDAADC852F9154F0476CA12F74E4F33BB9DF941064BDF77E247ED166A40DADC66EDAEE560E40384DAF73A19F0200D657650E82D703BD39444DE2237F58D727194D9, NULL, NULL, NULL, NULL, N'0', N'1')
68GO
69
70
71-- ----------------------------
72-- Primary Key structure for table TblRoles
73-- ----------------------------
74ALTER TABLE [dbo].[TblRoles] ADD CONSTRAINT [PK_tblRoles] PRIMARY KEY CLUSTERED ([Id])
75WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
76ON [PRIMARY]
77GO
78
79
80-- ----------------------------
81-- Primary Key structure for table TblUser
82-- ----------------------------
83ALTER TABLE [dbo].[TblUser] ADD CONSTRAINT [PK_TblUser] PRIMARY KEY CLUSTERED ([UserId])
84WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
85ON [PRIMARY]
86GO