diff options
| author | gpolins <gpolins@users.sourceforge.net> | 2001-08-19 22:10:39 +0000 |
|---|---|---|
| committer | gpolins <gpolins@users.sourceforge.net> | 2001-08-19 22:10:39 +0000 |
| commit | 7d408e542930fae3acac4e80df066c2bc8a885f3 (patch) | |
| tree | e76fe30d3a366c8e6e7baadf4d12e037426172c4 /phpBB/db/mysql_schema.sql | |
| parent | 5f0c024f0c4f9f6b88e2e3ac94d7c5a74e956672 (diff) | |
| download | forums-7d408e542930fae3acac4e80df066c2bc8a885f3.tar forums-7d408e542930fae3acac4e80df066c2bc8a885f3.tar.gz forums-7d408e542930fae3acac4e80df066c2bc8a885f3.tar.bz2 forums-7d408e542930fae3acac4e80df066c2bc8a885f3.tar.xz forums-7d408e542930fae3acac4e80df066c2bc8a885f3.zip | |
Added NOT NULL to 3 unique keys - mysql complained
git-svn-id: file:///svn/phpbb/trunk@908 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
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) ); |