Skip to content

Instantly share code, notes, and snippets.

@eniolopes
Created November 26, 2010 18:52
Show Gist options
  • Save eniolopes/717087 to your computer and use it in GitHub Desktop.
Save eniolopes/717087 to your computer and use it in GitHub Desktop.
CREATE TABLE IF NOT EXISTS `ofertas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_parceiros` int(11) NOT NULL,
`data_inicio` datetime NOT NULL,
`data_termino` datetime NOT NULL,
`titulo` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`destaques` text NOT NULL,
`regulamento` text NOT NULL,
`apresentacao` text NOT NULL,
`qtd_vendidos` int(4) DEFAULT NULL,
`qtd_vendidos_fake` int(4) DEFAULT NULL,
`qtd_tickets_permitidos` int(4) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id_parceiros` (`id_parceiros`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment