Advertisement
Guest User

Untitled

a guest
Sep 24th, 2015
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. --
  2. -- Estrutura da tabela `tblbundles`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `tblbundles` (
  6. `id` int(10) NOT NULL AUTO_INCREMENT,
  7. `name` text NOT NULL,
  8. `validfrom` date NOT NULL,
  9. `validuntil` date NOT NULL,
  10. `uses` int(4) NOT NULL,
  11. `maxuses` int(4) NOT NULL,
  12. `itemdata` text NOT NULL,
  13. `allowpromo` int(1) NOT NULL,
  14. `showgroup` int(1) NOT NULL,
  15. `gid` int(10) NOT NULL,
  16. `description` text NOT NULL,
  17. `displayprice` decimal(10,2) NOT NULL,
  18. `sortorder` int(3) NOT NULL,
  19. `is_featured` tinyint(1) NOT NULL,
  20. PRIMARY KEY (`id`)
  21. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement