_________________________________________________________________________________________________
CREATE TABLE sa2.transaction (
  TransactionID bigint(12) NOT NULL AUTO_INCREMENT,
  MerchantID int(8) NOT NULL DEFAULT 0,
  SalesLocationID int(8) NOT NULL DEFAULT 0,
  TerminalID varchar(24) binary NOT NULL DEFAULT '',
  TerminalModelID smallint(4) NOT NULL DEFAULT 0,
  ApplicationNamespaceID varchar(32) binary NOT NULL DEFAULT '',
  TransactionTypeID varchar(8) binary NOT NULL DEFAULT '',
  OriginalTransactionID bigint(12) NOT NULL DEFAULT 0,
  ReversalTransactionID bigint(12) NOT NULL DEFAULT 0,
  SettleTransactionID bigint(12) NOT NULL DEFAULT 0,
  AuthorizationHostID smallint(4) NOT NULL DEFAULT 0,
  ClearingHostID smallint(4) NOT NULL DEFAULT 0,
  CardGroupID smallint(4) NOT NULL DEFAULT 0,
  CurrencyID smallint(4) NOT NULL DEFAULT 0,
  MerchantIdentity varchar(32) binary NOT NULL DEFAULT '',
  ClearingHour tinyint(2) NOT NULL DEFAULT - 1,
  ClearingBatchKey varchar(64) binary NOT NULL DEFAULT '',
  Online tinyint(2) NOT NULL DEFAULT 0,
  Confirmed tinyint(2) NOT NULL DEFAULT 0,
  Cleared tinyint(2) NOT NULL DEFAULT 0,
  TransactionDateTime datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  Amount bigint(12) NOT NULL DEFAULT 0,
  ResponseCode char(2) binary NOT NULL DEFAULT '',
  CashierIdentity varchar(6) binary NOT NULL DEFAULT '',
  ReceiptNo varchar(32) binary NOT NULL DEFAULT '',
  TerminalRRN bigint(12) NOT NULL DEFAULT 0,
  PANHash char(64) binary NOT NULL DEFAULT '',
  PANSuffix smallint(4) NOT NULL DEFAULT - 1,
  PRIMARY KEY (TransactionID),
  INDEX ClearingHostID_ClearingHour_Cleared_SettleTransactionID (ClearingHostID, ClearingHour, Cleared, SettleTransactionID),
  INDEX MerchantID_SettleTransactionID_TerminalID_TerminalModelID (MerchantID, SettleTransactionID, TerminalID, TerminalModelID),
  INDEX MerchantID_TerminalID_TerminalModelID_ReceiptNo_Amount (MerchantID, TerminalID, TerminalModelID, ReceiptNo, Amount),
  INDEX MerchantID_TerminalID_TerminalModelID_TransactionDateTime (MerchantID, TerminalID, TerminalModelID, TransactionDateTime),
  INDEX MerchantID_TransactionDateTime (MerchantID, TransactionDateTime),
  INDEX OriginalTransactionID (OriginalTransactionID),
  INDEX PANHash_MerchantID (PANHash, MerchantID),
  INDEX ResponseCode_TransactionDateTime (ResponseCode, TransactionDateTime),
  INDEX TransactionDateTime (TransactionDateTime)
)
ENGINE = INNODB
AUTO_INCREMENT = 300347742933
AVG_ROW_LENGTH = 299
CHARACTER SET latin1
COLLATE latin1_bin;
_________________________________________________________________________________________________
Insert SQL (pseudo-code):

string inserttransactionsql = "INSERT INTO transaction SET";
inserttransactionsql += "fields and values are added here"......
inserttransactionsql += "; SELECT LAST_INSERT_ID();";
_________________________________________________________________________________________________

Error generated in client:
[14-11-16 00:51:31.91] Information: InsertTransaction (ln239): MySql.Data.MySqlClient.MySqlException Duplicate entry '300346539473' for key 'PRIMARY'