HELP Deleted a sql in database

[Jezthomp]

Was trying to remove product sort from the database but managed to remove sort_order from both:

 

configuration

configuration_group

 

HELP :'(

 

Obviously when i go to configuration in admin i get.

1054 - Unknown column 'sort_order' in 'order clause'

 

select configuration_group_id as cgID, configuration_group_title as cgTitle from configuration_group where visible = '1' order by sort_order

 

[TEP STOP]

 

Can anyone give me a sql to run or any advice, my own stupid fault.

 

Help :(

[dv8]

I think this is the bit you want

 

drop table if exists configuration;
create table configuration (
 configuration_id int(11) not null auto_increment,
 configuration_title varchar(64) not null ,
 configuration_key varchar(64) not null ,
 configuration_value varchar(255) not null ,
 configuration_description varchar(255) not null ,
 configuration_group_id int(11) default '0' not null ,
 sort_order int(5) ,
 last_modified datetime ,
 date_added datetime default '0000-00-00 00:00:00' not null ,
 use_function varchar(255) ,
 set_function varchar(255) ,
 PRIMARY KEY (configuration_id)
);