# README # Nodejs backend for android/ios app ### What is this repository for? ### * Backend for android/ios app ### How do I get set up? ### * Configuration - Mysql 5.7, Nodejs 12.0, Nodemon * Dependencies - Run npm install * Database configuration - Run `db-migrate up` to setup database * Deployment instructions - Run nodemon * Copy all the .sample and .example files and paste in the same directories and rename them by removing suffixes. For Example the filename .env.example file should copied and pasted in the same directory and rename it to .env. ### Contribution guidelines ### * Code review ### Who do I talk to? ### * Abhishek Tripathi "# flexo-india-backend" // first udpate regType enum type in user and tmp_user table ALTER TABLE `user` ADD `panNumber` VARCHAR(255) NULL AFTER `companyName`, ADD `gstNumber` VARCHAR(255) NULL AFTER `panNumber`; ALTER TABLE `visit` CHANGE `howManyPeople` `howManyPeople` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0'; ALTER TABLE `visit` CHANGE `visitTime` `visitTime` TIME NULL DEFAULT NULL; ALTER TABLE `user` ADD `billing_address` TEXT NULL DEFAULT NULL AFTER `gstNumber ALTER TABLE `userinvoicelists` ADD `gstNumber` VARCHAR(264) NULL DEFAULT NULL AFTER `space_actual_name`, ADD `panNumber` VARCHAR(264) NULL DEFAULT NULL AFTER `gstNumber`; ALTER TABLE `hostadmin` ADD `lastName` VARCHAR(264) NULL DEFAULT NULL AFTER `name`; ALTER TABLE `visit` CHANGE `hostId` `hostId` INT NOT NULL DEFAULT '0'; ALTER TABLE `leads` CHANGE `hostId` `hostId` INT(11) NOT NULL DEFAULT '0', CHANGE `message` `message` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `worker_id` `worker_id` INT(11) NOT NULL DEFAULT '0', CHANGE `booking_date_time` `booking_date_time` DATETIME NULL DEFAULT NULL, CHANGE `location_name` `location_name` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `type` `type` INT(11) NULL DEFAULT NULL, CHANGE `location` `location` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `persons` `persons` SMALLINT(6) NULL DEFAULT NULL, CHANGE `company_name` `company_name` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `city_name` `city_name` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `spaceId` `spaceId` INT(11) NULL DEFAULT NULL, CHANGE `spaceType` `spaceType` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `inquiryStatus` `inquiryStatus` TINYINT(1) NOT NULL DEFAULT '1', CHANGE `inquiryDescription` `inquiryDescription` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `userId` `userId` INT(11) NOT NULL DEFAULT '0', CHANGE `userEmail` `userEmail` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `userMobile` `userMobile` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `userName` `userName` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `spaceName` `spaceName` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `landmark` `landmark` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `spaceAddress` `spaceAddress` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `rating` `rating` INT(11) NOT NULL DEFAULT '0', CHANGE `ratingRatio` `ratingRatio` DECIMAL(10,0) NOT NULL DEFAULT '0', CHANGE `favorite` `favorite` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `leadBuyStatus` `leadBuyStatus` TINYINT(1) NOT NULL DEFAULT '1', CHANGE `creditPoint` `creditPoint` INT(11) NOT NULL DEFAULT '0', CHANGE `leadStatus` `leadStatus` ENUM('Open','interested','not interested','Contacted','Converted') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Open', CHANGE `tags` `tags` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `leadsRating` `leadsRating` INT(11) NULL DEFAULT NULL, CHANGE `feedback` `feedback` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `connect` `connect` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `verified` `verified` INT(11) NULL DEFAULT '0'; ALTER TABLE `inquiry` CHANGE `inquirySpaceCapacity` `inquirySpaceCapacity` VARCHAR(264) NOT NULL DEFAULT '0'; ALTER TABLE `userinvoicelists` ADD `billingAddress` TEXT NULL DEFAULT NULL AFTER `panNumber`; ALTER TABLE `ratings` CHANGE `approved` `approved` ENUM('0','1','2') NOT NULL DEFAULT '0'; ALTER TABLE `ratings` ADD `remark` VARCHAR(255) NULL AFTER `Review`; ALTER TABLE `ratings` ADD `action_date` DATETIME NULL AFTER `remark`; ALTER TABLE `inquiry` CHANGE `inquiryCompanyName` `inquiryCompanyName` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `inquiry` CHANGE `leadBuyStatus` `leadBuyStatus` TINYINT(1) NOT NULL DEFAULT '1'; ALTER TABLE `bookings` CHANGE `userMobile` `userMobile` VARCHAR(256) NULL DEFAULT NULL; ALTER TABLE `visit` CHANGE `images` `images` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `favorite` ADD `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `favourite`, ADD `updated_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `created_at`; ALTER TABLE `hostadmin` CHANGE `reset_password_code` `reset_password_code` INT NULL DEFAULT NULL; ALTER TABLE `spacerequest` ADD `status` ENUM('Pending', 'Approved', 'Rejected') NOT NULL DEFAULT 'Pending' AFTER `spaceDeleteRequest`; ALTER TABLE `spacerequest` ADD `spaceData` JSON NULL AFTER `reason`; ALTER TABLE `spacerequest` CHANGE `reason` `reason` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; UPDATE `spaces` SET spaceCreateStatus='1'; ALTER TABLE `bookings` CHANGE `isInstant` `isInstant` ENUM('0','1') NULL DEFAULT '1'; ALTER TABLE `hostadmin` ADD `old_password` VARCHAR(255) NULL DEFAULT NULL AFTER `password`; ALTER TABLE `hostadmin` ADD `country_id` INT NOT NULL DEFAULT '101' AFTER `mobile`, ADD `state_id` INT NOT NULL DEFAULT '0' AFTER `country_id`, ADD `city_id` INT NOT NULL DEFAULT '0' AFTER `state_id`, ADD `pincode` INT NOT NULL DEFAULT '0' AFTER `city_id`; ALTER TABLE `hostadmin` ADD `billingcountry_id` INT NOT NULL DEFAULT '101' AFTER `address`, ADD `billingstate_id` INT NOT NULL DEFAULT '0' AFTER `billingcountry_id`, ADD `billingcity_id` INT NOT NULL DEFAULT '0' AFTER `billingstate_id`, ADD `billing_pincode` INT NOT NULL DEFAULT '0' AFTER `billingcity_id`; ALTER TABLE `spaces` ADD `cancellationType` ENUM('Flexible', 'Moderate', 'Strict') NULL DEFAULT NULL AFTER `servicePrice`; ALTER TABLE `hostadmin` ADD `billing_address2` VARCHAR(256) NULL DEFAULT NULL AFTER `billing_address`; ALTER TABLE `hostadmin` ADD `address2` VARCHAR(256) NULL DEFAULT NULL AFTER `address`; ALTER TABLE `spaces` ADD `working_time` TEXT NULL DEFAULT NULL AFTER `saturday_closing_time`;