Привет еще раз всем
При импорте базы выходит ошибка вида
SQL query:
CREATE TABLE `dv_log_intervals` (
`interval_id` smallint( 6 ) unsigned NOT NULL default '0',
`sent` int( 11 ) unsigned NOT NULL default '0',
`recv` int( 11 ) unsigned NOT NULL default '0',
`duration` int( 11 ) unsigned NOT NULL default '0',
`traffic_type` tinyint( 4 ) unsigned NOT NULL default '0',
`sum` double( 14, 6 ) unsigned NOT NULL default '0.000000',
`acct_session_id` varchar( 25 ) NOT NULL default '',
`added` timestamp( 14 ) NOT NULL ,
KEY `acct_session_id` ( `acct_session_id` ) ,
KEY `session_interval` ( `acct_session_id` , `interval_id` )
);
MySQL said: Documentation
#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 '(14) NOT NULL,
KEY `acct_session_id` (`acct_session_id`),
KEY `session_inter' at line 9
ЧТо делать подскажите плз
MYSQL 5.5 проблема импорта
-
- Site Admin
- Сообщения: 5749
- Зарегистрирован: Пт янв 28, 2005 3:11 pm
- Контактная информация:
Re: MYSQL 5.5 проблема импорта
CREATE TABLE `dv_log_intervals` (
`interval_id` smallint(6) unsigned NOT NULL default '0',
`sent` int(11) unsigned NOT NULL default '0',
`recv` int(11) unsigned NOT NULL default '0',
`duration` int(11) unsigned NOT NULL default '0',
`traffic_type` tinyint(4) unsigned NOT NULL default '0',
`sum` double(14,6) unsigned NOT NULL default '0.000000',
`acct_session_id` varchar(25) NOT NULL default '',
`added` timestamp NOT NULL,
KEY `acct_session_id` (`acct_session_id`),
KEY `session_interval` (`acct_session_id`,`interval_id`)
) ;
`interval_id` smallint(6) unsigned NOT NULL default '0',
`sent` int(11) unsigned NOT NULL default '0',
`recv` int(11) unsigned NOT NULL default '0',
`duration` int(11) unsigned NOT NULL default '0',
`traffic_type` tinyint(4) unsigned NOT NULL default '0',
`sum` double(14,6) unsigned NOT NULL default '0.000000',
`acct_session_id` varchar(25) NOT NULL default '',
`added` timestamp NOT NULL,
KEY `acct_session_id` (`acct_session_id`),
KEY `session_interval` (`acct_session_id`,`interval_id`)
) ;
Re: MYSQL 5.5 проблема импорта
Спасибо заработало