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
|
#!/usr/bin/perl
##############################################################################
#
# Embperl - Copyright (c) 1997-2008 Gerald Richter / ecos gmbh www.ecos.de
# Embperl - Copyright (c) 2008-2014 Gerald Richter
#
# You may distribute under the terms of either the GNU General Public
# License or the Artistic License, as specified in the Perl README file.
# For use with Apache httpd and mod_perl, see also Apache copyright.
#
# THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR
# IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED
# WARRANTIES OF MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
#
# $Id: setupdb.pl 1578075 2014-03-16 14:01:14Z richter $
#
##############################################################################
use FindBin ;
use DBIx::Recordset ;
use Getopt::Long ;
GetOptions ("debug|d:i") ;
$DBIx::Recordset::Debug = $opt_debug ;
if ($^O eq 'MSWin32')
{
$user = '' ;
$suuser = '' ;
$supass = '' ;
$ds = 'dbi:ODBC:embperl' ;
}
else
{
$user = 'www' ;
$suuser = 'root' ;
$supass = '' ;
$ds = 'dbi:mysql:embperl' ;
}
$DBIx::Recordset::Debug = $opt_debug ;
my $dbshema = "$FindBin::Bin/db.schema" ;
my $db = DBIx::Database -> new ({'!DataSource' => $ds,
'!Username' => $suuser,
'!Password' => $supass,
'!KeepOpen' => 1,
}) ;
die DBIx::Database->LastError . "; Datenbank mu bereits bestehen" if (DBIx::Database->LastError) ;
$db -> CreateTables ($dbshema, '', $user) ;
|
