| [ Index ] |
|
Code source de osCommerce 2.2ms2-060817 |
1 # $Id: oscommerce.sql,v 1.84 2003/05/27 17:32:16 hpdl Exp $ 2 # 3 # osCommerce, Open Source E-Commerce Solutions 4 # http://www.oscommerce.com 5 # 6 # Copyright (c) 2003 osCommerce 7 # 8 # Released under the GNU General Public License 9 # 10 # NOTE: * Please make any modifications to this file by hand! 11 # * DO NOT use a mysqldump created file for new changes! 12 # * Please take note of the table structure, and use this 13 # structure as a standard for future modifications! 14 # * Any tables you add here should be added in admin/backup.php 15 # and in catalog/install/includes/functions/database.php 16 # * To see the 'diff'erence between MySQL databases, use 17 # the mysqldiff perl script located in the extras 18 # directory of the 'catalog' module. 19 # * Comments should be like these, full line comments. 20 # (don't use inline comments) 21 22 DROP TABLE IF EXISTS address_book; 23 CREATE TABLE address_book ( 24 address_book_id int NOT NULL auto_increment, 25 customers_id int NOT NULL, 26 entry_gender char(1) NOT NULL, 27 entry_company varchar(32), 28 entry_firstname varchar(32) NOT NULL, 29 entry_lastname varchar(32) NOT NULL, 30 entry_street_address varchar(64) NOT NULL, 31 entry_suburb varchar(32), 32 entry_postcode varchar(10) NOT NULL, 33 entry_city varchar(32) NOT NULL, 34 entry_state varchar(32), 35 entry_country_id int DEFAULT '0' NOT NULL, 36 entry_zone_id int DEFAULT '0' NOT NULL, 37 PRIMARY KEY (address_book_id), 38 KEY idx_address_book_customers_id (customers_id) 39 ); 40 41 DROP TABLE IF EXISTS address_format; 42 CREATE TABLE address_format ( 43 address_format_id int NOT NULL auto_increment, 44 address_format varchar(128) NOT NULL, 45 address_summary varchar(48) NOT NULL, 46 PRIMARY KEY (address_format_id) 47 ); 48 49 DROP TABLE IF EXISTS banners; 50 CREATE TABLE banners ( 51 banners_id int NOT NULL auto_increment, 52 banners_title varchar(64) NOT NULL, 53 banners_url varchar(255) NOT NULL, 54 banners_image varchar(64) NOT NULL, 55 banners_group varchar(10) NOT NULL, 56 banners_html_text text, 57 expires_impressions int(7) DEFAULT '0', 58 expires_date datetime DEFAULT NULL, 59 date_scheduled datetime DEFAULT NULL, 60 date_added datetime NOT NULL, 61 date_status_change datetime DEFAULT NULL, 62 status int(1) DEFAULT '1' NOT NULL, 63 PRIMARY KEY (banners_id) 64 ); 65 66 DROP TABLE IF EXISTS banners_history; 67 CREATE TABLE banners_history ( 68 banners_history_id int NOT NULL auto_increment, 69 banners_id int NOT NULL, 70 banners_shown int(5) NOT NULL DEFAULT '0', 71 banners_clicked int(5) NOT NULL DEFAULT '0', 72 banners_history_date datetime NOT NULL, 73 PRIMARY KEY (banners_history_id) 74 ); 75 76 DROP TABLE IF EXISTS categories; 77 CREATE TABLE categories ( 78 categories_id int NOT NULL auto_increment, 79 categories_image varchar(64), 80 parent_id int DEFAULT '0' NOT NULL, 81 sort_order int(3), 82 date_added datetime, 83 last_modified datetime, 84 PRIMARY KEY (categories_id), 85 KEY idx_categories_parent_id (parent_id) 86 ); 87 88 DROP TABLE IF EXISTS categories_description; 89 CREATE TABLE categories_description ( 90 categories_id int DEFAULT '0' NOT NULL, 91 language_id int DEFAULT '1' NOT NULL, 92 categories_name varchar(32) NOT NULL, 93 PRIMARY KEY (categories_id, language_id), 94 KEY idx_categories_name (categories_name) 95 ); 96 97 DROP TABLE IF EXISTS configuration; 98 CREATE TABLE configuration ( 99 configuration_id int NOT NULL auto_increment, 100 configuration_title varchar(64) NOT NULL, 101 configuration_key varchar(64) NOT NULL, 102 configuration_value varchar(255) NOT NULL, 103 configuration_description varchar(255) NOT NULL, 104 configuration_group_id int NOT NULL, 105 sort_order int(5) NULL, 106 last_modified datetime NULL, 107 date_added datetime NOT NULL, 108 use_function varchar(255) NULL, 109 set_function varchar(255) NULL, 110 PRIMARY KEY (configuration_id) 111 ); 112 113 DROP TABLE IF EXISTS configuration_group; 114 CREATE TABLE configuration_group ( 115 configuration_group_id int NOT NULL auto_increment, 116 configuration_group_title varchar(64) NOT NULL, 117 configuration_group_description varchar(255) NOT NULL, 118 sort_order int(5) NULL, 119 visible int(1) DEFAULT '1' NULL, 120 PRIMARY KEY (configuration_group_id) 121 ); 122 123 DROP TABLE IF EXISTS counter; 124 CREATE TABLE counter ( 125 startdate char(8), 126 counter int(12) 127 ); 128 129 DROP TABLE IF EXISTS counter_history; 130 CREATE TABLE counter_history ( 131 month char(8), 132 counter int(12) 133 ); 134 135 DROP TABLE IF EXISTS countries; 136 CREATE TABLE countries ( 137 countries_id int NOT NULL auto_increment, 138 countries_name varchar(64) NOT NULL, 139 countries_iso_code_2 char(2) NOT NULL, 140 countries_iso_code_3 char(3) NOT NULL, 141 address_format_id int NOT NULL, 142 PRIMARY KEY (countries_id), 143 KEY IDX_COUNTRIES_NAME (countries_name) 144 ); 145 146 DROP TABLE IF EXISTS currencies; 147 CREATE TABLE currencies ( 148 currencies_id int NOT NULL auto_increment, 149 title varchar(32) NOT NULL, 150 code char(3) NOT NULL, 151 symbol_left varchar(12), 152 symbol_right varchar(12), 153 decimal_point char(1), 154 thousands_point char(1), 155 decimal_places char(1), 156 value float(13,8), 157 last_updated datetime NULL, 158 PRIMARY KEY (currencies_id) 159 ); 160 161 DROP TABLE IF EXISTS customers; 162 CREATE TABLE customers ( 163 customers_id int NOT NULL auto_increment, 164 customers_gender char(1) NOT NULL, 165 customers_firstname varchar(32) NOT NULL, 166 customers_lastname varchar(32) NOT NULL, 167 customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, 168 customers_email_address varchar(96) NOT NULL, 169 customers_default_address_id int, 170 customers_telephone varchar(32) NOT NULL, 171 customers_fax varchar(32), 172 customers_password varchar(40) NOT NULL, 173 customers_newsletter char(1), 174 PRIMARY KEY (customers_id) 175 ); 176 177 DROP TABLE IF EXISTS customers_basket; 178 CREATE TABLE customers_basket ( 179 customers_basket_id int NOT NULL auto_increment, 180 customers_id int NOT NULL, 181 products_id tinytext NOT NULL, 182 customers_basket_quantity int(2) NOT NULL, 183 final_price decimal(15,4), 184 customers_basket_date_added char(8), 185 PRIMARY KEY (customers_basket_id) 186 ); 187 188 DROP TABLE IF EXISTS customers_basket_attributes; 189 CREATE TABLE customers_basket_attributes ( 190 customers_basket_attributes_id int NOT NULL auto_increment, 191 customers_id int NOT NULL, 192 products_id tinytext NOT NULL, 193 products_options_id int NOT NULL, 194 products_options_value_id int NOT NULL, 195 PRIMARY KEY (customers_basket_attributes_id) 196 ); 197 198 DROP TABLE IF EXISTS customers_info; 199 CREATE TABLE customers_info ( 200 customers_info_id int NOT NULL, 201 customers_info_date_of_last_logon datetime, 202 customers_info_number_of_logons int(5), 203 customers_info_date_account_created datetime, 204 customers_info_date_account_last_modified datetime, 205 global_product_notifications int(1) DEFAULT '0', 206 PRIMARY KEY (customers_info_id) 207 ); 208 209 DROP TABLE IF EXISTS languages; 210 CREATE TABLE languages ( 211 languages_id int NOT NULL auto_increment, 212 name varchar(32) NOT NULL, 213 code char(2) NOT NULL, 214 image varchar(64), 215 directory varchar(32), 216 sort_order int(3), 217 PRIMARY KEY (languages_id), 218 KEY IDX_LANGUAGES_NAME (name) 219 ); 220 221 222 DROP TABLE IF EXISTS manufacturers; 223 CREATE TABLE manufacturers ( 224 manufacturers_id int NOT NULL auto_increment, 225 manufacturers_name varchar(32) NOT NULL, 226 manufacturers_image varchar(64), 227 date_added datetime NULL, 228 last_modified datetime NULL, 229 PRIMARY KEY (manufacturers_id), 230 KEY IDX_MANUFACTURERS_NAME (manufacturers_name) 231 ); 232 233 DROP TABLE IF EXISTS manufacturers_info; 234 CREATE TABLE manufacturers_info ( 235 manufacturers_id int NOT NULL, 236 languages_id int NOT NULL, 237 manufacturers_url varchar(255) NOT NULL, 238 url_clicked int(5) NOT NULL default '0', 239 date_last_click datetime NULL, 240 PRIMARY KEY (manufacturers_id, languages_id) 241 ); 242 243 DROP TABLE IF EXISTS newsletters; 244 CREATE TABLE newsletters ( 245 newsletters_id int NOT NULL auto_increment, 246 title varchar(255) NOT NULL, 247 content text NOT NULL, 248 module varchar(255) NOT NULL, 249 date_added datetime NOT NULL, 250 date_sent datetime, 251 status int(1), 252 locked int(1) DEFAULT '0', 253 PRIMARY KEY (newsletters_id) 254 ); 255 256 DROP TABLE IF EXISTS orders; 257 CREATE TABLE orders ( 258 orders_id int NOT NULL auto_increment, 259 customers_id int NOT NULL, 260 customers_name varchar(64) NOT NULL, 261 customers_company varchar(32), 262 customers_street_address varchar(64) NOT NULL, 263 customers_suburb varchar(32), 264 customers_city varchar(32) NOT NULL, 265 customers_postcode varchar(10) NOT NULL, 266 customers_state varchar(32), 267 customers_country varchar(32) NOT NULL, 268 customers_telephone varchar(32) NOT NULL, 269 customers_email_address varchar(96) NOT NULL, 270 customers_address_format_id int(5) NOT NULL, 271 delivery_name varchar(64) NOT NULL, 272 delivery_company varchar(32), 273 delivery_street_address varchar(64) NOT NULL, 274 delivery_suburb varchar(32), 275 delivery_city varchar(32) NOT NULL, 276 delivery_postcode varchar(10) NOT NULL, 277 delivery_state varchar(32), 278 delivery_country varchar(32) NOT NULL, 279 delivery_address_format_id int(5) NOT NULL, 280 billing_name varchar(64) NOT NULL, 281 billing_company varchar(32), 282 billing_street_address varchar(64) NOT NULL, 283 billing_suburb varchar(32), 284 billing_city varchar(32) NOT NULL, 285 billing_postcode varchar(10) NOT NULL, 286 billing_state varchar(32), 287 billing_country varchar(32) NOT NULL, 288 billing_address_format_id int(5) NOT NULL, 289 payment_method varchar(32) NOT NULL, 290 cc_type varchar(20), 291 cc_owner varchar(64), 292 cc_number varchar(32), 293 cc_expires varchar(4), 294 last_modified datetime, 295 date_purchased datetime, 296 orders_status int(5) NOT NULL, 297 orders_date_finished datetime, 298 currency char(3), 299 currency_value decimal(14,6), 300 PRIMARY KEY (orders_id) 301 ); 302 303 DROP TABLE IF EXISTS orders_products; 304 CREATE TABLE orders_products ( 305 orders_products_id int NOT NULL auto_increment, 306 orders_id int NOT NULL, 307 products_id int NOT NULL, 308 products_model varchar(12), 309 products_name varchar(64) NOT NULL, 310 products_price decimal(15,4) NOT NULL, 311 final_price decimal(15,4) NOT NULL, 312 products_tax decimal(7,4) NOT NULL, 313 products_quantity int(2) NOT NULL, 314 PRIMARY KEY (orders_products_id) 315 ); 316 317 DROP TABLE IF EXISTS orders_status; 318 CREATE TABLE orders_status ( 319 orders_status_id int DEFAULT '0' NOT NULL, 320 language_id int DEFAULT '1' NOT NULL, 321 orders_status_name varchar(32) NOT NULL, 322 PRIMARY KEY (orders_status_id, language_id), 323 KEY idx_orders_status_name (orders_status_name) 324 ); 325 326 DROP TABLE IF EXISTS orders_status_history; 327 CREATE TABLE orders_status_history ( 328 orders_status_history_id int NOT NULL auto_increment, 329 orders_id int NOT NULL, 330 orders_status_id int(5) NOT NULL, 331 date_added datetime NOT NULL, 332 customer_notified int(1) DEFAULT '0', 333 comments text, 334 PRIMARY KEY (orders_status_history_id) 335 ); 336 337 DROP TABLE IF EXISTS orders_products_attributes; 338 CREATE TABLE orders_products_attributes ( 339 orders_products_attributes_id int NOT NULL auto_increment, 340 orders_id int NOT NULL, 341 orders_products_id int NOT NULL, 342 products_options varchar(32) NOT NULL, 343 products_options_values varchar(32) NOT NULL, 344 options_values_price decimal(15,4) NOT NULL, 345 price_prefix char(1) NOT NULL, 346 PRIMARY KEY (orders_products_attributes_id) 347 ); 348 349 DROP TABLE IF EXISTS orders_products_download; 350 CREATE TABLE orders_products_download ( 351 orders_products_download_id int NOT NULL auto_increment, 352 orders_id int NOT NULL default '0', 353 orders_products_id int NOT NULL default '0', 354 orders_products_filename varchar(255) NOT NULL default '', 355 download_maxdays int(2) NOT NULL default '0', 356 download_count int(2) NOT NULL default '0', 357 PRIMARY KEY (orders_products_download_id) 358 ); 359 360 DROP TABLE IF EXISTS orders_total; 361 CREATE TABLE orders_total ( 362 orders_total_id int unsigned NOT NULL auto_increment, 363 orders_id int NOT NULL, 364 title varchar(255) NOT NULL, 365 text varchar(255) NOT NULL, 366 value decimal(15,4) NOT NULL, 367 class varchar(32) NOT NULL, 368 sort_order int NOT NULL, 369 PRIMARY KEY (orders_total_id), 370 KEY idx_orders_total_orders_id (orders_id) 371 ); 372 373 DROP TABLE IF EXISTS products; 374 CREATE TABLE products ( 375 products_id int NOT NULL auto_increment, 376 products_quantity int(4) NOT NULL, 377 products_model varchar(12), 378 products_image varchar(64), 379 products_price decimal(15,4) NOT NULL, 380 products_date_added datetime NOT NULL, 381 products_last_modified datetime, 382 products_date_available datetime, 383 products_weight decimal(5,2) NOT NULL, 384 products_status tinyint(1) NOT NULL, 385 products_tax_class_id int NOT NULL, 386 manufacturers_id int NULL, 387 products_ordered int NOT NULL default '0', 388 PRIMARY KEY (products_id), 389 KEY idx_products_date_added (products_date_added) 390 ); 391 392 DROP TABLE IF EXISTS products_attributes; 393 CREATE TABLE products_attributes ( 394 products_attributes_id int NOT NULL auto_increment, 395 products_id int NOT NULL, 396 options_id int NOT NULL, 397 options_values_id int NOT NULL, 398 options_values_price decimal(15,4) NOT NULL, 399 price_prefix char(1) NOT NULL, 400 PRIMARY KEY (products_attributes_id) 401 ); 402 403 DROP TABLE IF EXISTS products_attributes_download; 404 CREATE TABLE products_attributes_download ( 405 products_attributes_id int NOT NULL, 406 products_attributes_filename varchar(255) NOT NULL default '', 407 products_attributes_maxdays int(2) default '0', 408 products_attributes_maxcount int(2) default '0', 409 PRIMARY KEY (products_attributes_id) 410 ); 411 412 DROP TABLE IF EXISTS products_description; 413 CREATE TABLE products_description ( 414 products_id int NOT NULL auto_increment, 415 language_id int NOT NULL default '1', 416 products_name varchar(64) NOT NULL default '', 417 products_description text, 418 products_url varchar(255) default NULL, 419 products_viewed int(5) default '0', 420 PRIMARY KEY (products_id,language_id), 421 KEY products_name (products_name) 422 ); 423 424 DROP TABLE IF EXISTS products_notifications; 425 CREATE TABLE products_notifications ( 426 products_id int NOT NULL, 427 customers_id int NOT NULL, 428 date_added datetime NOT NULL, 429 PRIMARY KEY (products_id, customers_id) 430 ); 431 432 DROP TABLE IF EXISTS products_options; 433 CREATE TABLE products_options ( 434 products_options_id int NOT NULL default '0', 435 language_id int NOT NULL default '1', 436 products_options_name varchar(32) NOT NULL default '', 437 PRIMARY KEY (products_options_id,language_id) 438 ); 439 440 DROP TABLE IF EXISTS products_options_values; 441 CREATE TABLE products_options_values ( 442 products_options_values_id int NOT NULL default '0', 443 language_id int NOT NULL default '1', 444 products_options_values_name varchar(64) NOT NULL default '', 445 PRIMARY KEY (products_options_values_id,language_id) 446 ); 447 448 DROP TABLE IF EXISTS products_options_values_to_products_options; 449 CREATE TABLE products_options_values_to_products_options ( 450 products_options_values_to_products_options_id int NOT NULL auto_increment, 451 products_options_id int NOT NULL, 452 products_options_values_id int NOT NULL, 453 PRIMARY KEY (products_options_values_to_products_options_id) 454 ); 455 456 DROP TABLE IF EXISTS products_to_categories; 457 CREATE TABLE products_to_categories ( 458 products_id int NOT NULL, 459 categories_id int NOT NULL, 460 PRIMARY KEY (products_id,categories_id) 461 ); 462 463 DROP TABLE IF EXISTS reviews; 464 CREATE TABLE reviews ( 465 reviews_id int NOT NULL auto_increment, 466 products_id int NOT NULL, 467 customers_id int, 468 customers_name varchar(64) NOT NULL, 469 reviews_rating int(1), 470 date_added datetime, 471 last_modified datetime, 472 reviews_read int(5) NOT NULL default '0', 473 PRIMARY KEY (reviews_id) 474 ); 475 476 DROP TABLE IF EXISTS reviews_description; 477 CREATE TABLE reviews_description ( 478 reviews_id int NOT NULL, 479 languages_id int NOT NULL, 480 reviews_text text NOT NULL, 481 PRIMARY KEY (reviews_id, languages_id) 482 ); 483 484 DROP TABLE IF EXISTS sessions; 485 CREATE TABLE sessions ( 486 sesskey varchar(32) NOT NULL, 487 expiry int(11) unsigned NOT NULL, 488 value text NOT NULL, 489 PRIMARY KEY (sesskey) 490 ); 491 492 DROP TABLE IF EXISTS specials; 493 CREATE TABLE specials ( 494 specials_id int NOT NULL auto_increment, 495 products_id int NOT NULL, 496 specials_new_products_price decimal(15,4) NOT NULL, 497 specials_date_added datetime, 498 specials_last_modified datetime, 499 expires_date datetime, 500 date_status_change datetime, 501 status int(1) NOT NULL DEFAULT '1', 502 PRIMARY KEY (specials_id) 503 ); 504 505 DROP TABLE IF EXISTS tax_class; 506 CREATE TABLE tax_class ( 507 tax_class_id int NOT NULL auto_increment, 508 tax_class_title varchar(32) NOT NULL, 509 tax_class_description varchar(255) NOT NULL, 510 last_modified datetime NULL, 511 date_added datetime NOT NULL, 512 PRIMARY KEY (tax_class_id) 513 ); 514 515 DROP TABLE IF EXISTS tax_rates; 516 CREATE TABLE tax_rates ( 517 tax_rates_id int NOT NULL auto_increment, 518 tax_zone_id int NOT NULL, 519 tax_class_id int NOT NULL, 520 tax_priority int(5) DEFAULT 1, 521 tax_rate decimal(7,4) NOT NULL, 522 tax_description varchar(255) NOT NULL, 523 last_modified datetime NULL, 524 date_added datetime NOT NULL, 525 PRIMARY KEY (tax_rates_id) 526 ); 527 528 DROP TABLE IF EXISTS geo_zones; 529 CREATE TABLE geo_zones ( 530 geo_zone_id int NOT NULL auto_increment, 531 geo_zone_name varchar(32) NOT NULL, 532 geo_zone_description varchar(255) NOT NULL, 533 last_modified datetime NULL, 534 date_added datetime NOT NULL, 535 PRIMARY KEY (geo_zone_id) 536 ); 537 538 DROP TABLE IF EXISTS whos_online; 539 CREATE TABLE whos_online ( 540 customer_id int, 541 full_name varchar(64) NOT NULL, 542 session_id varchar(128) NOT NULL, 543 ip_address varchar(15) NOT NULL, 544 time_entry varchar(14) NOT NULL, 545 time_last_click varchar(14) NOT NULL, 546 last_page_url varchar(255) NOT NULL 547 ); 548 549 DROP TABLE IF EXISTS zones; 550 CREATE TABLE zones ( 551 zone_id int NOT NULL auto_increment, 552 zone_country_id int NOT NULL, 553 zone_code varchar(32) NOT NULL, 554 zone_name varchar(32) NOT NULL, 555 PRIMARY KEY (zone_id) 556 ); 557 558 DROP TABLE IF EXISTS zones_to_geo_zones; 559 CREATE TABLE zones_to_geo_zones ( 560 association_id int NOT NULL auto_increment, 561 zone_country_id int NOT NULL, 562 zone_id int NULL, 563 geo_zone_id int NULL, 564 last_modified datetime NULL, 565 date_added datetime NOT NULL, 566 PRIMARY KEY (association_id) 567 ); 568 569 570 # data 571 572 INSERT INTO address_book VALUES ( '1', '1', 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', '223', '12'); 573 574 # 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - Germany 575 INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'); 576 INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'); 577 INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'); 578 INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'); 579 INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); 580 581 INSERT INTO banners VALUES (1, 'osCommerce', 'http://www.oscommerce.com', 'banners/oscommerce.gif', '468x50', '', 0, null, null, now(), null, 1); 582 583 INSERT INTO categories VALUES ('1', 'category_hardware.gif', '0', '1', now(), null); 584 INSERT INTO categories VALUES ('2', 'category_software.gif', '0', '2', now(), null); 585 INSERT INTO categories VALUES ('3', 'category_dvd_movies.gif', '0', '3', now(), null); 586 INSERT INTO categories VALUES ('4', 'subcategory_graphic_cards.gif', '1', '0', now(), null); 587 INSERT INTO categories VALUES ('5', 'subcategory_printers.gif', '1', '0', now(), null); 588 INSERT INTO categories VALUES ('6', 'subcategory_monitors.gif', '1', '0', now(), null); 589 INSERT INTO categories VALUES ('7', 'subcategory_speakers.gif', '1', '0', now(), null); 590 INSERT INTO categories VALUES ('8', 'subcategory_keyboards.gif', '1', '0', now(), null); 591 INSERT INTO categories VALUES ('9', 'subcategory_mice.gif', '1', '0', now(), null); 592 INSERT INTO categories VALUES ('10', 'subcategory_action.gif', '3', '0', now(), null); 593 INSERT INTO categories VALUES ('11', 'subcategory_science_fiction.gif', '3', '0', now(), null); 594 INSERT INTO categories VALUES ('12', 'subcategory_comedy.gif', '3', '0', now(), null); 595 INSERT INTO categories VALUES ('13', 'subcategory_cartoons.gif', '3', '0', now(), null); 596 INSERT INTO categories VALUES ('14', 'subcategory_thriller.gif', '3', '0', now(), null); 597 INSERT INTO categories VALUES ('15', 'subcategory_drama.gif', '3', '0', now(), null); 598 INSERT INTO categories VALUES ('16', 'subcategory_memory.gif', '1', '0', now(), null); 599 INSERT INTO categories VALUES ('17', 'subcategory_cdrom_drives.gif', '1', '0', now(), null); 600 INSERT INTO categories VALUES ('18', 'subcategory_simulation.gif', '2', '0', now(), null); 601 INSERT INTO categories VALUES ('19', 'subcategory_action_games.gif', '2', '0', now(), null); 602 INSERT INTO categories VALUES ('20', 'subcategory_strategy.gif', '2', '0', now(), null); 603 604 INSERT INTO categories_description VALUES ( '1', '1', 'Hardware'); 605 INSERT INTO categories_description VALUES ( '2', '1', 'Software'); 606 INSERT INTO categories_description VALUES ( '3', '1', 'DVD Movies'); 607 INSERT INTO categories_description VALUES ( '4', '1', 'Graphics Cards'); 608 INSERT INTO categories_description VALUES ( '5', '1', 'Printers'); 609 INSERT INTO categories_description VALUES ( '6', '1', 'Monitors'); 610 INSERT INTO categories_description VALUES ( '7', '1', 'Speakers'); 611 INSERT INTO categories_description VALUES ( '8', '1', 'Keyboards'); 612 INSERT INTO categories_description VALUES ( '9', '1', 'Mice'); 613 INSERT INTO categories_description VALUES ( '10', '1', 'Action'); 614 INSERT INTO categories_description VALUES ( '11', '1', 'Science Fiction'); 615 INSERT INTO categories_description VALUES ( '12', '1', 'Comedy'); 616 INSERT INTO categories_description VALUES ( '13', '1', 'Cartoons'); 617 INSERT INTO categories_description VALUES ( '14', '1', 'Thriller'); 618 INSERT INTO categories_description VALUES ( '15', '1', 'Drama'); 619 INSERT INTO categories_description VALUES ( '16', '1', 'Memory'); 620 INSERT INTO categories_description VALUES ( '17', '1', 'CDROM Drives'); 621 INSERT INTO categories_description VALUES ( '18', '1', 'Simulation'); 622 INSERT INTO categories_description VALUES ( '19', '1', 'Action'); 623 INSERT INTO categories_description VALUES ( '20', '1', 'Strategy'); 624 INSERT INTO categories_description VALUES ( '1', '2', 'Hardware'); 625 INSERT INTO categories_description VALUES ( '2', '2', 'Software'); 626 INSERT INTO categories_description VALUES ( '3', '2', 'DVD Filme'); 627 INSERT INTO categories_description VALUES ( '4', '2', 'Grafikkarten'); 628 INSERT INTO categories_description VALUES ( '5', '2', 'Drucker'); 629 INSERT INTO categories_description VALUES ( '6', '2', 'Bildschirme'); 630 INSERT INTO categories_description VALUES ( '7', '2', 'Lautsprecher'); 631 INSERT INTO categories_description VALUES ( '8', '2', 'Tastaturen'); 632 INSERT INTO categories_description VALUES ( '9', '2', 'Mäuse'); 633 INSERT INTO categories_description VALUES ( '10', '2', 'Action'); 634 INSERT INTO categories_description VALUES ( '11', '2', 'Science Fiction'); 635 INSERT INTO categories_description VALUES ( '12', '2', 'Komödie'); 636 INSERT INTO categories_description VALUES ( '13', '2', 'Zeichentrick'); 637 INSERT INTO categories_description VALUES ( '14', '2', 'Thriller'); 638 INSERT INTO categories_description VALUES ( '15', '2', 'Drama'); 639 INSERT INTO categories_description VALUES ( '16', '2', 'Speicher'); 640 INSERT INTO categories_description VALUES ( '17', '2', 'CDROM Laufwerke'); 641 INSERT INTO categories_description VALUES ( '18', '2', 'Simulation'); 642 INSERT INTO categories_description VALUES ( '19', '2', 'Action'); 643 INSERT INTO categories_description VALUES ( '20', '2', 'Strategie'); 644 INSERT INTO categories_description VALUES ( '1', '3', 'Hardware'); 645 INSERT INTO categories_description VALUES ( '2', '3', 'Software'); 646 INSERT INTO categories_description VALUES ( '3', '3', 'Peliculas DVD'); 647 INSERT INTO categories_description VALUES ( '4', '3', 'Tarjetas Graficas'); 648 INSERT INTO categories_description VALUES ( '5', '3', 'Impresoras'); 649 INSERT INTO categories_description VALUES ( '6', '3', 'Monitores'); 650 INSERT INTO categories_description VALUES ( '7', '3', 'Altavoces'); 651 INSERT INTO categories_description VALUES ( '8', '3', 'Teclados'); 652 INSERT INTO categories_description VALUES ( '9', '3', 'Ratones'); 653 INSERT INTO categories_description VALUES ( '10', '3', 'Accion'); 654 INSERT INTO categories_description VALUES ( '11', '3', 'Ciencia Ficcion'); 655 INSERT INTO categories_description VALUES ( '12', '3', 'Comedia'); 656 INSERT INTO categories_description VALUES ( '13', '3', 'Dibujos Animados'); 657 INSERT INTO categories_description VALUES ( '14', '3', 'Suspense'); 658 INSERT INTO categories_description VALUES ( '15', '3', 'Drama'); 659 INSERT INTO categories_description VALUES ( '16', '3', 'Memoria'); 660 INSERT INTO categories_description VALUES ( '17', '3', 'Unidades CDROM'); 661 INSERT INTO categories_description VALUES ( '18', '3', 'Simulacion'); 662 INSERT INTO categories_description VALUES ( '19', '3', 'Accion'); 663 INSERT INTO categories_description VALUES ( '20', '3', 'Estrategia'); 664 665 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Name', 'STORE_NAME', 'osCommerce', 'The name of my store', '1', '1', now()); 666 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Owner', 'STORE_OWNER', 'Harald Ponce de Leon', 'The name of my store owner', '1', '2', now()); 667 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'root@localhost', 'The e-mail address of my store owner', '1', '3', now()); 668 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail From', 'EMAIL_FROM', 'osCommerce <root@localhost>', 'The e-mail address used in (sent) e-mails', '1', '4', now()); 669 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Country', 'STORE_COUNTRY', '223', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', '1', '6', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(', now()); 670 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Zone', 'STORE_ZONE', '18', 'The zone my store is located in', '1', '7', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list(', now()); 671 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', 'tep_cfg_select_option(array(\'asc\', \'desc\'), ', now()); 672 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', 'tep_cfg_select_option(array(\'products_name\', \'date_expected\'), ', now()); 673 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\'s currency when it is changed', '1', '10', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 674 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', '1', '11', now()); 675 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', '1', '12', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 676 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', '1', '14', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 677 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', '1', '15', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 678 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', '1', '17', 'tep_cfg_select_option(array(\'and\', \'or\'), ', now()); 679 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Store Address and Phone', 'STORE_NAME_ADDRESS', 'Store Name\nAddress\nCountry\nPhone', 'This is the Store Name, Address and Phone used on printable documents and displayed online', '1', '18', 'tep_cfg_textarea(', now()); 680 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Show Category Counts', 'SHOW_COUNTS', 'true', 'Count recursively how many products are in each category', '1', '19', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 681 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', '1', '20', now()); 682 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'Display prices with tax included (true) or add the tax at the end (false)', '1', '21', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 683 684 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', '2', '1', now()); 685 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', '2', '2', now()); 686 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', '2', '3', now()); 687 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', '2', '4', now()); 688 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', '2', '5', now()); 689 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', '2', '6', now()); 690 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', '2', '7', now()); 691 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', '2', '8', now()); 692 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', '2', '9', now()); 693 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', '2', '10', now()); 694 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', '2', '11', now()); 695 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', '2', '12', now()); 696 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', '2', '13', now()); 697 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', '2', '14', now()); 698 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', '2', '15', now()); 699 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \'This Customer Also Purchased\' box', '2', '16', now()); 700 701 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', '3', '1', now()); 702 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', now()); 703 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', '3', '3', now()); 704 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', now()); 705 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', now()); 706 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', now()); 707 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now()); 708 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', now()); 709 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', '3', '8', now()); 710 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', now()); 711 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', now()); 712 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', now()); 713 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', now()); 714 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', now()); 715 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', '3', '14', now()); 716 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', '3', '15', now()); 717 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the \'This Customer Also Purchased\' box', '3', '16', now()); 718 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', '3', '17', now()); 719 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', '3', '18', now()); 720 721 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', '4', '1', now()); 722 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', '4', '2', now()); 723 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', '4', '3', now()); 724 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', '4', '4', now()); 725 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', '4', '5', now()); 726 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', '4', '6', now()); 727 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', '4', '7', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 728 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', '4', '8', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 729 730 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Gender', 'ACCOUNT_GENDER', 'true', 'Display gender in the customers account', '5', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 731 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Date of Birth', 'ACCOUNT_DOB', 'true', 'Display date of birth in the customers account', '5', '2', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 732 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Company', 'ACCOUNT_COMPANY', 'true', 'Display company in the customers account', '5', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 733 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Suburb', 'ACCOUNT_SUBURB', 'true', 'Display suburb in the customers account', '5', '4', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 734 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', '5', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 735 736 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'cc.php;cod.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', '6', '0', now()); 737 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', '6', '0', now()); 738 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Modules', 'MODULE_SHIPPING_INSTALLED', 'flat.php', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', '6', '0', now()); 739 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Cash On Delivery Module', 'MODULE_PAYMENT_COD_STATUS', 'True', 'Do you want to accept Cash On Delevery payments?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 740 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Payment Zone', 'MODULE_PAYMENT_COD_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now()); 741 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort order of display.', 'MODULE_PAYMENT_COD_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now()); 742 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) VALUES ('Set Order Status', 'MODULE_PAYMENT_COD_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now()); 743 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Credit Card Module', 'MODULE_PAYMENT_CC_STATUS', 'True', 'Do you want to accept credit card payments?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 744 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Split Credit Card E-Mail Address', 'MODULE_PAYMENT_CC_EMAIL', '', 'If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)', '6', '0', now()); 745 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort order of display.', 'MODULE_PAYMENT_CC_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0' , now()); 746 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Payment Zone', 'MODULE_PAYMENT_CC_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now()); 747 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) VALUES ('Set Order Status', 'MODULE_PAYMENT_CC_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now()); 748 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Flat Shipping', 'MODULE_SHIPPING_FLAT_STATUS', 'True', 'Do you want to offer flat rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 749 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Shipping Cost', 'MODULE_SHIPPING_FLAT_COST', '5.00', 'The shipping cost for all orders using this shipping method.', '6', '0', now()); 750 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Tax Class', 'MODULE_SHIPPING_FLAT_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now()); 751 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Shipping Zone', 'MODULE_SHIPPING_FLAT_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now()); 752 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Order', 'MODULE_SHIPPING_FLAT_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now()); 753 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', '6', '0', now()); 754 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', '6', '0', now()); 755 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', '6', '0', now()); 756 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 757 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '2', 'Sort order of display.', '6', '2', now()); 758 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', '6', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 759 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) VALUES ('Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', '6', '4', 'currencies->format', now()); 760 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', '6', '5', 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ', now()); 761 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 762 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', '6', '2', now()); 763 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 764 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '3', 'Sort order of display.', '6', '2', now()); 765 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 766 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', '6', '2', now()); 767 768 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', '7', '1', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(', now()); 769 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', '7', '2', now()); 770 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', '7', '3', now()); 771 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', '7', '4', now()); 772 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', '7', '5', now()); 773 774 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', '8', '1', now()); 775 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', '8', '2', now()); 776 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', '8', '3', now()); 777 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', '8', '4', now()); 778 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', '8', '5', now()); 779 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', '8', '6', now()); 780 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', '8', '7', now()); 781 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column?', '8', '8', now()); 782 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', '8', '9', now()); 783 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', '8', '10', now()); 784 785 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', '9', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 786 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', '9', '2', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 787 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', '9', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 788 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', '9', '4', now()); 789 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', '9', '5', now()); 790 791 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', '10', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 792 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', '10', '2', now()); 793 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', '10', '3', now()); 794 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'true', 'Display the page parse time (store page parse time must be enabled)', '10', '4', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 795 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', '10', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 796 797 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Use Cache', 'USE_CACHE', 'false', 'Use caching features', '11', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 798 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', '11', '2', now()); 799 800 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', '12', '1', 'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),', now()); 801 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', '12', '2', 'tep_cfg_select_option(array(\'LF\', \'CRLF\'),', now()); 802 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', '12', '3', 'tep_cfg_select_option(array(\'true\', \'false\'),', now()); 803 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', '12', '4', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 804 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', '12', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 805 806 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable download', 'DOWNLOAD_ENABLED', 'false', 'Enable the products download functions.', '13', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 807 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'false', 'Use browser redirection for download. Disable on non-Unix systems.', '13', '2', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 808 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expiry delay (days)' ,'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', '13', '3', '', now()); 809 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Maximum number of downloads' ,'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', '13', '4', '', now()); 810 811 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', '14', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); 812 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', '14', '2', now()); 813 814 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', '15', '1', now()); 815 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'False', 'Force the use of sessions when cookies are only enabled.', '15', '2', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 816 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', '15', '3', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 817 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', '15', '4', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 818 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', '15', '5', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 819 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', '15', '6', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 820 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', '15', '7', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now()); 821 822 INSERT INTO configuration_group VALUES ('1', 'My Store', 'General information about my store', '1', '1'); 823 INSERT INTO configuration_group VALUES ('2', 'Minimum Values', 'The minimum values for functions / data', '2', '1'); 824 INSERT INTO configuration_group VALUES ('3', 'Maximum Values', 'The maximum values for functions / data', '3', '1'); 825 INSERT INTO configuration_group VALUES ('4', 'Images', 'Image parameters', '4', '1'); 826 INSERT INTO configuration_group VALUES ('5', 'Customer Details', 'Customer account configuration', '5', '1'); 827 INSERT INTO configuration_group VALUES ('6', 'Module Options', 'Hidden from configuration', '6', '0'); 828 INSERT INTO configuration_group VALUES ('7', 'Shipping/Packaging', 'Shipping options available at my store', '7', '1'); 829 INSERT INTO configuration_group VALUES ('8', 'Product Listing', 'Product Listing configuration options', '8', '1'); 830 INSERT INTO configuration_group VALUES ('9', 'Stock', 'Stock configuration options', '9', '1'); 831 INSERT INTO configuration_group VALUES ('10', 'Logging', 'Logging configuration options', '10', '1'); 832 INSERT INTO configuration_group VALUES ('11', 'Cache', 'Caching configuration options', '11', '1'); 833 INSERT INTO configuration_group VALUES ('12', 'E-Mail Options', 'General setting for E-Mail transport and HTML E-Mails', '12', '1'); 834 INSERT INTO configuration_group VALUES ('13', 'Download', 'Downloadable products options', '13', '1'); 835 INSERT INTO configuration_group VALUES ('14', 'GZip Compression', 'GZip compression options', '14', '1'); 836 INSERT INTO configuration_group VALUES ('15', 'Sessions', 'Session options', '15', '1'); 837 838 INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1'); 839 INSERT INTO countries VALUES (2,'Albania','AL','ALB','1'); 840 INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1'); 841 INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1'); 842 INSERT INTO countries VALUES (5,'Andorra','AD','AND','1'); 843 INSERT INTO countries VALUES (6,'Angola','AO','AGO','1'); 844 INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1'); 845 INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1'); 846 INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1'); 847 INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1'); 848 INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1'); 849 INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1'); 850 INSERT INTO countries VALUES (13,'Australia','AU','AUS','1'); 851 INSERT INTO countries VALUES (14,'Austria','AT','AUT','5'); 852 INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1'); 853 INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1'); 854 INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1'); 855 INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1'); 856 INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1'); 857 INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1'); 858 INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1'); 859 INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1'); 860 INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1'); 861 INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1'); 862 INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1'); 863 INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1'); 864 INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1'); 865 INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1'); 866 INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1'); 867 INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1'); 868 INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1'); 869 INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1'); 870 INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1'); 871 INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1'); 872 INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1'); 873 INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1'); 874 INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1'); 875 INSERT INTO countries VALUES (38,'Canada','CA','CAN','1'); 876 INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1'); 877 INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1'); 878 INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1'); 879 INSERT INTO countries VALUES (42,'Chad','TD','TCD','1'); 880 INSERT INTO countries VALUES (43,'Chile','CL','CHL','1'); 881 INSERT INTO countries VALUES (44,'China','CN','CHN','1'); 882 INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1'); 883 INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1'); 884 INSERT INTO countries VALUES (47,'Colombia','CO','COL','1'); 885 INSERT INTO countries VALUES (48,'Comoros','KM','COM','1'); 886 INSERT INTO countries VALUES (49,'Congo','CG','COG','1'); 887 INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1'); 888 INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1'); 889 INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV','1'); 890 INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1'); 891 INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1'); 892 INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1'); 893 INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1'); 894 INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1'); 895 INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1'); 896 INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1'); 897 INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1'); 898 INSERT INTO countries VALUES (61,'East Timor','TP','TMP','1'); 899 INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1'); 900 INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1'); 901 INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1'); 902 INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1'); 903 INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1'); 904 INSERT INTO countries VALUES (67,'Estonia','EE','EST','1'); 905 INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1'); 906 INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1'); 907 INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1'); 908 INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1'); 909 INSERT INTO countries VALUES (72,'Finland','FI','FIN','1'); 910 INSERT INTO countries VALUES (73,'France','FR','FRA','1'); 911 INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX','1'); 912 INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1'); 913 INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1'); 914 INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1'); 915 INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1'); 916 INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1'); 917 INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1'); 918 INSERT INTO countries VALUES (81,'Germany','DE','DEU','5'); 919 INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1'); 920 INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1'); 921 INSERT INTO countries VALUES (84,'Greece','GR','GRC','1'); 922 INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1'); 923 INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1'); 924 INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1'); 925 INSERT INTO countries VALUES (88,'Guam','GU','GUM','1'); 926 INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1'); 927 INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1'); 928 INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1'); 929 INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1'); 930 INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1'); 931 INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1'); 932 INSERT INTO countries VALUES (95,'Honduras','HN','HND','1'); 933 INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1'); 934 INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1'); 935 INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1'); 936 INSERT INTO countries VALUES (99,'India','IN','IND','1'); 937 INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1'); 938 INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1'); 939 INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1'); 940 INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1'); 941 INSERT INTO countries VALUES (104,'Israel','IL','ISR','1'); 942 INSERT INTO countries VALUES (105,'Italy','IT','ITA','1'); 943 INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1'); 944 INSERT INTO countries VALUES (107,'Japan','JP','JPN','1'); 945 INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1'); 946 INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1'); 947 INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1'); 948 INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1'); 949 INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1'); 950 INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1'); 951 INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1'); 952 INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1'); 953 INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1'); 954 INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1'); 955 INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1'); 956 INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1'); 957 INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1'); 958 INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1'); 959 INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1'); 960 INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1'); 961 INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1'); 962 INSERT INTO countries VALUES (125,'Macau','MO','MAC','1'); 963 INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1'); 964 INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1'); 965 INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1'); 966 INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1'); 967 INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1'); 968 INSERT INTO countries VALUES (131,'Mali','ML','MLI','1'); 969 INSERT INTO countries VALUES (132,'Malta','MT','MLT','1'); 970 INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1'); 971 INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1'); 972 INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1'); 973 INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1'); 974 INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1'); 975 INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1'); 976 INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1'); 977 INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA','1'); 978 INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1'); 979 INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1'); 980 INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1'); 981 INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1'); 982 INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1'); 983 INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1'); 984 INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1'); 985 INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1'); 986 INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1'); 987 INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1'); 988 INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1'); 989 INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1'); 990 INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1'); 991 INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1'); 992 INSERT INTO countries VALUES (155,'Niger','NE','NER','1'); 993 INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1'); 994 INSERT INTO countries VALUES (157,'Niue','NU','NIU','1'); 995 INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1'); 996 INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1'); 997 INSERT INTO countries VALUES (160,'Norway','NO','NOR','1'); 998 INSERT INTO countries VALUES (161,'Oman','OM','OMN','1'); 999 INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1'); 1000 INSERT INTO countries VALUES (163,'Palau','PW','PLW','1'); 1001 INSERT INTO countries VALUES (164,'Panama','PA','PAN','1'); 1002 INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1'); 1003 INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1'); 1004 INSERT INTO countries VALUES (167,'Peru','PE','PER','1'); 1005 INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1'); 1006 INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1'); 1007 INSERT INTO countries VALUES (170,'Poland','PL','POL','1'); 1008 INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1'); 1009 INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1'); 1010 INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1'); 1011 INSERT INTO countries VALUES (174,'Reunion','RE','REU','1'); 1012 INSERT INTO countries VALUES (175,'Romania','RO','ROM','1'); 1013 INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1'); 1014 INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1'); 1015 INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1'); 1016 INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1'); 1017 INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1'); 1018 INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1'); 1019 INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1'); 1020 INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1'); 1021 INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1'); 1022 INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1'); 1023 INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1'); 1024 INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1'); 1025 INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4'); 1026 INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1'); 1027 INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1'); 1028 INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1'); 1029 INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1'); 1030 INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF','1'); 1031 INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1'); 1032 INSERT INTO countries VALUES (195,'Spain','ES','ESP','3'); 1033 INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1'); 1034 INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1'); 1035 INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1'); 1036 INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1'); 1037 INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1'); 1038 INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1'); 1039 INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1'); 1040 INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1'); 1041 INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1'); 1042 INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1'); 1043 INSERT INTO countries VALUES (206,'Taiwan','TW','TWN','1'); 1044 INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1'); 1045 INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1'); 1046 INSERT INTO countries VALUES (209,'Thailand','TH','THA','1'); 1047 INSERT INTO countries VALUES (210,'Togo','TG','TGO','1'); 1048 INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1'); 1049 INSERT INTO countries VALUES (212,'Tonga','TO','TON','1'); 1050 INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1'); 1051 INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1'); 1052 INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1'); 1053 INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1'); 1054 INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1'); 1055 INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1'); 1056 INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1'); 1057 INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1'); 1058 INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1'); 1059 INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','1'); 1060 INSERT INTO countries VALUES (223,'United States','US','USA', '2'); 1061 INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1'); 1062 INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1'); 1063 INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1'); 1064 INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1'); 1065 INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1'); 1066 INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1'); 1067 INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1'); 1068 INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1'); 1069 INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1'); 1070 INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1'); 1071 INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1'); 1072 INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1'); 1073 INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG','1'); 1074 INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR','1'); 1075 INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1'); 1076 INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1'); 1077 1078 INSERT INTO currencies VALUES (1,'US Dollar','USD','$','','.',',','2','1.0000', now()); 1079 INSERT INTO currencies VALUES (2,'Euro','EUR','','EUR','.',',','2','1.1036', now()); 1080 1081 INSERT INTO customers VALUES ( '1', 'm', 'John', 'doe', '2001-01-01 00:00:00', 'root@localhost', '1', '12345', '', 'd95e8fa7f20a009372eb3477473fcd34:1c', '0'); 1082 1083 INSERT INTO customers_info VALUES('1', null, '0', now(), null, '0'); 1084 1085 INSERT INTO languages VALUES (1,'English','en','icon.gif','english',1); 1086 INSERT INTO languages VALUES (2,'Deutsch','de','icon.gif','german',2); 1087 INSERT INTO languages VALUES (3,'Español','es','icon.gif','espanol',3); 1088 1089 INSERT INTO manufacturers VALUES (1,'Matrox','manufacturer_matrox.gif', now(), null); 1090 INSERT INTO manufacturers VALUES (2,'Microsoft','manufacturer_microsoft.gif', now(), null); 1091 INSERT INTO manufacturers VALUES (3,'Warner','manufacturer_warner.gif', now(), null); 1092 INSERT INTO manufacturers VALUES (4,'Fox','manufacturer_fox.gif', now(), null); 1093 INSERT INTO manufacturers VALUES (5,'Logitech','manufacturer_logitech.gif', now(), null); 1094 INSERT INTO manufacturers VALUES (6,'Canon','manufacturer_canon.gif', now(), null); 1095 INSERT INTO manufacturers VALUES (7,'Sierra','manufacturer_sierra.gif', now(), null); 1096 INSERT INTO manufacturers VALUES (8,'GT Interactive','manufacturer_gt_interactive.gif', now(), null); 1097 INSERT INTO manufacturers VALUES (9,'Hewlett Packard','manufacturer_hewlett_packard.gif', now(), null); 1098 1099 INSERT INTO manufacturers_info VALUES (1, 1, 'http://www.matrox.com', 0, null); 1100 INSERT INTO manufacturers_info VALUES (1, 2, 'http://www.matrox.de', 0, null); 1101 INSERT INTO manufacturers_info VALUES (1, 3, 'http://www.matrox.com', 0, null); 1102 INSERT INTO manufacturers_info VALUES (2, 1, 'http://www.microsoft.com', 0, null); 1103 INSERT INTO manufacturers_info VALUES (2, 2, 'http://www.microsoft.de', 0, null); 1104 INSERT INTO manufacturers_info VALUES (2, 3, 'http://www.microsoft.es', 0, null); 1105 INSERT INTO manufacturers_info VALUES (3, 1, 'http://www.warner.com', 0, null); 1106 INSERT INTO manufacturers_info VALUES (3, 2, 'http://www.warner.de', 0, null); 1107 INSERT INTO manufacturers_info VALUES (3, 3, 'http://www.warner.com', 0, null); 1108 INSERT INTO manufacturers_info VALUES (4, 1, 'http://www.fox.com', 0, null); 1109 INSERT INTO manufacturers_info VALUES (4, 2, 'http://www.fox.de', 0, null); 1110 INSERT INTO manufacturers_info VALUES (4, 3, 'http://www.fox.com', 0, null); 1111 INSERT INTO manufacturers_info VALUES (5, 1, 'http://www.logitech.com', 0, null); 1112 INSERT INTO manufacturers_info VALUES (5, 2, 'http://www.logitech.com', 0, null); 1113 INSERT INTO manufacturers_info VALUES (5, 3, 'http://www.logitech.com', 0, null); 1114 INSERT INTO manufacturers_info VALUES (6, 1, 'http://www.canon.com', 0, null); 1115 INSERT INTO manufacturers_info VALUES (6, 2, 'http://www.canon.de', 0, null); 1116 INSERT INTO manufacturers_info VALUES (6, 3, 'http://www.canon.es', 0, null); 1117 INSERT INTO manufacturers_info VALUES (7, 1, 'http://www.sierra.com', 0, null); 1118 INSERT INTO manufacturers_info VALUES (7, 2, 'http://www.sierra.de', 0, null); 1119 INSERT INTO manufacturers_info VALUES (7, 3, 'http://www.sierra.com', 0, null); 1120 INSERT INTO manufacturers_info VALUES (8, 1, 'http://www.infogrames.com', 0, null); 1121 INSERT INTO manufacturers_info VALUES (8, 2, 'http://www.infogrames.de', 0, null); 1122 INSERT INTO manufacturers_info VALUES (8, 3, 'http://www.infogrames.com', 0, null); 1123 INSERT INTO manufacturers_info VALUES (9, 1, 'http://www.hewlettpackard.com', 0, null); 1124 INSERT INTO manufacturers_info VALUES (9, 2, 'http://www.hewlettpackard.de', 0, null); 1125 INSERT INTO manufacturers_info VALUES (9, 3, 'http://welcome.hp.com/country/es/spa/welcome.htm', 0, null); 1126 1127 INSERT INTO orders_status VALUES ( '1', '1', 'Pending'); 1128 INSERT INTO orders_status VALUES ( '1', '2', 'Offen'); 1129 INSERT INTO orders_status VALUES ( '1', '3', 'Pendiente'); 1130 INSERT INTO orders_status VALUES ( '2', '1', 'Processing'); 1131 INSERT INTO orders_status VALUES ( '2', '2', 'In Bearbeitung'); 1132 INSERT INTO orders_status VALUES ( '2', '3', 'Proceso'); 1133 INSERT INTO orders_status VALUES ( '3', '1', 'Delivered'); 1134 INSERT INTO orders_status VALUES ( '3', '2', 'Versendet'); 1135 INSERT INTO orders_status VALUES ( '3', '3', 'Entregado'); 1136 1137 INSERT INTO products VALUES (1,32,'MG200MMS','matrox/mg200mms.gif',299.99, now(),null,null,23.00,1,1,1,0); 1138 INSERT INTO products VALUES (2,32,'MG400-32MB','matrox/mg400-32mb.gif',499.99, now(),null,null,23.00,1,1,1,0); 1139 INSERT INTO products VALUES (3,2,'MSIMPRO','microsoft/msimpro.gif',49.99, now(),null,null,7.00,1,1,3,0); 1140 INSERT INTO products VALUES (4,13,'DVD-RPMK','dvd/replacement_killers.gif',42.00, now(),null,null,23.00,1,1,2,0); 1141 INSERT INTO products VALUES (5,17,'DVD-BLDRNDC','dvd/blade_runner.gif',35.99, now(),null,null,7.00,1,1,3,0); 1142 INSERT INTO products VALUES (6,10,'DVD-MATR','dvd/the_matrix.gif',39.99, now(),null,null,7.00,1,1,3,0); 1143 INSERT INTO products VALUES (7,10,'DVD-YGEM','dvd/youve_got_mail.gif',34.99, now(),null,null,7.00,1,1,3,0); 1144 INSERT INTO products VALUES (8,10,'DVD-ABUG','dvd/a_bugs_life.gif',35.99, now(),null,null,7.00,1,1,3,0); 1145 INSERT INTO products VALUES (9,10,'DVD-UNSG','dvd/under_siege.gif',29.99, now(),null,null,7.00,1,1,3,0); 1146 INSERT INTO products VALUES (10,10,'DVD-UNSG2','dvd/under_siege2.gif',29.99, now(),null,null,7.00,1,1,3,0); 1147 INSERT INTO products VALUES (11,10,'DVD-FDBL','dvd/fire_down_below.gif',29.99, now(),null,null,7.00,1,1,3,0); 1148 INSERT INTO products VALUES (12,10,'DVD-DHWV','dvd/die_hard_3.gif',39.99, now(),null,null,7.00,1,1,4,0); 1149 INSERT INTO products VALUES (13,10,'DVD-LTWP','dvd/lethal_weapon.gif',34.99, now(),null,null,7.00,1,1,3,0); 1150 INSERT INTO products VALUES (14,10,'DVD-REDC','dvd/red_corner.gif',32.00, now(),null,null,7.00,1,1,3,0); 1151 INSERT INTO products VALUES (15,10,'DVD-FRAN','dvd/frantic.gif',35.00, now(),null,null,7.00,1,1,3,0); 1152 INSERT INTO products VALUES (16,10,'DVD-CUFI','dvd/courage_under_fire.gif',38.99, now(),null,null,7.00,1,1,4,0); 1153 INSERT INTO products VALUES (17,10,'DVD-SPEED','dvd/speed.gif',39.99, now(),null,null,7.00,1,1,4,0); 1154 INSERT INTO products VALUES (18,10,'DVD-SPEED2','dvd/speed_2.gif',42.00, now(),null,null,7.00,1,1,4,0); 1155 INSERT INTO products VALUES (19,10,'DVD-TSAB','dvd/theres_something_about_mary.gif',49.99, now(),null,null,7.00,1,1,4,0); 1156 INSERT INTO products VALUES (20,10,'DVD-BELOVED','dvd/beloved.gif',54.99, now(),null,null,7.00,1,1,3,0); 1157 INSERT INTO products VALUES (21,16,'PC-SWAT3','sierra/swat_3.gif',79.99, now(),null,null,7.00,1,1,7,0); 1158 INSERT INTO products VALUES (22,13,'PC-UNTM','gt_interactive/unreal_tournament.gif',89.99, now(),null,null,7.00,1,1,8,0); 1159 INSERT INTO products VALUES (23,16,'PC-TWOF','gt_interactive/wheel_of_time.gif',99.99, now(),null,null,10.00,1,1,8,0); 1160 INSERT INTO products VALUES (24,17,'PC-DISC','gt_interactive/disciples.gif',90.00, now(),null,null,8.00,1,1,8,0); 1161 INSERT INTO products VALUES (25,16,'MSINTKB','microsoft/intkeyboardps2.gif',69.99, now(),null,null,8.00,1,1,2,0); 1162 INSERT INTO products VALUES (26,10,'MSIMEXP','microsoft/imexplorer.gif',64.95, now(),null,null,8.00,1,1,2,0); 1163 INSERT INTO products VALUES (27,8,'HPLJ1100XI','hewlett_packard/lj1100xi.gif',499.99, now(),null,null,45.00,1,1,9,0); 1164 1165 INSERT INTO products_description VALUES (1,1,'Matrox G200 MMS','Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.<br><br>With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br><br>Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.','www.matrox.com/mga/products/g200_mms/home.cfm',0); 1166 INSERT INTO products_description VALUES (2,1,'Matrox G400 32MB','<b>Dramatically Different High Performance Graphics</b><br><br>Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry\'s fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC\'s arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.<br><br><b>Key features:</b><ul><li>New Matrox G400 256-bit DualBus graphics chip</li><li>Explosive 3D, 2D and DVD performance</li><li>DualHead Display</li><li>Superior DVD and TV output</li><li>3D Environment-Mapped Bump Mapping</li><li>Vibrant Color Quality rendering </li><li>UltraSharp DAC of up to 360 MHz</li><li>3D Rendering Array Processor</li><li>Support for 16 or 32 MB of memory</li></ul>','www.matrox.com/mga/products/mill_g400/home.htm',0); 1167 INSERT INTO products_description VALUES (3,1,'Microsoft IntelliMouse Pro','Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft\'s popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency.','www.microsoft.com/hardware/mouse/intellimouse.asp',0); 1168 INSERT INTO products_description VALUES (4,1,'The Replacement Killers','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 80 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.replacement-killers.com',0); 1169 INSERT INTO products_description VALUES (5,1,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 112 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.bladerunner.com',0); 1170 INSERT INTO products_description VALUES (6,1,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch.\r<br>\nAudio: Dolby Surround.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 131 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Making Of.','www.thematrix.com',0); 1171 INSERT INTO products_description VALUES (7,1,'You\'ve Got Mail','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch, Spanish.\r<br>\nSubtitles: English, Deutsch, Spanish, French, Nordic, Polish.\r<br>\nAudio: Dolby Digital 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 115 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.youvegotmail.com',0); 1172 INSERT INTO products_description VALUES (8,1,'A Bug\'s Life','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Digital 5.1 / Dobly Surround Stereo.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 91 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.abugslife.com',0); 1173 INSERT INTO products_description VALUES (9,1,'Under Siege','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 98 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1174 INSERT INTO products_description VALUES (10,1,'Under Siege 2 - Dark Territory','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 98 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1175 INSERT INTO products_description VALUES (11,1,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 100 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1176 INSERT INTO products_description VALUES (12,1,'Die Hard With A Vengeance','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 122 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1177 INSERT INTO products_description VALUES (13,1,'Lethal Weapon','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 100 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1178 INSERT INTO products_description VALUES (14,1,'Red Corner','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 117 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1179 INSERT INTO products_description VALUES (15,1,'Frantic','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 115 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1180 INSERT INTO products_description VALUES (16,1,'Courage Under Fire','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 112 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1181 INSERT INTO products_description VALUES (17,1,'Speed','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 112 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1182 INSERT INTO products_description VALUES (18,1,'Speed 2: Cruise Control','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 120 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1183 INSERT INTO products_description VALUES (19,1,'There\'s Something About Mary','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 114 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1184 INSERT INTO products_description VALUES (20,1,'Beloved','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 164 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1185 INSERT INTO products_description VALUES (21,1,'SWAT 3: Close Quarters Battle','<b>Windows 95/98</b><br><br>211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and \"When needed\" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!','www.swat3.com',0); 1186 INSERT INTO products_description VALUES (22,1,'Unreal Tournament','From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.<br><br>This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It\'s a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of \'bots\' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master.','www.unrealtournament.net',0); 1187 INSERT INTO products_description VALUES (23,1,'The Wheel Of Time','The world in which The Wheel of Time takes place is lifted directly out of Jordan\'s pages; it\'s huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you\'re playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter\'angreal, Portal Stones, and the Ways. However you move around, though, you\'ll quickly discover that means of locomotion can easily become the least of the your worries...<br><br>During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time\'s main characters. Some of these places are ripped directly from the pages of Jordan\'s books, made flesh with Legend\'s unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you\'ll have this year.','www.wheeloftime.com',0); 1188 INSERT INTO products_description VALUES (24,1,'Disciples: Sacred Lands','A new age is dawning...<br><br>Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.<br><br>The day of reckoning has come... and only the chosen will survive.','',0); 1189 INSERT INTO products_description VALUES (25,1,'Microsoft Internet Keyboard PS/2','The Internet Keyboard has 10 Hot Keys on a comfortable standard keyboard design that also includes a detachable palm rest. The Hot Keys allow you to browse the web, or check e-mail directly from your keyboard. The IntelliType Pro software also allows you to customize your hot keys - make the Internet Keyboard work the way you want it to!','',0); 1190 INSERT INTO products_description VALUES (26,1,'Microsoft IntelliMouse Explorer','Microsoft introduces its most advanced mouse, the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design, an industrial-silver finish, a glowing red underside and taillight, creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology, the convenience of two new customizable function buttons, the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC!','www.microsoft.com/hardware/mouse/explorer.asp',0); 1191 INSERT INTO products_description VALUES (27,1,'Hewlett Packard LaserJet 1100Xi','HP has always set the pace in laser printing technology. The new generation HP LaserJet 1100 series sets another impressive pace, delivering a stunning 8 pages per minute print speed. The 600 dpi print resolution with HP\'s Resolution Enhancement technology (REt) makes every document more professional.<br><br>Enhanced print speed and laser quality results are just the beginning. With 2MB standard memory, HP LaserJet 1100xi users will be able to print increasingly complex pages. Memory can be increased to 18MB to tackle even more complex documents with ease. The HP LaserJet 1100xi supports key operating systems including Windows 3.1, 3.11, 95, 98, NT 4.0, OS/2 and DOS. Network compatibility available via the optional HP JetDirect External Print Servers.<br><br>HP LaserJet 1100xi also features The Document Builder for the Web Era from Trellix Corp. (featuring software to create Web documents).','www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100',0); 1192 INSERT INTO products_description VALUES (1,2,'Matrox G200 MMS','<b>Unterstützung für zwei bzw. vier analoge oder digitale Monitore</b><br><br>\r\nDie Matrox G200 Multi-Monitor-Serie führt die bewährte Matrox Tradition im Multi-Monitor- Bereich fort und bietet flexible und fortschrittliche Lösungen.Matrox stellt als erstes Unternehmen einen vierfachen digitalen PanelLink® DVI Flachbildschirm Ausgang zur Verfügung. Mit den optional erhältlichen TV Tuner und Video-Capture Möglichkeiten stellt die Matrox G200 MMS eine alles umfassende Mehrschirm-Lösung dar.<br><br>\r\n<b>Leistungsmerkmale:</b>\r\n<ul>\r\n<li>Preisgekrönter Matrox G200 128-Bit Grafikchip</li>\r\n<li>Schneller 8 MB SGRAM-Speicher pro Kanal</li>\r\n<li>Integrierter, leistungsstarker 250 MHz RAMDAC</li>\r\n<li>Unterstützung für bis zu 16 Bildschirme über 4 Quad-Karten (unter Win NT,ab Treiber 4.40)</li>\r\n<li>Unterstützung von 9 Monitoren unter Win 98</li>\r\n<li>2 bzw. 4 analoge oder digitale Ausgabekanäle pro PCI-Karte</li>\r\n<li>Desktop-Darstellung von 1800 x 1440 oder 1920 x 1200 pro Chip</li>\r\n<li>Anschlußmöglichkeit an einen 15-poligen VGA-Monitor oder an einen 30-poligen digitalen DVI-Flachbildschirm plus integriertem Composite-Video-Eingang (bei der TV-Version)</li>\r\n<li>PCI Grafikkarte, kurze Baulänge</li>\r\n<li>Treiberunterstützung: Windows® 2000, Windows NT® und Windows® 98</li>\r\n<li>Anwendungsbereiche: Börsenumgebung mit zeitgleich großem Visualisierungsbedarf, Videoüberwachung, Video-Conferencing</li>\r\n</ul>','www.matrox.com/mga/deutsch/products/g200_mms/home.cfm',0); 1193 INSERT INTO products_description VALUES (2,2,'Matrox G400 32 MB','<b>Neu! Matrox G400 "all inclusive" und vieles mehr...</b><br><br>\r\nDie neue Millennium G400-Serie - Hochleistungsgrafik mit dem sensationellen Unterschied. Ausgestattet mit dem neu eingeführten Matrox G400 Grafikchip, bietet die Millennium G400-Serie eine überragende Beschleunigung inklusive bisher nie dagewesener Bildqualitat und enorm flexibler Darstellungsoptionen bei allen Ihren 3D-, 2D- und DVD-Anwendungen.<br><br>\r\n<ul>\r\n<li>DualHead Display und TV-Ausgang</li>\r\n<li>Environment Mapped Bump Mapping</li>\r\n<li>Matrox G400 256-Bit DualBus</li>\r\n<li>3D Rendering Array Prozessor</li>\r\n<li>Vibrant Color Quality² (VCQ²)</li>\r\n<li>UltraSharp DAC</li>\r\n</ul>\r\n<i>"Bleibt abschließend festzustellen, daß die Matrox Millennium G400 Max als Allroundkarte für den Highend-PC derzeit unerreicht ist. Das ergibt den Testsieg und unsere wärmste Empfehlung."</i><br>\r\n<b>GameStar 8/99 (S.184)</b>','www.matrox.com/mga/deutsch/products/mill_g400/home.cfm',0); 1194 INSERT INTO products_description VALUES (3,2,'Microsoft IntelliMouse Pro','Die IntelliMouse Pro hat mit der IntelliRad-Technologie einen neuen Standard gesetzt. Anwenderfreundliche Handhabung und produktiveres Arbeiten am PC zeichnen die IntelliMouse aus. Die gewölbte Oberseite paßt sich natürlich in die Handfläche ein, die geschwungene Form erleichtert das Bedienen der Maus. Sie ist sowohl für Rechts- wie auch für Linkshänder geeignet. Mit dem Rad der IntelliMouse kann der Anwender einfach und komfortabel durch Dokumente navigieren.<br><br>\r\n<b>Eigenschaften:</b>\r\n<ul>\r\n<li><b>ANSCHLUSS:</b> PS/2</li>\r\n<li><b>FARBE:</b> weiß</li>\r\n<li><b>TECHNIK:</b> Mauskugel</li>\r\n<li><b>TASTEN:</b> 3 (incl. Scrollrad)</li>\r\n<li><b>SCROLLRAD:</b> Ja</li>\r\n</ul>','',0); 1195 INSERT INTO products_description VALUES (4,2,'Die Ersatzkiller','Originaltitel: "The Replacement Killers"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 80 minutes.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n(USA 1998). Til Schweiger schießt auf Hongkong-Star Chow Yun-Fat ("Anna und der König") ein Fehler ...','www.replacement-killers.com',0); 1196 INSERT INTO products_description VALUES (5,2,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 112 minutes.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n<b>Sci-Fi-Klassiker, USA 1983, 112 Min.</b><br><br>\r\nLos Angeles ist im Jahr 2019 ein Hexenkessel. Dauerregen und Smog tauchen den überbevölkerten Moloch in ewige Dämmerung. Polizeigleiter schwirren durch die Luft und überwachen das grelle Ethnogemisch, das sich am Fuße 400stöckiger Stahlbeton-Pyramiden tummelt. Der abgehalfterte Ex-Cop und \"Blade Runner\" Rick Deckard ist Spezialist für die Beseitigung von Replikanten, künstlichen Menschen, geschaffen für harte Arbeit auf fremden Planeten. Nur ihm kann es gelingen, vier flüchtige, hochintelligente \"Nexus 6\"-Spezialmodelle zu stellen. Die sind mit ihrem starken und brandgefährlichen Anführer Batty auf der Suche nach ihrem Schöpfer. Er soll ihnen eine längere Lebenszeit schenken. Das muß Rick Deckard verhindern. Als sich der eiskalte Jäger in Rachel, die Sekretärin seines Auftraggebers, verliebt, gerät sein Weltbild jedoch ins Wanken. Er entdeckt, daß sie - vielleicht wie er selbst - ein Replikant ist ...<br><br>\r\nDie Konfrontation des Menschen mit \"Realität\" und \"Virtualität\" und das verstrickte Spiel mit getürkten Erinnerungen zieht sich als roter Faden durch das Werk von Autor Philip K. Dick (\"Die totale Erinnerung\"). Sein Roman \"Träumen Roboter von elektrischen Schafen?\" liefert die Vorlage für diesen doppelbödigen Thriller, der den Zuschauer mit faszinierenden\r\nZukunftsvisionen und der gigantischen Kulisse des Großstadtmolochs gefangen nimmt.','www.bladerunner.com',0); 1197 INSERT INTO products_description VALUES (6,2,'Matrix','Originaltitel: "The Matrix"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 136 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n(USA 1999) Der Geniestreich der Wachowski-Brüder. In dieser technisch perfekten Utopie kämpft Hacker Keanu Reeves gegen die Diktatur der Maschinen...','www.whatisthematrix.com',0); 1198 INSERT INTO products_description VALUES (7,2,'e-m@il für Dich','Original: "You\'ve got mail"<br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 112 minutes.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n(USA 1998) von Nora Ephron (&qout;Schlaflos in Seattle"). Meg Ryan und Tom Hanks knüpfen per E-Mail zarte Bande. Dass sie sich schon kennen, ahnen sie nicht ...','www.youvegotmail.com',0); 1199 INSERT INTO products_description VALUES (8,2,'Das Große Krabbeln','Originaltitel: "A Bug\'s Life"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n(USA 1998). Ameise Flik zettelt einen Aufstand gegen gefräßige Grashüpfer an ... Eine fantastische Computeranimation des \"Toy Story\"-Teams. ','www.abugslife.com',0); 1200 INSERT INTO products_description VALUES (9,2,'Alarmstufe: Rot','Originaltitel: "Under Siege"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n<b>Actionthriller. Smutje Steven Seagal versalzt Schurke Tommy Lee Jones die Suppe</b><br><br>\r\nKatastrophe ahoi: Kurz vor Ausmusterung der \"U.S.S. Missouri\" kapert die High-tech-Bande von Ex-CIA-Agent Strannix (Tommy Lee Jones) das Schlachtschiff. Strannix will die Nuklearraketen des Kreuzers klauen und verscherbeln. Mit Hilfe des irren Ersten Offiziers Krill (lustig: Gary Busey) killen die Gangster den Käpt’n und sperren seine Crew unter Deck. Blöd, dass sie dabei Schiffskoch Rybak (Steven Seagal) vergessen. Der Ex-Elitekämpfer knipst einen Schurken nach dem anderen aus. Eine Verbündete findet er in Stripperin Jordan (Ex-\"Baywatch\"-Biene Erika Eleniak). Die sollte eigentlich aus Käpt’ns Geburtstagstorte hüpfen ... Klar: Seagal ist kein Edelmime. Dafür ist Regisseur Andrew Davis (\"Auf der Flucht\") ein Könner: Er würzt die Action-Orgie mit Ironie und nutzt die imposante Schiffskulisse voll aus. Für Effekte und Ton gab es 1993 Oscar-Nominierungen. ','',0); 1201 INSERT INTO products_description VALUES (10,2,'Alarmstufe: Rot 2','Originaltitel: "Under Siege 2: Dark Territory"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n(USA ’95). Von einem gekaperten Zug aus übernimmt Computerspezi Dane die Kontrolle über einen Kampfsatelliten und erpresst das Pentagon. Aber auch Ex-Offizier Ryback (Steven Seagal) ist im Zug ...\r\n','',0); 1202 INSERT INTO products_description VALUES (11,2,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nEin mysteriöser Mordfall führt den Bundesmarschall Jack Taggert in eine Kleinstadt im US-Staat Kentucky. Doch bei seinen Ermittlungen stößt er auf eine Mauer des Schweigens. Angst beherrscht die Stadt, und alle Spuren führen zu dem undurchsichtigen Minen-Tycoon Orin Hanner. Offenbar werden in der friedlichen Berglandschaft gigantische Mengen Giftmülls verschoben, mit unkalkulierbaren Risiken. Um eine Katastrophe zu verhindern, räumt Taggert gnadenlos auf ...','',0); 1203 INSERT INTO products_description VALUES (12,2,'Stirb Langsam - Jetzt Erst Recht','Originaltitel: "Die Hard With A Vengeance"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nSo explosiv, so spannend, so rasant wie nie zuvor: Bruce Willis als Detectiv John McClane in einem Action-Thriller der Superlative! Das ist heute nicht McClanes Tag. Seine Frau hat ihn verlassen, sein Boß hat ihn vom Dienst suspendiert und irgendein Verrückter hat ihn gerade zum Gegenspieler in einem teuflischen Spiel erkoren - und der Einsatz ist New York selbst. Ein Kaufhaus ist explodiert, doch das ist nur der Auftakt. Der geniale Superverbrecher Simon droht, die ganze Stadt Stück für Stück in die Luft zu sprengen, wenn McClane und sein Partner wider Willen seine explosiven\" Rätsel nicht lösen. Eine mörderische Hetzjagd quer durch New York beginnt - bis McClane merkt, daß der Bombenterror eigentlich nur ein brillantes Ablenkungsmanöver ist...!<br><i>\"Perfekt gemacht und stark besetzt. Das Action-Highlight des Jahres!\"</i> <b>(Bild)</b>','',0); 1204 INSERT INTO products_description VALUES (13,2,'Zwei stahlharte Profis','Originaltitel: "Lethal Weapon"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nSie sind beide Cops in L.A.. Sie haben beide in Vietnam für eine Spezialeinheit gekämpft. Und sie hassen es beide, mit einem Partner arbeiten zu müssen. Aber sie sind Partner: Martin Riggs, der Mann mit dem Todeswunsch, für wen auch immer. Und Roger Murtaugh, der besonnene Polizist. Gemeinsam enttarnen sie einen gigantischen Heroinschmuggel, hinter dem sich eine Gruppe ehemaliger CIA-Söldner verbirgt. Eine Killerbande gegen zwei Profis ...','',0); 1205 INSERT INTO products_description VALUES (14,2,'Labyrinth ohne Ausweg','Originaltitel: "Red Corner"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nDem Amerikaner Jack Moore wird in China der bestialische Mord an einem Fotomodel angehängt. Brutale Gefängnisschergen versuchen, ihn durch Folter zu einem Geständnis zu zwingen. Vor Gericht fordert die Anklage die Todesstrafe - Moore\'s Schicksal scheint besiegelt. Durch einen Zufall gelingt es ihm, aus der Haft zu fliehen, doch aus der feindseligen chinesischen Hauptstadt gibt es praktisch kein Entkommen ...','',0); 1206 INSERT INTO products_description VALUES (15,2,'Frantic','Originaltitel: "Frantic"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nEin romantischer Urlaub in Paris, der sich in einen Alptraum verwandelt. Ein Mann auf der verzweifelten Suche nach seiner entführten Frau. Ein düster-bedrohliches Paris, in dem nur ein Mensch Licht in die tödliche Affäre bringen kann.','',0); 1207 INSERT INTO products_description VALUES (16,2,'Mut Zur Wahrheit','Originaltitel: "Courage Under Fire"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nLieutenant Colonel Nathaniel Serling (Denzel Washington) lässt während einer Schlacht im Golfkrieg versehentlich auf einen US-Panzer schießen, dessen Mannschaft dabei ums Leben kommt. Ein Jahr nach diesem Vorfall wird Serling, der mittlerweile nach Washington D.C. versetzt wurde, die Aufgabe übertragen, sich um einen Kandidaten zu kümmern, der während des Krieges starb und dem der höchste militärische Orden zuteil werden soll. Allerdings sind sowohl der Fall und als auch der betreffende Soldat ein politisch heißes Eisen -- Captain Karen Walden (Meg Ryan) ist Amerikas erster weiblicher Soldat, der im Kampf getötet wurde.<br><br>\r\nSerling findet schnell heraus, dass es im Fall des im felsigen Gebiet von Kuwait abgestürzten Rettungshubschraubers Diskrepanzen gibt. In Flashbacks werden von unterschiedlichen Personen verschiedene Versionen von Waldens Taktik, die Soldaten zu retten und den Absturz zu überleben, dargestellt (à la Kurosawas Rashomon). Genau wie in Glory erweist sich Regisseur Edward Zwicks Zusammenstellung von bekannten und unbekannten Schauspielern als die richtige Mischung. Waldens Crew ist besonders überzeugend. Matt Damon als der Sanitäter kommt gut als der leichtfertige Typ rüber, als er Washington seine Geschichte erzählt. Im Kampf ist er ein mit Fehlern behafteter, humorvoller Soldat.<br><br>\r\nDie erstaunlichste Arbeit in Mut zur Wahrheit leistet Lou Diamond Phillips (als der Schütze der Gruppe), dessen Karriere sich auf dem Weg in die direkt für den Videomarkt produzierten Filme befand. Und dann ist da noch Ryan. Sie hat sich in dramatischen Filmen in der Vergangenheit gut behauptet (Eine fast perfekte Liebe, Ein blutiges Erbe), es aber nie geschafft, ihrem Image zu entfliehen, das sie in die Ecke der romantischen Komödie steckte. Mit gefärbtem Haar, einem leichten Akzent und der von ihr geforderten Darstellungskunst hat sie endlich einen langlebigen dramatischen Film. Obwohl sie nur halb so oft wie Washington im Film zu sehen ist, macht ihre mutige und beeindruckend nachhaltige Darstellung Mut zur Wahrheit zu einem speziellen Film bis hin zu dessen seltsamer, aber lohnender letzter Szene.','',0); 1208 INSERT INTO products_description VALUES (17,2,'Speed','Originaltitel: "Speed"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nEr ist ein Cop aus der Anti-Terror-Einheit von Los Angeles. Und so ist der Alarm für Jack Traven nichts Ungewöhnliches: Ein Terrorist will drei Millionen Dollar erpressen, oder die zufälligen Geiseln in einem Aufzug fallen 35 Stockwerke in die Tiefe. Doch Jack schafft das Unmögliche - die Geiseln werden gerettet und der Terrorist stirbt an seiner eigenen Bombe. Scheinbar. Denn schon wenig später steht Jack (Keanu Reeves) dem Bombenexperten Payne erneut gegenüber. Diesmal hat sich der Erpresser eine ganz perfide Mordwaffe ausgedacht: Er plaziert eine Bombe in einem öffentlichen Bus. Der Mechanismus der Sprengladung schaltet sich automatisch ein, sobald der Bus schneller als 50 Meilen in der Stunde fährt und detoniert sofort, sobald die Geschwindigkeit sinkt. Plötzlich wird für eine Handvoll ahnungsloser Durchschnittsbürger der Weg zur Arbeit zum Höllentrip - und nur Jack hat ihr Leben in der Hand. Als der Busfahrer verletzt wird, übernimmt Fahrgast Annie (Sandra Bullock) das Steuer. Doch wohin mit einem Bus, der nicht bremsen kann in der Stadt der Staus? Doch es kommt noch schlimmer: Payne (Dennis Hopper) will jetzt nicht nur seine drei Millionen Dollar. Er will Jack. Um jeden Preis.','',0); 1209 INSERT INTO products_description VALUES (18,2,'Speed 2: Cruise Control','Originaltitel: "Speed 2 - Cruise Control"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nHalten Sie ihre Schwimmwesten bereit, denn die actiongeladene Fortsetzung von Speed begibt sich auf Hochseekurs. Erleben Sie Sandra Bullock erneut in ihrer Star-Rolle als Annie Porter. Die Karibik-Kreuzfahrt mit ihrem Freund Alex entwickelt sich unaufhaltsam zur rasenden Todesfahrt, als ein wahnsinniger Computer-Spezialist den Luxusliner in seine Gewalt bringt und auf einen mörderischen Zerstörungskurs programmiert. Eine hochexplosive Reise, bei der kein geringerer als Action-Spezialist Jan De Bont das Ruder in die Hand nimmt. Speed 2: Cruise Controll läßt ihre Adrenalin-Wellen in rasender Geschwindigkeit ganz nach oben schnellen.','',0); 1210 INSERT INTO products_description VALUES (19,2,'Verrückt nach Mary','Originaltitel: "There\'s Something About Mary"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\n13 Jahre nachdem Teds Rendezvous mit seiner angebeteten Mary in einem peinlichen Fiasko endete, träumt er immer noch von ihr und engagiert den windigen Privatdetektiv Healy um sie aufzuspüren. Der findet Mary in Florida und verliebt sich auf den ersten Blick in die atemberaubende Traumfrau. Um Ted als Nebenbuhler auszuschalten, tischt er ihm dicke Lügen über Mary auf. Ted läßt sich jedoch nicht abschrecken, eilt nach Miami und versucht nun alles, um Healy die Balztour zu vermasseln. Doch nicht nur Healy ist verrückt nach Mary und Ted bekommt es mit einer ganzen Legion liebeskranker Konkurrenten zu tun ...','',0); 1211 INSERT INTO products_description VALUES (20,2,'Menschenkind','Originaltitel: "Beloved"<br><br>\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).<br>\r\nSprachen: English, Deutsch.<br>\r\nUntertitel: English, Deutsch, Spanish.<br>\r\nAudio: Dolby Surround 5.1.<br>\r\nBildformat: 16:9 Wide-Screen.<br>\r\nDauer: (approx) 96 minuten.<br>\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.<br><br>\r\nDieser vielschichtige Film ist eine Arbeit, die Regisseur Jonathan Demme und dem amerikanischen Talkshow-Star Oprah Winfrey sehr am Herzen lag. Der Film deckt im Verlauf seiner dreistündigen Spielzeit viele Bereiche ab. Menschenkind ist teils Sklavenepos, teils Mutter-Tochter-Drama und teils Geistergeschichte.<br><br>\r\nDer Film fordert vom Publikum höchste Aufmerksamkeit, angefangen bei seiner dramatischen und etwas verwirrenden Eingangssequenz, in der die Bewohner eines Hauses von einem niederträchtigen übersinnlichen Angriff heimgesucht werden. Aber Demme und seine talentierte Besetzung bereiten denen, die dabei bleiben ein unvergessliches Erlebnis. Der Film folgt den Spuren von Sethe (in ihren mittleren Jahren von Oprah Winfrey dargestellt), einer ehemaligen Sklavin, die sich scheinbar ein friedliches und produktives Leben in Ohio aufgebaut hat. Aber durch den erschreckenden und sparsamen Einsatz von Rückblenden deckt Demme, genau wie das literarische Meisterwerk von Toni Morrison, auf dem der Film basiert, langsam die Schrecken von Sethes früherem Leben auf und das schreckliche Ereignis, dass dazu führte, dass Sethes Haus von Geistern heimgesucht wird.<br><br>\r\nWährend die Gräuel der Sklaverei und das blutige Ereignis in Sethes Familie unleugbar tief beeindrucken, ist die Qualität des Film auch in kleineren, genauso befriedigenden Details sichtbar. Die geistlich beeinflusste Musik von Rachel Portman ist gleichzeitig befreiend und bedrückend, und der Einblick in die afro-amerikanische Gemeinschaft nach der Sklaverei -- am Beispiel eines Familienausflugs zu einem Jahrmarkt, oder dem gospelsingenden Nähkränzchen -- machen diesen Film zu einem speziellen Vergnügen sowohl für den Geist als auch für das Herz. Die Schauspieler, besonders Kimberley Elise als Sethes kämpfende Tochter und Thandie Newton als der mysteriöse Titelcharakter, sind sehr rührend. Achten Sie auch auf Danny Glover (Lethal Weapon) als Paul D.','',0); 1212 INSERT INTO products_description VALUES (21,2,'SWAT 3: Elite Edition','<b>KEINE KOMPROMISSE!</b><br><i>Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!</i><br><br>\r\nEine der realistischsten 3D-Taktiksimulationen der letzten Zeit jetzt mit Multiplayer-Modus, 5 neuen Missionen und jede Menge nützliche Tools!<br><br>\r\nLos Angeles, 2005. In wenigen Tagen steht die Unterzeichnung des Abkommens der Vereinten Nationen zur Atom-Ächtung durch Vertreter aller Nationen der Welt an. Radikale terroristische Vereinigungen machen sich in der ganzen Stadt breit. Verantwortlich für die Sicherheit der Delegierten zeichnet sich eine Eliteeinheit der LAPD: das SWAT-Team. Das Schicksal der Stadt liegt in Ihren Händen.<br><br>\r\n<b>Neue Features:</b>\r\n<ul>\r\n<li>Multiplayer-Modus (Co op-Modus, Deathmatch in den bekannten Variationen)</li>\r\n<li>5 neue Missionen an original Örtlichkeiten Las (U-Bahn, Whitman Airport, etc.)</li>\r\n<li>neue Charakter</li>\r\n<li>neue Skins</li>\r\n<li>neue Waffen</li>\r\n<li>neue Sounds</li>\r\n<li>verbesserte KI</li>\r\n<li>Tools-Package</li>\r\n<li>Scenario-Editor</li>\r\n<li>Level-Editor</li>\r\n</ul>\r\nDie dritte Folge der Bestseller-Reihe im Bereich der 3D-Echtzeit-Simulationen präsentiert sich mit einer neuen Spielengine mit extrem ausgeprägtem Realismusgrad. Der Spieler übernimmt das Kommando über eine der besten Polizei-Spezialeinheiten oder einer der übelsten Terroristen-Gangs der Welt. Er durchläuft - als \"Guter\" oder \"Böser\" - eine der härtesten und elitärsten Kampfausbildungen, in der er lernt, mit jeder Art von Krisensituationen umzugehen. Bei diesem Action-Abenteuer geht es um das Leben prominenter Vertreter der Vereinten Nationen und bei 16 Missionen an Originalschauplätzen in LA gibt die \"lebensechte\" KI den Protagonisten jeder Seite so einige harte Nüsse zu knacken.','www.swat3.com',0); 1213 INSERT INTO products_description VALUES (22,2,'Unreal Tournament','2341: Die Gewalt ist eine Lebensweise, die sich ihren Weg durch die dunklen Risse der Gesellschaft bahnt. Sie bedroht die Macht und den Einfluss der regierenden Firmen, die schnellstens ein Mittel finden müssen, die tobenden Massen zu besänftigen - ein profitables Mittel ... Gladiatorenkämpfe sind die Lösung. Sie sollen den Durst der Menschen nach Blut stillen und sind die perfekte Gelegenheit, die Aufständischen, Kriminellen und Aliens zu beseitigen, die die Firmenelite bedrohen.<br><br>\r\nDas Turnier war geboren - ein Kampf auf Leben und Tod. Galaxisweit live und in Farbe! Kämpfen Sie für Freiheit, Ruhm und Ehre. Sie müssen stark, schnell und geschickt sein ... oder Sie bleiben auf der Strecke.<br><br>\r\nKämpfen Sie allein oder kommandieren Sie ein Team gegen Armeen unbarmherziger Krieger, die alle nur ein Ziel vor Augen haben: Die Arenen lebend zu verlassen und sich dem Grand Champion zu stellen ... um ihn dann zu bezwingen!<br><br>\r\n<b>Features:</b>\r\n<ul>\r\n<li>Auf dem PC mehrfach als Spiel des Jahres ausgezeichnet!</li>\r\n<li>Mehr als 50 faszinierende Level - verlassene Raumstationen, gotische Kathedralen und graffitibedeckte Großstädte.</li>\r\n<li>Vier actionreiche Spielmodi - Deathmatch, Capture the Flag, Assault und Domination werden Ihren Adrenalinpegel in die Höhe schnellen lassen.</li>\r\n<li>Dramatische Mehrspieler-Kämpfe mit 2, 3 und 4 Spielern, auch über das Netzwerk</li>\r\n<li>Gnadenlos aggressive Computergegner verlangen Ihnen das Äußerste ab.</li>\r\n<li>Neuartiges Benutzerinterface und verbesserte Steuerung - auch mit USB-Maus und -Tastatur spielbar.</li>\r\n</ul>\r\nDer Nachfolger des Actionhits \"Unreal\" verspricht ein leichtes, intuitives Interface, um auch Einsteigern schnellen Zugang zu den Duellen gegen die Bots zu ermöglichen. Mit diesen KI-Kriegern kann man auch Teams bilden und im umfangreichen Multiplayermodus ohne Onlinekosten in den Kampf ziehen. 35 komplett neue Arenen und das erweiterte Waffenangebot bilden dazu den würdigen Rahmen.','www.unrealtournament.net',0); 1214 INSERT INTO products_description VALUES (23,2,'The Wheel Of Time','<b><i>\"Wheel Of Time\"(Das Rad der Zeit)</i></b> basiert auf den Fantasy-Romanen von Kultautor Robert Jordan und stellt einen einzigartigen Mix aus Strategie-, Action- und Rollenspielelementen dar. Obwohl die Welt von \"Wheel of Time\" eng an die literarische Vorlage der Romane angelehnt ist, erzählt das Spiel keine lineare Geschichte. Die Story entwickelt sich abhängig von den Aktionen der Spieler, die jeweils die Rollen der Hauptcharaktere aus dem Roman übernehmen. Jede Figur hat den Oberbefehl über eine große Gefolgschaft, militärische Einheiten und Ländereien. Die Spieler können ihre eigenen Festungen konstruieren, individuell ausbauen, von dort aus das umliegende Land erforschen, magische Gegenstände sammeln oder die gegnerischen Zitadellen erstürmen. Selbstverständlich kann man sich auch über LAN oder Internet gegenseitig Truppen auf den Hals hetzen und die Festungen seiner Mitspieler in Schutt und Asche legen. Dreh- und Anlegepunkt von \"Wheel of Time\" ist der Kampf um die finstere Macht \"The Dark One\", die vor langer Zeit die Menschheit beinahe ins Verderben stürzte und nur mit Hilfe gewaltiger magischer Energie verbannt werden konnte. \"The Amyrlin Seat\" und \"The Children of the Night\" kämpfen nur gegen \"The Forsaken\" und \"The Hound\" um den Besitz des Schlüssels zu \"Shayol Ghul\" - dem magischen Siegel, mit dessen Hilfe \"The Dark One\" seinerzeit gebannt werden konnte.<br><br>\r\n<b>Features:</b> \r\n<ul>\r\n<li>Ego-Shooter mit Strategie-Elementen</li>\r\n<li>Spielumgebung in Echtzeit-3D</li>\r\n<li>Konstruktion aud Ausbau der eigenen Festung</li>\r\n<li>Einsatz von über 100 Artefakten und Zaubersprüchen</li>\r\n<li>Single- und Multiplayermodus</li>\r\n</ul>\r\nIm Mittelpunkt steht der Kampf gegen eine finstere Macht namens The Dark One. Deren Schergen müssen mit dem Einsatz von über 100 Artefakten und Zaubereien wie Blitzschlag oder Teleportation aus dem Weg geräumt werden. Die opulente 3D-Grafik verbindet Strategie- und Rollenspielelemente. \r\n\r\n<b>Voraussetzungen</b>\r\nmind. P200, 32MB RAM, 4x CD-Rom, Win95/98, DirectX 5.0 komp.Grafikkarte und Soundkarte. ','www.wheeloftime.com',0); 1215 INSERT INTO products_description VALUES (24,2,'Disciples: Sacred Land','Rundenbasierende Fantasy/RTS-Strategie mit gutem Design (vor allem die Levels, 4 versch. Rassen, tolle Einheiten), fantastischer Atmosphäre und exzellentem Soundtrack. Grafisch leider auf das Niveau von 1990.','www.strategyfirst.com/disciples/welcome.html',0); 1216 INSERT INTO products_description VALUES (25,2,'Microsoft Internet Tastatur PS/2','<i>Microsoft Internet Keyboard,Windows-Tastatur mit 10 zusätzl. Tasten,2 selbst programmierbar, abnehmbareHandgelenkauflage. Treiber im Lieferumfang.</i><br><br>\r\nEin-Klick-Zugriff auf das Internet und vieles mehr! Das Internet Keyboard verfügt über 10 zusätzliche Abkürzungstasten auf einer benutzerfreundlichen Standardtastatur, die darüber hinaus eine abnehmbare Handballenauflage aufweist. Über die Abkürzungstasten können Sie durch das Internet surfen oder direkt von der Tastatur aus auf E-Mails zugreifen. Die IntelliType Pro-Software ermöglicht außerdem das individuelle Belegen der Tasten.','',0); 1217 INSERT INTO products_description VALUES (26,2,'Microsof IntelliMouse Explorer','Die IntelliMouse Explorer überzeugt durch ihr modernes Design mit silberfarbenem Gehäuse, sowie rot schimmernder Unter- und Rückseite. Die neuartige IntelliEye-Technologie sorgt für eine noch nie dagewesene Präzision, da statt der beweglichen Teile (zum Abtasten der Bewegungsänderungen an der Unterseite der Maus) ein optischer Sensor die Bewegungen der Maus erfaßt. Das Herzstück der Microsoft IntelliEye-Technologie ist ein kleiner Chip, der einen optischen Sensor und einen digitalen Signalprozessor (DSP) enthält.<br><br>\r\nDa auf bewegliche Teile, die Staub, Schmutz und Fett aufnehmen können, verzichtet wurde, muß die IntelliMouse Explorer nicht mehr gereinigt werden. Darüber hinaus arbeitet die IntelliMouse Explorer auf nahezu jeder Arbeitsoberfläche, so daß kein Mauspad mehr erforderlich ist. Mit dem Rad und zwei neuen zusätzlichen Maustasten ermöglicht sie effizientes und komfortables Arbeiten am PC.<br><br>\r\n<b>Eigenschaften:</b>\r\n<ul>\r\n<li><b>ANSCHLUSS:</b> USB (PS/2-Adapter enthalten)</li>\r\n<li><b>FARBE:</b> metallic-grau</li>\r\n<li><b>TECHNIK:</b> Optisch (Akt.: ca. 1500 Bilder/s)</li>\r\n<li><b>TASTEN:</b> 5 (incl. Scrollrad)</li>\r\n<li><b>SCROLLRAD:</b> Ja</li>\r\n</ul>\r\n<i><b>BEMERKUNG:</b><br>Keine Reinigung bewegter Teile mehr notwendig, da statt der Mauskugel ein Fotoempfänger benutzt wird.</i>','',0); 1218 INSERT INTO products_description VALUES (27,2,'Hewlett-Packard LaserJet 1100Xi','<b>HP LaserJet für mehr Produktivität und Flexibilität am Arbeitsplatz</b><br><br>\r\nDer HP LaserJet 1100Xi Drucker verbindet exzellente Laserdruckqualität mit hoher Geschwindigkeit für mehr Effizienz.<br><br>\r\n<b>Zielkunden</b>\r\n<ul><li>Einzelanwender, die Wert auf professionelle Ausdrucke in Laserqualität legen und schnelle Ergebnisse auch bei komplexen Dokumenten erwarten.</li>\r\n<li>Der HP LaserJet 1100 sorgt mit gestochen scharfen Texten und Grafiken für ein professionelles Erscheinungsbild Ihrer Arbeit und Ihres Unternehmens. Selbst bei komplexen Dokumenten liefert er schnelle Ergebnisse. Andere Medien - wie z.B. Transparentfolien und Briefumschläge, etc. - lassen sich problemlos bedrucken. Somit ist der HP LaserJet 1100 ein Multifunktionstalent im Büroalltag.</li>\r\n</ul>\r\n<b>Eigenschaften</b>\r\n<ul>\r\n<li><b>Druckqualität</b> Schwarzweiß: 600 x 600 dpi</li>\r\n<li><b>Monatliche Druckleistung</b> Bis zu 7000 Seiten</li>\r\n<li><b>Speicher</b> 2 MB Standardspeicher, erweiterbar auf 18 MB</li>\r\n<li><b>Schnittstelle/gemeinsame Nutzung</b> Parallel, IEEE 1284-kompatibel</li>\r\n<li><b>Softwarekompatibilität</b> DOS/Win 3.1x/9x/NT 4.0</li>\r\n<li><b>Papierzuführung</b> 125-Blatt-Papierzuführung</li>\r\n<li><b>Druckmedien</b> Normalpapier, Briefumschläge, Transparentfolien, kartoniertes Papier, Postkarten und Etiketten</li>\r\n<li><b>Netzwerkfähig</b> Über HP JetDirect PrintServer</li>\r\n<li><b>Lieferumfang</b> HP LaserJet 1100Xi Drucker (Lieferumfang: Drucker, Tonerkassette, 2 m Parallelkabel, Netzkabel, Kurzbedienungsanleitung, Benutzerhandbuch, CD-ROM, 3,5\"-Disketten mit Windows® 3.1x, 9x, NT 4.0 Treibern und DOS-Dienstprogrammen)</li>\r\n<li><b>Gewährleistung</b> Ein Jahr</li>\r\n</ul>\r\n','www.hp.com',0); 1219 INSERT INTO products_description VALUES (1,3,'Matrox G200 MMS','Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.<br><br>With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br><br>Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.','www.matrox.com/mga/products/g200_mms/home.cfm',0); 1220 INSERT INTO products_description VALUES (2,3,'Matrox G400 32MB','<b>Dramatically Different High Performance Graphics</b><br><br>Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry\'s fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC\'s arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.<br><br><b>Key features:</b><ul><li>New Matrox G400 256-bit DualBus graphics chip</li><li>Explosive 3D, 2D and DVD performance</li><li>DualHead Display</li><li>Superior DVD and TV output</li><li>3D Environment-Mapped Bump Mapping</li><li>Vibrant Color Quality rendering </li><li>UltraSharp DAC of up to 360 MHz</li><li>3D Rendering Array Processor</li><li>Support for 16 or 32 MB of memory</li></ul>','www.matrox.com/mga/products/mill_g400/home.htm',0); 1221 INSERT INTO products_description VALUES (3,3,'Microsoft IntelliMouse Pro','Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft\'s popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency.','www.microsoft.com/hardware/mouse/intellimouse.asp',0); 1222 INSERT INTO products_description VALUES (4,3,'The Replacement Killers','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 80 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.replacement-killers.com',0); 1223 INSERT INTO products_description VALUES (5,3,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 112 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.bladerunner.com',0); 1224 INSERT INTO products_description VALUES (6,3,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch.\r<br>\nAudio: Dolby Surround.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 131 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Making Of.','www.thematrix.com',0); 1225 INSERT INTO products_description VALUES (7,3,'You\'ve Got Mail','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch, Spanish.\r<br>\nSubtitles: English, Deutsch, Spanish, French, Nordic, Polish.\r<br>\nAudio: Dolby Digital 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 115 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.youvegotmail.com',0); 1226 INSERT INTO products_description VALUES (8,3,'A Bug\'s Life','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Digital 5.1 / Dobly Surround Stereo.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 91 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.abugslife.com',0); 1227 INSERT INTO products_description VALUES (9,3,'Under Siege','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 98 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1228 INSERT INTO products_description VALUES (10,3,'Under Siege 2 - Dark Territory','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 98 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1229 INSERT INTO products_description VALUES (11,3,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 100 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1230 INSERT INTO products_description VALUES (12,3,'Die Hard With A Vengeance','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 122 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1231 INSERT INTO products_description VALUES (13,3,'Lethal Weapon','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 100 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1232 INSERT INTO products_description VALUES (14,3,'Red Corner','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 117 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1233 INSERT INTO products_description VALUES (15,3,'Frantic','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 115 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1234 INSERT INTO products_description VALUES (16,3,'Courage Under Fire','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 112 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1235 INSERT INTO products_description VALUES (17,3,'Speed','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 112 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1236 INSERT INTO products_description VALUES (18,3,'Speed 2: Cruise Control','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 120 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1237 INSERT INTO products_description VALUES (19,3,'There\'s Something About Mary','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 114 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1238 INSERT INTO products_description VALUES (20,3,'Beloved','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r<br>\nLanguages: English, Deutsch.\r<br>\nSubtitles: English, Deutsch, Spanish.\r<br>\nAudio: Dolby Surround 5.1.\r<br>\nPicture Format: 16:9 Wide-Screen.\r<br>\nLength: (approx) 164 minutes.\r<br>\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); 1239 INSERT INTO products_description VALUES (21,3,'SWAT 3: Close Quarters Battle','<b>Windows 95/98</b><br><br>211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and \"When needed\" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!','www.swat3.com',0); 1240 INSERT INTO products_description VALUES (22,3,'Unreal Tournament','From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.<br><br>This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It\'s a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of \'bots\' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master.','www.unrealtournament.net',0); 1241 INSERT INTO products_description VALUES (23,3,'The Wheel Of Time','The world in which The Wheel of Time takes place is lifted directly out of Jordan\'s pages; it\'s huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you\'re playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter\'angreal, Portal Stones, and the Ways. However you move around, though, you\'ll quickly discover that means of locomotion can easily become the least of the your worries...<br><br>During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time\'s main characters. Some of these places are ripped directly from the pages of Jordan\'s books, made flesh with Legend\'s unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you\'ll have this year.','www.wheeloftime.com',0); 1242 INSERT INTO products_description VALUES (24,3,'Disciples: Sacred Lands','A new age is dawning...<br><br>Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.<br><br>The day of reckoning has come... and only the chosen will survive.','',0); 1243 INSERT INTO products_description VALUES (25,3,'Microsoft Internet Keyboard PS/2','The Internet Keyboard has 10 Hot Keys on a comfortable standard keyboard design that also includes a detachable palm rest. The Hot Keys allow you to browse the web, or check e-mail directly from your keyboard. The IntelliType Pro software also allows you to customize your hot keys - make the Internet Keyboard work the way you want it to!','',0); 1244 INSERT INTO products_description VALUES (26,3,'Microsoft IntelliMouse Explorer','Microsoft introduces its most advanced mouse, the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design, an industrial-silver finish, a glowing red underside and taillight, creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology, the convenience of two new customizable function buttons, the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC!','www.microsoft.com/hardware/mouse/explorer.asp',0); 1245 INSERT INTO products_description VALUES (27,3,'Hewlett Packard LaserJet 1100Xi','HP has always set the pace in laser printing technology. The new generation HP LaserJet 1100 series sets another impressive pace, delivering a stunning 8 pages per minute print speed. The 600 dpi print resolution with HP\'s Resolution Enhancement technology (REt) makes every document more professional.<br><br>Enhanced print speed and laser quality results are just the beginning. With 2MB standard memory, HP LaserJet 1100xi users will be able to print increasingly complex pages. Memory can be increased to 18MB to tackle even more complex documents with ease. The HP LaserJet 1100xi supports key operating systems including Windows 3.1, 3.11, 95, 98, NT 4.0, OS/2 and DOS. Network compatibility available via the optional HP JetDirect External Print Servers.<br><br>HP LaserJet 1100xi also features The Document Builder for the Web Era from Trellix Corp. (featuring software to create Web documents).','www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100',0); 1246 1247 INSERT INTO products_attributes VALUES (1,1,4,1,0.00,'+'); 1248 INSERT INTO products_attributes VALUES (2,1,4,2,50.00,'+'); 1249 INSERT INTO products_attributes VALUES (3,1,4,3,70.00,'+'); 1250 INSERT INTO products_attributes VALUES (4,1,3,5,0.00,'+'); 1251 INSERT INTO products_attributes VALUES (5,1,3,6,100.00,'+'); 1252 INSERT INTO products_attributes VALUES (6,2,4,3,10.00,'-'); 1253 INSERT INTO products_attributes VALUES (7,2,4,4,0.00,'+'); 1254 INSERT INTO products_attributes VALUES (8,2,3,6,0.00,'+'); 1255 INSERT INTO products_attributes VALUES (9,2,3,7,120.00,'+'); 1256 INSERT INTO products_attributes VALUES (10,26,3,8,0.00,'+'); 1257 INSERT INTO products_attributes VALUES (11,26,3,9,6.00,'+'); 1258 INSERT INTO products_attributes VALUES (26, 22, 5, 10, '0.00', '+'); 1259 INSERT INTO products_attributes VALUES (27, 22, 5, 13, '0.00', '+'); 1260 1261 INSERT INTO products_attributes_download VALUES (26, 'unreal.zip', 7, 3); 1262 1263 INSERT INTO products_options VALUES (1,1,'Color'); 1264 INSERT INTO products_options VALUES (2,1,'Size'); 1265 INSERT INTO products_options VALUES (3,1,'Model'); 1266 INSERT INTO products_options VALUES (4,1,'Memory'); 1267 INSERT INTO products_options VALUES (1,2,'Farbe'); 1268 INSERT INTO products_options VALUES (2,2,'Größe'); 1269 INSERT INTO products_options VALUES (3,2,'Modell'); 1270 INSERT INTO products_options VALUES (4,2,'Speicher'); 1271 INSERT INTO products_options VALUES (1,3,'Color'); 1272 INSERT INTO products_options VALUES (2,3,'Talla'); 1273 INSERT INTO products_options VALUES (3,3,'Modelo'); 1274 INSERT INTO products_options VALUES (4,3,'Memoria'); 1275 INSERT INTO products_options VALUES (5, 3, 'Version'); 1276 INSERT INTO products_options VALUES (5, 2, 'Version'); 1277 INSERT INTO products_options VALUES (5, 1, 'Version'); 1278 1279 1280 INSERT INTO products_options_values VALUES (1,1,'4 mb'); 1281 INSERT INTO products_options_values VALUES (2,1,'8 mb'); 1282 INSERT INTO products_options_values VALUES (3,1,'16 mb'); 1283 INSERT INTO products_options_values VALUES (4,1,'32 mb'); 1284 INSERT INTO products_options_values VALUES (5,1,'Value'); 1285 INSERT INTO products_options_values VALUES (6,1,'Premium'); 1286 INSERT INTO products_options_values VALUES (7,1,'Deluxe'); 1287 INSERT INTO products_options_values VALUES (8,1,'PS/2'); 1288 INSERT INTO products_options_values VALUES (9,1,'USB'); 1289 INSERT INTO products_options_values VALUES (1,2,'4 MB'); 1290 INSERT INTO products_options_values VALUES (2,2,'8 MB'); 1291 INSERT INTO products_options_values VALUES (3,2,'16 MB'); 1292 INSERT INTO products_options_values VALUES (4,2,'32 MB'); 1293 INSERT INTO products_options_values VALUES (5,2,'Value Ausgabe'); 1294 INSERT INTO products_options_values VALUES (6,2,'Premium Ausgabe'); 1295 INSERT INTO products_options_values VALUES (7,2,'Deluxe Ausgabe'); 1296 INSERT INTO products_options_values VALUES (8,2,'PS/2 Anschluss'); 1297 INSERT INTO products_options_values VALUES (9,2,'USB Anschluss'); 1298 INSERT INTO products_options_values VALUES (1,3,'4 mb'); 1299 INSERT INTO products_options_values VALUES (2,3,'8 mb'); 1300 INSERT INTO products_options_values VALUES (3,3,'16 mb'); 1301 INSERT INTO products_options_values VALUES (4,3,'32 mb'); 1302 INSERT INTO products_options_values VALUES (5,3,'Value'); 1303 INSERT INTO products_options_values VALUES (6,3,'Premium'); 1304 INSERT INTO products_options_values VALUES (7,3,'Deluxe'); 1305 INSERT INTO products_options_values VALUES (8,3,'PS/2'); 1306 INSERT INTO products_options_values VALUES (9,3,'USB'); 1307 INSERT INTO products_options_values VALUES (10, 1, 'Download: Windows - English'); 1308 INSERT INTO products_options_values VALUES (10, 2, 'Download: Windows - Englisch'); 1309 INSERT INTO products_options_values VALUES (10, 3, 'Download: Windows - Inglese'); 1310 INSERT INTO products_options_values VALUES (13, 1, 'Box: Windows - English'); 1311 INSERT INTO products_options_values VALUES (13, 2, 'Box: Windows - Englisch'); 1312 INSERT INTO products_options_values VALUES (13, 3, 'Box: Windows - Inglese'); 1313 1314 INSERT INTO products_options_values_to_products_options VALUES (1,4,1); 1315 INSERT INTO products_options_values_to_products_options VALUES (2,4,2); 1316 INSERT INTO products_options_values_to_products_options VALUES (3,4,3); 1317 INSERT INTO products_options_values_to_products_options VALUES (4,4,4); 1318 INSERT INTO products_options_values_to_products_options VALUES (5,3,5); 1319 INSERT INTO products_options_values_to_products_options VALUES (6,3,6); 1320 INSERT INTO products_options_values_to_products_options VALUES (7,3,7); 1321 INSERT INTO products_options_values_to_products_options VALUES (8,3,8); 1322 INSERT INTO products_options_values_to_products_options VALUES (9,3,9); 1323 INSERT INTO products_options_values_to_products_options VALUES (10, 5, 10); 1324 INSERT INTO products_options_values_to_products_options VALUES (13, 5, 13); 1325 1326 INSERT INTO products_to_categories VALUES (1,4); 1327 INSERT INTO products_to_categories VALUES (2,4); 1328 INSERT INTO products_to_categories VALUES (3,9); 1329 INSERT INTO products_to_categories VALUES (4,10); 1330 INSERT INTO products_to_categories VALUES (5,11); 1331 INSERT INTO products_to_categories VALUES (6,10); 1332 INSERT INTO products_to_categories VALUES (7,12); 1333 INSERT INTO products_to_categories VALUES (8,13); 1334 INSERT INTO products_to_categories VALUES (9,10); 1335 INSERT INTO products_to_categories VALUES (10,10); 1336 INSERT INTO products_to_categories VALUES (11,10); 1337 INSERT INTO products_to_categories VALUES (12,10); 1338 INSERT INTO products_to_categories VALUES (13,10); 1339 INSERT INTO products_to_categories VALUES (14,15); 1340 INSERT INTO products_to_categories VALUES (15,14); 1341 INSERT INTO products_to_categories VALUES (16,15); 1342 INSERT INTO products_to_categories VALUES (17,10); 1343 INSERT INTO products_to_categories VALUES (18,10); 1344 INSERT INTO products_to_categories VALUES (19,12); 1345 INSERT INTO products_to_categories VALUES (20,15); 1346 INSERT INTO products_to_categories VALUES (21,18); 1347 INSERT INTO products_to_categories VALUES (22,19); 1348 INSERT INTO products_to_categories VALUES (23,20); 1349 INSERT INTO products_to_categories VALUES (24,20); 1350 INSERT INTO products_to_categories VALUES (25,8); 1351 INSERT INTO products_to_categories VALUES (26,9); 1352 INSERT INTO products_to_categories VALUES (27,5); 1353 1354 INSERT INTO reviews VALUES (1,19,1,'John doe',5, now(),null,0); 1355 1356 INSERT INTO reviews_description VALUES (1,1, 'this has to be one of the funniest movies released for 1999!'); 1357 1358 INSERT INTO specials VALUES (1,3, 39.99, now(), null, null, null, '1'); 1359 INSERT INTO specials VALUES (2,5, 30.00, now(), null, null, null, '1'); 1360 INSERT INTO specials VALUES (3,6, 30.00, now(), null, null, null, '1'); 1361 INSERT INTO specials VALUES (4,16, 29.99, now(), null, null, null, '1'); 1362 1363 INSERT INTO tax_class VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', now(), now()); 1364 1365 # USA/Florida 1366 INSERT INTO tax_rates VALUES (1, 1, 1, 1, 7.0, 'FL TAX 7.0%', now(), now()); 1367 INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added) VALUES (1,"Florida","Florida local sales tax zone",now()); 1368 INSERT INTO zones_to_geo_zones (association_id,zone_country_id,zone_id,geo_zone_id,date_added) VALUES (1,223,18,1,now()); 1369 1370 # USA 1371 INSERT INTO zones VALUES (1,223,'AL','Alabama'); 1372 INSERT INTO zones VALUES (2,223,'AK','Alaska'); 1373 INSERT INTO zones VALUES (3,223,'AS','American Samoa'); 1374 INSERT INTO zones VALUES (4,223,'AZ','Arizona'); 1375 INSERT INTO zones VALUES (5,223,'AR','Arkansas'); 1376 INSERT INTO zones VALUES (6,223,'AF','Armed Forces Africa'); 1377 INSERT INTO zones VALUES (7,223,'AA','Armed Forces Americas'); 1378 INSERT INTO zones VALUES (8,223,'AC','Armed Forces Canada'); 1379 INSERT INTO zones VALUES (9,223,'AE','Armed Forces Europe'); 1380 INSERT INTO zones VALUES (10,223,'AM','Armed Forces Middle East'); 1381 INSERT INTO zones VALUES (11,223,'AP','Armed Forces Pacific'); 1382 INSERT INTO zones VALUES (12,223,'CA','California'); 1383 INSERT INTO zones VALUES (13,223,'CO','Colorado'); 1384 INSERT INTO zones VALUES (14,223,'CT','Connecticut'); 1385 INSERT INTO zones VALUES (15,223,'DE','Delaware'); 1386 INSERT INTO zones VALUES (16,223,'DC','District of Columbia'); 1387 INSERT INTO zones VALUES (17,223,'FM','Federated States Of Micronesia'); 1388 INSERT INTO zones VALUES (18,223,'FL','Florida'); 1389 INSERT INTO zones VALUES (19,223,'GA','Georgia'); 1390 INSERT INTO zones VALUES (20,223,'GU','Guam'); 1391 INSERT INTO zones VALUES (21,223,'HI','Hawaii'); 1392 INSERT INTO zones VALUES (22,223,'ID','Idaho'); 1393 INSERT INTO zones VALUES (23,223,'IL','Illinois'); 1394 INSERT INTO zones VALUES (24,223,'IN','Indiana'); 1395 INSERT INTO zones VALUES (25,223,'IA','Iowa'); 1396 INSERT INTO zones VALUES (26,223,'KS','Kansas'); 1397 INSERT INTO zones VALUES (27,223,'KY','Kentucky'); 1398 INSERT INTO zones VALUES (28,223,'LA','Louisiana'); 1399 INSERT INTO zones VALUES (29,223,'ME','Maine'); 1400 INSERT INTO zones VALUES (30,223,'MH','Marshall Islands'); 1401 INSERT INTO zones VALUES (31,223,'MD','Maryland'); 1402 INSERT INTO zones VALUES (32,223,'MA','Massachusetts'); 1403 INSERT INTO zones VALUES (33,223,'MI','Michigan'); 1404 INSERT INTO zones VALUES (34,223,'MN','Minnesota'); 1405 INSERT INTO zones VALUES (35,223,'MS','Mississippi'); 1406 INSERT INTO zones VALUES (36,223,'MO','Missouri'); 1407 INSERT INTO zones VALUES (37,223,'MT','Montana'); 1408 INSERT INTO zones VALUES (38,223,'NE','Nebraska'); 1409 INSERT INTO zones VALUES (39,223,'NV','Nevada'); 1410 INSERT INTO zones VALUES (40,223,'NH','New Hampshire'); 1411 INSERT INTO zones VALUES (41,223,'NJ','New Jersey'); 1412 INSERT INTO zones VALUES (42,223,'NM','New Mexico'); 1413 INSERT INTO zones VALUES (43,223,'NY','New York'); 1414 INSERT INTO zones VALUES (44,223,'NC','North Carolina'); 1415 INSERT INTO zones VALUES (45,223,'ND','North Dakota'); 1416 INSERT INTO zones VALUES (46,223,'MP','Northern Mariana Islands'); 1417 INSERT INTO zones VALUES (47,223,'OH','Ohio'); 1418 INSERT INTO zones VALUES (48,223,'OK','Oklahoma'); 1419 INSERT INTO zones VALUES (49,223,'OR','Oregon'); 1420 INSERT INTO zones VALUES (50,223,'PW','Palau'); 1421 INSERT INTO zones VALUES (51,223,'PA','Pennsylvania'); 1422 INSERT INTO zones VALUES (52,223,'PR','Puerto Rico'); 1423 INSERT INTO zones VALUES (53,223,'RI','Rhode Island'); 1424 INSERT INTO zones VALUES (54,223,'SC','South Carolina'); 1425 INSERT INTO zones VALUES (55,223,'SD','South Dakota'); 1426 INSERT INTO zones VALUES (56,223,'TN','Tennessee'); 1427 INSERT INTO zones VALUES (57,223,'TX','Texas'); 1428 INSERT INTO zones VALUES (58,223,'UT','Utah'); 1429 INSERT INTO zones VALUES (59,223,'VT','Vermont'); 1430 INSERT INTO zones VALUES (60,223,'VI','Virgin Islands'); 1431 INSERT INTO zones VALUES (61,223,'VA','Virginia'); 1432 INSERT INTO zones VALUES (62,223,'WA','Washington'); 1433 INSERT INTO zones VALUES (63,223,'WV','West Virginia'); 1434 INSERT INTO zones VALUES (64,223,'WI','Wisconsin'); 1435 INSERT INTO zones VALUES (65,223,'WY','Wyoming'); 1436 1437 # Canada 1438 INSERT INTO zones VALUES (66,38,'AB','Alberta'); 1439 INSERT INTO zones VALUES (67,38,'BC','British Columbia'); 1440 INSERT INTO zones VALUES (68,38,'MB','Manitoba'); 1441 INSERT INTO zones VALUES (69,38,'NF','Newfoundland'); 1442 INSERT INTO zones VALUES (70,38,'NB','New Brunswick'); 1443 INSERT INTO zones VALUES (71,38,'NS','Nova Scotia'); 1444 INSERT INTO zones VALUES (72,38,'NT','Northwest Territories'); 1445 INSERT INTO zones VALUES (73,38,'NU','Nunavut'); 1446 INSERT INTO zones VALUES (74,38,'ON','Ontario'); 1447 INSERT INTO zones VALUES (75,38,'PE','Prince Edward Island'); 1448 INSERT INTO zones VALUES (76,38,'QC','Quebec'); 1449 INSERT INTO zones VALUES (77,38,'SK','Saskatchewan'); 1450 INSERT INTO zones VALUES (78,38,'YT','Yukon Territory'); 1451 1452 # Germany 1453 INSERT INTO zones VALUES (79,81,'NDS','Niedersachsen'); 1454 INSERT INTO zones VALUES (80,81,'BAW','Baden-Württemberg'); 1455 INSERT INTO zones VALUES (81,81,'BAY','Bayern'); 1456 INSERT INTO zones VALUES (82,81,'BER','Berlin'); 1457 INSERT INTO zones VALUES (83,81,'BRG','Brandenburg'); 1458 INSERT INTO zones VALUES (84,81,'BRE','Bremen'); 1459 INSERT INTO zones VALUES (85,81,'HAM','Hamburg'); 1460 INSERT INTO zones VALUES (86,81,'HES','Hessen'); 1461 INSERT INTO zones VALUES (87,81,'MEC','Mecklenburg-Vorpommern'); 1462 INSERT INTO zones VALUES (88,81,'NRW','Nordrhein-Westfalen'); 1463 INSERT INTO zones VALUES (89,81,'RHE','Rheinland-Pfalz'); 1464 INSERT INTO zones VALUES (90,81,'SAR','Saarland'); 1465 INSERT INTO zones VALUES (91,81,'SAS','Sachsen'); 1466 INSERT INTO zones VALUES (92,81,'SAC','Sachsen-Anhalt'); 1467 INSERT INTO zones VALUES (93,81,'SCN','Schleswig-Holstein'); 1468 INSERT INTO zones VALUES (94,81,'THE','Thüringen'); 1469 1470 # Austria 1471 INSERT INTO zones VALUES (95,14,'WI','Wien'); 1472 INSERT INTO zones VALUES (96,14,'NO','Niederösterreich'); 1473 INSERT INTO zones VALUES (97,14,'OO','Oberösterreich'); 1474 INSERT INTO zones VALUES (98,14,'SB','Salzburg'); 1475 INSERT INTO zones VALUES (99,14,'KN','Kärnten'); 1476 INSERT INTO zones VALUES (100,14,'ST','Steiermark'); 1477 INSERT INTO zones VALUES (101,14,'TI','Tirol'); 1478 INSERT INTO zones VALUES (102,14,'BL','Burgenland'); 1479 INSERT INTO zones VALUES (103,14,'VB','Voralberg'); 1480 1481 # Swizterland 1482 INSERT INTO zones VALUES (104,204,'AG','Aargau'); 1483 INSERT INTO zones VALUES (105,204,'AI','Appenzell Innerrhoden'); 1484 INSERT INTO zones VALUES (106,204,'AR','Appenzell Ausserrhoden'); 1485 INSERT INTO zones VALUES (107,204,'BE','Bern'); 1486 INSERT INTO zones VALUES (108,204,'BL','Basel-Landschaft'); 1487 INSERT INTO zones VALUES (109,204,'BS','Basel-Stadt'); 1488 INSERT INTO zones VALUES (110,204,'FR','Freiburg'); 1489 INSERT INTO zones VALUES (111,204,'GE','Genf'); 1490 INSERT INTO zones VALUES (112,204,'GL','Glarus'); 1491 INSERT INTO zones VALUES (113,204,'JU','Graubünden'); 1492 INSERT INTO zones VALUES (114,204,'JU','Jura'); 1493 INSERT INTO zones VALUES (115,204,'LU','Luzern'); 1494 INSERT INTO zones VALUES (116,204,'NE','Neuenburg'); 1495 INSERT INTO zones VALUES (117,204,'NW','Nidwalden'); 1496 INSERT INTO zones VALUES (118,204,'OW','Obwalden'); 1497 INSERT INTO zones VALUES (119,204,'SG','St. Gallen'); 1498 INSERT INTO zones VALUES (120,204,'SH','Schaffhausen'); 1499 INSERT INTO zones VALUES (121,204,'SO','Solothurn'); 1500 INSERT INTO zones VALUES (122,204,'SZ','Schwyz'); 1501 INSERT INTO zones VALUES (123,204,'TG','Thurgau'); 1502 INSERT INTO zones VALUES (124,204,'TI','Tessin'); 1503 INSERT INTO zones VALUES (125,204,'UR','Uri'); 1504 INSERT INTO zones VALUES (126,204,'VD','Waadt'); 1505 INSERT INTO zones VALUES (127,204,'VS','Wallis'); 1506 INSERT INTO zones VALUES (128,204,'ZG','Zug'); 1507 INSERT INTO zones VALUES (129,204,'ZH','Zürich'); 1508 1509 # Spain 1510 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'A Coruña','A Coruña'); 1511 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alava','Alava'); 1512 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Albacete','Albacete'); 1513 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alicante','Alicante'); 1514 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Almeria','Almeria'); 1515 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Asturias','Asturias'); 1516 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Avila','Avila'); 1517 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Badajoz','Badajoz'); 1518 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Baleares','Baleares'); 1519 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Barcelona','Barcelona'); 1520 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Burgos','Burgos'); 1521 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Caceres','Caceres'); 1522 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cadiz','Cadiz'); 1523 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cantabria','Cantabria'); 1524 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Castellon','Castellon'); 1525 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ceuta','Ceuta'); 1526 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ciudad Real','Ciudad Real'); 1527 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cordoba','Cordoba'); 1528 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cuenca','Cuenca'); 1529 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Girona','Girona'); 1530 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Granada','Granada'); 1531 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guadalajara','Guadalajara'); 1532 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guipuzcoa','Guipuzcoa'); 1533 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huelva','Huelva'); 1534 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huesca','Huesca'); 1535 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Jaen','Jaen'); 1536 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'La Rioja','La Rioja'); 1537 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Las Palmas','Las Palmas'); 1538 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Leon','Leon'); 1539 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lleida','Lleida'); 1540 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lugo','Lugo'); 1541 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Madrid','Madrid'); 1542 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Malaga','Malaga'); 1543 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Melilla','Melilla'); 1544 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Murcia','Murcia'); 1545 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Navarra','Navarra'); 1546 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ourense','Ourense'); 1547 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Palencia','Palencia'); 1548 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Pontevedra','Pontevedra'); 1549 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Salamanca','Salamanca'); 1550 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife'); 1551 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Segovia','Segovia'); 1552 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Sevilla','Sevilla'); 1553 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Soria','Soria'); 1554 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Tarragona','Tarragona'); 1555 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Teruel','Teruel'); 1556 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Toledo','Toledo'); 1557 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valencia','Valencia'); 1558 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valladolid','Valladolid'); 1559 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Vizcaya','Vizcaya'); 1560 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zamora','Zamora'); 1561 INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zaragoza','Zaragoza');
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Mon Nov 26 19:48:25 2007 | par Balluche grâce à PHPXref 0.7 |
|
|