• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    [Guia] moder acc tablas mysql

    Compartir:

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 1 de 1.)

    1default [Guia] moder acc tablas mysql el Jue Ago 09, 2018 12:41 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    Hola usuarios de tibiaface



    bueno aqui le dejo todas las tablas mysql de la moder para lo que tienen problemas al momento de ejecutar su moder acc


    Código:

    ALTER TABLE `accounts` ADD `page_access` INT(11);
    ALTER TABLE `accounts` ADD `page_lastday` INT(11);
    ALTER TABLE `accounts` ADD `email_new` VARCHAR(255);
    ALTER TABLE `accounts` ADD `email_new_time` INT(15);
    ALTER TABLE `accounts` ADD `rlname` VARCHAR(255);
    ALTER TABLE `accounts` ADD `location` VARCHAR(255);
    ALTER TABLE `accounts` ADD `created` INT(16);
    ALTER TABLE `accounts` ADD `email_code` VARCHAR(255);
    ALTER TABLE `accounts` ADD `next_email` INT(11);
    ALTER TABLE `accounts` ADD `premium_points` INT(11);
    ALTER TABLE `accounts` ADD `nickname` CHAR(48);
    ALTER TABLE `accounts` ADD avatar CHAR(48);
    ALTER TABLE `accounts` ADD about_me text;
    ALTER TABLE `accounts` ADD `nickname` VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE `accounts` CHANGE  `key`  `key` VARCHAR( 128 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '';
    ALTER TABLE `players` ADD `old_name` VARCHAR(255);
    ALTER TABLE `players` ADD `hide_char` INT(11);
    ALTER TABLE `players` ADD `worldtransfer` INT(11);
    ALTER TABLE `players` ADD `created` INT(16);
    ALTER TABLE `players` ADD `nick_verify` INT(11);
    ALTER TABLE `players` ADD `comment` text;
    UPDATE `players` SET `hide_char` = 0;
    UPDATE `accounts` SET `key` = '';
     
    INSERT INTO `players` (`name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`) VALUES
    ('Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
    ('Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
    ('Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
    ('Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
    ('Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.');
     
    CREATE TABLE IF NOT EXISTS `bugtracker` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `category` INT(3) NOT NULL,
      `time` INT(11),
      `author` INT(11) NOT NULL,
      `text` text,
      `title` VARCHAR(120),
      `done` tinyint(3),
      `priority` tinyint(3),
      `closed` tinyint(1) DEFAULT '0',
      PRIMARY KEY (`id`),
      FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE 
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `friends` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `with` INT(11),
      `friend` INT(11),
      `time` INT(11),
      `active` tinyint(1),
      PRIMARY KEY (`id`),
      FOREIGN KEY (`with`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
      FOREIGN KEY (`friend`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `messages` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `from` INT(11),
      `to` INT(11),
      `title` VARCHAR(120),
      `text` tinytext,
      `time` INT(11),
      `delete_from` tinyint(1),
      `delete_to` tinyint(1),
      `unread` tinyint(1),
      PRIMARY KEY (`id`),
      FOREIGN KEY (`from`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
      FOREIGN KEY (`to`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `news` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `title` VARCHAR(150) DEFAULT '',
      `body` text,
      `time` INT(11) DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `comments` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `news_id` INT(11),
      `body` text,
      `time` INT(11) DEFAULT '0',
      `author` INT(11) DEFAULT '0',
      PRIMARY KEY (`id`),
      FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
      FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `forums` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `name` VARCHAR(120),
      `description` tinytext,
      `access` SMALLINT(5) DEFAULT '1' COMMENT 'Min. access to see the board',
      `closed` tinyint(1),
      `moderators` tinytext,
      `order` INT(6),
      `requireLogin` tinyint(1),
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    ALTER TABLE `forums` ADD `guild` INT(11);
     
    CREATE TABLE IF NOT EXISTS `threads` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `name` VARCHAR(120),
      `sticked` tinyint(1),
      `closed` tinyint(1),
      `author` VARCHAR(64),
      `time` INT(11),
      `board_id` INT(11),
      PRIMARY KEY (`id`),
      FOREIGN KEY (`board_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `posts` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `title` VARCHAR(120) ,
      `text` text,
      `time` INT(11),
      `author` VARCHAR(64),
      `board_id` INT(11),
      `thread_id` INT(11),
      PRIMARY KEY (`id`),
      FOREIGN KEY (`board_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE,
      FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    CREATE TABLE IF NOT EXISTS `videos` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `author` INT(11) ,
      `title` VARCHAR(120),
      `description` tinytext,
      `youtube` VARCHAR(45),
      `views` INT(11),
      `time` INT(11),
      PRIMARY KEY (`id`),
      FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
     
    CREATE TABLE IF NOT EXISTS `video_comments` (
      `id` INT(10) NOT NULL AUTO_INCREMENT,
      `author` INT(11),
      `video` INT(11),
      `time` INT(11),
      `text` tinytext,
      PRIMARY KEY (`id`),
      FOREIGN KEY (`video`) REFERENCES `videos` (`id`) ON DELETE CASCADE,
      FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     
    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 ;



    Ver perfil de usuario http://www.tibiaface.com

    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 1 de 1.)

    Permisos de este foro:
    No puedes responder a temas en este foro.

     

    BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).