--disable_warnings drop database if exists bug26080; create database bug26080; --enable_warnings use bug26080; CREATE TABLE `fisa_cont` ( `id_fisa_cont` bigint(20) NOT NULL AUTO_INCREMENT, `data` datetime DEFAULT '0000-00-00 00:00:00', `numar` varchar(100) DEFAULT '', `suma` double(19,7) DEFAULT '0.0000000', `din_care` double(19,7) DEFAULT '0.0000000', `suma_achitata` double(19,7) DEFAULT '0.0000000', `termen` datetime DEFAULT '0000-00-00 00:00:00', `data_inchidere` datetime DEFAULT '0000-00-00 00:00:00', `zile` mediumint(5) DEFAULT '0', `id_client` bigint(20) DEFAULT '-1', `reserved` varchar(100) DEFAULT '', `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `id_factura` bigint(20) DEFAULT '-1', `id_factura_plata` bigint(20) DEFAULT '-1', `banca` varchar(3) DEFAULT '', `curs` float(9,3) DEFAULT '0.000', `fise_casare` varchar(5000) DEFAULT '', PRIMARY KEY (`id_fisa_cont`), UNIQUE KEY `id_fisa_cont` (`id_fisa_cont`), KEY `data` (`data`), KEY `id_client` (`id_client`), KEY `reserved` (`reserved`) ) ENGINE=MEMORY DEFAULT CHARSET=latin1; insert into fisa_cont(data, numar, suma, din_care, suma_achitata, termen, data_inchidere, zile, id_client, reserved, id_factura, id_factura_plata, banca, curs, fise_casare) values(now(), '99123499', 1000, 1000, 0, now(), now(), 0, -1, '00003root#192.168.0.3', -1, -1, 'BNC', 2.5, ''); select suma from fisa_cont; alter table fisa_cont modify column numar varchar(150) default ''; select suma from fisa_cont; --disable_warnings drop database bug26080; --enable_warnings