OXPUS.de

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.

Hi

The must be a field (depending on your phpmyadmin-version) "Create new table on database ..."

Name: phpbb_downloads
Fields: 7

Click: GO

Then there mus be a form, where you can fill in all data for each field...

CU
Hotschi

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..

Enter this:

ALTER TABLE phpbb_users ADD user_traffic INT(255) DEFAULT 0;

Bye, SamSite