According to mysql.com it is a new feature in 4.1! /jacob
----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 9:32 AM Subject: Re: Slide and multiple languange?? > Does 4.0 understand or at least tolerate this "CHARACTER SET uft8 > COLLATE utf8_general_ci" thing? If so we might change the default scheme... > > Oliver > > Jacob Lund wrote: > > > You have to tell mysql that you want to store the data as unicode. I have > > attached a draft of the scheme! I have no idea if it work since my 4.1 > > installation has some personal issues with me. > > > > /jacob > > > > ----- Original Message ----- > > From: "Oliver Zeigermann" <[EMAIL PROTECTED]> > > To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, April 21, 2004 9:12 AM > > Subject: Re: Slide and multiple languange?? > > > > > > > >>I had 4.1 running and tested it with the MySql store and it worked. I > >>have no idea if the UTF-8 thing works. Maybe a change in scheme is needed? > >> > >>Oliver > >> > >>? ?? wrote: > >> > >>>thx for your email. then do you know how to solve the problem in mySQL? > >>> > >>> > >>> > >>>>From: "Jacob Lund" <[EMAIL PROTECTED]> > >>>>Reply-To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >>>>To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >>>>Subject: Re: Slide and multiple languange?? > >>>>Date: Tue, 20 Apr 2004 13:03:11 +0200 > >>>> > >>>>MySql 4.0 does not support UTF-8! Mysql 4.1 should, but it is still in > >>> > >>>alpha > >>> > >>> > >>>>and I have not succeeded in getting it to work yet! > >>>> > >>>>/jacob > >>>> > >>>>----- Original Message ----- > >>>>From: "? ??" <[EMAIL PROTECTED]> > >>>>To: <[EMAIL PROTECTED]> > >>>>Sent: Tuesday, April 20, 2004 12:32 PM > >>>>Subject: Re: Slide and multiple languange?? > >>>> > >>>> > >>>> > >>>>>I thought the problem maybe lie in mySql, since if I use the same > >>> > >>>chinese > >>> > >>> > >>>>>name to download the file in Slide, it success although the file is > >>> > >>>shown > >>> > >>> > >>>>>as ???.txt. I check the file name in mySql, the file show the same as > >>>>>???.txt. But I still don't know how can I solve the problem. > >>>>> > >>>>> > >>>>> > >>>>>>From: "Jacob Lund" <[EMAIL PROTECTED]> > >>>>>>Reply-To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >>>>>>To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >>>>>>Subject: Re: Slide and multiple languange?? > >>>>>>Date: Tue, 20 Apr 2004 11:55:31 +0200 > >>>>>> > >>>>>>I don't know anything about jboss! But when I used TC 4.1 i had to > > > > use > > > >>>>the > >>>> > >>>>>>coyoteconnector and apply useURIValidationHack="false" in order to > > > > get > > > >>>>>UTF-8 > >>>>> > >>>>>>working properly. > >>>>>> > >>>>>>/jacob > >>>>>> > >>>>>>----- Original Message ----- > >>>>>>From: "? ??" <[EMAIL PROTECTED]> > >>>>>>To: <[EMAIL PROTECTED]> > >>>>>>Sent: Tuesday, April 20, 2004 11:43 AM > >>>>>>Subject: Re: Slide and multiple languange?? > >>>>>> > >>>>>> > >>>>>> > >>>>>>>thanks for your reply. > >>>>>>> > >>>>>>>I use slide 2RC1 with Jboss3.0.8+tomcat4.1.24. which seems > > > > tomcat's > > > >>>>>>>server.xml doesnot work when I start the Jboss+tomcat, I have > > > > found > > > >>>>>that > >>>>> > >>>>>>>org.apache.slide.urlEncoding=UTF-8 had been set in > > > > slide.properties > > > >>>>>file. > >>>>> > >>>>>>>I have follow your words as following: > >>>>>>> > >>>>>>> <contentstore > >>>>>>>classname="org.apache.slide.store.txfile.TxFileContentStore"> > >>>>>>> <parameter name="rootpath">slide/fileContent</parameter> > >>>>>>> <parameter name="workpath">slide/workContent</parameter> > >>>>>>> <parameter name="version">true</parameter> > >>>>>>> <parameter name="url-encode-path">true</parameter> > >>>>>>> </contentstore> > >>>>>>> > >>>>>>>However, when I successfully upload a file in slide, and use > >>>>>>>propfindMehtod, the file name still display as ???.txt. the > >>> > >>>properties > >>> > >>> > >>>>>>>shown as following(see <D:href> and <D:displayname>): > >>>>>>> > >>>>>>>------------------------------------------------ > >>>>>>> > >>>>>>><D:response xmlns:D="DAV:"> > >>>>> > >>>> > > <D:href>/slide/files/testtomcat%C3%A4%C2%B8%C2%AD%C3%A6%C2%96%C2%87.test</D > > > >>> > >>>>: > >>>> > >>>>>>href> > >>>>> > >>>>>>> <D:propstat> > >>>>> > >>>>>>> <D:prop> > >>>>> > >>>>>>> <D:displayname>testtomcat??????.test</D:displayname> > >>>>> > >>>>>>> <D:source></D:source> > >>>>> > >>>>>>> <D:getlastmodified>Tue, 20 Apr 2004 09:32:20 > >>>>>>>GMT</D:getlastmodified> > >>>>> > >>>>>>> <D:getcontentlength>852</D:getcontentlength> > >>>>> > >>>>>>> <D:resourcetype></D:resourcetype> > >>>>> > >>>>>>> <D:getcontenttype>application/octet-stream</D:getcontenttype> > >>>>> > >>>>>>> <D:getcontentlanguage>en</D:getcontentlanguage> > >>>>> > >>>>>>> <D:creationdate>2004-04-20T09:17:21Z</D:creationdate> > >>>>> > >>>>>>> <D:lockdiscovery></D:lockdiscovery> > >>>>> > >>>>>>> <D:supportedlock> > >>>>> > >>>>>>> <D:lockentry> > >>>>> > >>>>>>> <D:lockscope> > >>>>> > >>>>>>> <D:exclusive></D:exclusive> > >>>>> > >>>>>>> </D:lockscope> > >>>>> > >>>>>>> <D:locktype> > >>>>> > >>>>>>> <D:write></D:write> > >>>>> > >>>>>>> </D:locktype> > >>>>> > >>>>>>> </D:lockentry> > >>>>> > >>>>>>> <D:lockentry> > >>>>> > >>>>>>> <D:lockscope> > >>>>> > >>>>>>> <D:shared></D:shared> > >>>>> > >>>>>>> </D:lockscope> > >>>>> > >>>>>>> <D:locktype> > >>>>> > >>>>>>> <D:write></D:write> > >>>>> > >>>>>>> </D:locktype> > >>>>> > >>>>>>> </D:lockentry> > >>>>> > >>>>>>> </D:supportedlock> > >>>>> > > <D:modificationdate>2004-04-20T09:32:20Z</D:modificationdate> > > > >>>>>>> <D:getetag>791b7c7bddf9ae4259e6c8d2a7ad0f1a</D:getetag> > >>>>> > >>>>>>> </D:prop> > >>>>> > >>>>>>> <D:status>HTTP/1.1 200 OK</D:status> > >>>>> > >>>>>>> </D:propstat> > >>>>> > >>>>>>></D:response> > >>>>>>> > >>>>>>>>From: "Jacob Lund" <[EMAIL PROTECTED]> > >>>>>>>>Reply-To: "Slide Users Mailing List" > >>> > >>><[EMAIL PROTECTED]> > >>> > >>>>>>>>To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >>>>>>>>Subject: Re: Slide and multiple languange?? > >>>>>>>>Date: Tue, 20 Apr 2004 11:11:24 +0200 > >>>>>>>> > >>>>>>>>what version of slide are you using and what servlet engine are > >>> > >>>you > >>> > >>> > >>>>>>using? > >>>>>> > >>>>>>>>I have slide 2RC1 working fine with utf-8 encoding on a tomcat > > > > 5. > > > >>>>Here > >>>> > >>>>>is > >>>>> > >>>>>>>>what I did to make it work: > >>>>>>>>In slide: > >>>>>>>>Add a parameter url-encode-path in the tx content and > > > > descriptors > > > >>>>>store > >>>>> > >>>>>>>and > >>>>>>> > >>>>>>>>set it to true. (in domain.xml) > >>>>>>>>In tomcat 5: > >>>>>>>>add URIEncoding="UTF-8" as parameter to the connector in > >>> > >>>server.xml. > >>> > >>> > >>>>>>>>I have not tested it with Chinese but it works with Russian and > >>>> > >>>>Danish > >>>> > >>>>>on > >>>>> > >>>>>>>an > >>>>>>> > >>>>>>>>English machine. > >>>>>>>> > >>>>>>>>Just notice that this requires your client to support UTF-8 > >>> > >>>encoding. > >>> > >>> > >>>>>>>>/jacob > >>>>>>>> > >>>>>>>>----- Original Message ----- > >>>>>>>>From: "? ??" <[EMAIL PROTECTED]> > >>>>>>>>To: <[EMAIL PROTECTED]> > >>>>>>>>Sent: Tuesday, April 20, 2004 10:48 AM > >>>>>>>>Subject: Slide and multiple languange?? > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>>hi, > >>>>>>>>> > >>>>>>>>>does the Slide support Chinese? if so how to? > >>>>>>>>> > >>>>>>>>>I have put a file onto the slide, when I use propfindmethod > > > > to > > > >>>>>display > >>>>> > >>>>>>>the > >>>>>>> > >>>>>>>>>file name, the file with Chinese name is shown as ???.txt. I > >>> > >>>think > >>> > >>> > >>>>>>some > >>>>>> > >>>>>>>>one > >>>>>>>> > >>>>>>>>>may also face such multiple language problem, but how to deal > >>> > >>>with > >>> > >>> > >>>>>it? > >>>>> > >>>>>>>>>Thanks for any help. > >>>>>>>>> > >>>>>>>>> > >>> > >>>_________________________________________________________________ > >>> > >>> > >>>>>>>>>??????????,??? MSN Messenger: > >>>>>>> > >>>>>>>http://messenger.msn.com/cn > >>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>--------------------------------------------------------------------- > >>>>> > >>>>>>>>>To unsubscribe, e-mail: > >>> > >>>[EMAIL PROTECTED] > >>> > >>> > >>>>>>>>>For additional commands, e-mail: > >>>> > >>>>[EMAIL PROTECTED] > >>>> > >>>>>>>> > >>>>--------------------------------------------------------------------- > >>>> > >>>>>>>>To unsubscribe, e-mail: > > > > [EMAIL PROTECTED] > > > >>>>>>>>For additional commands, e-mail: > >>> > >>>[EMAIL PROTECTED] > >>> > >>> > >>>>>>>_________________________________________________________________ > >>>>>>>???? MSN Explorer: http://explorer.msn.com/lccn > >>>>>>> > >>>>>>> > >>>>>>> > >>> > >>>--------------------------------------------------------------------- > >>> > >>> > >>>>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>>>For additional commands, e-mail: > > > > [EMAIL PROTECTED] > > > >>>>>> > >>--------------------------------------------------------------------- > >> > >>>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>>>> > >>>>> > >>>>>_________________________________________________________________ > >>>>>??????????????- MSN Hotmail? http://www.hotmail.com > >>>>> > >>>>> > >>>>>--------------------------------------------------------------------- > >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>>> > >>>> > >>>> > >>>>--------------------------------------------------------------------- > >>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>> > >>> > >>>_________________________________________________________________ > >>>??????????,??? MSN Messenger: http://messenger.msn.com/cn > >>> > >>>--------------------------------------------------------------------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >>>. > >>> > >> > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >>------------------------------------------------------------------------ > >> > >># -------------------------------------------------------- > >> > >>drop table if exists OBJECT; > >>drop table if exists CHILDREN; > >>drop table if exists BINDING; > >>drop table if exists PARENT_BINDING; > >>drop table if exists LINKS; > >>drop table if exists LOCKS; > >>drop table if exists VERSION_CONTENT; > >>drop table if exists PROPERTIES; > >>drop table if exists PERMISSIONS; > >>drop table if exists VERSION_PREDS; > >>drop table if exists VERSION_LABELS; > >>drop table if exists VERSION_HISTORY; > >>drop table if exists VERSION; > >>drop table if exists BRANCH; > >>drop table if exists LABEL; > >>drop table if exists URI; > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE URI ( > >> URI_ID bigint NOT NULL auto_increment, > >> URI_STRING varchar(255) NOT NULL CHARACTER SET uft8 COLLATE utf8_general_ci, > >> PRIMARY KEY (URI_ID), > >> KEY URI_IX2 (URI_STRING) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE OBJECT ( > >> URI_ID bigint NOT NULL, > >> CLASS_NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PRIMARY KEY (URI_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID) > >>REFERENCES URI (URI_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE BINDING ( > >> URI_ID bigint NOT NULL, > >> NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> CHILD_UURI_ID bigint NOT NULL, > >> PRIMARY KEY (URI_ID, NAME, CHILD_UURI_ID), > >> KEY BINDING_IX (CHILD_UURI_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK1 FOREIGN KEY > >>BINDING_FK1(URI_ID) REFERENCES URI (URI_ID); > >>ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK2 FOREIGN KEY > >>BINDING_FK2(CHILD_UURI_ID) REFERENCES URI (URI_ID); > >> > >>CREATE TABLE PARENT_BINDING ( > >> URI_ID bigint NOT NULL, > >> NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PARENT_UURI_ID bigint NOT NULL, > >> PRIMARY KEY (URI_ID, NAME, PARENT_UURI_ID), > >> KEY PARENT_BINDING_IX (PARENT_UURI_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK1 FOREIGN KEY > >>PARENT_BINDING_FK1(URI_ID) REFERENCES URI (URI_ID); > >>ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK2 FOREIGN KEY > >>PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES URI (URI_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE LINKS ( > >> URI_ID bigint NOT NULL, > >> LINK_TO_ID bigint NOT NULL, > >> PRIMARY KEY (URI_ID,LINK_TO_ID), > >> key LINK_IX2 (LINK_TO_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID) > >>REFERENCES URI (URI_ID); > >>ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID) > >>REFERENCES URI (URI_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE LOCKS ( > >> LOCK_ID bigint NOT NULL, > >> OBJECT_ID bigint NOT NULL, > >> SUBJECT_ID bigint NOT NULL, > >> TYPE_ID bigint NOT NULL, > >> EXPIRATION_DATE bigint NOT NULL, > >> IS_INHERITABLE tinyint(1) NOT NULL, > >> IS_EXCLUSIVE tinyint(1) NOT NULL, > >> OWNER varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PRIMARY KEY (LOCK_ID), > >> KEY LOCK_IX2 (OBJECT_ID), > >> KEY LOCK_IX3 (SUBJECT_ID), > >> KEY LOCK_IX4 (TYPE_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID) > >>REFERENCES URI (URI_ID); > >>ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID) > >>REFERENCES URI (URI_ID); > >>ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID) > >>REFERENCES URI (URI_ID); > >>ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID) > >>REFERENCES URI (URI_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE BRANCH ( > >> BRANCH_ID bigint NOT NULL auto_increment, > >> BRANCH_STRING varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PRIMARY KEY (BRANCH_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE LABEL ( > >> LABEL_ID bigint NOT NULL auto_increment, > >> LABEL_STRING varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PRIMARY KEY (LABEL_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE VERSION ( > >> URI_ID bigint NOT NULL, > >> IS_VERSIONED tinyint(1) NOT NULL, > >> PRIMARY KEY (URI_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY > >>VERSION_FK1(URI_ID) REFERENCES URI (URI_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE VERSION_HISTORY ( > >> VERSION_ID bigint NOT NULL auto_increment, > >> URI_ID bigint NOT NULL, > >> BRANCH_ID bigint NOT NULL, > >> REVISION_NO varchar(20) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PRIMARY KEY (VERSION_ID), > >> UNIQUE KEY URI_ID (BRANCH_ID,URI_ID,REVISION_NO), > >> KEY URI_ID_IX3 (URI_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY > >>VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID); > >>ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY > >>VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE VERSION_PREDS ( > >> VERSION_ID bigint NOT NULL, > >> PREDECESSOR_ID bigint NOT NULL, > >> PRIMARY KEY (VERSION_ID,PREDECESSOR_ID), > >> KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY > >>VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); > >>ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY > >>VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE VERSION_LABELS ( > >> VERSION_ID bigint NOT NULL, > >> LABEL_ID bigint NOT NULL, > >> PRIMARY KEY (VERSION_ID,LABEL_ID), > >> KEY LABEL_ID_IX2 (LABEL_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY > >>VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); > >>ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY > >>VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE VERSION_CONTENT ( > >> VERSION_ID bigint NOT NULL, > >> CONTENT blob NOT NULL, > >> PRIMARY KEY (VERSION_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY > >>VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE PROPERTIES ( > >> VERSION_ID bigint NOT NULL, > >> PROPERTY_NAMESPACE varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PROPERTY_NAME varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PROPERTY_VALUE varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> PROPERTY_TYPE varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, > >> IS_PROTECTED tinyint(1) NOT NULL, > >> PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY > >>PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); > >> > >># -------------------------------------------------------- > >> > >>CREATE TABLE PERMISSIONS ( > >> OBJECT_ID bigint NOT NULL, > >> SUBJECT_ID bigint NOT NULL, > >> ACTION_ID bigint NOT NULL, > >> VERSION_NO varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci, > >> IS_INHERITABLE tinyint(1) NOT NULL, > >> IS_NEGATIVE tinyint(1) NOT NULL, > >> SUCCESSION int NOT NULL, > >> PRIMARY KEY (SUBJECT_ID,OBJECT_ID,ACTION_ID), > >> UNIQUE KEY OBJECT_ID_2 (OBJECT_ID,SUCCESSION), > >> KEY ACTION_ID_IX3 (ACTION_ID) > >>) TYPE=InnoDB CHARACTER SET utf8; > >> > >>ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY > >>PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID); > >>ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY > >>PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID); > >>ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY > >>PERMISSIONS_FK3(ACTION_ID) REFERENCES URI (URI_ID); > >> > >> > >>------------------------------------------------------------------------ > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
