phpMyAdmin - Datenbank
Verfasst: Do Aug 23, 2001 1:44 pm
von Rici
Ich habe das Problem schon mal mit inges und Payne besprochen, aber erster ist momentan nicht mehr da und letzterer kennt das System net gut genug... vielleicht weiß ja ein anderer Rat?
Ich wollte mein Forum wieder aufbauen (phpBB), dazu brauche ich die mysql-Datenbank. Wie kann ich da eine geeignete erstellen? Hängt das mit den Tabellen da zusammen, wenn ja, wie muss ich eine einrichten, damit ein Forum möglich wird? Hoffe mal, dass mich jemand helfen kann!
phpMyAdmin - Datenbank
Verfasst: Do Aug 23, 2001 1:59 pm
von retroK
Lies mal das hier durch:
"2.0.3 Running the Installer
We have tried to make the installer as user-friendly as we possible. Open your
web browser and type in the address of your phpBB install file. For example:
http://www.yoursite.com/phpBB/install.php. If you do not have the correct file
permissions on config.php you will see an error message telling you how to
correct this. If all goes well you should see the first screen of the
installer, the database information screen. You will see that values have
been set for you, these may not work for you! They are simply there to give
you an idea of what needs to be entered. Set them to the correct values before
proceeding. Next you will see a screen that tells you the status of the
database creation, if all goes well your database has now been set-up for
phpBB. After that you will be presented with the user registration screen for
the admin user. You must fill out at least the username, password, and email
fields in this form, all the rest are optional. Next you will see the forum
wide options configuration screen. This form allows you to set-up the basic
options to be used on the forum, default values have been entered for you to
give you an idea of what data you should enter.
If all goes well you should be presented with a link to the administration
panel. Congratulations, you have just installed phpBB."
phpMyAdmin - Datenbank
Verfasst: Do Aug 23, 2001 2:00 pm
von Rici
Naja, wo man die Tables erstellt weiß ich ja, aber ich weiß nicht, was in die einzelnen Rubriken reingehört (Felder, Typ, Attribute, usw. usf.). Ansonsten brauche ich das ja nie, ich werde ja keine weiteren Tables mehr erstellen. Aber wennde meinst, dass mysql-Front dafür vielleicht besser geeignet ist, werde ich dem mal antesten!
phpMyAdmin - Datenbank
Verfasst: Do Aug 23, 2001 2:03 pm
von retroK
<BLOCKQUOTE><font size="1" face="Verdana, Arial">Code:</font><HR><pre>
$tables = array ("cat" => "CREATE TABLE catagories (
cat_id int(10) DEFAULT '0' NOT NULL auto_increment,
cat_title varchar(100),
cat_order varchar(10),
PRIMARY KEY (cat_id)
)",
"config" => "CREATE TABLE config (
config_id int(10) DEFAULT '0' NOT NULL auto_increment,
sitename varchar(100),
allow_html int(2),
allow_bbcode int(2),
allow_sig int(2),
allow_namechange int(2) DEFAULT '0',
admin_passwd varchar(32),
selected int(2) DEFAULT '0' NOT NULL,
posts_per_page int(10),
hot_threshold int(10),
topics_per_page int(10),
allow_theme_create int(10),
override_themes int(2) DEFAULT '0',
email_sig varchar(255),
email_from varchar(100),
default_lang varchar(255),
UNIQUE selected (selected),
PRIMARY KEY (config_id)
)",
"disallow" => "CREATE TABLE disallow (
disallow_id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
disallow_username varchar(50),
PRIMARY KEY(disallow_id)
)",
"forums" => "CREATE TABLE forums (
forum_id int(10) DEFAULT '0' NOT NULL auto_increment,
forum_name varchar(150),
forum_desc text,
forum_access int(10) DEFAULT '1',
forum_moderator int(10),
forum_topics int(10) NOT NULL DEFAULT '0',
forum_posts int(10) NOT NULL DEFAULT '0',
forum_last_post_id int(10) NOT NULL DEFAULT '0',
cat_id int(10),
forum_type int(10) DEFAULT '0',
KEY(forum_last_post_id),
PRIMARY KEY (forum_id)
)",
"hmf" => "CREATE TABLE headermetafooter (
header text,
meta text,
footer text
)",
"ranks" => "CREATE TABLE ranks (
rank_id int(10) DEFAULT '0' NOT NULL auto_increment,
rank_title varchar(50) NOT NULL,
rank_min int(10) NOT NULL,
rank_max int(10) NOT NULL,
rank_special int(2) DEFAULT '0',
rank_image varchar(255),
PRIMARY KEY(rank_id),
KEY (rank_min),
KEY (rank_max)
)",
"posts" => "CREATE TABLE posts (
post_id int(10) DEFAULT '0' NOT NULL auto_increment,
topic_id int(10) DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '0' NOT NULL,
poster_id int(10) NOT NULL,
post_time varchar(20),
poster_ip varchar(16),
KEY(post_id),
KEY(forum_id),
KEY(topic_id),
KEY(poster_id),
PRIMARY KEY (post_id)
)",
"posts_text" => "CREATE TABLE posts_text (
post_id int(10) NOT NULL,
post_text text,
PRIMARY KEY(post_id)
)",
"pmsg" => "CREATE TABLE priv_msgs (
msg_id int(10) DEFAULT '0' NOT NULL auto_increment,
from_userid int(10) DEFAULT '0' NOT NULL,
to_userid int(10) DEFAULT '0' NOT NULL,
msg_time varchar(20),
poster_ip varchar(16),
msg_status int(10) DEFAULT '0',
msg_text text,
PRIMARY KEY (msg_id),
KEY msg_id (msg_id),
KEY to_userid (to_userid)
)",
"sessions" => "CREATE TABLE sessions (
sess_id int(10) unsigned DEFAULT '0' NOT NULL,
user_id int(10) DEFAULT '0' NOT NULL,
start_time int(10) unsigned DEFAULT '0' NOT NULL,
remote_ip varchar(15) DEFAULT '' NOT NULL,
PRIMARY KEY (sess_id),
KEY sess_id (sess_id),
KEY start_time (start_time),
KEY remote_ip (remote_ip)
)",
"themes" => "CREATE TABLE themes (
theme_id int(10) DEFAULT '0' NOT NULL auto_increment,
theme_name varchar(35),
bgcolor varchar(10),
textcolor varchar(10),
color1 varchar(10),
color2 varchar(10),
table_bgcolor varchar(10),
header_image varchar(50),
newtopic_image varchar(50),
reply_image varchar(50),
linkcolor varchar(15),
vlinkcolor varchar(15),
theme_default int(2) DEFAULT '0',
fontface varchar(100),
fontsize1 varchar(5),
fontsize2 varchar(5),
fontsize3 varchar(5),
fontsize4 varchar(5),
tablewidth varchar(10),
replylocked_image varchar(255),
PRIMARY KEY (theme_id)
)",
"topics" => "CREATE TABLE topics (
topic_id int(10) DEFAULT '0' NOT NULL auto_increment,
topic_title varchar(100),
topic_poster int(10),
topic_time varchar(20),
topic_views int(10) DEFAULT '0' NOT NULL,
topic_replies int(10) NOT NULL DEFAULT '0',
topic_last_post_id int(10) NOT NULL,
forum_id int(10) NOT NULL,
topic_status int(10) DEFAULT '0' NOT NULL,
topic_notify int(2) DEFAULT '0',
KEY(topic_id),
KEY(forum_id),
KEY(topic_last_post_id),
PRIMARY KEY (topic_id)
)",
"users" => "CREATE TABLE users (
user_id int(10) DEFAULT '0' NOT NULL auto_increment,
username varchar(40) DEFAULT '' NOT NULL,
user_regdate varchar(20) NOT NULL,
user_password varchar(32) DEFAULT '' NOT NULL,
user_email varchar(50),
user_icq varchar(15),
user_website varchar(100),
user_occ varchar(100),
user_from varchar(100),
user_intrest varchar(150),
user_sig varchar(255),
user_viewemail tinyint(2),
user_theme int(10),
user_aim varchar(18),
user_yim varchar(25),
user_msnm varchar(25),
user_posts int(10) DEFAULT '0',
user_attachsig int(2) DEFAULT '0',
user_desmile int(2) DEFAULT '0',
user_html int(2) DEFAULT '0',
user_bbcode int(2) DEFAULT '0',
user_rank int(10) DEFAULT '0',
user_level int(10) DEFAULT '1',
user_lang varchar(255),
user_actkey varchar(32),
user_newpasswd varchar(32),
PRIMARY KEY (user_id)
)",
"online" => "CREATE TABLE whosonline (
id int(3) DEFAULT '0' NOT NULL auto_increment,
ip varchar(255),
name varchar(255),
count varchar(255),
date varchar(255),
username varchar(40),
forum int(10),
PRIMARY KEY (id)
)",
"acess" => "CREATE TABLE access (
access_id int(10) DEFAULT '0' NOT NULL auto_increment,
access_title varchar(20),
PRIMARY KEY (access_id)
)",
"smiles" => "CREATE TABLE smiles (
id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
code varchar(50),
smile_url varchar(100),
emotion varchar(75),
PRIMARY KEY(id)
)",
"words" => "CREATE TABLE words (
word_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
word varchar(100),
replacement varchar(100),
PRIMARY KEY(word_id))",
"banlist" => "CREATE TABLE banlist(
ban_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
ban_userid int(10),
ban_ip varchar(16),
ban_start int(32),
ban_end int(50),
ban_time_type int(10),
KEY(ban_id),
PRIMARY KEY(ban_id))",
"forum_mods" => "CREATE TABLE forum_mods (
forum_id int(10) NOT NULL,
user_id int(10) NOT NULL
)",
"forum_access" => "CREATE TABLE forum_access(
forum_id int(10) NOT NULL,
user_id int(10) NOT NULL,
can_post tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY(forum_id, user_id))");
</pre><HR></BLOCKQUOTE>
phpMyAdmin - Datenbank
Verfasst: Do Aug 23, 2001 5:37 pm
von Payne
Ist die Frage nun wie man eine Tabelle erstellt ? Führe mal folgenden Code in deiner Datenbank aus:
CREATE TABLE adressen (
id tinyint(4) DEFAULT '0' NOT NULL
name varchar(80),
vorname varchar(80),
email varchar(120),
kommentar text,
PRIMARY KEY (id)
);
Kannst du natürlich noch anpassen... beim PHPBB ist aber glaube ich auch eine Datei dabei, mit den nötigen Commands, um die benötigten Tabellen anzulegen.
