Файл: update/update_440/install.sql
Строк: 69
ALTER TABLE `cms_ads` CHANGE `type` `type` TINYINT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `cms_ads` CHANGE `view` `view` TINYINT UNSIGNED
NOT NULL DEFAULT '0';
ALTER TABLE `cms_ads` CHANGE `layout` `layout`
TINYINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_ads` CHANGE
`count` `count` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_ads`
CHANGE `count_link` `count_link` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER
TABLE `cms_ads` CHANGE `to` `to` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER
TABLE `cms_ads` CHANGE `color` `color` VARCHAR( 10 ) NOT NULL DEFAULT
'';
ALTER TABLE `cms_ads` CHANGE `time` `time` INT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `cms_ads` CHANGE `day` `day` INT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `cms_ads` CHANGE `mesto` `mesto` TINYINT
UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE `cms_ads`;
ALTER TABLE
`cms_album_cat` CHANGE `sort` `sort` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `cms_album_cat` CHANGE `name` `name` VARCHAR( 40 ) NOT
NULL DEFAULT '';
ALTER TABLE `cms_album_cat` CHANGE `password` `password`
VARCHAR( 20 ) NOT NULL DEFAULT '';
ALTER TABLE `cms_album_cat` CHANGE
`access` `access` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_album_cat` ADD INDEX ( `user_id` );
ALTER TABLE `cms_album_cat` ADD
INDEX ( `access` );
OPTIMIZE TABLE `cms_album_cat`;
ALTER TABLE
`cms_album_comments` DROP INDEX `module`;
ALTER TABLE `cms_album_comments`
DROP `module`;
ALTER TABLE `cms_album_comments` CHANGE `sub_id` `sub_id`
INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_album_comments` CHANGE
`user_id` `user_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_album_comments` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
OPTIMIZE TABLE `cms_album_comments`;
ALTER TABLE
`cms_album_downloads` CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `cms_album_downloads` CHANGE `file_id` `file_id`
INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_album_downloads`
CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE
`cms_album_downloads`;
ALTER TABLE `cms_album_files` CHANGE `img_name`
`img_name` VARCHAR( 100 ) NOT NULL DEFAULT '';
ALTER TABLE
`cms_album_files` CHANGE `tmb_name` `tmb_name` VARCHAR( 100 ) NOT NULL
DEFAULT '';
ALTER TABLE `cms_album_files` CHANGE `time` `time` INT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_album_files` CHANGE
`comm_count` `comm_count` INT UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE
TABLE `cms_album_files`;
ALTER TABLE `cms_album_views` CHANGE `user_id`
`user_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_album_views`
CHANGE `file_id` `file_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_album_views` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
OPTIMIZE TABLE `cms_album_views`;
ALTER TABLE `cms_album_votes`
CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_album_votes` CHANGE `file_id` `file_id` INT UNSIGNED NOT NULL DEFAULT
'0';
OPTIMIZE TABLE `cms_album_votes`;
ALTER TABLE `cms_forum_files`
CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE
`cms_forum_files` CHANGE `cat` `cat` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `cms_forum_files` CHANGE `subcat` `subcat` INT UNSIGNED
NOT NULL DEFAULT '0';
ALTER TABLE `cms_forum_files` CHANGE `topic` `topic`
INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_forum_files` CHANGE
`post` `post` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_forum_files` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `cms_forum_files` CHANGE `filetype` `filetype` TINYINT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_forum_files` CHANGE
`dlcount` `dlcount` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`cms_forum_files` CHANGE `del` `del` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT
'0';
OPTIMIZE TABLE `cms_forum_files`;
ALTER TABLE `cms_forum_rdm`
CHANGE `topic_id` `topic_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER
TABLE `cms_forum_rdm` CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `cms_forum_rdm` CHANGE `time` `time` INT UNSIGNED
NOT NULL DEFAULT '0';
OPTIMIZE TABLE `cms_forum_rdm`;
ALTER TABLE
`cms_forum_vote` CHANGE `id` `id` INT UNSIGNED NOT NULL
AUTO_INCREMENT;
ALTER TABLE `cms_forum_vote` CHANGE `time` `time` INT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_forum_vote` CHANGE `topic`
`topic` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cms_forum_vote`
CHANGE `count` `count` INT UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE
`cms_forum_vote`;
DROP TABLE IF EXISTS `cms_users_data`;
CREATE TABLE
`cms_users_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`key` varchar(30) NOT
NULL DEFAULT '',
`val` text NOT NULL,
PRIMARY KEY (`id`),
KEY
`user_id` (`user_id`),
KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
ALTER TABLE `forum` DROP INDEX `realid`;
ALTER TABLE
`forum` CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE
`forum` CHANGE `refid` `refid` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER
TABLE `forum` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `forum` CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `forum` CHANGE `close_who` `close_who` VARCHAR(
25 ) NOT NULL DEFAULT '';
ALTER TABLE `forum` CHANGE `tedit` `tedit` INT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `forum` CHANGE `kedit` `kedit`
INT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE `forum`;
ALTER
TABLE `guest` CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER
TABLE `guest` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `guest` CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL
DEFAULT '0';
ALTER TABLE `guest` CHANGE `otime` `otime` INT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `guest` CHANGE `edit_time` `edit_time` INT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `guest` CHANGE `edit_count`
`edit_count` TINYINT UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE
`guest`;
ALTER TABLE `karma_users` CHANGE `id` `id` INT UNSIGNED NOT
NULL AUTO_INCREMENT;
ALTER TABLE `karma_users` CHANGE `user_id` `user_id`
INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `karma_users` CHANGE `name`
`name` VARCHAR( 50 ) NOT NULL DEFAULT '';
ALTER TABLE `karma_users` CHANGE
`karma_user` `karma_user` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`karma_users` CHANGE `points` `points` TINYINT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `karma_users` CHANGE `type` `type` TINYINT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `karma_users` CHANGE `time` `time` INT
UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE `karma_users`;
ALTER
TABLE `lib` CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER
TABLE `lib` CHANGE `refid` `refid` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `lib` CHANGE `time` `time` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `lib` CHANGE `count` `count` INT UNSIGNED NOT NULL
DEFAULT '0';
OPTIMIZE TABLE `lib`;
ALTER TABLE `news` CHANGE `id` `id`
INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `news` CHANGE `time`
`time` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `news` CHANGE `kom`
`kom` INT UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE `news`;
ALTER
TABLE `users` CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER
TABLE `users` CHANGE `failed_login` `failed_login` TINYINT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `imname` `imname` VARCHAR( 50
) NOT NULL DEFAULT '';
ALTER TABLE `users` CHANGE `komm` `komm` INT
UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `postforum`
`postforum` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users` CHANGE
`postguest` `postguest` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE
`users` CHANGE `datereg` `datereg` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `users` CHANGE `lastdate` `lastdate` INT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `icq` `icq` INT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `skype` `skype` VARCHAR( 50 )
NOT NULL DEFAULT '';
ALTER TABLE `users` CHANGE `jabber` `jabber` VARCHAR(
50 ) NOT NULL DEFAULT '';
ALTER TABLE `users` CHANGE `live` `live`
VARCHAR( 100 ) NOT NULL DEFAULT '';
ALTER TABLE `users` CHANGE `rights`
`rights` TINYINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users` CHANGE
`sestime` `sestime` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users`
CHANGE `total_on_site` `total_on_site` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `users` CHANGE `lastpost` `lastpost` INT UNSIGNED NOT
NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `rest_code` `rest_code`
VARCHAR( 32 ) NOT NULL DEFAULT '';
ALTER TABLE `users` CHANGE `rest_time`
`rest_time` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users` CHANGE
`movings` `movings` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `users`
CHANGE `place` `place` VARCHAR( 30 ) NOT NULL DEFAULT '';
ALTER TABLE
`users` CHANGE `karma_time` `karma_time` INT UNSIGNED NOT NULL DEFAULT
'0';
ALTER TABLE `users` CHANGE `karma_off` `karma_off` TINYINT( 1 )
UNSIGNED NOT NULL DEFAULT '0';
OPTIMIZE TABLE `users`;
--
--
Структура таблицы `cms_contact`
--
DROP TABLE IF EXISTS
`cms_contact`;
CREATE TABLE IF NOT EXISTS `cms_contact` (
`id`
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10)
UNSIGNED NOT NULL DEFAULT '0',
`from_id` INT(10) UNSIGNED NOT NULL
DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
`friends` TINYINT(1)
UNSIGNED NOT NULL DEFAULT '0',
`ban` TINYINT(1) UNSIGNED NOT NULL
DEFAULT '0',
`man` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id_user` (`user_id`, `from_id`),
KEY
`time` (`time`),
KEY `ban` (`ban`)
)
ENGINE = MyISAM
DEFAULT
CHARSET = utf8;
--
-- Структура таблицы
`cms_mail`
--
DROP TABLE IF EXISTS `privat`;
DROP TABLE IF EXISTS
`cms_mail`;
CREATE TABLE IF NOT EXISTS `cms_mail` (
`id` INT(10)
UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT
NULL DEFAULT '0',
`from_id` INT(10) UNSIGNED NOT NULL DEFAULT
'0',
`text` TEXT NOT NULL,
`time` INT(10)
UNSIGNED NOT NULL DEFAULT '0',
`read` TINYINT(1) UNSIGNED NOT
NULL DEFAULT '0',
`sys` TINYINT(1) UNSIGNED NOT NULL DEFAULT
'0',
`delete` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`file_name` VARCHAR(100) NOT NULL DEFAULT '',
`count` INT(10)
NOT NULL DEFAULT '0',
`size` INT(10) NOT
NULL DEFAULT '0',
`them` VARCHAR(100) NOT NULL DEFAULT '',
`spam` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`),
KEY `user_id` (`user_id`),
KEY `from_id` (`from_id`),
KEY
`time` (`time`),
KEY `read` (`read`),
KEY `sys` (`sys`),
KEY
`delete` (`delete`)
)
ENGINE = MyISAM
DEFAULT CHARSET =
utf8;
INSERT INTO `cms_settings` (`key`, `val`) VALUES
('them_message',
''),
('setting_mail', ''),
('reg_message', ''),
('site_access',
'2');
ALTER TABLE `users` ADD `set_mail` TINYTEXT NOT NULL AFTER
`set_forum`;
ALTER TABLE `users` CHANGE `karma_plus` `karma_plus` INT
NOT NULL DEFAULT '0';
ALTER TABLE `users` CHANGE `karma_minus`
`karma_minus` INT NOT NULL DEFAULT '0';