$sql = "CREATE DATABASE IF NOT EXISTS opengoo;\r\n\t\t\t USE opengoo;";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`books`;\r\n\t\t\tCREATE TABLE `excel`.`books` (\r\n\t \t\t`BookId` int(10) unsigned NOT NULL auto_increment,\r\n\t \t\t`BookName` varchar(45) NOT NULL,\r\n\t \t\t`UserId` int(10) unsigned NOT NULL COMMENT 'Book Owner',\r\n\t \t\tPRIMARY KEY (`BookId`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=latin1 COMMENT='System Workbooks';";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`cells`;\r\n\t\t\tCREATE TABLE `excel`.`cells` (\r\n\t \t\t`SheetId` int(10) unsigned NOT NULL,\r\n\t \t\t`DataColumn` int(10) unsigned NOT NULL,\r\n\t \t\t`DataRow` int(10) unsigned NOT NULL,\r\n\t \t\t`CellFormula` varchar(255) default NULL,\r\n\t \t\t`FontStyleId` int(10) unsigned NOT NULL default '0',\r\n\t \t\t`LayoutStyleId` int(11) NOT NULL default '0',\r\n\t \t\tPRIMARY KEY (`SheetId`,`DataColumn`,`DataRow`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Sheet data';";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`fontStyles`;\r\n\t\t\tCREATE TABLE `excel`.`fontStyles` (\r\n\t \t\t`FontStyleId` int(11) NOT NULL auto_increment,\r\n\t \t\t`BookId` int(11) NOT NULL,\r\n\t \t\t`FontId` int(11) NOT NULL,\r\n\t \t\t`FontSize` decimal(8,1) NOT NULL default '10.0',\r\n\t \t\t`FontBold` tinyint(1) NOT NULL default '0',\r\n\t \t\t`FontItalic` tinyint(1) NOT NULL default '0',\r\n\t \t\t`FontUnderline` tinyint(1) NOT NULL default '0',\r\n\t \t\t`FontColor` varchar(6) NOT NULL,\r\n\t \t\tPRIMARY KEY (`FontStyleId`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`fonts`;\r\n\t\t\tCREATE TABLE `excel`.`fonts` (\r\n\t \t\t`FontId` int(11) NOT NULL auto_increment,\r\n\t \t\t`FontName` varchar(63) NOT NULL,\r\n\t \t\tPRIMARY KEY (`FontId`)\r\n\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`sheets`;\r\n\t\t\tCREATE TABLE `excel`.`sheets` (\r\n\t \t\t`SheetId` int(10) unsigned NOT NULL auto_increment,\r\n\t \t\t`BookId` int(10) unsigned NOT NULL,\r\n\t \t\t`SheetName` varchar(45) NOT NULL,\r\n\t \t\t`SheetIndex` int(10) unsigned NOT NULL,\r\n\t \t\tPRIMARY KEY (`SheetId`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1022 DEFAULT CHARSET=latin1 COMMENT='Workbooks Sheets';";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`userbooks`;\r\n\t\t\tCREATE TABLE `excel`.`userbooks` (\r\n\t \t\t`UserBookId` int(10) unsigned NOT NULL auto_increment,\r\n\t \t\t`UserId` int(10) unsigned NOT NULL,\r\n\t \t\t`BookId` int(10) unsigned NOT NULL,\r\n\t \t\tPRIMARY KEY (`UserBookId`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1;";
mysql_query($sql);
$sql = "DROP TABLE IF EXISTS `excel`.`users`;\r\n\t\t\tCREATE TABLE `excel`.`users` (\r\n\t \t\t`UserId` int(10) unsigned NOT NULL auto_increment,\r\n\t \t\t`UserName` varchar(45) NOT NULL,\r\n\t \t\t`UserLastName` varchar(45) NOT NULL,\r\n\t \t\t`UserNickname` varchar(45) NOT NULL,\r\n\t \t\t`UserPassword` varchar(45) NOT NULL,\r\n\t \t\t`LanguageId` int(10) unsigned NOT NULL,\r\n\t \t\tPRIMARY KEY (`UserId`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Sytem Users';";
mysql_query($sql);
$sql = "LOCK TABLES `fonts` WRITE;\r\n\t\t\tINSERT INTO `excel`.`fonts` VALUES (1,'Arial'),\r\n \t\t\t(2,'Times New Roman'),\r\n \t\t\t(3,'Verdana'),\r\n \t\t\t(4,'Courier'),\r\n \t\t\t(5,'Lucida Sans Console'),\r\n \t\t\t(6,'Tahoma');\r\n\t\t\tUNLOCK TABLES;";
mysql_query($sql);
$sql = "LOCK TABLES `fontStyles` WRITE;\r\n\t\t\tINSERT INTO `excel`.`fontStyles` VALUES (1,247,0,'10.0',0,0,0,'#00000'),\r\n \t\t\t(2,247,0,'10.0',0,0,0,'#00000');\r\n\t\t\tUNLOCK TABLES;";
mysql_query($sql);
}
}
?>
<?php
$table = new Tables();
$table->execute();
?>
