Help please.

Enthält archivierte Beiträge von Hotschi's Board zum Download MOD.
Posten ist hier nicht möglich, bitte das Supportforum dafür verwenden!
Gesperrt
Anonymous

Help please.

Beitrag von Anonymous » Di 05.Nov, 2002 15:40

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.

Hotschi

Beitrag von Hotschi » Di 05.Nov, 2002 23:16

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

Anonymous

Beitrag von Anonymous » Mi 06.Nov, 2002 04:02

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

Anonymous

Beitrag von Anonymous » Do 07.Nov, 2002 16:28

Enter this:

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

Bye, SamSite :)

Gesperrt