<?php
/*
********************************************************
Name: setup.php
Author: Rob Hunter
Date 1/3/11
Description: Contains the functions to setup the DS NoSQL database.
Requires a dbConf.php file with database credentials
********************************************************
*/
function createShapes(){
global $shapesTable, $link, $dbName;
mysql_select_db($dbName, $link) ;
$sql = "CREATE TABLE ".$shapesTable."
(id INT NOT NULL AUTO_INCREMENT,
type varchar(255) NOT NULL,
title varchar(255) NOT NULL,
my1 varchar(32),
my2 varchar(32),
my3 varchar(32),
my4 varchar(32),
my5 varchar(32),
my6 varchar(32),
my7 varchar(32),
my8 varchar(32),
my9 varchar(32),
my10 varchar(32),
my11 varchar(32),
my12 varchar(32),
my13 varchar(32),
my14 varchar(32),
my15 varchar(32),
my16 varchar(32),
my17 varchar(32),
my18 varchar(32),
my19 varchar(32),
my20 varchar(32),
my21 varchar(32),
my22 varchar(32),
my23 varchar(32),
my24 varchar(32),
my25 varchar(32),
my26 varchar(32),
my27 varchar(32),
my28 varchar(32),
my29 varchar(32),
my30 varchar(32),
my31 varchar(32),
my32 varchar(32),
my33 varchar(32),
my34 varchar(32),
my35 varchar(32),
my36 varchar(32),
my37 varchar(32),
my38 varchar(32),
my39 varchar(32),
my40 varchar(32),
my41 varchar(32),
my42 varchar(32),
my43 varchar(32),
my44 varchar(32),
my45 varchar(32),
my46 varchar(32),
my47 varchar(32),
my48 varchar(32),
my49 varchar(32),
my50 varchar(32),
my51 varchar(32),
my52 varchar(32),
my53 varchar(32),
my54 varchar(32),
my55 varchar(32),
my56 varchar(32),
my57 varchar(32),
my58 varchar(32),
my59 varchar(32),
my60 varchar(32),
my61 varchar(32),
my62 varchar(32),
my63 varchar(32),
my64 varchar(32),
my65 varchar(32),
my66 varchar(32),
my67 varchar(32),
my68 varchar(32),
my69 varchar(32),
my70 varchar(32),
my71 varchar(32),
my72 varchar(32),
my73 varchar(32),
my74 varchar(32),
my75 varchar(32),
my76 varchar(32),
my77 varchar(32),
my78 varchar(32),
my79 varchar(32),
my80 varchar(32),
my81 varchar(32),
my82 varchar(32),
my83 varchar(32),
my84 varchar(32),
my85 varchar(32),
my86 varchar(32),
my87 varchar(32),
my88 varchar(32),
my89 varchar(32),
my90 varchar(32),
my91 varchar(32),
my92 varchar(32),
my93 varchar(32),
my94 varchar(32),
my95 varchar(32),
my96 varchar(32),
my97 varchar(32),
my98 varchar(32),
my99 varchar(32),
my100 varchar(32),
my101 varchar(32),
my102 varchar(32),
my103 varchar(32),
my104 varchar(32),
my105 varchar(32),
my106 varchar(32),
my107 varchar(32),
my108 varchar(32),
my109 varchar(32),
my110 varchar(32),
my111 varchar(32),
my112 varchar(32),
my113 varchar(32),
my114 varchar(32),
my115 varchar(32),
my116 varchar(32),
my117 varchar(32),
my118 varchar(32),
my119 varchar(32),
my120 varchar(32),
my121 varchar(32),
my122 varchar(32),
my123 varchar(32),
my124 varchar(32),
my125 varchar(32),
my126 varchar(32),
my127 varchar(32),
my128 varchar(32),
my129 varchar(32),
my130 varchar(32),
my131 varchar(32),
my132 varchar(32),
my133 varchar(32),
my134 varchar(32),
my135 varchar(32),
my136 varchar(32),
my137 varchar(32),
my138 varchar(32),
my139 varchar(32),
my140 varchar(32),
my141 varchar(32),
my142 varchar(32),
my143 varchar(32),
my144 varchar(32),
my145 varchar(32),
my146 varchar(32),
my147 varchar(32),
my148 varchar(32),
my149 varchar(32),
my150 varchar(32),
PRIMARY KEY (id)
)
";
//print $sql;
echo "Adding shapes<br><br>";
$shapesQuery = mysql_query($sql)
or die('CREATE SHAPES TABLE FAILED: '.mysql_error());
}
function createContentStore(){
global $contentTable, $numRange, $strRange, $txtRange, $link;
$range = array( 'float(32)' => $numRange,
'varchar(255)' => $strRange,
'text' => $txtRange,
);
mysql_select_db($dbName, $link) ;
$sql = "CREATE TABLE ".$contentTable."
(id INT NOT NULL AUTO_INCREMENT,
createdDate integer(16) NOT NULL,
updatedDate integer(16),
type varchar(255) NOT NULL,
title varchar(255) NOT NULL,
description varchar(255),
contributorName varchar(30),
page integer(4),";
foreach ($range as $dataType => $rangeArray){
for ($i = $rangeArray['start']; $i<=$rangeArray['end']; $i++){
$sql .= "my".$i." ".$dataType.",
";
}
}
$sql .= "PRIMARY KEY (id) )";
//print $sql;
echo "Adding content_store";
$shapesQuery = mysql_query($sql)
or die('CREATE SHAPES TABLE FAILED: '.mysql_error());
}
function doesTableExist($table){
global $link, $dbName;
mysql_select_db($dbName, $link) ;
$sql = 'SELECT table_name FROM information_schema.tables
WHERE table_name = "'.$table.'"';
//echo $sql."<br>";
$checkQuery = mysql_query($sql)
or die('DOES TABLE EXIST '.$table.' FAILED: '.mysql_error());
if(mysql_num_rows($checkQuery) > 0){
return TRUE;
}
else{
return FALSE;
}
}
function dropTable($table){
global $link, $dbName;
mysql_select_db($dbName, $link) ;
$sql = "DROP TABLE ".$table;
$dropQuery = mysql_query($sql)
or die('DROP TABLE '.$table.' FAILED: '.mysql_error());
}
/*
Copyright 2011 Oversee.net. All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are
permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice, this list of
conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, this list
of conditions and the following disclaimer in the documentation and/or other materials
provided with the distribution.
THIS SOFTWARE IS PROVIDED BY OVERSEE.NET ``AS IS'' AND ANY EXPRESS OR IMPLIED
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL OVERSEE.NET OR
CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The views and conclusions contained in the software and documentation are those of the
authors and should not be interpreted as representing official policies, either expressed
or implied, of Oversee.net.
*/
?>
