• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Tables

Sort by date Sort by votes
Code: 
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 ;

Code: 
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 ;

Code: 
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 ;
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Sql

Code: 
 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 ;
 
Upvote 0 Downvote
Back
Top