After instalation is complete please set install property to false.
  • update_from_v2_to_v2.02.sql
    ALTER TABLE settings 
       ADD setting_order INT NULL;
    
    • MySQL:
      update_from_v2.02_to_v2.03.MySQL.sql
      /**
       * -----------------------------------------------------
       * Table password_recovery
       * -----------------------------------------------------
       */
      CREATE  TABLE IF NOT EXISTS password_recovery (
        id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
        id_user BIGINT UNSIGNED NOT NULL ,
        code VARCHAR(10) NOT NULL ,
        long_code VARCHAR(32) NOT NULL ,
        user_name VARCHAR(45) NULL ,
        email VARCHAR(60) NOT NULL ,
        ip VARBINARY(16) NOT NULL,
        used BOOLEAN NOT NULL DEFAULT FALSE,
        date_of_request TIMESTAMP NOT NULL ,
        expired BOOLEAN NOT NULL DEFAULT FALSE,
      
        PRIMARY KEY (id),
        
        FOREIGN KEY (id_user) REFERENCES users (id)
          ON DELETE CASCADE
          ON UPDATE CASCADE
      )ENGINE = InnoDB;
      
      CREATE UNIQUE INDEX password_recovery_lc_UNIQUE ON password_recovery (long_code);
      
      
      
      
      DELIMITER //
      /**
       * -----------------------------------------------------
       * Trigger function(s) for table password_recovery.
       * ----------------------------------------------------- 
       */
      CREATE TRIGGER trg_password_recovery_bi BEFORE INSERT ON password_recovery
          FOR EACH ROW BEGIN
              SET NEW.date_of_request = current_timestamp;
          END; //
      DELIMITER ;
      
      
    • PostgreSQL:
      update_from_v2.02_to_v2.03.postgre.sql
      /**
       * -----------------------------------------------------
       * Table password_recovery
       * -----------------------------------------------------
       */
      CREATE  TABLE IF NOT EXISTS password_recovery (
        id BIGSERIAL  NOT NULL ,
        id_user BIGINT  NOT NULL ,
        code VARCHAR(10) NOT NULL ,
        long_code VARCHAR(32) NOT NULL ,
        user_name VARCHAR(45) NULL ,
        email VARCHAR(60) NOT NULL ,
        ip cidr NOT NULL,
        used BOOLEAN NOT NULL DEFAULT FALSE,
        date_of_request TIMESTAMP NOT NULL ,
        expired BOOLEAN NOT NULL DEFAULT FALSE,
      
        PRIMARY KEY (id),
      
        
        FOREIGN KEY (id_user) REFERENCES users (id)
          ON DELETE CASCADE
          ON UPDATE CASCADE
      );
      
      CREATE UNIQUE INDEX password_recovery_lc_UNIQUE ON password_recovery (long_code);
      
      /**
       * -----------------------------------------------------
       * Trigger function(s) for table password_recovery.
       * ----------------------------------------------------- 
       */
      CREATE OR REPLACE FUNCTION trg_password_recovery_bi ()
          RETURNS trigger AS $$
          BEGIN
              NEW.password_recovery := current_timestamp;
              
              RETURN NEW;
          END;
          $$ LANGUAGE PLPGSQL;
      
        
      /**
       * -----------------------------------------------------
       * Trigger(s) for table password_recovery.
       * ----------------------------------------------------- 
       */
      CREATE TRIGGER password_recovery_bi BEFORE INSERT ON password_recovery
        FOR EACH ROW EXECUTE PROCEDURE trg_password_recovery_bi();  
      
    • MySQL:
      update_from_v2.03_to_v2.04.MySQL.sql
      INSERT INTO settings (name, value) SELECT 'sender_registerNewEmail', value FROM settings WHERE name = 'notificationVerificationEmail';
      DELETE FROM settings WHERE name = 'notificationVerificationEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_invitation', value FROM settings WHERE name = 'invitationEmail';
      DELETE FROM settings WHERE name = 'invitationEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_signUp', value FROM settings WHERE name = 'notificationSignUpEmail';
      DELETE FROM settings WHERE name = 'notificationSignUpEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_passwordRecovery', value FROM settings WHERE name = 'passwordRecoveryEmail';
      DELETE FROM settings WHERE name = 'passwordRecoveryEmail';
      
      ALTER TABLE settings 
          ADD   version INT DEFAULT 0;
      
      /** 
       * -----------------------------------------------------
       * Table site_emails_content
       * -----------------------------------------------------
       */ 
      CREATE  TABLE IF NOT EXISTS site_emails_content (
        id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
        name VARCHAR(45) NOT NULL ,
        subject VARCHAR(100) NOT NULL ,
        body TEXT NOT NULL ,
        available_variables TEXT NULL ,
        date_of_update TIMESTAMP NULL ,
        version INT DEFAULT 0,
      
        PRIMARY KEY (id) ,
      
        FOREIGN KEY (name) REFERENCES settings (name)
          ON DELETE CASCADE
          ON UPDATE CASCADE
      )ENGINE = InnoDB;
      
      CREATE UNIQUE INDEX site_emails_content_name_UNIQUE ON site_emails_content (name);
      
      
      DELIMITER //
      
      
      /**
       * -----------------------------------------------------
       * Trigger function(s) for table site_emails_content.
       * ----------------------------------------------------- 
       */
      CREATE TRIGGER trg_site_emails_content_bu BEFORE UPDATE ON site_emails_content
          FOR EACH ROW BEGIN
              SET NEW.date_of_update = current_timestamp;
          END; //
      
      
      DELIMITER ;
      
    • PostgreSQL:
      update_from_v2.03_to_v2.04.postgre.sql
      INSERT INTO settings (name, value) SELECT 'sender_registerNewEmail', value FROM settings WHERE name = 'notificationVerificationEmail';
      DELETE FROM settings WHERE name = 'notificationVerificationEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_invitation', value FROM settings WHERE name = 'invitationEmail';
      DELETE FROM settings WHERE name = 'invitationEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_signUp', value FROM settings WHERE name = 'notificationSignUpEmail';
      DELETE FROM settings WHERE name = 'notificationSignUpEmail';
      
      INSERT INTO settings (name, value) SELECT 'sender_passwordRecovery', value FROM settings WHERE name = 'passwordRecoveryEmail';
      DELETE FROM settings WHERE name = 'passwordRecoveryEmail';
      
      ALTER TABLE settings 
          ADD   version INT DEFAULT 0;
      
      ALTER TABLE settings
         ADD CONSTRAINT settings_name_a_unique UNIQUE (name);
      /** 
       * -----------------------------------------------------
       * Table site_emails_content
       * -----------------------------------------------------
       */ 
      CREATE  TABLE IF NOT EXISTS site_emails_content (
        id BIGSERIAL NOT NULL,
        name VARCHAR(45) NOT NULL ,
        subject VARCHAR(100) NOT NULL ,
        body TEXT NOT NULL ,
        available_variables TEXT NULL ,
        date_of_update TIMESTAMP NULL ,
        version INT DEFAULT 0,
      
        PRIMARY KEY (id) 
      
      );
      
      CREATE UNIQUE INDEX site_emails_content_name_UNIQUE ON site_emails_content (UPPER(name));
      
      
      ALTER TABLE site_emails_content
        ADD CONSTRAINT site_emails_content_name_foreign FOREIGN KEY (name)
            REFERENCES settings (name)
            ON UPDATE CASCADE ON DELETE CASCADE;
      
      
      
          
      /**
       * -----------------------------------------------------
       * Trigger function(s) for table settings.
       * ----------------------------------------------------- 
       */
      CREATE OR REPLACE FUNCTION trg_site_emails_content_bu ()
          RETURNS trigger AS $$
          BEGIN
              NEW.date_of_update := current_timestamp;
              
              RETURN NEW;
          END;
          $$ LANGUAGE PLPGSQL;
      
      /**
       * -----------------------------------------------------
       * Trigger(s) for table settings.
       * ----------------------------------------------------- 
       */
      CREATE TRIGGER site_emails_content_bu BEFORE UPDATE ON site_emails_content
        FOR EACH ROW EXECUTE PROCEDURE trg_site_emails_content_bu();  
      
    • MySQL:
      update_from_v2_to_v3.MySQL.sql
      ALTER TABLE users_data
          ADD facebook_user_id BIGINT UNSIGNED;
    • PostgreSQL:
      update_from_v2_to_v3.postgre.sql
      ALTER TABLE users_data
          ADD facebook_user_id BIGINT;
    • MySQL:
      update_from_v3_to_v301.MySQL.sql
      ALTER TABLE users_data
          ADD twitter_user_id BIGINT UNSIGNED;
    • PostgreSQL:
      update_from_v3_to_v301.postgre.sql
      ALTER TABLE users_data
          ADD twitter_user_id BIGINT;