Portal Application Laboratory

[pal-cvs 2873] [617] removed insert.

svnno****@sourc***** svnno****@sourc*****
2007年 10月 9日 (火) 12:18:51 JST

• 前の記事 [pal-cvs 2872] [616] modified m2 repo
• 次の記事 [pal-cvs 2874] [618] updated db(fixed typo and added type to order status).
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]

Revision: 617
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=617
Author:   shinsuke
Date:     2007-10-09 12:18:51 +0900 (Tue, 09 Oct 2007)

Log Message:
-----------
removed insert.

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql	2007-10-08 23:35:27 UTC (rev 616)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql	2007-10-09 03:18:51 UTC (rev 617)
@@ -1,371 +0,0 @@
-INSERT INTO LANGUAGE VALUES (2,'English','en','icon.gif','english',2);
-
-INSERT INTO COUNTRY VALUES (1,'Afghanistan','AF','AFG');
-INSERT INTO COUNTRY VALUES (2,'Albania','AL','ALB');
-INSERT INTO COUNTRY VALUES (3,'Algeria','DZ','DZA');
-INSERT INTO COUNTRY VALUES (4,'American Samoa','AS','ASM');
-INSERT INTO COUNTRY VALUES (5,'Andorra','AD','AND');
-INSERT INTO COUNTRY VALUES (6,'Angola','AO','AGO');
-INSERT INTO COUNTRY VALUES (7,'Anguilla','AI','AIA');
-INSERT INTO COUNTRY VALUES (8,'Antarctica','AQ','ATA');
-INSERT INTO COUNTRY VALUES (9,'Antigua and Barbuda','AG','ATG');
-INSERT INTO COUNTRY VALUES (10,'Argentina','AR','ARG');
-INSERT INTO COUNTRY VALUES (11,'Armenia','AM','ARM');
-INSERT INTO COUNTRY VALUES (12,'Aruba','AW','ABW');
-INSERT INTO COUNTRY VALUES (13,'Australia','AU','AUS');
-INSERT INTO COUNTRY VALUES (14,'Austria','AT','AUT');
-INSERT INTO COUNTRY VALUES (15,'Azerbaijan','AZ','AZE');
-INSERT INTO COUNTRY VALUES (16,'Bahamas','BS','BHS');
-INSERT INTO COUNTRY VALUES (17,'Bahrain','BH','BHR');
-INSERT INTO COUNTRY VALUES (18,'Bangladesh','BD','BGD');
-INSERT INTO COUNTRY VALUES (19,'Barbados','BB','BRB');
-INSERT INTO COUNTRY VALUES (20,'Belarus','BY','BLR');
-INSERT INTO COUNTRY VALUES (21,'Belgium','BE','BEL');
-INSERT INTO COUNTRY VALUES (22,'Belize','BZ','BLZ');
-INSERT INTO COUNTRY VALUES (23,'Benin','BJ','BEN');
-INSERT INTO COUNTRY VALUES (24,'Bermuda','BM','BMU');
-INSERT INTO COUNTRY VALUES (25,'Bhutan','BT','BTN');
-INSERT INTO COUNTRY VALUES (26,'Bolivia','BO','BOL');
-INSERT INTO COUNTRY VALUES (27,'Bosnia and Herzegowina','BA','BIH');
-INSERT INTO COUNTRY VALUES (28,'Botswana','BW','BWA');
-INSERT INTO COUNTRY VALUES (29,'Bouvet Island','BV','BVT');
-INSERT INTO COUNTRY VALUES (30,'Brazil','BR','BRA');
-INSERT INTO COUNTRY VALUES (31,'British Indian Ocean Territory','IO','IOT');
-INSERT INTO COUNTRY VALUES (32,'Brunei Darussalam','BN','BRN');
-INSERT INTO COUNTRY VALUES (33,'Bulgaria','BG','BGR');
-INSERT INTO COUNTRY VALUES (34,'Burkina Faso','BF','BFA');
-INSERT INTO COUNTRY VALUES (35,'Burundi','BI','BDI');
-INSERT INTO COUNTRY VALUES (36,'Cambodia','KH','KHM');
-INSERT INTO COUNTRY VALUES (37,'Cameroon','CM','CMR');
-INSERT INTO COUNTRY VALUES (38,'Canada','CA','CAN');
-INSERT INTO COUNTRY VALUES (39,'Cape Verde','CV','CPV');
-INSERT INTO COUNTRY VALUES (40,'Cayman Islands','KY','CYM');
-INSERT INTO COUNTRY VALUES (41,'Central African Republic','CF','CAF');
-INSERT INTO COUNTRY VALUES (42,'Chad','TD','TCD');
-INSERT INTO COUNTRY VALUES (43,'Chile','CL','CHL');
-INSERT INTO COUNTRY VALUES (44,'China','CN','CHN');
-INSERT INTO COUNTRY VALUES (45,'Christmas Island','CX','CXR');
-INSERT INTO COUNTRY VALUES (46,'Cocos (Keeling) Islands','CC','CCK');
-INSERT INTO COUNTRY VALUES (47,'Colombia','CO','COL');
-INSERT INTO COUNTRY VALUES (48,'Comoros','KM','COM');
-INSERT INTO COUNTRY VALUES (49,'Congo','CG','COG');
-INSERT INTO COUNTRY VALUES (50,'Cook Islands','CK','COK');
-INSERT INTO COUNTRY VALUES (51,'Costa Rica','CR','CRI');
-INSERT INTO COUNTRY VALUES (52,'Cote D''Ivoire','CI','CIV');
-INSERT INTO COUNTRY VALUES (53,'Croatia','HR','HRV');
-INSERT INTO COUNTRY VALUES (54,'Cuba','CU','CUB');
-INSERT INTO COUNTRY VALUES (55,'Cyprus','CY','CYP');
-INSERT INTO COUNTRY VALUES (56,'Czech Republic','CZ','CZE');
-INSERT INTO COUNTRY VALUES (57,'Denmark','DK','DNK');
-INSERT INTO COUNTRY VALUES (58,'Djibouti','DJ','DJI');
-INSERT INTO COUNTRY VALUES (59,'Dominica','DM','DMA');
-INSERT INTO COUNTRY VALUES (60,'Dominican Republic','DO','DOM');
-INSERT INTO COUNTRY VALUES (61,'East Timor','TP','TMP');
-INSERT INTO COUNTRY VALUES (62,'Ecuador','EC','ECU');
-INSERT INTO COUNTRY VALUES (63,'Egypt','EG','EGY');
-INSERT INTO COUNTRY VALUES (64,'El Salvador','SV','SLV');
-INSERT INTO COUNTRY VALUES (65,'Equatorial Guinea','GQ','GNQ');
-INSERT INTO COUNTRY VALUES (66,'Eritrea','ER','ERI');
-INSERT INTO COUNTRY VALUES (67,'Estonia','EE','EST');
-INSERT INTO COUNTRY VALUES (68,'Ethiopia','ET','ETH');
-INSERT INTO COUNTRY VALUES (69,'Falkland Islands (Malvinas)','FK','FLK');
-INSERT INTO COUNTRY VALUES (70,'Faroe Islands','FO','FRO');
-INSERT INTO COUNTRY VALUES (71,'Fiji','FJ','FJI');
-INSERT INTO COUNTRY VALUES (72,'Finland','FI','FIN');
-INSERT INTO COUNTRY VALUES (73,'France','FR','FRA');
-INSERT INTO COUNTRY VALUES (74,'France, Metropolitan','FX','FXX');
-INSERT INTO COUNTRY VALUES (75,'French Guiana','GF','GUF');
-INSERT INTO COUNTRY VALUES (76,'French Polynesia','PF','PYF');
-INSERT INTO COUNTRY VALUES (77,'French Southern Territories','TF','ATF');
-INSERT INTO COUNTRY VALUES (78,'Gabon','GA','GAB');
-INSERT INTO COUNTRY VALUES (79,'Gambia','GM','GMB');
-INSERT INTO COUNTRY VALUES (80,'Georgia','GE','GEO');
-INSERT INTO COUNTRY VALUES (81,'Germany','DE','DEU');
-INSERT INTO COUNTRY VALUES (82,'Ghana','GH','GHA');
-INSERT INTO COUNTRY VALUES (83,'Gibraltar','GI','GIB');
-INSERT INTO COUNTRY VALUES (84,'Greece','GR','GRC');
-INSERT INTO COUNTRY VALUES (85,'Greenland','GL','GRL');
-INSERT INTO COUNTRY VALUES (86,'Grenada','GD','GRD');
-INSERT INTO COUNTRY VALUES (87,'Guadeloupe','GP','GLP');
-INSERT INTO COUNTRY VALUES (88,'Guam','GU','GUM');
-INSERT INTO COUNTRY VALUES (89,'Guatemala','GT','GTM');
-INSERT INTO COUNTRY VALUES (90,'Guinea','GN','GIN');
-INSERT INTO COUNTRY VALUES (91,'Guinea-bissau','GW','GNB');
-INSERT INTO COUNTRY VALUES (92,'Guyana','GY','GUY');
-INSERT INTO COUNTRY VALUES (93,'Haiti','HT','HTI');
-INSERT INTO COUNTRY VALUES (94,'Heard and Mc Donald Islands','HM','HMD');
-INSERT INTO COUNTRY VALUES (95,'Honduras','HN','HND');
-INSERT INTO COUNTRY VALUES (96,'Hong Kong','HK','HKG');
-INSERT INTO COUNTRY VALUES (97,'Hungary','HU','HUN');
-INSERT INTO COUNTRY VALUES (98,'Iceland','IS','ISL');
-INSERT INTO COUNTRY VALUES (99,'India','IN','IND');
-INSERT INTO COUNTRY VALUES (100,'Indonesia','ID','IDN');
-INSERT INTO COUNTRY VALUES (101,'Iran (Islamic Republic of)','IR','IRN');
-INSERT INTO COUNTRY VALUES (102,'Iraq','IQ','IRQ');
-INSERT INTO COUNTRY VALUES (103,'Ireland','IE','IRL');
-INSERT INTO COUNTRY VALUES (104,'Israel','IL','ISR');
-INSERT INTO COUNTRY VALUES (105,'Italy','IT','ITA');
-INSERT INTO COUNTRY VALUES (106,'Jamaica','JM','JAM');
-INSERT INTO COUNTRY VALUES (108,'Jordan','JO','JOR');
-INSERT INTO COUNTRY VALUES (109,'Kazakhstan','KZ','KAZ');
-INSERT INTO COUNTRY VALUES (110,'Kenya','KE','KEN');
-INSERT INTO COUNTRY VALUES (111,'Kiribati','KI','KIR');
-INSERT INTO COUNTRY VALUES (112,'Korea, Democratic People''s Republic of','KP','PRK');
-INSERT INTO COUNTRY VALUES (113,'Korea, Republic of','KR','KOR');
-INSERT INTO COUNTRY VALUES (114,'Kuwait','KW','KWT');
-INSERT INTO COUNTRY VALUES (115,'Kyrgyzstan','KG','KGZ');
-INSERT INTO COUNTRY VALUES (116,'Lao People''s Democratic Republic','LA','LAO');
-INSERT INTO COUNTRY VALUES (117,'Latvia','LV','LVA');
-INSERT INTO COUNTRY VALUES (118,'Lebanon','LB','LBN');
-INSERT INTO COUNTRY VALUES (119,'Lesotho','LS','LSO');
-INSERT INTO COUNTRY VALUES (120,'Liberia','LR','LBR');
-INSERT INTO COUNTRY VALUES (121,'Libyan Arab Jamahiriya','LY','LBY');
-INSERT INTO COUNTRY VALUES (122,'Liechtenstein','LI','LIE');
-INSERT INTO COUNTRY VALUES (123,'Lithuania','LT','LTU');
-INSERT INTO COUNTRY VALUES (124,'Luxembourg','LU','LUX');
-INSERT INTO COUNTRY VALUES (125,'Macau','MO','MAC');
-INSERT INTO COUNTRY VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD');
-INSERT INTO COUNTRY VALUES (127,'Madagascar','MG','MDG');
-INSERT INTO COUNTRY VALUES (128,'Malawi','MW','MWI');
-INSERT INTO COUNTRY VALUES (129,'Malaysia','MY','MYS');
-INSERT INTO COUNTRY VALUES (130,'Maldives','MV','MDV');
-INSERT INTO COUNTRY VALUES (131,'Mali','ML','MLI');
-INSERT INTO COUNTRY VALUES (132,'Malta','MT','MLT');
-INSERT INTO COUNTRY VALUES (133,'Marshall Islands','MH','MHL');
-INSERT INTO COUNTRY VALUES (134,'Martinique','MQ','MTQ');
-INSERT INTO COUNTRY VALUES (135,'Mauritania','MR','MRT');
-INSERT INTO COUNTRY VALUES (136,'Mauritius','MU','MUS');
-INSERT INTO COUNTRY VALUES (137,'Mayotte','YT','MYT');
-INSERT INTO COUNTRY VALUES (138,'Mexico','MX','MEX');
-INSERT INTO COUNTRY VALUES (139,'Micronesia, Federated States of','FM','FSM');
-INSERT INTO COUNTRY VALUES (140,'Moldova, Republic of','MD','MDA');
-INSERT INTO COUNTRY VALUES (141,'Monaco','MC','MCO');
-INSERT INTO COUNTRY VALUES (142,'Mongolia','MN','MNG');
-INSERT INTO COUNTRY VALUES (143,'Montserrat','MS','MSR');
-INSERT INTO COUNTRY VALUES (144,'Morocco','MA','MAR');
-INSERT INTO COUNTRY VALUES (145,'Mozambique','MZ','MOZ');
-INSERT INTO COUNTRY VALUES (146,'Myanmar','MM','MMR');
-INSERT INTO COUNTRY VALUES (147,'Namibia','NA','NAM');
-INSERT INTO COUNTRY VALUES (148,'Nauru','NR','NRU');
-INSERT INTO COUNTRY VALUES (149,'Nepal','NP','NPL');
-INSERT INTO COUNTRY VALUES (150,'Netherlands','NL','NLD');
-INSERT INTO COUNTRY VALUES (151,'Netherlands Antilles','AN','ANT');
-INSERT INTO COUNTRY VALUES (152,'New Caledonia','NC','NCL');
-INSERT INTO COUNTRY VALUES (153,'New Zealand','NZ','NZL');
-INSERT INTO COUNTRY VALUES (154,'Nicaragua','NI','NIC');
-INSERT INTO COUNTRY VALUES (155,'Niger','NE','NER');
-INSERT INTO COUNTRY VALUES (156,'Nigeria','NG','NGA');
-INSERT INTO COUNTRY VALUES (157,'Niue','NU','NIU');
-INSERT INTO COUNTRY VALUES (158,'Norfolk Island','NF','NFK');
-INSERT INTO COUNTRY VALUES (159,'Northern Mariana Islands','MP','MNP');
-INSERT INTO COUNTRY VALUES (160,'Norway','NO','NOR');
-INSERT INTO COUNTRY VALUES (161,'Oman','OM','OMN');
-INSERT INTO COUNTRY VALUES (162,'Pakistan','PK','PAK');
-INSERT INTO COUNTRY VALUES (163,'Palau','PW','PLW');
-INSERT INTO COUNTRY VALUES (164,'Panama','PA','PAN');
-INSERT INTO COUNTRY VALUES (165,'Papua New Guinea','PG','PNG');
-INSERT INTO COUNTRY VALUES (166,'Paraguay','PY','PRY');
-INSERT INTO COUNTRY VALUES (167,'Peru','PE','PER');
-INSERT INTO COUNTRY VALUES (168,'Philippines','PH','PHL');
-INSERT INTO COUNTRY VALUES (169,'Pitcairn','PN','PCN');
-INSERT INTO COUNTRY VALUES (170,'Poland','PL','POL');
-INSERT INTO COUNTRY VALUES (171,'Portugal','PT','PRT');
-INSERT INTO COUNTRY VALUES (172,'Puerto Rico','PR','PRI');
-INSERT INTO COUNTRY VALUES (173,'Qatar','QA','QAT');
-INSERT INTO COUNTRY VALUES (174,'Reunion','RE','REU');
-INSERT INTO COUNTRY VALUES (175,'Romania','RO','ROM');
-INSERT INTO COUNTRY VALUES (176,'Russian Federation','RU','RUS');
-INSERT INTO COUNTRY VALUES (177,'Rwanda','RW','RWA');
-INSERT INTO COUNTRY VALUES (178,'Saint Kitts and Nevis','KN','KNA');
-INSERT INTO COUNTRY VALUES (179,'Saint Lucia','LC','LCA');
-INSERT INTO COUNTRY VALUES (180,'Saint Vincent and the Grenadines','VC','VCT');
-INSERT INTO COUNTRY VALUES (181,'Samoa','WS','WSM');
-INSERT INTO COUNTRY VALUES (182,'San Marino','SM','SMR');
-INSERT INTO COUNTRY VALUES (183,'Sao Tome and Principe','ST','STP');
-INSERT INTO COUNTRY VALUES (184,'Saudi Arabia','SA','SAU');
-INSERT INTO COUNTRY VALUES (185,'Senegal','SN','SEN');
-INSERT INTO COUNTRY VALUES (186,'Seychelles','SC','SYC');
-INSERT INTO COUNTRY VALUES (187,'Sierra Leone','SL','SLE');
-INSERT INTO COUNTRY VALUES (188,'Singapore','SG','SGP');
-INSERT INTO COUNTRY VALUES (189,'Slovakia (Slovak Republic)','SK','SVK');
-INSERT INTO COUNTRY VALUES (190,'Slovenia','SI','SVN');
-INSERT INTO COUNTRY VALUES (191,'Solomon Islands','SB','SLB');
-INSERT INTO COUNTRY VALUES (192,'Somalia','SO','SOM');
-INSERT INTO COUNTRY VALUES (193,'South Africa','ZA','ZAF');
-INSERT INTO COUNTRY VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS');
-INSERT INTO COUNTRY VALUES (195,'Spain','ES','ESP');
-INSERT INTO COUNTRY VALUES (196,'Sri Lanka','LK','LKA');
-INSERT INTO COUNTRY VALUES (197,'St. Helena','SH','SHN');
-INSERT INTO COUNTRY VALUES (198,'St. Pierre and Miquelon','PM','SPM');
-INSERT INTO COUNTRY VALUES (199,'Sudan','SD','SDN');
-INSERT INTO COUNTRY VALUES (200,'Suriname','SR','SUR');
-INSERT INTO COUNTRY VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM');
-INSERT INTO COUNTRY VALUES (202,'Swaziland','SZ','SWZ');
-INSERT INTO COUNTRY VALUES (203,'Sweden','SE','SWE');
-INSERT INTO COUNTRY VALUES (204,'Switzerland','CH','CHE');
-INSERT INTO COUNTRY VALUES (205,'Syrian Arab Republic','SY','SYR');
-INSERT INTO COUNTRY VALUES (206,'Taiwan','TW','TWN');
-INSERT INTO COUNTRY VALUES (207,'Tajikistan','TJ','TJK');
-INSERT INTO COUNTRY VALUES (208,'Tanzania, United Republic of','TZ','TZA');
-INSERT INTO COUNTRY VALUES (209,'Thailand','TH','THA');
-INSERT INTO COUNTRY VALUES (210,'Togo','TG','TGO');
-INSERT INTO COUNTRY VALUES (211,'Tokelau','TK','TKL');
-INSERT INTO COUNTRY VALUES (212,'Tonga','TO','TON');
-INSERT INTO COUNTRY VALUES (213,'Trinidad and Tobago','TT','TTO');
-INSERT INTO COUNTRY VALUES (214,'Tunisia','TN','TUN');
-INSERT INTO COUNTRY VALUES (215,'Turkey','TR','TUR');
-INSERT INTO COUNTRY VALUES (216,'Turkmenistan','TM','TKM');
-INSERT INTO COUNTRY VALUES (217,'Turks and Caicos Islands','TC','TCA');
-INSERT INTO COUNTRY VALUES (218,'Tuvalu','TV','TUV');
-INSERT INTO COUNTRY VALUES (219,'Uganda','UG','UGA');
-INSERT INTO COUNTRY VALUES (220,'Ukraine','UA','UKR');
-INSERT INTO COUNTRY VALUES (221,'United Arab Emirates','AE','ARE');
-INSERT INTO COUNTRY VALUES (222,'United Kingdom','GB','GBR');
-INSERT INTO COUNTRY VALUES (223,'United States','US','USA');
-INSERT INTO COUNTRY VALUES (224,'United States Minor Outlying Islands','UM','UMI');
-INSERT INTO COUNTRY VALUES (225,'Uruguay','UY','URY');
-INSERT INTO COUNTRY VALUES (226,'Uzbekistan','UZ','UZB');
-INSERT INTO COUNTRY VALUES (227,'Vanuatu','VU','VUT');
-INSERT INTO COUNTRY VALUES (228,'Vatican City State (Holy See)','VA','VAT');
-INSERT INTO COUNTRY VALUES (229,'Venezuela','VE','VEN');
-INSERT INTO COUNTRY VALUES (230,'Viet Nam','VN','VNM');
-INSERT INTO COUNTRY VALUES (231,'Virgin Islands (British)','VG','VGB');
-INSERT INTO COUNTRY VALUES (232,'Virgin Islands (U.S.)','VI','VIR');
-INSERT INTO COUNTRY VALUES (233,'Wallis and Futuna Islands','WF','WLF');
-INSERT INTO COUNTRY VALUES (234,'Western Sahara','EH','ESH');
-INSERT INTO COUNTRY VALUES (235,'Yemen','YE','YEM');
-INSERT INTO COUNTRY VALUES (236,'Yugoslavia','YU','YUG');
-INSERT INTO COUNTRY VALUES (237,'Zaire','ZR','ZAR');
-INSERT INTO COUNTRY VALUES (238,'Zambia','ZM','ZMB');
-INSERT INTO COUNTRY VALUES (239,'Zimbabwe','ZW','ZWE');
-
-INSERT INTO CURRENCY VALUES (2,'USD','$','','###,###.##','2007-01-01 00:00:00','2007-01-01 00:00:00');
-
-INSERT INTO CURRENCY_DESCRIPTION VALUES (2,2,'US Dollar','');
-
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 1, 2, 'New Order','');
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 2, 2, 'Received Money Processing','');
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 3, 2, 'Credit Card Processing','');
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 4, 2, 'Delivering','');
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 5, 2, 'Delivered','');
-INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 6, 2, 'Pending','');
-
--- USA
-INSERT INTO ZONE VALUES (1,223,'AL','Alabama');
-INSERT INTO ZONE VALUES (2,223,'AK','Alaska');
-INSERT INTO ZONE VALUES (3,223,'AS','American Samoa');
-INSERT INTO ZONE VALUES (4,223,'AZ','Arizona');
-INSERT INTO ZONE VALUES (5,223,'AR','Arkansas');
-INSERT INTO ZONE VALUES (6,223,'AF','Armed Forces Africa');
-INSERT INTO ZONE VALUES (7,223,'AA','Armed Forces Americas');
-INSERT INTO ZONE VALUES (8,223,'AC','Armed Forces Canada');
-INSERT INTO ZONE VALUES (9,223,'AE','Armed Forces Europe');
-INSERT INTO ZONE VALUES (10,223,'AM','Armed Forces Middle East');
-INSERT INTO ZONE VALUES (11,223,'AP','Armed Forces Pacific');
-INSERT INTO ZONE VALUES (12,223,'CA','California');
-INSERT INTO ZONE VALUES (13,223,'CO','Colorado');
-INSERT INTO ZONE VALUES (14,223,'CT','Connecticut');
-INSERT INTO ZONE VALUES (15,223,'DE','Delaware');
-INSERT INTO ZONE VALUES (16,223,'DC','District of Columbia');
-INSERT INTO ZONE VALUES (17,223,'FM','Federated States Of Micronesia');
-INSERT INTO ZONE VALUES (18,223,'FL','Florida');
-INSERT INTO ZONE VALUES (19,223,'GA','Georgia');
-INSERT INTO ZONE VALUES (20,223,'GU','Guam');
-INSERT INTO ZONE VALUES (21,223,'HI','Hawaii');
-INSERT INTO ZONE VALUES (22,223,'ID','Idaho');
-INSERT INTO ZONE VALUES (23,223,'IL','Illinois');
-INSERT INTO ZONE VALUES (24,223,'IN','Indiana');
-INSERT INTO ZONE VALUES (25,223,'IA','Iowa');
-INSERT INTO ZONE VALUES (26,223,'KS','Kansas');
-INSERT INTO ZONE VALUES (27,223,'KY','Kentucky');
-INSERT INTO ZONE VALUES (28,223,'LA','Louisiana');
-INSERT INTO ZONE VALUES (29,223,'ME','Maine');
-INSERT INTO ZONE VALUES (30,223,'MH','Marshall Islands');
-INSERT INTO ZONE VALUES (31,223,'MD','Maryland');
-INSERT INTO ZONE VALUES (32,223,'MA','Massachusetts');
-INSERT INTO ZONE VALUES (33,223,'MI','Michigan');
-INSERT INTO ZONE VALUES (34,223,'MN','Minnesota');
-INSERT INTO ZONE VALUES (35,223,'MS','Mississippi');
-INSERT INTO ZONE VALUES (36,223,'MO','Missouri');
-INSERT INTO ZONE VALUES (37,223,'MT','Montana');
-INSERT INTO ZONE VALUES (38,223,'NE','Nebraska');
-INSERT INTO ZONE VALUES (39,223,'NV','Nevada');
-INSERT INTO ZONE VALUES (40,223,'NH','New Hampshire');
-INSERT INTO ZONE VALUES (41,223,'NJ','New Jersey');
-INSERT INTO ZONE VALUES (42,223,'NM','New Mexico');
-INSERT INTO ZONE VALUES (43,223,'NY','New York');
-INSERT INTO ZONE VALUES (44,223,'NC','North Carolina');
-INSERT INTO ZONE VALUES (45,223,'ND','North Dakota');
-INSERT INTO ZONE VALUES (46,223,'MP','Northern Mariana Islands');
-INSERT INTO ZONE VALUES (47,223,'OH','Ohio');
-INSERT INTO ZONE VALUES (48,223,'OK','Oklahoma');
-INSERT INTO ZONE VALUES (49,223,'OR','Oregon');
-INSERT INTO ZONE VALUES (50,223,'PW','Palau');
-INSERT INTO ZONE VALUES (51,223,'PA','Pennsylvania');
-INSERT INTO ZONE VALUES (52,223,'PR','Puerto Rico');
-INSERT INTO ZONE VALUES (53,223,'RI','Rhode Island');
-INSERT INTO ZONE VALUES (54,223,'SC','South Carolina');
-INSERT INTO ZONE VALUES (55,223,'SD','South Dakota');
-INSERT INTO ZONE VALUES (56,223,'TN','Tennessee');
-INSERT INTO ZONE VALUES (57,223,'TX','Texas');
-INSERT INTO ZONE VALUES (58,223,'UT','Utah');
-INSERT INTO ZONE VALUES (59,223,'VT','Vermont');
-INSERT INTO ZONE VALUES (60,223,'VI','Virgin Islands');
-INSERT INTO ZONE VALUES (61,223,'VA','Virginia');
-INSERT INTO ZONE VALUES (62,223,'WA','Washington');
-INSERT INTO ZONE VALUES (63,223,'WV','West Virginia');
-INSERT INTO ZONE VALUES (64,223,'WI','Wisconsin');
-INSERT INTO ZONE VALUES (65,223,'WY','Wyoming');
-
-INSERT INTO TAX_CLASS VALUES (2, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-
-INSERT INTO TAX_RATE VALUES (2, 1, 2, 1, 7.0, 'FL TAX 7.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-
-INSERT INTO DELIVERY_METHOD VALUES (1,'POMEPIUNYU','defaultDeliveryMethodCalculator',1,1,'2007-09-20 03:32:13','2007-09-20 03:32:13');
-INSERT INTO DELIVERY_METHOD VALUES (2,'POMPEIKYUBIN','defaultDeliveryMethodCalculator',1,2,'2007-09-20 03:32:28','2007-09-20 03:32:28');
-
-INSERT INTO DELIVERY_METHOD_DESCRIPTION VALUES (1,1,'ポンペイ運輸','一般消費者・企業向け小口貨物輸送サービスを提供');
-INSERT INTO DELIVERY_METHOD_DESCRIPTION VALUES (2,1,'ポンペイ急便','宅配便など各種輸送にかかわるサービスを提供');
-
-INSERT INTO PAYMENT_METHOD VALUES (1,'COD',1,'2007-09-20 03:32:13','2007-09-20 03:32:13');
-INSERT INTO PAYMENT_METHOD VALUES (2,'BANK',2,'2007-09-20 03:32:28','2007-09-20 03:32:28');
-INSERT INTO PAYMENT_METHOD VALUES (3,'CREDITCARD',3,'2007-09-20 03:32:28','2007-09-20 03:32:28');
-
-INSERT INTO PAYMENT_METHOD_DESCRIPTION VALUES (1,1,'代金引換','業者:ポンペイ運輸<br/>備考:<br/><ul><li>代引手数料は300円(税込)となります。</li><li>商品が２つ以上に分かれて配送する場合、お届け明細やメールで表示されている消費税額と、実際に請求される消費税額に誤差が生じる場合がございます。</li><li>実際に請求される金額が正しい消費税額となりますので、ご了承ください。</li></ul>');
-INSERT INTO PAYMENT_METHOD_DESCRIPTION VALUES (2,1,'銀行振込','振込先: ポンペイ銀行 本店事業部　普通　1234567<br/><ul><li>振込手数料はお客様負担でお願い致します。</li><li>お申込後、お振り込み金額を記載したご案内メールをお送りしております。必ずメールをご確認の上お振込みください。</li><li>当店でご注文確認後三日以内にお振り込みがない場合は、ご注文を取り消させていただく場合があります。</li><li>振込伝票は無くさないように保管してください。</li><li>ご購入金額全てを楽天スーパーポイントで支払う場合(お支払金額がゼロ円になる場合)は、必ず銀行振替を選択してください。</li><li>他の支払い方法を選んだ場合、手数料か発生する場合があります(発生した手数料は返金できません)。</li></ul>');
-INSERT INTO PAYMENT_METHOD_DESCRIPTION VALUES (3,1,'クレジットカード','取扱カード: <br/>取り扱いカードは以下のとおりです。 すべてのカード会社で、一括払いが可能となっております。<br/><table><tr><th>カード会社</th><th>支払方法</th></tr><tr><td>VISA</td><td>一括払い、リボ</td></tr><tr><td>MASTER</td><td>一括払い、リボ</td></tr><tr><td>JCB</td><td>一括払い、リボ</td></tr></table><br/>備考:<br/><ul><li>お支払い回数は「１回払い」と「リボルビング払い(リボ払い)」とさせていただきます。</li><li>当店ではセキュリティ上の配慮から、クレジットカード利用控は原則としてお送りしておりません。カード会社から送付されますご利用明細をご確認ください。</li><li>お支払い日は、ご指定のカード会社の規約に基づいた指定日のお支払いとなります。</li></ul>');
-
-INSERT INTO CARD_TYPE VALUES (1,'VISA',1,'2007-09-20 03:32:13','2007-09-20 03:32:13');
-INSERT INTO CARD_TYPE VALUES (2,'MASTER',2,'2007-09-20 03:32:28','2007-09-20 03:32:28');
-INSERT INTO CARD_TYPE VALUES (3,'JCB',3,'2007-09-20 03:32:28','2007-09-20 03:32:28');
-
-INSERT INTO CARD_TYPE_DESCRIPTION VALUES (1,1,'VISA','');
-INSERT INTO CARD_TYPE_DESCRIPTION VALUES (2,1,'MASTER','');
-INSERT INTO CARD_TYPE_DESCRIPTION VALUES (3,1,'JCB','');
-
-INSERT INTO CATEGORY VALUES (2,NULL,1,1,'2007-09-20 07:09:33','2007-09-20 07:09:33');
-INSERT INTO CATEGORY VALUES (3,NULL,1,2,'2007-09-20 06:30:11','2007-09-20 06:30:11');
-
-INSERT INTO CATEGORY_DESCRIPTION VALUES (2,1,'ハードウェア','パソコン関連のハードウェア');
-INSERT INTO CATEGORY_DESCRIPTION VALUES (3,1,'ソフトウェア','パソコン関連のソフトウェア');
-
-INSERT INTO MANUFACTURER VALUES (1,'Matrox',NULL,'2007-09-20 08:40:13','2007-09-20 08:40:13');
-INSERT INTO MANUFACTURER VALUES (2,'Microsoft',NULL,'2007-09-20 08:40:47','2007-09-20 08:40:47');
-INSERT INTO MANUFACTURER VALUES (3,'Warner Bros.',NULL,'2007-09-20 08:41:02','2007-09-20 08:41:02');
-
-INSERT INTO MANUFACTURER_DESCRIPTION VALUES (1,1,'http://www.matrox.com','ハードウェア会社',NULL);
-INSERT INTO MANUFACTURER_DESCRIPTION VALUES (2,1,'http://www.microsoft.com/','ソフトウェア会社',NULL);
-INSERT INTO MANUFACTURER_DESCRIPTION VALUES (3,1,'http://www.warner.com',NULL,NULL);
-
-INSERT INTO PRODUCT VALUES (1,'12345','MG200MMS',100,1000.0000,100.00,NULL,0,0,0,1,'2007-09-20 12:31:53','2007-09-20 12:31:53',NULL,1,1);
-INSERT INTO PRODUCT VALUES (2,'123456','MG400-32MB',100,2000.0000,200.00,NULL,0,0,0,1,'2007-09-20 12:32:34','2007-09-20 12:32:34',NULL,1,1);
-INSERT INTO PRODUCT VALUES (3,'123457','WINDOWS-XP',100,10000.0000,100.00,NULL,0,0,0,1,'2007-09-20 12:33:59','2007-09-20 12:33:59',NULL,1,2);
-
-INSERT INTO PRODUCT_DESCRIPTION VALUES (1,1,'Matrox G200 MMS',NULL,NULL,NULL,0);
-INSERT INTO PRODUCT_DESCRIPTION VALUES (2,1,'Matrox G400 32MB',NULL,NULL,NULL,0);
-INSERT INTO PRODUCT_DESCRIPTION VALUES (3,1,'Windows XP',NULL,NULL,NULL,0);
-
-INSERT INTO PRODUCT_TO_CATEGORY VALUES (1,2,NULL);
-INSERT INTO PRODUCT_TO_CATEGORY VALUES (2,2,NULL);
-INSERT INTO PRODUCT_TO_CATEGORY VALUES (3,3,NULL);
-

• 前の記事 [pal-cvs 2872] [616] modified m2 repo
• 次の記事 [pal-cvs 2874] [618] updated db(fixed typo and added type to order status).
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]