Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

FSx-Connector troubles


Aefe

Recommended Posts

Hello.

 

I couldn't find any section for this AddOn (I believe this is the section it goes, if not, please point me to where should I post this) and I really ran out of places where to look to find the solutions I need.

 

So, this FSx-Connector was made to work with FactuSOL (a commerce managment software) and osCommerce to basically use the forementioned software's database directly as an e-store . And there are a few guides to make it work but they are all discontinued and I can't seem to fix the issues I have.

I'm going to explain the troubles I have and If someone can help me and doesn't understand where the things I did came from, I can detail them later.

 

A) The guide says:

3 - Go to your osCommerce Administration Panel

3.1 - Update osCommerce Database

3.2 - Back up your Database"

 

For me, instead of looking like this:

 

error1bl.jpg

 

It looks like this:

 

error1ag.jpg

 

Meaning that I have no further options to manage. Off course I clicked on it and this is what it says:

 

error2n.jpg

 

Which means: "A Factusol installation hasn't been found" and you can either go back or go to FactuSol's development site (They didn't answer my questions yet....)

 

B) Then, this it what it follows that I can't seem to do either (I know it's not an osCommerce specific trouble but maybe they are related and maybe then people here can help me with that too):

"3.4 - Execute script fsxq.php from your browser.

- This script creates various tables. If they exist already they'll be deleted.

- It modifies Customers' and Orders' tables adding customers_id.

Remember: FSx Connector uses orders_date_finished from Orders' table to control what requests had been downloaded.

 

4.- Delete script fsxq.php."

 

While inside phpMyAdmin, I did a new SQL query with the data I get from this "script fsxq.php" and this is what I get:

 

error4r.jpg

 

Note: I also tried using the Import feature but I got the same result.

 

 

Thanks in advance. Hope that you guys can help me.

 

 

P.S: Sorry for my english.

P.S2: As I said before, I can detail other steps if someone needs to know more.

Edited by Aefe
Link to comment
Share on other sites

@@Aefe

 

There should be an SQL statement included within the fsxq.php file, that is what should be run using PHPMYMADMIN SQL tab. It appears the fsxq.php is being run in it's entirety as an SQL Statement which is causing the error in the database.

 

Extract the SQL statement from the PHP file and run it manually using PHPMYADMIN

 

 

 

Chris

Link to comment
Share on other sites

Hello Chris, thank you for your entry.

 

As you may figure by now, I'm not an expert in this subject so I'm learning as it goes. With that being said, I don't know what is the "Exact statement" I should extract. This is the script, can you show me?

 

<?php

/*

$Id: shop_qwery.php RWS $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

function rws_UpdateQuery($query) {

$val = true;

$result = tep_db_query($query) or $val = error();

return $val;

}

 

function error() {

return false;

}

 

$breadcrumb->add('oscUpdate', tep_href_link(FILENAME_DEFAULT));

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<tr>

<td> 

</td>

</tr>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><!-- table border="0" width="100%" cellspacing="0" cellpadding="0" -->

 

 

<?php

 

$id=0;

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `fsx_configuration`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `fsx_configuration`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `fsx_configuration` (

`configuration_id` int(11) NOT NULL auto_increment,

`configuration_title` varchar(255) NOT NULL,

`configuration_key` varchar(255) NOT NULL,

`configuration_value` varchar(255) NOT NULL,

`configuration_description` varchar(255) NOT NULL,

`configuration_group_id` int(11) NOT NULL,

`sort_order` int(5) default NULL,

`last_modified` datetime default NULL,

`date_added` datetime NOT NULL,

`use_function` varchar(255) default NULL,

`set_function` varchar(255) default NULL,

PRIMARY KEY (`configuration_id`)

) AUTO_INCREMENT=1626 ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `fsx_configuration`

// -

 

$id ++;

define('Q'.$id, "INSERT INTO `fsx_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES

(101, 'Idioma destino', 'FSOL_LANGUAGE_ISO', 'es', 'Idioma de la Tienda donde se cargarán los textos (código ISO).<br />Ponga ''es'' para español.', 1, 1, '2009-03-20 18:47:34', '0000-00-00 00:00:00', 'rws_get_language_name', 'rws_cfg_pull_down_languages('),

(1611, '', 'FSOLWEB_SQL_LAST_DBUPDATE', '0000-00-00 00:00:00', '', 16, 11, NULL, '0000-00-00 00:00:00', NULL, NULL),

(1612, '', 'FSX_CATALOGUE_LAST_RUN_DATE', '0000-00-00 00:00:00', '', 16, 12, NULL, '0000-00-00 00:00:00', NULL, NULL),

(1613, '', 'FSX_ORDERS_LAST_RUN_DATE', '0000-00-00 00:00:00', '', 16, 13, NULL, '0000-00-00 00:00:00', NULL, NULL),

(1614, '', 'OSC_LAST_DLOADED_ORDER', '0', '', 16, 14, NULL, '0000-00-00 00:00:00', NULL, NULL),

(201, 'FactuSol : Impuesto Directo Tipo 1 (TIVART=0)', 'FSOL_IMPUESTO_DIRECTO_TIPO_1', '', 'Normalmente corresponde a IVA 16%', 21, 1, '2009-03-16 18:55:06', '0000-00-00 00:00:00', 'rws_get_tax_class_name', 'rws_cfg_pull_down_tax_classes('),

(202, 'FactuSol : Impuesto Directo Tipo 2 (TIVART=1)', 'FSOL_IMPUESTO_DIRECTO_TIPO_2', '', 'Normalmente corresponde a IVA 7%', 21, 2, '2009-03-16 18:44:15', '0000-00-00 00:00:00', 'rws_get_tax_class_name', 'rws_cfg_pull_down_tax_classes('),

(203, 'FactuSol : Impuesto Directo Tipo 3 (TIVART=2)', 'FSOL_IMPUESTO_DIRECTO_TIPO_3', '', 'Normalmente corresponde a IVA 4%', 21, 3, '2009-03-16 18:44:23', '0000-00-00 00:00:00', 'rws_get_tax_class_name', 'rws_cfg_pull_down_tax_classes('),

 

(601, 'Cargar Secciones', 'FSOL_LOAD_SECCIONES', 'true', 'Cargar Secciones', 6, 1, '2009-04-09 04:33:53', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true''),'),

(603, 'Cargar Familias', 'FSOL_LOAD_FAMILIAS', 'true', 'Cargar Familias', 6, 3, '2009-04-07 13:35:35', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true''),'),

(605, 'Familias en la raíz del Catálogo', 'FSOL_LOAD_FAMILIAS_TO_ROOT', 'false', 'Cargar Familias en la raíz del Catálogo.<br /><strong>Atención:</strong><br /> si selecciona ''true'', entonces ''Cargar Secciones'' debería ser ''false''', 6, 5, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''false''),'),

(612, 'Cargar Artículos', 'FSOL_LOAD_ARTICULOS', 'true', 'Cargar Artículos', 6, 12, '2009-04-07 13:33:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true''),'),

 

(615, 'Activar nuevos Artículos?', 'FSOL_LOAD_ARTICULOS_ACTIVE', 'true', 'Nuevos Artículos tienen status ''Activo''', 6, 15, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(616, 'Categoría por defecto', 'FSOL_ARTICULOS_CAT_NOT_FOUND', '3', 'Si no existe la Categoría del Artículo, asociarle esta Categoría (Si no selecciona ninguna, se cargarán en la raíz del Catálogo)', 6, 16, '2009-03-31 05:57:49', '0000-00-00 00:00:00', 'rws_get_category_name', 'rws_cfg_pull_down_categories('),

 

(701, 'Código base para FactuSol', 'FSOL_CUSTOMER_CODE_BASE', '50000', 'Los Clientes que se importan a FactuSol se numeran a partir de este valor', 7, 1, '2009-04-09 05:32:11', '0000-00-00 00:00:00', NULL, NULL),

(801, 'Pedidos sólo desde el País de la Tienda', 'FSOL_ORDERS_COUNTRY_ONLY', 'false', 'Descargar únicamente los Pedidos realizados desde el País de la Tienda (las Direcciones de Entrega y Pago están en el País de la Tienda)', 8, 1, '2009-04-09 05:34:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(802, 'Clase de Impuesto para Costes de Envío', 'OSC_SHIPPING_TAX_CLASS', '2', 'Aplicar la siguiente Clase de Impuesto a los Costes de Envío', 8, 2, '2009-03-24 17:26:04', '0000-00-00 00:00:00', 'rws_get_tax_class_name', 'tep_cfg_pull_down_tax_classes('),

(803, 'Descargar Pedidos por Estatus', 'OSC_ORDER_TO_DOWNLOAD_STATUS_ID', '1', 'Descargar sólo los Pedidos con el Estatus seleccionado', 8, 3, NULL, '0000-00-00 00:00:00', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('),

(804, 'Cambiar el Estatus de los Pedidos', 'OSC_ORDER_DOWNLOADED_STATUS_ID', '2', 'El Estatus de los Pedidos descargados se cambiará al Estatus seleccionado', 8, 4, NULL, '0000-00-00 00:00:00', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(')

");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `fsx_configuration` (PREMIUM)

// -

 

$id ++;

define('Q'.$id, "INSERT INTO `fsx_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES

(102, 'Ordenación del LOG', 'FSX_LOG_SORTING', 'DESC', 'DESC: El mensaje más reciente aparece el primero', 1, 2, '2009-03-20 19:43:30', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'),

(103, 'LOG. Filtrar mensajes ''INFO''', 'FSX_LOG_FILTER_INFO', 'false', 'Por defecto, el LOG se muestra ocultando estos mensajes', 1, 3, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(104, 'LOG. Filtrar mensajes ''AVISO''', 'FSX_LOG_FILTER_AVISO', 'false', 'Por defecto, el LOG se muestra ocultando estos mensajes', 1, 4, '2009-03-31 05:53:42', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(105, 'Vaciar el LOG', 'FSX_LOG_EMPTY_BEFORE_RUN', 'true', 'El LOG se vacía antes de iniciar un proceso de carga del Catálogo, o de descarga de Clientes / Pedidos', 1, 5, '2009-03-20 18:55:18', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(106, 'LOG. Mensajes por Página', 'FSX_LOG_MESSAGES_PER_PAGE', '10', 'Número de mensajes que se mostrarán por página', 1, 6, '2009-03-18 12:33:36', '0000-00-00 00:00:00', NULL, NULL),

(1615, '', 'FSX_SOURCE_ROOT', 'PHP;Catalog;none', '', 16, 15, NULL, '0000-00-00 00:00:00', NULL, NULL),

(1616, '', 'FSX_NEED_INITIALIZE', 'true', '', 16, 16, NULL, '0000-00-00 00:00:00', NULL, NULL),

(1617, '', 'FSX_SERVER_STRING', 'Basic', '', 16, 17, NULL, '0000-00-00 00:00:00', NULL, NULL),

 

(613, 'Actualizar precios', 'FSOL_LOAD_ARTICULOS_PRIZE_ALL', 'false', 'Actualizar precios de todos los Artículos', 6, 13, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(614, 'Actualizar stock', 'FSOL_LOAD_ARTICULOS_STOCK_ALL', 'false', 'Actualizar stock de todos los Artículos', 6, 14, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

 

(621, 'Desactivar los Productos no encontrados', 'FSOL_PROD_OSC_ONLY_DEACTIVATE', 'false', 'Desactivar los Productos de la Tienda que no tienen correspondencia en Factusol', 6, 21, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''false''),'),

(622, 'Imagen por Defecto', 'FSOL_ARTICULOS_IMG_NOT_FOUND', '-none-', 'Imagen por defecto para Categorías y Productos', 6, 22, '2009-04-09 04:33:33', '0000-00-00 00:00:00', NULL, 'rws_cfg_pull_down_image_sets('),

 

(702, 'Campo para el NIF/CIF', 'OSC_VAT_ID_FIELD', 'billing_nif', 'Campo de la tabla de Pedidos donde se guarda el NIF/CIF/NIE. Dejar en blanco si no se tiene la contribución instalada', 7, 2, '2009-04-09 05:32:11', '0000-00-00 00:00:00', NULL, NULL),

 

(805, 'Descargar Pedidos anteriores', 'OSC_DOWNLOAD_ALL_ORDERS', 'true', 'Comprueba Pedidos anteriores al último descargado', 8, 5, '2009-04-09 05:35:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(806, 'Descargar todos los Clientes', 'OSC_DOWNLOAD_ALL_CUSTOMERS_WO', 'true', 'Descargar los Clientes de los Pedidos, aunque se hayan descargado a FactuSol anteriormente', 8, 6, '2009-04-09 05:35:07', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(807, 'Descargar Pedidos con Dirección de Entrega', 'OSC_DOWNLOAD_ORDERS_SHIPPING_ADDRESS', 'true', 'Descargar Pedidos que la Dirección de Entrega es diferente de la Dirección Principal del Cliente', 8, 7, '2009-03-31 06:35:36', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),

(808, 'Usar el nombre web de los Artículos', 'FSX_USE_WEB_DESCRIPTIONS', 'true', '<b>true:</b> Usa el nombre web de los Artículos<br /><b>false:</b> Usa el nombre de FactuSol', 8, 8, '2009-03-31 06:35:36', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true''),')

");

define('_Q'.$id, '- ');

 

/*

 

Basic

 

*/

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `fsx_configuration_group`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `fsx_configuration_group`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `fsx_configuration_group` (

`configuration_group_id` int(11) NOT NULL auto_increment,

`configuration_group_title` varchar(64) NOT NULL,

`configuration_group_description` varchar(255) NOT NULL,

`sort_order` int(5) default NULL,

`visible` int(1) default '1',

PRIMARY KEY (`configuration_group_id`)

) AUTO_INCREMENT=23 ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `fsx_configuration_group`

// -

 

$id ++;

define('Q'.$id, "INSERT INTO `fsx_configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES

(1, 'FSx General', 'Conector con FactuSol - Valores Generales', 1, 1),

(21, 'FSx Diccionario FSol', 'Conector con FactuSol - Diccionario FSol -> osC', 2, 1),

(22, 'FSx Diccionario osC', 'Conector con FactuSol - Diccionario osC -> FSol', 2, 1),

(6, 'FSx Artículos', 'Conector con FactuSol - Artículos', 6, 1),

(7, 'FSx Clientes', 'Conector con FactuSol - Clientes', 7, 1),

(8, 'FSx Pedidos', 'Conector con FactuSol - Pedidos', 8, 1),

(16, 'FSx Module Options', 'Conector con FactuSol - Module Options', 16, 0)");

define('_Q'.$id, '- ');

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `fsx_dic`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `fsx_dic`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `fsx_dic` (

`fsol_group_key` varchar(64) NOT NULL,

`fsol_value` varchar(255) NOT NULL,

`osc_value` varchar(255) NOT NULL,

`last_modified` datetime NOT NULL default '0000-00-00 00:00:00',

`date_added` datetime NOT NULL default '0000-00-00 00:00:00',

KEY `fsol_group_key` (`fsol_group_key`,`fsol_value`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `fsx_dic`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `fsx_log`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `fsx_log`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `fsx_log` (

`line_id` int(11) NOT NULL auto_increment,

`line_type` varchar(32) NOT NULL,

`line_message` varchar(255) default NULL,

`date_added` datetime default '0000-00-00 00:00:00',

`secs_added` int(6) NOT NULL default '0',

PRIMARY KEY (`line_id`),

KEY `IDX_MICROTIME` (`date_added`,`secs_added`)

) AUTO_INCREMENT=6 ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `fsx_log`

// -

 

$id ++;

define('Q'.$id, "INSERT INTO `fsx_log` (`line_id`, `line_type`, `line_message`, `date_added`, `secs_added`) VALUES

(1, 'INFO', 'LOG reiniciado', '2009-01-01 00:00:00', 10594)");

define('_Q'.$id, '- ');

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_AGE`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_AGE`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_AGE` (

`CUWAGE` varchar(50) NOT NULL,

`CAWAGE` varchar(15) NOT NULL,

`CODAGE` int(11) NOT NULL,

`NOMAGE` varchar(40) NOT NULL,

`COMAGE` smallint(6) NOT NULL,

`MEWAGE` varchar(255) NOT NULL,

PRIMARY KEY (`CODAGE`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_AGE`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_ALM`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_ALM`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_ALM` (

`CODALM` varchar(3) NOT NULL,

`NOMALM` varchar(50) NOT NULL,

`OBSALM` varchar(100) NOT NULL,

PRIMARY KEY (`CODALM`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_ALM`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_ART`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_ART`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_ART` (

`CODART` varchar(13) NOT NULL,

`EANART` varchar(13) NOT NULL,

`FAMART` varchar(3) NOT NULL,

`DESART` varchar(50) NOT NULL,

`DEWART` text NOT NULL,

`TIVART` smallint(6) NOT NULL,

`CP1ART` varchar(25) NOT NULL,

`CP2ART` varchar(25) NOT NULL,

`CP3ART` varchar(25) NOT NULL,

`IMGART` varchar(100) NOT NULL,

`MEWART` varchar(255) NOT NULL,

`CSTART` smallint(6) NOT NULL,

`USTART` decimal(12,4) NOT NULL,

`FUMART` datetime NOT NULL,

PRIMARY KEY (`CODART`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_ART`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_AUT`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_AUT`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_AUT` (

`CODAUT` tinyint(4) NOT NULL,

`IVA1AUT` decimal(12,4) NOT NULL,

`IVA2AUT` decimal(12,4) NOT NULL,

`IVA3AUT` decimal(12,4) NOT NULL,

`REQ1AUT` decimal(12,4) NOT NULL,

`REQ2AUT` decimal(12,4) NOT NULL,

`REQ3AUT` decimal(12,4) NOT NULL,

`MARARTAUT` smallint(6) NOT NULL,

`UDAARTAUT` smallint(6) NOT NULL,

`BLQARTAUT` smallint(6) NOT NULL,

`RDNARTAUT` smallint(6) NOT NULL,

`PR1ARTAUT` int(11) NOT NULL,

`PR2ARTAUT` int(11) NOT NULL,

`PI1ARTAUT` smallint(6) NOT NULL,

`PI2ARTAUT` smallint(6) NOT NULL,

`CP1ARTAUT` varchar(20) NOT NULL,

`CP2ARTAUT` varchar(20) NOT NULL,

`CP3ARTAUT` varchar(20) NOT NULL,

`NA1PPRAUT` int(11) NOT NULL,

`NA2PPRAUT` int(11) NOT NULL,

`NA3PPRAUT` int(11) NOT NULL,

`NA4PPRAUT` int(11) NOT NULL,

`NA5PPRAUT` int(11) NOT NULL,

`NA6PPRAUT` int(11) NOT NULL,

`NA7PPRAUT` int(11) NOT NULL,

`NA8PPRAUT` int(11) NOT NULL,

`NA9PPRAUT` int(11) NOT NULL,

`TDOPPRAUT` varchar(1) NOT NULL,

`ALMPPRAUT` varchar(3) NOT NULL,

`FPAPPRAUT` varchar(3) NOT NULL,

`RDNPPRAUT` smallint(6) NOT NULL,

`PPEPPRAUT` smallint(6) NOT NULL,

`PPAPPRAUT` smallint(6) NOT NULL,

`PREPPRAUT` smallint(6) NOT NULL,

`TDVPPRAUT` varchar(9) NOT NULL,

`VPMPPRAUT` smallint(6) NOT NULL,

`AITPPRAUT` smallint(6) NOT NULL,

`NOTPPRAUT` varchar(200) NOT NULL,

`TPEPPRAUT` smallint(6) NOT NULL,

`NA1PREAUT` int(11) NOT NULL,

`NA2PREAUT` int(11) NOT NULL,

`NA3PREAUT` int(11) NOT NULL,

`NA4PREAUT` int(11) NOT NULL,

`NA5PREAUT` int(11) NOT NULL,

`NA6PREAUT` int(11) NOT NULL,

`NA7PREAUT` int(11) NOT NULL,

`NA8PREAUT` int(11) NOT NULL,

`NA9PREAUT` int(11) NOT NULL,

`TDOPREAUT` varchar(1) NOT NULL,

`ALMPREAUT` varchar(3) NOT NULL,

`FPAPREAUT` varchar(3) NOT NULL,

`I1HPREAUT` varchar(15) NOT NULL,

`I2HPREAUT` varchar(15) NOT NULL,

`RDNPREAUT` smallint(6) NOT NULL,

`UAGPREAUT` smallint(6) NOT NULL,

`UDEPREAUT` smallint(6) NOT NULL,

`PRRPREAUT` smallint(6) NOT NULL,

`PRAPREAUT` smallint(6) NOT NULL,

`TDVPREAUT` varchar(9) NOT NULL,

`VPMPREAUT` smallint(6) NOT NULL,

`NOTPREAUT` varchar(200) NOT NULL,

`TPEPREAUT` smallint(6) NOT NULL,

`AITPREAUT` smallint(6) NOT NULL,

`ICAPREAUT` smallint(6) NOT NULL,

`NA1PCLAUT` int(11) NOT NULL,

`NA2PCLAUT` int(11) NOT NULL,

`NA3PCLAUT` int(11) NOT NULL,

`NA4PCLAUT` int(11) NOT NULL,

`NA5PCLAUT` int(11) NOT NULL,

`NA6PCLAUT` int(11) NOT NULL,

`NA7PCLAUT` int(11) NOT NULL,

`NA8PCLAUT` int(11) NOT NULL,

`NA9PCLAUT` int(11) NOT NULL,

`TDOPCLAUT` varchar(1) NOT NULL,

`ALMPCLAUT` varchar(3) NOT NULL,

`FPAPCLAUT` varchar(3) NOT NULL,

`RDNPCLAUT` smallint(6) NOT NULL,

`UAGPCLAUT` smallint(6) NOT NULL,

`UDEPCLAUT` smallint(6) NOT NULL,

`PPEPCLAUT` smallint(6) NOT NULL,

`PENPCLAUT` smallint(6) NOT NULL,

`PEPPCLAUT` smallint(6) NOT NULL,

`TDVPCLAUT` varchar(9) NOT NULL,

`VPMPCLAUT` smallint(6) NOT NULL,

`NOTPCLAUT` varchar(200) NOT NULL,

`TPEPCLAUT` smallint(6) NOT NULL,

`AITPCLAUT` smallint(6) NOT NULL,

`ICAPCLAUT` smallint(6) NOT NULL,

`NA1ALBAUT` int(11) NOT NULL,

`NA2ALBAUT` int(11) NOT NULL,

`NA3ALBAUT` int(11) NOT NULL,

`NA4ALBAUT` int(11) NOT NULL,

`NA5ALBAUT` int(11) NOT NULL,

`NA6ALBAUT` int(11) NOT NULL,

`NA7ALBAUT` int(11) NOT NULL,

`NA8ALBAUT` int(11) NOT NULL,

`NA9ALBAUT` int(11) NOT NULL,

`TDOALBAUT` varchar(1) NOT NULL,

`ALMALBAUT` varchar(3) NOT NULL,

`FPAALBAUT` varchar(3) NOT NULL,

`RDNALBAUT` smallint(6) NOT NULL,

`UAGALBAUT` smallint(6) NOT NULL,

`UDEALBAUT` smallint(6) NOT NULL,

`TDVALBAUT` varchar(9) NOT NULL,

`VPMALBAUT` smallint(6) NOT NULL,

`NOTALBAUT` varchar(200) NOT NULL,

`TPEALBAUT` smallint(6) NOT NULL,

`AITALBAUT` smallint(6) NOT NULL,

`ICAALBAUT` smallint(6) NOT NULL,

`VLAALBAUT` int(11) NOT NULL,

`IAAALBAUT` smallint(6) NOT NULL,

`NA1FACAUT` int(11) NOT NULL,

`NA2FACAUT` int(11) NOT NULL,

`NA3FACAUT` int(11) NOT NULL,

`NA4FACAUT` int(11) NOT NULL,

`NA5FACAUT` int(11) NOT NULL,

`NA6FACAUT` int(11) NOT NULL,

`NA7FACAUT` int(11) NOT NULL,

`NA8FACAUT` int(11) NOT NULL,

`NA9FACAUT` int(11) NOT NULL,

`TDOFACAUT` varchar(1) NOT NULL,

`ALMFACAUT` varchar(3) NOT NULL,

`FPAFACAUT` varchar(3) NOT NULL,

`RDNFACAUT` smallint(6) NOT NULL,

`UAGFACAUT` smallint(6) NOT NULL,

`UDEFACAUT` smallint(6) NOT NULL,

`TDVFACAUT` varchar(9) NOT NULL,

`VPMFACAUT` smallint(6) NOT NULL,

`NOTFACAUT` varchar(200) NOT NULL,

`TPEFACAUT` smallint(6) NOT NULL,

`AITFACAUT` smallint(6) NOT NULL,

`ICAFACAUT` smallint(6) NOT NULL,

`VLFFACAUT` int(11) NOT NULL,

`FCNFACAUT` smallint(6) NOT NULL,

`APAFACAUT` smallint(6) NOT NULL,

`INAFACAUT` smallint(6) NOT NULL,

`IFAFACAUT` int(11) NOT NULL,

`IRAFACAUT` smallint(6) NOT NULL,

`TRAFACAUT` varchar(50) NOT NULL,

`TAFFACAUT` varchar(9) NOT NULL,

`IAAFACAUT` smallint(6) NOT NULL,

`NA1RECAUT` int(11) NOT NULL,

`NA2RECAUT` int(11) NOT NULL,

`NA3RECAUT` int(11) NOT NULL,

`NA4RECAUT` int(11) NOT NULL,

`NA5RECAUT` int(11) NOT NULL,

`NA6RECAUT` int(11) NOT NULL,

`NA7RECAUT` int(11) NOT NULL,

`NA8RECAUT` int(11) NOT NULL,

`NA9RECAUT` int(11) NOT NULL,

`TDORECAUT` varchar(1) NOT NULL,

`RDNRECAUT` smallint(6) NOT NULL,

`PENRECAUT` smallint(6) NOT NULL,

`COBRECAUT` smallint(6) NOT NULL,

`COPRECAUT` smallint(6) NOT NULL,

`TDVRECAUT` varchar(9) NOT NULL,

`NOTRECAUT` varchar(200) NOT NULL,

`MODRECAUT` smallint(6) NOT NULL,

`LAIRECAUT` smallint(6) NOT NULL,

`LDIRECAUT` smallint(6) NOT NULL,

`NCORECAUT` smallint(6) NOT NULL,

`ICARECAUT` smallint(6) NOT NULL,

`GCNRECAUT` smallint(6) NOT NULL,

`NF1RECAUT` smallint(6) NOT NULL,

`NF2RECAUT` smallint(6) NOT NULL,

`RFPRECAUT` smallint(6) NOT NULL,

`TFGRECAUT` varchar(9) NOT NULL,

`CO1RECAUT` varchar(60) NOT NULL,

`CO2RECAUT` varchar(60) NOT NULL,

`NA1ENTAUT` int(11) NOT NULL,

`NA2ENTAUT` int(11) NOT NULL,

`NA3ENTAUT` int(11) NOT NULL,

`NA4ENTAUT` int(11) NOT NULL,

`NA5ENTAUT` int(11) NOT NULL,

`NA6ENTAUT` int(11) NOT NULL,

`NA7ENTAUT` int(11) NOT NULL,

`NA8ENTAUT` int(11) NOT NULL,

`NA9ENTAUT` int(11) NOT NULL,

`TDOENTAUT` varchar(1) NOT NULL,

`ALMENTAUT` varchar(3) NOT NULL,

`FPAENTAUT` varchar(3) NOT NULL,

`RDNENTAUT` smallint(6) NOT NULL,

`APVENTAUT` smallint(6) NOT NULL,

`ACTENTAUT` smallint(6) NOT NULL,

`ADEENTAUT` smallint(6) NOT NULL,

`EPEENTAUT` smallint(6) NOT NULL,

`EPAENTAUT` smallint(6) NOT NULL,

`EFAENTAUT` smallint(6) NOT NULL,

`TDVENTAUT` varchar(9) NOT NULL,

`VPMENTAUT` smallint(6) NOT NULL,

`ICAENTAUT` smallint(6) NOT NULL,

`VLFENTAUT` int(11) NOT NULL,

`AITENTAUT` smallint(6) NOT NULL,

`NOTENTAUT` varchar(200) NOT NULL,

`TPEENTAUT` smallint(6) NOT NULL,

`NA1FREAUT` int(11) NOT NULL,

`NA2FREAUT` int(11) NOT NULL,

`NA3FREAUT` int(11) NOT NULL,

`NA4FREAUT` int(11) NOT NULL,

`NA5FREAUT` int(11) NOT NULL,

`NA6FREAUT` int(11) NOT NULL,

`NA7FREAUT` int(11) NOT NULL,

`NA8FREAUT` int(11) NOT NULL,

`NA9FREAUT` int(11) NOT NULL,

`TDOFREAUT` varchar(1) NOT NULL,

`FPAFREAUT` varchar(3) NOT NULL,

`RDNFREAUT` int(11) NOT NULL,

`UDEFREAUT` int(11) NOT NULL,

`PENFREAUT` smallint(6) NOT NULL,

`PAGFREAUT` smallint(6) NOT NULL,

`PAPFREAUT` smallint(6) NOT NULL,

`TDVFREAUT` varchar(9) NOT NULL,

`NOTFREAUT` varchar(200) NOT NULL,

`ICAFREAUT` smallint(6) NOT NULL,

`TPEFREAUT` smallint(6) NOT NULL,

`AITFREAUT` smallint(6) NOT NULL,

`VLFFREAUT` int(11) NOT NULL,

`FPNFREAUT` smallint(6) NOT NULL,

`APAFREAUT` smallint(6) NOT NULL,

`INEFREAUT` smallint(6) NOT NULL,

`IFEFREAUT` int(11) NOT NULL,

`IREFREAUT` smallint(6) NOT NULL,

`TRAFREAUT` varchar(50) NOT NULL,

`TEFFREAUT` varchar(10) NOT NULL,

`CPALCOAUT` varchar(200) NOT NULL,

`CPALPFAUT` varchar(200) NOT NULL,

`CFGAUT` varchar(250) NOT NULL,

`CONRIEAUT` smallint(6) NOT NULL,

`BO1RIEAUT` smallint(6) NOT NULL,

`BO2RIEAUT` smallint(6) NOT NULL,

`BO3RIEAUT` smallint(6) NOT NULL,

`ALBRIEAUT` varchar(9) NOT NULL,

`FPCRIEAUT` varchar(3) NOT NULL,

`NUMDECAUT` smallint(6) NOT NULL,

`MAEAUT` int(11) NOT NULL,

`NUMUNIAUT` smallint(6) NOT NULL,

`GP1ENTAUT` varchar(25) NOT NULL,

`GP2ENTAUT` varchar(25) NOT NULL,

`GP3ENTAUT` varchar(25) NOT NULL,

`GP4ENTAUT` varchar(25) NOT NULL,

`TSEFACAUT` varchar(50) NOT NULL

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_AUT`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_CFG`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_CFG`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_CFG` (

`CODCFG` smallint(6) NOT NULL,

`NOMCFG` varchar(50) NOT NULL,

`DENCFG` varchar(40) NOT NULL,

`DOMCFG` varchar(50) NOT NULL,

`CPOCFG` varchar(5) NOT NULL,

`POBCFG` varchar(50) NOT NULL,

`PROCFG` varchar(20) NOT NULL,

`NIFCFG` varchar(18) NOT NULL,

`PTECFG` varchar(3) NOT NULL,

`TELCFG` varchar(12) NOT NULL,

`PFACFG` varchar(3) NOT NULL,

`FAXCFG` varchar(12) NOT NULL,

`NRLCFG` varchar(100) NOT NULL,

`NILCFG` varchar(20) NOT NULL,

`LOGCFG` varchar(255) NOT NULL,

`PIV1CFG` decimal(12,4) NOT NULL,

`PIV2CFG` decimal(12,4) NOT NULL,

`PIV3CFG` decimal(12,4) NOT NULL,

`PRE1CFG` decimal(12,4) NOT NULL,

`PRE2CFG` decimal(12,4) NOT NULL,

`PRE3CFG` decimal(12,4) NOT NULL,

`MICCFG` smallint(6) NOT NULL,

`NAPCFG` smallint(6) NOT NULL,

`UFSCFG` smallint(6) NOT NULL,

`NFSCFG` varchar(40) NOT NULL,

`UFFCFG` smallint(6) NOT NULL,

`NFFCFG` varchar(40) NOT NULL,

`MCACFG` smallint(6) NOT NULL,

`MCBCFG` smallint(6) NOT NULL,

`MDECFG` smallint(6) NOT NULL,

`MDDCFG` smallint(6) NOT NULL,

`MPRCFG` smallint(6) NOT NULL,

`MSTCFG` smallint(6) NOT NULL,

`MIMCFG` smallint(6) NOT NULL,

`MALCFG` int(11) NOT NULL,

`MANCFG` int(11) NOT NULL,

`MCP1CFG` smallint(6) NOT NULL,

`MCP2CFG` smallint(6) NOT NULL,

`MCP3CFG` smallint(6) NOT NULL,

`NCP1CFG` varchar(20) NOT NULL,

`NCP2CFG` varchar(20) NOT NULL,

`NCP3CFG` varchar(20) NOT NULL,

`TCACFG` smallint(6) NOT NULL,

`AUSCFG` varchar(3) NOT NULL,

`PPCCFG` smallint(6) NOT NULL,

`SPCCFG` varchar(1) NOT NULL,

`TDACFG` smallint(6) NOT NULL,

`ECCCFG` varchar(1) NOT NULL,

`TCCCFG` text NOT NULL,

`PPACFG` smallint(6) NOT NULL,

`SPACFG` varchar(1) NOT NULL,

`PCTCFG` smallint(6) NOT NULL,

`TDAGCFG` smallint(6) NOT NULL,

`PCFCFG` smallint(6) NOT NULL,

`CA1CFG` varchar(30) NOT NULL,

`CA2CFG` varchar(30) NOT NULL,

`CA3CFG` varchar(30) NOT NULL,

`CA4CFG` varchar(30) NOT NULL,

`CA5CFG` varchar(30) NOT NULL,

`CA6CFG` varchar(30) NOT NULL,

`CA7CFG` varchar(30) NOT NULL,

`CA8CFG` varchar(30) NOT NULL,

`CA9CFG` varchar(30) NOT NULL,

`CA10CFG` varchar(30) NOT NULL,

`CA11CFG` varchar(30) NOT NULL,

`CA12CFG` varchar(30) NOT NULL,

`DS1CFG` varchar(15) NOT NULL,

`DS2CFG` varchar(15) NOT NULL,

`DS3CFG` varchar(15) NOT NULL,

`DS4CFG` varchar(15) NOT NULL,

`DS5CFG` varchar(15) NOT NULL,

`DS6CFG` varchar(15) NOT NULL,

`DS7CFG` varchar(15) NOT NULL,

`DS8CFG` varchar(15) NOT NULL,

`DS9CFG` varchar(15) NOT NULL,

`LOCCFG` smallint(6) NOT NULL,

`TBDCFG` smallint(6) NOT NULL,

`DSFCFG` varchar(100) NOT NULL,

`NUFCFG` varchar(100) NOT NULL,

`CFTCFG` varchar(40) NOT NULL,

`CBDCFG` varchar(100) NOT NULL,

`CBRCFG` varchar(100) NOT NULL,

`CIACFG` varchar(100) NOT NULL,

`CPVCFG` varchar(100) NOT NULL,

`CCLCFG` varchar(100) NOT NULL,

`ABDCFG` varchar(20) NOT NULL,

`ABRCFG` varchar(20) NOT NULL,

`ESM1CFG` smallint(6) NOT NULL,

`ESM2CFG` smallint(6) NOT NULL,

`ESM3CFG` smallint(6) NOT NULL,

`ESM4CFG` smallint(6) NOT NULL,

`TXM1CFG` text NOT NULL,

`TXM2CFG` text NOT NULL,

`TXM3CFG` text NOT NULL,

`TXM4CFG` text NOT NULL,

`PAOCFG` smallint(6) NOT NULL,

`SNOMCFG` smallint(6) NOT NULL,

`SDOMCFG` smallint(6) NOT NULL,

`SCPOCFG` smallint(6) NOT NULL,

`SPOBCFG` smallint(6) NOT NULL,

`SPROCFG` smallint(6) NOT NULL,

`SNIFCFG` smallint(6) NOT NULL,

`STELCFG` smallint(6) NOT NULL,

`SFAXCFG` smallint(6) NOT NULL,

`SMOVCFG` smallint(6) NOT NULL,

`SEMACFG` smallint(6) NOT NULL,

`SPCOCFG` smallint(6) NOT NULL,

`SNENCFG` smallint(6) NOT NULL,

`SDENCFG` smallint(6) NOT NULL,

`SCPECFG` smallint(6) NOT NULL,

`SPOECFG` smallint(6) NOT NULL,

`SPRECFG` smallint(6) NOT NULL,

`SPCECFG` smallint(6) NOT NULL,

`STCECFG` smallint(6) NOT NULL,

`SFPACFG` smallint(6) NOT NULL,

`TDACCFG` smallint(6) NOT NULL,

`ECCCCFG` smallint(6) NOT NULL,

`APECIECFG` varchar(255) NOT NULL,

`PAGACTCFG` varchar(255) NOT NULL,

`CDTCFG` smallint(6) NOT NULL,

`NFCCFG` smallint(6) NOT NULL,

PRIMARY KEY (`CODCFG`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_CFG`

// -

 

$id ++;

define('Q'.$id, "INSERT INTO F_CFG (CODCFG, NOMCFG, DENCFG, DOMCFG, CPOCFG, POBCFG, PROCFG, NIFCFG, PTECFG, TELCFG, PFACFG, FAXCFG, NRLCFG, NILCFG, LOGCFG, PIV1CFG, PIV2CFG, PIV3CFG, PRE1CFG, PRE2CFG, PRE3CFG, MICCFG, NAPCFG, UFSCFG, NFSCFG, UFFCFG, NFFCFG, MCACFG, MCBCFG, MDECFG, MDDCFG, MPRCFG, MSTCFG, MIMCFG, MALCFG, MANCFG, MCP1CFG, MCP2CFG, MCP3CFG, NCP1CFG, NCP2CFG, NCP3CFG, TCACFG, AUSCFG, PPCCFG, SPCCFG, TDACFG, ECCCFG, TCCCFG, PPACFG, SPACFG, PCTCFG, TDAGCFG, PCFCFG, CA1CFG, CA2CFG, CA3CFG, CA4CFG, CA5CFG, CA6CFG, CA7CFG, CA8CFG, CA9CFG, CA10CFG, CA11CFG, CA12CFG, DS1CFG, DS2CFG, DS3CFG, DS4CFG, DS5CFG, DS6CFG, DS7CFG, DS8CFG, DS9CFG, LOCCFG, TBDCFG, DSFCFG, NUFCFG, CFTCFG, CBDCFG, CBRCFG, CIACFG, CPVCFG, CCLCFG, ABDCFG, ABRCFG, ESM1CFG, ESM2CFG, ESM3CFG, ESM4CFG, TXM1CFG, TXM2CFG, TXM3CFG, TXM4CFG, PAOCFG, SNOMCFG, SDOMCFG, SCPOCFG, SPOBCFG, SPROCFG, SNIFCFG, STELCFG, SFAXCFG, SMOVCFG, SEMACFG, SPCOCFG, SNENCFG, SDENCFG, SCPECFG, SPOECFG, SPRECFG, SPCECFG, STCECFG, SFPACFG, TDACCFG, ECCCCFG, APECIECFG, PAGACTCFG) VALUES (1, 'NeSA', 'Negocietes, S.A.', 'Fake St.', '28005', 'Madrid', 'MADRID', '123456789', '', '123456789', '', '', '', '', 'http://localhost/fsweb/img/logo_nesa.jpg' 16.00, 7.00, 4.00, 4.00, 1.00, 0.50, 1, 10, 1, 'Sección', 1, 'Familia', 1, 1, 1, 1, 1, 1, 1, 75, 75, 1, 0, 0, 'Material', '', '', 50, 'GEN', 1, '8', 0, '0', '{rtf1ansiansicpg1252deff0deflang3082{fonttbl{f0fnilfcharset0 MS Sans Serif;}}

viewkind4uc1pardf0fs17

par }

', 1, '9', 1, 0, 1, 'POSLFA', 'ARTLFA', 'EANART', 'DESLFA', 'CANLFA', 'PRELFA', 'DT1LFA', 'DT2LFA', 'DT3LFA', 'STOLFA', 'TOTLFA', 'IVALFA', '1', '2', '3', '4', '5', '6', '7', '8', '9', 2, 1, 'ftp://localhost' 'anonymous', '103P125O135S143X147M160W171Z386P90D115K1', '/fsweb/BBDD/', 'factusolweb.sql', 'imagenes/', 'npedidos/', 'nclientes/', 'contraseña_BaseDatos', 'contraseña_Pedidos', 1, 1, 1, 1, '', '', '', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 'http://localhost/fsweb/admin/index.php' 'http://localhost/fsweb/BBDD/index.php')");

define('_Q'.$id, '- ');

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_CLI`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_CLI`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_CLI` (

`CUWCLI` varchar(50) NOT NULL,

`CAWCLI` varchar(15) NOT NULL,

`CODCLI` int(11) NOT NULL,

`NIFCLI` varchar(18) NOT NULL,

`NOFCLI` varchar(50) NOT NULL,

`NOCCLI` varchar(50) NOT NULL,

`DOMCLI` varchar(50) NOT NULL,

`CPOCLI` varchar(5) NOT NULL,

`POBCLI` varchar(30) NOT NULL,

`PROCLI` varchar(20) NOT NULL,

`AGECLI` int(11) NOT NULL,

`FPACLI` varchar(3) NOT NULL,

`FINCLI` decimal(12,4) NOT NULL,

`PPACLI` decimal(12,4) NOT NULL,

`TARCLI` int(11) NOT NULL,

`TCLCLI` varchar(3) NOT NULL,

`DT1CLI` smallint(6) NOT NULL,

`DT2CLI` smallint(6) NOT NULL,

`TPOCLI` smallint(6) NOT NULL,

`PORCLI` varchar(30) NOT NULL,

`IVACLI` smallint(6) NOT NULL,

`TIVCLI` smallint(6) NOT NULL,

`REQCLI` smallint(6) NOT NULL,

`MEWCLI` varchar(255) NOT NULL,

PRIMARY KEY (`CUWCLI`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_CLI`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_DES`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_DES`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_DES` (

`TCLDES` varchar(5) NOT NULL,

`ARFDES` varchar(13) NOT NULL,

`TIPDES` smallint(6) NOT NULL,

`PORDES` decimal(12,4) NOT NULL,

`IMPDES` decimal(12,4) NOT NULL,

`FIJDES` smallint(6) NOT NULL,

PRIMARY KEY (`TCLDES`,`ARFDES`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_DES`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_DIR`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_DIR`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_DIR` (

`CLIDIR` int(11) NOT NULL,

`CODDIR` smallint(6) NOT NULL,

`NOMDIR` varchar(40) NOT NULL,

`DOMDIR` varchar(40) NOT NULL,

`POBDIR` varchar(30) NOT NULL,

`CPODIR` varchar(5) NOT NULL,

`PRODIR` varchar(20) NOT NULL,

`TELDIR` varchar(40) NOT NULL,

`PCODIR` varchar(40) NOT NULL,

`AGEDIR` int(11) NOT NULL,

PRIMARY KEY (`CLIDIR`,`CODDIR`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_DIR`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_EMP`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_EMP`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_EMP` (

`CODEMP` varchar(3) NOT NULL,

`NIFEMP` varchar(18) NOT NULL,

`DENEMP` varchar(40) NOT NULL,

`NOMEMP` varchar(40) NOT NULL,

`DOMEMP` varchar(40) NOT NULL,

`NUMEMP` varchar(5) NOT NULL,

`ESCEMP` varchar(2) NOT NULL,

`PISEMP` varchar(2) NOT NULL,

`PRTEMP` varchar(2) NOT NULL,

`POBEMP` varchar(30) NOT NULL,

`CPOEMP` varchar(5) NOT NULL,

`PROEMP` varchar(30) NOT NULL,

`PTEEMP` varchar(3) NOT NULL,

`TELEMP` varchar(12) NOT NULL,

`PFAEMP` varchar(3) NOT NULL,

`FAXEMP` varchar(12) NOT NULL,

`EJEEMP` varchar(4) NOT NULL,

`MONEMP` varchar(1) NOT NULL,

`CLAEMP` varchar(10) NOT NULL,

`REGEMP` varchar(30) NOT NULL,

`TOMEMP` varchar(10) NOT NULL,

`FOLEMP` varchar(10) NOT NULL,

`HOJEMP` varchar(10) NOT NULL,

`INSEMP` varchar(10) NOT NULL,

`EMAEMP` varchar(50) NOT NULL,

`WEBEMP` varchar(50) NOT NULL,

`CFGEMP` varchar(250) NOT NULL,

`IVAEMP` smallint(6) NOT NULL,

`FFEEMP` smallint(6) NOT NULL,

PRIMARY KEY (`CODEMP`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_EMP`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_FAC`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_FAC`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_FAC` (

`TIPFAC` varchar(1) NOT NULL,

`CODFAC` int(11) NOT NULL,

`REFFAC` varchar(12) NOT NULL,

`FECFAC` datetime NOT NULL,

`ESTFAC` smallint(6) NOT NULL,

`ALMFAC` varchar(3) NOT NULL,

`AGEFAC` int(11) NOT NULL,

`PROFAC` varchar(10) NOT NULL,

`CLIFAC` int(11) NOT NULL,

`CNOFAC` varchar(50) NOT NULL,

`CDOFAC` varchar(50) NOT NULL,

`CPOFAC` varchar(30) NOT NULL,

`CCPFAC` varchar(5) NOT NULL,

`CPRFAC` varchar(20) NOT NULL,

`CNIFAC` varchar(18) NOT NULL,

`TIVFAC` smallint(6) NOT NULL,

`REQFAC` int(11) NOT NULL,

`TELFAC` varchar(20) NOT NULL,

`NET1FAC` decimal(12,4) NOT NULL,

`NET2FAC` decimal(12,4) NOT NULL,

`NET3FAC` decimal(12,4) NOT NULL,

`PDTO1FAC` decimal(12,4) NOT NULL,

`PDTO2FAC` decimal(12,4) NOT NULL,

`PDTO3FAC` decimal(12,4) NOT NULL,

`IDTO1FAC` decimal(12,4) NOT NULL,

`IDTO2FAC` decimal(12,4) NOT NULL,

`IDTO3FAC` decimal(12,4) NOT NULL,

`PPPA1FAC` decimal(12,4) NOT NULL,

`PPPA2FAC` decimal(12,4) NOT NULL,

`PPPA3FAC` decimal(12,4) NOT NULL,

`IPPA1FAC` decimal(12,4) NOT NULL,

`IPPA2FAC` decimal(12,4) NOT NULL,

`IPPA3FAC` decimal(12,4) NOT NULL,

`PPOR1FAC` decimal(12,4) NOT NULL,

`PPOR2FAC` decimal(12,4) NOT NULL,

`PPOR3FAC` decimal(12,4) NOT NULL,

`IPOR1FAC` decimal(12,4) NOT NULL,

`IPOR2FAC` decimal(12,4) NOT NULL,

`IPOR3FAC` decimal(12,4) NOT NULL,

`PFIN1FAC` decimal(12,4) NOT NULL,

`PFIN2FAC` decimal(12,4) NOT NULL,

`PFIN3FAC` decimal(12,4) NOT NULL,

`IFIN1FAC` decimal(12,4) NOT NULL,

`IFIN2FAC` decimal(12,4) NOT NULL,

`IFIN3FAC` decimal(12,4) NOT NULL,

`BAS1FAC` decimal(12,4) NOT NULL,

`BAS2FAC` decimal(12,4) NOT NULL,

`BAS3FAC` decimal(12,4) NOT NULL,

`PIVA1FAC` decimal(12,4) NOT NULL,

`PIVA2FAC` decimal(12,4) NOT NULL,

`PIVA3FAC` decimal(12,4) NOT NULL,

`IIVA1FAC` decimal(12,4) NOT NULL,

`IIVA2FAC` decimal(12,4) NOT NULL,

`IIVA3FAC` decimal(12,4) NOT NULL,

`PREC1FAC` decimal(12,4) NOT NULL,

`PREC2FAC` decimal(12,4) NOT NULL,

`PREC3FAC` decimal(12,4) NOT NULL,

`IREC1FAC` decimal(12,4) NOT NULL,

`IREC2FAC` decimal(12,4) NOT NULL,

`IREC3FAC` decimal(12,4) NOT NULL,

`PRET1FAC` decimal(12,4) NOT NULL,

`IRET1FAC` decimal(12,4) NOT NULL,

`TOTFAC` decimal(12,4) NOT NULL,

`FOPFAC` varchar(3) NOT NULL,

`PRTFAC` smallint(6) NOT NULL,

`TPOFAC` varchar(30) NOT NULL,

`OB1FAC` varchar(40) NOT NULL,

`OB2FAC` varchar(40) NOT NULL,

`OBRFAC` smallint(6) NOT NULL,

`REPFAC` varchar(50) NOT NULL,

`EMBFAC` varchar(50) NOT NULL,

`AATFAC` varchar(50) NOT NULL,

`REAFAC` varchar(50) NOT NULL,

`PEDFAC` varchar(50) NOT NULL,

`FPEFAC` datetime NOT NULL,

`VENFAC` varchar(255) NOT NULL,

PRIMARY KEY (`TIPFAC`,`CODFAC`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_FAC`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_FAM`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_FAM`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_FAM` (

`CODFAM` varchar(3) NOT NULL,

`DESFAM` varchar(50) NOT NULL,

`SECFAM` varchar(3) NOT NULL,

PRIMARY KEY (`CODFAM`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_FAM`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_FPA`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_FPA`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_FPA` (

`CODFPA` varchar(3) NOT NULL,

`DESFPA` varchar(50) NOT NULL,

`VENFPA` smallint(6) NOT NULL,

`TIPFPA` smallint(6) NOT NULL,

PRIMARY KEY (`CODFPA`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_FPA`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_LFA`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_LFA`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_LFA` (

`TIPLFA` varchar(1) NOT NULL,

`CODLFA` int(11) NOT NULL,

`POSLFA` smallint(6) NOT NULL,

`ARTLFA` varchar(13) NOT NULL,

`DESLFA` text NOT NULL,

`CANLFA` decimal(12,4) NOT NULL,

`DT1LFA` smallint(6) NOT NULL,

`DT2LFA` smallint(6) NOT NULL,

`DT3LFA` smallint(6) NOT NULL,

`PRELFA` decimal(12,4) NOT NULL,

`TOTLFA` decimal(12,4) NOT NULL,

`IVALFA` smallint(6) NOT NULL,

`DOCLFA` varchar(1) NOT NULL,

`DTPLFA` varchar(1) NOT NULL,

`DCOLFA` int(11) NOT NULL,

`COSLFA` decimal(12,4) NOT NULL,

`BULLFA` decimal(12,4) NOT NULL,

`COMLFA` decimal(12,4) NOT NULL,

`MEMLFA` text NOT NULL,

`EJELFA` varchar(4) NOT NULL,

`ALTLFA` decimal(12,4) NOT NULL,

`ANCLFA` decimal(12,4) NOT NULL,

`FONLFA` decimal(12,4) NOT NULL,

`FFALFA` datetime NOT NULL,

`FCOLFA` datetime NOT NULL,

`IINLFA` int(11) NOT NULL,

`PIVLFA` decimal(12,4) NOT NULL,

`TIVLFA` decimal(12,4) NOT NULL,

PRIMARY KEY (`TIPLFA`,`CODLFA`,`POSLFA`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_LFA`

// -

 

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_LPC`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_LPC`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_LPC` (

`TIPLPC` varchar(1) NOT NULL,

`CODLPC` int(11) NOT NULL,

`POSLPC` smallint(6) NOT NULL,

`ARTLPC` varchar(13) NOT NULL,

`DESLPC` text NOT NULL,

`CANLPC` decimal(12,4) NOT NULL,

`DT1LPC` smallint(6) NOT NULL,

`PRELPC` decimal(12,4) NOT NULL,

`TOTLPC` decimal(12,4) NOT NULL,

`IVALPC` smallint(6) NOT NULL,

`IINLPC` smallint(6) NOT NULL,

PRIMARY KEY (`TIPLPC`,`CODLPC`,`POSLPC`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_LPC`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_LTA`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_LTA`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_LTA` (

`TARLTA` int(11) NOT NULL,

`ARTLTA` varchar(13) NOT NULL,

`MARLTA` decimal(12,4) NOT NULL,

`PRELTA` decimal(12,4) NOT NULL,

PRIMARY KEY (`TARLTA`,`ARTLTA`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_LTA`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_PCL`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_PCL`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_PCL` (

`TIPPCL` varchar(1) NOT NULL,

`CODPCL` int(11) NOT NULL,

`REFPCL` varchar(12) NOT NULL,

`FECPCL` datetime NOT NULL,

`AGEPCL` int(11) NOT NULL,

`CLIPCL` int(11) NOT NULL,

`DIRPCL` smallint(6) NOT NULL,

`TIVPCL` smallint(6) NOT NULL,

`REQPCL` int(11) NOT NULL,

`ALMPCL` varchar(3) NOT NULL,

`NET1PCL` decimal(12,4) NOT NULL,

`NET4PCL` decimal(12,4) NOT NULL,

`NET2PCL` decimal(12,4) NOT NULL,

`NET3PCL` decimal(12,4) NOT NULL,

`PDTO1PCL` decimal(12,4) NOT NULL,

`PDTO2PCL` decimal(12,4) NOT NULL,

`PDTO3PCL` decimal(12,4) NOT NULL,

`PDTO4PCL` decimal(12,4) NOT NULL,

`IDTO1PCL` decimal(12,4) NOT NULL,

`IDTO2PCL` decimal(12,4) NOT NULL,

`IDTO3PCL` decimal(12,4) NOT NULL,

`IDTO4PCL` decimal(12,4) NOT NULL,

`PPPA1PCL` decimal(12,4) NOT NULL,

`PPPA2PCL` decimal(12,4) NOT NULL,

`PPPA3PCL` decimal(12,4) NOT NULL,

`PPPA4PCL` decimal(12,4) NOT NULL,

`IPPA1PCL` decimal(12,4) NOT NULL,

`IPPA2PCL` decimal(12,4) NOT NULL,

`IPPA3PCL` decimal(12,4) NOT NULL,

`IPPA4PCL` decimal(12,4) NOT NULL,

`PFIN1PCL` decimal(12,4) NOT NULL,

`PFIN2PCL` decimal(12,4) NOT NULL,

`PFIN3PCL` decimal(12,4) NOT NULL,

`PFIN4PCL` decimal(12,4) NOT NULL,

`IFIN1PCL` decimal(12,4) NOT NULL,

`IFIN2PCL` decimal(12,4) NOT NULL,

`IFIN3PCL` decimal(12,4) NOT NULL,

`IFIN4PCL` decimal(12,4) NOT NULL,

`BAS1PCL` decimal(12,4) NOT NULL,

`BAS2PCL` decimal(12,4) NOT NULL,

`BAS3PCL` decimal(12,4) NOT NULL,

`BAS4PCL` decimal(12,4) NOT NULL,

`PIVA1PCL` decimal(12,4) NOT NULL,

`PIVA2PCL` decimal(12,4) NOT NULL,

`PIVA3PCL` decimal(12,4) NOT NULL,

`IIVA1PCL` decimal(12,4) NOT NULL,

`IIVA2PCL` decimal(12,4) NOT NULL,

`IIVA3PCL` decimal(12,4) NOT NULL,

`PREC1PCL` decimal(12,4) NOT NULL,

`PREC2PCL` decimal(12,4) NOT NULL,

`PREC3PCL` decimal(12,4) NOT NULL,

`xPREC3PCLx` decimal(12,4) NOT NULL,

`IREC1PCL` decimal(12,4) NOT NULL,

`IREC2PCL` decimal(12,4) NOT NULL,

`IREC3PCL` decimal(12,4) NOT NULL,

`TOTPCL` decimal(12,4) NOT NULL,

`FOPPCL` varchar(3) NOT NULL,

`OB1PCL` varchar(50) NOT NULL,

`OB2PCL` varchar(50) NOT NULL,

`PPOPCL` varchar(40) NOT NULL,

`ESTPCL` varchar(1) NOT NULL,

PRIMARY KEY (`TIPPCL`,`CODPCL`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_PCL`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_SEC`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_SEC`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_SEC` (

`CODSEC` varchar(3) NOT NULL,

`DESSEC` varchar(50) NOT NULL,

PRIMARY KEY (`CODSEC`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_SEC`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_STO`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_STO`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_STO` (

`ARTSTO` varchar(13) NOT NULL,

`ALMSTO` varchar(3) NOT NULL,

`MINSTO` decimal(12,4) NOT NULL,

`MAXSTO` decimal(12,4) NOT NULL,

`ACTSTO` decimal(12,4) NOT NULL,

`DISSTO` decimal(12,4) NOT NULL

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_STO`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `F_TAR`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `F_TAR`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `F_TAR` (

`CODTAR` int(11) NOT NULL,

`DESTAR` varchar(20) NOT NULL,

`MARTAR` decimal(12,4) NOT NULL,

`IINTAR` smallint(6) NOT NULL,

PRIMARY KEY (`CODTAR`)

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `F_TAR`

// -

 

// ------------------------------------------------------// -

 

// -

// Estructura de tabla para la tabla `PAGINAS`

// -

 

$id ++;

define('Q'.$id, "DROP TABLE IF EXISTS `PAGINAS`");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "CREATE TABLE `PAGINAS` (

`NOMBPAG` varchar(255) NOT NULL,

`CONTPAG` mediumtext NOT NULL

) ");

define('_Q'.$id, '- ');

 

// -

// Volcar la base de datos para la tabla `paginas`

// -

 

$id ++;

define('Q'.$id, "INSERT INTO `PAGINAS` (`NOMBPAG`, `CONTPAG`) VALUES

('inicio', '<p>Bienvenido!</p>\r\n<p><br>\r\nEsta instalación de <strong>FactuSol Web</strong> enlaza con el conector <strong>FSx-Connector</strong>\r\nentre el software de tienda web <strong>osCommerce</strong> y <strong>FactuSol</strong>.</p>\r\n<p>Powered by: www.FactuSol-osCommerce.es</p>\r\n')");

define('_Q'.$id, '- ');

 

 

// ------------------------------------------------------// -

 

// -

// Modificar tablas. Insertar nuevo campo `customers_cid`

// -

 

$id ++;

define('Q'.$id, "ALTER TABLE `orders` ADD `customers_cid` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `orders_id` ");

define('_Q'.$id, '- ');

$id ++;

define('Q'.$id, "ALTER TABLE `customers` ADD `customers_cid` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `customers_id` ");

define('_Q'.$id, '- ');

 

 

// ------------------------------------------------------// -

 

define('COUNT', $id);

 

$content_body = '

 

<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td xwidth="165" valign="top" bgcolor="F3F3F3" style="border-bottom: 1px solid; border-left: 1px solid; border-right: 1px solid; border-top: 1px solid; border-color: #6D6D6D;">

<table width="165" border="0" cellspacing="0" cellpadding="0">

<tr>

<td height="17" width="165" bgcolor="ffffff">

<div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="FFAF00">osc</font><font color="#999999">Update</font></b></font></div></td>

</tr>

</table>

</td>

<td width="100%" align="right" valign="top" style="border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid; border-color: #6D6D6D;">

<br />

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">

<tr>

<td>

 

<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br />

 

 

<p align="left">Database Update:</p>

 

 

 

 

<table width="100%" border="0" cellpadding="2" cellspacing="2" style="border: 1px solid; border-color: #4CC534;">';

 

for ($i=1;$i<COUNT+1;$i++) {

$content_body .= '

<tr>

<td width="95%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">' . constant(_Q.$i) . '</font></td>

<td>';

 

$result=rws_UpdateQuery(constant(Q.$i));

if($result) { $content_body .= '<img src="images/icons/success.gif" title=" OK ">'; } else { $content_body .= '<img src="images/icons/error.gif" title=" Error! ">'; }

 

$content_body .= '

</td>

</tr>';

 

}

$content_body .= '

</table>

 

<br><br>DATABASE UDPATE FINISHED!<br><br>

 

Please remove /update/ files from your webspace<br><br>

 

 

 

</font><br />

<br /></td>

</tr>

 

 

 

</table>

<p><br /><br /></p>

 

</td>

</tr>

</table>

 

';

 

echo $content_body;

 

?>

 

 

<!-- /table --></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<tr>

<td> 

</td>

</tr>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

As far as I know, this script should delete the tables that comes with the osCommerce installation to adjust it to the data that Factusol provides.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...