phpBB España Oficial

Código: Seleccionar todo

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `phpbb_thanks`;
CREATE TABLE `phpbb_thanks` (
  `post_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM;
SET FOREIGN_KEY_CHECKS = 1;

Código: Seleccionar todo

CREATE TABLE `phpbb_thanks` (
  `thanks_id` mediumint(8) unsigned NOT NULL auto_increment,
  `thanks_from` mediumint(8) unsigned NOT NULL,
  `thanks_to` mediumint(8) unsigned NOT NULL,
  `post_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`thanks_id`)
);
ALTER TABLE `phpbb_posts` ADD `post_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` ADD `user_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks_post` INT(11) UNSIGNED NOT NULL DEFAULT '0';

Código: Seleccionar todo

DROP TABLE IF EXISTS `phpbb_thanks`;
DROP TABLE `phpbb_thanks`;

Código: Seleccionar todo

DROP TABLE IF EXISTS `phpbb_thanks` on cascade_contrains;
DROP TABLE `phpbb_thanks` on cascade_contrains;

Código: Seleccionar todo

ALTER TABLE `phpbb_posts` DROP `post_thanked`;
ALTER TABLE `phpbb_users` DROP `user_thanked`,
DROP `user_thanks`,
DROP `user_thanks_post`;