Ignore:
Timestamp:
2007/02/28 16:17:07 (19 years ago)
Author:
inoue
Message:

モバイル版EC-CUBE

Location:
branches/dev/html/install
Files:
5 edited
4 copied

Legend:

Unmodified
Added
Removed

  • branches/dev/html/install/index.php

    r399 r11460  
    9999    $objPage->arrErr = lfAddTable("dtb_module", $dsn);          // ¥â¥¸¥å¡¼¥ë´ÉÍý¥Æ¡¼¥Ö¥ë 
    100100    $objPage->arrErr = lfAddTable("dtb_campaign_order", $dsn);  // ¥­¥ã¥ó¥Ú¡¼¥ó¼õÃí¥Æ¡¼¥Ö¥ë 
     101    // ¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ËÄɲ䵤ì¤ë¡£ 
     102    $objPage->arrErr = lfAddTable("dtb_mobile_kara_mail", $dsn);    // ¶õ¥á¡¼¥ë´ÉÍý¥Æ¡¼¥Ö¥ë 
     103    // ¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ËÄɲ䵤ì¤ë¡£ 
     104    $objPage->arrErr = lfAddTable("dtb_mobile_ext_session_id", $dsn);   // ¥»¥Ã¥·¥ç¥óID´ÉÍý¥Æ¡¼¥Ö¥ë 
    101105     
    102106    // ¥«¥é¥à¤òÄɲà
    … …  
    345349    $arrWriteFile = array( 
    346350        "../../data/install.inc", 
     351        "../../data/install_mobile.inc", 
    347352        "../user_data", 
    348353        "../cp", 
    349354        "../upload", 
    350         "../../data/Smarty/templates_c",         
     355        "../mobile/converted_images", 
     356        "../../data/Smarty/templates_c", 
    351357        "../../data/downloads", 
    352358        "../../data/logs" 
    … …  
    767773        fclose($fp); 
    768774    } 
     775 
     776    // ¥â¥Ð¥¤¥ëÈǤÎÀßÄê¥Õ¥¡¥¤¥ë install_mobile.inc ¤òºîÀ®¤¹¤ë¡£ 
     777    $filepath = $data_path . "install_mobile.inc"; 
     778     
     779    $config_data =  
     780    "<?php\n". 
     781    "    define ('ECCUBE_INSTALL', 'ON');\n" . 
     782    "    define ('HTML_PATH', '" . $root_dir . "mobile/');\n" .   
     783    "    define ('PC_HTML_PATH', '" . $root_dir . "');\n" .   
     784    "    define ('SITE_URL', '" . $normal_url . "mobile/');\n" . 
     785    "    define ('PC_SITE_URL', '" . $normal_url . "');\n" . 
     786    "    define ('SSL_URL', '" . $secure_url . "mobile/');\n" . 
     787    "    define ('PC_SSL_URL', '" . $secure_url . "');\n" . 
     788    "    define ('URL_DIR', '" . $url_dir . "mobile/');\n" .     
     789    "    define ('PC_URL_DIR', '" . $url_dir . "');\n" .     
     790    "    define ('DOMAIN_NAME', '" . $objWebParam->getValue('domain') . "');\n" . 
     791    "    define ('DB_TYPE', '" . $objDBParam->getValue('db_type') . "');\n" . 
     792    "    define ('DB_USER', '" . $objDBParam->getValue('db_user') . "');\n" .  
     793    "    define ('DB_PASSWORD', '" . $objDBParam->getValue('db_password') . "');\n" . 
     794    "    define ('DB_SERVER', '" . $objDBParam->getValue('db_server') . "');\n" . 
     795    "    define ('DB_NAME', '" . $objDBParam->getValue('db_name') . "');\n" . 
     796    "    define ('DB_PORT', '" . $objDBParam->getValue('db_port') .  "');\n" . 
     797    "    define ('DATA_PATH', '".$data_path."');\n" . 
     798    "?>"; 
     799     
     800    if($fp = fopen($filepath,"w")) { 
     801        fwrite($fp, $config_data); 
     802        fclose($fp); 
     803    } 
    769804} 
    770805 
    … …  
    803838// ¥«¥é¥à¤ÎÄɲáʴû¤Ë¥«¥é¥à¤¬Â¸ºß¤¹¤ë¾ì¹ç¤ÏºîÀ®¤·¤Ê¤¤¡Ë 
    804839function lfAddColumn($dsn) { 
     840    global $objDBParam; 
     841 
    805842    // ¼õÃí¥Æ¡¼¥Ö¥ë  
    806843    sfColumnExists("dtb_order", "memo01", "text", $dsn, true);   
    … …  
    853890    sfColumnExists("dtb_campaign", "cart_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); 
    854891    sfColumnExists("dtb_campaign", "deliv_free_flg", "int2 NOT NULL DEFAULT 0", $dsn, true);     
     892 
     893    // ¸ÜµÒ 
     894    if (!sfColumnExists("dtb_customer", "mobile_phone_id", "", $dsn)) { 
     895        sfColumnExists("dtb_customer", "mobile_phone_id", "text", $dsn, true); 
     896        $objQuery = new SC_Query($dsn); 
     897        if ($objDBParam->getValue('db_type') == 'mysql') { 
     898            $objQuery->query("CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64))"); 
     899        } else { 
     900            $objQuery->query("CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id)"); 
     901        } 
     902    } 
     903 
     904    // ¸ÜµÒ¥á¡¼¥ë 
     905    if ($objDBParam->getValue('db_type') == 'mysql') { 
     906        sfColumnExists("dtb_customer_mail", "secret_key", "varchar(50) unique", $dsn, true); 
     907    } else { 
     908        sfColumnExists("dtb_customer_mail", "secret_key", "text unique", $dsn, true); 
     909    } 
    855910} 
    856911 

  • branches/dev/html/install/sql/column_comment.sql

    r8 r11460  
    368368INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell02','·ÈÂÓÅÅÏÃÈÖ¹æ2'); 
    369369INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell03','·ÈÂÓÅÅÏÃÈÖ¹æ3'); 
     370INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','mobile_phone_id','·ÈÂÓüËöID'); 
    370371INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','email','¥á¡¼¥ë¥¢¥É¥ì¥¹'); 
    371372INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','mail_flag','1:HTML 2:TEXT 3:´õ˾¤·¤Ê¤¤ 4:²¾ÅÐÏ¿¡ÊHTML¡Ë 5:²¾ÅÐÏ¿(TEXT) 6:²¾ÅÐÏ¿(´õ˾¤·¤Ê¤¤)'); 
     373INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','secret_key','°Å¹æ²½¸ÜµÒID'); 
    372374INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','email','¥á¡¼¥ë¥¢¥É¥ì¥¹'); 
    373375INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','mail_flag','1:HTML 2:TEXT 3:´õ˾¤·¤Ê¤¤(Ää»ß)'); 

  • branches/dev/html/install/sql/create_table_mysql.sql

    r8 r11460  
    517517    cell01 text, 
    518518    cell02 text, 
    519     cell03 text 
    520 ) TYPE=InnoDB ; 
     519    cell03 text, 
     520    mobile_phone_id text 
     521) TYPE=InnoDB ; 
     522 
     523CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    521524 
    522525CREATE TABLE dtb_customer_mail ( 
    523526    email varchar(50) NOT NULL UNIQUE, 
    524527    mail_flag smallint, 
     528    secret_key varchar(50) UNIQUE, 
    525529    create_date datetime NOT NULL , 
    526530    update_date datetime  

  • branches/dev/html/install/sql/create_table_pgsql.sql

    r8 r11460  
    517517    cell01 text, 
    518518    cell02 text, 
    519     cell03 text 
    520 ); 
     519    cell03 text, 
     520    mobile_phone_id text 
     521); 
     522 
     523CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
    521524 
    522525CREATE TABLE dtb_customer_mail ( 
    523526    email text NOT NULL UNIQUE, 
    524527    mail_flag int2, 
     528    secret_key text UNIQUE, 
    525529    create_date timestamp NOT NULL DEFAULT now(), 
    526530    update_date timestamp DEFAULT now() 

  • branches/dev/html/install/sql/insert_data.sql

    r24 r11460  
    2323update dtb_pagelayout set page_id = 0 where page_id = 5; 
    2424 
    25 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); 
    26 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); 
    27 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); 
    28 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),2,'search_products'); 
    29 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),1,'news'); 
    30 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),1,'login'); 
    31 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),2,'best5'); 
    32 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); 
    33 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); 
    34 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); 
    35 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products'); 
    36 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news'); 
    37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login'); 
    38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5'); 
    39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); 
    40 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); 
    41 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); 
    42 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products'); 
    43 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news'); 
    44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login'); 
    45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5'); 
     25INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,1,2,'category'); 
     26INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,2,3,'guide'); 
     27INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,3,1,'cart'); 
     28INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,4,2,'search_products'); 
     29INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,5,1,'news'); 
     30INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,6,1,'login'); 
     31INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,7,2,'best5'); 
     32INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,1,2,'category'); 
     33INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,2,3,'guide'); 
     34INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,3,1,'cart'); 
     35INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,4,0,'search_products'); 
     36INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,5,0,'news'); 
     37INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,6,0,'login'); 
     38INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,7,0,'best5'); 
     39INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,1,2,'category'); 
     40INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,2,3,'guide'); 
     41INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,3,1,'cart'); 
     42INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,4,0,'search_products'); 
     43INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,5,0,'news'); 
     44INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,6,0,'login'); 
     45INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,7,0,'best5'); 
    4646 
    4747insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_id','¾¦ÉÊID',1,now(),now()); 
Note: See TracChangeset for help on using the changeset viewer.