Commit | Line | Data |
---|---|---|
9d5e1087 FB |
1 | #!/bin/bash |
2 | ||
3 | . ../inc/pervasive.sh | |
4 | ||
5 | ########################################################### | |
d0293d9b FB |
6 | [ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat" |
7 | ||
8 | echo "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\"" | |
9 | echo "* press ^D to start import (^C to cancel)" | |
9d5e1087 FB |
10 | cat |
11 | ||
d0293d9b | 12 | echo -n "* create database " |
aa1f260a | 13 | (echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | mysql_run) || die "ERROR" |
d0293d9b FB |
14 | echo "OK" |
15 | ||
9d5e1087 | 16 | echo -n "* copying tables " |
8600216c | 17 | (./copy_tables.sh | mysql_run) || die "ERROR" |
9d5e1087 FB |
18 | echo "OK" |
19 | ||
aa1f260a | 20 | for sql in ../newdirectory-0.0.1/*.sql *.sql |
9d5e1087 FB |
21 | do |
22 | echo -n "* running $sql " | |
aa1f260a | 23 | (cat $sql | mysql_run) || die "ERROR" |
9d5e1087 FB |
24 | echo "OK" |
25 | done | |
26 | ||
27 | ########################################################### | |
28 | echo -n "Importing phone numbers " | |
29 | ||
d0293d9b | 30 | ../newdirectory-0.0.1/phones.php || die "ERROR" |
9d5e1087 FB |
31 | echo "OK" |
32 | ||
33 | ########################################################### | |
34 | echo "Updating birthday dates " | |
35 | ||
36 | ./birthday.php || die "ERROR" | |
37 | echo "OK" |