[mxbb-commits] core/install/schemas mysql_schema_install.sql,1.15,1.16

[Andrew <men...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30110/install/schemas

Modified Files:
	mysql_schema_install.sql 
Log Message:
We shouldn't need those DROPs...

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** mysql_schema_install.sql	17 Dec 2005 13:10:27 -0000	1.15
--- mysql_schema_install.sql	19 Dec 2005 03:23:57 -0000	1.16
***************
*** 10,14 ****
  #
  
- DROP TABLE IF EXISTS mx_table_block;
  CREATE TABLE `mx_table_block` (
    `block_id` smallint(5) unsigned NOT NULL auto_increment,
--- 10,13 ----
***************
*** 66,70 ****
  #
  
- DROP TABLE IF EXISTS mx_table_block_system_parameter;
  CREATE TABLE `mx_table_block_system_parameter` (
    `block_id` smallint(5) unsigned NOT NULL default '0',
--- 65,68 ----
***************
*** 139,143 ****
  #
  
- DROP TABLE IF EXISTS mx_table_column;
  CREATE TABLE `mx_table_column` (
    `column_id` smallint(5) unsigned NOT NULL auto_increment,
--- 137,140 ----
***************
*** 171,175 ****
  #
  
- DROP TABLE IF EXISTS mx_table_column_block;
  CREATE TABLE `mx_table_column_block` (
    `column_id` smallint(5) NOT NULL default '0',
--- 168,171 ----
***************
*** 209,213 ****
  #
  
- DROP TABLE IF EXISTS mx_table_column_templates;
  CREATE TABLE `mx_table_column_templates` (
    `column_template_id` smallint(5) unsigned NOT NULL auto_increment,
--- 205,208 ----
***************
*** 238,242 ****
  #
  
- DROP TABLE IF EXISTS mx_table_function;
  CREATE TABLE `mx_table_function` (
    `function_id` smallint(5) unsigned NOT NULL auto_increment,
--- 233,236 ----
***************
*** 281,285 ****
  #
  
- DROP TABLE IF EXISTS mx_table_menu_categories;
  CREATE TABLE `mx_table_menu_categories` (
    `block_id` smallint(5) unsigned NOT NULL default '1',
--- 275,278 ----
***************
*** 312,316 ****
  #
  
- DROP TABLE IF EXISTS mx_table_menu_nav;
  CREATE TABLE `mx_table_menu_nav` (
    `menu_id` smallint(5) unsigned NOT NULL auto_increment,
--- 305,308 ----
***************
*** 358,362 ****
  #
  
- DROP TABLE IF EXISTS mx_table_module;
  CREATE TABLE `mx_table_module` (
    `module_id` smallint(5) unsigned NOT NULL auto_increment,
--- 350,353 ----
***************
*** 386,390 ****
  #
  
- DROP TABLE IF EXISTS mx_table_page;
  CREATE TABLE `mx_table_page` (
    `page_id` smallint(5) NOT NULL auto_increment,
--- 377,380 ----
***************
*** 417,421 ****
  #
  
- DROP TABLE IF EXISTS mx_table_page_templates;
  CREATE TABLE `mx_table_page_templates` (
    `page_template_id` smallint(3) unsigned NOT NULL auto_increment,
--- 407,410 ----
***************
*** 439,443 ****
  #
  
- DROP TABLE IF EXISTS mx_table_parameter;
  CREATE TABLE `mx_table_parameter` (
    `parameter_id` smallint(5) unsigned NOT NULL auto_increment,
--- 428,431 ----
***************
*** 511,515 ****
  #
  
- DROP TABLE IF EXISTS mx_table_portal;
  CREATE TABLE `mx_table_portal` (
    `portal_id` smallint(5) unsigned NOT NULL auto_increment,
--- 499,502 ----
***************
*** 530,534 ****
  #
  
- DROP TABLE IF EXISTS mx_table_search_results;
  CREATE TABLE `mx_table_search_results` (
    `search_id` int(11) unsigned NOT NULL default '0',
--- 517,520 ----
***************
*** 544,548 ****
  #
  
- DROP TABLE IF EXISTS mx_table_wordlist;
  CREATE TABLE `mx_table_wordlist` (
    `word_text` varchar(50) binary NOT NULL default '',
--- 530,533 ----
***************
*** 558,562 ****
  #
  
- DROP TABLE IF EXISTS mx_table_wordmatch;
  CREATE TABLE `mx_table_wordmatch` (
    `block_id` mediumint(8) unsigned NOT NULL default '0',
--- 543,546 ----