Файл: forum/forum/install-mod.php
Строк: 18
<?php
require_once '../config.php';
$align='center';
$title='Install';
//$head = text($set['head']);
head();
$db -> sql_query('DROP TABLE IF EXISTS `forum_golos`;') or die(mysql_error());
$db -> sql_query('CREATE TABLE `forum_golos`(
`id` INT( 11 ) NOT NULL auto_increment,
`tid` INT( 11 ) NOT NULL,
`question` VARCHAR( 200 ) NOT NULL,
`answer1` VARCHAR( 200 ) NOT NULL,
`answer2` VARCHAR( 200 ) NOT NULL,
`answer3` VARCHAR( 200 ) DEFAULT NULL,
`answer4` VARCHAR( 200 ) DEFAULT NULL,
`answer5` VARCHAR( 200 ) DEFAULT NULL,
`answer6` VARCHAR( 200 ) DEFAULT NULL,
`start` INT NOT NULL,
`end` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;') or die(mysql_error());
$db -> sql_query('CREATE TABLE `forum_replay`(
`id` INT( 11 ) NOT NULL auto_increment,
`gid` INT( 11 ) NOT NULL,
`uid` INT( 20 ) NOT NULL,
`replay` ENUM("1","2","3","4","5","6") NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;') or die(mysql_error());
$db -> sql_query('ALTER TABLE `users` ADD `lvisit` INT NOT NULL AFTER `rest_code` ;') or die(mysql_error())
?>
Таблица успешно создана!
<?php
foot();
?>