Jump to content

Archived

This topic is now archived and is closed to further replies.

gsurface

MYSQL Errors

Recommended Posts

I was wondering if anyone here would be able to tell me what is wrong with the following MYSQL code below. When I try to run it in PHPMyAdmin, it gives me a #1064 error.

[code]
-- MySQL dump 10.9
--
-- Host: localhost    Database: blog_memes
-- ------------------------------------------------------
-- Server version    4.1.16-standard

/*!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 latin1 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `debate`
--

DROP TABLE IF EXISTS `debate`;
CREATE TABLE `debate` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `position` int(11) default NULL,
  `post_id` int(11) default NULL,
  `comment` text,
  `date_posted` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_debate_meme` (`post_id`),
  KEY `idx_debate_user` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_cats`
--

DROP TABLE IF EXISTS `post_cats`;
CREATE TABLE `post_cats` (
  `cat_title` varchar(100) default NULL,
  `cat_desc` text,
  `ID` int(11) NOT NULL auto_increment,
  `lang` char(2) default 'es',
  `feed` text,
  PRIMARY KEY  (`ID`),
  KEY `idx_cat_title` (`cat_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_comments`
--

DROP TABLE IF EXISTS `post_comments`;
CREATE TABLE `post_comments` (
  `title` varchar(200) default NULL,
  `content` text,
  `user_id` int(11) default NULL,
  `post_id` int(11) default NULL,
  `date_posted` int(11) default NULL,
  `ID` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`ID`),
  KEY `idx_post_comments` (`post_id`),
  KEY `idx_user_comment` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `post_votes`
--

DROP TABLE IF EXISTS `post_votes`;
CREATE TABLE `post_votes` (
  `post_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `date_voted` int(11) default NULL,
  `ID` int(11) NOT NULL auto_increment,
  `ip_address` varchar(15) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `idx_post_votes_ip` (`ip_address`),
  KEY `idx_post_votes_user_id` (`user_id`),
  KEY `idx_post_votes_post_id` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `title` varchar(200) default NULL,
  `content` text,
  `date_posted` int(11) default NULL,
  `category` int(11) default NULL,
  `url` varchar(200) default NULL,
  `submitted_user_id` int(11) default NULL,
  `ID` int(11) NOT NULL auto_increment,
  `trackback` varchar(200) default NULL,
  `date_promo` int(11) default NULL,
  `lang` varchar(2) default 'es',
  `clicks` int(11) default '0',
  `rank` int(11) default '0',
  `votes` int(11) NOT NULL default '0',
  `is_micro_content` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `icon` varchar(200) default NULL,
  `debate_0` int(11) default '0',
  `debate_neg` int(11) default '0',
  `debate_pos` int(11) default '0',
  `allows_debates` int(11) NOT NULL default '0',
  `promoted` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `idx_post_dates` (`date_posted`),
  KEY `idx_post_submiters` (`submitted_user_id`),
  KEY `idx_post_cats` (`category`),
  KEY `idx_post_url` (`url`),
  KEY `idx_promo` (`date_promo`),
  KEY `post_lang` (`lang`),
  KEY `idx_post_rank` (`rank`),
  KEY `idx_post_votes` (`votes`),
  KEY `idx_prooted` (`promoted`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `ID` int(11) NOT NULL auto_increment,
  `tag` varchar(40) default NULL,
  `lang` char(2) default 'es',
  PRIMARY KEY  (`ID`),
  KEY `idx_tags` (`tag`),
  KEY `idx_tags_lang` (`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tags_posts`
--

DROP TABLE IF EXISTS `tags_posts`;
CREATE TABLE `tags_posts` (
  `tag_id` int(11) NOT NULL default '0',
  `post_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tag_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `tags_user`
--

DROP TABLE IF EXISTS `tags_user`;
CREATE TABLE `tags_user` (
  `tag_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tag_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(100) default NULL,
  `password` varchar(32) default NULL,
  `email` varchar(200) default NULL,
  `join_date` int(11) default NULL,
  `admin` enum('0','1') default NULL,
  `ID` int(11) NOT NULL auto_increment,
  `website` varchar(200) default NULL,
  `blog` varchar(200) default NULL,
  `fullname` varchar(200) default NULL,
  `persistent_session` varchar(64) default NULL,
  `gravatar` varchar(32) default NULL,
  `strong_pass` blob,
  PRIMARY KEY  (`ID`),
  KEY `idx_username` (`username`),
  KEY `idx_user_email` (`email`),
  KEY `idx_persist_session` (`persistent_session`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `users_profiles`
--

DROP TABLE IF EXISTS `users_profiles`;
CREATE TABLE `users_profiles` (
  `user_id` int(11) default NULL,
  `full_name` varchar(100) default NULL,
  `website` varchar(200) default NULL,
  `blogsite` varchar(200) default NULL,
  `preferred_lang` char(2) default NULL,
  `id` int(11) NOT NULL auto_increment,
  `avatar` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

[/code]

Share this post


Link to post
Share on other sites
What error did you get back (not just the code)?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.