Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.
Help keep Vanilla free:1 to 2 of 2
// User Table
$DatabaseTables['User'] = 'LUM_User';
// User Table fields
$DatabaseColumns['User']['UserID'] = 'UserID';
$DatabaseColumns['User']['RoleID'] = 'RoleID';
$DatabaseColumns['User']['StyleID'] = 'StyleID';
$DatabaseColumns['User']['CustomStyle'] = 'CustomStyle';
$DatabaseColumns['User']['FirstName'] = 'FirstName';
$DatabaseColumns['User']['LastName'] = 'LastName';
$DatabaseColumns['User']['Name'] = 'Name';
$DatabaseColumns['User']['Password'] = 'Password';
$DatabaseColumns['User']['VerificationKey'] = 'VerificationKey';
$DatabaseColumns['User']['EmailVerificationKey'] = 'EmailVerificationKey';
$DatabaseColumns['User']['Email'] = 'Email';
$DatabaseColumns['User']['UtilizeEmail'] = 'UtilizeEmail';
$DatabaseColumns['User']['ShowName'] = 'ShowName';
$DatabaseColumns['User']['Icon'] = 'Icon';
$DatabaseColumns['User']['Picture'] = 'Picture';
$DatabaseColumns['User']['Attributes'] = 'Attributes';
$DatabaseColumns['User']['CountVisit'] = 'CountVisit';
$DatabaseColumns['User']['CountDiscussions'] = 'CountDiscussions';
$DatabaseColumns['User']['CountComments'] = 'CountComments';
$DatabaseColumns['User']['DateFirstVisit'] = 'DateFirstVisit';
$DatabaseColumns['User']['DateLastActive'] = 'DateLastActive';
$DatabaseColumns['User']['RemoteIp'] = 'RemoteIp';
$DatabaseColumns['User']['LastDiscussionPost'] = 'LastDiscussionPost';
$DatabaseColumns['User']['DiscussionSpamCheck'] = 'DiscussionSpamCheck';
$DatabaseColumns['User']['LastCommentPost'] = 'LastCommentPost';
$DatabaseColumns['User']['CommentSpamCheck'] = 'CommentSpamCheck';
$DatabaseColumns['User']['UserBlocksCategories'] = 'UserBlocksCategories';
$DatabaseColumns['User']['DefaultFormatType'] = 'DefaultFormatType';
$DatabaseColumns['User']['Discovery'] = 'Discovery';
$DatabaseColumns['User']['Preferences'] = 'Preferences';
$DatabaseColumns['User']['SendNewApplicantNotifications'] = 'SendNewApplicantNotifications';CREATE TABLE `LUM_User` (
`UserID` int(10) NOT NULL auto_increment,
`RoleID` int(2) NOT NULL default '0',
`StyleID` int(3) NOT NULL default '1',
`CustomStyle` varchar(255) default NULL,
`FirstName` varchar(50) NOT NULL default '',
`LastName` varchar(50) NOT NULL default '',
`Name` varchar(20) NOT NULL default '',
`Password` varchar(32) default NULL,
`VerificationKey` varchar(50) NOT NULL default '',
`EmailVerificationKey` varchar(50) default NULL,
`Email` varchar(200) NOT NULL default '',
`UtilizeEmail` enum('1','0') NOT NULL default '0',
`ShowName` enum('1','0') NOT NULL default '1',
`Icon` varchar(255) default NULL,
`Picture` varchar(255) default NULL,
`Attributes` text NULL,
`CountVisit` int(8) NOT NULL default '0',
`CountDiscussions` int(8) NOT NULL default '0',
`CountComments` int(8) NOT NULL default '0',
`DateFirstVisit` datetime NOT NULL default '0000-00-00 00:00:00',
`DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00',
`RemoteIp` varchar(100) NOT NULL default '',
`LastDiscussionPost` datetime default NULL,
`DiscussionSpamCheck` int(11) NOT NULL default '0',
`LastCommentPost` datetime default NULL,
`CommentSpamCheck` int(11) NOT NULL default '0',
`UserBlocksCategories` enum('1','0') NOT NULL default '0',
`DefaultFormatType` varchar(20) default NULL,
`Discovery` text,
`Preferences` text,
`SendNewApplicantNotifications` enum('1','0') NOT NULL default '0',
PRIMARY KEY (`UserID`),
KEY `user_role` (`RoleID`),
KEY `user_style` (`StyleID`),
KEY `user_name` (`Name`)
);
1 to 2 of 2