osCommerce 日本語版

返答ありがとうございます。

どこをチェックすれば良いかも良くわかってないレベルの素人です。そのような改造は全然出来ません。

やったことと言えばコントロールパネル(と言う言い方でOKでしょうか?初期画面です)からショップの設定を行ったことと、各言語の説明ページを書き換えた位です。


もしかして、最初からインストールしなおしとかでは無いですよね?そうなった場合、今まで保存した商品情報は全て抹消されてしまうのでしょうか?


何度も済みませんが、宜しくお願いします。

DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
orders_id int NOT NULL auto_increment,
customers_id int NOT NULL,
customers_name varchar(64) NOT NULL,
customers_company varchar(32),
customers_street_address varchar(64) NOT NULL,
customers_suburb varchar(32),
customers_city varchar(32) NOT NULL,
customers_postcode varchar(10) NOT NULL,
customers_state varchar(32),
customers_country varchar(32) NOT NULL,
customers_telephone varchar(32) NOT NULL,
customers_email_address varchar(96) NOT NULL,
customers_address_format_id int(5) NOT NULL,
delivery_name varchar(64) NOT NULL,
delivery_company varchar(32),
delivery_street_address varchar(64) NOT NULL,
delivery_suburb varchar(32),
delivery_city varchar(32) NOT NULL,
delivery_postcode varchar(10) NOT NULL,
delivery_state varchar(32),
delivery_country varchar(32) NOT NULL,
delivery_telephone varchar(32) DEFAULT '',
delivery_address_format_id int(5) NOT NULL,
billing_name varchar(64) NOT NULL,
billing_company varchar(32),
billing_street_address varchar(64) NOT NULL,
billing_suburb varchar(32),
billing_city varchar(32) NOT NULL,
billing_postcode varchar(10) NOT NULL,
billing_state varchar(32),
billing_country varchar(32) NOT NULL,
billing_telephone varchar(32) DEFAULT '',
billing_address_format_id int(5) NOT NULL,
payment_method varchar(32) NOT NULL,
cc_type varchar(20),
cc_owner varchar(64),
cc_number varchar(32),
cc_expires varchar(4),
last_modified datetime,
date_purchased datetime,
orders_status int(5) NOT NULL,
orders_date_finished datetime,
currency char(3),
currency_value decimal(14,6),
PRIMARY KEY (orders_id)
);

DROP TABLE IF EXISTS orders_products;
CREATE TABLE orders_products (
orders_products_id int NOT NULL auto_increment,
orders_id int NOT NULL,
products_id int NOT NULL,
products_model varchar(12),
products_name varchar(64) NOT NULL,
products_price decimal(15,4) NOT NULL,
final_price decimal(15,4) NOT NULL,
products_tax decimal(7,4) NOT NULL,
products_quantity int(2) NOT NULL,
PRIMARY KEY (orders_products_id)
);

DROP TABLE IF EXISTS orders_status;
CREATE TABLE orders_status (
orders_status_id int DEFAULT '0' NOT NULL,
language_id int DEFAULT '1' NOT NULL,
orders_status_name varchar(32) NOT NULL,
PRIMARY KEY (orders_status_id, language_id),
KEY idx_orders_status_name (orders_status_name)
);

DROP TABLE IF EXISTS orders_status_history;
CREATE TABLE orders_status_history (
orders_status_history_id int NOT NULL auto_increment,
orders_id int NOT NULL,
orders_status_id int(5) NOT NULL,
date_added datetime NOT NULL,
customer_notified int(1) DEFAULT '0',
comments text,
PRIMARY KEY (orders_status_history_id)
);

DROP TABLE IF EXISTS orders_products_attributes;
CREATE TABLE orders_products_attributes (
orders_products_attributes_id int NOT NULL auto_increment,
orders_id int NOT NULL,
orders_products_id int NOT NULL,
products_options varchar(32) NOT NULL,
products_options_values varchar(32) NOT NULL,
options_values_price decimal(15,4) NOT NULL,
price_prefix char(1) NOT NULL,
PRIMARY KEY (orders_products_attributes_id)
);

DROP TABLE IF EXISTS orders_products_download;
CREATE TABLE orders_products_download (
orders_products_download_id int NOT NULL auto_increment,
orders_id int NOT NULL default '0',
orders_products_id int NOT NULL default '0',
orders_products_filename varchar(255) NOT NULL default '',
download_maxdays int(2) NOT NULL default '0',
download_count int(2) NOT NULL default '0',
PRIMARY KEY (orders_products_download_id)
);

DROP TABLE IF EXISTS orders_total;
CREATE TABLE orders_total (
orders_total_id int unsigned NOT NULL auto_increment,
orders_id int NOT NULL,
title varchar(255) NOT NULL,
text varchar(255) NOT NULL,
value decimal(15,4) NOT NULL,
class varchar(32) NOT NULL,
sort_order int NOT NULL,
PRIMARY KEY (orders_total_id),
KEY idx_orders_total_orders_id (orders_id)
);