From 0346b9da372c4e7309dffd14a2a1c77efcf3493a Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
Date: Wed, 21 Jun 2006 05:16:08 +0000
Subject: schema! hooray!

git-svn-id: file:///svn/phpbb/trunk@6110 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 40 +++++++++++++++++-----------------
 1 file changed, 20 insertions(+), 20 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index f89f468085..fad2c457e3 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -195,9 +195,9 @@ CREATE TABLE phpbb_extension_groups (
 # Table: 'phpbb_forums'
 CREATE TABLE phpbb_forums (
   forum_id smallint(5) UNSIGNED NOT NULL auto_increment,
-  parent_id smallint(5) UNSIGNED NOT NULL,
-  left_id smallint(5) UNSIGNED NOT NULL,
-  right_id smallint(5) UNSIGNED NOT NULL,
+  parent_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL,
+  left_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL,
+  right_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL,
   forum_parents text,
   forum_name text,
   forum_desc text,
@@ -227,8 +227,8 @@ CREATE TABLE phpbb_forums (
   enable_icons tinyint(1) DEFAULT '1' NOT NULL,
   enable_prune tinyint(1) DEFAULT '0' NOT NULL,
   prune_next int(11) UNSIGNED,
-  prune_days tinyint(4) UNSIGNED NOT NULL,
-  prune_viewed tinyint(4) UNSIGNED NOT NULL,
+  prune_days tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
+  prune_viewed tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
   prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
   PRIMARY KEY (forum_id),
   KEY left_right_id (left_id, right_id),
@@ -289,9 +289,9 @@ CREATE TABLE phpbb_groups (
 CREATE TABLE phpbb_icons (
   icons_id tinyint(4) UNSIGNED NOT NULL auto_increment,
   icons_url varchar(255),
-  icons_width tinyint(4) UNSIGNED NOT NULL,
-  icons_height tinyint(4) UNSIGNED NOT NULL,
-  icons_order tinyint(4) UNSIGNED NOT NULL,
+  icons_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
+  icons_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
+  icons_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
   display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   PRIMARY KEY (icons_id)
 );
@@ -311,12 +311,12 @@ CREATE TABLE phpbb_lang (
 CREATE TABLE phpbb_log (
   log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   log_type tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
-  user_id mediumint(8) DEFAULT '0' NOT NULL,
+  user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   log_ip varchar(40) NOT NULL,
-  log_time int(11) NOT NULL,
+  log_time int(11) DEFAULT '0' NOT NULL,
   log_operation text,
   log_data text,
   PRIMARY KEY (log_id),
@@ -329,7 +329,7 @@ CREATE TABLE phpbb_log (
 
 # Table: 'phpbb_moderator_cache'
 CREATE TABLE phpbb_moderator_cache (
-  forum_id mediumint(8) UNSIGNED NOT NULL,
+  forum_id mediumint(8) DEFAULT '0' UNSIGNED NOT NULL,
   user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   username varchar(255) DEFAULT '' NOT NULL,
   group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -361,7 +361,7 @@ CREATE TABLE phpbb_modules (
 # Table: 'phpbb_poll_options'
 CREATE TABLE phpbb_poll_options (
   poll_option_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
-  topic_id mediumint(8) UNSIGNED NOT NULL,
+  topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   poll_option_text text,
   poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   KEY poll_option_id (poll_option_id),
@@ -491,7 +491,7 @@ CREATE TABLE phpbb_privmsgs_to (
 CREATE TABLE phpbb_profile_fields (
   field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   field_name varchar(255) DEFAULT '' NOT NULL,
-  field_type mediumint(8) UNSIGNED NOT NULL,
+  field_type mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   field_ident varchar(20) DEFAULT '' NOT NULL,
   field_length varchar(20) DEFAULT '' NOT NULL,
   field_minlen varchar(255) DEFAULT '' NOT NULL,
@@ -637,9 +637,9 @@ CREATE TABLE phpbb_smilies (
   code varchar(50),
   emotion varchar(50),
   smiley_url varchar(50),
-  smiley_width tinyint(4) UNSIGNED NOT NULL,
-  smiley_height tinyint(4) UNSIGNED NOT NULL,
-  smiley_order tinyint(4) UNSIGNED NOT NULL,
+  smiley_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
+  smiley_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
+  smiley_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL,
   display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   PRIMARY KEY (smiley_id)
 );
@@ -650,9 +650,9 @@ CREATE TABLE phpbb_styles (
   style_name varchar(255) DEFAULT '' NOT NULL,
   style_copyright varchar(255) DEFAULT '' NOT NULL,
   style_active tinyint(1) DEFAULT '1' NOT NULL,
-  template_id tinyint(4) UNSIGNED NOT NULL,
-  theme_id tinyint(4) UNSIGNED NOT NULL,
-  imageset_id tinyint(4) UNSIGNED NOT NULL,
+  template_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
+  theme_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
+  imageset_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
   PRIMARY KEY (style_id),
   UNIQUE style_name (style_name),
   KEY (template_id),
@@ -674,7 +674,7 @@ CREATE TABLE phpbb_styles_template (
 
 # Table: 'phpbb_styles_template_data'
 CREATE TABLE phpbb_styles_template_data (
-  template_id tinyint(4) UNSIGNED NOT NULL,
+  template_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
   template_filename varchar(100) DEFAULT '' NOT NULL,
   template_included text,
   template_mtime int(11) DEFAULT '0' NOT NULL,
-- 
cgit v1.2.1

