API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.95 KB | None | 0 0
raw download clone embed print report
  1. Database: ptpoa
  2. Table: cadastro
  3. [12 columns]
  4. +----------+--------------+
  5. | Column | Type |
  6. +----------+--------------+
  7. | bol | int(1) |
  8. | cep | varchar(12) |
  9. | cidade | varchar(255) |
  10. | confirma | varchar(255) |
  11. | email | varchar(255) |
  12. | fone | varchar(60) |
  13. | id | int(10) |
  14. | ip | varchar(30) |
  15. | nome | varchar(255) |
  16. | num | varchar(35) |
  17. | rua | varchar(255) |
  18. | uf | varchar(5) |
  19. +----------+--------------+
  20.  
  21. Database: ptpoa
  22. Table: txt_img
  23. [3 columns]
  24. +------------+---------+
  25. | Column | Type |
  26. +------------+---------+
  27. | id_img | int(10) |
  28. | id_txt | int(10) |
  29. | id_txt_img | int(10) |
  30. +------------+---------+
  31.  
  32. Database: ptpoa
  33. Table: agenda
  34. [8 columns]
  35. +-----------+--------------+
  36. | Column | Type |
  37. +-----------+--------------+
  38. | local | varchar(255) |
  39. | data | date |
  40. | descricao | text |
  41. | evento | varchar(255) |
  42. | hora | time |
  43. | id_agenda | int(11) |
  44. | obs | text |
  45. | tema | varchar(255) |
  46. +-----------+--------------+
  47.  
  48. Database: ptpoa
  49. Table: img
  50. [17 columns]
  51. +----------+--------------+
  52. | Column | Type |
  53. +----------+--------------+
  54. | ano | int(4) |
  55. | arquivo | varchar(255) |
  56. | credito | varchar(150) |
  57. | data | date |
  58. | data_alt | datetime |
  59. | dia | int(2) |
  60. | filename | varchar(200) |
  61. | hora | time |
  62. | id_img | int(10) |
  63. | image | varchar(250) |
  64. | ip | varchar(50) |
  65. | legenda | varchar(255) |
  66. | mes | int(2) |
  67. | obs | text |
  68. | tamanho | varchar(255) |
  69. | tipoid | varchar(255) |
  70. | ver | varchar(20) |
  71. +----------+--------------+
  72.  
  73. Database: ptpoa
  74. Table: wp_posts
  75. [24 columns]
  76. +-----------------------+------------------------------------------------------------------+
  77. | Column | Type |
  78. +-----------------------+------------------------------------------------------------------+
  79. | comment_count | bigint(20) |
  80. | comment_status | enum('open','closed','registered_only') |
  81. | guid | varchar(255) |
  82. | ID | bigint(20) unsigned |
  83. | menu_order | int(11) |
  84. | ping_status | enum('open','closed') |
  85. | pinged | text |
  86. | post_author | bigint(20) |
  87. | post_category | int(4) |
  88. | post_content | longtext |
  89. | post_content_filtered | text |
  90. | post_date | datetime |
  91. | post_date_gmt | datetime |
  92. | post_excerpt | text |
  93. | post_mime_type | varchar(100) |
  94. | post_modified | datetime |
  95. | post_modified_gmt | datetime |
  96. | post_name | varchar(200) |
  97. | post_parent | bigint(20) |
  98. | post_password | varchar(20) |
  99. | post_status | enum('publish','draft','private','static','object','attachment') |
  100. | post_title | text |
  101. | post_type | varchar(100) |
  102. | to_ping | text |
  103. +-----------------------+------------------------------------------------------------------+
  104.  
  105. Database: ptpoa
  106. Table: wp_users
  107. [10 columns]
  108. +---------------------+---------------------+
  109. | Column | Type |
  110. +---------------------+---------------------+
  111. | display_name | varchar(250) |
  112. | ID | bigint(20) unsigned |
  113. | user_activation_key | varchar(60) |
  114. | user_email | varchar(100) |
  115. | user_login | varchar(60) |
  116. | user_nicename | varchar(50) |
  117. | user_pass | varchar(64) |
  118. | user_registered | datetime |
  119. | user_status | int(11) |
  120. | user_url | varchar(100) |
  121. +---------------------+---------------------+
  122.  
  123. Database: ptpoa
  124. Table: wp_links
  125. [14 columns]
  126. +------------------+---------------+
  127. | Column | Type |
  128. +------------------+---------------+
  129. | link_category | bigint(20) |
  130. | link_description | varchar(255) |
  131. | link_id | bigint(20) |
  132. | link_image | varchar(255) |
  133. | link_name | varchar(255) |
  134. | link_notes | mediumtext |
  135. | link_owner | int(11) |
  136. | link_rating | int(11) |
  137. | link_rel | varchar(255) |
  138. | link_rss | varchar(255) |
  139. | link_target | varchar(25) |
  140. | link_updated | datetime |
  141. | link_url | varchar(255) |
  142. | link_visible | enum('Y','N') |
  143. +------------------+---------------+
  144.  
  145. Database: ptpoa
  146. Table: wp_comments
  147. [15 columns]
  148. +----------------------+----------------------+
  149. | Column | Type |
  150. +----------------------+----------------------+
  151. | comment_agent | varchar(255) |
  152. | comment_approved | enum('0','1','spam') |
  153. | comment_author | tinytext |
  154. | comment_author_email | varchar(100) |
  155. | comment_author_IP | varchar(100) |
  156. | comment_author_url | varchar(200) |
  157. | comment_content | text |
  158. | comment_date | datetime |
  159. | comment_date_gmt | datetime |
  160. | comment_ID | bigint(20) unsigned |
  161. | comment_karma | int(11) |
  162. | comment_parent | bigint(20) |
  163. | comment_post_ID | int(11) |
  164. | comment_type | varchar(20) |
  165. | user_id | bigint(20) |
  166. +----------------------+----------------------+
  167.  
  168. Database: ptpoa
  169. Table: wp_post2cat
  170. [3 columns]
  171. +-------------+------------+
  172. | Column | Type |
  173. +-------------+------------+
  174. | category_id | bigint(20) |
  175. | post_id | bigint(20) |
  176. | rel_id | bigint(20) |
  177. +-------------+------------+
  178.  
  179. Database: ptpoa
  180. Table: wp_options
  181. [11 columns]
  182. +---------------------+------------------+
  183. | Column | Type |
  184. +---------------------+------------------+
  185. | autoload | enum('yes','no') |
  186. | blog_id | int(11) |
  187. | option_admin_level | int(11) |
  188. | option_can_override | enum('Y','N') |
  189. | option_description | tinytext |
  190. | option_height | int(11) |
  191. | option_id | bigint(20) |
  192. | option_name | varchar(64) |
  193. | option_type | int(11) |
  194. | option_value | longtext |
  195. | option_width | int(11) |
  196. +---------------------+------------------+
  197.  
  198. Database: ptpoa
  199. Table: wp_usermeta
  200. [4 columns]
  201. +------------+--------------+
  202. | Column | Type |
  203. +------------+--------------+
  204. | meta_key | varchar(255) |
  205. | meta_value | longtext |
  206. | umeta_id | bigint(20) |
  207. | user_id | bigint(20) |
  208. +------------+--------------+
  209.  
  210. Database: ptpoa
  211. Table: wp_linkcategories
  212. [13 columns]
  213. +------------------+---------------+
  214. | Column | Type |
  215. +------------------+---------------+
  216. | auto_toggle | enum('Y','N') |
  217. | cat_id | bigint(20) |
  218. | cat_name | tinytext |
  219. | list_limit | int(11) |
  220. | show_description | enum('Y','N') |
  221. | show_images | enum('Y','N') |
  222. | show_rating | enum('Y','N') |
  223. | show_updated | enum('Y','N') |
  224. | sort_desc | enum('Y','N') |
  225. | sort_order | varchar(64) |
  226. | text_after_all | varchar(128) |
  227. | text_after_link | varchar(128) |
  228. | text_before_link | varchar(128) |
  229. +------------------+---------------+
  230.  
  231. Database: ptpoa
  232. Table: wp_postmeta
  233. [4 columns]
  234. +------------+--------------+
  235. | Column | Type |
  236. +------------+--------------+
  237. | meta_id | bigint(20) |
  238. | meta_key | varchar(255) |
  239. | meta_value | longtext |
  240. | post_id | bigint(20) |
  241. +------------+--------------+
  242.  
  243. Database: ptpoa
  244. Table: wp_categories
  245. [6 columns]
  246. +----------------------+--------------+
  247. | Column | Type |
  248. +----------------------+--------------+
  249. | cat_ID | bigint(20) |
  250. | cat_name | varchar(55) |
  251. | category_count | bigint(20) |
  252. | category_description | longtext |
  253. | category_nicename | varchar(200) |
  254. | category_parent | bigint(20) |
  255. +----------------------+--------------+
  256.  
  257. Database: ptpoa
  258. Table: vereadores
  259. [19 columns]
  260. +-----------+--------------+
  261. | Column | Type |
  262. +-----------+--------------+
  263. | ass_imp | varchar(255) |
  264. | cargo | varchar(255) |
  265. | cel_imp | varchar(255) |
  266. | celular | varchar(80) |
  267. | cidade | varchar(255) |
  268. | comissoes | varchar(255) |
  269. | curriculo | text |
  270. | email | varchar(255) |
  271. | email_imp | varchar(255) |
  272. | fax | varchar(80) |
  273. | fone | varchar(80) |
  274. | foto_dep | varchar(30) |
  275. | gabinete | varchar(255) |
  276. | id | int(10) |
  277. | nasc | varchar(50) |
  278. | nome | varchar(255) |
  279. | nome_res | varchar(255) |
  280. | votos | varchar(50) |
  281. | web | varchar(255) |
  282. +-----------+--------------+
  283.  
  284. Database: ptpoa
  285. Table: txt
  286. [20 columns]
  287. +----------+--------------+
  288. | Column | Type |
  289. +----------+--------------+
  290. | ano | int(4) |
  291. | cidade | varchar(255) |
  292. | data | date |
  293. | data_alt | datetime |
  294. | destaque | varchar(8) |
  295. | dia | int(2) |
  296. | email | varchar(255) |
  297. | estado | varchar(5) |
  298. | hora | time |
  299. | id_tipo | int(4) |
  300. | id_txt | int(10) |
  301. | ip | varchar(50) |
  302. | lide | text |
  303. | mes | int(2) |
  304. | nome | varchar(255) |
  305. | sub | varchar(255) |
  306. | texto | text |
  307. | tipo | varchar(5) |
  308. | titulo | varchar(255) |
  309. | ver | char(3) |
  310. +----------+--------------+
  311.  
  312.  
  313. BAY FLETI
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!