| sabret00the |
02-21-2007 02:11 PM |
Quote:
Originally Posted by aacircle
(Post 1170370)
The install file doesn't show what tables are created. How would one go about uninstalling this product?
It would be so much better if this product didn't touch the vbulletin tables. I'm assuming from your above comments it does.
|
straight from the install file:
PHP Code:
$db->query_write("
ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `grpspermissions` INT(10) UNSIGNED DEFAULT 0 NOT NULL
");
$db->query_write("
ALTER TABLE `" . TABLE_PREFIX . "user` ADD `grps` MEDIUMTEXT NULL
");
$db->query_write("
CREATE TABLE `grps` (
`groupid` mediumint(9) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`catid` smallint(2) NOT NULL default '0',
`approved` enum('0','1') default NULL,
`create_date` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`lastpost` int(11) NOT NULL default '0',
`membercount` int(10) unsigned NOT NULL default '0',
`leaderid` int(10) default NULL,
PRIMARY KEY (`groupid`)
)
");
$db->query_write("
CREATE TABLE `grps_categories` (
`catid` tinyint(3) unsigned NOT NULL auto_increment,
`title` varchar(25) NOT NULL default '',
`description` varchar(250) default NULL,
PRIMARY KEY (`catid`)
)
");
$db->query_write("
CREATE TABLE `grps_grouptext` (
`groupid` mediumint(9) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`allowsmilie` enum('1','0') default '1',
`parseurl` enum('1','0') default '1',
`edit_reason` varchar(200) default NULL,
`edit_dateline` int(10) unsigned default NULL,
`edit_userid` tinyint(4) default NULL,
`edit_username` varchar(50) default NULL,
PRIMARY KEY (`groupid`)
)
");
$db->query_write("
CREATE TABLE `grps_post` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) NOT NULL default '0',
`groupid` mediumint(9) unsigned NOT NULL default '0',
`parentid` int(10) unsigned default NULL,
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`ipaddress` varchar(16) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`allowsmilie` enum('1','0') default NULL,
`showsignature` enum('0','1') NOT NULL default '0',
`edit_username` varchar(50) default NULL,
`edit_userid` int(10) default NULL,
`edit_reason` varchar(200) default NULL,
`edit_dateline` int(10) unsigned default NULL,
`delete_username` varchar(50) default NULL,
`delete_userid` int(10) default NULL,
`delete_reason` varchar(200) default NULL,
PRIMARY KEY (`postid`),
KEY `threadid` (`threadid`),
FULLTEXT KEY `title` (`title`,`pagetext`)
) ENGINE=MyISAM
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (1, 'Automotive', 'For groups pertaining to cars, bikes or such')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (2, 'Computers', 'For groups referring to computers, whether hardware, software or modding')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (3, 'Education', 'For groups regarding learning, whether it be help studying or school activities')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (4, 'Entertainment', 'For groups surrounding anything entertaining, visual or audio')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (5, 'Games', 'For groups surrounding games you love, digital, card or board')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (6, 'Health & Fitness', 'For groups pertaining to well-being')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (7, 'Home & Families', 'For groups regarding the home life')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (8, 'Lifestyles', 'For groups surrounding lifestyles whether it be goths, hippies, etc')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (9, 'Places & Travel', 'For groups referring to towns, cities and holidays')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (10, 'Religion & Belief', 'For groups surrounding christianity, islam, buddism, etc')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (11, 'Sports & Recreation', 'For groups referring to sports, whether it be Football, Cricket or Baseball teams')
");
$db->query_write("
INSERT INTO `grps_categories` VALUES (12, 'Others', 'For everything else')
");
$db->query_write("
CREATE TABLE `grps_setting` (
`groupid` mediumint(9) unsigned NOT NULL default '0',
`image_name` varchar(50) default NULL,
`private_posts` enum('0','1') default '0',
`moderate_members` enum('0','1') default '0',
`hidden_group` enum('0','1') default '0',
`hide_image` enum('0','1') default '0',
`edit_details` enum('1','0') default '1',
`leaderonly_threads` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`groupid`)
)
");
$db->query_write("
CREATE TABLE `grps_user` (
`recordid` mediumint(9) NOT NULL auto_increment,
`groupid` mediumint(9) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`in_mod_queue` enum('0','1') NOT NULL default '0',
`join_date` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`recordid`)
)
");
$db->query_write("
CREATE TABLE `grps_thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`groupid` int(10) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`username` varchar(250) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`dateline` varchar(15) NOT NULL default '',
`iconid` int(10) NOT NULL default '0',
`lastposterid` varchar(250) NOT NULL default '',
`lastpostdateline` varchar(250) NOT NULL default '',
`replies` int(10) NOT NULL default '0',
`firstpostid` int(10) default NULL,
`closed` enum('0','1') NOT NULL default '0',
`stuck` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `groupid` (`groupid`,`lastposterid`)
)
");
Quote:
Originally Posted by aacircle
(Post 1170370)
Does this product insert a copyright footer and if so, can it be removed?
|
with donation. |
More Information