"
CREATE TABLE {$config['tbprefix']}Users(
U_LoginName $varchar(64) NOT NULL,
U_Username $varchar(64) NOT NULL,
U_Password $varchar(32) NOT NULL,
U_Email $varchar(50),
U_Fakeemail $varchar(50),
U_Name $varchar(100),
U_Totalposts $int9 default '0',
U_Laston $int11,
U_Signature $text,
U_Homepage $varchar(150),
U_Occupation $varchar(150),
U_Hobbies $varchar(200),
U_Location $varchar(200),
U_Bio $text,
U_Status $varchar(15) DEFAULT 'User' NOT NULL,
U_Display $varchar(10) NOT NULL DEFAULT 'flat',
U_View $varchar(10) NOT NULL,
U_PostsPer $int11,
U_Number $int9 $autoincs PRIMARY KEY,
U_EReplies $varchar(3) NOT NULL,
U_Notify $varchar(3) NOT NULL,
U_TextCols $varchar(3),
U_TextRows $varchar(3),
U_Extra1 $varchar(200),
U_Extra2 $varchar(200),
U_Extra3 $varchar(200),
U_Extra4 $varchar(200),
U_Extra5 $varchar(200),
U_Registered $int11,
U_Preview $varchar(5),
U_Picture $varchar(150),
U_PictureView $varchar(3),
U_Visible $varchar(3) DEFAULT 'yes',
U_PicturePosts $varchar(3),
U_AcceptPriv $varchar(3) DEFAULT 'yes',
U_RegEmail char(50),
U_RegIP char(15),
U_Groups $varchar(250) DEFAULT '-1-',
U_Language $varchar(20),
U_Title $varchar(100),
U_FlatPosts $varchar(2),
U_TempPass $varchar(32),
U_Color $varchar(15),
U_StyleSheet $varchar(50),
U_TimeOffset $varchar(10),
U_Privates $int4 DEFAULT '0',
U_FrontPage $varchar(20),
U_StartPage $varchar(2) DEFAULT 'cp',
U_Favorites $varchar(250) DEFAULT '-',
U_ShowSigs $varchar(3),
U_OnlineFormat $varchar(3),
U_Rating $varchar(5) DEFAULT '0',
U_Rates $int4 DEFAULT '0',
U_RealRating $int1,
U_PicWidth $int4,
U_PicHeight $int4,
U_SessionId varchar(64) NOT NULL DEFAULT '0',
U_Approved VARCHAR(8) NOT NULL,
U_Palprofile $int11,
U_AdminEmails VARCHAR(3),
U_EmailFormat VARCHAR(10),
U_WhichForums VARCHAR(3) DEFAULT 'all',
U_Categories VARCHAR(255) DEFAULT '-',
U_Banned INT(1) DEFAULT '0',
U_CoppaUser INT(1) UNSIGNED DEFAULT '0',
U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',
U_ShowBday INT(1) NOT NULL DEFAULT '0',
U_TimeFormat VARCHAR(6),
U_Ignored TEXT,
U_OC_Userid VARCHAR(64),
U_LastPostTime INT(11) unsigned,
U_LastPostIP VARCHAR(15),
U_LastSearch INT(11),
U_SearchSession VARCHAR(32),
U_FloodControl MEDIUMINT(8),
U_LastPost INT(11) UNSIGNED,
U_ProfileHash VARCHAR(32)
$indexes
)"
