|
From: Jon O. <jon...@us...> - 2005-12-09 23:22:11
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9047/install/schemas Modified Files: mysql_schema_install.sql mysql_schema_upgrade_to_2.8_rc7.sql Log Message: - phpbb_stats per page - updated schemas - site search optimization (in progress) - code cleanup in index.php, common.php and page_header.php - gzip fixes in progress Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** mysql_schema_install.sql 8 Dec 2005 21:41:28 -0000 1.10 --- mysql_schema_install.sql 9 Dec 2005 23:22:03 -0000 1.11 *************** *** 394,402 **** `page_graph_border` varchar(255) NOT NULL default '', `ip_filter` varchar(255) NOT NULL default '', PRIMARY KEY (`page_id`) ); - # # Dumping data for table 'mx_table_page' --- 394,402 ---- `page_graph_border` varchar(255) NOT NULL default '', `ip_filter` varchar(255) NOT NULL default '', + `phpbb_stats` tinyint(2) NOT NULL default '-1', PRIMARY KEY (`page_id`) ); # # Dumping data for table 'mx_table_page' 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.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** mysql_schema_upgrade_to_2.8_rc7.sql 9 Dec 2005 00:22:23 -0000 1.5 --- mysql_schema_upgrade_to_2.8_rc7.sql 9 Dec 2005 23:22:03 -0000 1.6 *************** *** 37,40 **** --- 37,41 ---- 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'; + ALTER TABLE mx_table_page ADD phpbb_stats smallint(2) NOT NULL DEFAULT '-1'; # ------------------------------------------------------------ |