Advertisement
Guest User

Untitled

a guest
May 4th, 2015
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `board` (
  2. `id` int(11) auto_increment,
  3. `id_user` int(11) NOT NULL,
  4. `cat` int(11) NOT NULL,
  5. `podcat` int(11) NOT NULL,
  6. `name` varchar(250) NOT NULL,
  7. `name_translate` varchar(500) NOT NULL,
  8. `file` varchar(50) NOT NULL,
  9. `foto` varchar(50) NOT NULL,
  10. `fotka` varchar(50) NOT NULL,
  11. `screen` varchar(50) NOT NULL,
  12. `size` varchar(50) NOT NULL,
  13. `size_convert` varchar(50) NOT NULL,
  14. `price` varchar(11) NOT NULL,
  15. `telefon` varchar(13) NOT NULL,
  16. `email` varchar(32) NOT NULL,
  17. `contact` varchar(32) NOT NULL,
  18. `send` int(1) NOT NULL default '0',
  19. `city` varchar(32) NOT NULL,
  20. `skype` varchar(32) NOT NULL,
  21. `time` int(11) NOT NULL,
  22. `timeupdate` int(11) NOT NULL,
  23. `timesrok` int(11) NOT NULL,
  24. `top` int(1) NOT NULL default '0',
  25. `toptime` int(11) NOT NULL,
  26. `srochno` int(1) NOT NULL default '0',
  27. `timesrochno` int(11) NOT NULL,
  28. `vydelit` int(1) NOT NULL default '0',
  29. `timevydelit` int(11) NOT NULL,
  30. `torg` int(1) NOT NULL default '0',
  31. `by` int(1) NOT NULL default '0',
  32. `free` int(1) NOT NULL default '0',
  33. `status` int(1) NOT NULL default '2',
  34. `convert` int(1) NOT NULL default '2',
  35. `type` int(1) NOT NULL default '0',
  36. `activation` int(1) NOT NULL default '0',
  37. `count` int(11) NOT NULL default '0',
  38. `text` varchar(5000) NOT NULL,
  39. `prosmotrov` int(11) NOT NULL,
  40. `lat` varchar(11) NOT NULL,
  41. `lng` varchar(11) NOT NULL,
  42. `watermark` int(1) NOT NULL default '0',
  43. PRIMARY KEY (`id`)
  44. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
  45.  
  46. --
  47. -- Структура таблицы `cat`
  48. --
  49. DROP TABLE IF EXISTS `cat`;
  50. CREATE TABLE IF NOT EXISTS `cat` (
  51. `id` int(11) auto_increment,
  52. `ref` int(11) NOT NULL,
  53. `realid` int(11) NOT NULL,
  54. `name` varchar(500) NOT NULL,
  55. `translate` varchar(500) NOT NULL,
  56. `keywords` varchar(5000) NOT NULL,
  57. `logo` varchar(50) NOT NULL,
  58. PRIMARY KEY (`id`)
  59. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement