psa.smb_users

Overview
Column Descriptions

id –

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

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