maxwaldorf Posted October 22, 2009 Report Posted October 22, 2009 Hi Nabeel, I have discussing a lot with pilots in my VA and they seem to be disapointed by the fact we can't have two aircraft with same name and two different registration codes. As for MYSQL table primary key is set to "ID" and unique to "Name", it would be better to set unqiue to regitration number... I guess modding it would imply to change code in ACARS, etc... Cheers ! Quote
TAV1702 Posted October 22, 2009 Report Posted October 22, 2009 A couple guys in my VA are helping me test out as I build and we talked about the very same thing. Believe it or not, we do have a cessna 182 RG that we would love to have a few different ones of in the system for sight seeing and such around the KC and St Louis area. As it stands now, we can only use one so I have had to get a quick cessna in the system for now. Hopefully this feature can be added soon to allow multiple of the same with different reg numbers. Quote
Administrators Nabeel Posted October 22, 2009 Administrators Report Posted October 22, 2009 You should be able to? I thought that bug was fixed. Let me look through my notes. You're supposed to be able to though. You can remove the UNIQUE key on the table. I don't think there are any code checks. Internally, I only use the registration (including in the import/export files) Quote
Administrators Nabeel Posted October 22, 2009 Administrators Report Posted October 22, 2009 That's odd, I don't have a UNIQUE key in my master database for the name. What version are you guys on? There's no checks in the code either on the name when adding, just on registration. Quote
TAV1702 Posted October 22, 2009 Report Posted October 22, 2009 Well Nabeel, I have not tried it since I updated from full to Beta last night. I'll give it a go here in a little bit and so if it works or not. Hopefully it does. ;D Quote
Administrators Nabeel Posted October 22, 2009 Administrators Report Posted October 22, 2009 Great, thanks. If it doesn't, you'll have to remove a UNIQUE key from the database. If you have to do that, let me know, because I'll need the SQL query it generates to do that to include in my update script. Quote
maxwaldorf Posted October 22, 2009 Author Report Posted October 22, 2009 Well my database is almost 1 year old ! I've been through so many versions... I guess you should check that in your sql check quierery... Cheers Quote
Administrators Nabeel Posted October 22, 2009 Administrators Report Posted October 22, 2009 Which version of phpVMS are you on now? The UNIQUE was removed long ago. Quote
Administrators Nabeel Posted October 23, 2009 Administrators Report Posted October 23, 2009 Can you manually remove the UNIQUE index in phpmyadmin, and when you do that, it shows the query it used on top of the page, can you paste that in so I can include it in the updater? Thanks Quote
maxwaldorf Posted October 25, 2009 Author Report Posted October 25, 2009 Alright ! So just paste in your sql code : ALTER TABLE `phpvms_aircraft` DROP INDEX `name` Cheers ! Quote
Administrators Nabeel Posted October 25, 2009 Administrators Report Posted October 25, 2009 Thank you sir! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.