4 # Copyright (C) 2008 Michal Vaner (vorner@ucw.cz)
6 # This program is free software; you can redistribute it and/or modify
7 # it under the terms of the GNU General Public License as published by
8 # he Free Software Foundation; either version 2 of the License, or
9 # (at your option) any later version.
11 # This program is distributed in the hope that it will be useful,
12 # but WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with this program; if not, write to the Free Software
19 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
33 defConf( { "dbcharset" => "UTF8", "dbtype" => "InnoDB" } );
36 "CHARSET" => "CHARSET ".$config{"dbcharset"}
39 sub createTable( $ ) {
40 die "Invalid table definition\n" unless( defined( $tablename ) && @lines );
41 my $nt = $_[ 0 ]->prepare( "CREATE TABLE ".$tablename." (".( join "\n", @lines ).") TYPE = $config{dbtype};" );
44 print "Created table $tablename\n";
48 my $dbh = connectDb();
49 open TABLES, "tables" or die "Could not open table definitions\n";
58 s/<<([^<>]+)>>/$replaces{$1}/g;