Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    I-doIT 0.9 - Create a new mandator

    Scheduled Pinned Locked Moved Operating
    1 Posts 1 Posters 3.5k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • dsD Offline
      ds
      last edited by

      Creating a new mandator in 3 Steps.

      If you just want to create a new language for an existing mandator, you need to process step 3 only.
      Don't forget to change the database name used for this example: 'idoit_new_mandator'.

      Step 1. - Create a new database

      Get a connection to your database:

      
      mysql -u root -p
      
      

      Create your new mandator database:

      
      create database idoit_new_mandator;
      
      

      Step 2. - Import a dump of the i-doit data tables into your new database.

      Switch to your idoit directory:

      
      cd idoit-path/
      
      

      Insert a fresh database (change idoit_new_mandator to the name you used for your new database in step one):

      
      mysql -uroot -p -Didoit_new_mandator < setup/sql/idoit_data.sql
      
      

      Step 3. - Insert a new entry into your idoit system database

      Get a connection to your database management system and select your i-doit system database:

      
      mysql -u root -p -Didoit_system_database
      
      

      Modify the quoted fields after the keyword VALUES before inserting, but dont remove these quotes.

      Insert a new mandator entry with english language:

      
      INSERT INTO `isys_mandator` ( `isys_mandator__id` , `isys_mandator__title` , `isys_mandator__description` , `isys_mandator__dir_cache` , `isys_mandator__dir_tpl` , `isys_mandator__db_host` , `isys_mandator__db_port` , `isys_mandator__db_name` , `isys_mandator__db_user` , `isys_mandator__db_pass` , `isys_mandator__sort` , `isys_mandator__default_lang_const` , `isys_mandator__default_language_short` )
      VALUES (DEFAULT, 'MandantTitle', NULL , 'cache_mandanttitle', 'default', 'db_ip', '3306', 'idoit_new_mandator', 'db_user', 'db_pass', '50', 'ISYS_LANGUAGE_ENGLISH', 'de');
      
      

      Insert a new mandator entry with german language:

      
      INSERT INTO `isys_mandator` ( `isys_mandator__id` , `isys_mandator__title` , `isys_mandator__description` , `isys_mandator__dir_cache` , `isys_mandator__dir_tpl` , `isys_mandator__db_host` , `isys_mandator__db_port` , `isys_mandator__db_name` , `isys_mandator__db_user` , `isys_mandator__db_pass` , `isys_mandator__sort` , `isys_mandator__default_lang_const` , `isys_mandator__default_language_short` )
      VALUES (DEFAULT, 'MandantTitle', NULL , 'cache_mandanttitle', 'default', 'db_ip', '3306', 'idoit_new_mandator', 'db_user', 'db_pass', '50', 'ISYS_LANGUAGE_GERMAN', 'de');
      
      

      - You can also use another frontend than the mysql-client if you like.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post