Windows Tables

[Muciz]

Hello again !

how to add tables for website and where is the tables ?

 

[Friizee]

which tables need to add? specified

 

[Muciz]

Table 'hellfire.poll' doesn't exist <----- this tables :S

 

[Friizee]

CREATE TABLE IF NOT EXISTS `poll` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `question` VARCHAR(150) ,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_start` datetime ,
  `date_end` datetime ,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `question` (`question`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `poll_answer` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `poll_id` INT(11) NOT NULL,
  `answer` VARCHAR(150) ,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `poll_votes` (`id` INT(11) NOT NULL AUTO_INCREMENT,`answer_id` INT(11) ,`poll_id` INT(11) ,`account_id` INT(11) NOT NULL,PRIMARY KEY (`id`),FOREIGN KEY (`answer_id`) REFERENCES `poll_answer` (`id`) ON DELETE CASCADE,FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE,FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Muciz]

Need to add them in database/sql?

 

[Friizee]

yeah

 

[Muciz]

I added all that what to do now? dont work

 

[Friizee]

sure to correctly copy the tables in sql,
I just copied the and did not give me problems

 

[Muciz]

can u show me where u did get the tables? i think i got tables too but dont know where

 

[Friizee]

http://localhost/phpmyadmin/"YOUOT"/SQL/ and copy paste tables

 

[Muciz]

isnt there a dokument for the tables in xampp or something like that?

- - - Updated - - -

 

[Friizee]

no, only sql, you adds tables I gave and fix your problem

 

[Muciz]

I have added that u send me this is the score ---> Error Number: 1146

Table 'hellfire.news' doesn't exist

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

xD

 

[Friizee]

Sql

 CREATE TABLE IF NOT EXISTS `news` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL DEFAULT '',

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Muciz]

It works, Thx bro

 

[Friizee]

rep+ me :c

 

[Demnish]

Got this error when trying to add the poll_votes

Supports transactions, row-level locking, and foreign keys