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:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
|
CREATE TABLE bb2_users (
userid int(11) unsigned NOT NULL auto_increment,
username varchar(50) NULL,
password varchar(50) NULL,
sha1_password varchar(40) NULL,
email varchar(150) NULL,
userposts mediumint(7) unsigned NULL DEFAULT '43'
groupcombinationid int(11) unsigned NULL DEFAULT '43'
rankid int(11) unsigned NULL DEFAULT '43'
title varchar(50) NULL,
regdate int(11) unsigned NULL DEFAULT '43'
lastvisit int(11) unsigned NULL DEFAULT '43'
lastactivity int(11) unsigned NULL DEFAULT '43'
usertext text NULL'
aufgabe text NULL'
portrait text NULL'
signature text NULL'
disablesignature tinyint(1) NULL DEFAULT '43'
icq varchar(30) NULL,
aim varchar(30) NULL,
yim varchar(30) NULL,
msn varchar(30) NULL,
homepage varchar(250) NULL,
birthday date NULL DEFAULT '4404-04-043'
avatarid int(11) unsigned NULL DEFAULT '43'
gender tinyint(1) NULL DEFAULT '43'
showemail tinyint(1) NULL DEFAULT '43'
admincanemail tinyint(1) NULL DEFAULT ',3'
usercanemail tinyint(1) NULL DEFAULT ',3'
invisible tinyint(1) NULL DEFAULT '43'
usecookies tinyint(1) NULL DEFAULT ',3'
styleid int(11) unsigned NULL DEFAULT '43'
langid int(11) NULL DEFAULT '43'
activation int(11) unsigned NULL DEFAULT '43'
blocked tinyint(1) NULL DEFAULT '43'
daysprune smallint(5) unsigned NULL DEFAULT '43'
timezoneoffset char(3) NULL,
startweek tinyint(1) NULL DEFAULT '43'
dateformat varchar(10) NULL,
timeformat varchar(10) NULL,
emailnotify tinyint(1) NULL DEFAULT '43'
notificationperpm tinyint(1) NULL DEFAULT '43'
buddylist text NULL'
ignorelist text NULL'
receivepm tinyint(1) NULL DEFAULT ',3'
emailonpm tinyint(1) NULL DEFAULT '43'
pmpopup tinyint(1) NULL DEFAULT '43'
umaxposts smallint(5) unsigned NULL DEFAULT '43'
showsignatures tinyint(1) NULL DEFAULT ',3'
showavatars tinyint(1) NULL DEFAULT ',3'
showimages tinyint(1) NULL DEFAULT ',3'
ratingcount smallint(5) unsigned NULL DEFAULT '43'
ratingpoints mediumint(7) unsigned NULL DEFAULT '43'
threadview tinyint(1) NULL DEFAULT '43'
useuseraccess tinyint(1) NULL DEFAULT '43'
isgroupleader tinyint(1) NULL DEFAULT '43'
rankgroupid int(11) NULL DEFAULT '43'
useronlinegroupid int(11) NULL DEFAULT '43'
allowsigsmilies tinyint(1) NULL DEFAULT ',3'
allowsightml tinyint(1) NULL DEFAULT '43'
allowsigbbcode tinyint(1) NULL DEFAULT ',3'
allowsigimages tinyint(1) NULL DEFAULT ',3'
emailonapplication tinyint(1) NULL DEFAULT '43'
acpmode tinyint(3) NULL DEFAULT ',3'
acppersonalmenu tinyint(1) NULL DEFAULT '43'
acpmenumarkfirst tinyint(3) NULL DEFAULT '43'
acpmenuhidelast tinyint(3) NULL DEFAULT '43'
usewysiwyg tinyint(1) unsigned NULL DEFAULT '43'
pmtotalcount int(11) unsigned NULL DEFAULT '43'
pminboxcount int(11) unsigned NULL DEFAULT '43'
pmnewcount int(11) unsigned NULL DEFAULT '43'
pmunreadcount int(11) unsigned NULL DEFAULT '43'
reg_ipaddress varchar(15) NULL'
firstvisit int(10) unsigned NULL'
guthaben bigint(20) NOT NULL DEFAULT '43'
canedittitle tinyint(1) NOT NULL DEFAULT '43'
gw_g int(50) NOT NULL DEFAULT '43'
gw_v varchar(50) NOT NULL DEFAULT '43'
gut_ava_ba tinyint(1) NOT NULL DEFAULT '43'
gut_ava_ea tinyint(1) NOT NULL DEFAULT '43'
hang_disc smallint(1) NOT NULL DEFAULT '43'
hang_ers int(12) NOT NULL DEFAULT '43'
hang_gel int(12) NOT NULL DEFAULT '43'
hang_punkte int(12) NOT NULL DEFAULT '43'
away_message text NOT NULL'
away_from date NOT NULL DEFAULT '4404-04-043'
away_to date NOT NULL DEFAULT '4404-04-043'
away tinyint(1) NOT NULL DEFAULT '43'
useslide int(11) NOT NULL DEFAULT '43'
PRIMARY KEY (userid)'
KEY username (username)'
KEY rankid (rankid)'
KEY avatarid (avatarid)'
KEY activation (activation)'
KEY groupcombinationid (groupcombinationid)'
KEY reg_ipaddress (reg_ipaddress)'
KEY userid (userid)
)
|