Skip to content

Instantly share code, notes, and snippets.

@patrickacioli

patrickacioli/gist:fead6da72ab6c657b56dd8e81b186bd0

Created April 13, 2020 14:00
Show Gist options
  • Save patrickacioli/fead6da72ab6c657b56dd8e81b186bd0 to your computer and use it in GitHub Desktop.
Save patrickacioli/fead6da72ab6c657b56dd8e81b186bd0 to your computer and use it in GitHub Desktop.
Download ZIP
ingram_tables
Raw
gistfile1.txt
CREATE TABLE `crawler_ingram_all` (
`id` int(11) NOT NULL,
`nome_produto` varchar(255) NOT NULL,
`sku` varchar(50) NOT NULL,
`pn` varchar(50) NOT NULL,
`ean` varchar(50) NOT NULL,
`estoque_sp` int(11) NOT NULL,
`estoque_esi` int(11) NOT NULL,
`estoque_esii` int(11) NOT NULL,
`preco_sp` varchar(10) NOT NULL,
`preco_esi` varchar(10) NOT NULL,
`preco_esii` varchar(10) NOT NULL,
`status_sp` varchar(50) NOT NULL,
`status_esi` varchar(50) NOT NULL,
`status_esii` varchar(50) NOT NULL,
`url` varchar(255) NOT NULL,
`update_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Estrutura para tabela `products_partial`
--
CREATE TABLE `crawler_ingram_partial` (
`id` int(11) NOT NULL,
`nome_produto` varchar(255) NOT NULL,
`sku` varchar(50) NOT NULL,
`pn` varchar(50) NOT NULL,
`ean` varchar(50) NOT NULL,
`estoque_sp` int(11) NOT NULL,
`estoque_esi` int(11) NOT NULL,
`estoque_esii` int(11) NOT NULL,
`preco_sp` varchar(10) NOT NULL,
`preco_esi` varchar(10) NOT NULL,
`preco_esii` varchar(10) NOT NULL,
`status_sp` varchar(20) NOT NULL,
`status_esi` varchar(20) NOT NULL,
`status_esii` varchar(20) NOT NULL,
`url` varchar(255) NOT NULL,
`update_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment