كود:
CREATE TABLE IF NOT EXISTS `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`usertitle` char(100) NOT NULL default '',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`opentag` char(100) NOT NULL default '',
`closetag` char(100) NOT NULL default '',
`canoverride` smallint(5) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions2` int(10) unsigned NOT NULL default '0',
`genericoptions` int(10) unsigned NOT NULL default '0',
`signaturepermissions` int(10) unsigned NOT NULL default '0',
`visitormessagepermissions` int(10) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxsize` int(10) unsigned NOT NULL default '0',
`sigmaximages` smallint(5) unsigned NOT NULL default '0',
`sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
`sigmaxchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxlines` smallint(5) unsigned NOT NULL default '0',
`usercsspermissions` int(10) unsigned NOT NULL default '0',
`albumpermissions` int(10) unsigned NOT NULL default '0',
`albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxsize` int(10) unsigned NOT NULL default '0',
`albummaxpics` int(10) unsigned NOT NULL default '0',
`albummaxsize` int(10) unsigned NOT NULL default '0',
`socialgrouppermissions` int(10) unsigned NOT NULL default '0',
`pmthrottlequantity` int(10) unsigned NOT NULL default '0',
`groupiconmaxsize` int(10) unsigned NOT NULL default '0',
`maximumsocialgroups` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `usergroup`
--
INSERT INTO `usergroup` (`usergroupid`, `title`, `description`, `usertitle`, `passwordexpires`, `passwordhistory`, `pmquota`, `pmsendmax`, `opentag`, `closetag`, `canoverride`, `ispublicgroup`, `forumpermissions`, `pmpermissions`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions`, `genericpermissions2`, `genericoptions`, `signaturepermissions`, `visitormessagepermissions`, `attachlimit`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaximages`, `sigmaxsizebbcode`, `sigmaxchars`, `sigmaxrawchars`, `sigmaxlines`, `usercsspermissions`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `socialgrouppermissions`, `pmthrottlequantity`, `groupiconmaxsize`, `maximumsocialgroups`) VALUES
(1, '񾂄', '', '񾂄', 0, 0, 50, 0, '', '', 0, 0, 655421, 0, 1, 0, 0, 33554432, 0, 96, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 0),
(2, 'ãÔÊÑß ÇáÏÚã ÇáÝäí', '', 'ãÔÊÑß ÇáÏÚã ÇáÝäí', 0, 0, 50, 5, '', '', 0, 0, 12317183, 3, 63, 1, 0, 1579685063, 1, 62, 137215, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 55159, 0, 65535, 5),
(3, 'íäÊÙÑ ÇáÊÝÚíá', '', '', 0, 0, 50, 1, '', '', 0, 0, 655375, 0, 1, 0, 0, 33554499, 0, 56, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 5),
(4, '(COPPA) Users Awaiting Moderation', '', '', 0, 0, 50, 1, '', '', 0, 0, 655375, 0, 1, 0, 0, 33554499, 0, 56, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 5),
(5, 'ãÓÄÇá ÇÞÓÇã ÇáÏÚã', '', 'ãÓÄÇá ÇÞÓÇã ÇáÏÚã', 0, 0, 50, 0, '', '', 0, 0, 16777215, 7, 63, 15, 1, 1609520879, 1, 63, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(6, 'ÇÏÇÑÉ ÎÏãÉ ÓÇÚÏ', '', 'ÇÏÇÑÉ ÎÏãÉ ÓÇÚÏ', 180, 360, 50, 5, '', '', 0, 0, 16777215, 7, 63, 31, 3, 2147483583, 1, 55, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 0, 7, 0, 0, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(7, 'ÇáÏÚã ÇáÝäí', '', 'ÇáÏÚã ÇáÝäí', 0, 0, 50, 5, '', '', 0, 0, 12317183, 7, 63, 15, 0, 1609504463, 1, 62, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(8, 'Banned Users', '', 'Banned', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 0, 600, 600, 100000, 100, 0, 0, 0, 65535, 5);