|
From: Jon O. <jon...@us...> - 2005-12-09 00:22:31
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12821/install/schemas Modified Files: mysql_schema_upgrade_to_2.8_rc5.sql mysql_schema_upgrade_to_2.8_rc7.sql Log Message: schemas and upgrade data are validated Index: mysql_schema_upgrade_to_2.8_rc5.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc5.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mysql_schema_upgrade_to_2.8_rc5.sql 20 Sep 2005 15:36:47 -0000 1.2 --- mysql_schema_upgrade_to_2.8_rc5.sql 9 Dec 2005 00:22:23 -0000 1.3 *************** *** 30,33 **** --- 30,35 ---- ALTER TABLE mx_table_block_system_parameter CHANGE bbcode_uid parameter_opt TEXT; ALTER TABLE mx_table_block_system_parameter ADD sub_id INT(255) UNSIGNED NOT NULL DEFAULT '0'; + ALTER TABLE mx_table_block_system_parameter DROP INDEX block_id; + ALTER TABLE mx_table_block_system_parameter DROP INDEX parameter_id; ALTER TABLE mx_table_block_system_parameter DROP PRIMARY KEY, ADD PRIMARY KEY (block_id, parameter_id, sub_id); *************** *** 36,41 **** # New Fields in Table `mx_page` (update for new permissions) # ! ALTER TABLE mx_table_page ADD page_desc varchar(255) default NULL; ! ALTER TABLE mx_table_page ADD auth_moderator_group varchar(255) NOT NULL default '0'; ALTER TABLE mx_table_page ADD page_graph_border varchar(255) NOT NULL default ''; --- 38,43 ---- # New Fields in Table `mx_page` (update for new permissions) # ! ALTER TABLE mx_table_page ADD page_desc varchar(255) default NULL AFTER page_name; ! ALTER TABLE mx_table_page ADD auth_moderator_group varchar(255) NOT NULL default '0' AFTER auth_view_group; ALTER TABLE mx_table_page ADD page_graph_border varchar(255) NOT NULL default ''; *************** *** 113,117 **** # ALTER TABLE mx_table_portal ADD portal_recached VARCHAR(255) BINARY NOT NULL DEFAULT ''; ! ALTER TABLE mx_table_portal ADD mx_use_cache smallint(5) unsigned NOT NULL default '1'; # --- 115,119 ---- # ALTER TABLE mx_table_portal ADD portal_recached VARCHAR(255) BINARY NOT NULL DEFAULT ''; ! ALTER TABLE mx_table_portal ADD mx_use_cache smallint(5) unsigned NOT NULL default '1' AFTER top_phpbb_links; # *************** *** 213,217 **** UPDATE mx_table_module SET module_name = 'Core Blocks', ! SET module_desc = 'mxBB Core (standard) Module', ! SET module_path = 'modules/mx_coreblocks/', ! WHERE module_id = '{module.module_id}'; \ No newline at end of file --- 215,230 ---- UPDATE mx_table_module SET module_name = 'Core Blocks', ! module_desc = 'mxBB Core (standard) Module', ! module_path = 'modules/mx_coreblocks/', ! module_include_admin = '0' ! WHERE module_id = '{module.module_id}'; ! ! # ! # Minor mistake for the textblocks ! # ! SET module = SELECT * FROM mx_table_module WHERE module_path = 'modules/mx_textblocks/'; ! ! UPDATE mx_table_module ! SET module_include_admin = '0' ! WHERE module_id = '{module.module_id}'; ! \ No newline at end of file Index: mysql_schema_upgrade_to_2.8_rc7.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc7.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** mysql_schema_upgrade_to_2.8_rc7.sql 8 Dec 2005 21:41:28 -0000 1.4 --- mysql_schema_upgrade_to_2.8_rc7.sql 9 Dec 2005 00:22:23 -0000 1.5 *************** *** 22,27 **** # ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0'; ! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0'; ! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0'; ALTER TABLE mx_table_block MODIFY auth_view_group smallint(5) NOT NULL default '0'; --- 22,27 ---- # ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0'; ! ALTER TABLE mx_table_block MODIFY auth_edit tinyint(2) NOT NULL default '0'; ! ALTER TABLE mx_table_block MODIFY auth_delete tinyint(2) NOT NULL default '0'; ALTER TABLE mx_table_block MODIFY auth_view_group smallint(5) NOT NULL default '0'; *************** *** 36,39 **** --- 36,40 ---- ALTER TABLE mx_table_page MODIFY auth_view tinyint(2) NOT NULL default '0'; ALTER TABLE mx_table_page MODIFY auth_view_group smallint(5) NOT NULL default '0'; + ALTER TABLE mx_table_page MODIFY auth_moderator_group smallint(5) NOT NULL default '0'; # ------------------------------------------------------------ |