function FullImport($mysql_db, $file, $date)
{
$sqlite_db = new PDO('sqlite:./' . $file);
create_tables($sqlite_db);
setup_params($sqlite_db, $date, "FULL");
$sqlite_db->query("DROP TABLE tables");
$sqlite_db->query("DROP TABLE dir0");
$sqlite_db->query("DROP TABLE ref0");
$sqlite_db->query("CREATE TABLE dir0(code INTEGER PRIMARY KEY, name, info, parent INTEGER NOT NULL)");
$sqlite_db->query("CREATE TABLE ref0(code INTEGER, book INTEGER, PRIMARY KEY(code, book))");
$sqlite_db->query("CREATE INDEX dir0_parent ON dir0(parent)");
$sqlite_db->query("CREATE INDEX ref0_book ON ref0(book)");
$sqlite_db->query("CREATE TABLE tables(id INTEGER PRIMARY KEY AUTOINCREMENT,title,\n\tdir_file,dir_data,dir_type,dir_code,dir_name,dir_info,dir_prnt,\n\tref_file,ref_data,ref_type,ref_code,ref_book,fb2_code)");
$sqlite_db->query("INSERT INTO tables(title,dir_data,dir_type,dir_code,dir_name,dir_prnt,ref_data,ref_type,ref_code,ref_book)\n\tVALUES ('Тематический рубрикатор','dir0','INTEGER','code','name','parent','ref0','id','code','book')");
convert_books($mysql_db, $sqlite_db);
convert_auth($mysql_db, $sqlite_db);
convert_dates($mysql_db, $sqlite_db);
convert_topics($mysql_db, $sqlite_db);
create_indexes($sqlite_db);
}
function FullImport($file, $date)
{
$sqlite_db = new PDO('sqlite:./' . $file);
create_tables($sqlite_db);
setup_params($sqlite_db, $date, "FULL");
convert_auth($sqlite_db, 0);
convert_book($sqlite_db, 0);
convert_seqn($sqlite_db, 0);
convert_date($sqlite_db, 0);
convert_genr($sqlite_db, 0);
convert_info($sqlite_db, 0);
create_indexes($sqlite_db);
/*
convert_sequences($mysql_db, $sqlite_db, 0);
convert_dates($mysql_db, $sqlite_db, 0);
convert_zips($mysql_db, $sqlite_db, 0);
convert_files($mysql_db, $sqlite_db, 0, 0);
*/
}
