1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
|
#! /bin/sh
# A little Script to create Mp3Kult database
# Author: Stefano Brustia
# E-Mail: hio@lombardiacom.it
#echo "numero: " $#
if [ $# = 0 -o $# = 2 -o $# -gt 3 ] ; then
cat << EOF
Usage: $0 DATABASE-NAME USER-NAME PASSWORD
or: $0 --default
params:
--default Set the default values (DataBase = Mp3Kult, UserName = mp3kult,
Password = mp3kult)
EOF
exit 0
fi
#clear
echo
echo
echo " *******************************************"
echo " * *"
echo " * Mp3Kult *"
echo " * *"
echo " * Database Creation *"
echo " * *"
echo " *******************************************"
echo
echo
echo "Enter Mysql Root password !"
echo "If you don't have set a password press Return"
if [ "$1" = "--default" ] ; then
mysqladmin create -p Mp3Kult;
else
mysqladmin create -p $1;
fi
echo
echo "Retype Mysql Root password"
if [ "$1" = "--default" ] ; then
mysql -u root -p -e "connect Mp3Kult;
CREATE TABLE Mp3s (Mp3id MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, Title
VARCHAR(100) NOT NULL, Artist VARCHAR(100) NOT NULL, Album VARCHAR(100)
NOT NULL, Genre TINYINT UNSIGNED,Year CHAR(4), Comment VARCHAR(100),
Length INTEGER, Path TEXT NOT NULL, Name TEXT NOT NULL,
Volume VARCHAR(40), Size INTEGER NOT NULL, Mode TINYINT UNSIGNED,
Bitrate SMALLINT NOT NULL, Sample INTEGER NOT NULL, Track VARCHAR(10));
CREATE TABLE Playlists (Entryid MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
Song VARCHAR(210) NOT NULL, Length INTEGER, Volume VARCHAR(40),
Plname VARCHAR(50), File TEXT NOT NULL, Mp3id MEDIUMINT UNSIGNED,
Ord INTEGER NOT NULL);
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON Mp3Kult.* TO
mp3kult@localhost IDENTIFIED BY 'mp3kult';"
else
mysql -u root -p -e "connect $1;
CREATE TABLE Mp3s (Mp3id MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, Title
VARCHAR(100) NOT NULL, Artist VARCHAR(100) NOT NULL, Album VARCHAR(100)
NOT NULL, Genre TINYINT UNSIGNED,Year CHAR(4), Comment VARCHAR(100),
Length INTEGER, Path TEXT NOT NULL, Name TEXT NOT NULL,
Volume VARCHAR(40), Size INTEGER NOT NULL, Mode TINYINT UNSIGNED,
Bitrate SMALLINT NOT NULL, Sample INTEGER NOT NULL, Track VARCHAR(10));
CREATE TABLE Playlists (Entryid MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
Song VARCHAR(210) NOT NULL, Length INTEGER, Volume VARCHAR(40),
Plname VARCHAR(50), File TEXT NOT NULL, Mp3id MEDIUMINT UNSIGNED,
Ord INTEGER NOT NULL);
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $1.* TO
$2@localhost IDENTIFIED BY '$3';"
fi
|