2️⃣SQL - Database Installation

Database Setup

Load the SQL codes specified below into your server's database system.

CREATE TABLE `scode_house_data` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`keydata` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`date` TIMESTAMP NULL DEFAULT current_timestamp(),
	`status` INT(11) NULL DEFAULT '0',
	`door_status` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`paymentinfo` INT(11) NOT NULL DEFAULT '0',
	`blip_name` VARCHAR(50) NULL DEFAULT 'My House' COLLATE 'utf8mb4_general_ci',
	`end_date` TIMESTAMP NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=13
;