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`)
)
");
More Information