From cabcc3584b80c265905c128d34e5b9ec2a62df79 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Thu, 14 Jun 2001 16:06:45 +0000 Subject: Fixed some problems ... maybe git-svn-id: file:///svn/phpbb/trunk@493 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_basic.sql | 4 ++-- phpBB/db/mysql_schema.sql | 8 ++++---- phpBB/db/postgres_schema.sql | 8 ++++---- 3 files changed, 10 insertions(+), 10 deletions(-) (limited to 'phpBB/db') diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index e50d5a682a..ba6f7ae7f1 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -35,13 +35,13 @@ INSERT INTO phpbb_user_group (group_id, user_id) VALUES (2, 2); INSERT INTO phpbb_auth_forums (forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote) VALUES (1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); # -- User Access (admin is set as ... an admin) -INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote, auth_mod, auth_admin) VALUES (2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); +INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote, auth_mod, auth_admin) VALUES (2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); # -- Demo Topic INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_notify, topic_last_post_id) VALUES (1, 'Demo Topic', 1, NOW(), 0, 0, 1, 0, 0, 0, 1); # -- Demo Post -INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 1, NOW(), '', '127.0.0.1'); +INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 1, NOW(), '', '7F000001'); INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, 'This is the subject', 'This is a demo post in the demo topic, what do you think of it?'); # -- Themes diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 9b07973b97..599b9e263a 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -214,7 +214,7 @@ CREATE TABLE phpbb_posts ( forum_id int(10) DEFAULT '0' NOT NULL, poster_id int(10) DEFAULT '0' NOT NULL, post_time int(10) DEFAULT '0' NOT NULL, - poster_ip varchar(8) NOT NULL, + poster_ip char(8) NOT NULL, post_username varchar(30), bbcode_uid varchar(10) NOT NULL, PRIMARY KEY (post_id), @@ -251,8 +251,8 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_from_userid int(11) DEFAULT '0' NOT NULL, privmsgs_to_userid int(11) DEFAULT '0' NOT NULL, privmsgs_date int(11) DEFAULT '0' NOT NULL, - privmsgs_ip varchar(8) NOT NULL, - privmsgs_bbcode_uid int(11) DEFAULT '0' NOT NULL, + privmsgs_ip char(8) NOT NULL, + privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, PRIMARY KEY (privmsgs_id), KEY privmsgs_from_userid (privmsgs_from_userid), KEY privmsgs_to_userid (privmsgs_to_userid) @@ -321,7 +321,7 @@ DROP TABLE IF EXISTS phpbb_session_keys; CREATE TABLE phpbb_session_keys ( key_user_id int(11) DEFAULT '0' NOT NULL, - key_ip varchar(8) NOT NULL, + key_ip char(8) NOT NULL, key_login varchar(32) NOT NULL, PRIMARY KEY (key_user_id), KEY key_ip (key_ip) diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 41ddce0a67..e657fdfb51 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -238,7 +238,7 @@ CREATE TABLE phpbb_posts ( poster_id int4 DEFAULT '0' NOT NULL, post_time int4 DEFAULT '0' NOT NULL, post_username varchar(30), - poster_ip varchar(8) DEFAULT '' NOT NULL, + poster_ip char(8) DEFAULT '' NOT NULL, bbcode_uid varchar(10) DEFAULT '' NOT NULL, CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id) ); @@ -269,8 +269,8 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_from_userid int4 DEFAULT '0' NOT NULL, privmsgs_to_userid int4 DEFAULT '0' NOT NULL, privmsgs_date int4 DEFAULT '0' NOT NULL, - privmsgs_ip varchar(8) NOT NULL, - privmsgs_bbcode_uid int4 DEFAULT '0' NOT NULL, + privmsgs_ip char(8) NOT NULL, + privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) ); CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); @@ -326,7 +326,7 @@ CREATE INDEX session_id_ip_user_id ON phpbb_session (session_id, session_ip, ses -------------------------------------------------------- */ CREATE TABLE phpbb_session_keys ( key_user_id int4 DEFAULT '0' NOT NULL, - key_ip varchar(8) DEFAULT '' NOT NULL, + key_ip char(8) DEFAULT '' NOT NULL, key_login varchar(32) DEFAULT '' NOT NULL, CONSTRAINT phpbb_session_keys_pkey PRIMARY KEY (key_user_id) ); -- cgit v1.2.1