Changeset 10820 for temp/branches

Timestamp:

2006/12/17 19:49:09 (20 years ago)

Author:

uehara

Message:

 

Location:

temp/branches/ec-cube-beta/html/install

Files:

• index.php (modified) (1 diff)
• sql/insert_data.sql (modified) (previous)

temp/branches/ec-cube-beta/html/install/index.php

@@ -836 +836 @@
 function lfAddData($dsn) {
     // CSV¥Æ¡¼¥Ö¥ë
-    $sql = "insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','¥«¥Æ¥´¥êID',53,now(),now());";
-    if(sfTabaleExists('dtb_csv', $dsn)) sfDataExists("dtb_csv", "csv_id = ? AND col = ?", array(1, 'category_id'), $dsn = "", $sql, true);
+    if(sfTabaleExists('dtb_csv', $dsn)) {
+        lfInsertData(1,'category_id','¥«¥Æ¥´¥êID',53,'now()','now()');      
+        lfInsertData(4,'order_id','ÃíʸID',1,'now()','now()');
+        lfInsertData(4,'campaign_id','¥­¥ã¥ó¥Ú¡¼¥óID',2,'now()','now()');
+        lfInsertData(4,'customer_id','¸ÜµÒID',3,'now()','now()');
+        lfInsertData(4,'message','Í×˾Åù',4,'now()','now()');
+        lfInsertData(4,'order_name01','¸ÜµÒ̾1',5,'now()','now()');
+        lfInsertData(4,'order_name02','¸ÜµÒ̾2',6,'now()','now()');
+        lfInsertData(4,'order_kana01','¸ÜµÒ̾¥«¥Ê1',7,'now()','now()');
+        lfInsertData(4,'order_kana02','¸ÜµÒ̾¥«¥Ê2',8,'now()','now()');
+        lfInsertData(4,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',9,'now()','now()');
+        lfInsertData(4,'order_tel01','ÅÅÏÃÈÖ¹æ1',10,'now()','now()');
+        lfInsertData(4,'order_tel02','ÅÅÏÃÈÖ¹æ2',11,'now()','now()');
+        lfInsertData(4,'order_tel03','ÅÅÏÃÈÖ¹æ3',12,'now()','now()');
+        lfInsertData(4,'order_fax01','FAX1',13,'now()','now()');
+        lfInsertData(4,'order_fax02','FAX2',14,'now()','now()');
+        lfInsertData(4,'order_fax03','FAX3',15,'now()','now()');
+        lfInsertData(4,'order_zip01','͹ÊØÈÖ¹æ1',16,'now()','now()');
+        lfInsertData(4,'order_zip02','͹ÊØÈÖ¹æ2',17,'now()','now()');
+        lfInsertData(4,'order_pref','ÅÔÆ»Éܸ©',18,'now()','now()');
+        lfInsertData(4,'order_addr01','½»½ê1',19,'now()','now()');
+        lfInsertData(4,'order_addr02','½»½ê2',20,'now()','now()');
+        lfInsertData(4,'order_sex','À­ÊÌ',21,'now()','now()');
+        lfInsertData(4,'order_birth','À¸Ç¯·îÆü',22,'now()','now()');
+        lfInsertData(4,'order_job','¿¦¼ï',23,'now()','now()');
+        lfInsertData(4,'deliv_name01','ÇÛÁ÷Àè̾Á°',24,'now()','now()');
+        lfInsertData(4,'deliv_name02','ÇÛÁ÷Àè̾Á°',25,'now()','now()');
+        lfInsertData(4,'deliv_kana01','ÇÛÁ÷À襫¥Ê',26,'now()','now()');
+        lfInsertData(4,'deliv_kana02','ÇÛÁ÷À襫¥Ê',27,'now()','now()');
+        lfInsertData(4,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',28,'now()','now()');
+        lfInsertData(4,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',29,'now()','now()');
+        lfInsertData(4,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',30,'now()','now()');
+        lfInsertData(4,'deliv_fax01','FAX1',31,'now()','now()');
+        lfInsertData(4,'deliv_fax02','FAX2',32,'now()','now()');
+        lfInsertData(4,'deliv_fax03','FAX3',33,'now()','now()');
+        lfInsertData(4,'deliv_zip01','͹ÊØÈÖ¹æ1',34,'now()','now()');
+        lfInsertData(4,'deliv_zip02','͹ÊØÈÖ¹æ2',35,'now()','now()');
+        lfInsertData(4,'deliv_pref','ÅÔÆ»Éܸ©',36,'now()','now()');
+        lfInsertData(4,'deliv_addr01','½»½ê1',37,'now()','now()');
+        lfInsertData(4,'deliv_addr02','½»½ê2',38,'now()','now()');
+        lfInsertData(4,'payment_total','¤ª»Ùʧ¤¤¹ç·×',39,'now()','now()');
+    }
+}
+
+// ¥Ç¡¼¥¿¤ÎÄɲÃ
+function lfInsertData($csv_id,$col,$disp_name,$rank,$create_date,$update_date) {
+    $sql = "insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values($csv_id,'$col','$disp_name',$rank,$create_date,$update_date);";
+    sfDataExists("dtb_csv", "csv_id = ? AND col = ?", array($csv_id, $col), $dsn = "", $sql, true);
 }
 ?>