CREATE TABLE `other_info` (
  `Id` int NOT NULL,
  `Name` text NOT NULL,
  `ItemType` varchar(500) NOT NULL,
  `ImageUrl` text NOT NULL,
  `ParentId` varchar(400) NOT NULL,
  `Notes` text NOT NULL,
  `ItemValue` text NOT NULL,
  `Status` varchar(100) NOT NULL,
  `Decription` text NOT NULL,
  `Rules` text NOT NULL,
  `ItemCode` text NOT NULL,
  `CreateDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Slug` varchar(1000)  DEFAULT NULL
) ;


CREATE TABLE `user` (
  `UserId` varchar(225) NOT NULL,
  `CompanyId` varchar(225) DEFAULT NULL,
  `ParentCompanyId` varchar(225) DEFAULT NULL,
  `UserType` varchar(30) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Surname` varchar(50) NOT NULL,
  `Email` varchar(500) NOT NULL,
  `PhoneNumber` varchar(225) DEFAULT NULL,
  `Password` varchar(100) NOT NULL,
  `Dp` text,
  `CreateDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CreateUserId` varchar(225) NOT NULL,
  `ModifyDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ModifyUserId` varchar(225) NOT NULL,
  `StatusId` int NOT NULL,
  `UserToken` varchar(225) DEFAULT NULL,
  `AddressLineHome` text,
  `AddressUrlHome` text,
  `AddressLineWork` text,
  `AddressUrlWork` text,
  `ReferralCode` varchar(100) DEFAULT NULL,
  `ParentReferralCode` varchar(100) DEFAULT NULL,
  `AddressLine2` text NOT NULL,
  `BuildingType` varchar(100) NOT NULL,
  `City` varchar(100) NOT NULL,
  `CompanyName` varchar(100) NOT NULL,
  `PostalCode` varchar(50) NOT NULL,
  `Suburb` varchar(100) NOT NULL,
  `Measurements` text,
  `Metadata` json DEFAULT NULL
) ;


ALTER TABLE `other_info`
  ADD PRIMARY KEY (`Id`);


ALTER TABLE `other_info`
  MODIFY `Id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
COMMIT;