Duplicate row
Values from autoinc and auto timestamp gets copyed to new row.
You can imagine that then insert does not work. There is also then no way to empty(remove from insert) copyed auto timestamp
value.
To remind, I still think that at duplicate row all values should be copyed to new row (with exception of upper cases). Now keyed walues are not copyed. Imagine one have key on 5 fields and has to copy 4 of them manualy just to make new record.
ref table:
CREATE TABLE `tezaver_zunanji_spiski_detail_sources` (
`id_master` INT(10) UNSIGNED NOT NULL,
`term` VARCHAR(100) NOT NULL DEFAULT ' ' COMMENT 'zgolj podsetnik za update id_tezavra' COLLATE 'utf8_slovenian_ci',
`op` TEXT NULL COLLATE 'utf8_slovenian_ci',
`source` VARCHAR(400) NULL DEFAULT NULL COMMENT 'če je več sourcov ' COLLATE 'utf8_slovenian_ci',
`source_sha1` VARCHAR(50) NOT NULL DEFAULT ' ' COLLATE 'utf8_slovenian_ci',
`DSP` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`sources_record_id` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id_master`, `term`, `source_sha1`),
UNIQUE INDEX `auto` (`sources_record_id`)
)
COMMENT='viri za trditev, da ta in ta obstaja v tem in tem id_master'
COLLATE='utf8_slovenian_ci'
ENGINE=MyISAM
AUTO_INCREMENT=78680
;