need help designing a database table (or tables) to hold a hash ( %config) and ( %group)

Hi All

I have just registered  to this site , i am a  network engineer and
recently got busy coding in perl ( just a beginner )

i am creating a script for deployment of websites and i need to create
=A0hash =A0 =A0%config ( which stores a lot of configurations setting for
each type of website ) =A0... i have been manually =A0eaditing this hash
but now the =A0hash =A0has to now be generated from a a database ( mysql )
... i have =A0never worked =A0with designing a database structure . Can
any one guide =A0me how to go about =A0it =A0.


my hash structure looks some thing like this

my %config =A0=3D ( 'website_auto_1' =3D> {
=A0 =A0 =A0 'group' =3D> 'website_auto_group1',
=A0 =A0 'tempdir' =3D> '/var/www/html/temp/auto' ,
=A0 'svnurl' =3D> 'http://svn.intranet.com/repos/branch/auto',
=A0 'excludes' =3D>
'uploaded_images|includes/config.php|admin/includes/config.php|.svn',
=A0 'tarpath' =3D> '/var/www/html/temp/autotar/',
=A0 'tarname' =3D> 'auto',
=A0 =A0'rmtrootdir' =3D> '/var/www/projects/auto',
=A0 =A0'rmttmpdir' =3D> '/temp/auto',
=A0 =A0'rmteserver' =3D> '192.168.1.26' },

website_auto_2 =3D> { ....
:
:
) ;

%group =3D ( =A0website_auto_1 =A0=3D> { auto_group =3D> [ name =3D> user1 =
, name
=3D> user2 , name =3D> user6 ] },
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0website_auto_2 =A0=3D> { auto_group =3D>=
 [ name =3D> user2 ,
=A0name =3D> user5 ] }, ...
:
:
);

i am not too sure if the %group ( not really implement this ) =A0hash is
correct , but i what i want to do is , my deployment script should
only allow users who are logged in =A0to deploy a particular website (
eg website_auto_1 ) =A0if they belong to the group .


thanks in advanced






--
Regards
Agnello D'souza

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]