Tickets :: [#8584] change share_id typ to integer on postgresql

6.0.0-beta1

7/6/25

Summary	change share_id typ to integer on postgresql
Queue	Turba
Queue Version	2.3.2
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org
Requester	michael.menge (at) zdv (dot) uni-tuebingen (dot) de
Created	09/17/2009 (5771 days ago)
Due
Updated	01/13/2010 (5653 days ago)
Assigned	09/25/2009 (5763 days ago)
Resolved	09/25/2009 (5763 days ago)
Github Issue Link
Github Pull Request
Milestone	2.3.3
Patch	No

01/13/2010 12:12:13 AM	CVS Commit	Comment #13	Reply to this comment
Changes have been made in Git for this ticket: Add upgrade script (~~Bug #8584~~). create mode 100644 turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql http://git.horde.org/diff.php/turba/docs/UPGRADING?rt=horde-git&r1=99d3ec3de78ee8fb862d211e2b330747a31aac23&r2=f32cdb41522af0536afc5ae308a9c5e4ddc96189 http://git.horde.org/co.php/turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql?rt=horde-git&r=f32cdb41522af0536afc5ae308a9c5e4ddc96189

01/13/2010 12:12:11 AM	CVS Commit	Comment #12	Reply to this comment
Changes have been made in Git for this ticket: Fix share_id column type (~~Bug #8584~~). http://git.horde.org/diff.php/turba/scripts/sql/turba.pgsql.sql?rt=horde-git&r1=99d3ec3de78ee8fb862d211e2b330747a31aac23&r2=3a62ffbed8f1d3773cdd6345be95f7b4d85706e9

09/25/2009 03:24:30 PM	Jan Schneider	Comment #11	Reply to this comment
Thanks!

09/25/2009 03:24:27 PM	CVS Commit	Comment #10	Reply to this comment
Changes have been made in CVS for this ticket: MFH: Add upgrade script (~~Bug #8584~~). http://cvs.horde.org/diff.php/turba/docs/UPGRADING?rt=horde&r1=1.3.6.28&r2=1.3.6.29&ty=u http://cvs.horde.org/co.php/turba/scripts/upgrades/Attic/2.3_to_2.3.3.pgsql.sql?rt=horde&r=1.1.2.1

09/25/2009 03:20:47 PM	CVS Commit	Comment #9	Reply to this comment
Changes have been made in Git for this ticket: Add upgrade script (~~Bug #8584~~). create mode 100644 turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql http://git.horde.org/diff.php/turba/docs/UPGRADING?rt=horde-hatchery&r1=99d3ec3de78ee8fb862d211e2b330747a31aac23&r2=f32cdb41522af0536afc5ae308a9c5e4ddc96189 http://git.horde.org/co.php/turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql?rt=horde-hatchery&r=f32cdb41522af0536afc5ae308a9c5e4ddc96189

09/25/2009 02:56:00 PM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #8 New Attachment: 2.3.2_to_2.3.3.pgsql.sql	Reply to this comment
here is the script

09/25/2009 01:04:49 PM	Jan Schneider	Comment #7	Reply to this comment
If you want to contribute one, that would be nice.

09/25/2009 12:42:32 PM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #6	Reply to this comment
Should there be an upgrade script reflecting these chandes in turba/script/upgrades ?

09/25/2009 12:30:58 PM	Jan Schneider	Comment #5 State ⇒ Resolved Milestone ⇒ 2.3.3 Assigned to Jan Schneider	Reply to this comment
Fixed.

09/25/2009 12:30:49 PM	CVS Commit	Comment #4	Reply to this comment
Changes have been made in CVS for this ticket: MFH: Fix share_id column type (~~Bug #8584~~). http://cvs.horde.org/diff.php/turba/scripts/sql/turba.pgsql.sql?rt=horde&r1=1.1.2.9&r2=1.1.2.10&ty=u

09/25/2009 12:26:37 PM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in Git for this ticket: Fix share_id column type (~~Bug #8584~~). http://git.horde.org/diff.php/turba/scripts/sql/turba.pgsql.sql?rt=horde-hatchery&r1=99d3ec3de78ee8fb862d211e2b330747a31aac23&r2=3a62ffbed8f1d3773cdd6345be95f7b4d85706e9

09/25/2009 12:21:06 PM	Jan Schneider	Comment #2 Priority ⇒ 1. Low State ⇒ Assigned Type ⇒ Bug Queue ⇒ Turba Version ⇒ 2.3.2	Reply to this comment
Only the Turba SQL script uses SMALLINT.

09/17/2009 02:27:49 PM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #1 Priority ⇒ 1. Low State ⇒ New Patch ⇒ No Milestone ⇒ Summary ⇒ change share_id typ to integer on postgresql Type ⇒ Enhancement Queue ⇒ Horde Framework Packages	Reply to this comment
the typ of the share_id column is set to smallint for postgres. This is to small if you have a rapid turnover of users and should be changed to integer.