yapLjj8S

1$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_favorite` text NOT NULL;";
2$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_subscribe` text NOT NULL;";
3$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `mf_options` text NOT NULL;";
4$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `view_topic` text NOT NULL;";
5$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `count_warning` tinyint(3) NOT NULL default '0';";
6$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `mstatus` mediumint(8) NOT NULL default '0';";
7$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `personal_title` varchar(50) NOT NULL default '';";
8$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `topics_num` smallint(5) NOT NULL default '0';";
9$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `posts_num` mediumint(7) NOT NULL default '0';";
10$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `secret_key` varchar(32) NOT NULL default '';";
11$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_twitter` varchar(200) NOT NULL default '';";
12$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_vkontakte` varchar(200) NOT NULL default '';";
13$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_skype` varchar(200) NOT NULL default '';";
14$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_sex` tinyint(2) NOT NULL default '0';";
15$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_limit_publ` tinyint(1) NOT NULL default '0';";
16$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_limit_days` smallint(4) NOT NULL default '0';";
17$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_limit_date` int(10) NOT NULL default '0';";
18$install_db[] = "CREATE INDEX mstatus ON `".$mysql_pref_userdle."_users` (mstatus);";
19
20$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_b_day` tinyint(2) NOT NULL default '0';";
21$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_b_month` tinyint(2) NOT NULL default '0';";
22$install_db[] = "ALTER TABLE `".$mysql_pref_userdle."_users` ADD `lb_b_year` smallint(4) NOT NULL default '0';";
23
24$install_db[] = "CREATE INDEX lb_b_day ON `".$mysql_pref_userdle."_users` (lb_b_day);";
25$install_db[] = "CREATE INDEX lb_b_month ON `".$mysql_pref_userdle."_users` (lb_b_month);";
26$install_db[] = "CREATE INDEX lb_b_year ON `".$mysql_pref_userdle."_users` (lb_b_year);";