-- Create the client snapshot data store table.
CREATE TABLE IF NOT EXISTS `mod_invoicedata` (
    `invoiceid` INT( 10)NOT NULL ,
    `clientsdetails` TEXT NOT NULL COLLATE utf8_unicode_ci,
    `customfields` TEXT NOT NULL COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;