-- 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 `aspnetusers`
--

CREATE TABLE IF NOT EXISTS `aspnetusers` (
  `Id` varchar(95) NOT NULL,
  `MobileNumber` longtext,
  `IsDeleted` tinyint(1) NOT NULL,
  `ContactNumber` longtext,
  `FirstName` longtext,
  `LastName` longtext,
  `FullName` longtext,
  `UserRole` longtext,
  `PlanType` longtext,
  `PlanId` int(11) NOT NULL,
  `IsActive` tinyint(1) NOT NULL,
  `IsTrial` tinyint(1) NOT NULL,
  `IsServiceExpired` tinyint(1) NOT NULL,
  `TrialStartDate` datetime(6) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `TrialEndDate` datetime(6) NOT NULL,
  `BusinessName` longtext,
  `ABN` longtext,
  `ACN` longtext,
  `AccountId` longtext,
  `UserRoles` longtext,
  `ModifiedBy` longtext,
  `DeletedBy` longtext,
  `ModifiedDate` datetime(6) NOT NULL,
  `State` longtext,
  `PostCode` longtext,
  `CountryId` int(11) NOT NULL,
  `CountryName` longtext,
  `SubUrb` longtext,
  `UserName` varchar(256) DEFAULT NULL,
  `NormalizedUserName` varchar(256) DEFAULT NULL,
  `Email` varchar(256) DEFAULT NULL,
  `NormalizedEmail` varchar(256) DEFAULT NULL,
  `EmailConfirmed` tinyint(1) NOT NULL,
  `PasswordHash` longtext,
  `SecurityStamp` longtext,
  `ConcurrencyStamp` longtext,
  `PhoneNumber` longtext,
  `PhoneNumberConfirmed` tinyint(1) NOT NULL,
  `TwoFactorEnabled` tinyint(1) NOT NULL,
  `LockoutEnd` datetime(6) DEFAULT NULL,
  `LockoutEnabled` tinyint(1) NOT NULL,
  `AccessFailedCount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Dumping data for table `aspnetusers`
--

INSERT INTO `aspnetusers` (`Id`, `MobileNumber`, `IsDeleted`, `ContactNumber`, `FirstName`, `LastName`, `FullName`, `UserRole`, `PlanType`, `PlanId`, `IsActive`, `IsTrial`, `IsServiceExpired`, `TrialStartDate`, `CreatedDate`, `TrialEndDate`, `BusinessName`, `ABN`, `ACN`, `AccountId`, `UserRoles`, `ModifiedBy`, `DeletedBy`, `ModifiedDate`, `State`, `PostCode`, `CountryId`, `CountryName`, `SubUrb`, `UserName`, `NormalizedUserName`, `Email`, `NormalizedEmail`, `EmailConfirmed`, `PasswordHash`, `SecurityStamp`, `ConcurrencyStamp`, `PhoneNumber`, `PhoneNumberConfirmed`, `TwoFactorEnabled`, `LockoutEnd`, `LockoutEnabled`, `AccessFailedCount`) VALUES
('139d7a3f-e83d-401e-a2ed-a10dd2c7a89b', NULL, 0, NULL, NULL, NULL, 'ewjflkje', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 09:30:58.387737', '2023-05-31 09:30:58.387823', '2023-06-30 09:30:58.387777', 'dwqq421111', '21111111111', NULL, '139d7a3f-e83d-401e-a2ed-a10dd2c7a89b', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', '211111111', '2111', 2, NULL, '122222222', 'ewwe@fewe.com', 'EWWE@FEWE.COM', 'ewwe@fewe.com', 'EWWE@FEWE.COM', 0, NULL, 'M7DZJRKX5ON74E55273CRV2PHQ3IOPBG', 'eee120aa-c9d1-4e04-94c0-6e053db0e5c9', '1111111111', 0, 0, NULL, 1, 0),
('173b88d5-c923-4967-a76f-02aca337f9d5', NULL, 0, NULL, NULL, NULL, 'Abhishek', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-29 12:45:25.036173', '2023-05-29 12:45:25.036261', '2023-06-29 12:45:25.036213', 'Aadiguru Farm Products', '12121212121', NULL, '173b88d5-c923-4967-a76f-02aca337f9d5', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'Gujarat', '0000', 1, NULL, 'Keshod', 'abhishek.sarvaiya@sapphiresolutions.net', 'ABHISHEK.SARVAIYA@SAPPHIRESOLUTIONS.NET', 'abhishek.sarvaiya@sapphiresolutions.net', 'ABHISHEK.SARVAIYA@SAPPHIRESOLUTIONS.NET', 1, 'AQAAAAIAAYagAAAAEC1fgEPCIN+D4DZlV1P/hlU+1xW9wDRGRaD4uV3CLJHQKAQLoFSHgKWBUOw93c/7aw==', 'W3VIOSHXENFE6PA2YRLMW2R636NVYQQQ', 'd166874e-ed9f-43b2-bdd5-0c16a06366fe', '8401050500', 0, 0, NULL, 1, 0),
('19c0c16e-9264-4b7f-afdf-5a5c2594d7e0', NULL, 0, NULL, NULL, NULL, NULL, 'HeadChef', NULL, 0, 0, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'chips_chaperon@hotmail.com', 'CHIPS_CHAPERON@HOTMAIL.COM', 'chips_chaperon@hotmail.com', 'CHIPS_CHAPERON@HOTMAIL.COM', 0, NULL, '6IDUQBFBG6HXPPGXQFQ7P7SJSTIYAAFN', 'ea3efcd0-008e-49a8-91fc-1fc5dff6e29d', NULL, 0, 0, NULL, 1, 0),
('288c89d0-ab65-44c9-a5b2-b8067bcddbcb', NULL, 0, '7768865045', 'Ashendra', 'pal', NULL, 'HeadChef', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '173b88d5-c923-4967-a76f-02aca337f9d5', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'ashendra.pal@sapphiresolutions.net', 'ASHENDRA.PAL@SAPPHIRESOLUTIONS.NET', 'ashendra.pal@sapphiresolutions.net', 'ASHENDRA.PAL@SAPPHIRESOLUTIONS.NET', 1, 'AQAAAAIAAYagAAAAEEY4g6+ePKc4TGJOo/ZQNl1eSV6pMeQqEg0fEoSuQVz2LXEtfr6qs1+r8iQErEGcpw==', 'A5MGH7BJ3A4CD4QAVPI3TCGRELRHCHND', '6a9c2f39-e5ef-4ffb-90c7-26ffe56a2c02', '7768865045', 0, 0, NULL, 1, 0),
('3596f068-943c-472c-b33e-a4b93ef23637', NULL, 0, '0413030025', 'tom', 'jones', NULL, 'Administrator', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, '2023-06-01 09:16:06.210869', NULL, NULL, 0, NULL, NULL, 'chapers@gmx.com', 'CHAPERS@GMX.COM', 'chapers@gmx.com', 'CHAPERS@GMX.COM', 1, 'AQAAAAIAAYagAAAAEBYnlUFwfam2WfJmlpSmXXhGxjHnn79yMpu+72y78Dnvl4GqpwYxO+88uiX4KvDS2Q==', '7U3PPMBW7FME5EHUPHL2VL73IX66WOCU', 'a1cedd85-35d9-4830-aa7a-d1080081c123', '0413030025', 0, 0, NULL, 1, 0),
('3826514c-c832-4bee-bfe1-50208b19be75', NULL, 0, NULL, NULL, NULL, 'test account', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 09:55:04.907670', '2023-05-31 09:55:04.907752', '2023-06-30 09:55:04.907709', 'the hotels', '12222222222', NULL, '3826514c-c832-4bee-bfe1-50208b19be75', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gujarat', '7877', 3, NULL, 'ahmedabad', 'testaccount1@gmail.com', 'TESTACCOUNT1@GMAIL.COM', 'testaccount1@gmail.com', 'TESTACCOUNT1@GMAIL.COM', 0, NULL, '2QCHLS7E36I25LFBVQZHQ5YGJLWMMV6M', 'e117585f-1ad8-4b48-b45f-2e6c00dd9dcf', '9366554488', 0, 0, NULL, 1, 0),
('43d2c72a-5004-4cd9-aff5-bf5433b49cce', NULL, 0, '1234567898', 'waiter', 'waiter', NULL, 'Waiter', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, 'ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'waiter@yopmail.com', 'WAITER@YOPMAIL.COM', 'waiter@yopmail.com', 'WAITER@YOPMAIL.COM', 1, 'AQAAAAIAAYagAAAAEKNWxTlvCttwu29cpcipa/9M4b62t50JEq9W0wN1oCt8aCTUrf3NfFIibx/iy8b2qg==', 'I6RGUEVNXRHGHZU76WA3FORS5MRBWQN6', 'bdb6097e-ac22-47a3-b30f-c289cc592de8', '7412589632', 0, 0, NULL, 1, 0),
('45e7b575-cbcb-4240-a584-5e0f094d2df4', NULL, 0, NULL, NULL, NULL, 'eweew', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 10:24:02.811642', '2023-05-31 10:24:02.811645', '2023-06-30 10:24:02.811642', 'ffdfds', '53454353453', NULL, '45e7b575-cbcb-4240-a584-5e0f094d2df4', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'zvvdsdv', '43', 3, NULL, 'fvv', 'test1@gmail.com', 'TEST1@GMAIL.COM', 'test1@gmail.com', 'TEST1@GMAIL.COM', 0, NULL, 'P5GBLS6GHHPFB6KK6XDBL5EP5ZWSOD2H', 'f47b8c84-969a-48ad-98b3-32058f70fd7d', '5463666666', 0, 0, NULL, 1, 0),
('48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, 0, NULL, NULL, NULL, 'hkjhkhkjhkjhkjhkhjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-06-02 08:03:27.748224', '2023-06-02 08:03:27.748311', '2023-07-02 08:03:27.748264', 'gjhgjhg', '67567575754', NULL, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'hgfhfh', '5555', 1, NULL, 'jhgjgjg', 'nkbapodra@gmail.com', 'NKBAPODRA@GMAIL.COM', 'nkbapodra@gmail.com', 'NKBAPODRA@GMAIL.COM', 1, 'AQAAAAIAAYagAAAAEA1QbeoVKK6NiGiF5urg7ewn77cPMLCzaDlCWcSVYDATyV3m33qGGZ1zlR6/rnYFQA==', 'SM7RWK4UVDHHAFVVH5DQMYTDZ4TDJM7T', '90193e93-95f3-4d01-975e-e940d663e4a1', '6868768768', 0, 0, NULL, 1, 0),
('52fa4d8f-fe3b-4bae-a3cd-6dcb2cf67c9c', NULL, 0, '0419533442', 'tom', 'jones', NULL, 'Administrator', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'desertowl@gmx.com', 'DESERTOWL@GMX.COM', 'desertowl@gmx.com', 'DESERTOWL@GMX.COM', 1, 'AQAAAAIAAYagAAAAEET+UXGhjdyQtPbdO9ywN2R3qstDuZUI78exkHBmjsEiYKfTx3UEU/pxpVLqnYOc9Q==', 'ZW5LGMLBX3UP3IIMR4CNATSL677ZKRBF', '936de77d-fc05-4a4e-98f6-4fd4b175594a', '0419533442', 0, 0, NULL, 1, 0),
('6656f4bf-fcaa-4072-847e-21369aebec12', NULL, 0, NULL, NULL, NULL, 'hemant', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-29 12:20:32.338386', '2023-05-29 12:20:32.338546', '2023-06-29 12:20:32.338451', 'hemant', NULL, '123456789', '6656f4bf-fcaa-4072-847e-21369aebec12', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gujarat', '1020', 1, NULL, 'sa', 'hemant.ambaliya@vidyalayaschoolsoftware.com', 'HEMANT.AMBALIYA@VIDYALAYASCHOOLSOFTWARE.COM', 'hemant.ambaliya@vidyalayaschoolsoftware.com', 'HEMANT.AMBALIYA@VIDYALAYASCHOOLSOFTWARE.COM', 1, 'AQAAAAIAAYagAAAAEJF0BowWFbf4AHpGSomOmS/gpgXPZYpO6DedNQ5iHuWMHonm1Yi216qdkkFHYGJP6A==', 'FESQYUW7OQTEMULPQFWP6P3LJPRSS7G3', '2dfaad10-64be-4e44-ac39-7e6806724aa5', '1234567890', 0, 0, NULL, 1, 0),
('6d627a0a-dbe2-461f-99cf-c88ec55900e7', NULL, 0, NULL, NULL, NULL, 'fewjnfkjwej', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 10:23:00.553915', '2023-05-31 10:23:00.554002', '2023-06-30 10:23:00.553955', '54444', '23444444444', NULL, '6d627a0a-dbe2-461f-99cf-c88ec55900e7', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gffffffffff', '4564', 3, NULL, 'hfghhhhhhhhhhhh', 'fewefw@ferre.com', 'FEWEFW@FERRE.COM', 'fewefw@ferre.com', 'FEWEFW@FERRE.COM', 0, NULL, '5A3N4MKBVYAZEGO7TWFZ6YXLIA2ZBD6R', '82828b7f-7a9e-4604-b854-e9b4c2c58bf7', '5433333333', 0, 0, NULL, 1, 0),
('6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, 0, NULL, NULL, NULL, 'nick', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 02:08:28.845600', '2023-05-31 02:08:28.845689', '2023-06-30 02:08:28.845641', 'attis', NULL, '123456789', '6dca0e0f-4cbe-4ae8-bd99-4c3f9ec97dae', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'vic', '3179', 1, NULL, 'Dandening', 'nick@attis.au', 'NICK@ATTIS.AU', 'nick@attis.au', 'NICK@ATTIS.AU', 1, 'AQAAAAIAAYagAAAAEFMccv2Xkk3i20XHr3hWzi5QoQmk9SetCH/ivj6THJPgFwoIBzJojIet9Vgo7Itz9A==', 'BSLLH27XGEQNQ2CXSBYO7RAUCROY5EEG', '07e0bea8-534c-47f0-a93a-83bf328c1e82', '0413030025', 0, 0, NULL, 1, 0),
('71a0d475-6ac4-44cb-9628-e7ded6467861', NULL, 0, NULL, NULL, NULL, NULL, 'Waiter', NULL, 0, 0, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, 'f5b61f76-3603-4ed5-a04f-d16ae73bd457', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'gfnfgnxfgn2@hdfewsdfese.com', 'GFNFGNXFGN2@HDFEWSDFESE.COM', 'gfnfgnxfgn2@hdfewsdfese.com', 'GFNFGNXFGN2@HDFEWSDFESE.COM', 0, NULL, '3YAYKJXKHGVE6TKBQ56B3GO73DDVGXG5', '98e19e7e-8932-438c-85ae-c6e400efb679', NULL, 0, 0, NULL, 1, 0),
('78bd4c41-a968-48f6-9d68-6bd7c51aad79', NULL, 0, NULL, NULL, NULL, NULL, 'Waiter', NULL, 0, 0, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'nkbapodra1@gmail.com', 'NKBAPODRA1@GMAIL.COM', 'nkbapodra1@gmail.com', 'NKBAPODRA1@GMAIL.COM', 0, NULL, 'XJ3X4AIO46ESLUAZ6VKY2JWH5PCK4MS2', 'b27175d2-10e3-402d-b62e-36274fc85ef0', NULL, 0, 0, NULL, 1, 0),
('807f226c-0a41-4cd4-a46a-fd254b1c8a1f', NULL, 0, NULL, NULL, NULL, 'Maitri', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 14:07:22.396198', '2023-05-31 14:07:22.396369', '2023-06-30 14:07:22.396277', 'test', '00000000000', NULL, '807f226c-0a41-4cd4-a46a-fd254b1c8a1f', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'test', '0000', 1, NULL, 'test', 'maitri.shah@sapphiresolutions.net', 'MAITRI.SHAH@SAPPHIRESOLUTIONS.NET', 'maitri.shah@sapphiresolutions.net', 'MAITRI.SHAH@SAPPHIRESOLUTIONS.NET', 1, 'AQAAAAIAAYagAAAAEAclZ/3qBF1Gyz3tJyrFMC99TcOLj2PBPpWqqLpxyyc0PEejCdNWcFJ2Q6ERSpEcgg==', 'WE52ICRLNGXTGR4C6XQLU32CIZBNIMX4', '5416e763-1daa-4ae9-a5ee-ba9a77b60dd8', '4567813245', 0, 0, NULL, 1, 0),
('8323523c-8ced-4247-b5f0-e2c8dedc9cde', NULL, 0, NULL, NULL, NULL, NULL, 'HeadChef', NULL, 0, 0, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, 'ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'HeadChef@yopmail.com', 'HEADCHEF@YOPMAIL.COM', 'HeadChef@yopmail.com', 'HEADCHEF@YOPMAIL.COM', 0, NULL, 'BZEEUSKVBPLBUIWIXYISSFH5SEGL44IX', 'e28c2b22-85b7-4194-88bc-12ef3a775225', NULL, 0, 0, NULL, 1, 0),
('8434d5f4-5573-4e7e-9a4c-9b83d9dcac50', NULL, 0, NULL, NULL, NULL, NULL, 'HeadChef', NULL, 0, 0, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'a@b.com', 'A@B.COM', 'a@b.com', 'A@B.COM', 0, NULL, 'OCNYKCAXBCVNM5C62EAIEEWXEMTB6WUA', 'd5ad47c4-80a9-4ddb-bb73-7a06f0006610', NULL, 0, 0, NULL, 1, 0),
('9298af01-f83a-4b9e-a11c-f47843dab940', NULL, 1, '4333333333', 'dwdw', 'wdwd', NULL, 'Waiter', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, 'ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 0, NULL, NULL, 'userofoodtrail@yopmail.com', 'USEROFOODTRAIL@YOPMAIL.COM', 'userofoodtrail@yopmail.com', 'USEROFOODTRAIL@YOPMAIL.COM', 0, 'AQAAAAIAAYagAAAAELV+ydSamEeJrBKljvldihny5QkDjq0xM3fgnxvpeT4zX/27j10rfvnpRm5Bn0nfcQ==', 'UIJKHYAJ3557DRPZIBWJHPZPBL45T3DX', 'e042a1bf-0e6b-47ee-beea-f74f90f2bd3e', '2333333333', 0, 0, NULL, 1, 0),
('a55fe882-2a9a-4b69-ac32-4e0778f94c16', NULL, 0, NULL, NULL, NULL, 'test account', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 09:31:03.449257', '2023-05-31 09:31:03.449259', '2023-06-30 09:31:03.449257', 'The taj hotels ', '11111111111', NULL, 'a55fe882-2a9a-4b69-ac32-4e0778f94c16', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gujarat', '4654', 3, NULL, 'nr SG highway', 'testaccount@yopmail.com', 'TESTACCOUNT@YOPMAIL.COM', 'testaccount@yopmail.com', 'TESTACCOUNT@YOPMAIL.COM', 0, NULL, 'LJD3JFTGM46XZBRHBGBIHAOYC5AI2XYG', 'a855a4e3-2124-43a6-9b63-a959ba0d8b6e', '9377117777', 0, 0, NULL, 1, 0),
('a6b2c5d9-4037-4626-a165-88246ac90baa', NULL, 0, '0444444444', 'Naren', 'B', NULL, 'HeadChef', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, '48d04488-adb9-41ed-a3d2-3966bf094ce3', NULL, '2023-06-03 12:45:07.249561', NULL, NULL, 0, NULL, NULL, 'nkbapodra@yahoo.com', 'NKBAPODRA@YAHOO.COM', 'nkbapodra@yahoo.com', 'NKBAPODRA@YAHOO.COM', 1, 'AQAAAAIAAYagAAAAEMtozK8JEGRS78hFGKuHKvprKB+mdKdgHwHcTuPEdqcJXYV8xVq3/LE9CGYdfSWPMA==', 'GD2OPMPOZEINTUNTSDPRL433Y5O7DCNE', 'f8940fee-d541-4610-9a1c-19f623c98a94', '0444444444', 0, 0, NULL, 1, 0),
('ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, 0, NULL, NULL, NULL, 'foodtrail account', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 10:34:33.753752', '2023-05-31 10:34:33.753758', '2023-06-30 10:34:33.753754', 'the taj', '11111111111', NULL, 'ab4ef57d-17e8-4c11-a080-11a960f9d644', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gujarat', '5656', 3, NULL, 'ahmedabad', 'foodtrail@yopmail.com', 'FOODTRAIL@YOPMAIL.COM', 'foodtrail@yopmail.com', 'FOODTRAIL@YOPMAIL.COM', 1, 'AQAAAAIAAYagAAAAECP6hXEYhO6bJ++Zsf49ElFE5LO1+8Mm1J1yzBQsiAQ8tjhYSSm3MAlBP1Dy/cMNzw==', '4E3LOBXXUXISUFDOR4ZC6HEV7XQATJDA', 'a05ee3b8-7c12-446a-9246-3f27315ec316', '9874566541', 0, 0, NULL, 1, 0),
('caa0e99b-59f1-4a34-b967-d4565816750a', NULL, 0, NULL, NULL, NULL, 'foodtrail admin', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 09:57:42.895682', '2023-05-31 09:57:42.895686', '2023-06-30 09:57:42.895683', 'the hotels', '12345678909', NULL, 'caa0e99b-59f1-4a34-b967-d4565816750a', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'gujarat', '7775', 3, NULL, 'ahmedabad', 'foodtrailadmin@yopmail.com', 'FOODTRAILADMIN@YOPMAIL.COM', 'foodtrailadmin@yopmail.com', 'FOODTRAILADMIN@YOPMAIL.COM', 1, 'AQAAAAIAAYagAAAAEDZzc8BTEYNe6Di7yAiX+FcqbBREHve70NmnAdTVyYWp/hg9UOl0BRfExVeLRuMGqQ==', 'HRDLCQT4V3PYE7IWUOBJTCG4JOV5LLWI', '63e12b07-7720-4af0-b29f-071b532ba936', '9090787865', 0, 0, NULL, 1, 0),
('ec86010b-44ec-40e5-8191-45fc7892615f', NULL, 0, NULL, NULL, NULL, 'rewww', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 10:27:34.735863', '2023-05-31 10:27:34.735866', '2023-06-30 10:27:34.735864', 'rrrrrrrrrrrrre', '33333333333', NULL, 'ec86010b-44ec-40e5-8191-45fc7892615f', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'eeeeeeeeeeeeeeeeeeeeeeeee', '4444', 2, NULL, 'eeeeeeeeee', 'test1@yopmail.com', 'TEST1@YOPMAIL.COM', 'test1@yopmail.com', 'TEST1@YOPMAIL.COM', 1, 'AQAAAAIAAYagAAAAELsTfzOZgQcqNbv8MrdZ9MaymvTDo/QdwhamRZxVmeUrPqI3HF7h8pJg6q98pCUhLQ==', 'YVQOFQK4DYBQ4EXJO3ZISZ2D4QYZ4RJA', 'd041a50f-c6d7-40e7-ae0d-02062124cdf1', '6555555555', 0, 0, NULL, 1, 0),
('f5b61f76-3603-4ed5-a04f-d16ae73bd457', NULL, 0, NULL, NULL, NULL, 'Imok', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-06-02 08:34:06.530870', '2023-06-02 08:34:06.530954', '2023-07-02 08:34:06.530910', 'asfd', NULL, '123455123', 'f5b61f76-3603-4ed5-a04f-d16ae73bd457', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'vds', '1234', 3, NULL, 'wrwaqrw', 'iminvisibleok@gmail.com', 'IMINVISIBLEOK@GMAIL.COM', 'iminvisibleok@gmail.com', 'IMINVISIBLEOK@GMAIL.COM', 1, 'AQAAAAIAAYagAAAAEBgbGAx64pN85pPezYWksoB80QKexqtb2DA7mydlPn0BmaQzKsNsOrOh+rY9IQJSyQ==', 'Q6MLBFJJYKROW7ECSDD3YNGH67RGOLBY', '53d0309e-f956-45da-9b0b-5094776e849e', '2312434312', 0, 0, NULL, 1, 0),
('fc28511a-e47e-4527-81f5-12c45ec1d329', NULL, 0, NULL, NULL, NULL, 'manathn', NULL, 'Free-Trial', 0, 1, 1, 0, '2023-05-31 06:06:12.309880', '2023-05-31 06:06:12.309967', '2023-06-30 06:06:12.309920', 'as', '12345678900', NULL, 'fc28511a-e47e-4527-81f5-12c45ec1d329', NULL, NULL, NULL, '0001-01-01 00:00:00.000000', 'Gujarat', '1020', 3, NULL, '123454567890', 'manthan.sukhadiya@sapphiresolutions.net', 'MANTHAN.SUKHADIYA@SAPPHIRESOLUTIONS.NET', 'manthan.sukhadiya@sapphiresolutions.net', 'MANTHAN.SUKHADIYA@SAPPHIRESOLUTIONS.NET', 1, 'AQAAAAIAAYagAAAAEHcWxcjjSWS9EIPqFAvoAd/NHwHPq3OWLP4KQERLYtBdMeZwti/6ZLeGlGRgXYv37A==', 'RKFPY3YUV7ENKCAES5NC4A7YIM4FTA27', 'ee8fd79e-5f2e-43c2-a01b-0e55c25850bd', '1234567890', 0, 0, NULL, 1, 0),
('fde57016-2542-49d6-939c-5985a5d9c172', NULL, 0, '1452145210', 'Rajnikant', 'kumar', NULL, 'HeadChef', NULL, 0, 1, 0, 0, '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', '0001-01-01 00:00:00.000000', NULL, NULL, NULL, '173b88d5-c923-4967-a76f-02aca337f9d5', NULL, '173b88d5-c923-4967-a76f-02aca337f9d5', NULL, '2023-05-29 12:59:05.134533', NULL, NULL, 0, NULL, NULL, 'rajnikant.kumar@sapphiresolutions.net', 'RAJNIKANT.KUMAR@SAPPHIRESOLUTIONS.NET', 'rajnikant.kumar@sapphiresolutions.net', 'RAJNIKANT.KUMAR@SAPPHIRESOLUTIONS.NET', 1, 'AQAAAAIAAYagAAAAEC0BYe4FNZxX7ksXCgH5vvuk2fcIZ7nzgaU48JuRq9yLBBslW9KRqcKd912vJk0Srg==', 'HYVI3GDJVJOZJ5PDOFZCPK747VMIXFT5', '2d88c956-dda1-4b4d-98bd-0d7b1c720832', '7410258963', 0, 0, NULL, 1, 0);

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

--
-- 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 `aspnetusers`
--
ALTER TABLE `aspnetusers`
  ADD PRIMARY KEY (`Id`),
  ADD UNIQUE KEY `UserNameIndex` (`NormalizedUserName`),
  ADD KEY `EmailIndex` (`NormalizedEmail`);

--
-- 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;

