Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `direct_debit` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `validfrom` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `isactive` INT(2) DEFAULT '0',
- `id_card` BIGINT(20) NOT NULL,
- `rum` VARCHAR(20) COLLATE utf8_bin NOT NULL,
- `bic` VARCHAR(20) COLLATE utf8_bin NOT NULL,
- `iban` VARCHAR(50) COLLATE utf8_bin NOT NULL,
- `isfirst` INT(11) DEFAULT '1',
- PRIMARY KEY (`id`),
- UNIQUE KEY `idx_dd_idcard` (`id_card`),
- KEY `id_card` (`id_card`)
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- CREATE TABLE `direct_debit_data` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `cle` VARCHAR(20) COLLATE utf8_bin DEFAULT NULL,
- `valeur` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- INSERT INTO `direct_debit_data` VALUES (1,'lastref','14000'),(2,'lastdaterun','2014-11-05');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement