sql error. Please edit 4 me.

[Reddax]

thankz....

[vijayakumar]

enjoy :-)

-- PhpMyAdmin SQL Dump
-- 3.4.5
-- [url=http://www.phpmyadmin.net]phpMyAdmin[/url]
--
-- Host: localhost
-- Generation Time: Jan 16, 2012 at 03:06 AM
-- Server version: 5.1.56
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Table structure for table admins
--

CREATE TABLE `admins` (
  `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  PRIMARY KEY  (`Id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table admins
--

INSERT INTO `admins` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3');

--
-- Table structure for table advertising_links
--

CREATE TABLE `advertising_links` (
  `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`Id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table config
--

CREATE TABLE `config` (
  `id` int(6) unsigned NOT NULL default '0',
  `block_limit` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table counter
--

CREATE TABLE `counter` (
  `id` int(6) unsigned NOT NULL default '0',
  `today` int(4) NOT NULL default '0',
  `total` int(4) NOT NULL default '0',
  `last_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table counter_ips
--

CREATE TABLE `counter_ips` (
  `id` int(6) unsigned NOT NULL default '0',
  `ip` char(15) NOT NULL default '',
  `last_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`,`ip`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table guest_book
--

CREATE TABLE `guest_book` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `text` text,
  `date` datetime default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table links
--

CREATE TABLE `links` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table news
--

CREATE TABLE `news` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `text` text,
  `date` datetime default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table polls_answers
--

CREATE TABLE `polls_answers` (
  `qid` int(10) unsigned NOT NULL default '0',
  `aid` int(10) unsigned NOT NULL default '0',
  `answer` varchar(255) NOT NULL default '',
  `votes` int(10) unsigned NOT NULL default '0',
  KEY `pid` (`qid`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table polls_questions
--

CREATE TABLE `polls_questions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(250) NOT NULL default '',
  `date` datetime default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Table structure for table users
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `surname` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `banner` enum('top','bottom','none') NOT NULL default 'top',
  `active` enum('0','1') NOT NULL default '1',
  `block_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[Reddax]

thank you