Можете ли да ми направите базадани

[Emperator]

Здравейте преди доста време 1 приятел ми направи много прост форум но изгубих базата дани може ли да ми направите друга

mysql_query("INSERT into forums_topics SET uid='$aid',name='$tname',fid='$_GET[fid]'") or die(mysql_error());
$nid = mysql_insert_id();
mysql_query("INSERT into forums_posts SET uid='$aid',tid='$nid',body='$text',date='$date'") or die(mysql_error());
mysql_query("UPDATE forums_main SET topics = topics+1,posts = posts+1 WHERE id='$_GET[fid]'") or die(mysql_error());

 

[shashma88]

CREATE TABLE `forums_main` (
`id` int(11) NOT NULL auto_increment,
`fname` varchar(255) NOT NULL,
`topics` varchar(255) NOT NULL,
`posts` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

CREATE TABLE `forums_topics` (
`id` int(11) NOT NULL auto_increment,
`uid` int(15) NOT NULL,
`fid` int(15) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

CREATE TABLE `forums_posts` (
`id` int(11) NOT NULL auto_increment,
`uid` int(15) NOT NULL,
`tid` int(15) NOT NULL,
`body` varchar(255) NOT NULL,
`date` datetime NOT NULL,

PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

[Emperator]

CREATE TABLE `forums_main` (
`id` int(11) NOT NULL auto_increment,
`fname` varchar(255) NOT NULL,
`topics` varchar(255) NOT NULL,
`posts` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

CREATE TABLE `forums_topics` (
`id` int(11) NOT NULL auto_increment,
`uid` int(15) NOT NULL,
`fid` int(15) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

CREATE TABLE `forums_posts` (
`id` int(11) NOT NULL auto_increment,
`uid` int(15) NOT NULL,
`tid` int(15) NOT NULL,
`body` varchar(255) NOT NULL,
`date` datetime NOT NULL,

PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

мс +1 :?: