# Updating

## <mark style="color:red;">FILES TO KEEP!</mark>

Make sure to keep these files or stuff will disappear&#x20;

* **web > assets > properties**
* w**eb > 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:

<pre><code>ALTER TABLE `properties`
<strong>ADD COLUMN `purchase_type` VARCHAR(20) NOT NULL DEFAULT 'purchase' AFTER `price`,
</strong>ADD COLUMN `purchase_plan` JSON DEFAULT NULL AFTER `purchase_type`;
</code></pre>
