Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.41 KB | None | 0 0
  1. CREATE TABLE `codigo_barras_local` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `codigo_produto` int(11) DEFAULT NULL,
  4.   `codigo_ean` varchar(20) DEFAULT NULL,
  5.   PRIMARY KEY (`id`) USING BTREE,
  6.   KEY `ligacao` (`codigo_produto`),
  7.   CONSTRAINT `ligacao` FOREIGN KEY (`codigo_produto`) REFERENCES `produtos` (`COD_INTERNO`) ON DELETE CASCADE ON UPDATE CASCADE
  8. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement