svnno****@sourc*****
svnno****@sourc*****
2007年 8月 25日 (土) 21:55:06 JST
Revision: 490
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=490
Author: shinsuke
Date: 2007-08-25 21:55:06 +0900 (Sat, 25 Aug 2007)
Log Message:
-----------
added cellphone, department, delivery_method. removed password.
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-24 21:45:58 UTC (rev 489)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-25 12:55:06 UTC (rev 490)
@@ -5,6 +5,7 @@
customers_id int NOT NULL,
entry_gender char(1) NOT NULL,
entry_company varchar(32),
+ entry_department varchar(32),
entry_firstname varchar(32) NOT NULL,
entry_lastname varchar(32) NOT NULL,
entry_street_address varchar(64) NOT NULL,
@@ -12,6 +13,9 @@
entry_postcode varchar(10) NOT NULL,
entry_city varchar(32) NOT NULL,
entry_state varchar(32),
+ entry_telephone varchar(32) NOT NULL,
+ entry_fax varchar(32),
+ entry_cellphone varchar(32),
entry_country_id int DEFAULT 0 NOT NULL,
entry_zone_id int DEFAULT 0 NOT NULL,
PRIMARY KEY (address_book_id)
@@ -148,7 +152,7 @@
customers_default_address_id int,
customers_telephone varchar(32) NOT NULL,
customers_fax varchar(32),
- customers_password varchar(40) NOT NULL,
+ customers_cellphone varchar(32),
customers_newsletter char(1),
PRIMARY KEY (customers_id)
);
@@ -343,31 +347,37 @@
customers_state varchar(32),
customers_country varchar(32) NOT NULL,
customers_telephone varchar(32) NOT NULL,
+ customers_cellphone varchar(32),
customers_email_address varchar(96) NOT NULL,
customers_address_format_id int NOT NULL,
delivery_name varchar(64) NOT NULL,
delivery_company varchar(32),
+ delivery_department 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),
delivery_address_format_id int NOT NULL,
billing_name varchar(64) NOT NULL,
billing_company varchar(32),
+ billing_department 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),
billing_address_format_id int NOT NULL,
payment_method varchar(32) NOT NULL,
cc_type varchar(20),
cc_owner varchar(64),
cc_number varchar(32),
cc_expires varchar(4),
+ delivery_method_id int NOT NULL,
last_modified TIMESTAMP,
date_purchased TIMESTAMP,
orders_status_id int NOT NULL,
@@ -448,6 +458,25 @@
PRIMARY KEY (orders_total_id)
);
+//DROP TABLE delivery_method;
+CREATE TABLE delivery_method (
+ delivery_method_id int NOT NULL GENERATED ALWAYS AS IDENTITY
+ (START WITH 1, INCREMENT BY 1),
+ sort_order int,
+ date_added TIMESTAMP,
+ last_modified TIMESTAMP,
+ PRIMARY KEY (categories_id)
+);
+
+//DROP TABLE delivery_method_description;
+CREATE TABLE delivery_method_description (
+ delivery_method_id int DEFAULT 0 NOT NULL,
+ language_id int DEFAULT 1 NOT NULL,
+ delivery_method_name varchar(32) NOT NULL,
+ PRIMARY KEY (delivery_method_id, language_id)
+);
+
+
//DROP TABLE reviews;
CREATE TABLE reviews (
reviews_id int NOT NULL,