> For the complete documentation index, see [llms.txt](https://moon-store.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://moon-store.gitbook.io/docs/job-interviews-and-better-hiring/installation-guide.md).

# Installation Guide

## Step 1: SQL Modifications

You must execute the SQL code to set up the necessary database tables.

#### **Instructions**

1. Open your database management tool (e.g., phpMyAdmin or HeidiSQL).
2. Select Your Database.
3. Run the following SQL query in your database to create the required table:

```sql
CREATE TABLE `moon_interview` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`job` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`clearanceGrades` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`available24hours` TINYINT(1) NOT NULL,
	`questions` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`pauseapplications` TINYINT(1) NOT NULL,
	`applicationtimings` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`webhook` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`updated_at` TIMESTAMP NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	CONSTRAINT `questions` CHECK (json_valid(`questions`)),
	CONSTRAINT `applicationtimings` CHECK (json_valid(`applicationtimings`))
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=6
;

CREATE TABLE `interview_responses` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`citizenid` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_general_ci',
	`department` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_general_ci',
	`answers` LONGTEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`additional_info` LONGTEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
	`submitted_at` DATETIME NULL DEFAULT current_timestamp(),
	`status` LONGTEXT NULL DEFAULT '[{"type": 0, "reason": "We are looking into your application"}]' COLLATE 'utf8mb4_general_ci',
	`comments` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `citizenid_department` (`citizenid`, `department`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=46
;

```

***

## **Step 2:** Configure the `Config.lua` File

Customize the `Config.lua` file based on your preferences and requirements. Ensure the settings align with your server's intended functionality and features.