#!/bin/bash
cd /ext/exp
tar zxvf /ext/cmp/01/mysql-*.*.*.tar.gz
DIR=$(ls -d mysql-*.*.*)
cd $DIR
./configure --prefix=/ext/env/01/$DIR --with-charset=utf8
make
make install

cd /ext/ini
cat << EOF > mysql.sh
export MYSQL_HOME=/ext/env/01/mysql
if ! echo \$PATH | grep -q mysql/bin; then
	PATH=\$MYSQL_HOME/bin:\$PATH
fi
EOF
. /etc/profile

if ! grep -q mysql /etc/passwd; then
	useradd mysql
fi
echo mysql:mysql | chpasswd

cd /ext/env/01
ln -sf $DIR mysql
chown -R mysql:mysql $DIR
chown -h mysql:mysql mysql

mysql_install_db --user=mysql
mysqld_safe --user mysql &
sleep 5
mysqladmin -u root password 'root'
echo "GRANT ALL ON dtbs01.* TO usnm01@localhost IDENTIFIED BY 'pswd01'" | mysql -u root -proot
echo CREATE DATABASE dtbs01 | mysql -u usnm01 -ppswd01

mysql -u usnm01 -ppswd01 dtbs01 << EOF
create table memberlist (
	id integer primary key,
	name text,
	gender integer check(gender in (1, 2)),
	tel text,
	email text
);
insert into memberlist values(1, '田中', 1, '0120-11-0001', 'tanaka@mail.aaa.com');
insert into memberlist values(2, '鈴木', 2, '0120-11-0002', 'suzuki@mail.bbb.com');
insert into memberlist values(3, '佐藤', 1, '0120-11-0003', 'satoh@mail.ccc.com');
insert into memberlist values(4, '齋藤', 2, '0120-11-0004', 'saito@mail.ddd.com');
insert into memberlist values(5, '吉田', 1, '0120-11-0005', 'yoshida@mail.eee.com');
insert into memberlist values(6, '岡田', 2, '0120-11-0006', 'okada@mail.fff.com');
insert into memberlist values(7, '川上', 2, '0120-11-0007', 'kawakami@mail.ggg.com');
insert into memberlist values(8, '河野', 1, '0120-11-0008', 'kawano@mail.hhh.com');
insert into memberlist values(9, '村山', 1, '0120-11-0009', 'murayama@mail.iii.com');
EOF
mysqladmin shutdown -proot