I subscribed to the turbine list just a few minutes ago, so if a similar patch has been posted earlier today, I apologize. I modified the Sybase schema files to (a) drop the constraints and tables if they previously existed and (b) include the CONFIRM_VALUE column, required by the current version of Jyve, in the Visitor table. Since I am using Sybase SQL Server 11, however, I still have a problem: auto-incrementing sequences don't exist (as far as I know), so when org.apache.jyve.actions.CreateNewUserAndConfirm tries to add a record to the visitor table without manually populating the VISITORID column, we have a problem. I suppose this is probably an issue for the Jyve mailing list, but it affects Turbine since the schemas are different when you make your columns auto-increment. Anyway, here are the patches. Hopefully they will be useful. cvs -d :pserver:[EMAIL PROTECTED]:/products/cvs/turbine diff Sybase_id_table.sql Index: Sybase_id_table.sql =================================================================== RCS file: /products/cvs/turbine/turbine/docs/schemas/Sybase_id_table.sql,v retrieving revision 1.1 diff -r1.1 Sybase_id_table.sql 9a10,16 > > if exists (select 1 from sysobjects where type = "U" and name = "ID_TABLE") > begin > drop table ID_TABLE > end > go > -------------------------------------------------------------------------------- cvs -d :pserver:[EMAIL PROTECTED]:/products/cvs/turbine diff Sybase_users_roles_permissions.sql Index: Sybase_users_roles_permissions.sql =================================================================== RCS file: /products/cvs/turbine/turbine/docs/schemas/Sybase_users_roles_permissions.sql,v retrieving revision 1.1 diff -r1.1 Sybase_users_roles_permissions.sql 7a8,27 > /* Drop constraints */ > /* ============================================================ */ > if exists (select 1 from sysobjects where type ="RI" and name='FK_ROLEPERM_REF_83_PERMISSI') > alter table RolePermission drop constraint FK_ROLEPERM_REF_83_PERMISSI > go > > if exists (select 1 from sysobjects where type ="RI" and name='FK_ROLEPERM_REF_86_USERROLE') > alter table RolePermission drop constraint FK_ROLEPERM_REF_86_USERROLE > go > > if exists (select 1 from sysobjects where type ="RI" and name='FK_VISITORR_REF_89_USERROLE') > alter table VisitorRole drop constraint FK_VISITORR_REF_89_USERROLE > go > > if exists (select 1 from sysobjects where type ="RI" and name='FK_VISITORR_REF_92_VISITOR') > alter table VisitorRole drop constraint FK_VISITORR_REF_92_VISITOR > go > > > /* ============================================================ */ 9a30,36 > > if exists (select 1 from sysobjects where type = "U" and name = "Jobentry") > begin > drop table Jobentry > end > go > 25a53,59 > > if exists (select 1 from sysobjects where type = "U" and name = "Permission") > begin > drop table Permission > end > go > 42a77,83 > > if exists (select 1 from sysobjects where type = "U" and name = "UserRole") > begin > drop table UserRole > end > go > 59a101,107 > > if exists (select 1 from sysobjects where type = "U" and name = "Visitor") > begin > drop table Visitor > end > go > 87a136 > CONFIRM_VALUE varchar(99) null , 100a150,156 > > if exists (select 1 from sysobjects where type = "U" and name = "RolePermission") > begin > drop table RolePermission > end > go > 110a167,173 > > if exists (select 1 from sysobjects where type = "U" and name = "VisitorRole") > begin > drop table VisitorRole > end > go > 117a181,183 > /* ============================================================ */ > /* Create constraints */ > /* ============================================================ */ _________________________________________________________ Li Markakis (212)480-5823 x229 Random Walk Computing [EMAIL PROTECTED] ------------------------------------------------------------ To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
