Witam, szukam programu, którym mogłabym skonwertować kod SQL w diagram encji, żeby wyglądały czytelnie tabele i powiązania pomiędzy nimi oto kod:

  1. CREATE DATABASE `baza` DEFAULT CHARACTER SET latin2 COLLATE latin2_general_ci;
  2. USE `baza`;
  3.  
  4. -- --------------------------------------------------------
  5.  
  6. --
  7. -- Struktura tabeli dla `tbl_bulletin`
  8. --
  9.  
  10. CREATE TABLE `tbl_bulletin` (
  11. `bid` int(4) NOT NULL AUTO_INCREMENT,
  12. `u_id` int(4) NOT NULL DEFAULT '0',
  13. `utime` int(4) NOT NULL DEFAULT '0',
  14. `publish` int(4) NOT NULL DEFAULT '0',
  15. `mesg` text NOT NULL,
  16. PRIMARY KEY (`bid`)
  17. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
  18.  
  19. -- --------------------------------------------------------
  20.  
  21. --
  22. -- Struktura tabeli dla `tbl_cache`
  23. --
  24.  
  25. CREATE TABLE `tbl_cache` (
  26. `cacheid` int(4) NOT NULL AUTO_INCREMENT,
  27. `id` int(4) NOT NULL DEFAULT '0',
  28. `value` text NOT NULL,
  29. PRIMARY KEY (`cacheid`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=4 ;
  31.  
  32. -- --------------------------------------------------------
  33.  
  34. --
  35. -- Struktura tabeli dla `tbl_config`
  36. --
  37.  
  38. CREATE TABLE `tbl_config` (
  39. `id` int(4) NOT NULL AUTO_INCREMENT,
  40. `key` varchar(255) NOT NULL DEFAULT '',
  41. `value` text NOT NULL,
  42. `vtype` int(2) NOT NULL DEFAULT '0',
  43. UNIQUE KEY `id` (`id`,`key`),
  44. KEY `key` (`key`)
  45. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=53 ;
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Struktura tabeli dla `tbl_filetypes`
  51. --
  52.  
  53. CREATE TABLE `tbl_filetypes` (
  54. `id` int(4) NOT NULL AUTO_INCREMENT,
  55. `extension` varchar(32) NOT NULL DEFAULT '',
  56. `mime` varchar(128) NOT NULL DEFAULT '',
  57. `m3u` char(1) NOT NULL DEFAULT '',
  58. `getid` int(4) NOT NULL DEFAULT '0',
  59. `search` char(1) NOT NULL DEFAULT '1',
  60. `logaccess` char(1) NOT NULL DEFAULT '1',
  61. `enabled` char(1) NOT NULL DEFAULT '1',
  62. PRIMARY KEY (`id`)
  63. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
  64.  
  65. -- --------------------------------------------------------
  66.  
  67. --
  68. -- Struktura tabeli dla `tbl_kplayversion`
  69. --
  70.  
  71. CREATE TABLE `tbl_kplayversion` (
  72. `app_ver` varchar(6) NOT NULL DEFAULT '',
  73. `app_build` varchar(6) NOT NULL DEFAULT '',
  74. `app_finstall` int(4) NOT NULL DEFAULT '0'
  75. ) ENGINE=MyISAM DEFAULT CHARSET=latin2;
  76.  
  77. -- --------------------------------------------------------
  78.  
  79. --
  80. -- Struktura tabeli dla `tbl_mhistory`
  81. --
  82.  
  83. CREATE TABLE `tbl_mhistory` (
  84. `h_id` int(4) NOT NULL AUTO_INCREMENT,
  85. `u_id` int(4) NOT NULL DEFAULT '0',
  86. `s_id` int(4) NOT NULL DEFAULT '0',
  87. `tid` tinyint(4) NOT NULL DEFAULT '0',
  88. `utime` int(4) NOT NULL DEFAULT '0',
  89. `dwritten` int(4) NOT NULL DEFAULT '0',
  90. `dpercent` int(4) NOT NULL DEFAULT '0',
  91. `active` tinyint(4) NOT NULL DEFAULT '0',
  92. `mid` int(4) NOT NULL DEFAULT '0',
  93. PRIMARY KEY (`h_id`),
  94. KEY `s_id` (`s_id`),
  95. KEY `u_id` (`u_id`),
  96. KEY `utime` (`utime`)
  97. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=383 ;
  98.  
  99. -- --------------------------------------------------------
  100.  
  101. --
  102. -- Struktura tabeli dla `tbl_playlist`
  103. --
  104.  
  105. CREATE TABLE `tbl_playlist` (
  106. `u_id` int(4) NOT NULL DEFAULT '0',
  107. `name` varchar(32) NOT NULL DEFAULT '',
  108. `public` char(1) NOT NULL DEFAULT '0',
  109. `status` tinyint(1) NOT NULL DEFAULT '0',
  110. `listid` int(11) NOT NULL AUTO_INCREMENT,
  111. PRIMARY KEY (`listid`),
  112. UNIQUE KEY `u_login` (`u_id`,`name`)
  113. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=3 ;
  114.  
  115. -- --------------------------------------------------------
  116.  
  117. --
  118. -- Struktura tabeli dla `tbl_playlist_list`
  119. --
  120.  
  121. CREATE TABLE `tbl_playlist_list` (
  122. `listid` int(11) NOT NULL DEFAULT '0',
  123. `id` int(11) NOT NULL AUTO_INCREMENT,
  124. `sid` int(4) NOT NULL DEFAULT '0',
  125. `seq` int(4) NOT NULL DEFAULT '0',
  126. PRIMARY KEY (`id`),
  127. KEY `listid` (`listid`)
  128. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=12 ;
  129.  
  130. -- --------------------------------------------------------
  131.  
  132. --
  133. -- Struktura tabeli dla `tbl_search`
  134. --
  135.  
  136. CREATE TABLE `tbl_search` (
  137. `id` int(11) NOT NULL AUTO_INCREMENT,
  138. `f_stat` int(4) NOT NULL DEFAULT '0',
  139. `track` int(4) NOT NULL DEFAULT '0',
  140. `year` int(4) NOT NULL DEFAULT '0',
  141. `title` varchar(255) NOT NULL DEFAULT '',
  142. `free` varchar(255) NOT NULL DEFAULT '',
  143. `comment` varchar(255) NOT NULL DEFAULT '',
  144. `dirname` varchar(255) NOT NULL DEFAULT '0',
  145. `album` varchar(255) NOT NULL DEFAULT '',
  146. `artist` varchar(255) NOT NULL DEFAULT '',
  147. `md5` varchar(32) NOT NULL DEFAULT '',
  148. `hits` int(4) NOT NULL DEFAULT '0',
  149. `mtime` int(4) NOT NULL DEFAULT '0',
  150. `date` int(4) NOT NULL DEFAULT '0',
  151. `fsize` int(4) NOT NULL DEFAULT '0',
  152. `genre` int(4) NOT NULL DEFAULT '255',
  153. `bitrate` int(4) NOT NULL DEFAULT '0',
  154. `ratemode` tinyint(4) DEFAULT '0',
  155. `lengths` int(4) NOT NULL DEFAULT '0',
  156. `drive` tinyint(4) DEFAULT '0',
  157. `ftypeid` int(4) NOT NULL DEFAULT '-1',
  158. PRIMARY KEY (`id`),
  159. KEY `dirname` (`dirname`),
  160. KEY `free` (`free`),
  161. KEY `artist` (`artist`),
  162. KEY `album` (`album`),
  163. KEY `title` (`title`),
  164. KEY `fsize` (`fsize`),
  165. KEY `date` (`date`),
  166. KEY `f_stat` (`f_stat`),
  167. KEY `drive` (`drive`),
  168. KEY `ftypeid` (`ftypeid`)
  169. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=26 ;
  170.  
  171. -- --------------------------------------------------------
  172.  
  173. --
  174. -- Struktura tabeli dla `tbl_session`
  175. --
  176.  
  177. CREATE TABLE `tbl_session` (
  178. `sessionid` bigint(16) NOT NULL AUTO_INCREMENT,
  179. `u_id` int(4) NOT NULL DEFAULT '0',
  180. `ip` int(4) NOT NULL DEFAULT '0',
  181. `login` int(4) NOT NULL DEFAULT '0',
  182. `refreshed` int(4) NOT NULL DEFAULT '0',
  183. `logout` int(4) NOT NULL DEFAULT '0',
  184. `sstatus` int(4) NOT NULL DEFAULT '0',
  185. PRIMARY KEY (`sessionid`),
  186. KEY `u_id` (`u_id`)
  187. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1092396701 ;
  188.  
  189. -- --------------------------------------------------------
  190.  
  191. --
  192. -- Struktura tabeli dla `tbl_users`
  193. --
  194.  
  195. CREATE TABLE `tbl_users` (
  196. `u_name` varchar(32) NOT NULL DEFAULT '',
  197. `u_pass` varchar(32) NOT NULL DEFAULT '',
  198. `u_login` varchar(32) NOT NULL DEFAULT '',
  199. `u_ip` varchar(16) NOT NULL DEFAULT '',
  200. `u_comment` varchar(64) DEFAULT NULL,
  201. `u_id` int(4) NOT NULL AUTO_INCREMENT,
  202. `u_sessionkey` bigint(16) UNSIGNED DEFAULT '0',
  203. `u_booted` tinyint(4) NOT NULL DEFAULT '0',
  204. `u_status` tinyint(4) NOT NULL DEFAULT '0',
  205. `u_time` bigint(16) NOT NULL DEFAULT '0',
  206. `u_access` tinyint(4) DEFAULT '1',
  207. `u_allowdownload` char(1) NOT NULL DEFAULT '1',
  208. `allowarchive` char(1) NOT NULL DEFAULT '1',
  209. `archivesize` int(4) NOT NULL DEFAULT '0',
  210. `extm3u` char(1) NOT NULL DEFAULT '1',
  211. `defplaylist` int(4) NOT NULL DEFAULT '0',
  212. `defshplaylist` int(4) NOT NULL DEFAULT '0',
  213. `defaultid3` char(1) NOT NULL DEFAULT '0',
  214. `defaultsearch` int(1) NOT NULL DEFAULT '0',
  215. `partymode` char(1) NOT NULL DEFAULT '0',
  216. `theme` int(4) NOT NULL DEFAULT '1',
  217. `lockedtime` int(8) NOT NULL DEFAULT '0',
  218. `hotrows` int(4) NOT NULL DEFAULT '25',
  219. `searchrows` int(4) NOT NULL DEFAULT '25',
  220. `lang` tinyint(4) NOT NULL DEFAULT '0',
  221. `udlrate` int(4) NOT NULL DEFAULT '0',
  222. `defgenre` int(4) NOT NULL DEFAULT '0',
  223. `archer` char(1) NOT NULL DEFAULT '0',
  224. `hitsas` tinyint(4) NOT NULL DEFAULT '0',
  225. `lameperm` char(1) NOT NULL DEFAULT '0',
  226. `lamerate` int(4) NOT NULL DEFAULT '0',
  227. `allowemail` char(1) NOT NULL DEFAULT '0',
  228. `email` varchar(128) NOT NULL DEFAULT '',
  229. `plinline` char(1) NOT NULL DEFAULT '1',
  230. `hotmode` int(4) NOT NULL DEFAULT '0',
  231. `created` int(4) NOT NULL DEFAULT '0',
  232. `laston` int(4) NOT NULL DEFAULT '0',
  233. `pltype` int(4) NOT NULL DEFAULT '1',
  234. `orsearch` char(1) NOT NULL DEFAULT '0',
  235. `textcut` int(2) NOT NULL DEFAULT '80',
  236. `dircolumn` int(2) NOT NULL DEFAULT '1',
  237. `streamengine` char(1) NOT NULL DEFAULT '1',
  238. `utemplate` char(1) NOT NULL DEFAULT '0',
  239. PRIMARY KEY (`u_id`),
  240. UNIQUE KEY `u_login` (`u_login`)
  241. ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=8 ;