From [email protected] on July 01, 2009 21:32:41

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=24

From [email protected] on July 08, 2009 15:45:27

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=26

From [email protected] on July 10, 2009 10:43:16

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=XYZ
   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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=33

From [email protected] on October 30, 2009 14:55:33

Dear Ondrej,

I attach a new locale xml file for Esperanto.

Could you add it to your project?

Thanks

Attachment: eo.xml

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=40

From [email protected] on November 11, 2009 19:05:35

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.

Attachment: vsnap.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=46

From [email protected] on November 10, 2009 07:02:47

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.

Attachment: del.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=43

From [email protected] on July 08, 2009 15:54:12

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=28

From [email protected] on January 07, 2009 18:05:23

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=3

From [email protected] on January 31, 2009 21:26:23

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=6

From [email protected] on November 10, 2009 20:04:58

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.

Attachment: mac-delete.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=45

From jkrcma on August 12, 2009 00:48:15

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=36

From [email protected] on July 08, 2009 15:58:14

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=29

From [email protected] on February 01, 2009 02:20:14

It would be nice if we could also remove foreign key connections we may
have accidentally created.

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=7

From 007NOT on February 05, 2009 13:29:31

see image:
long word can't be displayed

Attachment: noname.png

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=9

From [email protected] on November 18, 2009 18:10:14

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=48

From [email protected] on December 26, 2008 07:45: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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=1

From ondrej.zara on April 24, 2009 22:24:35

WWW SQL Designer will switch from GNU GPL to BSD. Someday.

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=17

From [email protected] on February 22, 2009 22:56:45

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=10

From [email protected] on July 09, 2009 14:02:02

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=31

From [email protected] on April 23, 2009 04:17:40

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=14

Mysql functions will be removed.

From [email protected] on August 28, 2009 17:10:08

Hi Ondřej,
how can I catch the event when a schema was successful loaded?
Simon

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=38

From [email protected] on April 23, 2009 04:19:34

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=15

From [email protected] on April 23, 2009 04:25:12

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=16

From [email protected] on November 10, 2009 06:08:13

There are minor grammatical/style oddities in Polish localization.
The attached patch takes care of them.

Attachment: pl2.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=42

From [email protected] on June 08, 2009 16:32:18

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=21

From [email protected] on June 08, 2009 16:00:19

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=20

From [email protected] on July 09, 2009 14:01:44

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=30

From [email protected] on January 07, 2009 11:58:13

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=2

From [email protected] on April 20, 2009 01:57:40

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=13

From [email protected] on November 15, 2009 11:30:24

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=47

From [email protected] on October 09, 2009 18:43:26

Dear Ondrej

Find the attached file.
Congratulations for this nice project.

Zsolt

Attachment: hu.xml

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=39

From [email protected] on May 24, 2009 16:07:55

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=19

From [email protected] on May 04, 2009 03:59:32

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=18

From [email protected] on July 10, 2009 10:58:36

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=34

From [email protected] on February 23, 2009 19:56:18

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=11

From [email protected] on January 26, 2009 23:53:47

Hi Ondřej,
is it possible to create the XML schema file out of a sql file?
Simon

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=4

From [email protected] on November 10, 2009 14:50:51

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.

Attachment: postgresql-code-style.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=44

From [email protected] on July 08, 2009 15:47:14

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=27

From [email protected] on July 09, 2009 14:04:30

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=32

From [email protected] on July 08, 2009 15:41:23

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=25

From 007NOT on February 05, 2009 10:17:31

better ru.xml translate (more translated words)

Attachment: ru.xml

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=8

From [email protected] on November 22, 2009 06:13:35

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=50

From [email protected] on August 20, 2009 16:05:43

Is it possible to just import a SQL string to wwwsqldesigner?

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=37

From [email protected] on November 08, 2009 09:48:56

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.

Attachment: locale-pl.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=41

From [email protected] on June 10, 2009 21:39:01

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=22

From jkrcma on August 12, 2009 00:42:40

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=35

From [email protected] on November 22, 2009 05:58:00

The type drop down list doesn't contain a data type for boolean (aka bit)
data types.

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=49

From [email protected] on March 30, 2009 11:53:38

It would be invalueable if it'd have a PSQL backend and be able to load a
psql databases :)

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=12

From [email protected] on June 27, 2009 18:37:03

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: http://code.google.com/p/wwwsqldesigner/issues/detail?id=23