23SVEHTE

1--
2-- MySql ASP.NET Core Identity
3--
4
5--
6-- Table structure for table `aspnetroles`
7--
8
9CREATE TABLE IF NOT EXISTS AspNetRoles (
10  `Id` varchar(128) NOT NULL,
11  `Name` varchar(256) NOT NULL,
12  PRIMARY KEY (`Id`)
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14
15-- --------------------------------------------------------
16
17--
18-- Table structure for table `aspnetuserclaims`
19--
20
21CREATE TABLE IF NOT EXISTS AspNetUserClaims (
22  `Id` int(11) NOT NULL AUTO_INCREMENT,
23  `UserId` varchar(128) NOT NULL,
24  `ClaimType` longtext,
25  `ClaimValue` longtext,
26  PRIMARY KEY (`Id`),
27  UNIQUE KEY `Id` (`Id`),
28  KEY `UserId` (`UserId`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `aspnetuserlogins`
35--
36
37CREATE TABLE IF NOT EXISTS AspNetUserLogins (
38  `LoginProvider` varchar(128) NOT NULL,
39  `ProviderKey` varchar(128) NOT NULL,
40  `UserId` varchar(128) NOT NULL,
41  PRIMARY KEY (`LoginProvider`,`ProviderKey`,`UserId`),
42  KEY `ApplicationUser_Logins` (`UserId`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `aspnetuserroles`
49--
50
51CREATE TABLE IF NOT EXISTS AspNetUserRoles (
52  `UserId` varchar(128) NOT NULL,
53  `RoleId` varchar(128) NOT NULL,
54  PRIMARY KEY (`UserId`,`RoleId`),
55  KEY `IdentityRole_Users` (`RoleId`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `aspnetusers`
62--
63
64CREATE TABLE IF NOT EXISTS AspNetUsers (
65  `Id` varchar(128) NOT NULL,
66  `ConcurrencyStamp` varchar(256) DEFAULT NULL,
67  `Email` varchar(256) DEFAULT NULL,
68  `EmailConfirmed` tinyint(1) NOT NULL,
69  `PasswordHash` longtext,
70  `SecurityStamp` longtext,
71  `PhoneNumber` longtext,
72  `PhoneNumberConfirmed` tinyint(1) NOT NULL,
73  `TwoFactorEnabled` tinyint(1) NOT NULL,
74  `LockoutEndDateUtc` datetime DEFAULT NULL,
75  `LockoutEnabled` tinyint(1) NOT NULL,
76  `AccessFailedCount` int(11) NOT NULL,
77  `UserName` varchar(256) NOT NULL,
78  `LockoutEnd` datetime DEFAULT NULL,
79  `NormalizedEmail` varchar(256) DEFAULT NULL,
80  `NormalizedUserName` varchar(256) DEFAULT NULL,
81  PRIMARY KEY (`Id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `aspnetusertokens`
88--
89
90CREATE TABLE IF NOT EXISTS AspNetUserTokens (
91`UserId` varchar(128) NOT NULL,
92`LoginProvider` varchar(127) NOT NULL,
93Name varchar(127) NOT NULL,
94Value longtext,
95CONSTRAINT PK_AspNetUserTokens PRIMARY KEY (UserId, LoginProvider, Name)
96);
97
98--
99-- Constraints for dumped tables
100--
101
102--
103-- Constraints for table `aspnetuserclaims`
104--
105ALTER TABLE AspNetUserClaims
106  ADD CONSTRAINT `ApplicationUser_Claims` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE ON UPDATE NO ACTION;
107
108--
109-- Constraints for table `aspnetuserlogins`
110--
111ALTER TABLE AspNetUserLogins
112  ADD CONSTRAINT `ApplicationUser_Logins` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE ON UPDATE NO ACTION;
113
114--
115-- Constraints for table `aspnetuserroles`
116--
117ALTER TABLE AspNetUserRoles
118  ADD CONSTRAINT `ApplicationUser_Roles` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE ON UPDATE NO ACTION,
119  ADD CONSTRAINT `IdentityRole_Users` FOREIGN KEY (`RoleId`) REFERENCES `AspNetRoles` (`Id`) ON DELETE CASCADE ON UPDATE NO ACTION;