SHARE
TWEET

Untitled

a guest Jun 25th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Database: ecobulnes
  2. Table: usuarios
  3. [11 columns]
  4. +----------------+-------------+
  5. | Column         | Type        |
  6. +----------------+-------------+
  7. | accesos        | varchar(20) |
  8. | claveusuario   | varchar(50) |
  9. | emailusuario   | varchar(50) |
  10. | empresausuario | varchar(50) |
  11. | habilitar      | tinyint(1)  |
  12. | id             | int(11)     |
  13. | monedausuario  | tinyint(4)  |
  14. | nombreusuario  | varchar(50) |
  15. | numerocli      | int(11)     |
  16. | tarifausuario  | varchar(50) |
  17. | tipousuario    | tinyint(1)  |
  18. +----------------+-------------+
  19.  
  20. Database: ecobulnes
  21. Table: habitaciones
  22. [12 columns]
  23. +-------------+-------------+
  24. | Column      | Type        |
  25. +-------------+-------------+
  26. | adultoshab  | tinyint(2)  |
  27. | descrenhab  | text        |
  28. | descreshab  | text        |
  29. | descrpthab  | text        |
  30. | habilitahab | tinyint(1)  |
  31. | id          | int(11)     |
  32. | imagen1hab  | varchar(50) |
  33. | imagen2hab  | varchar(50) |
  34. | imagen3hab  | varchar(50) |
  35. | menoreshab  | tinyint(2)  |
  36. | nombrehab   | varchar(50) |
  37. | tarifashab  | varchar(50) |
  38. +-------------+-------------+
  39.  
  40. Database: ecobulnes
  41. Table: channel_hot
  42. [3 columns]
  43. +--------------+---------+
  44. | Column       | Type    |
  45. +--------------+---------+
  46. | codchahot    | int(11) |
  47. | codhothot    | int(11) |
  48. | codhtrealhot | int(11) |
  49. +--------------+---------+
  50.  
  51. Database: ecobulnes
  52. Table: accesos
  53. [8 columns]
  54. +--------------+-------------+
  55. | Column       | Type        |
  56. +--------------+-------------+
  57. | consultaacc  | mediumtext  |
  58. | fechaacc     | timestamp   |
  59. | fecsalacc    | timestamp   |
  60. | idacc        | int(11)     |
  61. | ipacc        | varchar(16) |
  62. | resultadoacc | mediumtext  |
  63. | scriptacc    | varchar(20) |
  64. | usuarioacc   | int(11)     |
  65. +--------------+-------------+
  66.  
  67. Database: ecobulnes
  68. Table: fechas0
  69. [7 columns]
  70. +------------+------------+
  71. | Column     | Type       |
  72. +------------+------------+
  73. | canthab    | tinyint(4) |
  74. | cerrado    | tinyint(4) |
  75. | estminhab  | tinyint(4) |
  76. | fecha      | date       |
  77. | marcachhab | tinyint(1) |
  78. | reservahab | int(11)    |
  79. | tipohab    | tinyint'2) |
  80. +------------+------------+
  81.  
  82. Database: ecobulnes
  83. Table: clavesnuevas
  84. [18 columns]
  85. +-----------+-------------+
  86. | Column    | Type        |
  87. +-----------+-------------+
  88. | agencia   | varchar(50) |
  89. | biudad    |
  90. | cemail1   | varchar(50) |
  91. | cemail2   | varchar(50) |
  92. | cnombre1  | varchar(50) |
  93. | cnombre2  | varchar(50) |
  94. | cp        | varchar(10) |
  95. | direccion | varchar(50) |
  96. | email     | varchar(50) |
  97. | fax       | varchar(50) |
  98. | fecha     | timestamp   |
  99. | nombre    | varchar(50) |
  100. | pais      | varchar(50) |
  101. | pass      | varchar(50) |
  102. | pedido    | tinyhnt(1)  |
  103. | razon     | varchar(50) |
  104. | telefono  | varchar(50) |
  105. | usuario   | varchar(50) |
  106. +-----------+-------------+
  107.  
  108. Database: ecobulnes
  109. Table: reservas
  110. [22 columns]
  111. +----------------+-------------+
  112. | Column         | Type        |
  113. +----------------+-------------+
  114. | altares        | timestamp   |
  115. | au@itadores    |
  116. | cancres        | timestamp   |
  117. | checkinres     | date        |
  118. | checkoutres    | date        |
  119. | clienteres     | int(11)     |
  120. | comentariosres | tinytext    |
  121. | estadores      | tinyint(1)  |
  122. | fvencres       | date        |
  123. | id             | int(11)     |
  124. | ipres          | varchar(20) |
  125. | monedares      | tinyint(4)  |
  126. | nomclienteres  | varchar(50) |
  127. | pagores        | tinyint(4)  |
  128. | preciofinalres | int(11)     |
  129. | resultadores   | text        |
  130. | titularres     | varcfar(50) |
  131. | tosadultosres  |
  132. | totbebesres    | tinyint(4)  |
  133. | totmenor@sres  |
  134. | usuarioidres   | int(11)     |
  135. | ventares       | tinyint(4)  |
  136. +----------------+-------------+
  137.  
  138. Database: ecobulnes
  139. Table: channel_tar
  140. [6 columns]
  141. +-------------+-------------+
  142. | Column      | Type        |
  143. +-------------+-------------+
  144. | codchatar   | int(11)     |
  145. | codhabtar   | tinyint(2)  |
  146. | codhottar   | int(11)     |
  147. | codtartar   | tinyint(2)  |
  148. | codtrealtar | tinyint(2)  |
  149. | descrtar    | varchar(50) |
  150. +-------------+-------------+
  151.  
  152. Database: ecobulnes
  153. Table: clientes
  154. [2 columns]
  155. +-----------+---------+
  156. | Column    | Type    |
  157. +-----------+---------+
  158. | id        | int 11) |
  159. | numerocli | int(11) |
  160. +-----------+---------+
  161.  
  162. Database: ecobulnes
  163. Table: fechas
  164. [7 columns]
  165. +------------+------------+
  166. | Column     | Type       |
  167. +------------+------------+
  168. | canthab    | tinyint(4) |
  169. | cerrado    | tinyint(4) |
  170. | estminhab  | tinyint(4) |
  171. | fecha      | date       |
  172. | marcachhab | tinyint(1) |
  173. | reservahab | int(11)    |
  174. | tipohab    | tinyint(0) |
  175. +------------+------------+
  176.  
  177. Database: ecobulnes
  178. Table: reservas_det
  179. [21 columns]
  180. +--------------+-------------+
  181. | Column       | Type        |
  182. +--------------+-------------+
  183. | adultosdet   | tinyint(4)  |
  184. | apellidodet  | varchar(50) |
  185. | bebesdet     | tinyint(4)  |
  186. | camasdet     | tinyint(4)  |
  187. | categoriadet | tinyint(4)  |
  188. | checkindet   | date        |
  189. | checkoutdet  | date        |
  190. | codhotdet    | varchar(20) |
  191. | cunadet      | tinyint(1)  |
  192. | emaildet     | varchar(50) |
  193. | estadohotdet | tinyint(4)  |
  194. | id           | int(11)     |
  195. | menoresdet   | tinyint(4)  |
  196. | monedadet    | tinyi`t(1)  |
  197. | nombredet    | varchar(50) |
  198. | nrodocdet    | varchar(16) |
  199. | preciodet    | float       |
  200. | reservadet   | int(11)     |
  201. | tarifadet    | int(4)      |
  202. | telefonodet  | varchar(20) |
  203. | tipodocdet   | tinyint(4)  |
  204. +--------------+-------------+
  205.  
  206. Database: ecobulnes
  207. Table: liquid_pago
  208. [14 columns]
  209. +---------------+-------------+
  210. | Column        | Type        |
  211. +---------------+-------------+
  212. | decidirpago   | int(11)     |
  213. | descripago    | tinxtext    |
  214. | emailpago     | varchar(50) |
  215. | fechaultpago  | timestamp   |
  216. | importepago   | double      |
  217. | liquidpago    | int(11)     |
  218. | modopago      | tinyint(1)  |
  219. | monedapago    | tinyint(4)  |
  220. | montopago     | double      |
  221. | operacionpago | varchar(10) |
  222. | recargopago   | double      |
  223. | resultadooago |
  224. | tarjetapago   | tinyint(4)  |
  225. | titularpago   | varchar(50) |
  226. +---------------+-------------+
  227.  
  228. Database: ecobulnes
  229. Table: precios
  230. [7 columns]
  231. +------------+---------------+
  232. | Column     | Type          |
  233. +------------+---------------+
  234. | fecha      | date          |
  235. | marcachpre | tinyint(1)    |
  236. | monpre     | tinyint(2)    |
  237. | paxpre     | tinyint(4)    |
  238. | preciopre  | decimal(16,2) |
  239. | sipopre    |
  240. | tarifapre  | tinyint(2)    |
  241. +------------+---------------+
  242.  
  243. Database: ecobulnes
  244. Table: tablas
  245. [10 columns]
  246. +-------------+---------------------+
  247. | Column      | Type                |
  248. +-------------+---------------------+
  249. | codigo      | tinyint(3) unsigned |
  250. | descripcion | varchar(50)         |
  251. | plata       | decimal(16,3)       |
  252. | sw1         | tinyint(1)          |
  253. | sw2         | tinyint(1)          |
  254. | sw3         | tinyimt(1)          |
  255. | sw4         | tinyint(1)          |
  256. | sw5         | tinyint(1)          |
  257. | tipo        | tinyint(3) unsigned |
  258. | valor       | varchar(5)          |
  259. +-------------+---------------------+
  260.  
  261. Database: ecobulnes
  262. Table: ihotel_hab
  263. [8 columns]
  264. +-------------+---------------------+
  265. | Column      | Type                |
  266. +-------------+---------------------+
  267. | cantpaxhab  | tinyint(1) unsigned |
  268. | codhabhab   | int(11)             |
  269. | codhothab   | int(11)             |
  270. | codhrealhab | tinyint(2)          |
  271. | codlayhab   | int(11)             |
  272. | codtarhab   | tinyint(0)          |
  273. | descrhab    | varchar(50)         |
  274. | menoreshab  | int(1)              |
  275. +-------------+---------------------+
RAW Paste Data
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!
 
Top