> For the complete documentation index, see [llms.txt](https://izaap-studios.gitbook.io/izaap-scripts/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://izaap-studios.gitbook.io/izaap-scripts/profiles/installation-and-configuration.md).

# Installation & Configuration

### Downloading Dependencies

{% stepper %}
{% step %}

### **Oxmysql**

{% embed url="<https://github.com/overextended/oxmysql>" %}
{% endstep %}
{% endstepper %}

***

### **Server cfg**

```shellscript
# iZaap Studios - Garages
ensure oxmysql
ensure izaap_score
```

#### SQL

Import the included SQL file into your database:

<details>

<summary>.SQL</summary>

```sql
CREATE TABLE `izaap_score_profiles` (
	`citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`license` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`firstname` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_uca1400_ai_ci',
	`lastname` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_uca1400_ai_ci',
	`joined_at` INT(11) NOT NULL,
	`play_minutes` INT(11) NOT NULL DEFAULT '0',
	`likes` INT(11) NOT NULL DEFAULT '0',
	`updated_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
	PRIMARY KEY (`citizenid`) USING BTREE
)
COLLATE='utf8mb4_uca1400_ai_ci'
ENGINE=InnoDB
;

CREATE TABLE `izaap_score_likes` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`from_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`to_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `uniq_like_pair` (`from_citizenid`, `to_citizenid`) USING BTREE
)
COLLATE='utf8mb4_uca1400_ai_ci'
ENGINE=InnoDB
AUTO_INCREMENT=63
;

CREATE TABLE `izaap_score_relations` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`requester_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`target_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`status` VARCHAR(20) NOT NULL DEFAULT 'pending' COLLATE 'utf8mb4_uca1400_ai_ci',
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	`updated_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `uniq_pair` (`requester_citizenid`, `target_citizenid`) USING BTREE
)
COLLATE='utf8mb4_uca1400_ai_ci'
ENGINE=InnoDB
AUTO_INCREMENT=16
;

CREATE TABLE `izaap_score_reviews` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`from_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`to_citizenid` VARCHAR(64) NOT NULL COLLATE 'utf8mb4_uca1400_ai_ci',
	`rating` TINYINT(4) NOT NULL DEFAULT '5',
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	`updated_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
	`note` VARCHAR(300) NOT NULL DEFAULT '' COLLATE 'utf8mb4_uca1400_ai_ci',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `uniq_review_pair` (`from_citizenid`, `to_citizenid`) USING BTREE
)
COLLATE='utf8mb4_uca1400_ai_ci'
ENGINE=InnoDB
AUTO_INCREMENT=14
;

```

</details>

***

#### Permissions

Permissions command are configured in the config.lua file itself; you can specify identifiers there.

```lua
    AllowedLicenses = {
        --'license:c70da7d1b951554d2f69aae6632823642b0fa939',
    },
```

Permission for staff to use the /review command on users who provide assistance

```shellscript
add_ace group.admin izaap.profilestaff allow
# Allows admins to access the garage admin panel features

add_ace identifier.license:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx izaap.profilestaff allow
# Allows this player to use admin features
```

***