News & Updates
13.1.2008
- Version 1.4.1
- Languages: Italian, Dutch, Traditional Chinese (Marc, Tiberti Fabio, Finjon Kiang)
25.11.2007
- Version 1.4
- Improvements from Travis Kroh: PDO-based io.php, SQLite, Symphony, XSLT for MySQL export, changed order of FK names
28.10.2007
- Version 1.3.6
- FK inherits more features from PK (thanks to Cyril Zekser)
- Fix for import from MSSQL (thanks to Andrea)
5.10.2007
- Version 1.3.5
- FK inherits datatype from PK (thanks to Kevin T. Ryan)
24.9.2007
- Version 1.3.4
- Two bugfixes for IE7
27.7.2007
- Version 1.3.3
- Foreign Keys have editable names (revert to previous behavior)
20.7.2007
- Version 1.3.2
- patches from Tobias Stechbarth
- MEDIUMTEXT used for data storage (thanks to Areski)
30.5.2007
- Version 1.3.1
- Numerous new translations
6.2.2007
- Version 1.3
- Browser crash fix (thanks to Hiroki Yoshioka)
- Importing existing DB schema (not in demo)
- Brazilian Portugese (Fabio Gomes Ramos)
31.1.2007
- Version 1.2.1
- PROPEL xslt update (Dominic Pelletier)
- Default language fix (Andrej Kvasnica)
21.1.2007
- Version 1.2
- XSLT template to PROPEL xml (Dominic Pelletier)
- Patched MSSQL template (Romain Fevre)
- Localisation (Romain Fevre)
- Oracle support (Romain Fevre)
- CHAR and DECIMAL support (Romain Fevre)
27.11.2006
- Version 1.1.8
- patches from Alex Petrescu
26.10.2006
- Version 1.1.7
- xml2postgresql template, thankss to Gérard
31.7.2006
- Print view, thanks to Tor Edvardsson
- Listing of keywords, thanks to Tor Edvardsson
7.4.2006
- xml2mssql template for creating Microsoft SQL scripts, thanks to Sean
27.10.2005
- direct loading of saved schema, see FAQ
18.10.2005
- php script resistant to magic_quotes_gpc
14.10.2005
- mouse wheel scrolls minimap, thanks to Andreas Attemann
- new Settings button, does nothing :)
- more straightforward labels in i/o select
- ajax based on xmlhttp, not <script>
12.10.2005
- bugfix - bad row order when exporting
- bugfix - string lengths not exported
6.10.2005
- xslt tranformation now DIRECTLY IN BROWSER!
- button 'clear tables'
- optimized bar for lower resolutions
5.10.2005
- major webpage changes
- all styling now in STYLES subdirectory
- changed descriptive texts on bar into <label>s
- new (albeit simple) rss feed!
- donation available, see quick links
4.10.2005
- website updates
- fixed non-selectable user-added rows (thanks to Paul Thrasher)
- added GNU GPL licence
- added version information; welcome 1.0 !
3.10.2005
TODO list
- multi-field PKs
- comments
- no auto_increment for non-numeric PKs
- automatic renaming of foreign keys (when parent gets renamed)
- SIGNED/UNSIGNED integer types
WWW SQL Designer
FAQs
-
How do quickly access a previously saved schema?
Use this URL form: http://someserver.tld/wwwsqldesigner/?keyword=saved_keyword
-
How do I create a relation?
Drag from primary key to target table (may be the same).
Foreign key will be created automatically.
-
How do I remove a relation?
Delete the row with either primary or foreign key.
-
How do I install a local copy of this application?
- you will need a php-enabled webserver!
- download a .zip file (use link on the right)
- unpack into a directory
- optional: setup a database connection in io.php file
this will enable saving & loading into database.
Don't forget to use the included mysql.sql script
to create appropriate DB table for saved schemas!
- optional: setup an ODBC connection in import.php file
this will enable importing existing DB schema
- open index.php file
-
How can I change size/fonts/colors/etc.. ?
Look into STYLES/ subdirectory. Three files want your attention there:
- style.js - some size & color constants
- style.css - main css style file
- bar.css - style for the gray command bar
There is also a fourth file, foo.
It is empty and has only one function - it is used in Internet Explorer position:fixed hack. Leave it alone.
-
I have a question that isn't listed here!
Mail me; I will add the question along with the answer.