|
From: Jon O. <jon...@us...> - 2008-02-10 20:58:51
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30903/schemas Modified Files: mysql_schema_install.sql Log Message: Updated. Upgrad etc http://www.mx-system.com/forum/viewtopic.php?t=10571 Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.51 retrieving revision 1.52 diff -C2 -d -r1.51 -r1.52 *** mysql_schema_install.sql 5 Feb 2008 18:37:20 -0000 1.51 --- mysql_schema_install.sql 10 Feb 2008 20:58:47 -0000 1.52 *************** *** 588,592 **** `cookie_domain` varchar(255) NOT NULL default '', ! `cookie_name` varchar(255) NOT NULL default 'mxbb28x', `cookie_path` varchar(255) NOT NULL default '/', `cookie_secure` smallint(2) unsigned NOT NULL default '0', --- 588,592 ---- `cookie_domain` varchar(255) NOT NULL default '', ! `cookie_name` varchar(255) NOT NULL default 'mxbb29x', `cookie_path` varchar(255) NOT NULL default '/', `cookie_secure` smallint(2) unsigned NOT NULL default '0', *************** *** 764,805 **** user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', - # user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - # user_timezone decimal(5,2) DEFAULT '0' NOT NULL, - # user_style tinyint(4), - # user_lang varchar(255), - # user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, - # user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - # user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - # user_last_privmsg int(11) DEFAULT '0' NOT NULL, user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_last_login_try int(11) DEFAULT '0' NOT NULL, - # user_emailtime int(11), - # user_viewemail tinyint(1), - # user_attachsig tinyint(1), - # user_allowhtml tinyint(1) DEFAULT '1', - # user_allowbbcode tinyint(1) DEFAULT '1', - # user_allowsmile tinyint(1) DEFAULT '1', - # user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, - # user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, - # user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, - # user_notify tinyint(1) DEFAULT '1' NOT NULL, - # user_notify_pm tinyint(1) DEFAULT '0' NOT NULL, - # user_popup_pm tinyint(1) DEFAULT '0' NOT NULL, - # user_rank int(11) DEFAULT '0', - # user_avatar varchar(100), - # user_avatar_type tinyint(4) DEFAULT '0' NOT NULL, user_email varchar(255), - # user_icq varchar(15), - # user_website varchar(100), - # user_from varchar(100), - # user_sig text, - # user_sig_bbcode_uid char(10), - # user_aim varchar(255), - # user_yim varchar(255), - # user_msnm varchar(255), - # user_occ varchar(100), - # user_interests varchar(255), - # user_actkey varchar(32), - # user_newpasswd varchar(32), PRIMARY KEY (user_id), KEY user_session_time (user_session_time) --- 764,770 ---- *************** *** 837,844 **** # -- Themes ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (1, 'mxSilver', 'mxSilver', 'mxSilver.css', 'internal'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (2, 'subSilver', 'subSilver', 'subSilver.css', 'phpbb2'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (3, 'subsilver2', 'subsilver2', 'subsilver2.css', 'phpbb3'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (4, 'prosilver', 'prosilver', 'prosilver.css', 'phpbb3'); # -------------------------------------------------------- --- 802,811 ---- # -- Themes ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (1, 'mxBase1', 'mxBase1', 'mxBase1.css', 'internal'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (2, 'mxBase2', 'mxBase2', 'mxBase2.css', 'internal'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (3, 'mxSilver', 'mxSilver', 'mxSilver.css', 'internal'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (4, 'subSilver', 'subSilver', 'subSilver.css', 'phpbb2'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (5, 'subsilver2', 'subsilver2', 'subsilver2.css', 'phpbb3'); ! INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (6, 'prosilver', 'prosilver', 'prosilver.css', 'phpbb3'); # -------------------------------------------------------- |