Location: PHPKode > projects > ProNuke. Postnuke To Oracle > postnuke/html/install/newtables.php
<?php
    mysql_connect($dbhost, $dbuname, $dbpass);
    mysql_select_db("$dbname") or die ("<br><font class=\"post-failed\">Unable to select database -- You must either create your database manually or if you have root access let the install script do it for you.</font></font>");

    $result = mysql_query("CREATE TABLE ".$prefix."_autonews (
	anid int(11) NOT NULL auto_increment,
	catid int(11) DEFAULT '0' NOT NULL,
	aid varchar(30) NOT NULL,
	title varchar(80) NOT NULL,
	time varchar(19) NOT NULL,
	hometext text NOT NULL,
	bodytext text NOT NULL,
	topic int(3) DEFAULT '1' NOT NULL,
	informant varchar(20) NOT NULL,
	notes text NOT NULL,
	ihome int(1) DEFAULT '0' NOT NULL,
	alanguage varchar(30) NOT NULL,
	withcomm int(1) DEFAULT '0' NOT NULL,
	PRIMARY KEY (anid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_autonews</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_autonews Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_autolinks (
	lid int(11) NOT NULL auto_increment,
	keyword varchar(100) NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(200) NOT NULL,
	comment varchar(200),
	PRIMARY KEY (lid),
	UNIQUE keyword (keyword)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_autonews</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_autolinks Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_banner (
	bid int(11) NOT NULL auto_increment,
	cid int(11) DEFAULT '0' NOT NULL,
	imptotal int(11) DEFAULT '0' NOT NULL,
	impmade int(11) DEFAULT '0' NOT NULL,
	clicks int(11) DEFAULT '0' NOT NULL,
	imageurl varchar(255) NOT NULL,
	clickurl varchar(255) NOT NULL,
	date datetime, PRIMARY KEY (bid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_banner</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_banner Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_bannerclient (
	cid int(11) NOT NULL auto_increment,
	name varchar(60) NOT NULL,
	contact varchar(60) NOT NULL,
	email varchar(60) NOT NULL,
	login varchar(10) NOT NULL,
	passwd varchar(10) NOT NULL,
	extrainfo text NOT NULL,
	PRIMARY KEY (cid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_bannerclient</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_bannerclient Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_bannerfinish (
	bid int(11) NOT NULL auto_increment,
	cid int(11) DEFAULT '0' NOT NULL,
	impressions int(11) DEFAULT '0' NOT NULL,
	clicks int(11) DEFAULT '0' NOT NULL,
	datestart datetime,
	dateend datetime,
	PRIMARY KEY (bid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_bannerfinish</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_bannerfinish Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_blocks (
	bid int(10) unsigned NOT NULL auto_increment,
	bkey varchar(255) NOT NULL,
	title varchar(255) NOT NULL,
	content text NOT NULL,
	url varchar(255) NOT NULL,
	position char(1) DEFAULT 'l' NOT NULL,
	weight decimal(10,1) DEFAULT '0.0' NOT NULL,
	active tinyint(3) unsigned DEFAULT '1' NOT NULL,
	refresh int(10) unsigned DEFAULT '0' NOT NULL,
	last_update timestamp(14),
	blanguage varchar(30) NOT NULL,
	PRIMARY KEY (bid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_blocks</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_blocks Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_blocks_buttons (
	id int(10) unsigned NOT NULL auto_increment,
	bid int(10) unsigned DEFAULT '0' NOT NULL,
	title varchar(255) NOT NULL,
	url varchar(255) NOT NULL,
	images longtext NOT NULL,
	PRIMARY KEY (id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_blocks_buttons</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_blocks_buttons Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_comments (
	tid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0',
	sid int(11) DEFAULT '0',
	date datetime,
	name varchar(60) NOT NULL,
	email varchar(60),
	url varchar(60),
	host_name varchar(60),
	subject varchar(85) NOT NULL,
	comment text NOT NULL,
	score tinyint(4) DEFAULT '0' NOT NULL,
	reason tinyint(4) DEFAULT '0' NOT NULL,
	PRIMARY KEY (tid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_comments</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_comments Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_counter (
	type varchar(80) NOT NULL,
	var varchar(80) NOT NULL,
	count int(10) unsigned DEFAULT '0' NOT NULL
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_counter</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_counter Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_categories (
	cid int(11) NOT NULL auto_increment,
	title varchar(50) NOT NULL,
	cdescription text NOT NULL,
	PRIMARY KEY (cid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_categories</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_categories Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_downloads (
	lid int(11) NOT NULL auto_increment,
	cid int(11) DEFAULT '0' NOT NULL,
	sid int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	date datetime,
	name varchar(100) NOT NULL,
	email varchar(100) NOT NULL,
	hits int(11) DEFAULT '0' NOT NULL,
	submitter varchar(60) NOT NULL,
	downloadratingsummary double(6,4) DEFAULT '0.0000' NOT NULL,
	totalvotes int(11) DEFAULT '0' NOT NULL,
	totalcomments int(11) DEFAULT '0' NOT NULL,
	filesize int(11) DEFAULT '0' NOT NULL,
	version varchar(10) NOT NULL,
	homepage varchar(200) NOT NULL,
	PRIMARY KEY (lid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_downloads</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_downloads Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_editorials (
	downloadid int(11) DEFAULT '0' NOT NULL,
	adminid varchar(60) NOT NULL,
	editorialtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	editorialtext text NOT NULL,
	editorialtitle varchar(100) NOT NULL,
	PRIMARY KEY (downloadid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_editorials</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_editorials Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_modrequest (
	requestid int(11) NOT NULL auto_increment,
	lid int(11) DEFAULT '0' NOT NULL,
	cid int(11) DEFAULT '0' NOT NULL,
	sid int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	modifysubmitter varchar(60) NOT NULL,
	brokendownload int(3) DEFAULT '0' NOT NULL,
	name varchar(100) NOT NULL,
	email varchar(100) NOT NULL,
	filesize int(11) DEFAULT '0' NOT NULL,
	version varchar(10) NOT NULL,
	homepage varchar(200) NOT NULL,
	PRIMARY KEY (requestid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_modrequest</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_modrequest Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_newdownload (
	lid int(11) NOT NULL auto_increment,
	cid int(11) DEFAULT '0' NOT NULL,
	sid int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	name varchar(100) NOT NULL,
	email varchar(100) NOT NULL,
	submitter varchar(60) NOT NULL,
	filesize int(11) DEFAULT '0' NOT NULL,
	version varchar(10) NOT NULL,
	homepage varchar(200) NOT NULL,
	PRIMARY KEY (lid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_newdownload</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_newdownload Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_subcategories (
	sid int(11) NOT NULL auto_increment,
	cid int(11) DEFAULT '0' NOT NULL,
	title varchar(50) NOT NULL,
	PRIMARY KEY (sid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_subcategories</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_subcategories Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_downloads_votedata (
	ratingdbid int(11) NOT NULL auto_increment,
	ratinglid int(11) DEFAULT '0' NOT NULL,
	ratinguser varchar(60) NOT NULL,
	rating int(11) DEFAULT '0' NOT NULL,
	ratinghostname varchar(60) NOT NULL,
	ratingcomments text NOT NULL,
	ratingtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	PRIMARY KEY (ratingdbid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_downloads_votedata</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_downloads_votedata Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_ephem (
	eid int(11) NOT NULL auto_increment,
	did int(2) DEFAULT '0' NOT NULL,
	mid int(2) DEFAULT '0' NOT NULL,
	yid int(4) DEFAULT '0' NOT NULL,
	content text NOT NULL,
	elanguage varchar(30) NOT NULL,
	PRIMARY KEY (eid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_ephem</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_ephem Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_faqanswer (
	id tinyint(4) NOT NULL auto_increment,
	id_cat tinyint(4),
	question varchar(255),
	answer text,
	submittedby varchar(250) NOT NULL,
	PRIMARY KEY (id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_faqanswer</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_faqanswer Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_faqcategories (
	id_cat tinyint(3) NOT NULL auto_increment,
	categories varchar(255),
	flanguage varchar(30) NOT NULL,
	parent_id tinyint(3) DEFAULT '0' NOT NULL,
	PRIMARY KEY (id_cat)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_faqcategories</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_faqcategories Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_group_membership (
        gid int(6) NOT NULL,
        uid int(11) NOT NULL
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_group_membership</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_group_membership Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_group_perms (
        pid int(11) NOT NULL auto_increment,
	gid int(6) NOT NULL,
	sequence int(6) NOT NULL,
	realm int(4) NOT NULL,
	component varchar(255) NOT NULL,
	instance varchar(255) NOT NULL,
	level int(4) NOT NULL,
	bond int(2) NOT NULL,
	PRIMARY KEY (pid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_group_perms</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_group_perms Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_groups (
        gid int(6) NOT NULL auto_increment,
        name varchar(255) NOT NULL,
	PRIMARY KEY (gid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_groups</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_groups Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_headlines (
	id int(10) unsigned NOT NULL auto_increment,
	sitename varchar(255) NOT NULL default '',
	rssuser varchar(10) default NULL,
	rsspasswd varchar(10) default NULL,
	use_proxy tinyint(3) NOT NULL default '0',
	rssurl varchar(255) NOT NULL default '',
	maxrows tinyint(3) NOT NULL default '10',
	siteurl varchar(255) NOT NULL default '',
	options varchar(20) default '',
	PRIMARY KEY  (id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_headlines</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_headlines Made.</font>";

        $result = mysql_query("CREATE TABLE ".$prefix."_links_categories (
	cat_id int(11) NOT NULL auto_increment,
	parent_id int(11),
	title varchar(50) NOT NULL,
	cdescription text NOT NULL,
	PRIMARY KEY (cat_id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_categories</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_categories Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_links_editorials (
	linkid int(11) DEFAULT '0' NOT NULL,
	adminid varchar(60) NOT NULL,
	editorialtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	editorialtext text NOT NULL,
	editorialtitle varchar(100) NOT NULL,
	PRIMARY KEY (linkid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_editorials</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_editorials Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_links_links (
	lid int(11) NOT NULL auto_increment,
	cat_id int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	date datetime,
	name varchar(100) NOT NULL,
	email varchar(100) NOT NULL,
	hits int(11) DEFAULT '0' NOT NULL,
	submitter varchar(60) NOT NULL,
	linkratingsummary double(6,4) DEFAULT '0.0000' NOT NULL,
	totalvotes int(11) DEFAULT '0' NOT NULL,
	totalcomments int(11) DEFAULT '0' NOT NULL,
	PRIMARY KEY (lid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_links</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_links Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_links_modrequest (
	requestid int(11) NOT NULL auto_increment,
	lid int(11) DEFAULT '0' NOT NULL,
	cat_id int(11) DEFAULT '0' NOT NULL,
	sid int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	modifysubmitter varchar(60) NOT NULL,
	brokenlink int(3) DEFAULT '0' NOT NULL,
	PRIMARY KEY (requestid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_modrequest</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_modrequest Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_links_newlink (
	lid int(11) NOT NULL auto_increment,
	cat_id int(11) DEFAULT '0' NOT NULL,
	title varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	description text NOT NULL,
	name varchar(100) NOT NULL,
	email varchar(100) NOT NULL,
	submitter varchar(60) NOT NULL,
	PRIMARY KEY (lid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_newlink</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_newlink Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_links_votedata (
	ratingdbid int(11) NOT NULL auto_increment,
	ratinglid int(11) DEFAULT '0' NOT NULL,
	ratinguser varchar(60) NOT NULL,
	rating int(11) DEFAULT '0' NOT NULL,
	ratinghostname varchar(60) NOT NULL,
	ratingcomments text NOT NULL,
	ratingtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	PRIMARY KEY (ratingdbid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_links_votedata</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_links_votedata Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_message (
	mid int(11) NOT NULL auto_increment,
	title varchar(100) NOT NULL,
	content text NOT NULL,
	date varchar(14) NOT NULL,
	expire int(7) DEFAULT '0' NOT NULL,
	active int(1) DEFAULT '1' NOT NULL,
	view int(1) DEFAULT '1' NOT NULL,
	mlanguage varchar(30) NOT NULL,
	PRIMARY KEY (mid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_message</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_message Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_poll_check (
	ip varchar(20) NOT NULL,
	time varchar(14) NOT NULL
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_poll_check</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_poll_check Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_poll_data (
	pollID int(11) DEFAULT '0' NOT NULL,
	optionText char(50) NOT NULL,
	optionCount int(11) DEFAULT '0' NOT NULL,
	voteID int(11) DEFAULT '0' NOT NULL
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_poll_data</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_poll_data Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_poll_desc (
	pollID int(11) NOT NULL auto_increment,
	pollTitle varchar(100) NOT NULL,
	timeStamp int(11) DEFAULT '0' NOT NULL,
	voters mediumint(9) DEFAULT '0' NOT NULL,
	planguage varchar(30) NOT NULL,
	PRIMARY KEY (pollID)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_poll_desc</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_poll_desc Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_pollcomments (
	tid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0',
	pollID int(11) DEFAULT '0',
	date datetime,
	name varchar(60) NOT NULL,
	email varchar(60),
	url varchar(60),
	host_name varchar(60),
	subject varchar(60) NOT NULL,
	comment text NOT NULL,
	score tinyint(4) DEFAULT '0' NOT NULL,
	reason tinyint(4) DEFAULT '0' NOT NULL,
	PRIMARY KEY (tid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_pollcomments</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_pollcomments Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_priv_msgs (
	msg_id int(10) NOT NULL auto_increment,
	msg_image varchar(100),
	subject varchar(100),
	from_userid int(10) DEFAULT '0' NOT NULL,
	to_userid int(10) DEFAULT '0' NOT NULL,
	msg_time varchar(20),
	msg_text text,
	read_msg tinyint(10) DEFAULT '0' NOT NULL,
	PRIMARY KEY (msg_id),
	KEY to_userid (to_userid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_priv_msgs</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_priv_msgs Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_queue (
	qid smallint(5) unsigned NOT NULL auto_increment,
	uid mediumint(9) DEFAULT '0' NOT NULL,
	arcd int(1) DEFAULT '0' NOT NULL,
	uname varchar(40) NOT NULL,
	subject varchar(100) NOT NULL,
	story text,
	timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	topic varchar(20) NOT NULL,
	alanguage varchar(30) NOT NULL,
	bodytext text,
	PRIMARY KEY (qid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_queue</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_queue Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_quotes (
	qid int(10) unsigned NOT NULL auto_increment,
	quote text,
	author varchar(150) NOT NULL,
	PRIMARY KEY (qid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_quotes</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_quotes Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_realms (
        rid int(4) NOT NULL auto_increment,
        name varchar(255) NOT NULL,
	PRIMARY KEY (rid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_realms</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_realms Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_referer (
	rid int(11) NOT NULL auto_increment,
	url varchar(100) NOT NULL,
	frequency INT(15),
	PRIMARY KEY (rid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_referer</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_referer Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_related (
	rid int(11) NOT NULL auto_increment,
	tid int(11) DEFAULT '0' NOT NULL,
	name varchar(30) NOT NULL,
	url varchar(200) NOT NULL,
	PRIMARY KEY (rid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_related</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_related Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_reviews (
	id int(10) NOT NULL auto_increment,
	date date DEFAULT '0000-00-00' NOT NULL,
	title varchar(150) NOT NULL,
	text text NOT NULL,
	reviewer varchar(20),
	email varchar(60),
	score int(10) DEFAULT '0' NOT NULL,
	cover varchar(100) NOT NULL,
	url varchar(100) NOT NULL,
	url_title varchar(50) NOT NULL,
	hits int(10) DEFAULT '0' NOT NULL,
	rlanguage varchar(30) NOT NULL,
	PRIMARY KEY (id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_reviews</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_reviews Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_reviews_add (
	id int(10) NOT NULL auto_increment,
	date date,
	title varchar(150) NOT NULL,
	text text NOT NULL,
	reviewer varchar(20) NOT NULL,
	email varchar(60),
	score int(10) DEFAULT '0' NOT NULL,
	url varchar(100) NOT NULL,
	url_title varchar(50) NOT NULL,
	rlanguage varchar(30) NOT NULL,
	PRIMARY KEY (id)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_reviews_add</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_reviews_add Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_reviews_comments (
	cid int(10) NOT NULL auto_increment,
	rid int(10) DEFAULT '0' NOT NULL,
	userid varchar(25) NOT NULL,
	date datetime,
	comments text,
	score int(10) DEFAULT '0' NOT NULL,
	PRIMARY KEY (cid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_reviews_comments</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_reviews_comments Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_reviews_main (
	title varchar(100),
	description text
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_reviews_main</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_reviews_main Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_seccont (
	artid int(11) NOT NULL auto_increment,
	secid int(11) DEFAULT '0' NOT NULL,
	title text NOT NULL,
	content text NOT NULL,
	counter int(11) DEFAULT '0' NOT NULL,
	slanguage varchar(30) NOT NULL,
	PRIMARY KEY (artid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_seccont</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_seccont Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_sections (
	secid int(11) NOT NULL auto_increment,
	secname varchar(40) NOT NULL,
	image varchar(50) NOT NULL,
	PRIMARY KEY (secid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_sections</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_sections Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_session (
	username varchar(25) NOT NULL,
	time varchar(14) NOT NULL,
	host_addr varchar(20) NOT NULL,
	guest int(1) DEFAULT '0' NOT NULL
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_session</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_session Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_stories (
	sid int(11) NOT NULL auto_increment,
	catid int(11) DEFAULT '0' NOT NULL,
	aid varchar(30) NOT NULL,
	title varchar(80),
	time datetime,
	hometext text,
	bodytext text NOT NULL,
	comments int(11) DEFAULT '0',
	counter mediumint(8) unsigned,
	topic int(3) DEFAULT '1' NOT NULL,
	informant varchar(20) NOT NULL,
	notes text NOT NULL,
	ihome int(1) DEFAULT '0' NOT NULL,
	themeoverride varchar(30) NOT NULL,
	alanguage varchar(30) NOT NULL,
	withcomm int(1) DEFAULT '0' NOT NULL,
	PRIMARY KEY (sid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_stories</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_stories Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_stories_cat (
	catid int(11) NOT NULL auto_increment,
	title varchar(40) NOT NULL,
	counter int(11) DEFAULT '0' NOT NULL,
	themeoverride varchar(30) NOT NULL,
	PRIMARY KEY (catid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_stories_cat</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_stories_cat Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_topics (
	topicid int(3) NOT NULL auto_increment,
	topicname varchar(255),
	topicimage varchar(255),
	topictext varchar(255),
	counter int(11) DEFAULT '0' NOT NULL,
	PRIMARY KEY (topicid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_topics</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_topics Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_user_perms (
        pid int(11) NOT NULL auto_increment,
	uid int(11) NOT NULL,
	sequence int(6) NOT NULL,
	realm int(4) NOT NULL,
	component varchar(255) NOT NULL,
	instance varchar(255) NOT NULL,
	level int(4) NOT NULL,
	bond int(2) NOT NULL,
	PRIMARY KEY (pid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_user_perms</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_user_perms Made.</font>";

    $result = mysql_query("CREATE TABLE ".$prefix."_users (
	uid int(11) NOT NULL auto_increment,
	name varchar(60) NOT NULL,
	uname varchar(25) NOT NULL,
	email varchar(60) NOT NULL,
	femail varchar(60) NOT NULL,
	url varchar(100) NOT NULL,
	user_avatar varchar(30),
	user_regdate varchar(20) NOT NULL,
	user_icq varchar(15),
	user_occ varchar(100),
	user_from varchar(100),
	user_intrest varchar(150),
	user_sig varchar(255),
	user_viewemail tinyint(2),
	user_theme int(3),
	user_aim varchar(18),
	user_yim varchar(25),
	user_msnm varchar(25),
	pass varchar(40) NOT NULL,
	storynum tinyint(4) DEFAULT '10' NOT NULL,
	umode varchar(10) NOT NULL,
	uorder tinyint(1) DEFAULT '0' NOT NULL,
	thold tinyint(1) DEFAULT '0' NOT NULL,
	noscore tinyint(1) DEFAULT '0' NOT NULL,
	bio tinytext NOT NULL,
	ublockon tinyint(1) DEFAULT '0' NOT NULL,
	ublock tinytext NOT NULL,
	theme varchar(255) NOT NULL,
	commentmax int(11) DEFAULT '4096' NOT NULL,
	counter int(11) DEFAULT '0' NOT NULL,
	timezone_offset float(3,1) DEFAULT '0.0' NOT NULL,
	PRIMARY KEY (uid)
	)") or die ("<font class=\"post-failed\">Unable to make ".$prefix."_users</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_users Made.</font>";
	
	$result = mysql_query("CREATE TABLE ".$prefix."_userblocks (
    uid int(11) NOT NULL,
    bid int(10) NOT NULL,
    active tinyint(3) DEFAULT '1' NOT NULL,
    last_update timestamp(14)
	)") or die ("<font class=\"post-sub\">Unable to make ".$prefix."_userblocks</font>");

   echo "<br><font class=\"post-sub\">".$prefix."_userblocks Made.</font>";

  $result = mysql_query("CREATE TABLE ".$prefix."_languages_constant (
  constant varchar(32) NOT NULL default '',
  file varchar(64) NOT NULL default '',
  PRIMARY KEY  (constant))") or die ("<font class=\"post-sub\">Unable to make ".$prefix."_languages_constant</font>");

	$result = mysql_query("CREATE TABLE ".$prefix."_languages_file (
  target varchar(64) NOT NULL default '',
  source varchar(64) NOT NULL default '',
  PRIMARY KEY  (target,source),
  UNIQUE KEY source (source))") or die ("<font class=\"post-sub\">Unable to make ".$prefix."_languages_file</font>");


	$result = mysql_query("CREATE TABLE ".$prefix."_languages_translation (
  language varchar(32) NOT NULL default '',
  constant varchar(32) NOT NULL default '',
  translation varchar(255) NOT NULL default '',
  level tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (constant,language))") or die ("<font class=\"post-sub\">Unable to make ".$prefix."_languages_translation</font>");

    echo "<br><font class=\"post-sub\">".$prefix."_users Made.</font>";
    echo "<br></center><br><br>";

?>
Return current item: ProNuke. Postnuke To Oracle