Editing Database

[martinstan]

Hi

I've found a couple of contributions that require editing the actual database. I've never done this before. Is there a tutorial around for this? Is it easy? Here are a couple of examples:

alter table products add disable_addtobasket enum('Y','N') DEFAULT 'N';
insert into configuration
(configuration_title
,configuration_key
,configuration_value
,configuration_description
,configuration_group_id
,sort_order
,last_modified
,date_added
,use_function
,set_function)
values
('Default Status for Shopping Cart and Buy Now buttons'
, 'DISABLE_ADDTOBASKET'
,'Y'
, 'Set to Y to enable Shopping Cart and Buy Now buttons by default. Set to N to disable Shopping Cart and Buy now buttons by default.'
, 8
, 0
, null
, sysdate()
, null
, null);

 

and

 

In the database, add the following field to the PRODUCTS table:
in_store_only tinyint(1) Not Null Default 0

 

Many thanks

[bill110]

For the first one go to your hosts phpmyadmin and select your database.

at the top of the page there should be a list of tabs like Structure Sql Export etc..

click SQL

Copy and paste the code in the query box overwriting anything that may default there.

Then click GO.

 

For the second one click on the Products table in thwe left column that displays all the tables.

At the bottom of the list of tables you will see an area that says something like Propose table structure and below that it says Add 1 field and you can choose at end of table. click the go button.

A box opens so you can enter the data

Field=in_store_only

Type= select tinyint from drop down

Length=1

leave collation and attributes blank

select not null

leave default as 0

[martinstan]

Thanks for your quick reply Bill. Sounds err easy ;)