Skip to content

Instantly share code, notes, and snippets.

@jnmronquillo

jnmronquillo/change-log-posweb.xml

Created April 11, 2013 02:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jnmronquillo/5360300 to your computer and use it in GitHub Desktop.
Save jnmronquillo/5360300 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
change-log-posweb.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
<changeSet author="juan" id="1">
<createTable tableName="actualstocks">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="actualstocks_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER"/>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="inicial" type="INTEGER"/>
<column name="ingreso" type="INTEGER"/>
<column name="salida" type="INTEGER"/>
<column name="venta" type="INTEGER"/>
<column name="separacion" type="INTEGER"/>
<column name="final" type="INTEGER"/>
<column name="entrada" type="INTEGER"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="2">
<createTable tableName="balancetiendas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="balancetiendas_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER"/>
<column name="saldoinicial" type="NUMERIC(10,2)"/>
<column name="ingresoseparaciones" type="NUMERIC(10,2)"/>
<column name="ingresoventas" type="NUMERIC(10,2)"/>
<column name="gastos" type="NUMERIC(10,2)"/>
<column name="balance" type="NUMERIC(10,2)"/>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="3">
<createTable tableName="cajainiciales">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="balancetiendas_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="saldoinicial" type="NUMERIC(10,2)" defaultValueNumeric="0.00">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="4">
<createTable tableName="clientes">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="clientes_pkey" nullable="false"/>
</column>
<column name="apellidos" type="VARCHAR(40)"/>
<column name="nombres" type="VARCHAR(40)"/>
<column name="ruc" type="VARCHAR(11)"/>
<column name="telefono" type="VARCHAR(15)"/>
<column name="celular" type="VARCHAR(20)"/>
<column name="email" type="VARCHAR(50)"/>
<column name="razonsocial" type="VARCHAR(50)"/>
<column name="dni" type="VARCHAR(8)"/>
<column name="tipocliente_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="puntosacumulados" type="INTEGER"/>
<column name="montoacumulado" type="NUMERIC(10,2)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="5">
<createTable tableName="colores">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="colores_pk" nullable="false"/>
</column>
<column name="codigo" type="VARCHAR(30)"/>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="6">
<createTable tableName="detalleseparaciones">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="detalleseparaciones_pkey" nullable="false"/>
</column>
<column name="separacion_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cantidad" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="subtotal" type="NUMERIC(10,2)"/>
<column name="preciounitario" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="7">
<createTable tableName="detalleventas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="detalleventas_pkey" nullable="false"/>
</column>
<column name="venta_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cantidad" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="subtotal" type="NUMERIC(10,2)"/>
<column name="preciounitario" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
<column name="descuento" type="NUMERIC(10,2)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="8">
<createTable tableName="direccionclientes">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="direccionclientes_pk" nullable="false"/>
</column>
<column name="pais_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="ubigeo_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cliente_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="direccion" type="VARCHAR(150)"/>
<column name="ciudad" type="VARCHAR(50)"/>
<column name="referencias" type="VARCHAR(250)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="9">
<createTable tableName="disenios">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="disenios_pk" nullable="false"/>
</column>
<column name="codigo" type="VARCHAR(30)"/>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="10">
<createTable tableName="estadoseparaciones">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="estadoseparaciones_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(80)">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="11">
<createTable tableName="estadoventas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="estadoventas_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="12">
<createTable tableName="gastos">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="gastos_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(200)">
<constraints nullable="false"/>
</column>
<column name="monto" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="numero" type="VARCHAR(50)"/>
<column name="observaciones" type="VARCHAR(200)"/>
<column name="tipodocumento_id" type="INTEGER">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="13">
<createTable tableName="ingresostocks">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="ingresostocks_pkey" nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="proveedor_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cantidad" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="14">
<createTable tableName="marcas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="marcas_pk" nullable="false"/>
</column>
<column name="codigo" type="VARCHAR(30)"/>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="15">
<createTable tableName="menu_roles">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="menus_roles_pkey" nullable="false"/>
</column>
<column name="menu_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="rol_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="permitido" type="TINYINT" defaultValueNumeric="1"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="16">
<createTable tableName="menu_usuarios">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="menus_usuarios_pkey" nullable="false"/>
</column>
<column name="menu_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="usuario_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="permitido" type="TINYINT" defaultValueNumeric="1"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="17">
<createTable tableName="menus">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="menus_pkey" nullable="false"/>
</column>
<column name="menu" type="VARCHAR(30)">
<constraints nullable="false"/>
</column>
<column name="parametro" type="VARCHAR(20)"/>
<column name="parent_id" type="INTEGER" />
<column name="haschildren" type="TINYINT"/>
<column name="tipo" type="INTEGER" defaultValueNumeric="1"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="18">
<createTable tableName="modeloprendas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="modeloprendas_pkey" nullable="false"/>
</column>
<column name="tipoprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="codigo" type="VARCHAR(30)">
<constraints nullable="false"/>
</column>
<column name="nombre" type="VARCHAR(60)">
<constraints nullable="false"/>
</column>
<column name="stock" type="INTEGER" defaultValueNumeric="0">
<constraints nullable="false"/>
</column>
<column name="precioventa" type="NUMERIC(10,2)"/>
<column name="tela_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="talla_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="color_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="disenio_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="marca_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="codigogenerico" type="VARCHAR(30)"/>
<column name="precioetiqueta" type="NUMERIC(10,2)"/>
<column name="serieprenda" type="VARCHAR(10)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="19">
<createTable tableName="movimientoentradas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="movimientoentradas_pkey" nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tiendaorigen_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cantidad" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="movimientosalida_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="numero" type="VARCHAR(20)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="20">
<createTable tableName="movimientosalidas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="movimientosalidas_pkey" nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tiendadestino_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cantidad" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="recepcionado" type="TINYINT"/>
<column name="numero" type="VARCHAR(20)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="21">
<createTable tableName="pagoseparaciones">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="pagoseparaciones_pkey" nullable="false"/>
</column>
<column name="separacion_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="monto" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="hora" type="TIME"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="22">
<createTable tableName="paises">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="paises_pk" nullable="false"/>
</column>
<column name="codigo" type="CHAR(5)"/>
<column name="pais" type="VARCHAR(50)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="23">
<createTable tableName="privilegios">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="privilegios_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(40)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="24">
<createTable tableName="proveedores">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="proveedores_pk" nullable="false"/>
</column>
<column name="razonsocial" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
<column name="representantelegal" type="VARCHAR(80)"/>
<column name="ruc" type="VARCHAR(11)">
<constraints nullable="false"/>
</column>
<column name="dni" type="VARCHAR(8)"/>
<column name="telefono" type="VARCHAR(15)"/>
<column name="celular" type="VARCHAR(15)"/>
<column name="direccion" type="VARCHAR(60)"/>
<column name="email" type="VARCHAR(20)"/>
<column name="descripcion" type="VARCHAR(200)"/>
<column name="tipoproveedor_id" type="INTEGER">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="25">
<createTable tableName="roles">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="roles_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="parent_id" type="INTEGER" />
<column name="haschildren" type="TINYINT"/>
<column name="hasusers" type="TINYINT"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="26">
<createTable tableName="separaciones">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="separaciones_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cliente_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tipodocumento_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="estadoseparacion_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="saldo" type="NUMERIC(10,2)"/>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="fechavencimiento" type="DATE">
<constraints nullable="false"/>
</column>
<column name="total" type="NUMERIC(10,2)"/>
<column name="igv" type="NUMERIC(10,2)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="27">
<createTable tableName="series">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="series_pkey" nullable="false"/>
</column>
<column name="serie" type="VARCHAR(20)"/>
<column name="descripcion" type="VARCHAR(60)"/>
<column name="ultimonumero" type="VARCHAR(20)">
<constraints nullable="false"/>
</column>
<column name="longitudnumero" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="parametro" type="VARCHAR(20)"/>
<column name="tienda_id" type="INTEGER"/>
<column name="tipodocumento_id" type="INTEGER" />
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="28">
<createTable tableName="stocktiendas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="stocktiendas_pkey" nullable="false"/>
</column>
<column name="modeloprenda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="stock" type="INTEGER" defaultValueNumeric="0">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="29">
<createTable tableName="tallas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tallas_pk" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="30">
<createTable tableName="telas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="telas_pk" nullable="false"/>
</column>
<column name="codigo" type="VARCHAR(30)"/>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="31">
<createTable tableName="tiendas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tiendas_pkey" nullable="false"/>
</column>
<column name="nombre" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="ubicacion" type="VARCHAR(100)"/>
<column name="telefono" type="VARCHAR(15)"/>
<column name="costoalquiler" type="NUMERIC(10,2)" defaultValueNumeric="0.00"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="32">
<createTable tableName="tipoclientes">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tipoclientes_pk" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="33">
<createTable tableName="tipodocumentos">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tipodocumentos_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="34">
<createTable tableName="tipoprendas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tipoprendas_pk" nullable="false"/>
</column>
<column name="nombre" type="VARCHAR(30)"/>
<column name="codigo" type="VARCHAR(30)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="35">
<createTable tableName="tipoproveedores">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="tipoproveedores_pkey" nullable="false"/>
</column>
<column name="descripcion" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="ingresoatienda" type="TINYINT" defaultValueNumeric="1"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="36">
<createTable tableName="ubigeos">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="ubigeos_pk" nullable="false"/>
</column>
<column name="ubigeo" type="VARCHAR(50)"/>
<column name="distrito" type="VARCHAR(50)"/>
<column name="provincia" type="VARCHAR(50)"/>
<column name="departamento" type="VARCHAR(50)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="37">
<createTable tableName="usuarios">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="usuarios_pkey" nullable="false"/>
</column>
<column name="usuario" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="clave" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="nombres" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="apellidos" type="VARCHAR(40)">
<constraints nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="privilegio_id" type="INTEGER">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="38">
<createTable tableName="usuarios_roles">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="usuarios_roles_pkey" nullable="false"/>
</column>
<column name="usuario_id" type="INTEGER"/>
<column name="rol_id" type="INTEGER">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="39">
<createTable tableName="ventas">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="ventas_pkey" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="cliente_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="tipodocumento_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="numero" type="VARCHAR(20)">
<constraints nullable="false"/>
</column>
<column name="total" type="NUMERIC(10,2)"/>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
<column name="estadoventa_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="igv" type="NUMERIC(10,2)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="40">
<addForeignKeyConstraint baseTableName="direccionclientes" constraintName="direccionclientes_clientes_fkey" baseColumnNames="cliente_id" referencedTableName="clientes" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="41">
<addForeignKeyConstraint baseTableName="separaciones" constraintName="separaciones_clientes_fkey" baseColumnNames="cliente_id" referencedTableName="clientes" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="42">
<addForeignKeyConstraint baseTableName="ventas" constraintName="ventas_clientes_fkey" baseColumnNames="cliente_id" referencedTableName="clientes" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="43">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprendas_colores_id_fkey" baseColumnNames="color_id" referencedTableName="colores" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="44">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprendas_disenios_id_fkey" baseColumnNames="disenio_id" referencedTableName="disenios" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="45">
<addForeignKeyConstraint baseTableName="separaciones" constraintName="separaciones_estadoseparaciones_fkey" baseColumnNames="estadoseparacion_id" referencedTableName="estadoseparaciones" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="46">
<addForeignKeyConstraint baseTableName="ventas" constraintName="ventas_estadoventas_id_fkey" baseColumnNames="estadoventa_id" referencedTableName="estadoventas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="47">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprendas_marcas_id_fkey" baseColumnNames="marca_id" referencedTableName="marcas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="48">
<addForeignKeyConstraint baseTableName="menu_roles" constraintName="seguridad_menus_roles_menus_id_fkey" baseColumnNames="menu_id" referencedTableName="menus" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="49">
<addForeignKeyConstraint baseTableName="menu_usuarios" constraintName="seguridad_menus_usuarios_menus_id_fkey" baseColumnNames="menu_id" referencedTableName="menus" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="50">
<addForeignKeyConstraint baseTableName="menus" constraintName="ventas_menus_id_fkey" baseColumnNames="parent_id" referencedTableName="menus" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="51">
<addForeignKeyConstraint baseTableName="detalleseparaciones" constraintName="detalleseparaciones_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="52">
<addForeignKeyConstraint baseTableName="detalleventas" constraintName="detalleventas_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="53">
<addForeignKeyConstraint baseTableName="ingresostocks" constraintName="ingresostocks_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="54">
<addForeignKeyConstraint baseTableName="movimientoentradas" constraintName="movimientoentradas_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="55">
<addForeignKeyConstraint baseTableName="movimientosalidas" constraintName="movimientosalidas_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="56">
<addForeignKeyConstraint baseTableName="stocktiendas" constraintName="stocktiendas_modeloprendas_fkey" baseColumnNames="modeloprenda_id" referencedTableName="modeloprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="57">
<addForeignKeyConstraint baseTableName="movimientoentradas" constraintName="movimientosalidas_movimientoentradas_id_fkey" baseColumnNames="movimientosalida_id" referencedTableName="movimientosalidas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="58">
<addForeignKeyConstraint baseTableName="direccionclientes" constraintName="direccionclientes_paises_fkey" baseColumnNames="pais_id" referencedTableName="paises" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="59">
<addForeignKeyConstraint baseTableName="usuarios" constraintName="usuarios_privilegios_id_fkey" baseColumnNames="privilegio_id" referencedTableName="privilegios" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="60">
<addForeignKeyConstraint baseTableName="ingresostocks" constraintName="ingresostocks_proveedores_fkey" baseColumnNames="proveedor_id" referencedTableName="proveedores" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="61">
<addForeignKeyConstraint baseTableName="menu_roles" constraintName="seguridad_menus_roles_roles_id_fkey" baseColumnNames="rol_id" referencedTableName="roles" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="62">
<addForeignKeyConstraint baseTableName="roles" constraintName="seguridad_roles_id_fkey" baseColumnNames="parent_id" referencedTableName="roles" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="63">
<addForeignKeyConstraint baseTableName="usuarios_roles" constraintName="seguridad_usuarios_roles_roles_id_fkey" baseColumnNames="rol_id" referencedTableName="roles" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="64">
<addForeignKeyConstraint baseTableName="detalleseparaciones" constraintName="detalleseparaciones_separaciones_fkey" baseColumnNames="separacion_id" referencedTableName="separaciones" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="65">
<addForeignKeyConstraint baseTableName="pagoseparaciones" constraintName="pagoseparaciones_separaciones_fkey" baseColumnNames="separacion_id" referencedTableName="separaciones" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="66">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprendas_tallas_id_fkey" baseColumnNames="talla_id" referencedTableName="tallas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="67">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprendas_telas_id_fkey" baseColumnNames="tela_id" referencedTableName="telas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="68">
<addForeignKeyConstraint baseTableName="usuarios" constraintName="usuarios_tiendas_id_fkey" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="69">
<addForeignKeyConstraint baseTableName="clientes" constraintName="clientes_tipoclientes_id_fkey" baseColumnNames="tipocliente_id" referencedTableName="tipoclientes" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="70">
<addForeignKeyConstraint baseTableName="gastos" constraintName="gastos_tipodocumentos_id_fkey" baseColumnNames="tipodocumento_id" referencedTableName="tipodocumentos" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="71">
<addForeignKeyConstraint baseTableName="separaciones" constraintName="separaciones_tipodocumentos_fkey" baseColumnNames="tipodocumento_id" referencedTableName="tipodocumentos" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="72">
<addForeignKeyConstraint baseTableName="series" constraintName="serie_tipodocumentos_fkey" baseColumnNames="tipodocumento_id" referencedTableName="tipodocumentos" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="73">
<addForeignKeyConstraint baseTableName="ventas" constraintName="ventas_tipodocumentos_fkey" baseColumnNames="tipodocumento_id" referencedTableName="tipodocumentos" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="74">
<addForeignKeyConstraint baseTableName="modeloprendas" constraintName="modeloprenda_tipoprendas_fkey" baseColumnNames="tipoprenda_id" referencedTableName="tipoprendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="75">
<addForeignKeyConstraint baseTableName="proveedores" constraintName="proveedores_tipoproveedores_id_fkey" baseColumnNames="tipoproveedor_id" referencedTableName="tipoproveedores" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="76">
<addForeignKeyConstraint baseTableName="direccionclientes" constraintName="direccionclientes_ubigeos_fkey" baseColumnNames="ubigeo_id" referencedTableName="ubigeos" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="77">
<addForeignKeyConstraint baseTableName="menu_usuarios" constraintName="seguridad_menus_usuarios_usuarios_id_fkey" baseColumnNames="usuario_id" referencedTableName="usuarios" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="78">
<addForeignKeyConstraint baseTableName="usuarios_roles" constraintName="usuarios_usuarios_roles_fk" baseColumnNames="usuario_id" referencedTableName="usuarios" referencedColumnNames="id" onDelete="CASCADE"/>
</changeSet>
<changeSet author="juan" id="79">
<addForeignKeyConstraint baseTableName="detalleventas" constraintName="detalleventas_ventas_fkey" baseColumnNames="venta_id" referencedTableName="ventas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="80">
<insert tableName="menus">
<column name="id" valueNumeric="1"/>
<column name="menu" value="Seguridad" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="null" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="2"/>
<column name="menu" value="Menus" />
<column name="parametro" value="menus" />
<column name="parent_id" valueNumeric="1" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="3"/>
<column name="menu" value="Registrar" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="null" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="4"/>
<column name="menu" value="Clientes" />
<column name="parametro" value="clientes" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="5"/>
<column name="menu" value="Tienda" />
<column name="parametro" value="tiendas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="6"/>
<column name="menu" value="Tipo Prendas" />
<column name="parametro" value="tipoprendas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="7"/>
<column name="menu" value="Prendas" />
<column name="parametro" value="modeloprendas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="8"/>
<column name="menu" value="Series" />
<column name="parametro" value="series" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="9"/>
<column name="menu" value="Proveedores" />
<column name="parametro" value="proveedores" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="10"/>
<column name="menu" value="Caja Inicial" />
<column name="parametro" value="cajainicial" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="11"/>
<column name="menu" value="Realizar" />
<column name="parametro" value="" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="12"/>
<column name="menu" value="Venta" />
<column name="parametro" value="ventas" />
<column name="parent_id" valueNumeric="11" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="13"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="4" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="14"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="4" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="15"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="4" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="16"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="4" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="17"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="5" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="18"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="5" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="19"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="5" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="20"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="5" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="21"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="6" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="22"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="6" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="23"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="6" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="24"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="6" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="25"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="7" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="26"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="7" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="27"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="7" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="28"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="7" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="29"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="8" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="30"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="8" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="31"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="8" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="32"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="8" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="33"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="9" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="34"/>
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="9" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="35"/>
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="9" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="36"/>
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="9" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="37"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="12" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="38"/>
<column name="menu" value="Realizar Venta" />
<column name="parametro" value="realizar" />
<column name="parent_id" valueNumeric="12" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="39"/>
<column name="menu" value="Anular" />
<column name="parametro" value="anular" />
<column name="parent_id" valueNumeric="12" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="40"/>
<column name="menu" value="Movimiento" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="11" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="41"/>
<column name="menu" value="Verificación" />
<column name="parametro" value="entrada" />
<column name="parent_id" valueNumeric="40" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="42"/>
<column name="menu" value="Salida" />
<column name="parametro" value="salida" />
<column name="parent_id" valueNumeric="40" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="43"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="41" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="44"/>
<column name="menu" value="Agregar Movimiento" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="41" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="45"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="42" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="46"/>
<column name="menu" value="Agregar Movimiento" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="42" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=47
</sql>
</changeSet>
<changeSet author="juan" id="81">
<insert tableName="roles">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Administradores" />
<column name="parent_id" valueNumeric="null" />
<column name="haschildren" valueNumeric="null" />
<column name="hasusers" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE roles AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="82">
<insert tableName="tiendas">
<column name="id" valueNumeric="1"/>
<column name="nombre" value="T01" />
<column name="ubicacion" value="gamarra" />
</insert>
<sql splitStatements="false">
ALTER TABLE tiendas AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="83">
<insert tableName="privilegios">
<column name="id" valueNumeric="1" />
<column name="descripcion" value="Super Usuario" />
</insert>
<insert tableName="privilegios">
<column name="id" valueNumeric="2" />
<column name="descripcion" value="Usuario" />
</insert>
<sql splitStatements="false">
ALTER TABLE privilegios AUTO_INCREMENT=3
</sql>
</changeSet>
<changeSet author="juan" id="84">
<sql splitStatements="false">
insert into usuarios (id,usuario,clave,nombres,apellidos,tienda_id,privilegio_id)
values(1,'admin',md5('123'),'admin','admin',1,1);
</sql>
<sql splitStatements="false">
ALTER TABLE usuarios AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="85">
<insert tableName="usuarios_roles">
<column name="id" valueNumeric="1"/>
<column name="usuario_id" valueNumeric="1" />
<column name="rol_id" valueNumeric="1"/>
</insert>
<sql splitStatements="false">
ALTER TABLE usuarios_roles AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="86">
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="1"/>
<column name="ingresoatienda" valueNumeric="0" />
<column name="descripcion" value="Insumo" />
</insert>
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="2"/>
<column name="descripcion" value="Bordado" />
</insert>
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="3"/>
<column name="ingresoatienda" valueNumeric="0" />
<column name="descripcion" value="Confeccion"/>
</insert>
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="4"/>
<column name="descripcion" value="Estampado" />
</insert>
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="5"/>
<column name="ingresoatienda" valueNumeric="0" />
<column name="descripcion" value="Corte" />
</insert>
<insert tableName="tipoproveedores">
<column name="id" valueNumeric="6"/>
<column name="ingresoatienda" valueNumeric="0" />
<column name="descripcion" value="Otros" />
</insert>
<sql splitStatements="false">
ALTER TABLE tipoproveedores AUTO_INCREMENT=7
</sql>
</changeSet>
<changeSet author="juan" id="87">
<insert tableName="tipodocumentos">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Boleta" />
</insert>
<insert tableName="tipodocumentos">
<column name="id" valueNumeric="2"/>
<column name="descripcion" value="Factura" />
</insert>
<insert tableName="tipodocumentos">
<column name="id" valueNumeric="3"/>
<column name="descripcion" value="Otro" />
</insert>
<sql splitStatements="false">
ALTER TABLE tipodocumentos AUTO_INCREMENT=4
</sql>
</changeSet>
<changeSet id="88" author="juan">
<insert tableName="series">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Codigo del articulo" />
<column name="ultimonumero" value="00000" />
<column name="longitudnumero" valueNumeric="5" />
<column name="parametro" value="codigoarticulo" />
</insert>
<sql splitStatements="false">
ALTER TABLE series AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet id="89" author="juan">
<insert tableName="estadoventas">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Realizado" />
</insert>
<insert tableName="estadoventas">
<column name="id" valueNumeric="2"/>
<column name="descripcion" value="Anulado" />
</insert>
<sql splitStatements="false">
ALTER TABLE estadoventas AUTO_INCREMENT=3
</sql>
</changeSet>
<changeSet id="90" author="juan">
<insert tableName="estadoseparaciones">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Realizado" />
</insert>
<insert tableName="estadoseparaciones">
<column name="id" valueNumeric="2"/>
<column name="descripcion" value="Anulado" />
</insert>
<insert tableName="estadoseparaciones">
<column name="id" valueNumeric="3"/>
<column name="descripcion" value="Cancelado" />
</insert>
<sql splitStatements="false">
ALTER TABLE estadoseparaciones AUTO_INCREMENT=4
</sql>
</changeSet>
<changeSet author="juan" id="91">
<insert tableName="menus">
<column name="id" valueNumeric="47"/>
<column name="menu" value="Separacion" />
<column name="parametro" value="separaciones" />
<column name="parent_id" valueNumeric="11" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="48"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="47" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="49"/>
<column name="menu" value="Realizar Separacion" />
<column name="parametro" value="realizar" />
<column name="parent_id" valueNumeric="47" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="50"/>
<column name="menu" value="Pagar Separacion" />
<column name="parametro" value="pagar" />
<column name="parent_id" valueNumeric="47" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="51"/>
<column name="menu" value="Anular" />
<column name="parametro" value="anular" />
<column name="parent_id" valueNumeric="47" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="52"/>
<column name="menu" value="Gasto" />
<column name="parametro" value="gastos" />
<column name="parent_id" valueNumeric="11" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="53"/>
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="52" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="54"/>
<column name="menu" value="Realizar" />
<column name="parametro" value="realizar" />
<column name="parent_id" valueNumeric="52" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=55
</sql>
</changeSet>
<changeSet author="juan" id="92">
<insert tableName="menus">
<column name="id" valueNumeric="55"/>
<column name="menu" value="Reportes" />
<column name="parametro" value="" />
<column name="haschildren" valueNumeric="1" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="56"/>
<column name="menu" value="Resumen del dia" />
<column name="parametro" value="resumen" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueNumeric="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=57
</sql>
</changeSet>
<changeSet author="juan" id="93">
<insert tableName="menus">
<column name="id" valueNumeric="57" />
<column name="menu" value="Prendas Vendidas" />
<column name="parametro" value="prendasvendidas" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="58" />
<column name="menu" value="Reporte de Ventas" />
<column name="parametro" value="reporteventas" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="59" />
<column name="menu" value="Reporte de Stock" />
<column name="parametro" value="reportestock" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=60
</sql>
</changeSet>
<changeSet author="juan" id="94">
<insert tableName="menus">
<column name="id" valueNumeric="60" />
<column name="menu" value="Reporte de Inventario" />
<column name="parametro" value="reporteinventario" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="61" />
<column name="menu" value="Ingresos de Taller" />
<column name="parametro" value="ingresostaller" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="62" />
<column name="menu" value="Reporte Saldos" />
<column name="parametro" value="reportesaldos" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=63
</sql>
</changeSet>
<changeSet author="juan" id="95">
<insert tableName="menus">
<column name="id" valueNumeric="63" />
<column name="menu" value="Reporte Entradas" />
<column name="parametro" value="movimientoentradas" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="64" />
<column name="menu" value="Reporte Salidas" />
<column name="parametro" value="movimientosalidas" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=65
</sql>
</changeSet>
<changeSet author="juan" id="96">
<delete tableName="menus">
<where>parent_id=55</where>
</delete>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=56
</sql>
</changeSet>
<changeSet author="juan" id="97">
<insert tableName="menus">
<column name="id" valueNumeric="56" />
<column name="menu" value="Por Tienda" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="57" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="55" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="58" />
<column name="menu" value="Resumen del dia" />
<column name="parametro" value="resumen" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="59" />
<column name="menu" value="Prendas Vendidas" />
<column name="parametro" value="prendasvendidas" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="60" />
<column name="menu" value="Reporte de Ventas" />
<column name="parametro" value="reporteventas" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="61" />
<column name="menu" value="Reporte de Stock" />
<column name="parametro" value="reportestock" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="62" />
<column name="menu" value="Reporte de Inventario" />
<column name="parametro" value="reporteinventario" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="63" />
<column name="menu" value="Ingresos de Taller" />
<column name="parametro" value="ingresostaller" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="64" />
<column name="menu" value="Reporte Saldos" />
<column name="parametro" value="reportesaldos" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="65" />
<column name="menu" value="Reporte Entradas" />
<column name="parametro" value="movimientoentradas" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="66" />
<column name="menu" value="Reporte Salidas" />
<column name="parametro" value="movimientosalidas" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="67" />
<column name="menu" value="Prendas Vendidas" />
<column name="parametro" value="gprendasvendidas" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="68" />
<column name="menu" value="Reporte de Ventas" />
<column name="parametro" value="greporteventas" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="69" />
<column name="menu" value="Reporte de Stock" />
<column name="parametro" value="greportestock" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="70" />
<column name="menu" value="Reporte de Inventario" />
<column name="parametro" value="greporteinventario" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="71" />
<column name="menu" value="Ingresos de Taller" />
<column name="parametro" value="gingresostaller" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="72" />
<column name="menu" value="Reporte Saldos" />
<column name="parametro" value="greportesaldos" />
<column name="parent_id" valueNumeric="57" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=73
</sql>
</changeSet>
<changeSet author="juan" id="98">
<insert tableName="menus">
<column name="id" valueNumeric="73" />
<column name="menu" value="Gráficos Estadísticos" />
<column name="parametro" value="" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="74" />
<column name="menu" value="Por Tienda" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="73" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="75" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="" />
<column name="parent_id" valueNumeric="73" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="76" />
<column name="menu" value="Ventas por día" />
<column name="parametro" value="prendasvendidasxdia" />
<column name="parent_id" valueNumeric="74" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="77" />
<column name="menu" value="Ventas por día" />
<column name="parametro" value="gprendasvendidasxdia" />
<column name="parent_id" valueNumeric="75" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="78" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="76" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="79" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="76" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="80" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="58" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="81" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="58" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="82" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="59" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="83" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="59" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="84" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="60" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="85" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="60" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="86" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="61" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="87" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="61" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="88" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="62" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="89" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="62" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="90" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="63" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="91" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="63" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="92" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="64" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="93" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="64" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="94" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="65" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="95" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="65" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="96" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="66" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="97" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="66" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="98" />
<column name="menu" value="Prenda vendida por fecha" />
<column name="parametro" value="prendavendidaxfecha" />
<column name="parent_id" valueNumeric="74" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="99" />
<column name="menu" value="Prenda vendida por fecha" />
<column name="parametro" value="gprendavendidaxfecha" />
<column name="parent_id" valueNumeric="75" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="100" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="98" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="101" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="98" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="102" />
<column name="menu" value="Ventas por fecha" />
<column name="parametro" value="gventasxfecha" />
<column name="parent_id" valueNumeric="75" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="103" />
<column name="menu" value="Ventas por fecha" />
<column name="parametro" value="ventasxfecha" />
<column name="parent_id" valueNumeric="74" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="104" />
<column name="menu" value="Todas las tiendas" />
<column name="parametro" value="lastiendas" />
<column name="parent_id" valueNumeric="103" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="105" />
<column name="menu" value="Solo su tienda" />
<column name="parametro" value="sutienda" />
<column name="parent_id" valueNumeric="103" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
</changeSet>
<changeSet author="juan" id="99">
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=106
</sql>
</changeSet>
<changeSet author="juan" id="100">
<insert tableName="menus">
<column name="id" valueNumeric="106" />
<column name="menu" value="Telas" />
<column name="parametro" value="telas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="107" />
<column name="menu" value="Tallas" />
<column name="parametro" value="tallas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="108" />
<column name="menu" value="Colores" />
<column name="parametro" value="colores" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="109" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="106" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="110" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="106" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="111" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="106" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="112" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="106" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="113" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="107" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="114" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="107" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="115" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="107" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="116" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="107" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="117" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="108" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="118" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="108" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="119" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="108" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="120" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="108" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="121" />
<column name="menu" value="Diseños" />
<column name="parametro" value="disenios" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="122" />
<column name="menu" value="Marcas" />
<column name="parametro" value="marcas" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="123" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="121" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="124" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="121" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="125" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="121" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="126" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="121" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="127" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="122" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="128" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="122" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="129" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="122" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="130" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="122" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
</changeSet>
<changeSet author="juan" id="101">
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=131
</sql>
</changeSet>
<changeSet id="102" author="juan">
<insert tableName="series">
<column name="id" valueNumeric="2" />
<column name="descripcion" value="Codigo del color" />
<column name="ultimonumero" value="00" />
<column name="longitudnumero" valueNumeric="2" />
<column name="parametro" value="codigocolor" />
</insert>
<insert tableName="series">
<column name="id" valueNumeric="3" />
<column name="descripcion" value="Codigo del diseño" />
<column name="ultimonumero" value="000" />
<column name="longitudnumero" valueNumeric="3" />
<column name="parametro" value="codigodisenio" />
</insert>
<insert tableName="series">
<column name="id" valueNumeric="4" />
<column name="descripcion" value="Codigo de la tela" />
<column name="ultimonumero" value="000" />
<column name="longitudnumero" valueNumeric="3" />
<column name="parametro" value="codigotela" />
</insert>
<sql splitStatements="false">
ALTER TABLE series AUTO_INCREMENT=4
</sql>
</changeSet>
<changeSet author="juan" id="103">
<insert tableName="menus">
<column name="id" valueNumeric="131" />
<column name="menu" value="Tipo Cliente" />
<column name="parametro" value="tipoclientes" />
<column name="parent_id" valueNumeric="3" />
<column name="haschildren" valueBoolean="true" />
<column name="tipo" valueNumeric="1" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="132" />
<column name="menu" value="Ver" />
<column name="parametro" value="view" />
<column name="parent_id" valueNumeric="131" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="133" />
<column name="menu" value="Agregar" />
<column name="parametro" value="add" />
<column name="parent_id" valueNumeric="131" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="134" />
<column name="menu" value="Editar" />
<column name="parametro" value="edit" />
<column name="parent_id" valueNumeric="131" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
<insert tableName="menus">
<column name="id" valueNumeric="135" />
<column name="menu" value="Eliminar" />
<column name="parametro" value="delete" />
<column name="parent_id" valueNumeric="131" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="2" />
</insert>
</changeSet>
<changeSet author="juan" id="104">
<insert tableName="menus">
<column name="id" valueNumeric="136" />
<column name="menu" value="Detalle prendas vendidas" />
<column name="parametro" value="reportedetalleprenda" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
</changeSet>
<changeSet author="juan" id="105">
<delete tableName="series">
<where> id=2</where>
</delete>
</changeSet>
<changeSet author="juan" id="106">
<delete tableName="series">
<where> id=3</where>
</delete>
</changeSet>
<changeSet author="juan" id="107">
<delete tableName="series">
<where> id=4</where>
</delete>
</changeSet>
<changeSet author="juan" id="108">
<sql splitStatements="false">
ALTER TABLE series AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="109">
<insert tableName="menus">
<column name="id" valueNumeric="137" />
<column name="menu" value="Reporte Clientes" />
<column name="parametro" value="reportedeclientes" />
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=138
</sql>
</changeSet>
<changeSet author="juan" id="110">
<insert tableName="menus">
<column name="id" valueNumeric="138" />
<column name="menu" value="Detalle Prendas Vendidas" />
<column name="parametro" value="gdetalleprenvendidas" />
<column name="parent_id" valueNumeric="75" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=139
</sql>
</changeSet>
<changeSet author="juan" id="111">
<delete tableName="menus">
<where>id=138</where>
</delete>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=138
</sql>
</changeSet>
<changeSet author="juan" id="112">
<insert tableName="menus">
<column name="id" valueNumeric="138" />
<column name="menu" value="Detalle Prendas Vendidas" />
<column name="parametro" value="gdetalleprenvendidas" />
<column name="parent_id" valueNumeric="74" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=139
</sql>
</changeSet>
<changeSet author="juan" id="113">
<delete tableName="series">
<where>id=1</where>
</delete>
</changeSet>
<changeSet id="114" author="juan">
<insert tableName="series">
<column name="id" valueNumeric="1"/>
<column name="descripcion" value="Vale de Salida" />
<column name="ultimonumero" value="00000" />
<column name="longitudnumero" valueNumeric="5" />
<column name="parametro" value="valesalida" />
</insert>
<sql splitStatements="false">
ALTER TABLE series AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet id="115" author="juan">
<insert tableName="series">
<column name="id" valueNumeric="2"/>
<column name="descripcion" value="Nota de Ingreso" />
<column name="ultimonumero" value="00000" />
<column name="longitudnumero" valueNumeric="5" />
<column name="parametro" value="notaingreso" />
</insert>
<sql splitStatements="false">
ALTER TABLE series AUTO_INCREMENT=3
</sql>
</changeSet>
<changeSet author="juan" id="116">
<insert tableName="estadoventas">
<column name="id" valueNumeric="3"/>
<column name="descripcion" value="Realizado por Separación" />
</insert>
<sql splitStatements="false">
ALTER TABLE estadoventas AUTO_INCREMENT=4
</sql>
</changeSet>
<changeSet author="juan" id="117">
<insert tableName="menus">
<column name="id" valueNumeric="139" />
<column name="menu" value="Ventas x Cliente" />
<column name="parametro" value="prendavendidacliente"/>
<column name="parent_id" valueNumeric="56" />
<column name="haschildren" valueBoolean="null" />
<column name="tipo" valueNumeric="1" />
</insert>
<sql splitStatements="false">
ALTER TABLE menus AUTO_INCREMENT=140
</sql>
</changeSet>
<changeSet author="juan" id="118">
<dropColumn tableName="actualstocks" columnName="modeloprenda_id"/>
</changeSet>
<changeSet author="juan" id="119">
<addColumn tableName="actualstocks">
<column name="stocktienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
</addColumn>
</changeSet>
<changeSet author="juan" id="120">
<dropColumn tableName="actualstocks" columnName="tienda_id"/>
</changeSet>
<changeSet author="juan" id="121">
<dropTable tableName="cajainiciales"/>
</changeSet>
<changeSet author="juan" id="122">
<addForeignKeyConstraint baseTableName="actualstocks" constraintName="stocktiendas_actualstocks_fk" baseColumnNames="stocktienda_id" referencedTableName="stocktiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="123">
<addForeignKeyConstraint baseTableName="balancetiendas" constraintName="tiendas_balancetiendas_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="124">
<addForeignKeyConstraint baseTableName="gastos" constraintName="tiendas_gastos_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="125">
<addForeignKeyConstraint baseTableName="ingresostocks" constraintName="tiendas_ingresostocks_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="126">
<addForeignKeyConstraint baseTableName="movimientoentradas" constraintName="tiendas_movimientoentradas_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="127">
<addForeignKeyConstraint baseTableName="separaciones" constraintName="tiendas_separaciones_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="128">
<addForeignKeyConstraint baseTableName="series" constraintName="tiendas_series_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="129">
<addForeignKeyConstraint baseTableName="stocktiendas" constraintName="tiendas_stocktiendas_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="130">
<addForeignKeyConstraint baseTableName="ventas" constraintName="tiendas_ventas_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="131">
<dropColumn tableName="actualstocks" columnName="final"/>
</changeSet>
<changeSet author="juan" id="132">
<dropColumn tableName="balancetiendas" columnName="balance"/>
</changeSet>
<changeSet author="juan" id="133">
<addColumn tableName="actualstocks">
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
</addColumn>
</changeSet>
<changeSet author="juan" id="134">
<dropColumn tableName="modeloprendas" columnName="stock"/>
</changeSet>
<changeSet author="juan" id="135">
<createTable tableName="cajainiciales">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" primaryKeyName="cajainiciales_pk" nullable="false"/>
</column>
<column name="tienda_id" type="INTEGER">
<constraints nullable="false"/>
</column>
<column name="saldoinicial" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
<column name="fecha" type="DATE">
<constraints nullable="false"/>
</column>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="137">
<addForeignKeyConstraint baseTableName="cajainiciales" constraintName="tiendas_cajainiciales_fk" baseColumnNames="tienda_id" referencedTableName="tiendas" referencedColumnNames="id"/>
</changeSet>
<changeSet author="juan" id="138">
<addColumn tableName="balancetiendas">
<column name="ingresocaja" type="NUMERIC(10,2)">
<constraints nullable="false"/>
</column>
</addColumn>
</changeSet>
<changeSet author="juan" id="139">
<addNotNullConstraint tableName="balancetiendas" columnName="gastos" columnDataType="NUMERIC(10,2)" />
</changeSet>
<changeSet author="juan" id="140">
<addNotNullConstraint tableName="balancetiendas" columnName="ingresoseparaciones" columnDataType="NUMERIC(10,2)"/>
</changeSet>
<changeSet author="juan" id="141">
<addNotNullConstraint tableName="balancetiendas" columnName="ingresoventas" columnDataType="NUMERIC(10,2)"/>
</changeSet>
<changeSet author="juan" id="142">
<addNotNullConstraint tableName="balancetiendas" columnName="saldoinicial" columnDataType="NUMERIC(10,2)"/>
</changeSet>
<changeSet author="juan" id="143">
<addNotNullConstraint tableName="balancetiendas" columnName="tienda_id" columnDataType="INTEGER"/>
</changeSet>
<changeSet author="juan" id="144">
<dropNotNullConstraint tableName="ventas" columnName="cliente_id" columnDataType="INTEGER"/>
</changeSet>
<changeSet author="juan" id="145">
<createTable tableName="configuraciones">
<column name="id" type="INTEGER" autoIncrement="true">
<constraints primaryKey="true" uniqueConstraintName="configuraciones_pk" nullable="false"/>
</column>
<column name="logomin" type="VARCHAR(200)"/>
<column name="logomax" type="VARCHAR(200)"/>
<column name="logooriginal" type="VARCHAR(200)"/>
<column name="mensajebienvenida" type="text" />
<column name="razonsocial" type="VARCHAR(255)"/>
</createTable>
<modifySql dbms="mysql">
<append value=" engine innodb"/>
</modifySql>
</changeSet>
<changeSet author="juan" id="146">
<insert tableName="configuraciones">
<column name="id" valueNumeric="1" />
<column name="logomin" value="rhemsolutions-logo-min.png" />
<column name="logomax" value="rhemsolutions-logo.png"/>
<column name="logooriginal" value="rhemsolutions-logo.png" />
<column name="mensajebienvenida" value="BIENVENIDOS:" />
<column name="razonsocial" value="RhemSolutions S.A.C." />
</insert>
<sql splitStatements="false">
ALTER TABLE configuraciones AUTO_INCREMENT=2
</sql>
</changeSet>
<changeSet author="juan" id="147">
<modifyColumn tableName="clientes">
<column name="apellidos" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="148">
<modifyColumn tableName="clientes">
<column name="celular" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="149">
<modifyColumn tableName="clientes">
<column name="email" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="150">
<modifyColumn tableName="clientes">
<column name="nombres" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="151">
<modifyColumn tableName="clientes">
<column name="razonsocial" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="152">
<modifyColumn tableName="clientes">
<column name="telefono" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="153">
<modifyColumn tableName="colores">
<column name="codigo" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="154">
<modifyColumn tableName="colores">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="155">
<modifyColumn tableName="configuraciones">
<column name="logomax" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="156">
<modifyColumn tableName="configuraciones">
<column name="logomin" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="157">
<modifyColumn tableName="configuraciones">
<column name="logooriginal" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="158">
<modifyColumn tableName="configuraciones">
<column name="razonsocial" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="159">
<modifyColumn tableName="direccionclientes">
<column name="direccion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="160">
<modifyColumn tableName="disenios">
<column name="codigo" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="161">
<modifyColumn tableName="disenios">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="162">
<modifyColumn tableName="estadoseparaciones">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="163">
<modifyColumn tableName="estadoventas">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="164">
<modifyColumn tableName="gastos">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="165">
<modifyColumn tableName="gastos">
<column name="observaciones" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="166">
<modifyColumn tableName="marcas">
<column name="codigo" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="167">
<modifyColumn tableName="marcas">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="168">
<modifyColumn tableName="menus">
<column name="menu" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="169">
<modifyColumn tableName="menus">
<column name="parametro" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="170">
<modifyColumn tableName="modeloprendas">
<column name="codigo" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="171">
<modifyColumn tableName="modeloprendas">
<column name="codigogenerico" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="172">
<modifyColumn tableName="modeloprendas">
<column name="nombre" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="173">
<modifyColumn tableName="modeloprendas">
<column name="serieprenda" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="174">
<modifyColumn tableName="movimientoentradas">
<column name="numero" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="175">
<modifyColumn tableName="movimientosalidas">
<column name="numero" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="176">
<modifyColumn tableName="privilegios">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="177">
<modifyColumn tableName="proveedores">
<column name="celular" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="178">
<modifyColumn tableName="proveedores">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="179">
<modifyColumn tableName="proveedores">
<column name="direccion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="180">
<modifyColumn tableName="proveedores">
<column name="email" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="181">
<modifyColumn tableName="proveedores">
<column name="razonsocial" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="182">
<modifyColumn tableName="proveedores">
<column name="representantelegal" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="183">
<modifyColumn tableName="proveedores">
<column name="telefono" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="184">
<modifyColumn tableName="roles">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="185">
<modifyColumn tableName="series">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="186">
<modifyColumn tableName="series">
<column name="parametro" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="187">
<modifyColumn tableName="series">
<column name="serie" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="188">
<modifyColumn tableName="series">
<column name="ultimonumero" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="189">
<modifyColumn tableName="tallas">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="190">
<modifyColumn tableName="telas">
<column name="codigo" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="191">
<modifyColumn tableName="telas">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="192">
<modifyColumn tableName="tiendas">
<column name="nombre" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="193">
<modifyColumn tableName="tiendas">
<column name="telefono" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="194">
<modifyColumn tableName="tiendas">
<column name="ubicacion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="195">
<modifyColumn tableName="tipoclientes">
<column name="descripcion" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="196">
<modifyColumn tableName="tipodocumentos">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="197">
<modifyColumn tableName="tipoprendas">
<column name="codigo" type="VARCHAR(50)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="198">
<modifyColumn tableName="tipoprendas">
<column name="nombre" type="VARCHAR(250)"/>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="199">
<modifyColumn tableName="tipoproveedores">
<column name="descripcion" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="200">
<modifyColumn tableName="usuarios">
<column name="apellidos" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="201">
<modifyColumn tableName="usuarios">
<column name="clave" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="202">
<modifyColumn tableName="usuarios">
<column name="nombres" type="VARCHAR(250)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="203">
<modifyColumn tableName="usuarios">
<column name="usuario" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="juan" id="204">
<modifyColumn tableName="ventas">
<column name="numero" type="VARCHAR(50)">
<constraints nullable="false"/>
</column>
</modifyColumn>
</changeSet>
<changeSet author="richard" id="1">
<addColumn tableName="configuraciones">
<column name="ruc" type="varchar(11)"/>
</addColumn>
</changeSet>
</databaseChangeLog>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment