Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE cliente (
- `id` int(11) NOT NULL,
- `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- INSERT INTO cliente VALUES(1, 'Coca-Cola');
- INSERT INTO cliente VALUES(3, 'IBM');
- INSERT INTO cliente VALUES(4, 'Logitech');
- INSERT INTO cliente VALUES(2, 'Toyota');
- CREATE TABLE pago (
- `id` int(11) NOT NULL,
- `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `monto` decimal(10,0) NOT NULL,
- `cliente_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- INSERT INTO pago VALUES(1, '2017-01-23 09:40:08', '100', 1);
- INSERT INTO pago VALUES(2, '2017-01-23 09:40:08', '300', 3);
- INSERT INTO pago VALUES(3, '2017-01-23 09:40:08', '400', 4);
- INSERT INTO pago VALUES(4, '2017-01-23 09:40:08', '200', 2);
- INSERT INTO pago VALUES(8, '2017-01-23 09:40:10', '50', 1);
- INSERT INTO pago VALUES(9, '2017-01-23 09:40:10', '150', 3);
- INSERT INTO pago VALUES(10, '2017-01-23 09:40:10', '200', 4);
- INSERT INTO pago VALUES(11, '2017-01-23 09:40:10', '100', 2);
- ALTER TABLE cliente
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `cliente_unq_name` (`name`);
- ALTER TABLE pago
- ADD PRIMARY KEY (`id`),
- ADD KEY `cliente_id` (`cliente_id`);
- ALTER TABLE cliente
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- ALTER TABLE pago
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
- ALTER TABLE pago
- ADD CONSTRAINT `pago_ibfk_1` FOREIGN KEY (`cliente_id`) REFERENCES `cliente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Add Comment
Please, Sign In to add comment