Skip to content

Instantly share code, notes, and snippets.

@arockwell
Created August 17, 2010 18:41
Show Gist options
  • Select an option

  • Save arockwell/531374 to your computer and use it in GitHub Desktop.

Select an option

Save arockwell/531374 to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS `jena_g10t1_stmt`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jena_g10t1_stmt` (
`Subj` varchar(100) character set utf8 collate utf8_bin NOT NULL,
`Prop` varchar(100) character set utf8 collate utf8_bin NOT NULL,
`Obj` varchar(100) character set utf8 collate utf8_bin NOT NULL,
`GraphID` int(11) default NULL,
KEY `jena_g10t1_stmtXSP` (`Subj`,`Prop`),
KEY `jena_g10t1_stmtXO` (`Obj`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment