1.1.7.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233
  1. CREATE TABLE IF NOT EXISTS `ins_homereq` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `date` datetime NOT NULL,
  4. `login` varchar(64) DEFAULT NULL,
  5. `address` varchar(200) NOT NULL,
  6. `realname` varchar(200) NOT NULL,
  7. `mobile` varchar(64) NOT NULL,
  8. `email` varchar(64) NOT NULL,
  9. `state` tinyint(1) NOT NULL,
  10. PRIMARY KEY (`id`)
  11. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  12. CREATE TABLE IF NOT EXISTS `youtv_subscribers` (
  13. `id` int(11) NOT NULL AUTO_INCREMENT,
  14. `date` datetime NOT NULL,
  15. `active` tinyint(1) DEFAULT NULL,
  16. `subscriberid` int(11) NOT NULL,
  17. `login` varchar(64) NOT NULL,
  18. `maintariff` int(11) DEFAULT NULL,
  19. `addtariffs` varchar(255) DEFAULT NULL,
  20. PRIMARY KEY (`id`)
  21. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
  22. CREATE TABLE IF NOT EXISTS `youtv_tariffs` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT,
  24. `serviceid` int(11) NOT NULL,
  25. `main` tinyint(1) NOT NULL,
  26. `name` varchar(64) NOT NULL,
  27. `chans` varchar(42) DEFAULT NULL,
  28. `fee` double NOT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;