Menu
▾
▴
[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.9.0.sql, NONE, 1.1 mysql_schema_upgrade_to_2.9.1.sql, NONE, 1.1 mysql_schema_install.sql, 1.42, 1.43 upgrade_schemas_map.php, 1.20, 1.21
|
From: Jon O. <jon...@us...> - 2007-09-09 16:49:14
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9080/schemas Modified Files: mysql_schema_install.sql upgrade_schemas_map.php Added Files: mysql_schema_upgrade_to_2.9.0.sql mysql_schema_upgrade_to_2.9.1.sql Log Message: Ok, massive update for 2.9.x. Index: upgrade_schemas_map.php =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v retrieving revision 1.20 retrieving revision 1.21 diff -C2 -d -r1.20 -r1.21 *** upgrade_schemas_map.php 23 Jul 2007 21:36:43 -0000 1.20 --- upgrade_schemas_map.php 9 Sep 2007 16:49:08 -0000 1.21 *************** *** 20,23 **** --- 20,25 ---- array('schema' => 'upgrade_to_2.8.0' , 'sql' => "SELECT override_user_style FROM mx_table_portal"), array('schema' => 'upgrade_to_2.8.1' , 'sql' => "SELECT portal_status FROM mx_table_portal"), + array('schema' => 'upgrade_to_2.9.0' , 'sql' => "SELECT portal_desc FROM mx_table_portal"), + array('schema' => 'upgrade_to_2.9.1' , 'sql' => "SELECT themes_id FROM mx_table_themes"), ); --- NEW FILE: mysql_schema_upgrade_to_2.9.0.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.9.0" # # $Id: mysql_schema_upgrade_to_2.9.0.sql,v 1.1 2007/09/09 16:49:08 jonohlsson Exp $ # # # Table structure for table 'mx_table_user_group' # CREATE TABLE mx_table_user_group ( group_id mediumint(8) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, user_pending tinyint(1), KEY group_id (group_id), KEY user_id (user_id) ); # # Table structure for table 'mx_table_groups' # CREATE TABLE mx_table_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator mediumint(8) DEFAULT '0' NOT NULL, group_single_user tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ); # -------------------------------------------------------- # # Table structure for table 'mx_table_sessions' # # Note that if you\'re running 3.23.x you may want to make # this table a type HEAP. This type of table is stored # within system memory and therefore for big busy boards # is likely to be noticeably faster than continually # writing to disk ... # CREATE TABLE mx_table_sessions ( session_id char(32) DEFAULT '' NOT NULL, session_user_id mediumint(8) DEFAULT '0' NOT NULL, session_start int(11) DEFAULT '0' NOT NULL, session_time int(11) DEFAULT '0' NOT NULL, session_ip char(8) DEFAULT '0' NOT NULL, session_page int(11) DEFAULT '0' NOT NULL, session_logged_in tinyint(1) DEFAULT '0' NOT NULL, session_admin tinyint(2) DEFAULT '0' NOT NULL, PRIMARY KEY (session_id), KEY session_user_id (session_user_id), KEY session_id_ip_user_id (session_id, session_ip, session_user_id) ); # -------------------------------------------------------- # # Table structure for table `mx_table_sessions_keys` # CREATE TABLE mx_table_sessions_keys ( key_id varchar(32) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, last_ip varchar(8) DEFAULT '0' NOT NULL, last_login int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (key_id, user_id), KEY last_login (last_login) ); # -------------------------------------------------------- # # Table structure for table 'mx_table_users' # CREATE TABLE mx_table_users ( user_id mediumint(8) NOT NULL, user_active tinyint(1) DEFAULT '1', username varchar(25) NOT NULL, user_password varchar(32) NOT NULL, user_session_time int(11) DEFAULT '0' NOT NULL, user_session_page smallint(5) DEFAULT '0' NOT NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, 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) ); # -- Users INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', 0); # -- username: admin password: admin (change this or remove it once everything is working!) INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', 1); # -- Groups INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1); INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1); # -- User -> Group INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0); INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); # ------------------------------------------------------------ # # New Fields in Table `mx_portal` # ALTER TABLE mx_table_portal ADD portal_desc varchar(255) NOT NULL default 'A _little_ text to describe your site'; ALTER TABLE mx_table_portal ADD server_name varchar(255) NOT NULL default 'www.myserver.tld'; ALTER TABLE mx_table_portal ADD script_path varchar(255) NOT NULL default '/'; ALTER TABLE mx_table_portal ADD script_protocol varchar(255) NOT NULL default 'http://'; ALTER TABLE mx_table_portal ADD server_port varchar(255) NOT NULL default '80'; ALTER TABLE mx_table_portal ADD default_dateformat varchar(255) NOT NULL default 'D M d, Y g:i a'; ALTER TABLE mx_table_portal ADD board_timezone smallint(2) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD gzip_compress smallint(2) unsigned NOT NULL default '0'; ALTER TABLE mx_table_portal ADD cookie_domain varchar(255) NOT NULL default ''; ALTER TABLE mx_table_portal ADD cookie_name varchar(255) NOT NULL default 'mxbb28x'; ALTER TABLE mx_table_portal ADD cookie_path varchar(255) NOT NULL default '/'; ALTER TABLE mx_table_portal ADD cookie_secure smallint(2) unsigned NOT NULL default '0'; ALTER TABLE mx_table_portal ADD session_length varchar(255) NOT NULL default '3600'; ALTER TABLE mx_table_portal ADD allow_autologin smallint(2) unsigned NOT NULL default '1'; ALTER TABLE mx_table_portal ADD max_autologin_time smallint(2) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD max_login_attempts smallint(2) NOT NULL default '5'; ALTER TABLE mx_table_portal ADD login_reset_time varchar(255) NOT NULL default '30'; ALTER TABLE mx_table_portal ADD default_lang varchar(255) NOT NULL default 'english'; ALTER TABLE mx_table_portal ADD allow_html smallint(2) unsigned NOT NULL default '1'; ALTER TABLE mx_table_portal ADD allow_html_tags varchar(255) NOT NULL default 'b,i,u,pre'; ALTER TABLE mx_table_portal ADD allow_bbcode smallint(2) unsigned NOT NULL default '1'; ALTER TABLE mx_table_portal ADD allow_smilies smallint(2) unsigned NOT NULL default '1'; ALTER TABLE mx_table_portal ADD smilies_path varchar(255) NOT NULL default 'images/smiles'; ALTER TABLE mx_table_portal ADD board_email varchar(255) NOT NULL default 'you...@yo...'; ALTER TABLE mx_table_portal ADD board_email_sig varchar(255) NOT NULL default 'Thanks, the mxBB Team'; ALTER TABLE mx_table_portal ADD smtp_delivery smallint(2) unsigned NOT NULL default '0'; ALTER TABLE mx_table_portal ADD smtp_host varchar(255) NOT NULL default ''; ALTER TABLE mx_table_portal ADD smtp_username varchar(255) NOT NULL default ''; ALTER TABLE mx_table_portal ADD smtp_password varchar(255) NOT NULL default ''; ALTER TABLE mx_table_portal ADD smtp_auth_method varchar(255) NOT NULL default ''; ALTER TABLE mx_table_portal ADD portal_startdate varchar(255) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD rand_seed varchar(255) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD record_online_users varchar(255) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD record_online_date varchar(255) NOT NULL default '0'; ALTER TABLE mx_table_portal ADD portal_backend_path varchar(255) NOT NULL default ''; # Remove from mx_table_portal # Help?? # ALTER TABLE mx_table_portal DELETE portal_url; # ALTER TABLE mx_table_portal DELETE portal_phpbb_url; --- NEW FILE: mysql_schema_upgrade_to_2.9.1.sql --- # -------------------------------------------------------- # # Table structure for table 'mx_table_themes' # CREATE TABLE mx_table_themes ( themes_id mediumint(8) UNSIGNED NOT NULL auto_increment, template_name varchar(30) NOT NULL default '', style_name varchar(30) NOT NULL default '', head_stylesheet varchar(100) default NULL, portal_backend varchar(30) NOT NULL default '', PRIMARY KEY (themes_id) ); # -- 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'); Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.42 retrieving revision 1.43 diff -C2 -d -r1.42 -r1.43 *** mysql_schema_install.sql 12 Aug 2007 20:54:45 -0000 1.42 --- mysql_schema_install.sql 9 Sep 2007 16:49:08 -0000 1.43 *************** *** 59,62 **** --- 59,63 ---- INSERT INTO mx_table_block VALUES("29", "Demo Pages", "Introduction", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144407996", "2"); INSERT INTO mx_table_block VALUES("30", "Modules Info", "Introduction", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144407795", "2"); + INSERT INTO mx_table_block VALUES("31", "Page Navigation", "This is a page navigation menu", "52", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1144406422", "2"); *************** *** 104,107 **** --- 105,113 ---- INSERT INTO mx_table_block_system_parameter VALUES("25", "64", "TRUE", "", "0"); + INSERT INTO mx_table_block_system_parameter VALUES("31", "100", "", "", "0"); + INSERT INTO mx_table_block_system_parameter VALUES("31", "101", "Overall_navigation", "", "0"); + INSERT INTO mx_table_block_system_parameter VALUES("31", "102", "Horizontal", "", "0"); + INSERT INTO mx_table_block_system_parameter VALUES("31", "103", "TRUE", "", "0"); + INSERT INTO mx_table_block_system_parameter VALUES("9", "50", "This is basically a [i:021a122fa6]standard[/i:021a122fa6] TextBlock, but you may configure settings for bbcodes, html and smilies for [i:021a122fa6]this[/i:021a122fa6] block.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "021a122fa6", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "51", "none", "", "0"); *************** *** 439,443 **** # INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "0", "", "10","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); ! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "0", "", "20","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1"); INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "0", "", "30","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "0", "", "40","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); --- 445,449 ---- # INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "0", "", "10","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); ! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "0", "", "20","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "overall_header_navigation_phpbb.tpl", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1"); INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "0", "", "30","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "0", "", "40","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); *************** *** 564,586 **** DROP TABLE IF EXISTS mx_table_portal; CREATE TABLE `mx_table_portal` ( ! `portal_id` smallint(5) unsigned NOT NULL auto_increment, ! `portal_name` varchar(150) default NULL, ! `portal_phpbb_url` varchar(255) default 'http://www.phpbb.com/phpBB/', ! `portal_url` varchar(255) default NULL, ! `portal_version` varchar(255) default NULL, ! `default_admin_style` smallint(5) NOT NULL default '-1', `default_style` smallint(5) NOT NULL default '-1', ! `override_user_style` smallint(2) NOT NULL default '1', ! `overall_header` varchar(255) default 'overall_header.tpl', ! `overall_footer` varchar(255) default 'overall_footer.tpl', ! `main_layout` varchar(255) default 'mx_main_layout.tpl', ! `navigation_block` smallint(5) unsigned NOT NULL default '0', ! `top_phpbb_links` smallint(5) unsigned NOT NULL default '0', ! `mx_use_cache` smallint(5) unsigned NOT NULL default '1', `portal_recached` varchar(255) NOT NULL default '', ! `mod_rewrite` smallint(2) NOT NULL default '0', ! `portal_backend` varchar(255) default 'phpBB2', ! `portal_status` smallint(2) NOT NULL default '1', ! `disabled_message` varchar(255) default 'We are currenty upgrading this site with latest mxBB software.', PRIMARY KEY (`portal_id`) ) TYPE=MyISAM; --- 570,632 ---- DROP TABLE IF EXISTS mx_table_portal; CREATE TABLE `mx_table_portal` ( ! `portal_id` smallint(2) unsigned NOT NULL auto_increment, ! ! `portal_name` varchar(255) NOT NULL default 'yourdomain.com', ! `portal_desc` varchar(255) NOT NULL default 'A _little_ text to describe your site', ! `portal_status` smallint(2) unsigned NOT NULL default '1', ! `disabled_message` varchar(255) NOT NULL default 'We are currenty upgrading this site with latest mxBB software.', ! `server_name` varchar(255) NOT NULL default 'www.myserver.tld', ! `script_path` varchar(255) NOT NULL default '/', ! `script_protocol` varchar(255) NOT NULL default 'http://', ! `server_port` varchar(255) NOT NULL default '80', ! `default_dateformat` varchar(255) NOT NULL default 'D M d, Y g:i a', ! `board_timezone` smallint(2) NOT NULL default '0', ! `gzip_compress` smallint(2) unsigned NOT NULL default '0', ! `mx_use_cache` smallint(2) unsigned NOT NULL default '1', ! `mod_rewrite` smallint(2) unsigned NOT NULL default '0', ! ! `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', ! `session_length` varchar(255) NOT NULL default '3600', ! `allow_autologin` smallint(2) unsigned NOT NULL default '1', ! `max_autologin_time` smallint(2) NOT NULL default '0', ! `max_login_attempts` smallint(2) NOT NULL default '5', ! `login_reset_time` varchar(255) NOT NULL default '30', ! ! `default_lang` varchar(255) NOT NULL default 'english', `default_style` smallint(5) NOT NULL default '-1', ! `override_user_style` smallint(2) unsigned NOT NULL default '1', ! `default_admin_style` smallint(5) NOT NULL default '-1', ! `overall_header` varchar(255) NOT NULL default 'overall_header_navigation.tpl', ! `overall_footer` varchar(255) NOT NULL default 'overall_footer.tpl', ! `main_layout` varchar(255) NOT NULL default 'mx_main_layout.tpl', ! `navigation_block` smallint(5) unsigned NOT NULL default '31', ! `top_phpbb_links` smallint(2) unsigned NOT NULL default '0', ! `allow_html` smallint(2) unsigned NOT NULL default '1', ! `allow_html_tags` varchar(255) NOT NULL default 'b,i,u,pre', ! `allow_bbcode` smallint(2) unsigned NOT NULL default '1', ! `allow_smilies` smallint(2) unsigned NOT NULL default '1', ! `smilies_path` varchar(255) NOT NULL default 'images/smiles', ! ! `board_email` varchar(255) NOT NULL default 'you...@yo...', ! `board_email_sig` varchar(255) NOT NULL default 'Thanks, the mxBB Team', ! `smtp_delivery` smallint(2) unsigned NOT NULL default '0', ! `smtp_host` varchar(255) NOT NULL default '', ! `smtp_username` varchar(255) NOT NULL default '', ! `smtp_password` varchar(255) NOT NULL default '', ! `smtp_auth_method` varchar(255) NOT NULL default '', ! ! `portal_version` varchar(255) NOT NULL default '', `portal_recached` varchar(255) NOT NULL default '', ! `portal_backend` varchar(255) NOT NULL default 'internal', ! `portal_backend_path` varchar(255) NOT NULL default '', ! ! `portal_startdate` varchar(255) NOT NULL default '0', ! `rand_seed` varchar(255) NOT NULL default '0', ! `record_online_users` varchar(255) NOT NULL default '0', ! `record_online_date` varchar(255) NOT NULL default '0', ! PRIMARY KEY (`portal_id`) ) TYPE=MyISAM; *************** *** 631,632 **** --- 677,830 ---- ) TYPE=MyISAM; + # + # Table structure for table 'mx_table_user_group' + # + CREATE TABLE mx_table_user_group ( + group_id mediumint(8) DEFAULT '0' NOT NULL, + user_id mediumint(8) DEFAULT '0' NOT NULL, + user_pending tinyint(1), + KEY group_id (group_id), + KEY user_id (user_id) + ); + + # + # Table structure for table 'mx_table_groups' + # + CREATE TABLE mx_table_groups ( + group_id mediumint(8) NOT NULL auto_increment, + group_type tinyint(4) DEFAULT '1' NOT NULL, + group_name varchar(40) NOT NULL, + group_description varchar(255) NOT NULL, + group_moderator mediumint(8) DEFAULT '0' NOT NULL, + group_single_user tinyint(1) DEFAULT '1' NOT NULL, + PRIMARY KEY (group_id), + KEY group_single_user (group_single_user) + ); + + # -------------------------------------------------------- + # + # Table structure for table 'mx_table_sessions' + # + # Note that if you\'re running 3.23.x you may want to make + # this table a type HEAP. This type of table is stored + # within system memory and therefore for big busy boards + # is likely to be noticeably faster than continually + # writing to disk ... + # + CREATE TABLE mx_table_sessions ( + session_id char(32) DEFAULT '' NOT NULL, + session_user_id mediumint(8) DEFAULT '0' NOT NULL, + session_start int(11) DEFAULT '0' NOT NULL, + session_time int(11) DEFAULT '0' NOT NULL, + session_ip char(8) DEFAULT '0' NOT NULL, + session_page int(11) DEFAULT '0' NOT NULL, + session_logged_in tinyint(1) DEFAULT '0' NOT NULL, + session_admin tinyint(2) DEFAULT '0' NOT NULL, + PRIMARY KEY (session_id), + KEY session_user_id (session_user_id), + KEY session_id_ip_user_id (session_id, session_ip, session_user_id) + ); + + # -------------------------------------------------------- + # + # Table structure for table `mx_table_sessions_keys` + # + CREATE TABLE mx_table_sessions_keys ( + key_id varchar(32) DEFAULT '0' NOT NULL, + user_id mediumint(8) DEFAULT '0' NOT NULL, + last_ip varchar(8) DEFAULT '0' NOT NULL, + last_login int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (key_id, user_id), + KEY last_login (last_login) + ); + + # -------------------------------------------------------- + # + # Table structure for table 'mx_table_users' + # + CREATE TABLE mx_table_users ( + user_id mediumint(8) NOT NULL, + user_active tinyint(1) DEFAULT '1', + username varchar(25) NOT NULL, + user_password varchar(32) NOT NULL, + user_session_time int(11) DEFAULT '0' NOT NULL, + user_session_page smallint(5) DEFAULT '0' NOT NULL, + user_lastvisit int(11) DEFAULT '0' NOT NULL, + 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) + ); + + # -- Users + INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', 0); + + # -- username: admin password: admin (change this or remove it once everything is working!) + INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', 1); + + # -- Groups + INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1); + INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1); + + + # -- User -> Group + INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0); + INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); + + # -------------------------------------------------------- + # + # Table structure for table 'mx_table_themes' + # + CREATE TABLE mx_table_themes ( + themes_id mediumint(8) UNSIGNED NOT NULL auto_increment, + template_name varchar(30) NOT NULL default '', + style_name varchar(30) NOT NULL default '', + head_stylesheet varchar(100) default NULL, + portal_backend varchar(30) NOT NULL default '', + PRIMARY KEY (themes_id) + ); + + # -- 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'); + |
