Violini Capricciosi

Item toegevoegd aan winkelwagentje!!

Naar winkelwagentje

#016

Migratiecode copy/paste naar doel-website:

if (exist_db_field("_assets","record_id")) { die("Table [_assets] already exists"); }
$query = "CREATE TABLE IF NOT EXISTS  (_id int(11) NOT NULL auto_increment, timestamp VARCHAR(20) NOT NULL, PRIMARY KEY (_id) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci";
$result = Db::run_query($query, "error creating ", true);
$query = "CREATE TABLE IF NOT EXISTS _assets (record_id int(11) NOT NULL auto_increment, PRIMARY KEY (record_id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci";
$result = Db::run_query($query, "error creating ", true);
$query3 = "SELECT autorgrp_id FROM autorisatiegroepen WHERE autorgrp_superadministrator = 1";
$result3 = Db::run_query($query3, "error getting autorisatiegroepen", true);
if ($result3->num_rows > 0)
{
while (list($autorgrp_id) = $result3->fetch_row())
{
$query = "SELECT autorisa_tabelnaam FROM autorisatie WHERE autorisa_tabelnaam = ''";
$result = Db::run_query($query, "error getting autorisatie", true);
if ($result->num_rows == 0)
{
$query2 = "INSERT INTO autorisatie SET autorisa_tabelnaam = '', autorisa_tabelkey = '', record_id = '0', autorgrp_id = '" . $autorgrp_id . "', autorisa_toevoegen = '1', 
	autorisa_wijzigen = '1', autorisa_verwijderen = '1', autorisa_lezen = '1', autorisa_zichtbaar = '1', autorisa_uploaden = '1', autorisa_reageren = '1', autorisa_security = '1'";
$result2 = Db::run_query($query2, "error inserting autorisatie", true);
}
}
}
$query = "SELECT stamtab_omschrijvingkort FROM stamtabel WHERE stamtab_categorie = 'assettabellen' AND stamtab_omschrijvingkort = ''";
$result = Db::run_query($query, "error getting stamtabel", true);
if ($result->num_rows == 0)
{
$query2 = 'INSERT INTO stamtabel SET stamtab_categorie = "assettabellen", stamtab_omschrijvingkort = "", stamtab_omschrijvinglang = ""';
$result2 = Db::run_query($query2, "error inserting stamtabel", true);
$record_id = mysqli_insert_id(DB::getDbh());
}

echo "Importeren van de tabel  is geslaagd";

Toevoegen in blokitem van doel-website:

Home

"Love and learn the great art of music. It will open you a whole world of high feelings, passions, thoughts".
(D. Shostakovich)