|
Тема |
Re: MySQL Cluster ??? [re: salle] |
|
Автор | Menta2K (Нерегистриран) | |
Публикувано | 19.01.06 20:13 |
|
|
импортнах го от dump от друг server като след което промених ENGINE-а в dump-a
.....
CREATE TABLE `bank_returns` (
`id` int(10) unsigned NOT NULL auto_increment,
`batch_id` int(11) NOT NULL default '0',
`user_type` tinyint(4) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`direction` tinyint(4) NOT NULL default '0',
`amount` varchar(20) NOT NULL default '',
`return_code` varchar(5) NOT NULL default '',
`return_date` datetime NOT NULL default '0000-00-00 00:00:00',
`batch_date` datetime NOT NULL default '0000-00-00 00:00:00',
`prop_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) engine=ndbcluster;
.......
"192.168.2.2 - таблиците изгубиха auto_increment-а"
дефинициата на колоната
mysql> describe bank_returns;
+-------------+------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------------------+-------+
| id | int(10) unsigned | | PRI | 0 | |
| batch_id | int(11) | | | 0 | |
| user_type | tinyint(4) | | | 0 | |
| user_id | int(11) | | | 0 | |
| direction | tinyint(4) | | | 0 | |
| amount | varchar(20) | | | | |
| return_code | varchar(5) | | | | |
| return_date | datetime | | | 0000-00-00 00:00:00 | |
| batch_date | datetime | | | 0000-00-00 00:00:00 | |
| prop_id | int(11) | | | 0 | |
+-------------+------------------+------+-----+---------------------+-------+
"192.168.2.3 - всичко си стана като хората"
mysql> describe bank_returns;
+-------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| batch_id | int(11) | | | 0 | |
| user_type | tinyint(4) | | | 0 | |
| user_id | int(11) | | | 0 | |
| direction | tinyint(4) | | | 0 | |
| amount | varchar(20) | | | | |
| return_code | varchar(5) | | | | |
| return_date | datetime | | | 0000-00-00 00:00:00 | |
| batch_date | datetime | | | 0000-00-00 00:00:00 | |
| prop_id | int(11) | | | 0 | |
+-------------+------------------+------+-----+---------------------+----------------+
|
| |
|
|
|