1
|
#!/bin/bash
|
2
|
|
3
|
DB_USR=sem-si-dejte-vaseho-db-uzivatele
|
4
|
DB_PW=sem-si-dejte-vase-heslo-do-db
|
5
|
DB_NAME=sem-si-dejte-jmeno-vasi-databaze
|
6
|
|
7
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < drop-all-tables.sql
|
8
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v01__base_schema.sql
|
9
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v02__data_10_04_2018.sql
|
10
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v03__vozidlo_rename.sql
|
11
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v04__geosouradnice.sql
|
12
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v05__geosouradnice_update.sql
|
13
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v06__zaznam_prum_den.sql
|
14
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v07__data_20_05_2018.sql
|
15
|
mysql -u $DB_USR --password=$DB_PW $DB_NAME < v08__geosouradnice_cesky.sql
|