Create database table phpAdmin

[Detritus]

Hi,

Please forgive me if this information is elsewhere, I've been searching but haven't found any answers.

I've just instaled the Featured Products contribution and need to create a database table in phpAdmin.

This is the info I have:

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','Destacats', 'Mostrar Productes Destacats', '339', '1'
);

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Mostrar Productes Destacats', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Marcar Verdader (true) o Fals (false) per activar el mòdul de Productes Destacats.', '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 ('Número màxim de Productes Destacats', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'Aquest es el número màxim de productes a mostrar en la portada.', '39', '2', now(), now()
);


I have no idea how to do this and am afraid to start experimenting at this point. Any help, greatly appreciated!

[Detritus]

So simple! I figured it out and for those clueless newbies like me, simply import the text file directly usning phpAdmin and it updates the database automatically.

[red_fraggle]

or if using phpmyadmin,

1. click database name to modify on left column
2. click the "SQL" tab
3. paste the query into the "Run SQL Query/Queries on database field"
4. Click "Go"



For step 3 above the query would be the section you psated here:

 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','Destacats', 'Mostrar Productes Destacats', '339', '1'
);
 
INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Mostrar Productes Destacats', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Marcar Verdader (true) o Fals (false) per activar el mòdul de Productes Destacats.', '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 ('Número màxim de Productes Destacats', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'Aquest es el número màxim de productes a mostrar en la portada.', '39', '2', now(), now()
);

Hope this helps,