From 7d408e542930fae3acac4e80df066c2bc8a885f3 Mon Sep 17 00:00:00 2001
From: gpolins <gpolins@users.sourceforge.net>
Date: Sun, 19 Aug 2001 22:10:39 +0000
Subject: Added NOT NULL to 3 unique keys - mysql complained
git-svn-id: file:///svn/phpbb/trunk@908 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/mysql_schema.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
(limited to 'phpBB')
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index c763d4cc2b..b93ee2500b 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -63,8 +63,8 @@ CREATE TABLE phpbb_groups (
DROP TABLE IF EXISTS phpbb_banlist;
CREATE TABLE phpbb_banlist (
ban_id int(11) NOT NULL auto_increment,
- ban_userid int(11),
- ban_ip char(8),
+ ban_userid int(11) NOT NULL,
+ ban_ip char(8) NOT NULL,
ban_email varchar(255),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
@@ -79,7 +79,7 @@ DROP TABLE IF EXISTS phpbb_categories;
CREATE TABLE phpbb_categories (
cat_id int(11) NOT NULL auto_increment,
cat_title varchar(100),
- cat_order int(11),
+ cat_order int(11) NOT NULL,
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
);
--
cgit v1.2.1