Код:
<code version="1.0.0">
<installcode><![CDATA[
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microrequests_requests` (
`requestid` int(10) unsigned NOT NULL auto_increment,
`categoryid` int(10) unsigned NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`request` mediumtext,
`reply` mediumtext,
`postdate` date NOT NULL default '0000-00-00',
PRIMARY KEY (`requestid`)
) ENGINE=MyISAM
");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microrequests_categories` (
`categoryid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`introfile` varchar(100) NOT NULL default '',
`displayorder` int(11) NOT NULL default '0',
PRIMARY KEY (`categoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM
");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microrequests_opinions` (
`opinionid` int(10) unsigned NOT NULL auto_increment,
`requestid` int(10) unsigned NOT NULL default '0',
`opinion` int(1) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`opinionid`)
) ENGINE=MyISAM
");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microrequests_status` (
`statusid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`displayorder` int(11) NOT NULL default '0',
PRIMARY KEY (`statusid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM
");
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."microrequests_status` VALUES (1, 'Открыт', 1)");
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."microrequests_status` VALUES (2, 'Утвержден', 2)");
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."microrequests_status` VALUES (3, 'Реализован', 3)");
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."microrequests_status` VALUES (4, 'Отклонен', 4)");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD microrequests INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
]]></installcode>