Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-3233 Option to require new account email verification
  3. CORE-3676

Add email_verifications table and model

        Details

        • Type: Sub-task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 4.12.0-b1
        • Component/s: Plugins, Staff Interface
        • Labels:
          None

          Description

          Create a new table to track email verifications

          email_verifications

          • contact_id INT(10) UNSIGNED NOT NULL
          • email VARCHAR(255) NOT NULL
          • token VARCHAR(255) NOT NULL
          • verified TINYINT(1) NOT NULL DEFAULT 0
          • redirect_url VARCHAR(255) NULL DEFAULT NULL
          • date_sent DATETIME NOT NULL
          • unique index on contact_id, email
          • index on contact_id

          Create a new model EmailVerifications with the following methods: get, getByToken, add, edit, delete, verified

          The add method should automatically generate a unique token based on the email

            Activity

            Ascending order - Click to sort in descending order
            jonathan Jonathan Reissmueller created issue -
            jonathan Jonathan Reissmueller made changes -
            Field Original Value New Value
            Component/s Plugins [ 10007 ]
            Component/s Staff Interface [ 10000 ]
            jonathan Jonathan Reissmueller made changes -
            Summary Add email_verifications table Add email_verifications table and model
            jonathan Jonathan Reissmueller made changes -
            Description Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * date_sent DATETIME NOT NULL
            * index on contact_id             		Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified
            jonathan Jonathan Reissmueller made changes -
            Description Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified             		Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified

            The add method should automatically generate a unique token based on the email
            jonathan Jonathan Reissmueller made changes -
            Description Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified

            The add method should automatically generate a unique token based on the email             		Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * redirect_url VARCHAR(255) NULL DEFAULT NULL
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified

            The add method should automatically generate a unique token based on the email
            jonathan Jonathan Reissmueller made changes -
            Description Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * redirect_url VARCHAR(255) NULL DEFAULT NULL
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, add, edit, delete, verified

            The add method should automatically generate a unique token based on the email             		Create a new table to track email verifications

            email_verifications
            * contact_id INT(10) UNSIGNED NOT NULL
            * email VARCHAR(255) NOT NULL
            * token VARCHAR(255) NOT NULL
            * verified TINYINT(1) NOT NULL DEFAULT 0
            * redirect_url VARCHAR(255) NULL DEFAULT NULL
            * date_sent DATETIME NOT NULL
            * unique index on contact_id, email
            * index on contact_id

            Create a new model EmailVerifications with the following methods: get, getByToken, add, edit, delete, verified

            The add method should automatically generate a unique token based on the email
            abdy Abdy Franco made changes -
            Assignee Abdy Franco [ abdy ]
            Automated transition triggered when Abdy Franco created a branch in Stash -
            Status Open [ 1 ] In Progress [ 3 ]
            abdy Abdy Franco made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 5 hours, 7 minutes [ 18420 ]
            Worklog Id 13830 [ 13830 ]
            Automated transition triggered when Abdy Franco created pull request #911 in Stash -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            Automated transition triggered when Abdy Franco merged pull request #911 in Stash -
            Status In Review [ 5 ] Closed [ 6 ]

              People

              • Assignee:
                abdy Abdy Franco
                Reporter:
                jonathan Jonathan Reissmueller
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  17/Sep/20

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours, 7 minutes
                  5h 7m

                    Agile