Nathali Posted August 5, 2010 Posted August 5, 2010 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
Guest Posted August 8, 2010 Posted August 8, 2010 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
artful Posted August 8, 2010 Posted August 8, 2010 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
Nathali Posted August 8, 2010 Author Posted August 8, 2010 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.