sid shouldn't be auto_increment; just seems like a horrid type no one's noticed before.

Fix would be to change sid to an int, define a primary key as sid + rid, add an update function to alter the schema.

Don't think it's causing any visual bugs, just a WTF.

Comments

hefox’s picture

Title: workflow_access has incorrect type for sid (current: serial) » workflow_access table schema has incorrect type for sid (current: serial)
Bastlynn’s picture

Assigned: Unassigned » Bastlynn

Eeeeeew, yeah, you're right. And since I was doing a flat port from 6 to 7 it's in 7 as well. I'll get started on it tonight.

johnv’s picture

Component: Code » Workflow Access: Code
johnv’s picture

Version: 6.x-1.x-dev » 7.x-1.2
Assigned: Bastlynn » Unassigned
Issue summary: View changes
Status: Active » Fixed

This is fixed in this commit.
There will be no backport for D6.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.