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");
+?>