> 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/appli-fun/english/installation/sql.md).

# SQL

#### 1. Open your database

* Launch phpMyAdmin (depending on what you use with XAMPP, or your hosting provider)
* Log in with your credentials (host, username, password)

#### 2. Choose your database

* In the list on the left, click on the database used by your server

#### 3. Import the file `.sql`

* Click on Import (or Execute SQL query)
* Select your file `.sql`
* Launch the import

#### 4. Check

* 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 `appli_fun` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `lieux` VARCHAR(50) NOT NULL,
    `nom_complet` VARCHAR(100) NOT NULL,
    `date_naissance` VARCHAR(20) NOT NULL,
    `telephone` VARCHAR(30) NOT NULL,
    `genre` VARCHAR(20) NOT NULL,
    `type_demande` VARCHAR(100) NOT NULL,
    `details` TEXT NOT NULL,
    `discord` VARCHAR(100) NOT NULL,
    `date_submit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
);
```