psa.smb_users
Overview
Column Descriptions
id –
CREATE TABLE `smb_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`contactName` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`companyName` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`address` text,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`creationDate` varchar(25) NOT NULL,
`isBuiltIn` int(11) DEFAULT '0',
`roleId` int(11) NOT NULL,
`uuid` varchar(36) NOT NULL,
`isLocked` int(11) DEFAULT '0',
`authCookie` varchar(255) DEFAULT NULL,
`sessionId` varchar(255) DEFAULT NULL,
`externalId` varchar(255) DEFAULT NULL,
`ownerId` int(11) DEFAULT NULL,
`isDomainAdmin` int(11) DEFAULT NULL,
`additionalInfo` text,
`imNumber` varchar(255) DEFAULT NULL,
`imType` int(11) DEFAULT NULL,
`isLegacyUser` int(11) DEFAULT NULL,
`subscriptionDomainId` bigint(20) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uuid` (`uuid`),
UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8
Related documentation
March 13th, 2013 in
Uncategorized