Remove sql lines

[KJ666]

Right im learning lots from this website but now i would like to know, How do you go about moving things you placed in sql ??

I have a add on which i dont want any more but it leaves stuff in the admin area. This add on (http://addons.oscommerce.com/info/1026)

This is what i added:

 

-- 
-- Table structure for table `information`
-- 

DROP TABLE IF EXISTS `information`;
CREATE TABLE `information` (
 `information_id` tinyint(3) unsigned NOT NULL auto_increment,
 `information_group_id` int(11) unsigned NOT NULL default '0',
 `information_title` varchar(255) NOT NULL default '',
 `information_description` text NOT NULL,
 `parent_id` int(11) default NULL,
 `sort_order` tinyint(3) unsigned NOT NULL default '0',
 `visible` enum('1','0') NOT NULL default '1',
 `language_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`information_id`,`language_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

-- 
-- Table structure for table `information_group`
-- 

DROP TABLE IF EXISTS `information_group`;
CREATE TABLE `information_group` (
 `information_group_id` int(11) NOT NULL auto_increment,
 `information_group_title` varchar(64) NOT NULL default '',
 `information_group_description` varchar(255) NOT NULL default '',
 `sort_order` int(5) default NULL,
 `visible` int(1) default '1',
 `locked` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`information_group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

-- 
-- Dumping data for table `information_group`
-- 

INSERT INTO `information_group` (`information_group_id`, `information_group_title`, `information_group_description`, `sort_order`, `visible`, `locked`) VALUES (1, 'Information pages', 'Information pages', 1, 1, '');


INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES
('16', 'HTML-Editor', 'HTML-Editor Optionen', 16, 1);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
(1182, 'FCKeditor verwenden', 'DESCRIPTION_EDITOR', 'true', 'Soll der HTML-Editor für Beschreibungen benutzt werden?', 16, 1, '2008-03-20 22:40:05', '2007-05-13 06:37:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'),
(1183, 'Höhe FCKeditor', 'FCK_EDITOR_HEIGHT', '600', 'Höhe der Eingabefelder in Pixel bei Verwendung des FCK-Editors.', 16, 2, '2007-12-17 01:08:56', '2007-05-13 06:37:14', NULL, NULL);

[Jan Zonjee]

How do you go about moving things you placed in sql ??

Do the opposite of the commands :)

-- 
DROP TABLE IF EXISTS `information`;
DROP TABLE IF EXISTS `information_group`;

// change "insert into" into "delete from" 
// for inspiration see any shipping, payment, order_total module: install an remove functions

DELETE FROM `configuration_group`where configuration_group_id = '16';

DELETE FROM `configuration` where configuration_key IN ( 'DESCRIPTION_EDITOR', 'FCK_EDITOR_HEIGHT');