> For the complete documentation index, see [llms.txt](https://gocomedyfunstoredocs.gitbook.io/gocomedyfun-store/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gocomedyfunstoredocs.gitbook.io/gocomedyfun-store/scripts-free/dj-fun/english/setup/sql.md).

# SQL

**Open Your Database**

1. **Launch phpMyAdmin**\
   (Depending on what you use with XAMPP or your hosting provider)\
   Log in with your credentials (host, user, password)

***

2. **Choose Your Database**\
   In the list on the left, click on the database used by your server

***

3. **Import the .sql File**
   * Click on **Import** (or **Execute an SQL query**)
   * Select your `.sql` file
   * Start the import process

***

4. **Verify**
   * If you see the new tables or columns in your database → it’s installed ✅
   * If you get a red error → check if the table already exists or if the SQL is compatible with your version

```lua
CREATE TABLE IF NOT EXISTS `DjFun_Tchat_Messages` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `license` VARCHAR(60) NOT NULL,
  `name` VARCHAR(100) NOT NULL,
  `sexe` VARCHAR(10) NOT NULL,
  `message` TEXT DEFAULT NULL,
  `audio` LONGTEXT DEFAULT NULL,
  `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
