google-code-export / wwwsqldesigner Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/wwwsqldesigner
License: BSD 3-Clause "New" or "Revised" License
Automatically exported from code.google.com/p/wwwsqldesigner
License: BSD 3-Clause "New" or "Revised" License
For documentation, visit http://code.google.com/p/wwwsqldesigner/w/list
What steps will reproduce the problem?
1. Set locale to PL
2. Reload
3. Look at the row manager
What is the expected output? What do you see instead?
Czech captions instead of Polish ones :)
What version of the product are you using? On what operating system?
r56
Please provide any additional information below.
Patch is attached.
Original issue reported on code.google.com by [email protected]
on 8 Nov 2009 at 8:48
Attachments:
When you select a value with the keyboard and then close the drop down list
with your mouse, the value reverts to its previous selection.
To reproduce:
1. Add a table, then a column, then edit it and click the data type drop
down list to open it.
2. Press V to select varchar.
3. Click the dropdown list again to close it.
Instead of remaining on varchar, it will revert to integer. If you press
tab or enter instead of clicking to close the dropdown, it stays on varchar
as it should.
I'm using Google Chrome v3.0.195.33 on Windows 7 Ultimate 64 bit.
Original issue reported on code.google.com by [email protected]
on 22 Nov 2009 at 5:13
What steps will reproduce the problem?
1. Click edit field
2. Read NOT NULL
3. Be confused
What is the expected output? What do you see instead?
Maybe NOT NULL should read: "Field can be NULL" and the action of the checkbox
is reversed.
Original issue reported on code.google.com by [email protected]
on 27 Jun 2009 at 4:37
It would be very nice if we had the TINYINT field option, as a TINYINT(1) is
ussually treated by many
frameworks as a BOOLEAN field.
Original issue reported on code.google.com by [email protected]
on 23 Feb 2009 at 6:56
What steps will reproduce the problem?
1.
2.
3.
What is the expected output? What do you see instead?
What version of the product are you using? On what operating system?
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 26 Dec 2008 at 6:45
[deleted issue]
Hi Ondřej,
is it possible to create the XML schema file out of a sql file?
Simon
Original issue reported on code.google.com by [email protected]
on 26 Jan 2009 at 10:53
With the latest checkout, I have to
* Click on "Save / Load"
* Click On "Save"
* Type keyword
* Confirm (Ok/Enter)
to save the drawing. If the drawing was previously loaded, perhaps it could
be auto-saved. Even a one-click option to save it with the current keyword
would be very helpful indeed.
Original issue reported on code.google.com by [email protected]
on 24 May 2009 at 2:07
What steps will reproduce the problem?
1. Click "Add field" adds a "new field" field to the selected table
2. Double click on the new field to edit its name / details
What is the expected output? What do you see instead?
It would make more sense to skip the 2nd step and directly open the edit
box when adding a new field.
What version of the product are you using? On what operating system?
Latest zip available
Original issue reported on code.google.com by [email protected]
on 8 Jul 2009 at 1:41
What steps will reproduce the problem?
1. It is not possible to drag n drop more than one table at the time (when
moving them around)
What is the expected output? What do you see instead?
It would very practical to be able to do so! :)
What version of the product are you using? On what operating system?
r45
Original issue reported on code.google.com by [email protected]
on 9 Jul 2009 at 12:04
What steps will reproduce the problem?
1. Import MyISAM table (no constraints)
2. Try to draw relations between already existing rows
What is the expected output? What do you see instead?
It is not possible to achieve this goal.
What version of the product are you using? On what operating system?
Doesn't matter.
Please provide any additional information below.
Additional information provided personally.
Original issue reported on code.google.com by [email protected]
on 7 Jan 2009 at 10:58
What steps will reproduce the problem?
1. Creating a relation / foreign key requires clicking on the button in the
menus
1.1. Changing the order of the fields in a table too!
What is the expected output? What do you see instead?
It would be great with those fields were dragable both within the table to
change their order, and to another table to create a new relation.
What version of the product are you using? On what operating system?
Latest zip available
Original issue reported on code.google.com by [email protected]
on 8 Jul 2009 at 1:58
What steps will reproduce the problem?
1. Install version 2.3.2 from google code
2. Use in Google Chrome
3. Compare Demo site @ http://ondras.zarovi.cz/sql/demo/?keyword=default
What is the expected output? What do you see instead?
My downloaded version does not show smooth connectors in google chrome also
the pane does not move in google chrome when moving the red rectangle in
the lower right corner. Functionality of local version is OK in IE7 and
Firefox. However when using the demo site in google chrome smooth
connectors and dragging the red rectangle works OK - Is the version on the
demo site different then the one on google code?
What version of the product are you using? On what operating system?
Windows XP,
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 10 Jun 2009 at 7:39
There are minor grammatical/style oddities in Polish localization.
The attached patch takes care of them.
Original issue reported on code.google.com by [email protected]
on 10 Nov 2009 at 5:08
Attachments:
What steps will reproduce the problem?
1. Add a table
2.
3.
What is the expected output? What do you see instead?
cursor is at end of 'name' field; 'new table' text should be highlighted to
save from having to do so.
What version of the product are you using? On what operating system?
2.3.2 Ubuntu 8.10
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 23 Apr 2009 at 2:17
What steps will reproduce the problem?
1.
2.
3.
What is the expected output? What do you see instead?
What version of the product are you using? On what operating system?
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 9 Jul 2009 at 12:02
Dear Ondrej
Find the attached file.
Congratulations for this nice project.
Zsolt
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 4:43
Attachments:
What steps will reproduce the problem?
1. Press Delete (command-delete) -- selected row/table gets deleted.
2. Press plain delete ("backspace" on PCs) -- the browser goes to the previous
page in the
history.
What is the expected output? What do you see instead?
On Macs, backspace is the customary key used to delete things. It should work
just like delete
does on PCs.
What version of the product are you using? On what operating system?
r61
Please provide any additional information below.
Implemented in the attached patch. Tested on most recent Safari, Opera and
Firefox on OS X
10.6.1. Works fine. This functionality is only enabled on Macs. On PCs, delete
is the right key to
use, *not* backspace.
Opera on Mac needed the well-known workaround, the latter is not applied on any
other
browser/platform for performance reasons.
Original issue reported on code.google.com by [email protected]
on 10 Nov 2009 at 7:04
Attachments:
What steps will reproduce the problem?
1. Create 2 tables w a relationship linking them together
2. Move one table so it is located beyond perimeter of 'full page viewer'.
What is the expected output? What do you see instead?
The relationship 'string' is no longer visible beyond the perimeter.
What version of the product are you using? On what operating system?
2.3.2 on firefox, ubuntu 8.1
Original issue reported on code.google.com by [email protected]
on 4 May 2009 at 1:59
What steps will reproduce the problem?
1. To load an existing model you need to copy paste the xml
What is the expected output? What do you see instead?
It would be nice to be able to "upload" (yes, again server backend needed
there) the file.
What version of the product are you using? On what operating system?
Latest zip available
Original issue reported on code.google.com by [email protected]
on 8 Jul 2009 at 1:47
What steps will reproduce the problem?
--------------------------------------
1. save the contents of a large database using the save/load dialog
2. refresh the page to clear the contents
3. load the document
What is the expected output? What do you see instead?
-----------------------------------------------------
all tables in the saved document to be visualized, instead nothing is shown
at all (likely the visualization is appropriately failing fast as the
output would be a malformed XML document).
Inspection of the database table (wwwsqldesigner) shows that the data
column is truncated in large XML files.
What version of the product are you using? On what operating system?
--------------------------------------------------------------------
wwwsqldesigner svn rev 47
Ubuntu Karmic Koala Alpha 2
LAMP stack (from debian repository)
Firefox 3.0.11 Ubuntu
Please provide any additional information below.
------------------------------------------------
As a suggestion perhaps the output of 'save' can be dumped into a static
xml file named, for example, "$WEBROOT/saved/$NAME.xml". Its probably
realistic to assume whoever is hosting wwwsqldesigner has the ability to
set writable permissions on the "saved" folder.
The wwwsqldesigner database table could then be modified to save only the
filename ($NAME) and not the data. As a nice side benefit you should get
free client-side caching, at least if you're hosting off of Apache you should.
The load request could then either echo out the content of the file, or
just provide a URL for the browser to perform a second AJAX request with.
I have not looked into the other database options (sqlite, etc) - so feel
free to comment on whether or not this logic will break them.
Original issue reported on code.google.com by [email protected]
on 10 Jul 2009 at 8:58
What steps will reproduce the problem?
1. Press LMB and drag across the viewport.
What is the expected output? What do you see instead?
A selection rubberband should appear. Regular browser text selection appears
instead within the
tables.
What version of the product are you using? On what operating system?
r63
Please provide any additional information below.
Working on a patch.
Original issue reported on code.google.com by [email protected]
on 15 Nov 2009 at 10:30
What steps will reproduce the problem?
1. create mysql database with only table:
CREATE TABLE `tableA` (
`id` UNSIGNED INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`id`)
);
2. import database to SQL Designer
3. export sql to re-create the table again
What is the expected output? What do you see instead?
the id is signed by default
What version of the product are you using? On what operating system?
Version 2.3.2 (8.1.2009)
Please provide any additional information below.
The tool is used in most cases to design database and then generate sql and
create tables. Workaround is to create tables and change types, but it's
hard to do it with many tables. Also foreign keys are problem when you
change types. It would be better id the tool supports UNSIGNED attribute
just like it supports INTEGER.
Original issue reported on code.google.com by [email protected]
on 22 Feb 2009 at 9:56
What steps will reproduce the problem?
1. Add a table
2. Cancel operation
3.
What is the expected output? What do you see instead?
if 'cancel' is selected, a blank table is still inserted on page. No table
should be created.
What version of the product are you using? On what operating system?
2.3.2 Ubuntu 8.10
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 23 Apr 2009 at 2:19
The type drop down list doesn't contain a data type for boolean (aka bit)
data types.
Original issue reported on code.google.com by [email protected]
on 22 Nov 2009 at 4:58
I save a scheme for every project and links are more comfortable than
navigating like "click on Save / Load, then Load and type 'projectname'"
Example: http://example.com/sql/#ps-projectname (where ps means php-sqlite
backend and projectname the title of stored schema)
Thanks ;)
Original issue reported on code.google.com by jkrcma
on 11 Aug 2009 at 10:48
What steps will reproduce the problem?
--------------------------------------
1. Import a large MySQL Database (>100 tables w/ ~8-10 fields each)
What is the expected output? What do you see instead?
-----------------------------------------------------
Over 100 tables with all their fields
What version of the product are you using? On what operating system?
--------------------------------------------------------------------
wwwsqldesigner svn rev 47
Ubuntu Karmic Koala Alpha 2
LAMP stack (from debian repository)
Please provide any additional information below.
------------------------------------------------
Firebug shows that the data returned from
http://localhost/wwwsqldesigner-svn/backend/php-mysql/?action=import&database=XY
Z
is a untruncated XML file with what appears to be the complete data set
(unverified). So this is likely an issue with whatever visualization
method is used.
Original issue reported on code.google.com by [email protected]
on 10 Jul 2009 at 8:43
Problem: PHP exceeds 30 second execution limit
Solution: place
ini_set("max_execution_time", 0);
At the top of the backend/php-mysql/index.php script
Original issue reported on code.google.com by [email protected]
on 31 Jan 2009 at 8:26
What steps will reproduce the problem?
1. Press Del when either row or a table is selected.
What is the expected output? What do you see instead?
Row/Table delete confirmation dialog should appear. Instead, nothing happens.
What version of the product are you using? On what operating system?
r57
Please provide any additional information below.
Implemented in the attached patch.
Original issue reported on code.google.com by [email protected]
on 10 Nov 2009 at 6:02
Attachments:
What steps will reproduce the problem?
1. Click "Save xml" fills the text area with the resulting xml
What is the expected output? What do you see instead?
It would be nice (although i believe it would also require a server side
backend,) to propose the resulting xml to be downloaded (and therefore no
need to copy / paste the xml).
Also the description of the db tables and fields are concatenated making
the xml a huge one line string which is heavy for buffers of most IDEs out
there : simple work around : new line on every closing tag!
What version of the product are you using? On what operating system?
latest zip available
Original issue reported on code.google.com by [email protected]
on 8 Jul 2009 at 1:45
What steps will reproduce the problem?
1. Load a database structure that is larger than the 'area' property
boundary in the 'styles/style.css' config file
2. Create a new foreign key constraint, or view existing FK constraint
connector lines
3. Scroll to the bottom of the defined CSS 'area' boundary and either view
that the existing connector lines going to tables located below the
boundary area are 'cut off', or drag a table with an existing FK connector
line below the boundary and note that the lines are cut off.
What is the expected output? What do you see instead?
Expected that the FK connector lines would continue to be drawn past the
'boundary', as the tables are correctly rendered past this point.
I see that the lines are 'cut off', although when dragging a table around
under the 'boundary', the lines continue to update and be drawn above the
'boundary'.
What version of the product are you using? On what operating system?
Latest stable download as of 06/30/2009. Fedora 10 Linux
2.6.27.21-170.2.56.fc10.x86_64 #1 SMP Mon Mar 23 23:08:10 EDT 2009 x86_64
x86_64 x86_64 GNU/Linux
Please provide any additional information below.
Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009061118
Fedora/3.0.11-1.fc10 Firefox/3.0.11
Original issue reported on code.google.com by [email protected]
on 1 Jul 2009 at 7:32
What steps will reproduce the problem?
1. Enable snap.
2. Drag a table around.
3. Create a new table.
What is the expected output? What do you see instead?
2: Table should snap while being dragged around. Instead,
it only snaps when the mouse cursor is released.
3: Newly placed tables are not snapped at all.
What version of the product are you using? On what operating system?
r61
Please provide any additional information below.
Attached patch implements visual feedback for snap while dragging, and while
placing new tables.
Original issue reported on code.google.com by [email protected]
on 11 Nov 2009 at 6:05
Attachments:
Dear Ondrej,
I attach a new locale xml file for Esperanto.
Could you add it to your project?
Thanks
Original issue reported on code.google.com by [email protected]
on 30 Oct 2009 at 1:55
Attachments:
Hi Ondřej,
it would be nice to have always a live demo with the current development
release. This would help me to keep track of the development of
wwwsqldesigner without the need to download and installing it. It would
help me also to figure out if the new features would work in the browser/os
I support. It would also fasten the feedback I can give on new features.
Simon
Original issue reported on code.google.com by [email protected]
on 18 Nov 2009 at 5:10
What steps will reproduce the problem?
1. Clicking "Align tables" aligns the table at the top of the workspace
making the relations invisible (if you have some!)
What is the expected output? What do you see instead?
It would be great to have an "autolayout" button (like in mysql workbench)
to auto-magically organize all the tables in an optimal way (trying to have
the relations not crossing each other for instance)!
What version of the product are you using? On what operating system?
Latest zip available
Original issue reported on code.google.com by [email protected]
on 8 Jul 2009 at 1:54
see image:
long word can't be displayed
Original issue reported on code.google.com by 007NOT
on 5 Feb 2009 at 12:29
Attachments:
What steps will reproduce the problem?
1. Generate SQL code for Postgresql using tables having foreign keys
What is the expected output? What do you see instead?
We get:
<< ALTER TABLE "table" ADD FOREIGN KEY (columnName) REFERENCES "table2"
("columnNameID"); >>
but should be:
<< ALTER TABLE "table" ADD FOREIGN KEY ("columnName") REFERENCES "table2"
("columnNameID"); >>
Quotes are missing at foreign key column.
What version of the product are you using? On what operating system?
version 2.3.2
Please provide any additional information below.
This will not be of any issue to anyone naming their columns in lowercase only.
Original issue reported on code.google.com by [email protected]
on 19 Apr 2009 at 11:57
It would be invalueable if it'd have a PSQL backend and be able to load a
psql databases :)
Original issue reported on code.google.com by [email protected]
on 30 Mar 2009 at 9:53
Is it possible to just import a SQL string to wwwsqldesigner?
Original issue reported on code.google.com by [email protected]
on 20 Aug 2009 at 2:05
Line 81:
$result = sqlite_query( "SELECT `data` FROM ".TABLE." WHERE keyword =
'$keyword'" , $GLOBALS['sqlConnect'] );
SQLite doesn't recognize the backtick operators, they should be removed.
Original issue reported on code.google.com by jkrcma
on 11 Aug 2009 at 10:42
the foreign key feature should be available on "unique" key
for instance
create table test (
id bigserial unique
)
create table blah (
test_id bigint references test(id)
)
works in postgresql
Original issue reported on code.google.com by [email protected]
on 8 Jun 2009 at 2:00
It would be nice if we could also remove foreign key connections we may
have accidentally created.
Original issue reported on code.google.com by [email protected]
on 1 Feb 2009 at 1:20
Hi Ondřej,
how can I catch the event when a schema was successful loaded?
Simon
Original issue reported on code.google.com by [email protected]
on 28 Aug 2009 at 3:10
WWW SQL Designer will switch from GNU GPL to BSD. Someday.
Original issue reported on code.google.com by ondrej.zara
on 24 Apr 2009 at 8:24
What steps will reproduce the problem?
1. 'create foreign key' from a primary key of data type 'serial'
2.
3.
What is the expected output? What do you see instead?
the resultant foreign key is of data type serial. Should be 'integer' if
reference column is 'serial' or 'bigint' if reference column is 'bigserial'.
What version of the product are you using? On what operating system?
2.3.2 ubuntu 8.10
Please provide any additional information below.
This is a Postgresql related issue. Serial/bigserial are pseudo-types
Original issue reported on code.google.com by [email protected]
on 23 Apr 2009 at 2:25
in order to be able to use the drawing in reports and the like, exporting
the schema as a picture, as a png file with transparent background (no grid)
Original issue reported on code.google.com by [email protected]
on 8 Jun 2009 at 2:32
What steps will reproduce the problem?
1. Vytvoreni tabulky bez primarniho klice
2. Export do SQL (MySQL)
3.
What is the expected output? What do you see instead?
Klasicky kod pro vytvoreni tabulky, ale BEZ direktivy PRIMARY KEY. Kdezto i
kdyz u tabulky nespecifikuji primarni klic, tak ona direktiva se
vygeneruje. Viz tento vypis:
CREATE TABLE `articles_tags` (
`article_id` INTEGER NOT NULL ,
`tag_id` INTEGER NOT NULL ,
PRIMARY KEY ()
) COMMENT 'Articles <> Tags spoiler';
coz samozrejme neni spravne :)
What version of the product are you using? On what operating system?
2.3.1, ArchLinux
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 7 Jan 2009 at 5:05
Purely code style issues, namely
if (l) this.typeIndex[l] = i;
should be
if (l) { this.typeIndex[l] = i; }
and an object initialization should be moved to beginning of the
block to be consistent.
I missed it when submitting the patch that got integrated in r60.
Patch attached.
Original issue reported on code.google.com by [email protected]
on 10 Nov 2009 at 1:50
Attachments:
better ru.xml translate (more translated words)
Original issue reported on code.google.com by 007NOT
on 5 Feb 2009 at 9:17
Attachments:
What steps will reproduce the problem?
1. When saving to db with the php-mysql backend we always overwrite the
existing data.
What is the expected output? What do you see instead?
It would be interesting to save revisions of the xml instead to one can
review the changes applied over time (I'll give it a try).
What version of the product are you using? On what operating system?
r45
Original issue reported on code.google.com by [email protected]
on 9 Jul 2009 at 12:01
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.