# SQL

To ensure the quest and XP system works as intended you must run or import the SQL file provided in the folder `[SQL]` to your database. Failure to do so will result in errors when performing tasks

***

```sql
CREATE TABLE IF NOT EXISTS `moonshine_rep` (
  `citizenid` varchar(50) NOT NULL,
  `rep` int(11) DEFAULT 0,
  `batches_made` int(11) DEFAULT 0,
  `claimed_quests` text DEFAULT NULL,
  `crops_picked` int(11) DEFAULT 0,
  `sales_made` int(11) DEFAULT 0
  PRIMARY KEY (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
```
