> On May 2, 2017, 3:58 p.m., Nate Cole wrote: > > I'm assuming UpgradeCatalog changes are coming?
Yes... since I am doing this in a feature branch, I thought making really small patches would be ok. - Robert ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/58929/#review173630 ----------------------------------------------------------- On May 2, 2017, 3:09 p.m., Robert Levas wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/58929/ > ----------------------------------------------------------- > > (Updated May 2, 2017, 3:09 p.m.) > > > Review request for Ambari, Attila Magyar, Balázs Bence Sári, Eugene > Chekanskiy, Jonathan Hurley, Laszlo Puskas, Nate Cole, and Sebastian Toader. > > > Bugs: AMBARI-20907 > https://issues.apache.org/jira/browse/AMBARI-20907 > > > Repository: ambari > > > Description > ------- > > User management tables in the DB should be: > > # users > Name |Type |Description > -------------------------------|----------|----------- > user_id |INTEGER |Internal unique identifier > principal_id |INTEGER |Foreign key from adminprincipal > table > user_name |VARCHAR |Unique, case-insensitive, login > identifier expected to be used when logging into Ambari > create_time |TIMESTAMP |Creation time for this account in > Ambari > active |BOOLEAN |Active/not active flag > consecutive_failed_auth_attemps|INTEGER |The number a failed authorization > attempts since the last successful authentication > active_widgets_layout |VARCHAR | > display_name |VARCHAR |Cosmetic name value to show the > user in user interfaces > local_username |VARCHAR |Case-sensitive username to use > when impersonating user in facilities like Ambari Views > > - Primary Key: `user_id` > - Foreign Key: `principal_id` -> `adminprincipal.principal_id` > > > # user_authentication > Name |Type |Description > ----------------------|---------|------------ > user_authentication_id|INTEGER |Primary key for this table > user_id |INTEGER |Foreign key from users table > authentication_type |VARCHAR |Type of authentication system - LOCAL, LDAP, > KERBEROS, JTW, PAM, etc... > authentication_key |VARCHAR |Type-specific key (or identifier): LOCAL: > the user's password (digest); LDAP: the user’s distinguished name; KERBEROS: > the user’s principal; etc... > create_time |TIMESTAMP|Creation time of this record > update_time |TIMESTAMP|Update time for this record, can be used to > enforce password retention times > > - Primary Key: `user_authentication_id` > - Foreign Key: `user_id` -> `users.user_id` > > > Diffs > ----- > > ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql b241dc271c > ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 670bf17594 > ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 00b3248b25 > ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f6af96807c > ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql > 64a0137f5b > ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql 22b2c3d7d5 > > > Diff: https://reviews.apache.org/r/58929/diff/1/ > > > Testing > ------- > > Tested creating new databases using Posgress, MySQL, and Derby. > _I have no way to test creating Oracle, MS SQL, and SQL Anywhere databases._ > > > Thanks, > > Robert Levas > >
