CREATE TABLE `acc_look` (
  `id` varchar(23) NOT NULL COMMENT 'usar la funcan microtime() de php para 0btener los ultimos 10 digitosn18 = 201601251234567890,date(''YmdHjs'').microtime()n5 =  ''rand_string''',
  `accounting_account_id` varchar(32) NOT NULL,
  `balance_from` double NOT NULL DEFAULT 0,
  `balance` double NOT NULL DEFAULT 0,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `currency` varchar(15) NOT NULL DEFAULT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='esta tabla almacena el registro de movimientos';