osCommerce
Docs :: PHP Cross Reference For osCommerce 2.2 MS2
Provided By OSCdox.com
Provided By OSCdox.com
| [ Index ] | osCommerce
Docs :: PHP Cross Reference For osCommerce 2.2 MS2 Provided By OSCdox.com |
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 NOT NULL, 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) NOT NULL, 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(64) 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\'), ',