Product Tables Php Myadmin

[Spots]

Hi, i need to make this table...

 

create table featured (
 featured_id int(11) not null auto_increment,
 products_id int(11) default '0' not null ,
 featured_date_added datetime ,
 featured_last_modified datetime ,
 expires_date datetime ,
 date_status_change datetime ,
 status int(1) default '1' ,
 PRIMARY KEY (featured_id)
);

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('39','Featured', 'Featured Products Display', '339', '1'
);

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Display Featured Products', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Set to true or false in order to display featured.', '39', '1', now(), now()
);

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Maximum Display of Featured', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'This is the maximum amount of items to display on the front page.', '39', '2', now(), now()
);

 

for the featured products contribution. So i need to make a table with 8 lines right? I put "featured_id int(11)" as the title..but what do i put for the "length"? And do i call everything varchar? Please help if you are familar with this...I have no idea what i'm doin on this part. Thanks ever so much

[ozcsys]

Go to phpmyadmin, choose your database and then click on the sql tab. You will see a text area to paste your sql code to, copy and paste it then click go. Your changes will be done for you.

 

Of course it goes without saying that you are going to backup your database in the osC admin before making any changes.

[Spots]

that was awesome...thanks richard!