Добавяне на MYSQL таблица ..

[monty1991]

Значи незнам как точно да добавя следните неща към съществуващите .. Опитах какво ли не и все дава някаква грешка :shock:

Искам към това

//MYSQL TABLES TO BE CREATED-------------------------------+

  $eplug_table_names = array
  (
  "lgsl"
  );

Да добавя това

  $eplug_table_names = array
  (
  "voting"
  );

иии към това

//MYSQL TABLE STRUCTURE--------------------------------------------------------------------------------------+

  $eplug_tables = array
  (
  "CREATE TABLE `".MPREFIX."lgsl` (

    `id`         INT     (11)  NOT NULL auto_increment,
    `type`       VARCHAR (50)  NOT NULL DEFAULT '',
    `ip`         VARCHAR (255) NOT NULL DEFAULT '',
    `c_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
    `q_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
    `s_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
    `zone`       VARCHAR (255) NOT NULL DEFAULT '0',
    `disabled`   TINYINT (1)   NOT NULL DEFAULT '0',
    `status`     TINYINT (1)   NOT NULL DEFAULT '0',
    `cache`      TEXT          NOT NULL,
    `cache_time` TEXT          NOT NULL,
    `rating`     INT     (11)  NOT NULL DEFAULT '0',

    PRIMARY KEY (`id`)

  ) ".(strpos(mysql_get_server_info(), "4.0") !== FALSE ? "TYPE=MyISAM;" : "ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;")
  );

Да добавя това

CREATE TABLE `".MPREFIX."voting` (

  `id`           int     (11)  NOT NULL auto_increment,

  `server_id`    int     (10)  NOT NULL,
  `vote_ip`      varchar (15)  NOT NULL,
  `time`         int     (11)  NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;

Вие сте :?: :?:

 

[ivo_pi4a]

$eplug_table_names = array

  ("lgsl","voting" );

$eplug_tables = array
(
"CREATE TABLE `".MPREFIX."lgsl` (
`id`         INT     (11)  NOT NULL auto_increment,
`type`       VARCHAR (50)  NOT NULL DEFAULT '',
`ip`         VARCHAR (255) NOT NULL DEFAULT '',
`c_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
`q_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
`s_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
`zone`       VARCHAR (255) NOT NULL DEFAULT '0',
`disabled`   TINYINT (1)   NOT NULL DEFAULT '0',
`status`     TINYINT (1)   NOT NULL DEFAULT '0',
`cache`      TEXT          NOT NULL,
`cache_time` TEXT          NOT NULL,
`rating`     INT     (11)  NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)".(strpos(mysql_get_server_info(), "4.0") !== FALSE ? "TYPE=MyISAM;" : "ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;"),
    "CREATE TABLE `".MPREFIX."voting` (
`id`           int     (11)  NOT NULL auto_increment,
`server_id`    int     (10)  NOT NULL,
`vote_ip`      varchar (15)  NOT NULL,
`time`         int     (11)  NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci"
);