1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
|
<?php
$MYSQL_HOST = 'localhost';
$MYSQL_USER = 'username';
$MYSQL_PASS = 'passwort';
$MYSQL_DATA = 'datenbankname';
$connid = @mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) OR die("Error: ".mysql_error());
mysql_select_db($MYSQL_DATA) OR die("Error: ".mysql_error());
$sql = 'CREATE TABLE `User` ('
' `ID` INT AUTO_INCREMENT NOT NULL, '
' `Autologin` VARCHAR(32) NULL, '
' `IP` VARCHAR(15) NOT NULL, '
' `SessionID` VARCHAR(32) NOT NULL, '
' `Nickname` VARCHAR(30) NOT NULL, '
' `Passwort` VARCHAR(32) NOT NULL, '
' `Email` VARCHAR(70) NOT NULL, '
' `Show_Email` BOOL NULL, '
' `Homepage` VARCHAR(70) NOT NULL, '
' `Registrierungsdatum` DATE NULL, '
' `Wohnort` VARCHAR(70) NOT NULL, '
' `ICQ` VARCHAR(20) NOT NULL, '
' `AIM` VARCHAR(70) NOT NULL, '
' `YIM` VARCHAR(70) NOT NULL, '
' `MSN` VARCHAR(70) NOT NULL, '
' `Avatar` VARCHAR(100) NOT NULL, '
' `Letzter_Login` INT NOT NULL DEFAULT \'0\', '
' `Letzte_Aktion` INT NOT NULL DEFAULT \'0\','
' PRIMARY KEY (`ID`),'
' UNIQUE (`Nickname`, `Email`)'
' )';
mysql_query($sql);
mysql_close($connid);
?> |
