Prvni pokus o osamostatneni carovych kodu, bohuzel to rozbilo asistenty a razeni...

[mirrors/SokoMan.git] / assistants / migrations.inc.php

diff --git a/assistants/migrations.inc.php b/assistants/migrations.inc.php
index c492ecb4e936b3975a5e9e3f4890300b70df5bf5..c00b8e36ef99c588fee0dc9fe2d6de7bb8c60173 100644 (file)
--- a/assistants/migrations.inc.php
+++ b/assistants/migrations.inc.php
@@ -1,4 +1,11 @@
 <pre>
+<h1>-- populate barcode table</h1><?php
+$data = $this->db->safe_query_fetch('SELECT model_id as id, model_barcode as bar FROM model;');
+//print_r($data);
+echo("UPDATE item SET barcode_id=model_id;\n");
+echo("INSERT INTO barcode (barcode_id,model_id,barcode_name) VALUES\n");
+foreach($data as $line) echo("('".$line['id']."','".$line['id']."','".$line['bar']."'),\n");
+?>
 <h1>-- populate columns item_date_bought and item_date_sold</h1><?php
 $data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS min,MAX(item_valid_from) AS max FROM item GROUP BY item_id;');
 //print_r($data);