...
The schema for the database is below. It can also be found in the application if the user has usersdatabase::read permission by going to menu: Manage -> Database -> List, then clicking on the "users" table.
| Code Block | ||||
|---|---|---|---|---|
| ||||
Create Table: CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`org_id` int(10) unsigned NOT NULL DEFAULT '1',
`password` varchar(250) NOT NULL,
`full_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`roles` text NOT NULL,
`orgs` text NOT NULL,
`lang` enum('de','en','es','fr','pt-br') NOT NULL DEFAULT 'en',
`active` varchar(1) NOT NULL DEFAULT 'y',
`ldap` text NOT NULL,
`edited_by` varchar(200) NOT NULL DEFAULT '',
`edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`),
KEY `user_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; |
...