Database: ecobulnes
Table: usuarios
[11 columns]
+----------------+-------------+
| Column         | Type        |
+----------------+-------------+
| accesos        | varchar(20) |
| claveusuario   | varchar(50) |
| emailusuario   | varchar(50) |
| empresausuario | varchar(50) |
| habilitar      | tinyint(1)  |
| id             | int(11)     |
| monedausuario  | tinyint(4)  |
| nombreusuario  | varchar(50) |
| numerocli      | int(11)     |
| tarifausuario  | varchar(50) |
| tipousuario    | tinyint(1)  |
+----------------+-------------+

Database: ecobulnes
Table: habitaciones
[12 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| adultoshab  | tinyint(2)  |
| descrenhab  | text        |
| descreshab  | text        |
| descrpthab  | text        |
| habilitahab | tinyint(1)  |
| id          | int(11)     |
| imagen1hab  | varchar(50) |
| imagen2hab  | varchar(50) |
| imagen3hab  | varchar(50) |
| menoreshab  | tinyint(2)  |
| nombrehab   | varchar(50) |
| tarifashab  | varchar(50) |
+-------------+-------------+

Database: ecobulnes
Table: channel_hot
[3 columns]
+--------------+---------+
| Column       | Type    |
+--------------+---------+
| codchahot    | int(11) |
| codhothot    | int(11) |
| codhtrealhot | int(11) |
+--------------+---------+

Database: ecobulnes
Table: accesos
[8 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| consultaacc  | mediumtext  |
| fechaacc     | timestamp   |
| fecsalacc    | timestamp   |
| idacc        | int(11)     |
| ipacc        | varchar(16) |
| resultadoacc | mediumtext  |
| scriptacc    | varchar(20) |
| usuarioacc   | int(11)     |
+--------------+-------------+

Database: ecobulnes
Table: fechas0
[7 columns]
+------------+------------+
| Column     | Type       |
+------------+------------+
| canthab    | tinyint(4) |
| cerrado    | tinyint(4) |
| estminhab  | tinyint(4) |
| fecha      | date       |
| marcachhab | tinyint(1) |
| reservahab | int(11)    |
| tipohab    | tinyint'2) |
+------------+------------+

Database: ecobulnes
Table: clavesnuevas
[18 columns]
+-----------+-------------+
| Column    | Type        |
+-----------+-------------+
| agencia   | varchar(50) |
| biudad    |
| cemail1   | varchar(50) |
| cemail2   | varchar(50) |
| cnombre1  | varchar(50) |
| cnombre2  | varchar(50) |
| cp        | varchar(10) |
| direccion | varchar(50) |
| email     | varchar(50) |
| fax       | varchar(50) |
| fecha     | timestamp   |
| nombre    | varchar(50) |
| pais      | varchar(50) |
| pass      | varchar(50) |
| pedido    | tinyhnt(1)  |
| razon     | varchar(50) |
| telefono  | varchar(50) |
| usuario   | varchar(50) |
+-----------+-------------+

Database: ecobulnes
Table: reservas
[22 columns]
+----------------+-------------+
| Column         | Type        |
+----------------+-------------+
| altares        | timestamp   |
| au@itadores    |
| cancres        | timestamp   |
| checkinres     | date        |
| checkoutres    | date        |
| clienteres     | int(11)     |
| comentariosres | tinytext    |
| estadores      | tinyint(1)  |
| fvencres       | date        |
| id             | int(11)     |
| ipres          | varchar(20) |
| monedares      | tinyint(4)  |
| nomclienteres  | varchar(50) |
| pagores        | tinyint(4)  |
| preciofinalres | int(11)     |
| resultadores   | text        |
| titularres     | varcfar(50) |
| tosadultosres  |
| totbebesres    | tinyint(4)  |
| totmenor@sres  |
| usuarioidres   | int(11)     |
| ventares       | tinyint(4)  |
+----------------+-------------+

Database: ecobulnes
Table: channel_tar
[6 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| codchatar   | int(11)     |
| codhabtar   | tinyint(2)  |
| codhottar   | int(11)     |
| codtartar   | tinyint(2)  |
| codtrealtar | tinyint(2)  |
| descrtar    | varchar(50) |
+-------------+-------------+

Database: ecobulnes
Table: clientes
[2 columns]
+-----------+---------+
| Column    | Type    |
+-----------+---------+
| id        | int 11) |
| numerocli | int(11) |
+-----------+---------+

Database: ecobulnes
Table: fechas
[7 columns]
+------------+------------+
| Column     | Type       |
+------------+------------+
| canthab    | tinyint(4) |
| cerrado    | tinyint(4) |
| estminhab  | tinyint(4) |
| fecha      | date       |
| marcachhab | tinyint(1) |
| reservahab | int(11)    |
| tipohab    | tinyint(0) |
+------------+------------+

Database: ecobulnes
Table: reservas_det
[21 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| adultosdet   | tinyint(4)  |
| apellidodet  | varchar(50) |
| bebesdet     | tinyint(4)  |
| camasdet     | tinyint(4)  |
| categoriadet | tinyint(4)  |
| checkindet   | date        |
| checkoutdet  | date        |
| codhotdet    | varchar(20) |
| cunadet      | tinyint(1)  |
| emaildet     | varchar(50) |
| estadohotdet | tinyint(4)  |
| id           | int(11)     |
| menoresdet   | tinyint(4)  |
| monedadet    | tinyi`t(1)  |
| nombredet    | varchar(50) |
| nrodocdet    | varchar(16) |
| preciodet    | float       |
| reservadet   | int(11)     |
| tarifadet    | int(4)      |
| telefonodet  | varchar(20) |
| tipodocdet   | tinyint(4)  |
+--------------+-------------+

Database: ecobulnes
Table: liquid_pago
[14 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| decidirpago   | int(11)     |
| descripago    | tinxtext    |
| emailpago     | varchar(50) |
| fechaultpago  | timestamp   |
| importepago   | double      |
| liquidpago    | int(11)     |
| modopago      | tinyint(1)  |
| monedapago    | tinyint(4)  |
| montopago     | double      |
| operacionpago | varchar(10) |
| recargopago   | double      |
| resultadooago |
| tarjetapago   | tinyint(4)  |
| titularpago   | varchar(50) |
+---------------+-------------+

Database: ecobulnes
Table: precios
[7 columns]
+------------+---------------+
| Column     | Type          |
+------------+---------------+
| fecha      | date          |
| marcachpre | tinyint(1)    |
| monpre     | tinyint(2)    |
| paxpre     | tinyint(4)    |
| preciopre  | decimal(16,2) |
| sipopre    |
| tarifapre  | tinyint(2)    |
+------------+---------------+

Database: ecobulnes
Table: tablas
[10 columns]
+-------------+---------------------+
| Column      | Type                |
+-------------+---------------------+
| codigo      | tinyint(3) unsigned |
| descripcion | varchar(50)         |
| plata       | decimal(16,3)       |
| sw1         | tinyint(1)          |
| sw2         | tinyint(1)          |
| sw3         | tinyimt(1)          |
| sw4         | tinyint(1)          |
| sw5         | tinyint(1)          |
| tipo        | tinyint(3) unsigned |
| valor       | varchar(5)          |
+-------------+---------------------+

Database: ecobulnes
Table: ihotel_hab
[8 columns]
+-------------+---------------------+
| Column      | Type                |
+-------------+---------------------+
| cantpaxhab  | tinyint(1) unsigned |
| codhabhab   | int(11)             |
| codhothab   | int(11)             |
| codhrealhab | tinyint(2)          |
| codlayhab   | int(11)             |
| codtarhab   | tinyint(0)          |
| descrhab    | varchar(50)         |
| menoreshab  | int(1)              |
+-------------+---------------------+