Forum Replies Created
-
AuthorPosts
-
May 6, 2015 at 12:35 am in reply to: Feature Request: Intelligent Defaults For Database Copy Dialog #35025Bruce LeisterMember
I agree with Peter, and want a like to like databse name copy (perhaps as an option to be set, so existing users do not see the change, until they choose it)
This is a BIG THUMBS UP, please implement it ASAP
Bruce LeisterMemberI am seeing the same on my V6.54, now that it is mentioned, had not noticed the left hand border til I went looking at it.
I have noticed for a number of point releases now, the absence of the right hand border, because it looked funny, with the close x right up against the window border (the x to close the query editor/schema designer tabs)
but was not serious enough to warrant the effort to complain :D:-)
Bruce Leister
I have a IBM T60 Thinkpad
Display adapter Mobile Intel 945GM Express Chipset
driver 14/12/05 6.14.10.4450
Bruce LeisterMemberI also find it slightly annoying that I have to click on the Database in the Object Browser, and a again on tables to get a list of the tables in the Database.
I agree that there could be situations where it is not desirable to open the Tables tree (to list the tables), so perhaps we could have an option in Preferences to:
Auto-Open Tables tree when database is first selected (expended)
Bruce Leister
Bruce LeisterMemberThese are the three table definitions,
badge_readers are many to many to areas on area field
and areas is many to one to categories on category
table badge_readers – primary key badge_reader, also a foreign key on area
table areas – primary key area,category, also a non unique index(foreign key) on category
table categories – primary key category
Bruce.
[codebox]CREATE TABLE `badge_readers` (
`badge_reader` char(8) NOT NULL,
`site` char(2) NOT NULL,
`floor` char(2) NOT NULL,
`location` char(20) NOT NULL,
`area` char(40) NOT NULL,
PRIMARY KEY (`badge_reader`),
KEY `FK_badge_readers` (`area`),
CONSTRAINT `FK_badge_readers` FOREIGN KEY (`area`) REFERENCES `areas` (`area`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC [/codebox]
[codebox]CREATE TABLE `areas` (
`area` char(40) NOT NULL,
`category` char(40) NOT NULL,
PRIMARY KEY (`area`,`category`),
KEY `FK_areas` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC[/codebox]
[codebox]CREATE TABLE `categories` (
`category` char(40) NOT NULL,
`owner_uid` char(9) NOT NULL,
`owner_email` char(60) NOT NULL,
`backup_uid` char(9) NOT NULL,
`backup_email` char(60) NOT NULL,
PRIMARY KEY (`category`),
CONSTRAINT `FK_categories` FOREIGN KEY (`category`) REFERENCES `areas` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC[/codebox]
Bruce LeisterMemberIt means it loops forever – (a nice animation swapping from page to page as the menu items change) or until I move the mouse
Bruce LeisterMemberpeterlaursen wrote on Nov 17 2006, 05:24 PM:what format (HTML, CHM or PDF) ?which version ?
what language ?
from where to get it?
Allow CHM, and a preference setting to define the location on the PC
-
AuthorPosts