[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.51, 1.52

[Jon O. <jon...@us...>]

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');
  
  # --------------------------------------------------------