<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="php enter" />
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<style type="text/css">
body {
font-family: "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
font-size: 14px;
font-weight: normal;
margin: 0px;
padding: 0px;
background-color: #f8f8f8;
color: #4F4F4F;
}
h1 {
font-family: Times New Roman, serif;
font-size: 26px;
font-weight: normal;
color: #4F4F4F;
}
h2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color: #333333;
}
p {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: normal;
line-height: 18px;
color: #333333;
}
a {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 14px;
font-weight: normal;
text-decoration: none;
color: #4F4F4F;
}
a:visited {
text-decoration: none;
color: #4F4F4F;
}
</style>
</head>
<body>
<br />
<table width="70%" text align="center" border="0">
<tr><td>
<center><h3>:: php Enter ::</h3>
<br />
<br />
<?php
require_once('../admin/config.php');
mysql_query("CREATE TABLE `categori` (
`catid` int(11) unsigned NOT NULL auto_increment,
`parent` int(11) unsigned default '1',
`cord` int(1) unsigned default '0',
`name` text collate utf8_unicode_ci,
`ccount` int(11) default '0',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `cpadmin` (
`ausid` int(11) NOT NULL auto_increment,
`ausername` varchar(255) collate utf8_unicode_ci default NULL,
`apassword` varchar(255) collate utf8_unicode_ci default NULL,
`aemail` varchar(55) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`ausid`),
UNIQUE KEY `Username` (`ausername`),
UNIQUE KEY `Email` (`aemail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `newser` (
`blogid` int(11) NOT NULL auto_increment,
`univer` varchar(255) collate utf8_unicode_ci NOT NULL,
`idblog` int(11) NOT NULL,
`buserid` text collate utf8_unicode_ci,
`buser` text collate utf8_unicode_ci NOT NULL,
`btexty` varchar(255) collate utf8_unicode_ci default NULL,
`badress` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
`images` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
`bimgs` text collate utf8_unicode_ci,
`bdate` datetime NOT NULL,
`bamess` text collate utf8_unicode_ci NOT NULL,
`commno` int(11) default '0',
`rating` int(10) unsigned NOT NULL,
`total_rating` int(10) unsigned NOT NULL,
`total_ratings` int(10) unsigned NOT NULL,
PRIMARY KEY (`blogid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `publictime` (
`commid` int(11) NOT NULL auto_increment,
`userid` text collate utf8_unicode_ci,
`texty` varchar(255) collate utf8_unicode_ci default NULL,
`imgs` text collate utf8_unicode_ci,
`date` datetime NOT NULL,
`amess` text collate utf8_unicode_ci NOT NULL,
`nocomm` varchar(11) collate utf8_unicode_ci default '0',
PRIMARY KEY (`commid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `reviews` (
`revid` int(5) NOT NULL auto_increment,
`comrev` varchar(15) collate utf8_unicode_ci NOT NULL,
`cmain` tinyint(1) NOT NULL,
`comenter` text collate utf8_unicode_ci NOT NULL,
`comimage` text collate utf8_unicode_ci NOT NULL,
`chomes` text collate utf8_unicode_ci,
`cdate` datetime NOT NULL,
`ctexte` text collate utf8_unicode_ci,
PRIMARY KEY (`revid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `users` (
`usid` int(11) NOT NULL auto_increment,
`privilege` tinyint(1) default '2',
`fullname` varchar(255) collate utf8_unicode_ci default NULL,
`username` varchar(255) collate utf8_unicode_ci default NULL,
`password` varchar(255) collate utf8_unicode_ci default NULL,
`tempass` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
`email` varchar(55) collate utf8_unicode_ci default NULL,
`homep` text collate utf8_unicode_ci NOT NULL,
`biosi` text collate utf8_unicode_ci NOT NULL,
`ipos` varchar(11) collate utf8_unicode_ci NOT NULL,
`thumbs` text collate utf8_unicode_ci NOT NULL,
`date` datetime default NULL,
`active` tinyint(1) default '0',
`keysi` varchar(32) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`usid`),
UNIQUE KEY `Username` (`username`),
UNIQUE KEY `Email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `vgalery` (
`galid` int(11) NOT NULL auto_increment,
`guniver` varchar(255) collate utf8_unicode_ci default NULL,
`gtitle` varchar(255) collate utf8_unicode_ci default NULL,
`gdate` datetime NOT NULL,
`gamess` text collate utf8_unicode_ci NOT NULL,
`gnocom` varchar(11) collate utf8_unicode_ci default '0',
PRIMARY KEY (`galid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
echo "<center><h3><font color=\"#56B068\">MySQL O.K.</font></h3>";
?>
<a href = "install3.php"><font color="#56B068"><h3>Step 3 >>>>></h3></font></a>
</td></tr>
</table>
<table width="100%" height="422px" text align="center" border="0">
<tr>
<td align="center" valign="bottom">
<center>
<a href="http://phpenter.net"><font size=1 font color="#4F4F4F">powered by phpenter.net</font></a>
</td>
</tr>
</table>
</center>
</HTML>