<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="es-mx" dir="ltr"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>CSVI Analyzer</title> </head> <body> <?php echo "ini"; echo "</br>"; $filename = "LDDE.txt"; $lara = executeSqlFile($filename); /* CREATE TABLE `prd`.`LDDE` ( `id` INT( 100 ) NOT NULL , `CONSECUTIVO` INT( 100 ) NOT NULL , `CLV_ELECTO` VARCHAR( 25 ) NOT NULL , `PATERNO` VARCHAR( 50 ) NOT NULL , `MATERNO` VARCHAR( 50 ) NOT NULL , `NOMBRE` VARCHAR( 50 ) NOT NULL , `ESTADO` VARCHAR( 50 ) NOT NULL , `MUNICIPIO` VARCHAR( 50 ) NOT NULL , `SECC` VARCHAR( 6 ) NOT NULL , `FECHA_AFILIACION` VARCHAR( 10 ) NOT NULL , `DDF` VARCHAR( 3 ) NOT NULL , `DDL` VARCHAR( 3 ) NOT NULL , `CORRIENTE` VARCHAR( 50 ) NOT NULL , `DIRECCION` VARCHAR( 50 ) NOT NULL , `COL` VARCHAR( 50 ) NOT NULL , `OBSERV` VARCHAR( 50 ) NOT NULL
function initTables()
{
$additional = "total_id int not null, person_id int not null, age int, sex int, is_animal int, for_all int, ";
executeSqlFile('tbl.sql');
$script = explode(';', file_get_contents(ROOT_DIR . 'all.sql'));
foreach ($script as $q) {
if (!$q) {
continue;
}
query("CREATE TABLE purchase_total (" . trim($q));
query("CREATE TABLE purchase_total_purchaser ({$additional} " . trim($q));
query("CREATE TABLE purchase_total_consumer ({$additional} " . trim($q));
}
query('delete from purchase_total');
}
function instPopulateDB(&$session, $fn_sql, $fn_sql_skin)
{
$session->trace(TC_Init, "instPopulateDB:");
$db_prefix = $session->fDbTablePrefix;
$message = '';
if (checkDB($session, $message) == DB_EXISTS) {
$message = executeSqlFile($session, $fn_sql, $line_count, $comments);
if (empty($message)) {
$message = executeSqlFile($session, $fn_sql_skin, $line_count2, $comments2);
}
if (empty($message)) {
$message = 'Die Infobasar-Tabellen wurden initialisiert: ' . ($line_count + $line_count2) . ' Zeilen gelesen, davon ' . ($comments + $comments2) . ' Kommentare';
instAdaptPathInDB($session, $message);
$fn_pages = instGetStandardPageFile($session);
$message .= '<br>' . instImportPages($session, $fn_pages, true);
}
}
return $message;
}
