Dong 02.16.2010

  • FormUsersMgmtCanvas and FormAddUsersCanvas added and quite functional.  add and delete users from form
  • added queries setter to DatabaseSQL.as to support for multiple inserts and others.
  • combined primary key is needed for proper insertion and deletion for forms_users table
    • CREATE TABLE IF NOT EXISTS `forms_users` (
      `forms_id` int(11) NOT NULL,
      `user` varchar(256) NOT NULL,
      PRIMARY KEY (`forms_id`,`user`)
      ) ENGINE=MyISAM DEFAULT CHARSET=armscii8;
    • this limits the duplicate records when using INSERT IGNORE, regular INSERT generates error when duplicates are found
  • created view; view_users, for easy query build
    • create view view_users as select db.user as ‘User ID’, full_name as Name, Description, email, contact_information as ‘Contact Info’,
      if (strcmp (grant_priv, ‘Y’), if (strcmp (create_priv, ‘Y’), ‘FORM USER’, ‘FORM OWNER’), ‘ADMIN’) AS ‘User Level’
      from mysql.db LEFT JOIN  mysql.user_info on (db.user = user_info.user) WHERE db=’formbuilder’
  • side-tracked to Visibilit 2 bug tracking…..
    • DatabaseIf.getTablesInfo (user) not working properly, removed and put UsersAndRoles.getUserTables()