-CREATE TABLE `bank` (
- `bank_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `bank_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `bank_from` varchar(23) COLLATE utf8_czech_ci NOT NULL,
- `bank_to` varchar(23) COLLATE utf8_czech_ci NOT NULL,
- `bank_amount` int(11) NOT NULL,
- `bank_author` int(11) NOT NULL,
- `bank_comment` varchar(128) COLLATE utf8_czech_ci NOT NULL,
- PRIMARY KEY (`bank_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+CREATE TABLE `transaction` (
+ `transaction_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `transaction_time` datetime NOT NULL,
+ `transaction_from` varchar(23) COLLATE utf8_czech_ci NOT NULL,
+ `transaction_to` varchar(23) COLLATE utf8_czech_ci NOT NULL,
+ `transaction_amount` int(11) NOT NULL,
+ `transaction_author` int(11) NOT NULL,
+ `transaction_comment` varchar(128) COLLATE utf8_czech_ci NOT NULL,
+ PRIMARY KEY (`transaction_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;