Файл: IPBMafia.ru_IPB_3.4.6_Final_Rus _Nulled/board/upload/admin/applications/members/setup/versions/install/sql/members_mysql_tables.php
Строк: 50
<?php
/**
* Installation Schematic File
* Generated on Thu, 19 Feb 2009 08:15:47 +0000 GMT
*/
$TABLE[] = "CREATE TABLE message_posts (
msg_id int(10) NOT NULL auto_increment,
msg_topic_id int(10) NOT NULL default 0,
msg_date int(10) default NULL,
msg_post text,
msg_post_key varchar(32) NOT NULL default '0',
msg_author_id mediumint(8) NOT NULL default 0,
msg_ip_address varchar(46) NOT NULL default '0',
msg_is_first_post int(1) NOT NULL default 0,
PRIMARY KEY (msg_id),
KEY msg_topic_id (msg_topic_id),
KEY msg_date (msg_date),
KEY msg_ip_address (msg_ip_address),
KEY msg_author_id (msg_author_id)
);";
$TABLE[] = "CREATE TABLE message_topic_user_map (
map_id int(10) NOT NULL auto_increment,
map_user_id int(10) NOT NULL default 0,
map_topic_id int(10) NOT NULL default 0,
map_folder_id varchar(32) NOT NULL default '',
map_read_time int(10) NOT NULL default 0,
map_user_active int(1) NOT NULL default 0,
map_user_banned int(1) NOT NULL default 0,
map_has_unread int(1) NOT NULL default 0,
map_is_system int(1) NOT NULL default 0,
map_is_starter int(1) NOT NULL default 0,
map_left_time int(10) NOT NULL default 0,
map_ignore_notification int(1) NOT NULL default 0,
map_last_topic_reply INT(10) NOT NULL default 0,
PRIMARY KEY map_id (map_id),
UNIQUE KEY map_main (map_user_id,map_topic_id),
KEY map_user ( map_user_id , map_folder_id , map_last_topic_reply ),
KEY map_topic_id (map_topic_id)
);";
$TABLE[] = "CREATE TABLE message_topics (
mt_id int(10) NOT NULL auto_increment,
mt_date int(10) NOT NULL default 0,
mt_title varchar(255) NOT NULL default '',
mt_hasattach smallint(5) NOT NULL default 0,
mt_starter_id int(10) NOT NULL default 0,
mt_start_time int(10) NOT NULL default 0,
mt_last_post_time int(10) NOT NULL default 0,
mt_invited_members text,
mt_to_count int(3) NOT NULL default 0,
mt_to_member_id int(10) NOT NULL default 0,
mt_replies int(10) NOT NULL default 0,
mt_last_msg_id int(10) NOT NULL default 0,
mt_first_msg_id int(10) NOT NULL default 0,
mt_is_draft int(1) NOT NULL default 0,
mt_is_deleted int(1) NOT NULL default 0,
mt_is_system int(1) NOT NULL default 0,
PRIMARY KEY (mt_id),
KEY mt_date (mt_date),
KEY mt_starter_id (mt_starter_id)
);";
?>