Sure - just note that it has not been tested! /jacob
----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 10:08 AM Subject: Re: Slide and multiple languange?? > OK, > > may I then take over the scheme into Slide, maybe called > MySqlScheme4_1.sql or so? > > Oliver > > Jacob Lund wrote: > > > 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] > > > > > > . > > > > > --------------------------------------------------------------------- > 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]
