Mercurial > epgrec.yaz
diff initdb.php @ 1:f5a9f0eb4858
deleted: LICENSE.ja
author | Sushi-k <epgrec@park.mda.or.jp> |
---|---|
date | Wed, 08 Jul 2009 11:44:50 +0900 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/initdb.php Wed Jul 08 11:44:50 2009 +0900 @@ -0,0 +1,39 @@ +#!/usr/bin/php +<?php + + require_once( "config.php" ); + require_once( INSTALL_PATH. "/DBRecord.class.php" ); + +/* + $dbh = @mysql_connect( DB_HOST, DB_USER, DB_PASS ); + if( $dbh === false ) { + exit("Can't connect DB\n" ); + } + + $sqlstr = "CREATE DATABASE IF NOT EXISTS ".DB_NAME; + $result = mysql_query( $sqlstr ); + if( $result === false ) { + exit( "Quary error\n" ); + } +*/ + try { + $rec = new DBRecord( TBL_PREFIX . RESERVE_TBL ); + $rec->createTable( RESERVE_STRUCT ); + + $rec = new DBRecord( TBL_PREFIX . PROGRAM_TBL ); + $rec->createTable( PROGRAM_STRUCT ); + + $rec = new DBRecord( TBL_PREFIX . CHANNEL_TBL ); + $rec->createTable( CHANNEL_STRUCT ); + + $rec = new DBRecord( TBL_PREFIX . CATEGORY_TBL ); + $rec->createTable( CATEGORY_STRUCT ); + + $rec = new DBRecord( TBL_PREFIX . KEYWORD_TBL ); + $rec->createTable( KEYWORD_STRUCT ); + } + catch( Exception $e ) { + exit( $e->getMessage() ); + } + exit( "Complete!\n"); +?>