Advertisement
Mr-Green

nationalbrassbandchampionships.com

Jul 17th, 2011
423
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 82.45 KB | None | 0 0
  1. Here's the stuff I got from www.nationalbrassbandchampionships.com (There's a lot)
  2.  
  3.  
  4.  
  5. --------CHARACTER_SETS----------
  6.  
  7. CHARACTER_SET_NAME,DEFAULT_COLLATE_NAME,DESCRIPTION,MAXLEN
  8. "cp1257","cp1257_general_ci","Windows Baltic","1"
  9. "cp1250","cp1250_general_ci","Windows Central European","1"
  10. "hebrew","hebrew_general_ci","ISO 8859-8 Hebrew","1"
  11. "cp1256","cp1256_general_ci","Windows Arabic","1"
  12. "koi8r","koi8r_general_ci","KOI8-R Relcom Russian","1"
  13. "cp932","cp932_japanese_ci","SJIS for Windows Japanese","2"
  14. "gbk","gbk_chinese_ci","GBK Simplified Chinese","2"
  15. "cp852","cp852_general_ci","DOS Central European","1"
  16. "macroman","macroman_general_ci","Mac West European","1"
  17. "cp866","cp866_general_ci","DOS Russian","1"
  18. "ucs2","ucs2_general_ci","UCS-2 Unicode","2"
  19. "eucjpms","eucjpms_japanese_ci","UJIS for Windows Japanese","3"
  20. "dec8","dec8_swedish_ci","DEC West European","1"
  21. "koi8u","koi8u_general_ci","KOI8-U Ukrainian","1"
  22. "latin7","latin7_general_ci","ISO 8859-13 Baltic","1"
  23. "greek","greek_general_ci","ISO 8859-7 Greek","1"
  24. "ujis","ujis_japanese_ci","EUC-JP Japanese","3"
  25. "sjis","sjis_japanese_ci","Shift-JIS Japanese","2"
  26. "swe7","swe7_swedish_ci","7bit Swedish","1"
  27. "euckr","euckr_korean_ci","EUC-KR Korean","2"
  28. "binary","binary","Binary pseudo charset","1"
  29. "tis620","tis620_thai_ci","TIS620 Thai","1"
  30. "latin5","latin5_turkish_ci","ISO 8859-9 Turkish","1"
  31. "cp1251","cp1251_general_ci","Windows Cyrillic","1"
  32. "keybcs2","keybcs2_general_ci","DOS Kamenicky Czech-Slovak","1"
  33. "hp8","hp8_english_ci","HP West European","1"
  34. "ascii","ascii_general_ci","US ASCII","1"
  35. "latin1","latin1_swedish_ci","cp1252 West European","1"
  36. "armscii8","armscii8_general_ci","ARMSCII-8 Armenian","1"
  37. "latin2","latin2_general_ci","ISO 8859-2 Central European","1"
  38. "utf8","utf8_general_ci","UTF-8 Unicode","3"
  39. "macce","macce_general_ci","Mac Central European","1"
  40. "cp850","cp850_general_ci","DOS West European","1"
  41. "gb2312","gb2312_chinese_ci","GB2312 Simplified Chinese","2"
  42. "big5","big5_chinese_ci","Big5 Traditional Chinese","2"
  43. "geostd8","geostd8_general_ci","GEOSTD8 Georgian","1"
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50. -----------COLLATION_CHARACTER_SET_APPLICABILITY------------
  51.  
  52. CHARACTER_SET_NAME,COLLATION_NAME
  53. "dec8","dec8_swedish_ci"
  54. "cp1257","cp1257_general_ci"
  55. "keybcs2","keybcs2_general_ci"
  56. "swe7","swe7_bin"
  57. "keybcs2","keybcs2_bin"
  58. "latin5","latin5_bin"
  59. "ucs2","ucs2_spanish_ci"
  60. "tis620","tis620_bin"
  61. "utf8","utf8_general_ci"
  62. "utf8","utf8_estonian_ci"
  63. "latin1","latin1_swedish_ci"
  64. "sjis","sjis_japanese_ci"
  65. "sjis","sjis_bin"
  66. "utf8","utf8_romanian_ci"
  67. "macce","macce_general_ci"
  68. "ucs2","ucs2_esperanto_ci"
  69. "utf8","utf8_turkish_ci"
  70. "gbk","gbk_bin"
  71. "cp932","cp932_bin"
  72. "ucs2","ucs2_roman_ci"
  73. "utf8","utf8_roman_ci"
  74. "latin1","latin1_german2_ci"
  75. "ucs2","ucs2_icelandic_ci"
  76. "cp1251","cp1251_general_ci"
  77. "gbk","gbk_chinese_ci"
  78. "cp1250","cp1250_croatian_ci"
  79. "hp8","hp8_bin"
  80. "utf8","utf8_persian_ci"
  81. "utf8","utf8_danish_ci"
  82. "cp1256","cp1256_general_ci"
  83. "utf8","utf8_spanish_ci"
  84. "ucs2","ucs2_danish_ci"
  85. "macce","macce_bin"
  86. "ucs2","ucs2_lithuanian_ci"
  87. "koi8u","koi8u_bin"
  88. "cp1257","cp1257_bin"
  89. "koi8r","koi8r_general_ci"
  90. "latin2","latin2_hungarian_ci"
  91. "hebrew","hebrew_bin"
  92. "utf8","utf8_esperanto_ci"
  93. "macroman","macroman_bin"
  94. "gb2312","gb2312_chinese_ci"
  95. "latin7","latin7_estonian_cs"
  96. "ujis","ujis_bin"
  97. "big5","big5_bin"
  98. "cp866","cp866_bin"
  99. "ucs2","ucs2_czech_ci"
  100. "utf8","utf8_icelandic_ci"
  101. "utf8","utf8_hungarian_ci"
  102. "ujis","ujis_japanese_ci"
  103. "dec8","dec8_bin"
  104. "hp8","hp8_english_ci"
  105. "cp852","cp852_general_ci"
  106. "cp1251","cp1251_bin"
  107. "ucs2","ucs2_general_ci"
  108. "cp850","cp850_bin"
  109. "koi8u","koi8u_general_ci"
  110. "ascii","ascii_bin"
  111. "geostd8","geostd8_bin"
  112. "ucs2","ucs2_polish_ci"
  113. "latin1","latin1_bin"
  114. "latin5","latin5_turkish_ci"
  115. "ucs2","ucs2_slovak_ci"
  116. "ucs2","ucs2_turkish_ci"
  117. "ucs2","ucs2_spanish2_ci"
  118. "ucs2","ucs2_estonian_ci"
  119. "cp1257","cp1257_lithuanian_ci"
  120. "eucjpms","eucjpms_bin"
  121. "cp1250","cp1250_bin"
  122. "utf8","utf8_lithuanian_ci"
  123. "cp1251","cp1251_bulgarian_ci"
  124. "ucs2","ucs2_swedish_ci"
  125. "utf8","utf8_bin"
  126. "latin2","latin2_bin"
  127. "hebrew","hebrew_general_ci"
  128. "ucs2","ucs2_hungarian_ci"
  129. "latin1","latin1_danish_ci"
  130. "greek","greek_bin"
  131. "cp932","cp932_japanese_ci"
  132. "gb2312","gb2312_bin"
  133. "greek","greek_general_ci"
  134. "utf8","utf8_polish_ci"
  135. "swe7","swe7_swedish_ci"
  136. "cp1251","cp1251_ukrainian_ci"
  137. "utf8","utf8_slovenian_ci"
  138. "ucs2","ucs2_slovenian_ci"
  139. "latin2","latin2_croatian_ci"
  140. "ucs2","ucs2_latvian_ci"
  141. "latin7","latin7_general_cs"
  142. "latin1","latin1_general_ci"
  143. "macroman","macroman_general_ci"
  144. "latin1","latin1_general_cs"
  145. "ucs2","ucs2_persian_ci"
  146. "eucjpms","eucjpms_japanese_ci"
  147. "latin7","latin7_general_ci"
  148. "utf8","utf8_czech_ci"
  149. "cp1251","cp1251_general_cs"
  150. "koi8r","koi8r_bin"
  151. "ucs2","ucs2_bin"
  152. "cp1250","cp1250_general_ci"
  153. "utf8","utf8_spanish2_ci"
  154. "cp852","cp852_bin"
  155. "cp1250","cp1250_czech_cs"
  156. "armscii8","armscii8_general_ci"
  157. "geostd8","geostd8_general_ci"
  158. "binary","binary"
  159. "latin2","latin2_general_ci"
  160. "euckr","euckr_bin"
  161. "ucs2","ucs2_romanian_ci"
  162. "ascii","ascii_general_ci"
  163. "ucs2","ucs2_unicode_ci"
  164. "latin1","latin1_german1_ci"
  165. "armscii8","armscii8_bin"
  166. "cp1256","cp1256_bin"
  167. "big5","big5_chinese_ci"
  168. "latin1","latin1_spanish_ci"
  169. "utf8","utf8_unicode_ci"
  170. "utf8","utf8_swedish_ci"
  171. "cp866","cp866_general_ci"
  172. "cp850","cp850_general_ci"
  173. "utf8","utf8_latvian_ci"
  174. "euckr","euckr_korean_ci"
  175. "tis620","tis620_thai_ci"
  176. "utf8","utf8_slovak_ci"
  177. "latin2","latin2_czech_cs"
  178. "latin7","latin7_bin"
  179.  
  180.  
  181.  
  182.  
  183.  
  184. ---------COLLATIONS---------
  185.  
  186. CHARACTER_SET_NAME,COLLATION_NAME,ID,IS_COMPILED,IS_DEFAULT,SORTLEN
  187. "utf8","utf8_persian_ci","208","Yes","NULL","8"
  188. "ucs2","ucs2_unicode_ci","128","Yes","NULL","8"
  189. "utf8","utf8_spanish2_ci","206","Yes","NULL","8"
  190. "euckr","euckr_bin","85","Yes","NULL","1"
  191. "cp932","cp932_bin","96","Yes","NULL","1"
  192. "cp1257","cp1257_bin","58","Yes","NULL","1"
  193. "armscii8","armscii8_general_ci","32","Yes","Yes","1"
  194. "utf8","utf8_estonian_ci","198","Yes","NULL","8"
  195. "latin1","latin1_german1_ci","5","Yes","NULL","1"
  196. "cp1257","cp1257_general_ci","59","Yes","Yes","1"
  197. "latin7","latin7_bin","79","Yes","NULL","1"
  198. "cp1256","cp1256_bin","67","Yes","NULL","1"
  199. "latin5","latin5_turkish_ci","30","Yes","Yes","1"
  200. "latin7","latin7_general_cs","42","Yes","NULL","1"
  201. "ucs2","ucs2_slovak_ci","141","Yes","NULL","8"
  202. "ucs2","ucs2_czech_ci","138","Yes","NULL","8"
  203. "utf8","utf8_czech_ci","202","Yes","NULL","8"
  204. "cp1251","cp1251_bulgarian_ci","14","Yes","NULL","1"
  205. "cp852","cp852_bin","81","Yes","NULL","1"
  206. "cp1256","cp1256_general_ci","57","Yes","Yes","1"
  207. "ucs2","ucs2_polish_ci","133","Yes","NULL","8"
  208. "utf8","utf8_unicode_ci","192","Yes","NULL","8"
  209. "gb2312","gb2312_bin","86","Yes","NULL","1"
  210. "eucjpms","eucjpms_bin","98","Yes","NULL","1"
  211. "latin1","latin1_general_cs","49","Yes","NULL","1"
  212. "keybcs2","keybcs2_general_ci","37","Yes","Yes","1"
  213. "cp866","cp866_general_ci","36","Yes","Yes","1"
  214. "utf8","utf8_bin","83","Yes","NULL","1"
  215. "latin1","latin1_swedish_ci","8","Yes","Yes","1"
  216. "dec8","dec8_swedish_ci","3","Yes","Yes","1"
  217. "latin1","latin1_danish_ci","15","Yes","NULL","1"
  218. "macroman","macroman_general_ci","39","Yes","Yes","1"
  219. "latin1","latin1_general_ci","48","Yes","NULL","1"
  220. "ucs2","ucs2_danish_ci","139","Yes","NULL","8"
  221. "binary","binary","63","Yes","Yes","1"
  222. "geostd8","geostd8_bin","93","Yes","NULL","1"
  223. "utf8","utf8_roman_ci","207","Yes","NULL","8"
  224. "utf8","utf8_turkish_ci","201","Yes","NULL","8"
  225. "swe7","swe7_bin","82","Yes","NULL","1"
  226. "utf8","utf8_lithuanian_ci","204","Yes","NULL","8"
  227. "cp850","cp850_general_ci","4","Yes","Yes","1"
  228. "koi8r","koi8r_bin","74","Yes","NULL","1"
  229. "cp1251","cp1251_ukrainian_ci","23","Yes","NULL","1"
  230. "gbk","gbk_chinese_ci","28","Yes","Yes","1"
  231. "cp852","cp852_general_ci","40","Yes","Yes","1"
  232. "utf8","utf8_general_ci","33","Yes","Yes","1"
  233. "utf8","utf8_polish_ci","197","Yes","NULL","8"
  234. "utf8","utf8_slovak_ci","205","Yes","NULL","8"
  235. "cp1251","cp1251_general_cs","52","Yes","NULL","1"
  236. "ucs2","ucs2_latvian_ci","130","Yes","NULL","8"
  237. "cp1250","cp1250_bin","66","Yes","NULL","1"
  238. "koi8r","koi8r_general_ci","7","Yes","Yes","1"
  239. "ucs2","ucs2_spanish_ci","135","Yes","NULL","8"
  240. "ucs2","ucs2_lithuanian_ci","140","Yes","NULL","8"
  241. "macce","macce_general_ci","38","Yes","Yes","1"
  242. "utf8","utf8_latvian_ci","194","Yes","NULL","8"
  243. "tis620","tis620_thai_ci","18","Yes","Yes","4"
  244. "utf8","utf8_esperanto_ci","209","Yes","NULL","8"
  245. "hp8","hp8_bin","72","Yes","NULL","1"
  246. "ascii","ascii_general_ci","11","Yes","Yes","1"
  247. "hebrew","hebrew_general_ci","16","Yes","Yes","1"
  248. "armscii8","armscii8_bin","64","Yes","NULL","1"
  249. "macce","macce_bin","43","Yes","NULL","1"
  250. "ucs2","ucs2_spanish2_ci","142","Yes","NULL","8"
  251. "dec8","dec8_bin","69","Yes","NULL","1"
  252. "latin2","latin2_czech_cs","2","Yes","NULL","4"
  253. "ucs2","ucs2_romanian_ci","131","Yes","NULL","8"
  254. "ucs2","ucs2_roman_ci","143","Yes","NULL","8"
  255. "ujis","ujis_japanese_ci","12","Yes","Yes","1"
  256. "sjis","sjis_japanese_ci","13","Yes","Yes","1"
  257. "latin1","latin1_bin","47","Yes","NULL","1"
  258. "utf8","utf8_danish_ci","203","Yes","NULL","8"
  259. "keybcs2","keybcs2_bin","73","Yes","NULL","1"
  260. "cp850","cp850_bin","80","Yes","NULL","1"
  261. "ucs2","ucs2_swedish_ci","136","Yes","NULL","8"
  262. "gbk","gbk_bin","87","Yes","NULL","1"
  263. "utf8","utf8_hungarian_ci","210","Yes","NULL","8"
  264. "latin2","latin2_hungarian_ci","21","Yes","NULL","1"
  265. "big5","big5_bin","84","Yes","NULL","1"
  266. "koi8u","koi8u_general_ci","22","Yes","Yes","1"
  267. "ucs2","ucs2_slovenian_ci","132","Yes","NULL","8"
  268. "greek","greek_general_ci","25","Yes","Yes","1"
  269. "euckr","euckr_korean_ci","19","Yes","Yes","1"
  270. "cp866","cp866_bin","68","Yes","NULL","1"
  271. "big5","big5_chinese_ci","1","Yes","Yes","1"
  272. "utf8","utf8_romanian_ci","195","Yes","NULL","8"
  273. "koi8u","koi8u_bin","75","Yes","NULL","1"
  274. "eucjpms","eucjpms_japanese_ci","97","Yes","Yes","1"
  275. "cp1250","cp1250_croatian_ci","44","Yes","NULL","1"
  276. "utf8","utf8_swedish_ci","200","Yes","NULL","8"
  277. "latin5","latin5_bin","78","Yes","NULL","1"
  278. "ucs2","ucs2_persian_ci","144","Yes","NULL","8"
  279. "ucs2","ucs2_bin","90","Yes","NULL","1"
  280. "cp1250","cp1250_czech_cs","34","Yes","NULL","2"
  281. "latin1","latin1_spanish_ci","94","Yes","NULL","1"
  282. "latin7","latin7_estonian_cs","20","Yes","NULL","1"
  283. "ucs2","ucs2_general_ci","35","Yes","Yes","1"
  284. "ujis","ujis_bin","91","Yes","NULL","1"
  285. "latin2","latin2_general_ci","9","Yes","Yes","1"
  286. "sjis","sjis_bin","88","Yes","NULL","1"
  287. "macroman","macroman_bin","53","Yes","NULL","1"
  288. "ucs2","ucs2_esperanto_ci","145","Yes","NULL","8"
  289. "ascii","ascii_bin","65","Yes","NULL","1"
  290. "utf8","utf8_spanish_ci","199","Yes","NULL","8"
  291. "tis620","tis620_bin","89","Yes","NULL","1"
  292. "utf8","utf8_icelandic_ci","193","Yes","NULL","8"
  293. "hp8","hp8_english_ci","6","Yes","Yes","1"
  294. "latin2","latin2_croatian_ci","27","Yes","NULL","1"
  295. "swe7","swe7_swedish_ci","10","Yes","Yes","1"
  296. "ucs2","ucs2_estonian_ci","134","Yes","NULL","8"
  297. "greek","greek_bin","70","Yes","NULL","1"
  298. "cp932","cp932_japanese_ci","95","Yes","Yes","1"
  299. "cp1251","cp1251_general_ci","51","Yes","Yes","1"
  300. "latin1","latin1_german2_ci","31","Yes","NULL","2"
  301. "latin7","latin7_general_ci","41","Yes","Yes","1"
  302. "gb2312","gb2312_chinese_ci","24","Yes","Yes","1"
  303. "ucs2","ucs2_turkish_ci","137","Yes","NULL","8"
  304. "cp1251","cp1251_bin","50","Yes","NULL","1"
  305. "cp1257","cp1257_lithuanian_ci","29","Yes","NULL","1"
  306. "ucs2","ucs2_hungarian_ci","146","Yes","NULL","8"
  307. "utf8","utf8_slovenian_ci","196","Yes","NULL","8"
  308. "ucs2","ucs2_icelandic_ci","129","Yes","NULL","8"
  309. "hebrew","hebrew_bin","71","Yes","NULL","1"
  310. "cp1250","cp1250_general_ci","26","Yes","Yes","1"
  311. "geostd8","geostd8_general_ci","92","Yes","Yes","1"
  312. "latin2","latin2_bin","77","Yes","NULL","1"
  313.  
  314.  
  315.  
  316.  
  317. ----------COLUMNS----------
  318.  
  319. CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,CHARACTER_SET_NAME,COLLATION_NAME,COLUMN_COMMENT,COLUMN_DEFAULT,COLUMN_KEY,COLUMN_NAME,COLUMN_TYPE,DATA_TYPE,EXTRA,IS_NULLABLE,NUMERIC_PRECISION,NUMERIC_SCALE,ORDINAL_POSITION,PRIVILEGES,TABLE_CATALOG,TABLE_NAME,TABLE_SCHEMA
  320. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_GRANTABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","6","select","NULL","TABLE_PRIVILEGES","information_schema"
  321. "8","24","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_BODY","varchar(8)","varchar","NULL","NO","NULL","NULL","7","select","NULL","ROUTINES","information_schema"
  322. "16","48","utf8","utf8_general_ci","NULL","NULL","NULL","COMMENT","varchar(16)","varchar","NULL","YES","NULL","NULL","15","select","NULL","STATISTICS","information_schema"
  323. "8","24","utf8","utf8_general_ci","NULL","NULL","NULL","width","varchar(8)","varchar","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  324. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","register_date","date","date","NULL","NO","NULL","NULL","15","select,insert,update,references","NULL","vacancies","kapitol_db1"
  325. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","ROUTINES","information_schema"
  326. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","menu_id","int(11)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  327. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","fax","varchar(20)","varchar","NULL","NO","NULL","NULL","14","select,insert,update,references","NULL","professional_network","kapitol_db1"
  328. "3","3","latin1","latin1_swedish_ci","NULL","NULL","NULL","iso3","char(3)","char","NULL","YES","NULL","NULL","4","select,insert,update,references","NULL","country","kapitol_db1"
  329. "80","80","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(80)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","country","kapitol_db1"
  330. "8","24","utf8","utf8_general_ci","NULL","NULL","NULL","PARAMETER_STYLE","varchar(8)","varchar","NULL","NO","NULL","NULL","11","select","NULL","ROUTINES","information_schema"
  331. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","INDEX_LENGTH","bigint(21)","bigint","NULL","YES","19","0","12","select","NULL","TABLES","information_schema"
  332. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","PRIVILEGE_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","5","select","NULL","TABLE_PRIVILEGES","information_schema"
  333. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_UPDATABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","6","select","NULL","VIEWS","information_schema"
  334. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ENGINE","varchar(64)","varchar","NULL","YES","NULL","NULL","5","select","NULL","TABLES","information_schema"
  335. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","SOURCE_LINE","bigint(20)","bigint","NULL","YES","19","0","18","select","NULL","PROFILING","information_schema"
  336. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","STATISTICS","information_schema"
  337. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","description","text","text","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","events","kapitol_db1"
  338. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","catID","int(3)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","sale_categories","kapitol_db1"
  339. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(6)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","vacancies","kapitol_db1"
  340. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(4)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","img_library","kapitol_db1"
  341. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CPU_SYSTEM","decimal(9,6)","decimal","NULL","YES","9","6","6","select","NULL","PROFILING","information_schema"
  342. "NULL","NULL","NULL","NULL","NULL","0","NULL","validity","int(1)","int","NULL","NO","10","0","10","select,insert,update,references","NULL","sale","kapitol_db1"
  343. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","8","select","NULL","STATISTICS","information_schema"
  344. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","DEFAULT_COLLATION_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","SCHEMATA","information_schema"
  345. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CHARACTER_SET_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","1","select","NULL","CHARACTER_SETS","information_schema"
  346. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","CATALOG_NAME","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","SCHEMATA","information_schema"
  347. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_KEY","varchar(3)","varchar","NULL","NO","NULL","NULL","16","select","NULL","COLUMNS","information_schema"
  348. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","filetype","varchar(50)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","file_library","kapitol_db1"
  349. "NULL","NULL","NULL","NULL","NULL","0000-00-00","NULL","register_date","date","date","NULL","NO","NULL","NULL","17","select,insert,update,references","NULL","professional_network","kapitol_db1"
  350. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","BLOCK_OPS_OUT","bigint(20)","bigint","NULL","YES","19","0","10","select","NULL","PROFILING","information_schema"
  351. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","register_date","date","date","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","events","kapitol_db1"
  352. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_REFERENCE_NEW_ROW","varchar(3)","varchar","NULL","NO","NULL","NULL","16","select","NULL","TRIGGERS","information_schema"
  353. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","VERSION","bigint(21)","bigint","NULL","YES","19","0","6","select","NULL","TABLES","information_schema"
  354. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","website","varchar(100)","varchar","NULL","NO","NULL","NULL","10","select,insert,update,references","NULL","professional_network","kapitol_db1"
  355. "9","27","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_TYPE","varchar(9)","varchar","NULL","NO","NULL","NULL","5","select","NULL","ROUTINES","information_schema"
  356. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_DEFINITION","longtext","longtext","NULL","YES","NULL","NULL","8","select","NULL","ROUTINES","information_schema"
  357. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","register_date","date","date","NULL","NO","NULL","NULL","9","select,insert,update,references","NULL","sale","kapitol_db1"
  358. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","POSITION_IN_UNIQUE_CONSTRAINT","bigint(10)","bigint","NULL","YES","19","0","9","select","NULL","KEY_COLUMN_USAGE","information_schema"
  359. "10","30","utf8","utf8_general_ci","NULL","NULL","NULL","PACKED","varchar(10)","varchar","NULL","YES","NULL","NULL","12","select","NULL","STATISTICS","information_schema"
  360. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","telephone","varchar(100)","varchar","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","vacancies","kapitol_db1"
  361. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_REFERENCE_OLD_TABLE","varchar(64)","varchar","NULL","YES","NULL","NULL","13","select","NULL","TRIGGERS","information_schema"
  362. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","2","select","NULL","TABLE_PRIVILEGES","information_schema"
  363. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","mailsent","int(1)","int","NULL","NO","10","0","11","select,insert,update,references","NULL","sale","kapitol_db1"
  364. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CREATE_TIME","datetime","datetime","NULL","YES","NULL","NULL","15","select","NULL","TABLES","information_schema"
  365. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","TABLE_ROWS","bigint(21)","bigint","NULL","YES","19","0","8","select","NULL","TABLES","information_schema"
  366. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","printable_title","varchar(50)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  367. "81","243","utf8","utf8_general_ci","NULL","NULL","NULL","GRANTEE","varchar(81)","varchar","NULL","NO","NULL","NULL","1","select","NULL","TABLE_PRIVILEGES","information_schema"
  368. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CHECK_TIME","datetime","datetime","NULL","YES","NULL","NULL","17","select","NULL","TABLES","information_schema"
  369. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","photo","varchar(50)","varchar","NULL","NO","NULL","NULL","16","select,insert,update,references","NULL","professional_network","kapitol_db1"
  370. "40","40","latin1","latin1_swedish_ci","NULL","NULL","NULL","secret_id","varchar(40)","varchar","NULL","NO","NULL","NULL","12","select,insert,update,references","NULL","sale","kapitol_db1"
  371. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","KEY_COLUMN_USAGE","information_schema"
  372. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","EXTERNAL_NAME","varchar(64)","varchar","NULL","YES","NULL","NULL","9","select","NULL","ROUTINES","information_schema"
  373. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLLATION_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","1","select","NULL","COLLATIONS","information_schema"
  374. "500","1500","utf8","utf8_general_ci","NULL","NULL","NULL","photo_description","varchar(500)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  375. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","email","varchar(100)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","sale","kapitol_db1"
  376. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","6","select","NULL","KEY_COLUMN_USAGE","information_schema"
  377. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","title","varchar(50)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  378. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","address_line_2","varchar(100)","varchar","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","professional_network","kapitol_db1"
  379. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","COLUMNS","information_schema"
  380. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","PRIVILEGE_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","6","select","NULL","COLUMN_PRIVILEGES","information_schema"
  381. "NULL","NULL","NULL","NULL","NULL","0","NULL","rgt","int(11)","int","NULL","NO","10","0","6","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  382. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_NULLABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","7","select","NULL","COLUMNS","information_schema"
  383. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","SPECIFIC_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","1","select","NULL","ROUTINES","information_schema"
  384. "81","243","utf8","utf8_general_ci","NULL","NULL","NULL","GRANTEE","varchar(81)","varchar","NULL","NO","NULL","NULL","1","select","NULL","USER_PRIVILEGES","information_schema"
  385. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","DTD_IDENTIFIER","varchar(64)","varchar","NULL","YES","NULL","NULL","6","select","NULL","ROUTINES","information_schema"
  386. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","REFERENCED_COLUMN_NAME","varchar(64)","varchar","NULL","YES","NULL","NULL","12","select","NULL","KEY_COLUMN_USAGE","information_schema"
  387. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","5","select","NULL","TABLE_CONSTRAINTS","information_schema"
  388. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","2","select","NULL","ROUTINES","information_schema"
  389. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","COLUMNS","information_schema"
  390. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","DEFINER","longtext","longtext","NULL","NO","NULL","NULL","19","select","NULL","TRIGGERS","information_schema"
  391. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","TABLES","information_schema"
  392. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","SCHEMA_PRIVILEGES","information_schema"
  393. "20","60","utf8","utf8_general_ci","NULL","NULL","NULL","EXTRA","varchar(20)","varchar","NULL","NO","NULL","NULL","17","select","NULL","COLUMNS","information_schema"
  394. "255","255","latin1","latin1_swedish_ci","NULL","NULL","NULL","file_path","varchar(255)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","img_library","kapitol_db1"
  395. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","content","text","text","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","content_pages","kapitol_db1"
  396. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_STATEMENT","longtext","longtext","NULL","NO","NULL","NULL","10","select","NULL","TRIGGERS","information_schema"
  397. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","folder_description","varchar(255)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","gallery_folders","kapitol_db1"
  398. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","TABLES","information_schema"
  399. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_DEFAULT","varchar(3)","varchar","NULL","NO","NULL","NULL","4","select","NULL","COLLATIONS","information_schema"
  400. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","structure","varchar(50)","varchar","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  401. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TRIGGER_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","TRIGGERS","information_schema"
  402. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","REFERENCED_TABLE_SCHEMA","varchar(64)","varchar","NULL","YES","NULL","NULL","10","select","NULL","KEY_COLUMN_USAGE","information_schema"
  403. "NULL","NULL","NULL","NULL","NULL","0","NULL","ORDINAL_POSITION","bigint(10)","bigint","NULL","NO","19","0","8","select","NULL","KEY_COLUMN_USAGE","information_schema"
  404. "8","24","utf8","utf8_general_ci","NULL","NULL","NULL","height","varchar(8)","varchar","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  405. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","SWAPS","bigint(20)","bigint","NULL","YES","19","0","15","select","NULL","PROFILING","information_schema"
  406. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","COLUMN_PRIVILEGES","information_schema"
  407. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(3)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","adverts","kapitol_db1"
  408. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","5","select","NULL","KEY_COLUMN_USAGE","information_schema"
  409. "30","90","utf8","utf8_general_ci","NULL","NULL","NULL","SOURCE_FUNCTION","varchar(30)","varchar","NULL","YES","NULL","NULL","16","select","NULL","PROFILING","information_schema"
  410. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","firstname","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","professional_network","kapitol_db1"
  411. "8","24","utf8","utf8_general_ci","NULL","NULL","NULL","CHECK_OPTION","varchar(8)","varchar","NULL","NO","NULL","NULL","5","select","NULL","VIEWS","information_schema"
  412. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","STATISTICS","information_schema"
  413. "65535","65535","utf8","utf8_general_ci","NULL","NULL","NULL","text","text","text","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","gallery_folders","kapitol_db1"
  414. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","UPDATE_TIME","datetime","datetime","NULL","YES","NULL","NULL","16","select","NULL","TABLES","information_schema"
  415. "6","18","utf8","utf8_general_ci","NULL","NULL","NULL","EVENT_MANIPULATION","varchar(6)","varchar","NULL","NO","NULL","NULL","4","select","NULL","TRIGGERS","information_schema"
  416. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CARDINALITY","bigint(21)","bigint","NULL","YES","19","0","10","select","NULL","STATISTICS","information_schema"
  417. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","postcode","varchar(20)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","sale","kapitol_db1"
  418. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(2)","int","NULL","NO","10","0","1","select,insert,update,references","NULL","vacancies_section","kapitol_db1"
  419. "81","243","utf8","utf8_general_ci","NULL","NULL","NULL","GRANTEE","varchar(81)","varchar","NULL","NO","NULL","NULL","1","select","NULL","SCHEMA_PRIVILEGES","information_schema"
  420. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","thumbnail","varchar(255)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  421. "NULL","NULL","NULL","NULL","NULL","0000-00-00 00:00:00","NULL","CREATED","datetime","datetime","NULL","NO","NULL","NULL","16","select","NULL","ROUTINES","information_schema"
  422. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","NUMERIC_PRECISION","bigint(21)","bigint","NULL","YES","19","0","11","select","NULL","COLUMNS","information_schema"
  423. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","tel_work","varchar(20)","varchar","NULL","NO","NULL","NULL","13","select,insert,update,references","NULL","professional_network","kapitol_db1"
  424. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","2","select","NULL","USER_PRIVILEGES","information_schema"
  425. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLLATION_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","1","select","NULL","COLLATION_CHARACTER_SET_APPLICABILITY","information_schema"
  426. "NULL","NULL","NULL","NULL","NULL","0","NULL","lft","int(11)","int","NULL","NO","10","0","5","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  427. "NULL","NULL","NULL","NULL","NULL","0000-00-00","NULL","expiry_date","date","date","NULL","NO","NULL","NULL","18","select,insert,update,references","NULL","professional_network","kapitol_db1"
  428. "80","240","utf8","utf8_general_ci","NULL","NULL","NULL","PRIVILEGES","varchar(80)","varchar","NULL","NO","NULL","NULL","18","select","NULL","COLUMNS","information_schema"
  429. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","address_line_1","varchar(100)","varchar","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","professional_network","kapitol_db1"
  430. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_DEFAULT","longtext","longtext","NULL","YES","NULL","NULL","6","select","NULL","COLUMNS","information_schema"
  431. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","BLOCK_OPS_IN","bigint(20)","bigint","NULL","YES","19","0","9","select","NULL","PROFILING","information_schema"
  432. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","REFERENCED_TABLE_NAME","varchar(64)","varchar","NULL","YES","NULL","NULL","11","select","NULL","KEY_COLUMN_USAGE","information_schema"
  433. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CHARACTER_SET_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","COLLATIONS","information_schema"
  434. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_TYPE","longtext","longtext","NULL","NO","NULL","NULL","15","select","NULL","COLUMNS","information_schema"
  435. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","COLUMNS","information_schema"
  436. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CHARACTER_MAXIMUM_LENGTH","bigint(21)","bigint","NULL","YES","19","0","9","select","NULL","COLUMNS","information_schema"
  437. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","end_date","date","date","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","events","kapitol_db1"
  438. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","PRIVILEGE_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","USER_PRIVILEGES","information_schema"
  439. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_DETERMINISTIC","varchar(3)","varchar","NULL","NO","NULL","NULL","12","select","NULL","ROUTINES","information_schema"
  440. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","PAGE_FAULTS_MINOR","bigint(20)","bigint","NULL","YES","19","0","14","select","NULL","PROFILING","information_schema"
  441. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CHARACTER_OCTET_LENGTH","bigint(21)","bigint","NULL","YES","19","0","10","select","NULL","COLUMNS","information_schema"
  442. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","specialisms","varchar(100)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","professional_network","kapitol_db1"
  443. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","folder_name","varchar(255)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","gallery_folders","kapitol_db1"
  444. "60","180","utf8","utf8_general_ci","NULL","NULL","NULL","DESCRIPTION","varchar(60)","varchar","NULL","NO","NULL","NULL","3","select","NULL","CHARACTER_SETS","information_schema"
  445. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","4","select","NULL","KEY_COLUMN_USAGE","information_schema"
  446. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CONTEXT_VOLUNTARY","bigint(20)","bigint","NULL","YES","19","0","7","select","NULL","PROFILING","information_schema"
  447. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","SQL_DATA_ACCESS","varchar(64)","varchar","NULL","NO","NULL","NULL","13","select","NULL","ROUTINES","information_schema"
  448. "250","250","latin1","latin1_swedish_ci","NULL","NULL","NULL","filepath","varchar(250)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","file_library","kapitol_db1"
  449. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","required","text","text","NULL","NO","NULL","NULL","13","select,insert,update,references","NULL","vacancies","kapitol_db1"
  450. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","telephone","varchar(20)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","sale","kapitol_db1"
  451. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","DATA_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","8","select","NULL","COLUMNS","information_schema"
  452. "50","50","latin1","latin1_swedish_ci","NULL","root","NULL","parent","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  453. "NULL","NULL","NULL","NULL","NULL","0","NULL","ID","bigint(11)","bigint","NULL","NO","19","0","3","select","NULL","COLLATIONS","information_schema"
  454. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","SQL_MODE","longtext","longtext","NULL","NO","NULL","NULL","18","select","NULL","ROUTINES","information_schema"
  455. "NULL","NULL","NULL","NULL","NULL","0.000000","NULL","DURATION","decimal(9,6)","decimal","NULL","NO","9","6","4","select","NULL","PROFILING","information_schema"
  456. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","vacancies_type","kapitol_db1"
  457. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","vacancies_country","kapitol_db1"
  458. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","id","int(3)","int","NULL","NO","10","0","1","select,insert,update,references","NULL","application_emails","kapitol_db1"
  459. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","MESSAGES_RECEIVED","bigint(20)","bigint","NULL","YES","19","0","12","select","NULL","PROFILING","information_schema"
  460. "NULL","NULL","NULL","NULL","NULL","0","NULL","QUERY_ID","bigint(20)","bigint","NULL","NO","19","0","1","select","NULL","PROFILING","information_schema"
  461. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","KEY_COLUMN_USAGE","information_schema"
  462. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","tel_mobile","varchar(20)","varchar","NULL","NO","NULL","NULL","12","select,insert,update,references","NULL","professional_network","kapitol_db1"
  463. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","INDEX_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","5","select","NULL","STATISTICS","information_schema"
  464. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","vacancies_region","kapitol_db1"
  465. "30","30","latin1","latin1_swedish_ci","NULL","NULL","NULL","fax","varchar(30)","varchar","NULL","NO","NULL","NULL","8","select,insert,update,references","NULL","vacancies","kapitol_db1"
  466. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","SQL_PATH","varchar(512)","varchar","NULL","YES","NULL","NULL","5","select","NULL","SCHEMATA","information_schema"
  467. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","SUB_PART","bigint(3)","bigint","NULL","YES","19","0","11","select","NULL","STATISTICS","information_schema"
  468. "30","90","utf8","utf8_general_ci","NULL","NULL","NULL","STATE","varchar(30)","varchar","NULL","NO","NULL","NULL","3","select","NULL","PROFILING","information_schema"
  469. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","DEFAULT_CHARACTER_SET_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","SCHEMATA","information_schema"
  470. "80","240","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_COMMENT","varchar(80)","varchar","NULL","NO","NULL","NULL","21","select","NULL","TABLES","information_schema"
  471. "9","27","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_ORIENTATION","varchar(9)","varchar","NULL","NO","NULL","NULL","11","select","NULL","TRIGGERS","information_schema"
  472. "4","4","latin1","latin1_swedish_ci","NULL","NULL","NULL","image_height","varchar(4)","varchar","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","img_library","kapitol_db1"
  473. "NULL","NULL","NULL","NULL","NULL","0","NULL","SORTLEN","bigint(3)","bigint","NULL","NO","19","0","6","select","NULL","COLLATIONS","information_schema"
  474. "7","21","utf8","utf8_general_ci","NULL","NULL","NULL","SECURITY_TYPE","varchar(7)","varchar","NULL","NO","NULL","NULL","15","select","NULL","ROUTINES","information_schema"
  475. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","VIEWS","information_schema"
  476. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","catID","int(11)","int","NULL","NO","10","0","8","select,insert,update,references","NULL","sale","kapitol_db1"
  477. "NULL","NULL","NULL","NULL","NULL","0","NULL","SEQ","bigint(20)","bigint","NULL","NO","19","0","2","select","NULL","PROFILING","information_schema"
  478. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","EVENT_OBJECT_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","6","select","NULL","TRIGGERS","information_schema"
  479. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_REFERENCE_NEW_TABLE","varchar(64)","varchar","NULL","YES","NULL","NULL","14","select","NULL","TRIGGERS","information_schema"
  480. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_REFERENCE_OLD_ROW","varchar(3)","varchar","NULL","NO","NULL","NULL","15","select","NULL","TRIGGERS","information_schema"
  481. "200","200","latin1","latin1_swedish_ci","NULL","NULL","NULL","subject","varchar(200)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","application_emails","kapitol_db1"
  482. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","surname","varchar(50)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","professional_network","kapitol_db1"
  483. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","CREATE_OPTIONS","varchar(255)","varchar","NULL","YES","NULL","NULL","20","select","NULL","TABLES","information_schema"
  484. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","EVENT_OBJECT_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","5","select","NULL","TRIGGERS","information_schema"
  485. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","SCHEMA_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","SCHEMATA","information_schema"
  486. "255","255","latin1","latin1_swedish_ci","NULL","NULL","NULL","thumbnail","varchar(255)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","img_library","kapitol_db1"
  487. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","resume","text","text","NULL","NO","NULL","NULL","15","select,insert,update,references","NULL","professional_network","kapitol_db1"
  488. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_GRANTABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","7","select","NULL","COLUMN_PRIVILEGES","information_schema"
  489. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","INDEX_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","6","select","NULL","STATISTICS","information_schema"
  490. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","address_line_3","varchar(100)","varchar","NULL","NO","NULL","NULL","8","select,insert,update,references","NULL","professional_network","kapitol_db1"
  491. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","filename","varchar(255)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  492. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","DEFAULT_COLLATE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","CHARACTER_SETS","information_schema"
  493. "255","255","latin1","latin1_swedish_ci","NULL","NULL","NULL","filename","varchar(255)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","img_library","kapitol_db1"
  494. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","VIEW_DEFINITION","longtext","longtext","NULL","NO","NULL","NULL","4","select","NULL","VIEWS","information_schema"
  495. "255","255","latin1","latin1_swedish_ci","NULL","NULL","NULL","title","varchar(255)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","usr_news_library","kapitol_db1"
  496. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","PAGE_FAULTS_MAJOR","bigint(20)","bigint","NULL","YES","19","0","13","select","NULL","PROFILING","information_schema"
  497. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","NULLABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","13","select","NULL","STATISTICS","information_schema"
  498. "60","60","latin1","latin1_swedish_ci","NULL","NULL","NULL","advert","varchar(60)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","adverts","kapitol_db1"
  499. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(100)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","vacancies","kapitol_db1"
  500. "20","20","latin1","latin1_swedish_ci","NULL","NULL","NULL","tel_home","varchar(20)","varchar","NULL","NO","NULL","NULL","11","select,insert,update,references","NULL","professional_network","kapitol_db1"
  501. "NULL","NULL","NULL","NULL","NULL","0","NULL","ORDINAL_POSITION","bigint(21)","bigint","NULL","NO","19","0","5","select","NULL","COLUMNS","information_schema"
  502. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","SQL_PATH","varchar(64)","varchar","NULL","YES","NULL","NULL","14","select","NULL","ROUTINES","information_schema"
  503. "7","21","utf8","utf8_general_ci","NULL","NULL","NULL","SECURITY_TYPE","varchar(7)","varchar","NULL","NO","NULL","NULL","8","select","NULL","VIEWS","information_schema"
  504. "30","30","latin1","latin1_swedish_ci","NULL","NULL","NULL","mobile","varchar(30)","varchar","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","vacancies","kapitol_db1"
  505. "4","4","latin1","latin1_swedish_ci","NULL","NULL","NULL","image_width","varchar(4)","varchar","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","img_library","kapitol_db1"
  506. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","visibility","int(1)","int","NULL","NO","10","0","8","select,insert,update,references","NULL","user_menu_list","kapitol_db1"
  507. "2","2","latin1","latin1_swedish_ci","NULL","NULL","PRI","iso","char(2)","char","NULL","NO","NULL","NULL","1","select,insert,update,references","NULL","country","kapitol_db1"
  508. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","STATISTICS","information_schema"
  509. "77","231","utf8","utf8_general_ci","NULL","NULL","NULL","DEFINER","varchar(77)","varchar","NULL","NO","NULL","NULL","7","select","NULL","VIEWS","information_schema"
  510. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_COLLATION","varchar(64)","varchar","NULL","YES","NULL","NULL","18","select","NULL","TABLES","information_schema"
  511. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","validity","int(1)","int","NULL","NO","10","0","8","select,insert,update,references","NULL","events","kapitol_db1"
  512. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","vacancies_section","kapitol_db1"
  513. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","region","int(2)","int","NULL","YES","10","0","11","select,insert,update,references","NULL","vacancies","kapitol_db1"
  514. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","information","text","text","NULL","NO","NULL","NULL","14","select,insert,update,references","NULL","vacancies","kapitol_db1"
  515. "255","765","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_COMMENT","varchar(255)","varchar","NULL","NO","NULL","NULL","19","select","NULL","COLUMNS","information_schema"
  516. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","start_date","date","date","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","events","kapitol_db1"
  517. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","name","varchar(100)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","sale","kapitol_db1"
  518. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(6)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","sale","kapitol_db1"
  519. "NULL","NULL","NULL","NULL","NULL","0","NULL","MAXLEN","bigint(3)","bigint","NULL","NO","19","0","4","select","NULL","CHARACTER_SETS","information_schema"
  520. "150","150","latin1","latin1_swedish_ci","NULL","NULL","NULL","title","varchar(150)","varchar","NULL","NO","NULL","NULL","6","select,insert,update,references","NULL","sale","kapitol_db1"
  521. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(2)","int","NULL","NO","10","0","1","select,insert,update,references","NULL","vacancies_country","kapitol_db1"
  522. "255","255","latin1","latin1_swedish_ci","NULL","NULL","NULL","description","varchar(255)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","img_library","kapitol_db1"
  523. "NULL","NULL","NULL","NULL","NULL","0","NULL","folder_id","tinyint(4)","tinyint","NULL","NO","3","0","2","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  524. "NULL","NULL","NULL","NULL","NULL","0000-00-00 00:00:00","NULL","creation_datetime","datetime","datetime","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","gallery_folders","kapitol_db1"
  525. "81","243","utf8","utf8_general_ci","NULL","NULL","NULL","GRANTEE","varchar(81)","varchar","NULL","NO","NULL","NULL","1","select","NULL","COLUMN_PRIVILEGES","information_schema"
  526. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","country","int(2)","int","NULL","YES","10","0","10","select,insert,update,references","NULL","vacancies","kapitol_db1"
  527. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","email","varchar(50)","varchar","NULL","NO","NULL","NULL","9","select,insert,update,references","NULL","professional_network","kapitol_db1"
  528. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","2","select","NULL","COLUMN_PRIVILEGES","information_schema"
  529. "250","250","latin1","latin1_swedish_ci","NULL","NULL","NULL","description","varchar(250)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","file_library","kapitol_db1"
  530. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","TABLE_PRIVILEGES","information_schema"
  531. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CREATED","datetime","datetime","NULL","YES","NULL","NULL","17","select","NULL","TRIGGERS","information_schema"
  532. "NULL","NULL","NULL","NULL","NULL","0","NULL","ACTION_ORDER","bigint(4)","bigint","NULL","NO","19","0","8","select","NULL","TRIGGERS","information_schema"
  533. "77","231","utf8","utf8_general_ci","NULL","NULL","NULL","DEFINER","varchar(77)","varchar","NULL","NO","NULL","NULL","20","select","NULL","ROUTINES","information_schema"
  534. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","7","select","NULL","KEY_COLUMN_USAGE","information_schema"
  535. "NULL","NULL","NULL","NULL","NULL","0000-00-00 00:00:00","NULL","date","datetime","datetime","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","usr_news_library","kapitol_db1"
  536. "60","60","latin1","latin1_swedish_ci","NULL","NULL","NULL","bandname","varchar(60)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","vacancies","kapitol_db1"
  537. "80","80","latin1","latin1_swedish_ci","NULL","NULL","NULL","printable_name","varchar(80)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","country","kapitol_db1"
  538. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","TABLE_PRIVILEGES","information_schema"
  539. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_GRANTABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","4","select","NULL","USER_PRIVILEGES","information_schema"
  540. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","2","select","NULL","SCHEMA_PRIVILEGES","information_schema"
  541. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(3)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","content_pages","kapitol_db1"
  542. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","TABLE_CONSTRAINTS","information_schema"
  543. "NULL","NULL","NULL","NULL","NULL","0000-00-00 00:00:00","NULL","LAST_ALTERED","datetime","datetime","NULL","NO","NULL","NULL","17","select","NULL","ROUTINES","information_schema"
  544. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","COLUMN_PRIVILEGES","information_schema"
  545. "150","150","latin1","latin1_swedish_ci","NULL","NULL","NULL","url","varchar(150)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","adverts","kapitol_db1"
  546. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","TABLE_CONSTRAINTS","information_schema"
  547. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","NUMERIC_SCALE","bigint(21)","bigint","NULL","YES","19","0","12","select","NULL","COLUMNS","information_schema"
  548. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","EXTERNAL_LANGUAGE","varchar(64)","varchar","NULL","YES","NULL","NULL","10","select","NULL","ROUTINES","information_schema"
  549. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CONTEXT_INVOLUNTARY","bigint(20)","bigint","NULL","YES","19","0","8","select","NULL","PROFILING","information_schema"
  550. "250","250","latin1","latin1_swedish_ci","NULL","NULL","NULL","filename","varchar(250)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","file_library","kapitol_db1"
  551. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","title","varchar(50)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","content_pages","kapitol_db1"
  552. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CPU_USER","decimal(9,6)","decimal","NULL","YES","9","6","5","select","NULL","PROFILING","information_schema"
  553. "10","30","utf8","utf8_general_ci","NULL","NULL","NULL","ROW_FORMAT","varchar(10)","varchar","NULL","YES","NULL","NULL","7","select","NULL","TABLES","information_schema"
  554. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","SQL_MODE","longtext","longtext","NULL","NO","NULL","NULL","18","select","NULL","TRIGGERS","information_schema"
  555. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLUMN_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","5","select","NULL","COLUMN_PRIVILEGES","information_schema"
  556. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","MESSAGES_SENT","bigint(20)","bigint","NULL","YES","19","0","11","select","NULL","PROFILING","information_schema"
  557. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","message","text","text","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","application_emails","kapitol_db1"
  558. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","DATA_LENGTH","bigint(21)","bigint","NULL","YES","19","0","10","select","NULL","TABLES","information_schema"
  559. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","main_story","text","text","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","usr_news_library","kapitol_db1"
  560. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","numcode","smallint(6)","smallint","NULL","YES","5","0","5","select,insert,update,references","NULL","country","kapitol_db1"
  561. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(4)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","professional_network","kapitol_db1"
  562. "NULL","NULL","NULL","NULL","NULL","0","NULL","NON_UNIQUE","bigint(1)","bigint","NULL","NO","19","0","4","select","NULL","STATISTICS","information_schema"
  563. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CHARACTER_SET_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","COLLATION_CHARACTER_SET_APPLICABILITY","information_schema"
  564. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","VIEWS","information_schema"
  565. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(2)","int","NULL","NO","10","0","1","select,insert,update,references","NULL","vacancies_region","kapitol_db1"
  566. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","CHECKSUM","bigint(21)","bigint","NULL","YES","19","0","19","select","NULL","TABLES","information_schema"
  567. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","newsID","int(4)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","usr_news_library","kapitol_db1"
  568. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","TABLE_CONSTRAINTS","information_schema"
  569. "16","48","utf8","utf8_general_ci","NULL","NULL","NULL","INDEX_TYPE","varchar(16)","varchar","NULL","NO","NULL","NULL","14","select","NULL","STATISTICS","information_schema"
  570. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","location","varchar(100)","varchar","NULL","NO","NULL","NULL","2","select,insert,update,references","NULL","events","kapitol_db1"
  571. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_COMMENT","varchar(64)","varchar","NULL","NO","NULL","NULL","19","select","NULL","ROUTINES","information_schema"
  572. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","AUTO_INCREMENT","bigint(21)","bigint","NULL","YES","19","0","14","select","NULL","TABLES","information_schema"
  573. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","short_description","text","text","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","events","kapitol_db1"
  574. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","filetype","varchar(50)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","adverts","kapitol_db1"
  575. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_GRANTABLE","varchar(3)","varchar","NULL","NO","NULL","NULL","5","select","NULL","SCHEMA_PRIVILEGES","information_schema"
  576. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","ROUTINE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","ROUTINES","information_schema"
  577. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","MAX_DATA_LENGTH","bigint(21)","bigint","NULL","YES","19","0","11","select","NULL","TABLES","information_schema"
  578. "4294967295","4294967295","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_CONDITION","longtext","longtext","NULL","YES","NULL","NULL","9","select","NULL","TRIGGERS","information_schema"
  579. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","title","int(150)","int","NULL","NO","10","0","2","select,insert,update,references","NULL","sale_categories","kapitol_db1"
  580. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","PRIVILEGE_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","SCHEMA_PRIVILEGES","information_schema"
  581. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","6","select","NULL","TABLE_CONSTRAINTS","information_schema"
  582. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(6)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","events","kapitol_db1"
  583. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","COLLATION_NAME","varchar(64)","varchar","NULL","YES","NULL","NULL","14","select","NULL","COLUMNS","information_schema"
  584. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","folder_id","int(4)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","gallery_folders","kapitol_db1"
  585. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","TABLE_CONSTRAINTS","information_schema"
  586. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","qualifications","varchar(100)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","professional_network","kapitol_db1"
  587. "50","50","latin1","latin1_swedish_ci","NULL","NULL","NULL","description","varchar(50)","varchar","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","adverts","kapitol_db1"
  588. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","photo_id","int(4)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","gallery_photos","kapitol_db1"
  589. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","type","int(2)","int","NULL","YES","10","0","9","select,insert,update,references","NULL","vacancies","kapitol_db1"
  590. "NULL","NULL","NULL","NULL","NULL","0","NULL","past","int(1)","int","NULL","NO","10","0","9","select,insert,update,references","NULL","events","kapitol_db1"
  591. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","validity","int(1)","int","NULL","NO","10","0","19","select,insert,update,references","NULL","professional_network","kapitol_db1"
  592. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","VIEWS","information_schema"
  593. "20","60","utf8","utf8_general_ci","NULL","NULL","NULL","SOURCE_FILE","varchar(20)","varchar","NULL","YES","NULL","NULL","17","select","NULL","PROFILING","information_schema"
  594. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","AVG_ROW_LENGTH","bigint(21)","bigint","NULL","YES","19","0","9","select","NULL","TABLES","information_schema"
  595. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","short_story","text","text","NULL","NO","NULL","NULL","3","select,insert,update,references","NULL","usr_news_library","kapitol_db1"
  596. "6","18","utf8","utf8_general_ci","NULL","NULL","NULL","ACTION_TIMING","varchar(6)","varchar","NULL","NO","NULL","NULL","12","select","NULL","TRIGGERS","information_schema"
  597. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","website","varchar(100)","varchar","NULL","NO","NULL","NULL","4","select,insert,update,references","NULL","vacancies","kapitol_db1"
  598. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","TABLES","information_schema"
  599. "NULL","NULL","NULL","NULL","NULL","0","NULL","SEQ_IN_INDEX","bigint(2)","bigint","NULL","NO","19","0","7","select","NULL","STATISTICS","information_schema"
  600. "100","100","latin1","latin1_swedish_ci","NULL","NULL","NULL","email","varchar(100)","varchar","NULL","NO","NULL","NULL","5","select,insert,update,references","NULL","vacancies","kapitol_db1"
  601. "65535","65535","latin1","latin1_swedish_ci","NULL","NULL","NULL","description","text","text","NULL","NO","NULL","NULL","7","select,insert,update,references","NULL","sale","kapitol_db1"
  602. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TRIGGER_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","TRIGGERS","information_schema"
  603. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","section","int(2)","int","NULL","YES","10","0","12","select,insert,update,references","NULL","vacancies","kapitol_db1"
  604. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","CHARACTER_SET_NAME","varchar(64)","varchar","NULL","YES","NULL","NULL","13","select","NULL","COLUMNS","information_schema"
  605. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(11)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","file_library","kapitol_db1"
  606. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TRIGGER_SCHEMA","varchar(64)","varchar","NULL","NO","NULL","NULL","2","select","NULL","TRIGGERS","information_schema"
  607. "NULL","NULL","NULL","NULL","NULL","NULL","PRI","id","int(2)","int","auto_increment","NO","10","0","1","select,insert,update,references","NULL","vacancies_type","kapitol_db1"
  608. "512","1536","utf8","utf8_general_ci","NULL","NULL","NULL","CONSTRAINT_CATALOG","varchar(512)","varchar","NULL","YES","NULL","NULL","1","select","NULL","KEY_COLUMN_USAGE","information_schema"
  609. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","DATA_FREE","bigint(21)","bigint","NULL","YES","19","0","13","select","NULL","TABLES","information_schema"
  610. "3","9","utf8","utf8_general_ci","NULL","NULL","NULL","IS_COMPILED","varchar(3)","varchar","NULL","NO","NULL","NULL","5","select","NULL","COLLATIONS","information_schema"
  611. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_TYPE","varchar(64)","varchar","NULL","NO","NULL","NULL","4","select","NULL","TABLES","information_schema"
  612. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","TABLE_NAME","varchar(64)","varchar","NULL","NO","NULL","NULL","3","select","NULL","COLUMNS","information_schema"
  613. "1","3","utf8","utf8_general_ci","NULL","NULL","NULL","COLLATION","varchar(1)","varchar","NULL","YES","NULL","NULL","9","select","NULL","STATISTICS","information_schema"
  614. "NULL","NULL","NULL","NULL","NULL","NULL","NULL","validity","int(1)","int","NULL","NO","10","0","16","select,insert,update,references","NULL","vacancies","kapitol_db1"
  615. "64","192","utf8","utf8_general_ci","NULL","NULL","NULL","EVENT_OBJECT_TABLE","varchar(64)","varchar","NULL","NO","NULL","NULL","7","select","NULL","TRIGGERS","information_schema"
  616.  
  617.  
  618.  
  619.  
  620.  
  621. ----------KEY_COLUMN_USAGE--------------
  622.  
  623. COLUMN_NAME,CONSTRAINT_CATALOG,CONSTRAINT_NAME,CONSTRAINT_SCHEMA,ORDINAL_POSITION,POSITION_IN_UNIQUE_CONSTRAINT,REFERENCED_COLUMN_NAME,REFERENCED_TABLE_NAME,REFERENCED_TABLE_SCHEMA,TABLE_CATALOG,TABLE_NAME,TABLE_SCHEMA
  624. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_section","kapitol_db1"
  625. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_region","kapitol_db1"
  626. "folder_id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","gallery_folders","kapitol_db1"
  627. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","sale","kapitol_db1"
  628. "iso","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","country","kapitol_db1"
  629. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","professional_network","kapitol_db1"
  630. "newsID","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","usr_news_library","kapitol_db1"
  631. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","content_pages","kapitol_db1"
  632. "newsID","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","usr_news_library","kapitol_db1"
  633. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","img_library","kapitol_db1"
  634. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies","kapitol_db1"
  635. "catID","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","sale_categories","kapitol_db1"
  636. "id","NULL","id_2","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_region","kapitol_db1"
  637. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_country","kapitol_db1"
  638. "id","NULL","id_3","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_region","kapitol_db1"
  639. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","content_pages","kapitol_db1"
  640. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_section","kapitol_db1"
  641. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","sale","kapitol_db1"
  642. "menu_id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","user_menu_list","kapitol_db1"
  643. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","file_library","kapitol_db1"
  644. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_type","kapitol_db1"
  645. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","img_library","kapitol_db1"
  646. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","events","kapitol_db1"
  647. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies","kapitol_db1"
  648. "photo_id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","gallery_photos","kapitol_db1"
  649. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_country","kapitol_db1"
  650. "id","NULL","PRIMARY","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","vacancies_type","kapitol_db1"
  651. "catID","NULL","catID","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","sale_categories","kapitol_db1"
  652. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","adverts","kapitol_db1"
  653. "id","NULL","id","kapitol_db1","1","NULL","NULL","NULL","NULL","NULL","events","kapitol_db1"
  654.  
  655.  
  656.  
  657.  
  658. ----------SCHEMA_PRIVILEGES-----------
  659.  
  660. GRANTEE,IS_GRANTABLE,PRIVILEGE_TYPE,TABLE_CATALOG,TABLE_SCHEMA
  661. "'kapitol_db1'@'localhost'","NO","INSERT","NULL","kapitol\_db1"
  662. "'kapitol_db1'@'localhost'","NO","EXECUTE","NULL","kapitol\_db1"
  663. "'kapitol_db1'@'localhost'","NO","INDEX","NULL","kapitol\_db1"
  664. "'kapitol_db1'@'localhost'","NO","CREATE","NULL","kapitol\_db1"
  665. "'kapitol_db1'@'localhost'","NO","DROP","NULL","kapitol\_db1"
  666. "'kapitol_db1'@'localhost'","NO","UPDATE","NULL","kapitol\_db1"
  667. "'kapitol_db1'@'localhost'","NO","CREATE TEMPORARY TABLES","NULL","kapitol\_db1"
  668. "'kapitol_db1'@'localhost'","NO","CREATE ROUTINE","NULL","kapitol\_db1"
  669. "'kapitol_db1'@'localhost'","NO","REFERENCES","NULL","kapitol\_db1"
  670. "'kapitol_db1'@'localhost'","NO","ALTER ROUTINE","NULL","kapitol\_db1"
  671. "'kapitol_db1'@'localhost'","NO","LOCK TABLES","NULL","kapitol\_db1"
  672. "'kapitol_db1'@'localhost'","NO","ALTER","NULL","kapitol\_db1"
  673. "'kapitol_db1'@'localhost'","NO","SELECT","NULL","kapitol\_db1"
  674. "'kapitol_db1'@'localhost'","NO","DELETE","NULL","kapitol\_db1"
  675.  
  676.  
  677.  
  678.  
  679. --------SCHEMATA----------
  680.  
  681. CATALOG_NAME,DEFAULT_CHARACTER_SET_NAME,DEFAULT_COLLATION_NAME,SCHEMA_NAME,SQL_PATH
  682. "NULL","latin1","latin1_swedish_ci","test","NULL"
  683. "NULL","latin1","latin1_swedish_ci","kapitol_db1","NULL"
  684. "NULL","utf8","utf8_general_ci","information_schema","NULL"
  685.  
  686.  
  687.  
  688.  
  689.  
  690. -------STATISTICS-----------
  691.  
  692. CARDINALITY,COLLATION,COLUMN_NAME,COMMENT,INDEX_NAME,INDEX_SCHEMA,INDEX_TYPE,NON_UNIQUE,NULLABLE,PACKED,SEQ_IN_INDEX,SUB_PART,TABLE_CATALOG,TABLE_NAME,TABLE_SCHEMA
  693. "8","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","professional_network","kapitol_db1"
  694. "6","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_type","kapitol_db1"
  695. "28","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","content_pages","kapitol_db1"
  696. "127","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","events","kapitol_db1"
  697. "6","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_country","kapitol_db1"
  698. "274","A","newsID","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","usr_news_library","kapitol_db1"
  699. "10","A","id","NULL","id_2","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_region","kapitol_db1"
  700. "127","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","events","kapitol_db1"
  701. "274","A","newsID","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","usr_news_library","kapitol_db1"
  702. "0","A","iso","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","country","kapitol_db1"
  703. "19","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies","kapitol_db1"
  704. "8","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","file_library","kapitol_db1"
  705. "269","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","img_library","kapitol_db1"
  706. "9","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_section","kapitol_db1"
  707. "269","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","img_library","kapitol_db1"
  708. "0","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","sale","kapitol_db1"
  709. "10","A","id","NULL","id_3","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_region","kapitol_db1"
  710. "1","A","catID","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","sale_categories","kapitol_db1"
  711. "28","A","id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","content_pages","kapitol_db1"
  712. "6","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_type","kapitol_db1"
  713. "15","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","adverts","kapitol_db1"
  714. "31","A","menu_id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","user_menu_list","kapitol_db1"
  715. "10","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_region","kapitol_db1"
  716. "28","A","photo_id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","gallery_photos","kapitol_db1"
  717. "0","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","sale","kapitol_db1"
  718. "1","A","folder_id","NULL","PRIMARY","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","gallery_folders","kapitol_db1"
  719. "1","A","catID","NULL","catID","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","sale_categories","kapitol_db1"
  720. "19","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies","kapitol_db1"
  721. "6","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_country","kapitol_db1"
  722. "9","A","id","NULL","id","kapitol_db1","BTREE","0","NULL","NULL","1","NULL","NULL","vacancies_section","kapitol_db1"
  723.  
  724.  
  725.  
  726.  
  727.  
  728.  
  729.  
  730. -----------TABLE_CONSTRAINTS-------------
  731.  
  732. CONSTRAINT_CATALOG,CONSTRAINT_NAME,CONSTRAINT_SCHEMA,CONSTRAINT_TYPE,TABLE_NAME,TABLE_SCHEMA
  733. "NULL","id","kapitol_db1","UNIQUE","vacancies_country","kapitol_db1"
  734. "NULL","id","kapitol_db1","UNIQUE","events","kapitol_db1"
  735. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","content_pages","kapitol_db1"
  736. "NULL","id","kapitol_db1","UNIQUE","vacancies_region","kapitol_db1"
  737. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","usr_news_library","kapitol_db1"
  738. "NULL","id","kapitol_db1","UNIQUE","sale","kapitol_db1"
  739. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","user_menu_list","kapitol_db1"
  740. "NULL","id","kapitol_db1","UNIQUE","vacancies","kapitol_db1"
  741. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","sale_categories","kapitol_db1"
  742. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","img_library","kapitol_db1"
  743. "NULL","id_3","kapitol_db1","UNIQUE","vacancies_region","kapitol_db1"
  744. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","file_library","kapitol_db1"
  745. "NULL","id","kapitol_db1","UNIQUE","professional_network","kapitol_db1"
  746. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","gallery_folders","kapitol_db1"
  747. "NULL","catID","kapitol_db1","UNIQUE","sale_categories","kapitol_db1"
  748. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","gallery_photos","kapitol_db1"
  749. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","events","kapitol_db1"
  750. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","vacancies","kapitol_db1"
  751. "NULL","id","kapitol_db1","UNIQUE","adverts","kapitol_db1"
  752. "NULL","id","kapitol_db1","UNIQUE","img_library","kapitol_db1"
  753. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","vacancies_country","kapitol_db1"
  754. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","vacancies_type","kapitol_db1"
  755. "NULL","id","kapitol_db1","UNIQUE","vacancies_type","kapitol_db1"
  756. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","sale","kapitol_db1"
  757. "NULL","id_2","kapitol_db1","UNIQUE","vacancies_region","kapitol_db1"
  758. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","vacancies_section","kapitol_db1"
  759. "NULL","id","kapitol_db1","UNIQUE","usr_news_library","kapitol_db1"
  760. "NULL","id","kapitol_db1","UNIQUE","content_pages","kapitol_db1"
  761. "NULL","PRIMARY","kapitol_db1","PRIMARY KEY","country","kapitol_db1"
  762. "NULL","id","kapitol_db1","UNIQUE","vacancies_section","kapitol_db1"
  763.  
  764.  
  765.  
  766.  
  767.  
  768. ---------TABLES----------
  769.  
  770. AUTO_INCREMENT,AVG_ROW_LENGTH,CHECK_TIME,CHECKSUM,CREATE_OPTIONS,CREATE_TIME,DATA_FREE,DATA_LENGTH,ENGINE,INDEX_LENGTH,MAX_DATA_LENGTH,ROW_FORMAT,TABLE_CATALOG,TABLE_COLLATION,TABLE_COMMENT,TABLE_NAME,TABLE_ROWS,TABLE_SCHEMA,TABLE_TYPE,UPDATE_TIME,VERSION
  771. "5","80","NULL","NULL","NULL","2009-02-19 14:44:07","0","80","MyISAM","2048","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","gallery_folders","1","kapitol_db1","BASE TABLE","2009-02-19 18:40:58","10"
  772. "NULL","732","NULL","NULL","NULL","2009-03-06 09:57:28","0","3660","MyISAM","1024","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","application_emails","5","kapitol_db1","BASE TABLE","2009-04-24 13:55:03","10"
  773. "NULL","576","NULL","NULL","max_rows=29127","NULL","0","0","MEMORY","0","16661376","Fixed","NULL","utf8_general_ci","NULL","CHARACTER_SETS","NULL","information_schema","SYSTEM VIEW","NULL","0"
  774. "50","202","NULL","NULL","NULL","2009-02-19 18:57:21","804","6468","MyISAM","2048","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","gallery_photos","28","kapitol_db1","BASE TABLE","2009-03-26 17:59:47","10"
  775. "NULL","2679","NULL","NULL","max_rows=6262","NULL","0","0","MEMORY","0","16770540","Fixed","NULL","utf8_general_ci","NULL","STATISTICS","NULL","information_schema","SYSTEM VIEW","NULL","0"
  776. "NULL","25","NULL","NULL","NULL","2009-03-23 16:36:47","0","232","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","vacancies_section","9","kapitol_db1","BASE TABLE","2009-03-23 16:37:00","10"
  777. "NULL","1986","NULL","NULL","max_rows=8447","NULL","0","0","MEMORY","0","16759854","Fixed","NULL","utf8_general_ci","NULL","USER_PRIVILEGES","NULL","information_schema","SYSTEM VIEW","NULL","0"
  778. "11","0","NULL","NULL","NULL","2009-04-24 14:07:25","764","764","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","sale","0","kapitol_db1","BASE TABLE","2011-04-03 03:27:40","10"
  779. "NULL","0","NULL","NULL","max_rows=7652","2011-07-17 19:21:20","0","0","MyISAM","1024","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","TRIGGERS","NULL","information_schema","SYSTEM VIEW","2011-07-17 19:21:20","0"
  780. "NULL","21","NULL","NULL","NULL","2009-03-23 16:37:21","0","128","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","vacancies_country","6","kapitol_db1","BASE TABLE","2009-03-23 16:37:35","10"
  781. "152","531","NULL","NULL","NULL","2009-03-16 11:53:25","0","67548","MyISAM","7168","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","events","127","kapitol_db1","BASE TABLE","2011-07-17 00:00:59","10"
  782. "NULL","2372","NULL","NULL","max_rows=7073","NULL","0","0","MEMORY","0","16748692","Fixed","NULL","utf8_general_ci","NULL","TABLE_PRIVILEGES","NULL","information_schema","SYSTEM VIEW","NULL","0"
  783. "288","5041","NULL","NULL","NULL","2010-01-28 15:46:04","0","1381332","MyISAM","9216","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","usr_news_library","274","kapitol_db1","BASE TABLE","2011-05-16 15:09:51","10"
  784. "NULL","423","NULL","NULL","max_rows=39662","NULL","0","0","MEMORY","0","16737264","Fixed","NULL","utf8_general_ci","NULL","COLLATIONS","NULL","information_schema","SYSTEM VIEW","NULL","0"
  785. "NULL","0","NULL","NULL","max_rows=9172","2011-07-17 19:21:14","0","0","MyISAM","1024","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","ROUTINES","NULL","information_schema","SYSTEM VIEW","2011-07-17 19:21:14","0"
  786. "NULL","22","NULL","NULL","NULL","2009-03-23 16:36:07","0","220","MyISAM","4096","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","vacancies_region","10","kapitol_db1","BASE TABLE","2009-03-23 16:36:21","10"
  787. "88","2967","NULL","NULL","NULL","2009-03-08 21:52:16","4556","28292","MyISAM","2048","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","professional_network","8","kapitol_db1","BASE TABLE","2009-06-15 13:19:22","10"
  788. "NULL","4637","NULL","NULL","max_rows=3618","NULL","0","0","MEMORY","0","16762755","Fixed","NULL","utf8_general_ci","NULL","KEY_COLUMN_USAGE","NULL","information_schema","SYSTEM VIEW","NULL","0"
  789. "NULL","2179","NULL","NULL","max_rows=7699","NULL","0","0","MEMORY","0","16767405","Fixed","NULL","utf8_general_ci","NULL","SCHEMA_PRIVILEGES","NULL","information_schema","SYSTEM VIEW","NULL","0"
  790. "97","773","NULL","NULL","NULL","2009-03-24 19:53:44","0","14692","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","vacancies","19","kapitol_db1","BASE TABLE","2011-07-13 00:58:54","10"
  791. "32","14424","NULL","NULL","NULL","2010-01-28 15:46:04","34388","438260","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","content_pages","28","kapitol_db1","BASE TABLE","2011-06-08 14:18:15","10"
  792. "284","216","NULL","NULL","NULL","2010-01-28 15:46:04","0","58212","MyISAM","9216","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","img_library","269","kapitol_db1","BASE TABLE","2011-02-09 11:45:28","10"
  793. "14","125","NULL","NULL","NULL","2010-01-28 15:46:04","0","1004","MyISAM","2048","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","file_library","8","kapitol_db1","BASE TABLE","2011-02-23 15:23:19","10"
  794. "70","92","NULL","NULL","NULL","2009-04-29 15:26:45","540","1924","MyISAM","2048","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","adverts","15","kapitol_db1","BASE TABLE","2011-02-22 15:44:50","10"
  795. "NULL","356","NULL","NULL","max_rows=47127","NULL","0","0","MEMORY","0","16590668","Fixed","NULL","utf8_general_ci","NULL","PROFILING","NULL","information_schema","SYSTEM VIEW","NULL","0"
  796. "NULL","0","NULL","NULL","max_rows=15073","2011-07-17 19:21:22","0","0","MyISAM","1024","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","VIEWS","NULL","information_schema","SYSTEM VIEW","2011-07-17 19:21:22","0"
  797. "33","66","NULL","NULL","NULL","2009-03-04 09:29:41","0","2076","MyISAM","2048","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","user_menu_list","31","kapitol_db1","BASE TABLE","2009-04-29 09:21:49","10"
  798. "NULL","0","NULL","NULL","NULL","2010-01-28 15:46:04","0","0","MyISAM","1024","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","country","0","kapitol_db1","BASE TABLE","2010-01-28 15:46:04","10"
  799. "NULL","3641","NULL","NULL","max_rows=4607","NULL","0","0","MEMORY","0","16763164","Fixed","NULL","utf8_general_ci","NULL","TABLES","NULL","information_schema","SYSTEM VIEW","NULL","0"
  800. "NULL","2504","NULL","NULL","max_rows=6700","NULL","0","0","MEMORY","0","16749256","Fixed","NULL","utf8_general_ci","NULL","TABLE_CONSTRAINTS","NULL","information_schema","SYSTEM VIEW","NULL","0"
  801. "NULL","2565","NULL","NULL","max_rows=6540","NULL","0","0","MEMORY","0","16757145","Fixed","NULL","utf8_general_ci","NULL","COLUMN_PRIVILEGES","NULL","information_schema","SYSTEM VIEW","NULL","0"
  802. "2","9","NULL","NULL","NULL","2009-04-21 10:46:34","0","9","MyISAM","3072","2533274790395903","Fixed","NULL","latin1_swedish_ci","NULL","sale_categories","1","kapitol_db1","BASE TABLE","2009-04-21 12:32:38","10"
  803. "NULL","387","NULL","NULL","max_rows=43351","NULL","0","0","MEMORY","0","16733880","Fixed","NULL","utf8_general_ci","NULL","COLLATION_CHARACTER_SET_APPLICABILITY","NULL","information_schema","SYSTEM VIEW","NULL","0"
  804. "NULL","3656","NULL","NULL","max_rows=4588","NULL","0","0","MEMORY","0","16755448","Fixed","NULL","utf8_general_ci","NULL","SCHEMATA","NULL","information_schema","SYSTEM VIEW","NULL","0"
  805. "NULL","0","NULL","NULL","max_rows=8715","2011-07-17 19:21:10","0","0","MyISAM","1024","281474976710655","Dynamic","NULL","utf8_general_ci","NULL","COLUMNS","NULL","information_schema","SYSTEM VIEW","2011-07-17 19:21:10","0"
  806. "7","21","NULL","NULL","NULL","2009-03-18 11:41:51","0","128","MyISAM","3072","281474976710655","Dynamic","NULL","latin1_swedish_ci","NULL","vacancies_type","6","kapitol_db1","BASE TABLE","2009-03-20 18:19:31","10"
  807.  
  808.  
  809.  
  810.  
  811.  
  812.  
  813.  
  814. ------------USER_PRIVILEGES-------------
  815.  
  816. GRANTEE,IS_GRANTABLE,PRIVILEGE_TYPE,TABLE_CATALOG
  817. "'kapitol_db1'@'localhost'","NO","USAGE","NULL"
  818.  
  819.  
  820.  
  821.  
  822.  
  823.  
  824.  
  825.  
  826.  
  827.  
  828. Wow
  829. -Neatstuffs
  830. http://www.twitter.com/Neatstuffs
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement