# SQL DB

We include the dummy database file at backend folder, \
\
Step to import database :\
1\. create new database with any name, in cpanel its located at menu MySQL database\
2\. create/reuse user database and remember its password \
3\. connect user database with your database from number 1\
4\. Go to menu phpMyAdmin, import **`database_notch.sql`** into created database number 1

* If your first time using Notch you can import file **`"database_notch.sql"`** into your MySQL database
* If you using Notch version before 3.0, please execute query fil&#x65;**`"notch_database patch 3.0.sql"`**

\
5\. still on notch database go to menu **Operations**, change **Collation** to **`utf8mb4_unicode_ci`**  and press GO

For first login you can login with \
\
ADMIN username : **`admin`**, password : **`admin`**\
WRITER username : **`writer`**, password : **`writer`**

To change configuration please see **services/conf.php** file, you must edit this data with your own data.

{% code title="services/conf.php" %}

```php
public $DB_SERVER   = "localhost";
public $DB_USER     = "your_db_user_name";
public $DB_PASSWORD = "your_db_user_password";
public $DB_NAME     = "your_db_name";
```

{% endcode %}

Database Architecture :

<div align="left"><img src="https://3588205094-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LmIkOkCOAw79NxbKX9J%2F-MjgBZQOiQta3zpHV8rL%2F-MjgDl5KRYlw6VwIfmDo%2Fimage.png?alt=media&#x26;token=4b07f311-91bd-4cbf-bc0c-d28eef03c582" alt=""></div>
