function backup()
{
$dbname = "peliculas";
$dbconn = pg_pconnect("host=localhost port=5432 dbname={$dbname} user=postgres password=root");
//connectionstring
if (!$dbconn) {
echo "Can't connect.\n";
exit;
}
/////////id de la auditoria////////////
date_default_timezone_set('UTC');
$fecha = date("Y-m-d");
///////////////*/
$back = fopen("{$dbname}.sql", "w");
/////////////////
$str = "";
$str .= "\nSET client_encoding=LATIN1" . ";";
$table = 'asignacion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_asignacion' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_bodega' . " " . 'int4' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'bancos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_bancos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'numero_cuenta' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'sucursal' . " " . 'text' . ",";
$str .= "\n" . 'tipo_cuenta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'bodegas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_bodega' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_bodega' . " " . 'text' . ",";
$str .= "\n" . 'ubicacion_bodega' . " " . 'text' . ",";
$str .= "\n" . 'telefono_bodega' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'c_cobrarexternas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_c_cobrarexternas' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'c_pagarexternas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_c_pagarexternas' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////////
$table = 'cargo_usuario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cargo_usuario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'categoria';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_categoria' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_categoria' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'cliente_ruta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cli_ruta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_ruta' . " " . 'int4';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'cliente_sector';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cli_sector' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_sector' . " " . 'int4';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'clientes';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cliente' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'identificacion' . " " . 'text' . ",";
$str .= "\n" . 'nombres_cli' . " " . 'text' . ",";
$str .= "\n" . 'tipo_cliente' . " " . 'text' . ",";
$str .= "\n" . 'direccion_cli' . " " . 'text' . ",";
$str .= "\n" . 'telefono' . " " . 'text' . ",";
$str .= "\n" . 'celular' . " " . 'text' . ",";
$str .= "\n" . 'pais' . " " . 'text' . ",";
$str .= "\n" . 'ciudad' . " " . 'text' . ",";
$str .= "\n" . 'correo' . " " . 'text' . ",";
$str .= "\n" . 'credito_cupo' . " " . 'text' . ",";
$str .= "\n" . 'notas' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'id_plan_cuentas' . " " . 'int4';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
$table = 'color';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_color' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_color' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalle_adicional';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_adicional' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_detalles_permiso' . " " . 'int4' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalle_asignacion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_asignacion' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_asignacion' . " " . 'int4' . ",";
$str .= "\n" . 'id_plan_cuentas' . " " . 'int4' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalle_devolucion_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_devcompra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_devolucion_compra' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////////
$table = 'detalle_devolucion_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_deventa' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_devolucion_venta' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////////
$table = 'detalle_egreso';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_egreso' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_egresos' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////////
$table = 'detalle_factura_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
$table = 'detalle_factura_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'pendientes' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////
$table = 'detalle_ingreso';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_ingreso' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_ingresos' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////
$table = 'detalle_inventario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_inventario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_inventario' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'p_costo' . " " . 'text' . ",";
$str .= "\n" . 'p_venta' . " " . 'text' . ",";
$str .= "\n" . 'disponibles' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . 'diferencia' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
/////////////////
$table = ' detalle_pagos_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_pagos_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_pagos_venta' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_pago' . " " . 'text' . ",";
$str .= "\n" . 'cuota' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////
$table = 'detalle_proforma';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_proforma' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proforma' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalle_transaccion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_transaccion' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_transacciones' . " " . 'int4' . ",";
$str .= "\n" . 'id_plan_cuentas' . " " . 'int4' . ",";
$str .= "\n" . 'tipo_referencia' . " " . 'text' . ",";
$str .= "\n" . 'num_referencia' . " " . 'text' . ",";
$str .= "\n" . 'debito' . " " . 'text' . ",";
$str .= "\n" . 'credito' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalles_ordenes';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalles_ordenes' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_ordenes' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'total_costo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
/////////////
$table = 'detalles_pagos_internos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalles_pagos_interna' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cuentas_cobrar' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_pago_actual' . " " . 'text' . ",";
$str .= "\n" . 'total_pagos' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////+}
$table = 'detalles_permiso';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalles_permiso' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_permisos' . " " . 'int4' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'devolucion_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_devolucion_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_compra' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'devolucion_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_devolucion_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'egresos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_egresos ' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'origen' . " " . 'text' . ",";
$str .= "\n" . 'destino' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_egreso' . " " . 'text' . ",";
$str .= "\n" . 'descuento_egreso' . " " . 'text' . ",";
$str .= "\n" . 'total_egreso' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'empresa';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_empresa' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_empresa' . " " . 'text' . ",";
$str .= "\n" . 'ruc_empresa' . " " . 'text' . ",";
$str .= "\n" . 'direccion_empresa' . " " . 'text' . ",";
$str .= "\n" . 'telefono_empresa' . " " . 'text' . ",";
$str .= "\n" . 'celular_empresa' . " " . 'text' . ",";
$str .= "\n" . 'pais_empresa' . " " . 'text' . ",";
$str .= "\n" . 'ciudad_empresa' . " " . 'text' . ",";
$str .= "\n" . 'fax_empresa' . " " . 'text' . ",";
$str .= "\n" . 'email_empresa' . " " . 'text' . ",";
$str .= "\n" . 'pagina_web' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'propietario' . " " . 'text' . ",";
$str .= "\n" . 'imagen' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'factura_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'fecha_registro' . " " . 'text' . ",";
$str .= "\n" . 'fecha_emision' . " " . 'text' . ",";
$str .= "\n" . 'fecha_caducidad' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_cancelacion' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_compra' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'factura_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'fecha_cancelacion' . " " . 'text' . ",";
$str .= "\n" . 'tipo_precio' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_caducidad' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'fecha_anulacion' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'gastos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_gastos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'acumulado' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'gastos_internos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_gastos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'impuestos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_impuestos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'ingresos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_ingresos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'origen' . " " . 'text' . ",";
$str .= "\n" . 'destino' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'descuento_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'total_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'inventario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_inventario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'kardex';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_kardex' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'fecha_kardex' . " " . 'text' . ",";
$str .= "\n" . 'detalle' . " " . 'text' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'valor_unitario' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'transaccion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'kardex_valorizado';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_kardex' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_transaccion' . " " . 'text' . ",";
$str .= "\n" . 'concepto' . " " . 'text' . ",";
$str .= "\n" . 'entrada' . " " . 'text' . ",";
$str .= "\n" . 'salida' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . 'costo_unitario' . " " . 'text' . ",";
$str .= "\n" . 'costo_promedio' . " " . 'text' . ",";
$str .= "\n" . 'debe' . " " . 'text' . ",";
$str .= "\n" . 'haber' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'libro_diario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_libro_diario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'fecha' . " " . 'text' . ",";
$str .= "\n" . 'detalle' . " " . 'text' . ",";
$str .= "\n" . 'debe' . " " . 'text' . ",";
$str .= "\n" . 'haber' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'marcas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_marca' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_marca' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'ordenes_produccion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_ordenes' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'sub_total' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_cobrar';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cuentas_cobrar' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tipo_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_factura' . " " . 'text' . ",";
$str .= "\n" . 'total_factura' . " " . 'text' . ",";
$str .= "\n" . 'valor_pagado' . " " . 'text' . ",";
$str .= "\n" . 'saldo_factura' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_pagos_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_credito' . " " . 'text' . ",";
$str .= "\n" . 'adelanto' . " " . 'text' . ",";
$str .= "\n" . 'meses' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'monto_credito' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_pagar';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cuentas_pagar' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tipo_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_factura' . " " . 'text' . ",";
$str .= "\n" . 'total_factura' . " " . 'text' . ",";
$str .= "\n" . 'valor_pagado' . " " . 'text' . ",";
$str .= "\n" . 'saldo_factura' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_pagos_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_credito' . " " . 'text' . ",";
$str .= "\n" . 'adelanto' . " " . 'text' . ",";
$str .= "\n" . 'meses' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'monto_credito' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'permisos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_permisos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'plan_cuentas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_plan_cuentas' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'codigo_plan' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'cuenta' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'productos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'cod_productos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'codigo' . " " . 'text' . ",";
$str .= "\n" . 'cod_barras' . " " . 'text' . ",";
$str .= "\n" . 'articulo' . " " . 'text' . ",";
$str .= "\n" . 'iva' . " " . 'text' . ",";
$str .= "\n" . 'series' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'utilidad_minorista' . " " . 'text' . ",";
$str .= "\n" . 'utilidad_mayorista' . " " . 'text' . ",";
$str .= "\n" . 'iva_minorista' . " " . 'text' . ",";
$str .= "\n" . 'iva_mayorista' . " " . 'text' . ",";
$str .= "\n" . 'categoria' . " " . 'text' . ",";
$str .= "\n" . 'marca' . " " . 'text' . ",";
$str .= "\n" . 'stock' . " " . 'text' . ",";
$str .= "\n" . 'stock_minimo' . " " . 'text' . ",";
$str .= "\n" . 'stock_maximo' . " " . 'text' . ",";
$str .= "\n" . 'fecha_creacion' . " " . 'text' . ",";
$str .= "\n" . 'caracteristicas' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'inventariable' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . 'diferencia' . " " . 'text' . ",";
$str .= "\n" . 'imagen' . " " . 'text' . ",";
$str .= "\n" . 'id_bodega' . " " . 'int4' . ",";
$str .= "\n" . ' incluye_iva' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'proforma';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_proforma' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_precio' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_proforma' . " " . 'text' . ",";
$str .= "\n" . 'descuento_proforma' . " " . 'text' . ",";
$str .= "\n" . 'total_proforma' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'proveedores';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'identificacion_pro' . " " . 'text' . ",";
$str .= "\n" . 'empresa_pro' . " " . 'text' . ",";
$str .= "\n" . 'representante_legal' . " " . 'text' . ",";
$str .= "\n" . 'visitador' . " " . 'text' . ",";
$str .= "\n" . 'direccion_pro' . " " . 'text' . ",";
$str .= "\n" . 'telefono' . " " . 'text' . ",";
$str .= "\n" . 'celular' . " " . 'text' . ",";
$str .= "\n" . 'fax' . " " . 'text' . ",";
$str .= "\n" . 'pais' . " " . 'text' . ",";
$str .= "\n" . 'ciudad' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'correo' . " " . 'text' . ",";
$str .= "\n" . 'principal' . " " . 'text' . ",";
$str .= "\n" . 'tipo_proveedor' . " " . 'text' . ",";
$str .= "\n" . 'credito_cupo' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . ' id_plan_cuentas' . " " . 'int4';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'retencion_fuentes';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_retencion_fuentes' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . 'valor_base' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'retenciones';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_retenciones' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . 'valor_base' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'rutas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_ruta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_ruta' . " " . 'text' . ",";
$str .= "\n" . ' id_sector' . " " . 'int4';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'sectores';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_sectores' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_sector' . " " . 'text' . ",";
$str .= "\n" . ' direccion_sector' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'segundo_impuesto';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_segundo_impuesto' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'seguridad';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_seguridad' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'clave' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'serie_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_serie_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'serie' . " " . 'text' . ",";
$str .= "\n" . 'observacion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'series_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_serie' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'serie' . " " . 'text' . ",";
$str .= "\n" . 'observacion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'tipo_transaccion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_tipo_transaccion' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'transacciones';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_transacciones' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_transaccion' . " " . 'text' . ",";
$str .= "\n" . 'num_transaccion' . " " . 'text' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'concepto' . " " . 'text' . ",";
$str .= "\n" . 'total_debe' . " " . 'text' . ",";
$str .= "\n" . 'total_haber' . " " . 'text' . ",";
$str .= "\n" . 'diferencia' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'unidades_medida';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_unidades' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'abreviatura' . " " . 'text' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'usuario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_usuario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_usuario' . " " . 'text' . ",";
$str .= "\n" . 'apellido_usuario' . " " . 'text' . ",";
$str .= "\n" . 'ci_usuario' . " " . 'text' . ",";
$str .= "\n" . 'telefono_usuario' . " " . 'text' . ",";
$str .= "\n" . 'celular_usuario' . " " . 'text' . ",";
$str .= "\n" . 'cargo_usuario' . " " . 'text' . ",";
$str .= "\n" . 'clave' . " " . 'text' . ",";
$str .= "\n" . 'email_usuario' . " " . 'text' . ",";
$str .= "\n" . 'direccion_usuario' . " " . 'text' . ",";
$str .= "\n" . 'usuario' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
///////////////////////////////
$res = pg_query(" SELECT\n cl.relname AS tabela,ct.conname,\n pg_get_constraintdef(ct.oid) FROM pg_catalog.pg_attribute a\n JOIN pg_catalog.pg_class cl ON (a.attrelid = cl.oid AND cl.relkind = 'r') \n JOIN pg_catalog.pg_namespace n ON (n.oid = cl.relnamespace)\n JOIN pg_catalog.pg_constraint ct ON (a.attrelid = ct.conrelid AND ct.confrelid != 0 AND ct.conkey[1] = a.attnum)\n JOIN pg_catalog.pg_class clf ON (ct.confrelid = clf.oid AND clf.relkind = 'r')\n JOIN pg_catalog.pg_namespace nf ON (nf.oid = clf.relnamespace)\n JOIN pg_catalog.pg_attribute af ON (af.attrelid = ct.confrelid AND\n af.attnum = ct.confkey[1]) order by cl.relname ");
while ($row = pg_fetch_row($res)) {
$str .= "\n\n--\n";
$str .= "-- Creating relacionships for '" . $row[0] . "'";
$str .= "\n--\n\n";
$str .= "ALTER TABLE ONLY " . $row[0] . " ADD CONSTRAINT " . $row[1] . " " . $row[2] . ";";
}
////////////////////
fwrite($back, $str);
fclose($back);
dl_file("{$dbname}.sql");
}
function batch_dir($d, $h)
{
$r = call_dir_list($d . '/' . $h);
foreach ($r as $k => $v) {
if ($v) {
dl_file($d, $v);
}
}
}
function backup()
{
$dbname = "neltex";
//database name
//$dbname = "mantenimiento_inventario"; //database name
$dbconn = pg_pconnect("host=localhost port=5432 dbname={$dbname} user=postgres password=rootdow");
//connectionstring
// $dbconn = pg_pconnect("dbname=df2jp28bdkuafd host=ec2-54-204-32-91.compute-1.amazonaws.com port=5432 user=larfyvwbaurpxo password=WV84lJxFXf7aqF6BXCXgwcI-tC sslmode=require"); //cadena de conexion
if (!$dbconn) {
echo "Can't connect.\n";
exit;
}
/////////id de la auditoria////////////
date_default_timezone_set('UTC');
$fecha = date("Y-m-d");
//////////////
$consulta = pg_query("select max(pk_audit) as maximo from tbl_audit");
while ($row = pg_fetch_row($consulta)) {
$max = $row[0];
}
$max = $max + 1;
//////////////
$back = fopen("{$dbname}.sql", "w");
/////////////////
$str = "";
$str .= "\nCREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog" . ";";
$str .= "\nCOMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'" . ";";
$str .= "\nSET search_path = public, pg_catalog" . ";";
$str .= "\nSET client_encoding=LATIN1" . ";";
////////////
$str .= "\nCREATE FUNCTION fn_log_audit() RETURNS trigger\n LANGUAGE plpgsql\n AS \$\$\nBEGIN\n IF (TG_OP = 'DELETE') THEN\n INSERT INTO tbl_audit (\"nombre_tabla\", \"operacion\", \"valor_anterior\", \"valor_nuevo\", \"fecha_cambio\", \"usuario\")\n VALUES (TG_TABLE_NAME, 'D', OLD, NULL, now(), USER);\n RETURN OLD;\n ELSIF (TG_OP = 'UPDATE') THEN\n INSERT INTO tbl_audit (\"nombre_tabla\", \"operacion\", \"valor_anterior\", \"valor_nuevo\", \"fecha_cambio\", \"usuario\")\n VALUES (TG_TABLE_NAME, 'U', OLD, NEW, now(), USER);\n RETURN NEW;\n ELSIF (TG_OP = 'INSERT') THEN\n INSERT INTO tbl_audit (\"nombre_tabla\", \"operacion\", \"valor_anterior\", \"valor_nuevo\", \"fecha_cambio\", \"usuario\")\n VALUES (TG_TABLE_NAME, 'I', NULL, NEW, now(), USER);\n RETURN NEW;\n END IF;\n RETURN NULL;\nEND;\n\$\$;";
$str .= "\nLANGUAGE 'plpgsql' VOLATILE COST 100;";
$str .= "\nALTER FUNCTION public.fn_log_audit() OWNER TO postgres;";
///////////
$table = 'c_cobrarexternas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_c_cobrarexternas' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'c_pagarexternas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_c_pagarexternas' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////////
$table = 'categoria';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_categoria' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_categoria' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'clientes';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cliente' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'identificacion' . " " . 'text' . ",";
$str .= "\n" . 'nombres_cli' . " " . 'text' . ",";
$str .= "\n" . 'tipo_cliente' . " " . 'text' . ",";
$str .= "\n" . 'direccion_cli' . " " . 'text' . ",";
$str .= "\n" . 'telefono' . " " . 'text' . ",";
$str .= "\n" . 'celular' . " " . 'text' . ",";
$str .= "\n" . 'pais' . " " . 'text' . ",";
$str .= "\n" . 'ciudad' . " " . 'text' . ",";
$str .= "\n" . 'correo' . " " . 'text' . ",";
$str .= "\n" . 'credito_cupo' . " " . 'text' . ",";
$str .= "\n" . 'notas' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
$table = 'color';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_color' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_color' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalle_devolucion_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_devcompra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_devolucion_compra' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////////
$table = 'detalle_devolucion_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_deventa' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_devolucion_venta' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////////
$table = 'detalle_egreso';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_egreso' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_egresos' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////////
$table = 'detalle_factura_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
$table = 'detalle_factura_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_producto' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'pendientes' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////
$table = 'detalle_ingreso';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_ingreso' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_ingresos' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////
$table = 'detalle_inventario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_inventario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_inventario' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'p_costo' . " " . 'text' . ",";
$str .= "\n" . 'p_venta' . " " . 'text' . ",";
$str .= "\n" . 'disponibles' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . 'diferencia' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
/////////////////
$table = ' detalle_pagos_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_pagos_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_pagos_venta' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_pago' . " " . 'text' . ",";
$str .= "\n" . 'cuota' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
////////////////
$table = 'detalle_proforma';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle_proforma' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proforma' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalles_ordenes';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalles_ordenes' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_ordenes' . " " . 'int4' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'precio_costo' . " " . 'text' . ",";
$str .= "\n" . 'total_costo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
/////////////
$table = 'detalles_pagos_internos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalles_pagos_interna' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cuentas_cobrar' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_pago_actual' . " " . 'text' . ",";
$str .= "\n" . 'total_pagos' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'detalles_trabajo';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_detalle' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_detalle' . " " . 'text' . ",";
$str .= "\n" . 'valor_detalle' . " " . 'text' . ",";
$str .= "\n" . 'id_trabajotecnico' . " " . 'int4' . ",";
$str .= "\n" . 'codigo' . " " . 'text' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'tipo' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'devolucion_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_devolucion_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_compra' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'devolucion_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_devolucion_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'egresos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_egresos ' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'origen' . " " . 'text' . ",";
$str .= "\n" . 'destino' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_egreso' . " " . 'text' . ",";
$str .= "\n" . 'descuento_egreso' . " " . 'text' . ",";
$str .= "\n" . 'total_egreso' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'empresa';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_empresa' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_empresa' . " " . 'text' . ",";
$str .= "\n" . 'ruc_empresa' . " " . 'text' . ",";
$str .= "\n" . 'direccion_empresa' . " " . 'text' . ",";
$str .= "\n" . 'telefono_empresa' . " " . 'text' . ",";
$str .= "\n" . 'celular_empresa' . " " . 'text' . ",";
$str .= "\n" . 'fax_empresa' . " " . 'text' . ",";
$str .= "\n" . 'email_empresa' . " " . 'text' . ",";
$str .= "\n" . 'pagina_web' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'factura_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'fecha_registro' . " " . 'text' . ",";
$str .= "\n" . 'fecha_emision' . " " . 'text' . ",";
$str .= "\n" . 'fecha_caducidad' . " " . 'text' . ",";
$str .= "\n" . 'tipo_comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_serie' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_cancelacion' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_compra' . " " . 'text' . ",";
$str .= "\n" . 'descuento_compra' . " " . 'text' . ",";
$str .= "\n" . 'total_compra' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'factura_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'fecha_cancelacion' . " " . 'text' . ",";
$str .= "\n" . 'tipo_precio' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_autorizacion' . " " . 'text' . ",";
$str .= "\n" . 'fecha_caducidad' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_venta' . " " . 'text' . ",";
$str .= "\n" . 'descuento_venta' . " " . 'text' . ",";
$str .= "\n" . 'total_venta' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'fecha_anulacion' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'gastos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_gastos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'valor' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'acumulado' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'gastos_internos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_gastos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'descripcion' . " " . 'text' . ",";
$str .= "\n" . 'total' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'ingresos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_ingresos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'origen' . " " . 'text' . ",";
$str .= "\n" . 'destino' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'descuento_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'total_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'inventario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_inventario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'kardex';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_kardex' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'fecha_kardex' . " " . 'text' . ",";
$str .= "\n" . 'detalle' . " " . 'text' . ",";
$str .= "\n" . 'cantidad_c' . " " . 'text' . ",";
$str .= "\n" . 'valor_unitario_c' . " " . 'text' . ",";
$str .= "\n" . 'total_c' . " " . 'text' . ",";
$str .= "\n" . 'cantidad_v' . " " . 'text' . ",";
$str .= "\n" . 'valor_unitario_v' . " " . 'text' . ",";
$str .= "\n" . 'total_v ' . " " . 'text' . ",";
$str .= "\n" . 'cod_productos ' . " " . 'int4' . ",";
$str .= "\n" . 'transaccion ' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'kardex_valorizado';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_kardex' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_transaccion' . " " . 'text' . ",";
$str .= "\n" . 'concepto' . " " . 'text' . ",";
$str .= "\n" . 'entrada' . " " . 'text' . ",";
$str .= "\n" . 'salida' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . 'costo_unitario' . " " . 'text' . ",";
$str .= "\n" . 'costo_promedio' . " " . 'text' . ",";
$str .= "\n" . 'debe' . " " . 'text' . ",";
$str .= "\n" . 'haber' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'marcas';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_marca' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_marca' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'ordenes_produccion';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_ordenes' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'cantidad' . " " . 'text' . ",";
$str .= "\n" . 'sub_total' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_cobrar';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cuentas_cobrar' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tipo_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_factura' . " " . 'text' . ",";
$str .= "\n" . 'total_factura' . " " . 'text' . ",";
$str .= "\n" . 'valor_pagado' . " " . 'text' . ",";
$str .= "\n" . 'saldo_factura' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_pagos_compra' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_credito' . " " . 'text' . ",";
$str .= "\n" . 'adelanto' . " " . 'text' . ",";
$str .= "\n" . 'meses' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'monto_credito' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_pagar';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_cuentas_pagar' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'tipo_pago' . " " . 'text' . ",";
$str .= "\n" . 'num_factura' . " " . 'text' . ",";
$str .= "\n" . 'tipo_factura' . " " . 'text' . ",";
$str .= "\n" . 'fecha_factura' . " " . 'text' . ",";
$str .= "\n" . 'total_factura' . " " . 'text' . ",";
$str .= "\n" . 'valor_pagado' . " " . 'text' . ",";
$str .= "\n" . 'saldo_factura' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'pagos_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_pagos_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_credito' . " " . 'text' . ",";
$str .= "\n" . 'adelanto' . " " . 'text' . ",";
$str .= "\n" . 'meses' . " " . 'text' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'monto_credito' . " " . 'text' . ",";
$str .= "\n" . 'saldo' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'parametros';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_parametro' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_empresa' . " " . 'text' . ",";
$str .= "\n" . 'ruc_empresa' . " " . 'text' . ",";
$str .= "\n" . 'telefono_empresa' . " " . 'text' . ",";
$str .= "\n" . 'direccion_empresa' . " " . 'text' . ",";
$str .= "\n" . ' propietario' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'productos';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'cod_productos' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'codigo' . " " . 'text' . ",";
$str .= "\n" . 'cod_barras' . " " . 'text' . ",";
$str .= "\n" . 'articulo' . " " . 'text' . ",";
$str .= "\n" . 'iva' . " " . 'text' . ",";
$str .= "\n" . 'series' . " " . 'text' . ",";
$str .= "\n" . 'precio_compra' . " " . 'text' . ",";
$str .= "\n" . 'utilidad_minorista' . " " . 'text' . ",";
$str .= "\n" . 'utilidad_mayorista' . " " . 'text' . ",";
$str .= "\n" . 'iva_minorista' . " " . 'text' . ",";
$str .= "\n" . 'iva_mayorista' . " " . 'text' . ",";
$str .= "\n" . 'categoria' . " " . 'text' . ",";
$str .= "\n" . 'marca' . " " . 'text' . ",";
$str .= "\n" . 'stock' . " " . 'text' . ",";
$str .= "\n" . 'stock_minimo' . " " . 'text' . ",";
$str .= "\n" . 'stock_maximo' . " " . 'text' . ",";
$str .= "\n" . 'fecha_creacion' . " " . 'text' . ",";
$str .= "\n" . 'caracteristicas' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'inventariable' . " " . 'text' . ",";
$str .= "\n" . 'existencia' . " " . 'text' . ",";
$str .= "\n" . ' diferencia' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'proforma';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_proforma' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'id_empresa' . " " . 'int4' . ",";
$str .= "\n" . 'comprobante' . " " . 'text' . ",";
$str .= "\n" . 'fecha_actual' . " " . 'text' . ",";
$str .= "\n" . 'hora_actual' . " " . 'text' . ",";
$str .= "\n" . 'tipo_precio' . " " . 'text' . ",";
$str .= "\n" . 'tarifa0' . " " . 'text' . ",";
$str .= "\n" . 'tarifa12' . " " . 'text' . ",";
$str .= "\n" . 'iva_proforma' . " " . 'text' . ",";
$str .= "\n" . 'descuento_proforma' . " " . 'text' . ",";
$str .= "\n" . 'total_proforma' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'proveedores';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_proveedor' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'tipo_documento' . " " . 'text' . ",";
$str .= "\n" . 'identificacion_pro' . " " . 'text' . ",";
$str .= "\n" . 'empresa_pro' . " " . 'text' . ",";
$str .= "\n" . 'representante_legal' . " " . 'text' . ",";
$str .= "\n" . 'visitador' . " " . 'text' . ",";
$str .= "\n" . 'direccion_pro' . " " . 'text' . ",";
$str .= "\n" . 'telefono' . " " . 'text' . ",";
$str .= "\n" . 'celular' . " " . 'text' . ",";
$str .= "\n" . 'fax' . " " . 'text' . ",";
$str .= "\n" . 'pais' . " " . 'text' . ",";
$str .= "\n" . 'ciudad' . " " . 'text' . ",";
$str .= "\n" . 'forma_pago' . " " . 'text' . ",";
$str .= "\n" . 'correo' . " " . 'text' . ",";
$str .= "\n" . 'principal' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'registro_equipo';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_registro' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_color' . " " . 'int4' . ",";
$str .= "\n" . 'id_marca' . " " . 'int4' . ",";
$str .= "\n" . 'id_cliente' . " " . 'int4' . ",";
$str .= "\n" . 'nro_serie' . " " . 'text' . ",";
$str .= "\n" . 'observaciones' . " " . 'text' . ",";
$str .= "\n" . 'detalles' . " " . 'text' . ",";
$str .= "\n" . 'estado' . " " . 'text' . ",";
$str .= "\n" . 'id_usuario' . " " . 'int4' . ",";
$str .= "\n" . 'fecha_ingreso' . " " . 'text' . ",";
$str .= "\n" . 'id_categoria' . " " . 'int4' . ",";
$str .= "\n" . 'modelo' . " " . 'text' . ",";
$str .= "\n" . 'fecha_salida' . " " . 'text' . ",";
$str .= "\n" . 'descuento' . " " . 'text' . ",";
$str .= "\n" . ' tecnico' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'seguridad';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_seguridad' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'clave' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'serie_venta';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_serie_venta' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_venta' . " " . 'int4' . ",";
$str .= "\n" . 'serie' . " " . 'text' . ",";
$str .= "\n" . 'observacion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'series_compra';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_serie' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'cod_productos' . " " . 'int4' . ",";
$str .= "\n" . 'id_factura_compra' . " " . 'int4' . ",";
$str .= "\n" . 'serie' . " " . 'text' . ",";
$str .= "\n" . 'observacion' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = '"tipoProducto"';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . '"id_tipoProducto"' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . '"nombreTipo"' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'trabajo';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_trabajo' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_trabajo' . " " . 'text' . ",";
$str .= "\n" . 'precio_trabajo' . " " . 'text' . ",";
$str .= "\n" . ' estado' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'trabajo_tecnico';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_trabajotecnico' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'id_tecnico' . " " . 'int4' . ",";
$str .= "\n" . 'id_registro' . " " . 'int4' . ",";
$str .= "\n" . 'total_reparaciones' . " " . 'text' . ",";
$str .= "\n" . ' detalles' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'usuario';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'id_usuario' . " " . 'int4' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'nombre_usuario' . " " . 'text' . ",";
$str .= "\n" . 'apellido_usuario' . " " . 'text' . ",";
$str .= "\n" . 'ci_usuario' . " " . 'text' . ",";
$str .= "\n" . 'telefono_usuario' . " " . 'text' . ",";
$str .= "\n" . 'celular_usuario' . " " . 'text' . ",";
$str .= "\n" . 'cargo_usuario' . " " . 'text' . ",";
$str .= "\n" . 'clave' . " " . 'text' . ",";
$str .= "\n" . 'email_usuario' . " " . 'text' . ",";
$str .= "\n" . 'direccion_usuario' . " " . 'text' . ",";
$str .= "\n" . ' usuario' . " " . 'text';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
//////////////////
$table = 'tbl_audit';
$str .= "\n--\n";
$str .= "-- Estrutura de la tabla '{$table}'";
$str .= "\n--\n";
$str .= "\nDROP TABLE {$table} CASCADE;";
$str .= "\nCREATE SEQUENCE tbl_audit_pk_audit_seq\n START WITH {$max}\n INCREMENT BY 1\n NO MINVALUE\n NO MAXVALUE\n CACHE 1;";
$str .= "\nCREATE TABLE {$table} (";
$str .= "\n" . 'pk_audit' . " " . 'int4' . " " . "NOT NULL DEFAULT nextval('tbl_audit_pk_audit_seq'::regclass) " . ",";
$str .= "\n" . 'nombre_tabla' . " " . 'text' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'operacion' . " " . 'character(1)' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'valor_anterior' . " " . 'text' . ",";
$str .= "\n" . 'valor_nuevo' . " " . 'text' . ",";
$str .= "\n" . 'fecha_cambio' . " " . 'timestamp' . " " . 'NOT NULL' . ",";
$str .= "\n" . 'usuario' . " " . 'text' . " " . 'NOT NULL';
$str = rtrim($str, ",");
$str .= "\n);\n";
$str .= "\n--\n";
$str .= "-- Creating data for '{$table}'";
$str .= "\n--\n\n";
$res3 = pg_query("SELECT * FROM {$table}");
while ($r = pg_fetch_row($res3)) {
$sql = "INSERT INTO {$table} VALUES ('";
$sql .= utf8_decode(implode("','", $r));
$sql .= "');";
$str = str_replace("''", "NULL", $str);
$str .= $sql;
$str .= "\n";
}
$res1 = pg_query("SELECT pg_index.indisprimary,\n pg_catalog.pg_get_indexdef(pg_index.indexrelid)\n FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,\n pg_catalog.pg_index AS pg_index\n WHERE c.relname = '{$table}'\n AND c.oid = pg_index.indrelid\n AND pg_index.indexrelid = c2.oid\n AND pg_index.indisprimary");
while ($r = pg_fetch_row($res1)) {
$str .= "\n\n--\n";
$str .= "-- Creating index for '{$table}'";
$str .= "\n--\n\n";
$t = str_replace("CREATE UNIQUE INDEX", "", $r[1]);
$t = str_replace("USING btree", "|", $t);
// Next Line Can be improved!!!
$t = str_replace("ON", "|", $t);
$Temparray = explode("|", $t);
$str .= "ALTER TABLE ONLY " . $Temparray[1] . " ADD CONSTRAINT " . $Temparray[0] . " PRIMARY KEY " . $Temparray[2] . ";\n";
}
///////////////
///////////////////////////////
$res = pg_query(" SELECT\n cl.relname AS tabela,ct.conname,\n pg_get_constraintdef(ct.oid)\n FROM pg_catalog.pg_attribute a\n JOIN pg_catalog.pg_class cl ON (a.attrelid = cl.oid AND cl.relkind = 'r')\n JOIN pg_catalog.pg_namespace n ON (n.oid = cl.relnamespace)\n JOIN pg_catalog.pg_constraint ct ON (a.attrelid = ct.conrelid AND\n ct.confrelid != 0 AND ct.conkey[1] = a.attnum)\n JOIN pg_catalog.pg_class clf ON (ct.confrelid = clf.oid AND \nclf.relkind = 'r')\n JOIN pg_catalog.pg_namespace nf ON (nf.oid = clf.relnamespace)\n JOIN pg_catalog.pg_attribute af ON (af.attrelid = ct.confrelid AND\n af.attnum = ct.confkey[1]) order by cl.relname ");
while ($row = pg_fetch_row($res)) {
$str .= "\n\n--\n";
$str .= "-- Creating relacionships for '" . $row[0] . "'";
$str .= "\n--\n\n";
$str .= "ALTER TABLE ONLY " . $row[0] . " ADD CONSTRAINT " . $row[1] . " " . $row[2] . ";";
}
////////////////////
/////////////////
$str .= "\nCREATE TRIGGER c_cobrarexternas_tg_audit AFTER INSERT OR UPDATE OR DELETE ON c_cobrarexternas FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER c_pagarexternas_tg_audit AFTER INSERT OR UPDATE OR DELETE ON c_pagarexternas FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER categoria_tg_audit AFTER INSERT OR UPDATE OR DELETE ON categoria FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER clientes_tg_audit AFTER INSERT OR UPDATE OR DELETE ON clientes FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER color_tg_audit AFTER INSERT OR UPDATE OR DELETE ON color FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_devolucion_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_devolucion_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_devolucion_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_devolucion_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_egreso_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_egreso FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_factura_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_factura_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_factura_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_factura_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_ingreso_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_ingreso FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_inventario_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_inventario FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_pagos_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_pagos_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalle_proforma_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalle_proforma FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalles_ordenes_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalles_ordenes FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalles_pagos_internos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalles_pagos_internos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER detalles_trabajo_tg_audit AFTER INSERT OR UPDATE OR DELETE ON detalles_trabajo FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER devolucion_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON devolucion_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER devolucion_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON devolucion_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER egresos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON egresos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER empresa_tg_audit AFTER INSERT OR UPDATE OR DELETE ON empresa FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER factura_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON factura_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER factura_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON factura_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER gastos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON gastos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER gastos_internos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON gastos_internos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER ingresos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON ingresos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER inventario_tg_audit AFTER INSERT OR UPDATE OR DELETE ON inventario FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER kardex_tg_audit AFTER INSERT OR UPDATE OR DELETE ON kardex FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER kardex_valorizado_tg_audit AFTER INSERT OR UPDATE OR DELETE ON kardex_valorizado FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER marcas_tg_audit AFTER INSERT OR UPDATE OR DELETE ON marcas FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER ordenes_produccion_tg_audit AFTER INSERT OR UPDATE OR DELETE ON ordenes_produccion FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER pagos_cobrar_tg_audit AFTER INSERT OR UPDATE OR DELETE ON pagos_cobrar FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER pagos_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON pagos_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER pagos_pagar_tg_audit AFTER INSERT OR UPDATE OR DELETE ON pagos_pagar FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER pagos_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON pagos_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER parametros_tg_audit AFTER INSERT OR UPDATE OR DELETE ON parametros FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER productos_tg_audit AFTER INSERT OR UPDATE OR DELETE ON productos FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER proforma_tg_audit AFTER INSERT OR UPDATE OR DELETE ON proforma FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER proveedores_tg_audit AFTER INSERT OR UPDATE OR DELETE ON proveedores FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER registro_equipo_tg_audit AFTER INSERT OR UPDATE OR DELETE ON registro_equipo FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER seguridad_tg_audit AFTER INSERT OR UPDATE OR DELETE ON seguridad FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER serie_venta_tg_audit AFTER INSERT OR UPDATE OR DELETE ON serie_venta FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER series_compra_tg_audit AFTER INSERT OR UPDATE OR DELETE ON series_compra FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER tipoproducto_tg_audit AFTER INSERT OR UPDATE OR DELETE ON " . '"tipoProducto"' . " FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER trabajo_tg_audit AFTER INSERT OR UPDATE OR DELETE ON trabajo FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER trabajo_tecnico_tg_audit AFTER INSERT OR UPDATE OR DELETE ON trabajo_tecnico FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
$str .= "\nCREATE TRIGGER usuario_tg_audit AFTER INSERT OR UPDATE OR DELETE ON usuario FOR EACH ROW EXECUTE PROCEDURE fn_log_audit();";
////////////////
fwrite($back, $str);
fclose($back);
dl_file("{$dbname}.sql");
}
$ctype = "application/pdf";
break;
case "zip":
$ctype = "application/zip";
break;
default:
$ctype = "application/force-download";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-Type: {$ctype}");
$header = "Content-Disposition: attachment; filename=" . $filename . ";";
header($header);
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . $len);
@readfile($file);
exit;
}
$abs_img_path = url_to_abs_path($image);
if (is_file($abs_img_path)) {
if (stristr($image, "wp-content/uploads") !== FALSE) {
dl_file($abs_img_path);
} else {
die("Sorry, error.");
}
} else {
die("Sorry, couldn't find the file.");
}
