<!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; }