-- http://www.phpmyadmin.net
--




--
-- Database: `foodtrailadminstage`
--

-- --------------------------------------------------------

--
-- Table structure for table `aspnetroleclaims`
--

CREATE TABLE IF NOT EXISTS `aspnetroleclaims` (
  `Id` int(11) NOT NULL,
  `RoleId` varchar(95) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- --------------------------------------------------------

--
-- Table structure for table `aspnetroles`
--

CREATE TABLE IF NOT EXISTS `aspnetroles` (
  `Id` varchar(95) NOT NULL,
  `Name` varchar(256) DEFAULT NULL,
  `NormalizedName` varchar(256) DEFAULT NULL,
  `ConcurrencyStamp` longtext
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Dumping data for table `aspnetroles`
--

INSERT INTO `aspnetroles` (`Id`, `Name`, `NormalizedName`, `ConcurrencyStamp`) VALUES
('1', 'Administrator', 'ADMINISTRATOR', ''),
('2', 'HeadChef', 'HEADCHEF', ''),
('3', 'Chef', 'CHEF', ''),
('4', 'Waiter', 'WAITER', '');

-- --------------------------------------------------------

--
-- Table structure for table `aspnetuserclaims`
--

CREATE TABLE IF NOT EXISTS `aspnetuserclaims` (
  `Id` int(11) NOT NULL,
  `UserId` varchar(95) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- --------------------------------------------------------

--
-- Table structure for table `aspnetuserlogins`
--

CREATE TABLE IF NOT EXISTS `aspnetuserlogins` (
  `LoginProvider` varchar(95) NOT NULL,
  `ProviderKey` varchar(95) NOT NULL,
  `ProviderDisplayName` longtext,
  `UserId` varchar(95) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- --------------------------------------------------------

--
-- Table structure for table `aspnetuserroles`
--

CREATE TABLE IF NOT EXISTS `aspnetuserroles` (
  `UserId` varchar(95) NOT NULL,
  `RoleId` varchar(95) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Dumping data for table `aspnetuserroles`
--

INSERT INTO `aspnetuserroles` (`UserId`, `RoleId`) VALUES
('173b88d5-c923-4967-a76f-02aca337f9d5', '1'),
('3596f068-943c-472c-b33e-a4b93ef23637', '1'),
('48d04488-adb9-41ed-a3d2-3966bf094ce3', '1'),
('6656f4bf-fcaa-4072-847e-21369aebec12', '1'),
('6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', '1'),
('807f226c-0a41-4cd4-a46a-fd254b1c8a1f', '1'),
('a6b2c5d9-4037-4626-a165-88246ac90baa', '1'),
('ab4ef57d-17e8-4c11-a080-11a960f9d644', '1'),
('ec86010b-44ec-40e5-8191-45fc7892615f', '1'),
('f5b61f76-3603-4ed5-a04f-d16ae73bd457', '1'),
('fc28511a-e47e-4527-81f5-12c45ec1d329', '1'),
('288c89d0-ab65-44c9-a5b2-b8067bcddbcb', '2'),
('a6b2c5d9-4037-4626-a165-88246ac90baa', '2'),
('fde57016-2542-49d6-939c-5985a5d9c172', '2'),
('43d2c72a-5004-4cd9-aff5-bf5433b49cce', '4'),
('9298af01-f83a-4b9e-a11c-f47843dab940', '4');

-- --------------------------------------------------------

--
-- Table structure for table `aspnetusertokens`
--

CREATE TABLE IF NOT EXISTS `aspnetusertokens` (
  `UserId` varchar(95) NOT NULL,
  `LoginProvider` varchar(95) NOT NULL,
  `Name` varchar(95) NOT NULL,
  `Value` longtext
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- --------------------------------------------------------

--
-- Table structure for table `planhistories`
--

CREATE TABLE IF NOT EXISTS `planhistories` (
  `Id` int(11) NOT NULL,
  `AccountId` longtext,
  `PlanType` longtext,
  `PlanDurationType` longtext,
  `StartDate` datetime(6) NOT NULL,
  `EndDate` datetime(6) NOT NULL,
  `IsFreeTrial` tinyint(1) NOT NULL,
  `IsPlanActive` tinyint(1) NOT NULL,
  `Active` tinyint(1) NOT NULL,
  `Deleted` tinyint(1) NOT NULL,
  `CreatedBy` longtext,
  `CreatedDate` datetime(6) DEFAULT NULL,
  `ModifiedBy` longtext,
  `ModifiedDate` datetime(6) DEFAULT NULL,
  `DeletedBy` longtext,
  `DeletedDate` datetime(6) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=ascii;

--
-- Dumping data for table `planhistories`
--

INSERT INTO `planhistories` (`Id`, `AccountId`, `PlanType`, `PlanDurationType`, `StartDate`, `EndDate`, `IsFreeTrial`, `IsPlanActive`, `Active`, `Deleted`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `DeletedBy`, `DeletedDate`) VALUES
(1, '6656f4bf-fcaa-4072-847e-21369aebec12', NULL, NULL, '2023-05-29 12:20:32.696672', '2023-06-29 12:20:32.696757', 1, 1, 1, 0, NULL, '2023-05-29 12:20:32.696620', NULL, NULL, NULL, NULL),
(2, '173b88d5-c923-4967-a76f-02aca337f9d5', NULL, NULL, '2023-05-29 12:45:25.450175', '2023-06-29 12:45:25.450257', 1, 1, 1, 0, NULL, '2023-05-29 12:45:25.450133', NULL, NULL, NULL, NULL),
(3, '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, NULL, '2023-05-31 02:08:29.256483', '2023-06-30 02:08:29.256565', 1, 1, 1, 0, NULL, '2023-05-31 02:08:29.256441', NULL, NULL, NULL, NULL),
(4, 'fc28511a-e47e-4527-81f5-12c45ec1d329', NULL, NULL, '2023-05-31 06:06:12.777190', '2023-06-30 06:06:12.777319', 1, 1, 1, 0, NULL, '2023-05-31 06:06:12.777130', NULL, NULL, NULL, NULL),
(5, '139d7a3f-e83d-401e-a2ed-a10dd2c7a89b', NULL, NULL, '2023-05-31 09:30:58.831376', '2023-06-30 09:30:58.831505', 1, 1, 1, 0, NULL, '2023-05-31 09:30:58.831312', NULL, NULL, NULL, NULL),
(6, 'a55fe882-2a9a-4b69-ac32-4e0778f94c16', NULL, NULL, '2023-05-31 09:31:03.459560', '2023-06-30 09:31:03.459561', 1, 1, 1, 0, NULL, '2023-05-31 09:31:03.459560', NULL, NULL, NULL, NULL),
(7, '3826514c-c832-4bee-bfe1-50208b19be75', NULL, NULL, '2023-05-31 09:55:05.150479', '2023-06-30 09:55:05.150579', 1, 1, 1, 0, NULL, '2023-05-31 09:55:05.150408', NULL, NULL, NULL, NULL),
(8, 'caa0e99b-59f1-4a34-b967-d4565816750a', NULL, NULL, '2023-05-31 09:57:42.904036', '2023-06-30 09:57:42.904036', 1, 1, 1, 0, NULL, '2023-05-31 09:57:42.904035', NULL, NULL, NULL, NULL),
(9, '6d627a0a-dbe2-461f-99cf-c88ec55900e7', NULL, NULL, '2023-05-31 10:23:00.607689', '2023-06-30 10:23:00.607772', 1, 1, 1, 0, NULL, '2023-05-31 10:23:00.607645', NULL, NULL, NULL, NULL),
(10, '45e7b575-cbcb-4240-a584-5e0f094d2df4', NULL, NULL, '2023-05-31 10:24:02.819763', '2023-06-30 10:24:02.819763', 1, 1, 1, 0, NULL, '2023-05-31 10:24:02.819762', NULL, NULL, NULL, NULL),
(11, 'ec86010b-44ec-40e5-8191-45fc7892615f', NULL, NULL, '2023-05-31 10:27:34.744203', '2023-06-30 10:27:34.744204', 1, 1, 1, 0, NULL, '2023-05-31 10:27:34.744202', NULL, NULL, NULL, NULL),
(12, 'ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, NULL, '2023-05-31 10:34:33.761226', '2023-06-30 10:34:33.761230', 1, 1, 1, 0, NULL, '2023-05-31 10:34:33.761223', NULL, NULL, NULL, NULL),
(13, '807f226c-0a41-4cd4-a46a-fd254b1c8a1f', NULL, NULL, '2023-05-31 14:07:22.666182', '2023-06-30 14:07:22.666269', 1, 1, 1, 0, NULL, '2023-05-31 14:07:22.666132', NULL, NULL, NULL, NULL),
(14, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, NULL, '2023-06-02 08:03:28.206989', '2023-07-02 08:03:28.207139', 1, 1, 1, 0, NULL, '2023-06-02 08:03:28.206919', NULL, NULL, NULL, NULL),
(15, 'f5b61f76-3603-4ed5-a04f-d16ae73bd457', NULL, NULL, '2023-06-02 08:34:06.542064', '2023-07-02 08:34:06.542136', 1, 1, 1, 0, NULL, '2023-06-02 08:34:06.542060', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `__efmigrationshistory`
--

CREATE TABLE IF NOT EXISTS `__efmigrationshistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aspnetroleclaims`
--
ALTER TABLE `aspnetroleclaims`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `IX_AspNetRoleClaims_RoleId` (`RoleId`);

--
-- Indexes for table `aspnetroles`
--
ALTER TABLE `aspnetroles`
  ADD PRIMARY KEY (`Id`),
  ADD UNIQUE KEY `RoleNameIndex` (`NormalizedName`);

--
-- Indexes for table `aspnetuserclaims`
--
ALTER TABLE `aspnetuserclaims`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `IX_AspNetUserClaims_UserId` (`UserId`);

--
-- Indexes for table `aspnetuserlogins`
--
ALTER TABLE `aspnetuserlogins`
  ADD PRIMARY KEY (`LoginProvider`,`ProviderKey`),
  ADD KEY `IX_AspNetUserLogins_UserId` (`UserId`);

--
-- Indexes for table `aspnetuserroles`
--
ALTER TABLE `aspnetuserroles`
  ADD PRIMARY KEY (`UserId`,`RoleId`),
  ADD KEY `IX_AspNetUserRoles_RoleId` (`RoleId`);

--
-- Indexes for table `aspnetusertokens`
--
ALTER TABLE `aspnetusertokens`
  ADD PRIMARY KEY (`UserId`,`LoginProvider`,`Name`);

--
-- Indexes for table `planhistories`
--
ALTER TABLE `planhistories`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `__efmigrationshistory`
--
ALTER TABLE `__efmigrationshistory`
  ADD PRIMARY KEY (`MigrationId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aspnetroleclaims`
--
ALTER TABLE `aspnetroleclaims`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `aspnetuserclaims`
--
ALTER TABLE `aspnetuserclaims`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `planhistories`
--
ALTER TABLE `planhistories`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `aspnetroleclaims`
--
ALTER TABLE `aspnetroleclaims`
  ADD CONSTRAINT `FK_AspNetRoleClaims_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE;

--
-- Constraints for table `aspnetuserclaims`
--
ALTER TABLE `aspnetuserclaims`
  ADD CONSTRAINT `FK_AspNetUserClaims_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE;

--
-- Constraints for table `aspnetuserlogins`
--
ALTER TABLE `aspnetuserlogins`
  ADD CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE;

--
-- Constraints for table `aspnetuserroles`
--
ALTER TABLE `aspnetuserroles`
  ADD CONSTRAINT `FK_AspNetUserRoles_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_AspNetUserRoles_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE;

--
-- Constraints for table `aspnetusertokens`
--
ALTER TABLE `aspnetusertokens`
  ADD CONSTRAINT `FK_AspNetUserTokens_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE;

