Guten Tag,
Can someone teach me how to create the tables? as like i see this but don't know what commands i should input in phpmyadmin..
## Creating table
#########################
##
## Name: "phpbb_downloads"
## Fields: "id" int(11) auto_increment, primary key
## "description" varchar(255)
## "file_name" varchar(255)
## "klicks" int(11), Standard "0"
## "free" tinyint(1), Standard "0"
## "long_desc" text
## "sort" int(11), Standard "0"
##
########################
I can't speak German, so it would be nice if the reply was in English.
Thanks in Advance.
Help please.
I couldn't find the create new table option but i saw the other post and i used the same SQL command and did this..
Code:
#
# Tabellenstruktur für Tabelle `phpBB_downloads`
#
DROP TABLE IF EXISTS phpBB_downloads;
CREATE TABLE phpBB_downloads (
id int(11) NOT NULL auto_increment,
description varchar(255) NOT NULL default '',
file_name varchar(255) NOT NULL default '',
klicks varchar(255) NOT NULL default '0',
free tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
it works fine now..
BUT how do I do the same for
## Modifying table "phpbb_users"
#########################
##
## New column: "user_traffic" int(255) Standard: "0"
##
########################
?
What SQL command should I enter?
Thanks..
Code:
#
# Tabellenstruktur für Tabelle `phpBB_downloads`
#
DROP TABLE IF EXISTS phpBB_downloads;
CREATE TABLE phpBB_downloads (
id int(11) NOT NULL auto_increment,
description varchar(255) NOT NULL default '',
file_name varchar(255) NOT NULL default '',
klicks varchar(255) NOT NULL default '0',
free tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
it works fine now..
BUT how do I do the same for
## Modifying table "phpbb_users"
#########################
##
## New column: "user_traffic" int(255) Standard: "0"
##
########################
?
What SQL command should I enter?
Thanks..