[mxbb-commits] core/install/schemas mysql_schema_install.sql,1.10,1.11 mysql_schema_upgrade_to_2.8_rc7.sql,1.5,1.6

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

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