Plusieurs modifications et ajouts appliqués, dont :
- Type de valeur
JSON
ajouté - Par défaut, un champ n'a pas de valeur par défaut et ne peut être
NULL
- Les options d'affichage suivantes sont sélectionnées par défaut :
show field type
etshow field size
- On peut maintenant donner un nom à la BD : ce nom est sauvegardé dans le fichier
XML
et est utilisé pour générer un scriptSQL
plus complet - Encodage et interclassement utilisent le code de caractères
utf8mb4
par défaut - Les tables utilisent le format de stockage
INNODB
par défaut
Le code est commenté avec la marque [MODIF/AJOUT 21B]
pour faciliter la consultation 👌 🔥
Le fichier README original est laissé intact ci-dessous.
WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.
Hi and welcome to WWW SQL Designer! This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled. The Designer works perfectly in Chrome, Mozilla (Firefox, Seamonkey), Internet Explorer, MS Edge, Safari and Opera.
Many database features are supported, such as keys, foreign key constraints, comments and indexes. You can either save your design (for further loading & modifications), print it or export as SQL script. It is possible to retrieve (import) schema from existing database.
WWW SQL Designer was created by Ondrej Zara and is built atop the oz.js JavaScript module. It is distributed under New BSD license.
If you wish to support this project, at PayPal!
npm install http-server -g
- Run
http-server
in the root of this repo to start a simple http server - Visit http://127.0.0.1:8080
- Build
docker build -t wwwsqldesigner .
- Run
docker run -d -p 8080:8080 wwwsqldesigner
- Visit http://127.0.0.1:8080
Please use the following auto formatters to maintain the code style
File | Remarks | Formatter |
---|---|---|
/index.html |
VSCode built-in formatter | |
/js/*.js |
4 spaces for tabs | https://marketplace.visualstudio.com/items?itemName=esbenp.prettier-vscode |
/styles/*.css |
https://marketplace.visualstudio.com/items?itemName=aeschli.vscode-css-formatter | |
/locale/*.xml |
https://marketplace.visualstudio.com/items?itemName=DotJoshJohnson.xml |
Google Code is closing down, we are now completely migrated to GitHub.
Thanks to Bharat Patil: http://bharat.whiteboard.jit.su/
Version 2.7 was released on 3.8.2012. This is mainly a bugfix release, although several new features (most notable localStorage support) are present.
Version 2.6 was released on 22.9.2011. Several new translations (pt_BR, sv, ar) added; VML removed; new visualization options available (show length and datatype); new DBs and backends; support for touch devices...
http://code.google.com/r/charlieyouakim-wwwsqldesigner-deleteadd/
A new patch, which enable optional display of field details, was submitted by Wilson Oliveira. While this code is not ready yet to be commited into repository, everyone can download it from http://ondras.zarovi.cz/sql/wwwsqldesigner-inline_field_details_patch.zip.
WWW SQL Designer now supports the CUBRID database: both as a backend (using PHP) as well as datatype definition set.
Version 2.5 was released on 18.6.2010. Many new features were added (hiding of sidebar, colored relation, multi-selection and multi-drag, ...), tons of bugs were fixed.
Version 2.4 was released on 5.11.2009. Several outstanding issues were fixed and new locales added.
Version 2.3.3 was released on 28.7.2009. This long-awaited release includes numerous fixes, compatibility improvements, new locales, backends and DB datatypes.
Version 2.3.2 was released on 8.1.2009. Apart from some traditional bugfixes and locales, a new functionality is introduced - the ability to mark foregin keys between existing table fields!
The project was recently moved to Google Code hosting, which (amongst many other things) introduces Subversion hosting. Enjoy! (The old website, http://ondras.zarovi.cz/sql/, will still exist for some time.)
Good news: A new version of WWW SQL Designer, rewritten from scratch, is now available. It has many new features, including bezier connectors, support for various customizations, localization, options and more.
Bad news: This new version is not backwards compatible with 1.x, so all old localizations and XSLT templates won't work with 2.x. Sorry for inconvenience :/