CREATE TABLE `itens_do_site` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`nome` VARCHAR( 40 ) NOT NULL ,
`uri` VARCHAR( 40 ) NOT NULL ,
`assunto` VARCHAR( 200 ) NOT NULL ,
`texto` TEXT NOT NULL
) ENGINE = innodb;
Para php5 suar código abaixo:
ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;
ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;
ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server Host Address', 'EMAIL_SMTP_HOST_SERVER', 'smtp.mailserver.net', 'The fully qualified host name of the SMTP server.', '12', '10', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server EHLO / HELO Name', 'EMAIL_SMTP_HELO_SERVER', 'mailserver.net', 'A name to send as part of the SMTP EHLO / HELO commands. The name is typically the hostname of the machine this web site runs on.', '12', '11', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server Port Number', 'EMAIL_SMTP_PORT_SERVER', '25', 'The SMTP server port number. Port number 25 is typically used by default.', '12', '12', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Required', 'EMAIL_SMTP_ACTIVE_PASSWORD', 'false', 'Set to true when the SMTP Server requires password authentication.', '12', '13', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Username', 'EMAIL_SMTP_USERNAME', 'e-mail username', 'The e-mail username sent to the server when SMTP password authentication is required.', '12', '14', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Password', 'EMAIL_SMTP_PASSWORD', 'e-mail password', 'The e-mail password sent to the server when SMTP password authentication is required.', '12', '15', NULL, now());
DROP TABLE IF EXISTS products_extra_images;
CREATE TABLE products_extra_images (
products_extra_images_id int(11) NOT NULL auto_increment,
products_id int(11) default NULL,
products_extra_image varchar(64) default NULL,
KEY products_extra_images_id (products_extra_images_id)
) TYPE=MyISAM;
INSERT INTO configuration VALUES ('', 'Afficher Extra images (sur products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Afficher Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');
DROP TABLE IF EXISTS products_extra_images;
CREATE TABLE products_extra_images (
products_extra_images_id int(11) NOT NULL auto_increment,
products_id int(11) default NULL,
products_extra_image varchar(64) default NULL,
KEY products_extra_images_id (products_extra_images_id)
) TYPE=MyISAM;
INSERT INTO configuration VALUES ('', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server Host Address', 'EMAIL_SMTP_HOST_SERVER', 'smtp.mailserver.net', 'The fully qualified host name of the SMTP server.', '12', '10', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server EHLO / HELO Name', 'EMAIL_SMTP_HELO_SERVER', 'mailserver.net', 'A name to send as part of the SMTP EHLO / HELO commands. The name is typically the hostname of the machine this web site runs on.', '12', '11', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Server Port Number', 'EMAIL_SMTP_PORT_SERVER', '25', 'The SMTP server port number. Port number 25 is typically used by default.', '12', '12', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Required', 'EMAIL_SMTP_ACTIVE_PASSWORD', 'false', 'Set to true when the SMTP Server requires password authentication.', '12', '13', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Username', 'EMAIL_SMTP_USERNAME', 'e-mail username', 'The e-mail username sent to the server when SMTP password authentication is required.', '12', '14', NULL, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('SMTP Authentication Password', 'EMAIL_SMTP_PASSWORD', 'e-mail password', 'The e-mail password sent to the server when SMTP password authentication is required.', '12', '15', NULL, now());
|