File: mp3kultdb

package info (click to toggle)
mp3kult 0.6.1-5
  • links: PTS
  • area: main
  • in suites: woody
  • size: 2,356 kB
  • ctags: 932
  • sloc: sh: 10,162; cpp: 7,927; perl: 1,967; python: 258; makefile: 95
file content (90 lines) | stat: -rwxr-xr-x 2,490 bytes parent folder | download | duplicates (2)
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