Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Drop Tables from database, please help. thanks


Nathali

Recommended Posts

Posted

Hi,

 

I would like to remove Information Pages Unlimited Contribution.

 

Could someone help me what the syntax I should use in phpadmin to remove the contribution tables?

 

The SQL SYNTEX to install it where:

*****************************************************

-- 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);********************************************

 

Could someone please tell me the complete syntax to use? Drop tables... etc

 

Thank you in advance !

 

Best Regards :)

 

Nathali

Best Regards,

Nathali

Posted

Nathali,

 

The SQL statement you need is right in the installation SQL statement:

 

DROP TABLE IF EXISTS `information`;

DROP TABLE IF EXISTS `information_group`;

 

 

OR, you could just select the two tables from the table listing and choose delete.

 

 

 

Chris

Posted

Nathali,

 

The SQL statement you need is right in the installation SQL statement:

 

DROP TABLE IF EXISTS `information`;

DROP TABLE IF EXISTS `information_group`;

 

 

OR, you could just select the two tables from the table listing and choose delete.

 

 

 

Chris

 

 

Very true for the tables Chris, but now Nathali has to remove the configuration group and configuration values. Since there are so few entries Nathal go to your database, look in configuration group and find the group number value assigned (in the set up it idicates a value but often MYSQL will use the last avalable value so be sure to find the one(s) corresponding to your table. Note their configuration_group_id value(s) and click on them and then delete.

 

Now go to the table configuration, and click to show the values. On the top you will find configuration_id - click on it to have them all lined down in order. Then you look for the configuration_group_id numbers that the noted in the first step, verify that they have the description shown on your install sql statement and delete them. Finished!

 

One important note... be sure to have taken all the code out of your files first or you will have warnings because the tables and the configuration values no longer exist!

 

Barbara

Posted

Very true for the tables Chris, but now Nathali has to remove the configuration group and configuration values. Since there are so few entries Nathal go to your database, look in configuration group and find the group number value assigned (in the set up it idicates a value but often MYSQL will use the last avalable value so be sure to find the one(s) corresponding to your table. Note their configuration_group_id value(s) and click on them and then delete.

 

Now go to the table configuration, and click to show the values. On the top you will find configuration_id - click on it to have them all lined down in order. Then you look for the configuration_group_id numbers that the noted in the first step, verify that they have the description shown on your install sql statement and delete them. Finished!

 

One important note... be sure to have taken all the code out of your files first or you will have warnings because the tables and the configuration values no longer exist!

 

Barbara

 

 

Thank you very much Chris and Barbara for your kind replies !

 

Barbara, I was sure, according to the SQL, that there are some more values to remove except

 

DROP TABLE IF EXISTS `information`;

DROP TABLE IF EXISTS `information_group`;

 

And I didn't want to mess with that.

 

Thank you again & lovely day,

Regards,

Nathali

Best Regards,

Nathali

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...