phpGroupWare - Support: sr #103400, schema_proc 'UNIQUE' feature...
You are not allowed to post comments on this tracker with your current authentication level.
sr #103400: schema_proc 'UNIQUE' feature working like 'INDEX'
Submitter: | Caeies <Caeies> | ||
Submitted: | Mon 27 Sep 2004 08:16:15 AM UTC | ||
Category: | Feature Request | Priority: | 5 - Normal |
Severity: | 3 - Normal | Status: | None |
Privacy: | Public | Assigned to: | Caeies |
Open/Closed: | Open | Operating System: | None |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
CC list is empty
There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.
Follow 2 latest changes.
Date | Changed by | Updated Field | Previous Value | => | Replaced by |
---|---|---|---|---|---|
2004-09-27 | Caeies | Assigned to | None | Caeies | |
2004-09-27 | Caeies | Carbon-Copy | - | Added skwashd |
Powered by Savane 3.13-02a9.
Corresponding source code
Hi,
Ok, this is more a reminder than a real support request.
Can you (I :) implement the UNIQUE() in table creation in the same way we are handling the INDEX ones ... I mean :
if I build a table with :
uc => array(id,name),
I get in the Create table query : UNIQUE(id),UNIQUE(name)
and not as it is currently the case : UNIQUE(id,name)
To get this second behavior, use a :
uc => array(id,array(id,name))
which will be turned into UNIQUE(id), UNIQUE(id,name)
We should be aware of potential breaks from older apps that rely on this behavior.
Hope that I'm clear :)
Regards,
Caeies