Location: PHPKode > projects > PHP Enter > www/install/install2.php
<!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>
Return current item: PHP Enter