text: /*
   * BSD 3-Clause License
   *
   * Copyright (c) 2020, TASoft Applications
   * All rights reserved.
   *
   * Redistribution and use in source and binary forms, with or without
   * modification, are permitted provided that the following conditions are met:
   *
   *  Redistributions of source code must retain the above copyright notice, this
   *   list of conditions and the following disclaimer.
   *
   *  Redistributions in binary form must reproduce the above copyright notice,
   *   this list of conditions and the following disclaimer in the documentation
   *   and/or other materials provided with the distribution.
   *
   *  Neither the name of the copyright holder nor the names of its
   *   contributors may be used to endorse or promote products derived from
   *   this software without specific prior written permission.
   *
   * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
   * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
   * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
   * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
   * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
   * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
   * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
   * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
   * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
   * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
   *
   */
  
  /*
   *   const OPTION_INTERNAL      = 1;
   */
  CREATE TABLE IF NOT EXISTS SKY_GROUP
  (
      id          int AUTO_INCREMENT
          primary key,
      name        varchar(100)     not null unique,
      description text            default null,
      options     int    default 0 not null
  );
  
  INSERT INTO SKY_GROUP (id, name, description, options) VALUES (1, 'Administrator', 'The administrators of Skyline CMS', 1);
  INSERT INTO SKY_GROUP (id, name, description, options) VALUES (2, 'Author', 'Authors can add, edit, translate and delete pages and contents of your website', 1);
  INSERT INTO SKY_GROUP (id, name, description, options) VALUES (3, 'Translator', 'Translators can translate existing text into several languages', 1);
  
  ALTER TABLE SKY_GROUP
      MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;