• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Installing wwwsqldesigner

  • Views Views: 10,222
  • Last updated Last updated:
  • Introduction​

    Creating an application framework usually consists of:

    • the idea - what is it that you want to create?
    • the implementation - how are you going to implement this?
    • the execution - running the application live
    Good database designis an essential part of this journey and part of the implementation process.

    Main Features​

    wwwsqldesigner allows you to 'plot out' your ideas in an ER diagram and has these main features:


    • the ability to save these diagram
    • the ability to load saved diagrams
    • the ability to import existing databases
    • the ability to import and export xml files
    • the ability to generate mysql from your diagrams
    You can see the demonstration Installation here.


    These are the steps required if you are using MySQL and phpMyAdmin and collation is OK as utf8_general_ci.

    • Download zip file from http://code.google.com/p/wwwsqldesigner/
    • Extract to your system
    • Upload contents to a directory on your site
    • Create a database (in cPanel for example)
    • Create a database table in phpMyadmin consisting of three (3) columns:
      • Column 1 called keyword, varchar(255), Default is 'None', utf8_unicode_ci
      • Column 2 called data, mediumtext, Default is 'NULL', utf8_unicode_ci, null checkbox checked
      • Column 3 called dt, timestamp, Default is CURRENT_TIMESTAMP, attributes 'on update CURRENT_TIMESTAMP'
    • Set the 'keyword' column as the index - not sure if this is necessary but phpMyAdmin prompts to set an index.
    • Note: You can import the database at backend/php-mysql/database.sql into your new database if you would like to see what the database table should look like.
    • Edit the file at backend/php-mysql/index.php so that the first three (3) functions match your new database settings.
    You should now be able to 'Save' and 'Load' schemas by their keyword.

    Example index.php​

    The following is a commented configuration for the first three (3) functions in your backend/php-mysql/index.php file.


    PHP:

    <?php
    set_time_limit(0);
    function setup_saveloadlist() {
    // define your server, usually localhost
    define("SERVER","localhost");
    // define the user who has access to your wwwsqldesigner database
    define("USER","");
    //define their password
    define("PASSWORD","");
    // define the wwwsqldesigner database where your keywords will be saved and loaded from
    define("DB","home");
    // define the wwwsqldesigner database table where you keywords will be saved and loaded from
    define("TABLE","wwwsqldesigner");
    }
    function setup_import() {
    // define the server where you will be importing databases from, usually localhost
    define("SERVER","localhost");
    // define the user who has access to the database you wish to import
    define("USER","");
    // define their password
    define("PASSWORD","");
    // leave this as is - do NOT adjust this
    define("DB","information_schema");
    }
    // ================== generally you do not need to edit below this line ==================
    function connect() {
    $conn = mysql_connect(SERVER,USER,PASSWORD);
    if (!$conn) return false;
    $res = mysql_select_db(DB);
    if (!$res) return false;
    return true;
    }

    Password Protecting Your Directory​

    You may wish to password protect your directory by following the steps mentioned here:

    http://css-tricks.com/easily-password-protect-a-website-or-subdirectory/
Back
Top