Помощ за SQL език

XeS · 9 Август 2007

Някой има ли на OGame SQL файла, който е със сетнат windows-1251 ?
Преведох си играта но никаде не намерих на друго място от каде се сетва езика по дефулт в sql-а. А както и да го въртя win1251 win-1251 windows-1251 cp1251 нито едно от всичките не ми го приема sql.А на utf-8 го приема файла но ми излиза всичко на маймуница.
Ето го реда от sql-a

Код:

You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE=win1251 AUTO_INCREMENT=27' at line 13

Та идеята ми беше на този ред тука:

Код:

) ENGINE=MyISAM CHARSET=cp1251 COLLATE=win1251 AUTO_INCREMENT=27 ;

как се задава да е windows-1251 ?

miro_94 · 9 Август 2007

Код:

)ENGINE=MyISAM CHARACTER SET cp1251 COLLATE cp1251_bulgarian_ci;

XeS · 9 Август 2007

Незнам аз ли нещо немога да го схвана но и по този начин нестава ето направо цялата грешка:

Код:

 БД ogame  работи на localhost

Грешка

SQL-запитване : 

CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET = cp1251 COLLATE = cp1251_bulgarian_ci AUTO_INCREMENT =27

MySQL отговори:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=27' at line 13

miro_94 · 9 Август 2007

XeS каза:

Незнам аз ли нещо немога да го схвана но и по този начин нестава ето направо цялата грешка:

Код:

 БД ogame  работи на localhost

Грешка

SQL-запитване : 

CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET = cp1251 COLLATE = cp1251_bulgarian_ci AUTO_INCREMENT =27

MySQL отговори:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=27' at line 13

От къде идват тези равни това е грешката.

Код:

CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci

Ето така е правилно.

XeS · 9 Август 2007

И по този начин връща пак същата грешка, имаш ли някакви други идеи?

miro_94 · 9 Август 2007

да

Код:

CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

Бях изпуснал ;

:?:

XeS · 9 Август 2007

Ще съм ти много благодарен ако отделиш малко време и метнеш едно око на целият код, който е в този SQL файл... понеже май и тези ; не помогат

Код:

-- --------------------------------------------------------

-- 
-- Структура таблици `alliance`
-- 

DROP TABLE IF EXISTS `alliance`;
CREATE TABLE IF NOT EXISTS `alliance` (
  `id` int(11) NOT NULL auto_increment,
  `ally_name` varchar(32) default '',
  `ally_tag` varchar(8) default '',
  `ally_owner` int(11) NOT NULL default '0',
  `ally_description` text,
  `ally_web` varchar(255) default '',
  `ally_text` text,
  `ally_image` varchar(255) default '',
  `ally_request` text,
  `ally_request_notallow` tinyint(4) NOT NULL default '0',
  `ally_owner_range` varchar(32) default '',
  `ally_register_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `buddy`
-- 

DROP TABLE IF EXISTS `buddy`;
CREATE TABLE IF NOT EXISTS `buddy` (
  `id` int(11) NOT NULL auto_increment,
  `sender` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `active` tinyint(3) NOT NULL default '0',
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `changelog`
-- 

DROP TABLE IF EXISTS `changelog`;
CREATE TABLE IF NOT EXISTS `changelog` (
  `id` int(11) NOT NULL auto_increment,
  `version` varchar(32) default NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `fleets`
-- 

DROP TABLE IF EXISTS `fleets`;
CREATE TABLE IF NOT EXISTS `fleets` (
  `fleet_id` int(11) NOT NULL auto_increment,
  `fleet_owner` int(11) NOT NULL default '0',
  `fleet_mission` int(11) NOT NULL default '0',
  `fleet_amount` int(11) NOT NULL default '0',
  `fleet_array` text,
  `fleet_start_time` int(11) NOT NULL default '0',
  `fleet_start_galaxy` int(11) NOT NULL default '0',
  `fleet_start_system` int(11) NOT NULL default '0',
  `fleet_start_planet` int(11) NOT NULL default '0',
  `fleet_start_type` int(11) NOT NULL default '0',
  `fleet_end_time` int(11) NOT NULL default '0',
  `fleet_end_galaxy` int(11) NOT NULL default '0',
  `fleet_end_system` int(11) NOT NULL default '0',
  `fleet_end_planet` int(11) NOT NULL default '0',
  `fleet_end_type` int(11) NOT NULL default '0',
  `fleet_resource_metal` double(16,6) default NULL,
  `fleet_resource_crystal` double(16,6) default NULL,
  `fleet_resource_deuterium` double(16,6) default NULL,
  PRIMARY KEY  (`fleet_id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_cat`
-- 

DROP TABLE IF EXISTS `forum_cat`;
CREATE TABLE IF NOT EXISTS `forum_cat` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_categories`
-- 

DROP TABLE IF EXISTS `forum_categories`;
CREATE TABLE IF NOT EXISTS `forum_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_posts`
-- 

DROP TABLE IF EXISTS `forum_posts`;
CREATE TABLE IF NOT EXISTS `forum_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_posts_text`
-- 

DROP TABLE IF EXISTS `forum_posts_text`;
CREATE TABLE IF NOT EXISTS `forum_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_topics`
-- 

DROP TABLE IF EXISTS `forum_topics`;
CREATE TABLE IF NOT EXISTS `forum_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) character set latin1 NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) ENGINE=MyISAM CHARSET=latin7 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `galaxy`
-- 

DROP TABLE IF EXISTS `galaxy`;
CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci; AUTO_INCREMENT=27 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `messages`
-- 

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(11) NOT NULL auto_increment,
  `message_owner` int(11) NOT NULL default '0',
  `message_sender` int(11) NOT NULL default '0',
  `message_time` int(11) NOT NULL default '0',
  `message_type` int(11) NOT NULL default '0',
  `message_from` varchar(32) default NULL,
  `message_subject` varchar(32) default NULL,
  `message_text` text,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `notes`
-- 

DROP TABLE IF EXISTS `notes`;
CREATE TABLE IF NOT EXISTS `notes` (
  `id` int(11) NOT NULL auto_increment,
  `owner` int(11) default NULL,
  `time` int(11) default NULL,
  `priority` tinyint(1) default NULL,
  `title` varchar(32) default NULL,
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `planets`
-- 

DROP TABLE IF EXISTS `planets`;
CREATE TABLE IF NOT EXISTS `planets` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(255) character set latin1 default NULL,
  `id_owner` int(11) default NULL,
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `last_update` int(11) default NULL,
  `planet_type` int(11) NOT NULL default '1',
  `destruyed` int(11) NOT NULL default '0',
  `b_building` int(11) NOT NULL default '0',
  `b_building_id` int(11) NOT NULL default '0',
  `b_tech` int(11) NOT NULL default '0',
  `b_tech_id` int(11) NOT NULL default '0',
  `b_hangar` int(11) NOT NULL default '0',
  `b_hangar_id` text character set latin1 NOT NULL,
  `image` char(32) character set latin1 NOT NULL default 'normaltempplanet01',
  `diameter` int(11) NOT NULL default '12800',
  `field_current` int(11) NOT NULL default '0',
  `field_max` int(11) NOT NULL default '163',
  `temp_min` int(3) NOT NULL default '-17',
  `temp_max` int(3) NOT NULL default '23',
  `metal` double(16,6) NOT NULL default '500.000000',
  `metal_perhour` int(11) NOT NULL default '0',
  `metal_max` bigint(20) NOT NULL default '100000',
  `crystal` double(16,6) NOT NULL default '500.000000',
  `crystal_perhour` int(11) NOT NULL default '0',
  `crystal_max` bigint(20) NOT NULL default '100000',
  `deuterium` double(16,6) NOT NULL default '0.000000',
  `deuterium_perhour` int(11) NOT NULL default '0',
  `deuterium_max` bigint(20) NOT NULL default '100000',
  `energy_free` int(11) NOT NULL default '0',
  `energy_max` int(11) NOT NULL default '0',
  `metal_mine` int(11) NOT NULL default '0',
  `crystal_mine` int(11) NOT NULL default '0',
  `deuterium_sintetizer` int(11) NOT NULL default '0',
  `solar_plant` int(11) NOT NULL default '0',
  `fusion_plant` int(11) NOT NULL default '0',
  `robot_factory` int(11) NOT NULL default '0',
  `nano_factory` int(11) NOT NULL default '0',
  `hangar` int(11) NOT NULL default '0',
  `metal_store` int(11) NOT NULL default '0',
  `crystal_store` int(11) NOT NULL default '0',
  `deuterium_store` int(11) NOT NULL default '0',
  `laboratory` int(11) NOT NULL default '0',
  `terraformer` int(11) NOT NULL default '0',
  `ally_deposit` int(11) NOT NULL default '0',
  `silo` int(11) NOT NULL default '0',
  `small_ship_cargo` int(11) NOT NULL default '0',
  `big_ship_cargo` int(11) NOT NULL default '0',
  `light_hunter` int(11) NOT NULL default '0',
  `heavy_hunter` int(11) NOT NULL default '0',
  `crusher` int(11) NOT NULL default '0',
  `battle_ship` int(11) NOT NULL default '0',
  `colonizer` int(11) NOT NULL default '0',
  `recycler` int(11) NOT NULL default '0',
  `spy_sonde` int(11) NOT NULL default '0',
  `bomber_ship` int(11) NOT NULL default '0',
  `solar_satelit` int(11) NOT NULL default '0',
  `destructor` int(11) NOT NULL default '0',
  `dearth_star` int(11) NOT NULL default '0',
  `metalmine_porcent` int(11) NOT NULL default '0',
  `crystalmine_porcent` int(11) NOT NULL default '0',
  `deuterium_porcent` int(11) NOT NULL default '0',
  `solarplant_porcent` int(11) NOT NULL default '0',
  `fusion_porcent` int(11) NOT NULL default '0',
  `satelite_porcent` int(11) NOT NULL default '0',
  `misil_launcher` int(11) NOT NULL default '0',
  `small_laser` int(11) NOT NULL default '0',
  `big_laser` int(11) NOT NULL default '0',
  `gauss_canyon` int(11) NOT NULL default '0',
  `ionic_canyon` int(11) NOT NULL default '0',
  `buster_canyon` int(11) NOT NULL default '0',
  `small_protection_shield` int(11) NOT NULL default '0',
  `big_protection_shield` int(11) NOT NULL default '0',
  `interceptor_misil` int(11) NOT NULL default '0',
  `interplanetary_misil` int(11) NOT NULL default '0',
  `lunar_base` int(11) NOT NULL default '0',
  `sensor_phalax` int(11) NOT NULL default '0',
  `quantic_jump` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=27 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `resource`
-- 

DROP TABLE IF EXISTS `resource`;
CREATE TABLE IF NOT EXISTS `resource` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(8) NOT NULL,
  `name` varchar(32) NOT NULL,
  `title` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Структура таблици `users`
-- 

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(64) character set latin1 NOT NULL default '',
  `password` varchar(64) character set latin1 NOT NULL default '',
  `email` varchar(64) character set latin1 NOT NULL default '',
  `email_first` varchar(64) character set latin1 NOT NULL default '',
  `email_2` varchar(64) character set latin1 NOT NULL default '',
  `lang` char(8) character set latin1 NOT NULL default 'es',
  `authlevel` tinyint(4) NOT NULL default '0',
  `sex` char(1) character set latin1 default NULL,
  `avatar` char(255) character set latin1 NOT NULL default '',
  `sign` text character set latin1,
  `id_planet` int(11) NOT NULL default '0',
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `current_planet` int(11) NOT NULL default '0',
  `user_lastip` varchar(16) character set latin1 NOT NULL default '',
  `register_time` int(11) NOT NULL default '0',
  `onlinetime` int(11) NOT NULL default '0',
  `dpath` varchar(255) character set latin1 NOT NULL default '',
  `design` tinyint(4) NOT NULL default '1',
  `noipcheck` tinyint(4) NOT NULL default '1',
  `spio_anz` tinyint(4) NOT NULL default '1',
  `settings_tooltiptime` tinyint(4) NOT NULL default '5',
  `settings_fleetactions` tinyint(4) NOT NULL default '0',
  `settings_allylogo` tinyint(4) NOT NULL default '0',
  `settings_esp` tinyint(4) NOT NULL default '1',
  `settings_wri` tinyint(4) NOT NULL default '1',
  `settings_bud` tinyint(4) NOT NULL default '1',
  `settings_mis` tinyint(4) NOT NULL default '1',
  `settings_rep` tinyint(4) NOT NULL default '0',
  `urlaubs_modus` tinyint(4) NOT NULL default '0',
  `db_deaktjava` tinyint(4) NOT NULL default '0',
  `points` bigint(20) NOT NULL default '0',
  `new_message` int(11) NOT NULL default '0',
  `fleet_shortcut` text character set latin1,
  `b_tech_planet` int(11) NOT NULL default '0',
  `spy_tech` int(11) NOT NULL default '0',
  `computer_tech` int(11) NOT NULL default '0',
  `military_tech` int(11) NOT NULL default '0',
  `defence_tech` int(11) NOT NULL default '0',
  `shield_tech` int(11) NOT NULL default '0',
  `energy_tech` int(11) NOT NULL default '0',
  `hyperspace_tech` int(11) NOT NULL default '0',
  `combustion_tech` int(11) NOT NULL default '0',
  `impulse_motor_tech` int(11) NOT NULL default '0',
  `hyperspace_motor_tech` int(11) NOT NULL default '0',
  `laser_tech` int(11) NOT NULL default '0',
  `ionic_tech` int(11) NOT NULL default '0',
  `buster_tech` int(11) NOT NULL default '0',
  `intergalactic_tech` int(11) NOT NULL default '0',
  `graviton_tech` int(11) NOT NULL default '0',
  `ally_id` int(11) NOT NULL default '0',
  `ally_request` int(11) NOT NULL default '0',
  `ally_register_time` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `id_planet` (`id_planet`)
) ENGINE=MyISAM CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=27 ;

miro_94 · 9 Август 2007

Заповядай

Код:

CREATE TABLE IF NOT EXISTS `alliance` (
  `id` int(11) NOT NULL auto_increment,
  `ally_name` varchar(32) default '',
  `ally_tag` varchar(8) default '',
  `ally_owner` int(11) NOT NULL default '0',
  `ally_description` text,
  `ally_web` varchar(255) default '',
  `ally_text` text,
  `ally_image` varchar(255) default '',
  `ally_request` text,
  `ally_request_notallow` tinyint(4) NOT NULL default '0',
  `ally_owner_range` varchar(32) default '',
  `ally_register_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;


CREATE TABLE IF NOT EXISTS `buddy` (
  `id` int(11) NOT NULL auto_increment,
  `sender` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `active` tinyint(3) NOT NULL default '0',
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `changelog` (
  `id` int(11) NOT NULL auto_increment,
  `version` varchar(32) default NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `fleets` (
  `fleet_id` int(11) NOT NULL auto_increment,
  `fleet_owner` int(11) NOT NULL default '0',
  `fleet_mission` int(11) NOT NULL default '0',
  `fleet_amount` int(11) NOT NULL default '0',
  `fleet_array` text,
  `fleet_start_time` int(11) NOT NULL default '0',
  `fleet_start_galaxy` int(11) NOT NULL default '0',
  `fleet_start_system` int(11) NOT NULL default '0',
  `fleet_start_planet` int(11) NOT NULL default '0',
  `fleet_start_type` int(11) NOT NULL default '0',
  `fleet_end_time` int(11) NOT NULL default '0',
  `fleet_end_galaxy` int(11) NOT NULL default '0',
  `fleet_end_system` int(11) NOT NULL default '0',
  `fleet_end_planet` int(11) NOT NULL default '0',
  `fleet_end_type` int(11) NOT NULL default '0',
  `fleet_resource_metal` double(16,6) default NULL,
  `fleet_resource_crystal` double(16,6) default NULL,
  `fleet_resource_deuterium` double(16,6) default NULL,
  PRIMARY KEY  (`fleet_id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `forum_cat` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `forum_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `forum_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) character set latin1 NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
)ENGINE = MYISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(11) NOT NULL auto_increment,
  `message_owner` int(11) NOT NULL default '0',
  `message_sender` int(11) NOT NULL default '0',
  `message_time` int(11) NOT NULL default '0',
  `message_type` int(11) NOT NULL default '0',
  `message_from` varchar(32) default NULL,
  `message_subject` varchar(32) default NULL,
  `message_text` text,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `notes` (
  `id` int(11) NOT NULL auto_increment,
  `owner` int(11) default NULL,
  `time` int(11) default NULL,
  `priority` tinyint(1) default NULL,
  `title` varchar(32) default NULL,
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `planets` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(255) character set latin1 default NULL,
  `id_owner` int(11) default NULL,
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `last_update` int(11) default NULL,
  `planet_type` int(11) NOT NULL default '1',
  `destruyed` int(11) NOT NULL default '0',
  `b_building` int(11) NOT NULL default '0',
  `b_building_id` int(11) NOT NULL default '0',
  `b_tech` int(11) NOT NULL default '0',
  `b_tech_id` int(11) NOT NULL default '0',
  `b_hangar` int(11) NOT NULL default '0',
  `b_hangar_id` text character set latin1 NOT NULL,
  `image` char(32) character set latin1 NOT NULL default 'normaltempplanet01',
  `diameter` int(11) NOT NULL default '12800',
  `field_current` int(11) NOT NULL default '0',
  `field_max` int(11) NOT NULL default '163',
  `temp_min` int(3) NOT NULL default '-17',
  `temp_max` int(3) NOT NULL default '23',
  `metal` double(16,6) NOT NULL default '500.000000',
  `metal_perhour` int(11) NOT NULL default '0',
  `metal_max` bigint(20) NOT NULL default '100000',
  `crystal` double(16,6) NOT NULL default '500.000000',
  `crystal_perhour` int(11) NOT NULL default '0',
  `crystal_max` bigint(20) NOT NULL default '100000',
  `deuterium` double(16,6) NOT NULL default '0.000000',
  `deuterium_perhour` int(11) NOT NULL default '0',
  `deuterium_max` bigint(20) NOT NULL default '100000',
  `energy_free` int(11) NOT NULL default '0',
  `energy_max` int(11) NOT NULL default '0',
  `metal_mine` int(11) NOT NULL default '0',
  `crystal_mine` int(11) NOT NULL default '0',
  `deuterium_sintetizer` int(11) NOT NULL default '0',
  `solar_plant` int(11) NOT NULL default '0',
  `fusion_plant` int(11) NOT NULL default '0',
  `robot_factory` int(11) NOT NULL default '0',
  `nano_factory` int(11) NOT NULL default '0',
  `hangar` int(11) NOT NULL default '0',
  `metal_store` int(11) NOT NULL default '0',
  `crystal_store` int(11) NOT NULL default '0',
  `deuterium_store` int(11) NOT NULL default '0',
  `laboratory` int(11) NOT NULL default '0',
  `terraformer` int(11) NOT NULL default '0',
  `ally_deposit` int(11) NOT NULL default '0',
  `silo` int(11) NOT NULL default '0',
  `small_ship_cargo` int(11) NOT NULL default '0',
  `big_ship_cargo` int(11) NOT NULL default '0',
  `light_hunter` int(11) NOT NULL default '0',
  `heavy_hunter` int(11) NOT NULL default '0',
  `crusher` int(11) NOT NULL default '0',
  `battle_ship` int(11) NOT NULL default '0',
  `colonizer` int(11) NOT NULL default '0',
  `recycler` int(11) NOT NULL default '0',
  `spy_sonde` int(11) NOT NULL default '0',
  `bomber_ship` int(11) NOT NULL default '0',
  `solar_satelit` int(11) NOT NULL default '0',
  `destructor` int(11) NOT NULL default '0',
  `dearth_star` int(11) NOT NULL default '0',
  `metalmine_porcent` int(11) NOT NULL default '0',
  `crystalmine_porcent` int(11) NOT NULL default '0',
  `deuterium_porcent` int(11) NOT NULL default '0',
  `solarplant_porcent` int(11) NOT NULL default '0',
  `fusion_porcent` int(11) NOT NULL default '0',
  `satelite_porcent` int(11) NOT NULL default '0',
  `misil_launcher` int(11) NOT NULL default '0',
  `small_laser` int(11) NOT NULL default '0',
  `big_laser` int(11) NOT NULL default '0',
  `gauss_canyon` int(11) NOT NULL default '0',
  `ionic_canyon` int(11) NOT NULL default '0',
  `buster_canyon` int(11) NOT NULL default '0',
  `small_protection_shield` int(11) NOT NULL default '0',
  `big_protection_shield` int(11) NOT NULL default '0',
  `interceptor_misil` int(11) NOT NULL default '0',
  `interplanetary_misil` int(11) NOT NULL default '0',
  `lunar_base` int(11) NOT NULL default '0',
  `sensor_phalax` int(11) NOT NULL default '0',
  `quantic_jump` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `resource` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(8) NOT NULL,
  `name` varchar(32) NOT NULL,
  `title` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(64) character set latin1 NOT NULL default '',
  `password` varchar(64) character set latin1 NOT NULL default '',
  `email` varchar(64) character set latin1 NOT NULL default '',
  `email_first` varchar(64) character set latin1 NOT NULL default '',
  `email_2` varchar(64) character set latin1 NOT NULL default '',
  `lang` char(8) character set latin1 NOT NULL default 'es',
  `authlevel` tinyint(4) NOT NULL default '0',
  `sex` char(1) character set latin1 default NULL,
  `avatar` char(255) character set latin1 NOT NULL default '',
  `sign` text character set latin1,
  `id_planet` int(11) NOT NULL default '0',
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `current_planet` int(11) NOT NULL default '0',
  `user_lastip` varchar(16) character set latin1 NOT NULL default '',
  `register_time` int(11) NOT NULL default '0',
  `onlinetime` int(11) NOT NULL default '0',
  `dpath` varchar(255) character set latin1 NOT NULL default '',
  `design` tinyint(4) NOT NULL default '1',
  `noipcheck` tinyint(4) NOT NULL default '1',
  `spio_anz` tinyint(4) NOT NULL default '1',
  `settings_tooltiptime` tinyint(4) NOT NULL default '5',
  `settings_fleetactions` tinyint(4) NOT NULL default '0',
  `settings_allylogo` tinyint(4) NOT NULL default '0',
  `settings_esp` tinyint(4) NOT NULL default '1',
  `settings_wri` tinyint(4) NOT NULL default '1',
  `settings_bud` tinyint(4) NOT NULL default '1',
  `settings_mis` tinyint(4) NOT NULL default '1',
  `settings_rep` tinyint(4) NOT NULL default '0',
  `urlaubs_modus` tinyint(4) NOT NULL default '0',
  `db_deaktjava` tinyint(4) NOT NULL default '0',
  `points` bigint(20) NOT NULL default '0',
  `new_message` int(11) NOT NULL default '0',
  `fleet_shortcut` text character set latin1,
  `b_tech_planet` int(11) NOT NULL default '0',
  `spy_tech` int(11) NOT NULL default '0',
  `computer_tech` int(11) NOT NULL default '0',
  `military_tech` int(11) NOT NULL default '0',
  `defence_tech` int(11) NOT NULL default '0',
  `shield_tech` int(11) NOT NULL default '0',
  `energy_tech` int(11) NOT NULL default '0',
  `hyperspace_tech` int(11) NOT NULL default '0',
  `combustion_tech` int(11) NOT NULL default '0',
  `impulse_motor_tech` int(11) NOT NULL default '0',
  `hyperspace_motor_tech` int(11) NOT NULL default '0',
  `laser_tech` int(11) NOT NULL default '0',
  `ionic_tech` int(11) NOT NULL default '0',
  `buster_tech` int(11) NOT NULL default '0',
  `intergalactic_tech` int(11) NOT NULL default '0',
  `graviton_tech` int(11) NOT NULL default '0',
  `ally_id` int(11) NOT NULL default '0',
  `ally_request` int(11) NOT NULL default '0',
  `ally_register_time` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `id_planet` (`id_planet`)
) ENGINE=MyISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci;

XeS · 9 Август 2007

Аз се предавам и така не става

Код:

 БД ogame  работи на localhost

Грешка

SQL-запитване : 

CREATE TABLE IF NOT EXISTS `alliance` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`ally_name` varchar( 32 ) default '',
`ally_tag` varchar( 8 ) default '',
`ally_owner` int( 11 ) NOT NULL default '0',
`ally_description` text,
`ally_web` varchar( 255 ) default '',
`ally_text` text,
`ally_image` varchar( 255 ) default '',
`ally_request` text,
`ally_request_notallow` tinyint( 4 ) NOT NULL default '0',
`ally_owner_range` varchar( 32 ) default '',
`ally_register_time` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` )
)ENGINE = MYISAM CHARSET cp1251 COLLATE cp1251_bulgarian_ci

MySQL отговори:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE cp1251_bulgarian_ci' at line 15

Cek0Ff · 9 Август 2007

Код:

-- --------------------------------------------------------

-- 
-- Структура таблици `alliance`
-- 

DROP TABLE IF EXISTS `alliance`;
CREATE TABLE IF NOT EXISTS `alliance` (
  `id` int(11) NOT NULL auto_increment,
  `ally_name` varchar(32) default '',
  `ally_tag` varchar(8) default '',
  `ally_owner` int(11) NOT NULL default '0',
  `ally_description` text,
  `ally_web` varchar(255) default '',
  `ally_text` text,
  `ally_image` varchar(255) default '',
  `ally_request` text,
  `ally_request_notallow` tinyint(4) NOT NULL default '0',
  `ally_owner_range` varchar(32) default '',
  `ally_register_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `buddy`
-- 

DROP TABLE IF EXISTS `buddy`;
CREATE TABLE IF NOT EXISTS `buddy` (
  `id` int(11) NOT NULL auto_increment,
  `sender` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `active` tinyint(3) NOT NULL default '0',
  `text` text,
  PRIMARY KEY  (`id`)
) ;

-- --------------------------------------------------------

-- 
-- Структура таблици `changelog`
-- 

DROP TABLE IF EXISTS `changelog`;
CREATE TABLE IF NOT EXISTS `changelog` (
  `id` int(11) NOT NULL auto_increment,
  `version` varchar(32) default NULL,
  `description` text,
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `fleets`
-- 

DROP TABLE IF EXISTS `fleets`;
CREATE TABLE IF NOT EXISTS `fleets` (
  `fleet_id` int(11) NOT NULL auto_increment,
  `fleet_owner` int(11) NOT NULL default '0',
  `fleet_mission` int(11) NOT NULL default '0',
  `fleet_amount` int(11) NOT NULL default '0',
  `fleet_array` text,
  `fleet_start_time` int(11) NOT NULL default '0',
  `fleet_start_galaxy` int(11) NOT NULL default '0',
  `fleet_start_system` int(11) NOT NULL default '0',
  `fleet_start_planet` int(11) NOT NULL default '0',
  `fleet_start_type` int(11) NOT NULL default '0',
  `fleet_end_time` int(11) NOT NULL default '0',
  `fleet_end_galaxy` int(11) NOT NULL default '0',
  `fleet_end_system` int(11) NOT NULL default '0',
  `fleet_end_planet` int(11) NOT NULL default '0',
  `fleet_end_type` int(11) NOT NULL default '0',
  `fleet_resource_metal` double(16,6) default NULL,
  `fleet_resource_crystal` double(16,6) default NULL,
  `fleet_resource_deuterium` double(16,6) default NULL,
  PRIMARY KEY  (`fleet_id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_cat`
-- 

DROP TABLE IF EXISTS `forum_cat`;
CREATE TABLE IF NOT EXISTS `forum_cat` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_categories`
-- 

DROP TABLE IF EXISTS `forum_categories`;
CREATE TABLE IF NOT EXISTS `forum_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_posts`
-- 

DROP TABLE IF EXISTS `forum_posts`;
CREATE TABLE IF NOT EXISTS `forum_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_posts_text`
-- 

DROP TABLE IF EXISTS `forum_posts_text`;
CREATE TABLE IF NOT EXISTS `forum_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `forum_topics`
-- 

DROP TABLE IF EXISTS `forum_topics`;
CREATE TABLE IF NOT EXISTS `forum_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) character set latin1 NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `galaxy`
-- 

DROP TABLE IF EXISTS `galaxy`;
CREATE TABLE IF NOT EXISTS `galaxy` (
`galaxy` int( 2 ) NOT NULL default '0',
`system` int( 3 ) NOT NULL default '0',
`planet` int( 2 ) NOT NULL default '0',
`id_planet` int( 11 ) NOT NULL default '0',
`metal` int( 11 ) NOT NULL default '0',
`crystal` int( 11 ) NOT NULL default '0',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `system` ( `system` ) ,
KEY `planet` ( `planet` ) ,
KEY `galaxy` ( `galaxy` )
);

-- --------------------------------------------------------

-- 
-- Структура таблици `messages`
-- 

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(11) NOT NULL auto_increment,
  `message_owner` int(11) NOT NULL default '0',
  `message_sender` int(11) NOT NULL default '0',
  `message_time` int(11) NOT NULL default '0',
  `message_type` int(11) NOT NULL default '0',
  `message_from` varchar(32) default NULL,
  `message_subject` varchar(32) default NULL,
  `message_text` text,
  PRIMARY KEY  (`message_id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `notes`
-- 

DROP TABLE IF EXISTS `notes`;
CREATE TABLE IF NOT EXISTS `notes` (
  `id` int(11) NOT NULL auto_increment,
  `owner` int(11) default NULL,
  `time` int(11) default NULL,
  `priority` tinyint(1) default NULL,
  `title` varchar(32) default NULL,
  `text` text,
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `planets`
-- 

DROP TABLE IF EXISTS `planets`;
CREATE TABLE IF NOT EXISTS `planets` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(255) character set latin1 default NULL,
  `id_owner` int(11) default NULL,
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `last_update` int(11) default NULL,
  `planet_type` int(11) NOT NULL default '1',
  `destruyed` int(11) NOT NULL default '0',
  `b_building` int(11) NOT NULL default '0',
  `b_building_id` int(11) NOT NULL default '0',
  `b_tech` int(11) NOT NULL default '0',
  `b_tech_id` int(11) NOT NULL default '0',
  `b_hangar` int(11) NOT NULL default '0',
  `b_hangar_id` text character set latin1 NOT NULL,
  `image` char(32) character set latin1 NOT NULL default 'normaltempplanet01',
  `diameter` int(11) NOT NULL default '12800',
  `field_current` int(11) NOT NULL default '0',
  `field_max` int(11) NOT NULL default '163',
  `temp_min` int(3) NOT NULL default '-17',
  `temp_max` int(3) NOT NULL default '23',
  `metal` double(16,6) NOT NULL default '500.000000',
  `metal_perhour` int(11) NOT NULL default '0',
  `metal_max` bigint(20) NOT NULL default '100000',
  `crystal` double(16,6) NOT NULL default '500.000000',
  `crystal_perhour` int(11) NOT NULL default '0',
  `crystal_max` bigint(20) NOT NULL default '100000',
  `deuterium` double(16,6) NOT NULL default '0.000000',
  `deuterium_perhour` int(11) NOT NULL default '0',
  `deuterium_max` bigint(20) NOT NULL default '100000',
  `energy_free` int(11) NOT NULL default '0',
  `energy_max` int(11) NOT NULL default '0',
  `metal_mine` int(11) NOT NULL default '0',
  `crystal_mine` int(11) NOT NULL default '0',
  `deuterium_sintetizer` int(11) NOT NULL default '0',
  `solar_plant` int(11) NOT NULL default '0',
  `fusion_plant` int(11) NOT NULL default '0',
  `robot_factory` int(11) NOT NULL default '0',
  `nano_factory` int(11) NOT NULL default '0',
  `hangar` int(11) NOT NULL default '0',
  `metal_store` int(11) NOT NULL default '0',
  `crystal_store` int(11) NOT NULL default '0',
  `deuterium_store` int(11) NOT NULL default '0',
  `laboratory` int(11) NOT NULL default '0',
  `terraformer` int(11) NOT NULL default '0',
  `ally_deposit` int(11) NOT NULL default '0',
  `silo` int(11) NOT NULL default '0',
  `small_ship_cargo` int(11) NOT NULL default '0',
  `big_ship_cargo` int(11) NOT NULL default '0',
  `light_hunter` int(11) NOT NULL default '0',
  `heavy_hunter` int(11) NOT NULL default '0',
  `crusher` int(11) NOT NULL default '0',
  `battle_ship` int(11) NOT NULL default '0',
  `colonizer` int(11) NOT NULL default '0',
  `recycler` int(11) NOT NULL default '0',
  `spy_sonde` int(11) NOT NULL default '0',
  `bomber_ship` int(11) NOT NULL default '0',
  `solar_satelit` int(11) NOT NULL default '0',
  `destructor` int(11) NOT NULL default '0',
  `dearth_star` int(11) NOT NULL default '0',
  `metalmine_porcent` int(11) NOT NULL default '0',
  `crystalmine_porcent` int(11) NOT NULL default '0',
  `deuterium_porcent` int(11) NOT NULL default '0',
  `solarplant_porcent` int(11) NOT NULL default '0',
  `fusion_porcent` int(11) NOT NULL default '0',
  `satelite_porcent` int(11) NOT NULL default '0',
  `misil_launcher` int(11) NOT NULL default '0',
  `small_laser` int(11) NOT NULL default '0',
  `big_laser` int(11) NOT NULL default '0',
  `gauss_canyon` int(11) NOT NULL default '0',
  `ionic_canyon` int(11) NOT NULL default '0',
  `buster_canyon` int(11) NOT NULL default '0',
  `small_protection_shield` int(11) NOT NULL default '0',
  `big_protection_shield` int(11) NOT NULL default '0',
  `interceptor_misil` int(11) NOT NULL default '0',
  `interplanetary_misil` int(11) NOT NULL default '0',
  `lunar_base` int(11) NOT NULL default '0',
  `sensor_phalax` int(11) NOT NULL default '0',
  `quantic_jump` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `resource`
-- 

DROP TABLE IF EXISTS `resource`;
CREATE TABLE IF NOT EXISTS `resource` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(8) NOT NULL,
  `name` varchar(32) NOT NULL,
  `title` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

-- 
-- Структура таблици `users`
-- 

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(64) character set latin1 NOT NULL default '',
  `password` varchar(64) character set latin1 NOT NULL default '',
  `email` varchar(64) character set latin1 NOT NULL default '',
  `email_first` varchar(64) character set latin1 NOT NULL default '',
  `email_2` varchar(64) character set latin1 NOT NULL default '',
  `lang` char(8) character set latin1 NOT NULL default 'es',
  `authlevel` tinyint(4) NOT NULL default '0',
  `sex` char(1) character set latin1 default NULL,
  `avatar` char(255) character set latin1 NOT NULL default '',
  `sign` text character set latin1,
  `id_planet` int(11) NOT NULL default '0',
  `galaxy` int(11) NOT NULL default '0',
  `system` int(11) NOT NULL default '0',
  `planet` int(11) NOT NULL default '0',
  `current_planet` int(11) NOT NULL default '0',
  `user_lastip` varchar(16) character set latin1 NOT NULL default '',
  `register_time` int(11) NOT NULL default '0',
  `onlinetime` int(11) NOT NULL default '0',
  `dpath` varchar(255) character set latin1 NOT NULL default '',
  `design` tinyint(4) NOT NULL default '1',
  `noipcheck` tinyint(4) NOT NULL default '1',
  `spio_anz` tinyint(4) NOT NULL default '1',
  `settings_tooltiptime` tinyint(4) NOT NULL default '5',
  `settings_fleetactions` tinyint(4) NOT NULL default '0',
  `settings_allylogo` tinyint(4) NOT NULL default '0',
  `settings_esp` tinyint(4) NOT NULL default '1',
  `settings_wri` tinyint(4) NOT NULL default '1',
  `settings_bud` tinyint(4) NOT NULL default '1',
  `settings_mis` tinyint(4) NOT NULL default '1',
  `settings_rep` tinyint(4) NOT NULL default '0',
  `urlaubs_modus` tinyint(4) NOT NULL default '0',
  `db_deaktjava` tinyint(4) NOT NULL default '0',
  `points` bigint(20) NOT NULL default '0',
  `new_message` int(11) NOT NULL default '0',
  `fleet_shortcut` text character set latin1,
  `b_tech_planet` int(11) NOT NULL default '0',
  `spy_tech` int(11) NOT NULL default '0',
  `computer_tech` int(11) NOT NULL default '0',
  `military_tech` int(11) NOT NULL default '0',
  `defence_tech` int(11) NOT NULL default '0',
  `shield_tech` int(11) NOT NULL default '0',
  `energy_tech` int(11) NOT NULL default '0',
  `hyperspace_tech` int(11) NOT NULL default '0',
  `combustion_tech` int(11) NOT NULL default '0',
  `impulse_motor_tech` int(11) NOT NULL default '0',
  `hyperspace_motor_tech` int(11) NOT NULL default '0',
  `laser_tech` int(11) NOT NULL default '0',
  `ionic_tech` int(11) NOT NULL default '0',
  `buster_tech` int(11) NOT NULL default '0',
  `intergalactic_tech` int(11) NOT NULL default '0',
  `graviton_tech` int(11) NOT NULL default '0',
  `ally_id` int(11) NOT NULL default '0',
  `ally_request` int(11) NOT NULL default '0',
  `ally_register_time` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `id_planet` (`id_planet`)
);

А така ?

XeS · 9 Август 2007

Сега пък дава това като грешка

Код:

 БД ogame  работи на localhost

Грешка

SQL-запитване : 

CREATE TABLE IF NOT EXISTS `planets` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` char( 255 ) CHARACTER SET latin1 default NULL ,
`id_owner` int( 11 ) default NULL ,
`galaxy` int( 11 ) NOT NULL default '0',
`system` int( 11 ) NOT NULL default '0',
`planet` int( 11 ) NOT NULL default '0',
`last_update` int( 11 ) default NULL ,
`planet_type` int( 11 ) NOT NULL default '1',
`destruyed` int( 11 ) NOT NULL default '0',
`b_building` int( 11 ) NOT NULL default '0',
`b_building_id` int( 11 ) NOT NULL default '0',
`b_tech` int( 11 ) NOT NULL default '0',
`b_tech_id` int( 11 ) NOT NULL default '0',
`b_hangar` int( 11 ) NOT NULL default '0',
`b_hangar_id` text CHARACTER SET latin1 NOT NULL ,
`image` char( 32 ) CHARACTER SET latin1 NOT NULL default 'normaltempplanet01',
`diameter` int( 11 ) NOT NULL default '12800',
`field_current` int( 11 ) NOT NULL default '0',
`field_max` int( 11 ) NOT NULL default '163',
`temp_min` int( 3 ) NOT NULL default '-17',
`temp_max` int( 3 ) NOT NULL default '23',
`metal` double( 16, 6 ) NOT NULL default '500.000000',
`metal_perhour` int( 11 ) NOT NULL default '0',
`metal_max` bigint( 20 ) NOT NULL default '100000',
`crystal` double( 16, 6 ) NOT NULL default '500.000000',
`crystal_perhour` int( 11 ) NOT NULL default '0',
`crystal_max` bigint( 20 ) NOT NULL default '100000',
`deuterium` double( 16, 6 ) NOT NULL default '0.000000',
`deuterium_perhour` int( 11 ) NOT NULL default '0',
`deuterium_max` bigint( 20 ) NOT NULL default '100000',
`energy_free` int( 11 ) NOT NULL default '0',
`energy_max` int( 11 ) NOT NULL default '0',
`metal_mine` int( 11 ) NOT NULL default '0',
`crystal_mine` int( 11 ) NOT NULL default '0',
`deuterium_sintetizer` int( 11 ) NOT NULL default '0',
`solar_plant` int( 11 ) NOT NULL default '0',
`fusion_plant` int( 11 ) NOT NULL default '0',
`robot_factory` int( 11 ) NOT NULL default '0',
`nano_factory` int( 11 ) NOT NULL default '0',
`hangar` int( 11 ) NOT NULL default '0',
`metal_store` int( 11 ) NOT NULL default '0',
`crystal_store` int( 11 ) NOT NULL default '0',
`deuterium_store` int( 11 ) NOT NULL default '0',
`laboratory` int( 11 ) NOT NULL default '0',
`terraformer` int( 11 ) NOT NULL default '0',
`ally_deposit` int( 11 ) NOT NULL default '0',
`silo` int( 11 ) NOT NULL default '0',
`small_ship_cargo` int( 11 ) NOT NULL default '0',
`big_ship_cargo` int( 11 ) NOT NULL default '0',
`light_hunter` int( 11 ) NOT NULL default '0',
`heavy_hunter` int( 11 ) NOT NULL default '0',
`crusher` int( 11 ) NOT NULL default '0',
`battle_ship` int( 11 ) NOT NULL default '0',
`colonizer` int( 11 ) NOT NULL default '0',
`recycler` int( 11 ) NOT NULL default '0',
`spy_sonde` int( 11 ) NOT NULL default '0',
`bomber_ship` int( 11 ) NOT NULL default '0',
`solar_satelit` int( 11 ) NOT NULL default '0',
`destructor` int( 11 ) NOT NULL default '0',
`dearth_star` int( 11 ) NOT NULL default '0',
`metalmine_porcent` int( 11 ) NOT NULL default '0',
`crystalmine_porcent` int( 11 ) NOT NULL default '0',
`deuterium_porcent` int( 11 ) NOT NULL default '0',
`solarplant_porcent` int( 11 ) NOT NULL default '0',
`fusion_porcent` int( 11 ) NOT NULL default '0',
`satelite_porcent` int( 11 ) NOT NULL default '0',
`misil_launcher` int( 11 ) NOT NULL default '0',
`small_laser` int( 11 ) NOT NULL default '0',
`big_laser` int( 11 ) NOT NULL default '0',
`gauss_canyon` int( 11 ) NOT NULL default '0',
`ionic_canyon` int( 11 ) NOT NULL default '0',
`buster_canyon` int( 11 ) NOT NULL default '0',
`small_protection_shield` int( 11 ) NOT NULL default '0',
`big_protection_shield` int( 11 ) NOT NULL default '0',
`interceptor_misil` int( 11 ) NOT NULL default '0',
`interplanetary_misil` int( 11 ) NOT NULL default '0',
`lunar_base` int( 11 ) NOT NULL default '0',
`sensor_phalax` int( 11 ) NOT NULL default '0',
`quantic_jump` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` )
)

MySQL отговори:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set latin1 NOT NULL,
  `image` char(32) character se

XeS · 9 Август 2007

Освен да махна навсякаде кадето има latin1 понеже тях ми ги дава в черно или де да знам малко съм зле с SQL

За сега лека нощ от мен, че утре съм на работа и незнам как ще ставам пък довечера пак ще го мъча този SQL

Помощ за SQL език

XeS

Registered

miro_94

Registered

XeS

Registered

miro_94

Registered

XeS

Registered

miro_94

Registered

XeS

Registered

miro_94

Registered

XeS

Registered

Cek0Ff

Registered

XeS

Registered

XeS

Registered