예제 #1
0
 public static function execute()
 {
     $success = false;
     _::echoWriteInfo("Bsm installation started...");
     $dbm = new MyMangr_ObjectsModel();
     //Create user table
     if ($dbm->tableExists('BsmUser')) {
         _::echoWriteInfo("Dropping BsmUser table");
         $dbm->execute("DROP TABLE BsmUser");
     }
     _::echoWriteInfo("Creating BsmUser table");
     $sql = "CREATE TABLE BsmUser\n              (\n                     id_user         VARCHAR    (12)  NOT NULL COMMENT 'User id, like u001, 88124, ...',\n                     name            VARCHAR    (60)  NOT NULL COMMENT 'Name of the user',\n                     surname         VARCHAR   (120)  NOT NULL COMMENT 'Surname of the user',\n                     email           VARCHAR   (120)           COMMENT 'Email account',\n                     password        CHAR       (40)           COMMENT 'Password hash',\n                     status          CHAR      (100)  NOT NULL COMMENT 'Status: A-Active, D-Deactivated',\n                     auth_class      CHAR      (100)  NOT NULL COMMENT 'Class for authentication',\n                     auth_method     CHAR        (1)  NOT NULL COMMENT 'Method of Class for authentication',\n                     cli_allowed     TINYINT     (1)  NOT NULL COMMENT 'Is the user allowed to use CLI?',\n                     web_allowed     TINYINT     (1)  NOT NULL COMMENT 'Is the user allowed to use WEB?',\n                     ts_created      TIMESTAMP        NOT NULL COMMENT 'Timestamp of user creation',     \n                     ts_last_access  TIMESTAMP                 COMMENT 'Timestamp of user last access',\n                     PRIMARY KEY(\n                        id_user\n                     )\n              )";
     $dbm->execute($sql);
     if ($dbm->tableExists('BsmUser') == false) {
         _::echoWriteInfo("Unable to create BsmUser table. Exiting Bsm install.");
         return $success;
     } else {
         _::echoWriteInfo("Table BsmUser succesfullly created");
     }
     //Create profile table
     if ($dbm->tableExists('BsmProfile')) {
         _::echoWriteInfo("Dropping BsmProfile table");
         $dbm->execute("DROP TABLE BsmProfile");
     }
     _::echoWriteInfo("Creating BsmProfile table");
     $sql = "CREATE TABLE BsmProfile\n              (\n                     id_profile      INT        (11)  NOT NULL COMMENT 'Profile identificator',\n                     profile         VARCHAR    (60)  NOT NULL COMMENT 'Profile name',\n                     status          CHAR        (1)  NOT NULL COMMENT 'Status: A-Active, D-Deactivated',\n                     PRIMARY KEY(\n                        id_profile\n                     )\n              )";
     $dbm->execute($sql);
     if ($dbm->tableExists('BsmProfile') == false) {
         _::echoWriteInfo("Unable to create BsmProfile table. Exiting Bsm install.");
         return $success;
     } else {
         _::echoWriteInfo("Table BsmProfile succesfullly created");
     }
     $success = true;
     return $success;
 }
예제 #2
0
 /**
  * Show message of failed installation
  * 
  * @param string $moduleName Name of the installed module
  */
 private static function failedInstall($moduleName)
 {
     _::echoWriteInfo(NL . "Module " . $moduleName . " installation failed.");
 }