Просмотр файла znak/sql.sql

Размер файла: 1.8Kb
  1. CREATE TABLE `users` (
  2. `id` int(10) NOT NULL auto_increment,
  3. `login` varchar(30) NOT NULL,
  4. `pass` varchar(30) NOT NULL,
  5. `status` text NOT NULL,
  6. `name` varchar(50) NOT NULL,
  7. `sex` set('0','1') NOT NULL default '0',
  8. `position` int(3) NOT NULL,
  9. `city` varchar(50) NOT NULL,
  10. `about` text NOT NULL,
  11. `interests` text NOT NULL,
  12. `reg_time` int(10) NOT NULL,
  13. `online_time` int(10) NOT NULL,
  14. `plus` int(5) NOT NULL,
  15. `minus` int(5) NOT NULL,
  16. `icq` int(10) NOT NULL,
  17. `money` int(3) NOT NULL,
  18. `level` int(3) NOT NULL default '0',
  19. PRIMARY KEY (`id`)
  20. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7;
  21.  
  22. CREATE TABLE `reclam` (
  23. `id` int(11) NOT NULL auto_increment,
  24. `rid` int(10) NOT NULL,
  25. `link` varchar(30) NOT NULL,
  26. `title` varchar(30) NOT NULL,
  27. PRIMARY KEY (`id`)
  28. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  29.  
  30. CREATE TABLE `feedback` (
  31. `id` int(11) NOT NULL auto_increment,
  32. `fid` int(10) NOT NULL,
  33. `login` varchar(30) NOT NULL,
  34. `mess` varchar(200) NOT NULL,
  35. `time` int(10) NOT NULL,
  36. PRIMARY KEY (`id`)
  37. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  38.  
  39. CREATE TABLE `news` (
  40. `nid` int(10) NOT NULL auto_increment,
  41. `news` text NOT NULL,
  42. `author` varchar(20) NOT NULL,
  43. `time` int(10) NOT NULL,
  44. PRIMARY KEY (`nid`)
  45. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
  46.  
  47. CREATE TABLE `mail` (
  48. `id` int(11) NOT NULL auto_increment,
  49. `uid` int(10) NOT NULL,
  50. `mail_from` text NOT NULL,
  51. `mail_for` text NOT NULL,
  52. `mess` text NOT NULL,
  53. `time` int(11) NOT NULL,
  54. `status` set('1','2') NOT NULL,
  55. PRIMARY KEY (`id`)
  56. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  57.  
  58. CREATE TABLE `adv` (
  59. `id` int(11) NOT NULL auto_increment,
  60. `title` varchar(30) NOT NULL,
  61. `text` text NOT NULL,
  62. `author` varchar(15) NOT NULL,
  63. `time` int(10) NOT NULL,
  64. PRIMARY KEY (`id`)
  65. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;