Updating

FILES TO KEEP!

Make sure to keep these files or stuff will disappear

• web > assets > properties

• web > assets > furniture (If you have added your own)

Updating SN_LIB

KEEP THE IMAGES FOLDER!!

CONVERTING FROM V1 RUN THE FOLLOWING SQL:

IF YOU HAVE "mortgage_plan" in the properties sql:

ALTER TABLE `properties` DROP COLUMN `mortgage_plan`;

IF YOU DONT HAVE "outside_zone" in the properties sql:

ALTER TABLE `properties`
ADD COLUMN `purchase_type` VARCHAR(20) NOT NULL DEFAULT 'purchase' AFTER `price`,
ADD COLUMN `purchase_plan` JSON DEFAULT NULL AFTER `purchase_type`,
ADD COLUMN `outside_zone` JSON DEFAULT NULL AFTER `garage_zone`;

IF YOU DO HAVE "outside_zone" run:

ALTER TABLE `properties`
ADD COLUMN `purchase_type` VARCHAR(20) NOT NULL DEFAULT 'purchase' AFTER `price`,
ADD COLUMN `purchase_plan` JSON DEFAULT NULL AFTER `purchase_type`;