Код: Выделить всё
CREATE TABLE `tbl_transactions` (
`id` int(11) NOT NULL,
`post_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`booking_date` date DEFAULT NULL,
`operation_id` bigint(20) UNSIGNED DEFAULT NULL,
`debit_account_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Account id',
`credit_account_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Account id',
`originator_id` bigint(20) DEFAULT NULL COMMENT 'Originator ID',
`amount` decimal(16,4) DEFAULT '0.0000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;