Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 889745 Details for
Bug 1075889
[abrt] nautilus: wherePathSatisfiesOrderBy(): nautilus killed by SIGSEGV
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
Schema of the tracker DB
tracker-schema.sql (text/plain), 93.22 KB, created by
Honza Horak
on 2014-04-25 12:56:18 UTC
(
hide
)
Description:
Schema of the tracker DB
Filename:
MIME Type:
Creator:
Honza Horak
Created:
2014-04-25 12:56:18 UTC
Size:
93.22 KB
patch
obsolete
>CREATE TABLE Resource (ID INTEGER NOT NULL PRIMARY KEY, Uri TEXT NOT NULL, UNIQUE (Uri)); >CREATE TABLE "rdfs:Resource_rdf:type" (ID INTEGER NOT NULL, "rdf:type" INTEGER NOT NULL, "rdf:type:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_rdf:type_ID_ID" ON "rdfs:Resource_rdf:type" (ID, "rdf:type"); >CREATE TABLE "rdfs:Resource_dc:contributor" (ID INTEGER NOT NULL, "dc:contributor" TEXT NOT NULL, "dc:contributor:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_dc:contributor_ID_ID" ON "rdfs:Resource_dc:contributor" (ID, "dc:contributor"); >CREATE TABLE "rdfs:Resource_dc:date" (ID INTEGER NOT NULL, "dc:date" INTEGER NOT NULL, "dc:date:graph" INTEGER, "dc:date:localDate" INTEGER NOT NULL, "dc:date:localTime" INTEGER NOT NULL); >CREATE UNIQUE INDEX "rdfs:Resource_dc:date_ID_ID" ON "rdfs:Resource_dc:date" (ID, "dc:date"); >CREATE TABLE "rdfs:Resource_dc:source" (ID INTEGER NOT NULL, "dc:source" INTEGER NOT NULL, "dc:source:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_dc:source_ID_ID" ON "rdfs:Resource_dc:source" (ID, "dc:source"); >CREATE TABLE "rdfs:Resource_dc:relation" (ID INTEGER NOT NULL, "dc:relation" TEXT NOT NULL, "dc:relation:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_dc:relation_ID_ID" ON "rdfs:Resource_dc:relation" (ID, "dc:relation"); >CREATE TABLE "rdfs:Resource_nao:hasTag" (ID INTEGER NOT NULL, "nao:hasTag" INTEGER NOT NULL, "nao:hasTag:graph" INTEGER); >CREATE INDEX "rdfs:Resource_nao:hasTag_ID" ON "rdfs:Resource_nao:hasTag" (ID); >CREATE UNIQUE INDEX "rdfs:Resource_nao:hasTag_ID_ID" ON "rdfs:Resource_nao:hasTag" ("nao:hasTag", ID); >CREATE TABLE "rdfs:Resource_nao:deprecated" (ID INTEGER NOT NULL, "nao:deprecated" INTEGER NOT NULL, "nao:deprecated:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_nao:deprecated_ID_ID" ON "rdfs:Resource_nao:deprecated" (ID, "nao:deprecated"); >CREATE TABLE "rdfs:Resource_nao:isRelated" (ID INTEGER NOT NULL, "nao:isRelated" INTEGER NOT NULL, "nao:isRelated:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Resource_nao:isRelated_ID_ID" ON "rdfs:Resource_nao:isRelated" (ID, "nao:isRelated"); >CREATE TABLE "rdfs:Resource" (ID INTEGER NOT NULL PRIMARY KEY, Available INTEGER NOT NULL, "rdfs:comment" TEXT COLLATE TRACKER, "rdfs:comment:graph" INTEGER, "rdfs:label" TEXT COLLATE TRACKER, "rdfs:label:graph" INTEGER, "tracker:added" INTEGER, "tracker:added:graph" INTEGER, "tracker:added:localDate" INTEGER, "tracker:added:localTime" INTEGER, "tracker:modified" INTEGER, "tracker:modified:graph" INTEGER, "tracker:damaged" INTEGER, "tracker:damaged:graph" INTEGER, "dc:title" TEXT COLLATE TRACKER, "dc:title:graph" INTEGER, "dc:creator" TEXT COLLATE TRACKER, "dc:creator:graph" INTEGER, "dc:subject" TEXT COLLATE TRACKER, "dc:subject:graph" INTEGER, "dc:description" TEXT COLLATE TRACKER, "dc:description:graph" INTEGER, "dc:publisher" TEXT COLLATE TRACKER, "dc:publisher:graph" INTEGER, "dc:type" TEXT COLLATE TRACKER, "dc:type:graph" INTEGER, "dc:format" TEXT COLLATE TRACKER, "dc:format:graph" INTEGER, "dc:identifier" TEXT COLLATE TRACKER, "dc:identifier:graph" INTEGER, "dc:language" TEXT COLLATE TRACKER, "dc:language:graph" INTEGER, "dc:coverage" TEXT COLLATE TRACKER, "dc:coverage:graph" INTEGER, "dc:rights" TEXT COLLATE TRACKER, "dc:rights:graph" INTEGER, "nao:identifier" TEXT COLLATE TRACKER, "nao:identifier:graph" INTEGER, "nao:numericRating" REAL, "nao:numericRating:graph" INTEGER, "nao:lastModified" INTEGER, "nao:lastModified:graph" INTEGER, "nao:lastModified:localDate" INTEGER, "nao:lastModified:localTime" INTEGER); >CREATE INDEX "rdfs:Resource_tracker:added" ON "rdfs:Resource" ("tracker:added"); >CREATE TABLE "rdfs:Class_rdfs:subClassOf" (ID INTEGER NOT NULL, "rdfs:subClassOf" INTEGER NOT NULL, "rdfs:subClassOf:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Class_rdfs:subClassOf_ID_ID" ON "rdfs:Class_rdfs:subClassOf" (ID, "rdfs:subClassOf"); >CREATE TABLE "rdfs:Class_tracker:domainIndex" (ID INTEGER NOT NULL, "tracker:domainIndex" INTEGER NOT NULL, "tracker:domainIndex:graph" INTEGER); >CREATE UNIQUE INDEX "rdfs:Class_tracker:domainIndex_ID_ID" ON "rdfs:Class_tracker:domainIndex" (ID, "tracker:domainIndex"); >CREATE TABLE "rdfs:Class" (ID INTEGER NOT NULL PRIMARY KEY, "tracker:notify" INTEGER, "tracker:notify:graph" INTEGER); >CREATE TABLE "rdf:Property_rdfs:subPropertyOf" (ID INTEGER NOT NULL, "rdfs:subPropertyOf" INTEGER NOT NULL, "rdfs:subPropertyOf:graph" INTEGER); >CREATE UNIQUE INDEX "rdf:Property_rdfs:subPropertyOf_ID_ID" ON "rdf:Property_rdfs:subPropertyOf" (ID, "rdfs:subPropertyOf"); >CREATE TABLE "rdf:Property" (ID INTEGER NOT NULL PRIMARY KEY, "rdfs:domain" INTEGER, "rdfs:domain:graph" INTEGER, "rdfs:range" INTEGER, "rdfs:range:graph" INTEGER, "tracker:indexed" INTEGER, "tracker:indexed:graph" INTEGER, "tracker:secondaryIndex" INTEGER, "tracker:secondaryIndex:graph" INTEGER, "tracker:fulltextIndexed" INTEGER, "tracker:fulltextIndexed:graph" INTEGER, "tracker:fulltextNoLimit" INTEGER, "tracker:fulltextNoLimit:graph" INTEGER, "tracker:transient" INTEGER, "tracker:transient:graph" INTEGER, "tracker:weight" INTEGER, "tracker:weight:graph" INTEGER, "tracker:defaultValue" TEXT COLLATE TRACKER, "tracker:defaultValue:graph" INTEGER, "nrl:maxCardinality" INTEGER, "nrl:maxCardinality:graph" INTEGER, "tracker:writeback" INTEGER, "tracker:writeback:graph" INTEGER, "tracker:forceJournal" INTEGER, "tracker:forceJournal:graph" INTEGER); >CREATE TABLE "rdfs:Literal" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "tracker:Namespace" (ID INTEGER NOT NULL PRIMARY KEY, "tracker:prefix" TEXT COLLATE TRACKER, "tracker:prefix:graph" INTEGER); >CREATE TABLE "tracker:Ontology" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nrl:InverseFunctionalProperty" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nie:DataObject_nie:dataSource" (ID INTEGER NOT NULL, "nie:dataSource" INTEGER NOT NULL, "nie:dataSource:graph" INTEGER); >CREATE UNIQUE INDEX "nie:DataObject_nie:dataSource_ID_ID" ON "nie:DataObject_nie:dataSource" (ID, "nie:dataSource"); >CREATE TABLE "nie:DataObject_nie:isPartOf" (ID INTEGER NOT NULL, "nie:isPartOf" INTEGER NOT NULL, "nie:isPartOf:graph" INTEGER); >CREATE UNIQUE INDEX "nie:DataObject_nie:isPartOf_ID_ID" ON "nie:DataObject_nie:isPartOf" (ID, "nie:isPartOf"); >CREATE TABLE "nie:DataObject" (ID INTEGER NOT NULL PRIMARY KEY, "nie:url" TEXT COLLATE TRACKER UNIQUE, "nie:url:graph" INTEGER, "nie:byteSize" INTEGER, "nie:byteSize:graph" INTEGER, "nie:interpretedAs" INTEGER, "nie:interpretedAs:graph" INTEGER, "nie:lastRefreshed" INTEGER, "nie:lastRefreshed:graph" INTEGER, "nie:lastRefreshed:localDate" INTEGER, "nie:lastRefreshed:localTime" INTEGER, "nie:created" INTEGER, "nie:created:graph" INTEGER, "nie:created:localDate" INTEGER, "nie:created:localTime" INTEGER, "nfo:belongsToContainer" INTEGER, "nfo:belongsToContainer:graph" INTEGER, "tracker:available" INTEGER, "tracker:available:graph" INTEGER); >CREATE INDEX "nie:DataObject_nie:url" ON "nie:DataObject" ("nie:url"); >CREATE TABLE "nie:DataSource" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nie:InformationElement_nie:informationElementDate" (ID INTEGER NOT NULL, "nie:informationElementDate" INTEGER NOT NULL, "nie:informationElementDate:graph" INTEGER, "nie:informationElementDate:localDate" INTEGER NOT NULL, "nie:informationElementDate:localTime" INTEGER NOT NULL); >CREATE UNIQUE INDEX "nie:InformationElement_nie:informationElementDate_ID_ID" ON "nie:InformationElement_nie:informationElementDate" (ID, "nie:informationElementDate"); >CREATE TABLE "nie:InformationElement_nie:relatedTo" (ID INTEGER NOT NULL, "nie:relatedTo" INTEGER NOT NULL, "nie:relatedTo:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nie:relatedTo_ID_ID" ON "nie:InformationElement_nie:relatedTo" (ID, "nie:relatedTo"); >CREATE TABLE "nie:InformationElement_nie:keyword" (ID INTEGER NOT NULL, "nie:keyword" TEXT NOT NULL, "nie:keyword:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nie:keyword_ID_ID" ON "nie:InformationElement_nie:keyword" (ID, "nie:keyword"); >CREATE TABLE "nie:InformationElement_nie:hasLogicalPart" (ID INTEGER NOT NULL, "nie:hasLogicalPart" INTEGER NOT NULL, "nie:hasLogicalPart:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nie:hasLogicalPart_ID_ID" ON "nie:InformationElement_nie:hasLogicalPart" (ID, "nie:hasLogicalPart"); >CREATE TABLE "nie:InformationElement_nie:hasPart" (ID INTEGER NOT NULL, "nie:hasPart" INTEGER NOT NULL, "nie:hasPart:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nie:hasPart_ID_ID" ON "nie:InformationElement_nie:hasPart" (ID, "nie:hasPart"); >CREATE TABLE "nie:InformationElement_nie:isLogicalPartOf" (ID INTEGER NOT NULL, "nie:isLogicalPartOf" INTEGER NOT NULL, "nie:isLogicalPartOf:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nie:isLogicalPartOf_ID_ID" ON "nie:InformationElement_nie:isLogicalPartOf" (ID, "nie:isLogicalPartOf"); >CREATE TABLE "nie:InformationElement_nao:hasProperty" (ID INTEGER NOT NULL, "nao:hasProperty" INTEGER NOT NULL, "nao:hasProperty:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nao:hasProperty_ID_ID" ON "nie:InformationElement_nao:hasProperty" (ID, "nao:hasProperty"); >CREATE TABLE "nie:InformationElement_nco:contributor" (ID INTEGER NOT NULL, "nco:contributor" INTEGER NOT NULL, "nco:contributor:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nco:contributor_ID_ID" ON "nie:InformationElement_nco:contributor" (ID, "nco:contributor"); >CREATE TABLE "nie:InformationElement_nco:creator" (ID INTEGER NOT NULL, "nco:creator" INTEGER NOT NULL, "nco:creator:graph" INTEGER); >CREATE UNIQUE INDEX "nie:InformationElement_nco:creator_ID_ID" ON "nie:InformationElement_nco:creator" (ID, "nco:creator"); >CREATE TABLE "nie:InformationElement_mlo:location" (ID INTEGER NOT NULL, "mlo:location" INTEGER NOT NULL, "mlo:location:graph" INTEGER); >CREATE INDEX "nie:InformationElement_mlo:location_ID" ON "nie:InformationElement_mlo:location" (ID); >CREATE UNIQUE INDEX "nie:InformationElement_mlo:location_ID_ID" ON "nie:InformationElement_mlo:location" ("mlo:location", ID); >CREATE TABLE "nie:InformationElement" (ID INTEGER NOT NULL PRIMARY KEY, "nie:title" TEXT COLLATE TRACKER, "nie:title:graph" INTEGER, "nie:contentLastModified" INTEGER, "nie:contentLastModified:graph" INTEGER, "nie:contentLastModified:localDate" INTEGER, "nie:contentLastModified:localTime" INTEGER, "nie:subject" TEXT COLLATE TRACKER, "nie:subject:graph" INTEGER, "nie:mimeType" TEXT COLLATE TRACKER, "nie:mimeType:graph" INTEGER, "nie:language" TEXT COLLATE TRACKER, "nie:language:graph" INTEGER, "nie:plainTextContent" TEXT COLLATE TRACKER, "nie:plainTextContent:graph" INTEGER, "nie:legal" TEXT COLLATE TRACKER, "nie:legal:graph" INTEGER, "nie:generator" TEXT COLLATE TRACKER, "nie:generator:graph" INTEGER, "nie:description" TEXT COLLATE TRACKER, "nie:description:graph" INTEGER, "nie:disclaimer" TEXT COLLATE TRACKER, "nie:disclaimer:graph" INTEGER, "nie:depends" INTEGER, "nie:depends:graph" INTEGER, "nie:links" INTEGER, "nie:links:graph" INTEGER, "nie:copyright" TEXT COLLATE TRACKER, "nie:copyright:graph" INTEGER, "nie:comment" TEXT COLLATE TRACKER, "nie:comment:graph" INTEGER, "nie:isStoredAs" INTEGER, "nie:isStoredAs:graph" INTEGER, "nie:version" TEXT COLLATE TRACKER, "nie:version:graph" INTEGER, "nie:contentCreated" INTEGER, "nie:contentCreated:graph" INTEGER, "nie:contentCreated:localDate" INTEGER, "nie:contentCreated:localTime" INTEGER, "nie:contentAccessed" INTEGER, "nie:contentAccessed:graph" INTEGER, "nie:contentAccessed:localDate" INTEGER, "nie:contentAccessed:localTime" INTEGER, "nie:license" TEXT COLLATE TRACKER, "nie:license:graph" INTEGER, "nie:identifier" TEXT COLLATE TRACKER, "nie:identifier:graph" INTEGER, "nie:licenseType" TEXT COLLATE TRACKER, "nie:licenseType:graph" INTEGER, "nie:characterSet" TEXT COLLATE TRACKER, "nie:characterSet:graph" INTEGER, "nie:contentSize" INTEGER, "nie:contentSize:graph" INTEGER, "nie:rootElementOf" INTEGER, "nie:rootElementOf:graph" INTEGER, "nie:usageCounter" INTEGER, "nie:usageCounter:graph" INTEGER, "nco:publisher" INTEGER, "nco:publisher:graph" INTEGER, "nfo:isContentEncrypted" INTEGER, "nfo:isContentEncrypted:graph" INTEGER, "nfo:isBootable" INTEGER, "nfo:isBootable:graph" INTEGER, "slo:location" INTEGER, "slo:location:graph" INTEGER, "osinfo:id" TEXT COLLATE TRACKER, "osinfo:id:graph" INTEGER, "osinfo:mediaId" TEXT COLLATE TRACKER, "osinfo:mediaId:graph" INTEGER); >CREATE INDEX "nie:InformationElement_slo:location" ON "nie:InformationElement" ("slo:location"); >CREATE TABLE "nao:Tag_tracker:isDefaultTag" (ID INTEGER NOT NULL, "tracker:isDefaultTag" INTEGER NOT NULL, "tracker:isDefaultTag:graph" INTEGER); >CREATE UNIQUE INDEX "nao:Tag_tracker:isDefaultTag_ID_ID" ON "nao:Tag_tracker:isDefaultTag" (ID, "tracker:isDefaultTag"); >CREATE TABLE "nao:Tag_tracker:tagRelatedTo" (ID INTEGER NOT NULL, "tracker:tagRelatedTo" INTEGER NOT NULL, "tracker:tagRelatedTo:graph" INTEGER); >CREATE UNIQUE INDEX "nao:Tag_tracker:tagRelatedTo_ID_ID" ON "nao:Tag_tracker:tagRelatedTo" (ID, "tracker:tagRelatedTo"); >CREATE TABLE "nao:Tag" (ID INTEGER NOT NULL PRIMARY KEY, "nao:prefLabel" TEXT COLLATE TRACKER, "nao:prefLabel:graph" INTEGER, "nao:description" TEXT COLLATE TRACKER, "nao:description:graph" INTEGER); >CREATE TABLE "nao:Property" (ID INTEGER NOT NULL PRIMARY KEY, "nao:propertyName" TEXT COLLATE TRACKER, "nao:propertyName:graph" INTEGER, "nao:propertyValue" TEXT COLLATE TRACKER, "nao:propertyValue:graph" INTEGER); >CREATE TABLE "nco:Role_nco:hasContactMedium" (ID INTEGER NOT NULL, "nco:hasContactMedium" INTEGER NOT NULL, "nco:hasContactMedium:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:hasContactMedium_ID_ID" ON "nco:Role_nco:hasContactMedium" (ID, "nco:hasContactMedium"); >CREATE TABLE "nco:Role_nco:url" (ID INTEGER NOT NULL, "nco:url" INTEGER NOT NULL, "nco:url:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:url_ID_ID" ON "nco:Role_nco:url" (ID, "nco:url"); >CREATE TABLE "nco:Role_nco:hasPhoneNumber" (ID INTEGER NOT NULL, "nco:hasPhoneNumber" INTEGER NOT NULL, "nco:hasPhoneNumber:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:hasPhoneNumber_ID_ID" ON "nco:Role_nco:hasPhoneNumber" (ID, "nco:hasPhoneNumber"); >CREATE TABLE "nco:Role_nco:websiteUrl" (ID INTEGER NOT NULL, "nco:websiteUrl" INTEGER NOT NULL, "nco:websiteUrl:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:websiteUrl_ID_ID" ON "nco:Role_nco:websiteUrl" (ID, "nco:websiteUrl"); >CREATE TABLE "nco:Role_nco:hasEmailAddress" (ID INTEGER NOT NULL, "nco:hasEmailAddress" INTEGER NOT NULL, "nco:hasEmailAddress:graph" INTEGER); >CREATE INDEX "nco:Role_nco:hasEmailAddress_ID" ON "nco:Role_nco:hasEmailAddress" (ID); >CREATE UNIQUE INDEX "nco:Role_nco:hasEmailAddress_ID_ID" ON "nco:Role_nco:hasEmailAddress" ("nco:hasEmailAddress", ID); >CREATE TABLE "nco:Role_nco:foafUrl" (ID INTEGER NOT NULL, "nco:foafUrl" INTEGER NOT NULL, "nco:foafUrl:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:foafUrl_ID_ID" ON "nco:Role_nco:foafUrl" (ID, "nco:foafUrl"); >CREATE TABLE "nco:Role_nco:blogUrl" (ID INTEGER NOT NULL, "nco:blogUrl" INTEGER NOT NULL, "nco:blogUrl:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:blogUrl_ID_ID" ON "nco:Role_nco:blogUrl" (ID, "nco:blogUrl"); >CREATE TABLE "nco:Role_nco:hasPostalAddress" (ID INTEGER NOT NULL, "nco:hasPostalAddress" INTEGER NOT NULL, "nco:hasPostalAddress:graph" INTEGER); >CREATE INDEX "nco:Role_nco:hasPostalAddress_ID" ON "nco:Role_nco:hasPostalAddress" (ID); >CREATE UNIQUE INDEX "nco:Role_nco:hasPostalAddress_ID_ID" ON "nco:Role_nco:hasPostalAddress" ("nco:hasPostalAddress", ID); >CREATE TABLE "nco:Role_nco:hasIMAddress" (ID INTEGER NOT NULL, "nco:hasIMAddress" INTEGER NOT NULL, "nco:hasIMAddress:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Role_nco:hasIMAddress_ID_ID" ON "nco:Role_nco:hasIMAddress" (ID, "nco:hasIMAddress"); >CREATE TABLE "nco:Role" (ID INTEGER NOT NULL PRIMARY KEY, "nco:video" INTEGER, "nco:video:graph" INTEGER); >CREATE TABLE "nco:Affiliation_nco:title" (ID INTEGER NOT NULL, "nco:title" TEXT NOT NULL, "nco:title:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Affiliation_nco:title_ID_ID" ON "nco:Affiliation_nco:title" (ID, "nco:title"); >CREATE TABLE "nco:Affiliation" (ID INTEGER NOT NULL PRIMARY KEY, "nco:department" TEXT COLLATE TRACKER, "nco:department:graph" INTEGER, "nco:org" INTEGER, "nco:org:graph" INTEGER, "nco:role" TEXT COLLATE TRACKER, "nco:role:graph" INTEGER); >CREATE TABLE "nco:Contact_nco:note" (ID INTEGER NOT NULL, "nco:note" TEXT NOT NULL, "nco:note:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_nco:note_ID_ID" ON "nco:Contact_nco:note" (ID, "nco:note"); >CREATE TABLE "nco:Contact_nco:belongsToGroup" (ID INTEGER NOT NULL, "nco:belongsToGroup" INTEGER NOT NULL, "nco:belongsToGroup:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_nco:belongsToGroup_ID_ID" ON "nco:Contact_nco:belongsToGroup" (ID, "nco:belongsToGroup"); >CREATE TABLE "nco:Contact_ncal:birthday" (ID INTEGER NOT NULL, "ncal:birthday" INTEGER NOT NULL, "ncal:birthday:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_ncal:birthday_ID_ID" ON "nco:Contact_ncal:birthday" (ID, "ncal:birthday"); >CREATE TABLE "nco:Contact_ncal:anniversary" (ID INTEGER NOT NULL, "ncal:anniversary" INTEGER NOT NULL, "ncal:anniversary:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_ncal:anniversary_ID_ID" ON "nco:Contact_ncal:anniversary" (ID, "ncal:anniversary"); >CREATE TABLE "nco:Contact_scal:birthday" (ID INTEGER NOT NULL, "scal:birthday" INTEGER NOT NULL, "scal:birthday:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_scal:birthday_ID_ID" ON "nco:Contact_scal:birthday" (ID, "scal:birthday"); >CREATE TABLE "nco:Contact_scal:anniversary" (ID INTEGER NOT NULL, "scal:anniversary" INTEGER NOT NULL, "scal:anniversary:graph" INTEGER); >CREATE UNIQUE INDEX "nco:Contact_scal:anniversary_ID_ID" ON "nco:Contact_scal:anniversary" (ID, "scal:anniversary"); >CREATE TABLE "nco:Contact" (ID INTEGER NOT NULL PRIMARY KEY, "nco:fullname" TEXT COLLATE TRACKER, "nco:fullname:graph" INTEGER, "nco:key" INTEGER, "nco:key:graph" INTEGER, "nco:contactUID" TEXT COLLATE TRACKER, "nco:contactUID:graph" INTEGER, "nco:contactLocalUID" TEXT COLLATE TRACKER, "nco:contactLocalUID:graph" INTEGER, "nco:hasLocation" INTEGER, "nco:hasLocation:graph" INTEGER, "nco:nickname" TEXT COLLATE TRACKER, "nco:nickname:graph" INTEGER, "nco:representative" INTEGER, "nco:representative:graph" INTEGER, "nco:photo" INTEGER, "nco:photo:graph" INTEGER, "nco:birthDate" INTEGER, "nco:birthDate:graph" INTEGER, "nco:birthDate:localDate" INTEGER, "nco:birthDate:localTime" INTEGER, "nco:sound" INTEGER, "nco:sound:graph" INTEGER); >CREATE TABLE "nco:ContactGroup" (ID INTEGER NOT NULL PRIMARY KEY, "nco:contactGroupName" TEXT COLLATE TRACKER, "nco:contactGroupName:graph" INTEGER); >CREATE TABLE "nco:ContactList_nco:containsContact" (ID INTEGER NOT NULL, "nco:containsContact" INTEGER NOT NULL, "nco:containsContact:graph" INTEGER); >CREATE UNIQUE INDEX "nco:ContactList_nco:containsContact_ID_ID" ON "nco:ContactList_nco:containsContact" (ID, "nco:containsContact"); >CREATE TABLE "nco:ContactList" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:ContactMedium" (ID INTEGER NOT NULL PRIMARY KEY, "nco:contactMediumComment" TEXT COLLATE TRACKER, "nco:contactMediumComment:graph" INTEGER); >CREATE TABLE "nco:EmailAddress" (ID INTEGER NOT NULL PRIMARY KEY, "nco:emailAddress" TEXT COLLATE TRACKER UNIQUE, "nco:emailAddress:graph" INTEGER); >CREATE TABLE "nco:IMAddress_nco:imCapability" (ID INTEGER NOT NULL, "nco:imCapability" INTEGER NOT NULL, "nco:imCapability:graph" INTEGER); >CREATE UNIQUE INDEX "nco:IMAddress_nco:imCapability_ID_ID" ON "nco:IMAddress_nco:imCapability" (ID, "nco:imCapability"); >CREATE TABLE "nco:IMAddress" (ID INTEGER NOT NULL PRIMARY KEY, "nco:imID" TEXT COLLATE TRACKER, "nco:imID:graph" INTEGER, "nco:imNickname" TEXT COLLATE TRACKER, "nco:imNickname:graph" INTEGER, "nco:imAvatar" INTEGER, "nco:imAvatar:graph" INTEGER, "nco:imProtocol" TEXT COLLATE TRACKER, "nco:imProtocol:graph" INTEGER, "nco:imStatusMessage" TEXT COLLATE TRACKER, "nco:imStatusMessage:graph" INTEGER, "nco:imPresence" INTEGER, "nco:imPresence:graph" INTEGER, "nco:presenceLastModified" INTEGER, "nco:presenceLastModified:graph" INTEGER, "nco:presenceLastModified:localDate" INTEGER, "nco:presenceLastModified:localTime" INTEGER, "nco:imAddressAuthStatusFrom" INTEGER, "nco:imAddressAuthStatusFrom:graph" INTEGER, "nco:imAddressAuthStatusTo" INTEGER, "nco:imAddressAuthStatusTo:graph" INTEGER); >CREATE TABLE "nco:IMAccount_nco:hasIMContact" (ID INTEGER NOT NULL, "nco:hasIMContact" INTEGER NOT NULL, "nco:hasIMContact:graph" INTEGER); >CREATE UNIQUE INDEX "nco:IMAccount_nco:hasIMContact_ID_ID" ON "nco:IMAccount_nco:hasIMContact" (ID, "nco:hasIMContact"); >CREATE TABLE "nco:IMAccount" (ID INTEGER NOT NULL PRIMARY KEY, "nco:imAccountAddress" INTEGER UNIQUE, "nco:imAccountAddress:graph" INTEGER, "nco:imAccountType" TEXT COLLATE TRACKER, "nco:imAccountType:graph" INTEGER, "nco:imDisplayName" TEXT COLLATE TRACKER, "nco:imDisplayName:graph" INTEGER, "nco:imEnabled" INTEGER, "nco:imEnabled:graph" INTEGER); >CREATE TABLE "nco:OrganizationContact" (ID INTEGER NOT NULL PRIMARY KEY, "nco:logo" INTEGER, "nco:logo:graph" INTEGER); >CREATE TABLE "nco:PersonContact_nco:hasAffiliation" (ID INTEGER NOT NULL, "nco:hasAffiliation" INTEGER NOT NULL, "nco:hasAffiliation:graph" INTEGER); >CREATE UNIQUE INDEX "nco:PersonContact_nco:hasAffiliation_ID_ID" ON "nco:PersonContact_nco:hasAffiliation" (ID, "nco:hasAffiliation"); >CREATE TABLE "nco:PersonContact" (ID INTEGER NOT NULL PRIMARY KEY, "nco:nameFamily" TEXT COLLATE TRACKER, "nco:nameFamily:graph" INTEGER, "nco:nameGiven" TEXT COLLATE TRACKER, "nco:nameGiven:graph" INTEGER, "nco:nameAdditional" TEXT COLLATE TRACKER, "nco:nameAdditional:graph" INTEGER, "nco:nameHonorificSuffix" TEXT COLLATE TRACKER, "nco:nameHonorificSuffix:graph" INTEGER, "nco:nameHonorificPrefix" TEXT COLLATE TRACKER, "nco:nameHonorificPrefix:graph" INTEGER, "nco:hobby" TEXT COLLATE TRACKER, "nco:hobby:graph" INTEGER, "nco:gender" INTEGER, "nco:gender:graph" INTEGER); >CREATE INDEX "nco:PersonContact_nco:nameFamily" ON "nco:PersonContact" ("nco:nameFamily"); >CREATE TABLE "nco:PhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, "nco:phoneNumber" TEXT COLLATE TRACKER, "nco:phoneNumber:graph" INTEGER); >CREATE INDEX "nco:PhoneNumber_nco:phoneNumber" ON "nco:PhoneNumber" ("nco:phoneNumber"); >CREATE TABLE "nco:PostalAddress" (ID INTEGER NOT NULL PRIMARY KEY, "nco:region" TEXT COLLATE TRACKER, "nco:region:graph" INTEGER, "nco:country" TEXT COLLATE TRACKER, "nco:country:graph" INTEGER, "nco:extendedAddress" TEXT COLLATE TRACKER, "nco:extendedAddress:graph" INTEGER, "nco:addressLocation" INTEGER, "nco:addressLocation:graph" INTEGER, "nco:streetAddress" TEXT COLLATE TRACKER, "nco:streetAddress:graph" INTEGER, "nco:postalcode" TEXT COLLATE TRACKER, "nco:postalcode:graph" INTEGER, "nco:locality" TEXT COLLATE TRACKER, "nco:locality:graph" INTEGER, "nco:county" TEXT COLLATE TRACKER, "nco:county:graph" INTEGER, "nco:district" TEXT COLLATE TRACKER, "nco:district:graph" INTEGER, "nco:pobox" TEXT COLLATE TRACKER, "nco:pobox:graph" INTEGER); >CREATE TABLE "nco:ModemNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:MessagingNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:PagerNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:Gender" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:VoicePhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, "nco:voiceMail" INTEGER, "nco:voiceMail:graph" INTEGER); >CREATE TABLE "nco:VideoTelephoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:IsdnNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:ParcelDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:FaxNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:CarPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:ContactListDataObject" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:PcsNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:InternationalDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:BbsNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:CellPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:DomesticDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:PresenceStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:IMCapability" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nco:AuthorizationStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Document" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:tableOfContents" TEXT COLLATE TRACKER, "nfo:tableOfContents:graph" INTEGER); >CREATE TABLE "nfo:FileDataObject" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:fileLastAccessed" INTEGER, "nfo:fileLastAccessed:graph" INTEGER, "nfo:fileLastAccessed:localDate" INTEGER, "nfo:fileLastAccessed:localTime" INTEGER, "nfo:fileCreated" INTEGER, "nfo:fileCreated:graph" INTEGER, "nfo:fileCreated:localDate" INTEGER, "nfo:fileCreated:localTime" INTEGER, "nfo:fileSize" INTEGER, "nfo:fileSize:graph" INTEGER, "nfo:permissions" TEXT COLLATE TRACKER, "nfo:permissions:graph" INTEGER, "nfo:fileName" TEXT COLLATE TRACKER, "nfo:fileName:graph" INTEGER, "nfo:hasHash" INTEGER, "nfo:hasHash:graph" INTEGER, "nfo:fileOwner" INTEGER, "nfo:fileOwner:graph" INTEGER, "nfo:fileLastModified" INTEGER, "nfo:fileLastModified:graph" INTEGER, "nfo:fileLastModified:localDate" INTEGER, "nfo:fileLastModified:localTime" INTEGER); >CREATE INDEX "nfo:FileDataObject_nfo:fileLastModified" ON "nfo:FileDataObject" ("nfo:fileLastModified"); >CREATE TABLE "nfo:Software" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:conflicts" INTEGER, "nfo:conflicts:graph" INTEGER, "nfo:supercedes" INTEGER, "nfo:supercedes:graph" INTEGER, "nfo:softwareIcon" INTEGER, "nfo:softwareIcon:graph" INTEGER, "nfo:softwareCmdLine" TEXT COLLATE TRACKER, "nfo:softwareCmdLine:graph" INTEGER); >CREATE TABLE "nfo:Media_nmm:alternativeMedia" (ID INTEGER NOT NULL, "nmm:alternativeMedia" INTEGER NOT NULL, "nmm:alternativeMedia:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:Media_nmm:alternativeMedia_ID_ID" ON "nfo:Media_nmm:alternativeMedia" (ID, "nmm:alternativeMedia"); >CREATE TABLE "nfo:Media_mtp:hidden" (ID INTEGER NOT NULL, "mtp:hidden" INTEGER NOT NULL, "mtp:hidden:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:Media_mtp:hidden_ID_ID" ON "nfo:Media_mtp:hidden" (ID, "mtp:hidden"); >CREATE TABLE "nfo:Media" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:count" INTEGER, "nfo:count:graph" INTEGER, "nfo:duration" INTEGER, "nfo:duration:graph" INTEGER, "nfo:compressionType" INTEGER, "nfo:compressionType:graph" INTEGER, "nfo:hasMediaStream" INTEGER, "nfo:hasMediaStream:graph" INTEGER, "nfo:bitDepth" INTEGER, "nfo:bitDepth:graph" INTEGER, "nfo:codec" TEXT COLLATE TRACKER, "nfo:codec:graph" INTEGER, "nfo:encodedBy" TEXT COLLATE TRACKER, "nfo:encodedBy:graph" INTEGER, "nfo:bitrateType" TEXT COLLATE TRACKER, "nfo:bitrateType:graph" INTEGER, "nfo:averageBitrate" REAL, "nfo:averageBitrate:graph" INTEGER, "nfo:genre" TEXT COLLATE TRACKER, "nfo:genre:graph" INTEGER, "nfo:equipment" INTEGER, "nfo:equipment:graph" INTEGER, "nfo:lastPlayedPosition" INTEGER, "nfo:lastPlayedPosition:graph" INTEGER, "nmm:genre" TEXT COLLATE TRACKER, "nmm:genre:graph" INTEGER, "nmm:skipCounter" INTEGER, "nmm:skipCounter:graph" INTEGER, "nmm:dlnaProfile" TEXT COLLATE TRACKER, "nmm:dlnaProfile:graph" INTEGER, "nmm:dlnaMime" TEXT COLLATE TRACKER, "nmm:dlnaMime:graph" INTEGER, "nmm:uPnPShared" INTEGER, "nmm:uPnPShared:graph" INTEGER, "mtp:credits" TEXT COLLATE TRACKER, "mtp:credits:graph" INTEGER, "mtp:creator" TEXT COLLATE TRACKER, "mtp:creator:graph" INTEGER); >CREATE TABLE "nfo:Visual" (ID INTEGER NOT NULL PRIMARY KEY, "nie:contentCreated" INTEGER, "nie:contentCreated:graph" INTEGER, "nie:contentCreated:localDate" INTEGER, "nie:contentCreated:localTime" INTEGER, "nfo:aspectRatio" REAL, "nfo:aspectRatio:graph" INTEGER, "nfo:heading" REAL, "nfo:heading:graph" INTEGER, "nfo:tilt" REAL, "nfo:tilt:graph" INTEGER, "nfo:interlaceMode" INTEGER, "nfo:interlaceMode:graph" INTEGER, "nfo:height" INTEGER, "nfo:height:graph" INTEGER, "nfo:width" INTEGER, "nfo:width:graph" INTEGER, "nfo:colorDepth" INTEGER, "nfo:colorDepth:graph" INTEGER); >CREATE INDEX "nfo:Visual_nie:contentCreated" ON "nfo:Visual" ("nie:contentCreated"); >CREATE TABLE "nfo:Image_nfo:depicts" (ID INTEGER NOT NULL, "nfo:depicts" INTEGER NOT NULL, "nfo:depicts:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:Image_nfo:depicts_ID_ID" ON "nfo:Image_nfo:depicts" (ID, "nfo:depicts"); >CREATE TABLE "nfo:Image_nfo:hasRegionOfInterest" (ID INTEGER NOT NULL, "nfo:hasRegionOfInterest" INTEGER NOT NULL, "nfo:hasRegionOfInterest:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:Image_nfo:hasRegionOfInterest_ID_ID" ON "nfo:Image_nfo:hasRegionOfInterest" (ID, "nfo:hasRegionOfInterest"); >CREATE TABLE "nfo:Image" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:verticalResolution" INTEGER, "nfo:verticalResolution:graph" INTEGER, "nfo:horizontalResolution" INTEGER, "nfo:horizontalResolution:graph" INTEGER, "nfo:orientation" INTEGER, "nfo:orientation:graph" INTEGER); >CREATE TABLE "nfo:RasterImage" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:DataContainer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:RemotePortAddress" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:MediaFileListEntry" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:listPosition" REAL, "nfo:listPosition:graph" INTEGER, "nfo:entryUrl" TEXT COLLATE TRACKER, "nfo:entryUrl:graph" INTEGER); >CREATE TABLE "nfo:VectorImage" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Audio" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:channels" INTEGER, "nfo:channels:graph" INTEGER, "nfo:sideChannels" INTEGER, "nfo:sideChannels:graph" INTEGER, "nfo:lfeChannels" INTEGER, "nfo:lfeChannels:graph" INTEGER, "nfo:sampleCount" INTEGER, "nfo:sampleCount:graph" INTEGER, "nfo:bitsPerSample" INTEGER, "nfo:bitsPerSample:graph" INTEGER, "nfo:frontChannels" INTEGER, "nfo:frontChannels:graph" INTEGER, "nfo:sampleRate" REAL, "nfo:sampleRate:graph" INTEGER, "nfo:averageAudioBitrate" REAL, "nfo:averageAudioBitrate:graph" INTEGER, "nfo:rearChannels" INTEGER, "nfo:rearChannels:graph" INTEGER, "nfo:gain" INTEGER, "nfo:gain:graph" INTEGER, "nfo:peakGain" INTEGER, "nfo:peakGain:graph" INTEGER, "nfo:audioOffset" REAL, "nfo:audioOffset:graph" INTEGER); >CREATE TABLE "nfo:CompressionType" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Icon" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:TextDocument" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:wordCount" INTEGER, "nfo:wordCount:graph" INTEGER, "nfo:lineCount" INTEGER, "nfo:lineCount:graph" INTEGER, "nfo:characterCount" INTEGER, "nfo:characterCount:graph" INTEGER); >CREATE TABLE "nfo:PlainTextDocument" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:HtmlDocument" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:OperatingSystem" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:MediaList_nfo:hasMediaFileListEntry" (ID INTEGER NOT NULL, "nfo:hasMediaFileListEntry" INTEGER NOT NULL, "nfo:hasMediaFileListEntry:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:MediaList_nfo:hasMediaFileListEntry_ID_ID" ON "nfo:MediaList_nfo:hasMediaFileListEntry" (ID, "nfo:hasMediaFileListEntry"); >CREATE TABLE "nfo:MediaList_nfo:mediaListEntry" (ID INTEGER NOT NULL, "nfo:mediaListEntry" INTEGER NOT NULL, "nfo:mediaListEntry:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:MediaList_nfo:mediaListEntry_ID_ID" ON "nfo:MediaList_nfo:mediaListEntry" (ID, "nfo:mediaListEntry"); >CREATE TABLE "nfo:MediaList" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:entryCounter" INTEGER, "nfo:entryCounter:graph" INTEGER, "nfo:listDuration" INTEGER, "nfo:listDuration:graph" INTEGER); >CREATE TABLE "nfo:Executable" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Folder" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Font" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:fontFamily" TEXT COLLATE TRACKER, "nfo:fontFamily:graph" INTEGER, "nfo:foundry" INTEGER, "nfo:foundry:graph" INTEGER); >CREATE TABLE "nfo:Filesystem" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:SoftwareService" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:SoftwareItem" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Presentation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:RemoteDataObject" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:PaginatedTextDocument" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:pageCount" INTEGER, "nfo:pageCount:graph" INTEGER); >CREATE TABLE "nfo:Video" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:frameRate" REAL, "nfo:frameRate:graph" INTEGER, "nfo:frameCount" INTEGER, "nfo:frameCount:graph" INTEGER, "nfo:averageVideoBitrate" REAL, "nfo:averageVideoBitrate:graph" INTEGER); >CREATE TABLE "nfo:Spreadsheet" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Trash" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:FileHash" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:hashValue" TEXT COLLATE TRACKER, "nfo:hashValue:graph" INTEGER, "nfo:hashAlgorithm" TEXT COLLATE TRACKER, "nfo:hashAlgorithm:graph" INTEGER); >CREATE TABLE "nfo:SourceCode" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:commentCharacterCount" INTEGER, "nfo:commentCharacterCount:graph" INTEGER, "nfo:programmingLanguage" TEXT COLLATE TRACKER, "nfo:programmingLanguage:graph" INTEGER, "nfo:definesClass" TEXT COLLATE TRACKER, "nfo:definesClass:graph" INTEGER, "nfo:definesFunction" TEXT COLLATE TRACKER, "nfo:definesFunction:graph" INTEGER, "nfo:definesGlobalVariable" TEXT COLLATE TRACKER, "nfo:definesGlobalVariable:graph" INTEGER); >CREATE TABLE "nfo:Application" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:EmbeddedFileDataObject" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:encoding" TEXT COLLATE TRACKER, "nfo:encoding:graph" INTEGER); >CREATE TABLE "nfo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:ArchiveItem" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:isPasswordProtected" INTEGER, "nfo:isPasswordProtected:graph" INTEGER); >CREATE TABLE "nfo:Archive" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:uncompressedSize" INTEGER, "nfo:uncompressedSize:graph" INTEGER); >CREATE TABLE "nfo:MindMap" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:MediaStream" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID INTEGER NOT NULL, "nfo:containsBookmarkFolder" INTEGER NOT NULL, "nfo:containsBookmarkFolder:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:BookmarkFolder_nfo:containsBookmarkFolder_ID_ID" ON "nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID, "nfo:containsBookmarkFolder"); >CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmark" (ID INTEGER NOT NULL, "nfo:containsBookmark" INTEGER NOT NULL, "nfo:containsBookmark:graph" INTEGER); >CREATE UNIQUE INDEX "nfo:BookmarkFolder_nfo:containsBookmark_ID_ID" ON "nfo:BookmarkFolder_nfo:containsBookmark" (ID, "nfo:containsBookmark"); >CREATE TABLE "nfo:BookmarkFolder" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:FilesystemImage" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:HardDiskPartition" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Cursor" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Bookmark" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:bookmarks" INTEGER, "nfo:bookmarks:graph" INTEGER, "nfo:characterPosition" INTEGER, "nfo:characterPosition:graph" INTEGER, "nfo:pageNumber" INTEGER, "nfo:pageNumber:graph" INTEGER, "nfo:streamPosition" INTEGER, "nfo:streamPosition:graph" INTEGER, "nfo:streamDuration" INTEGER, "nfo:streamDuration:graph" INTEGER); >CREATE TABLE "nfo:DeletedResource" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:originalLocation" TEXT COLLATE TRACKER, "nfo:originalLocation:graph" INTEGER, "nfo:deletionDate" INTEGER, "nfo:deletionDate:graph" INTEGER, "nfo:deletionDate:localDate" INTEGER, "nfo:deletionDate:localTime" INTEGER); >CREATE TABLE "nfo:Website" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:WebHistory" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:domain" TEXT COLLATE TRACKER, "nfo:domain:graph" INTEGER, "nfo:uri" TEXT COLLATE TRACKER, "nfo:uri:graph" INTEGER); >CREATE TABLE "nfo:Note" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:SoftwareCategory" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:softwareCategoryIcon" INTEGER, "nfo:softwareCategoryIcon:graph" INTEGER); >CREATE TABLE "nfo:SoftwareApplication" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Orientation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "poi:ObjectOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:Equipment" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:manufacturer" TEXT COLLATE TRACKER, "nfo:manufacturer:graph" INTEGER, "nfo:model" TEXT COLLATE TRACKER, "nfo:model:graph" INTEGER, "nfo:equipmentSoftware" TEXT COLLATE TRACKER, "nfo:equipmentSoftware:graph" INTEGER); >CREATE TABLE "nfo:HelpDocument" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nfo:RegionOfInterest" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:regionOfInterestX" REAL, "nfo:regionOfInterestX:graph" INTEGER, "nfo:regionOfInterestY" REAL, "nfo:regionOfInterestY:graph" INTEGER, "nfo:regionOfInterestWidth" REAL, "nfo:regionOfInterestWidth:graph" INTEGER, "nfo:regionOfInterestHeight" REAL, "nfo:regionOfInterestHeight:graph" INTEGER, "nfo:regionOfInterestType" INTEGER, "nfo:regionOfInterestType:graph" INTEGER, "nfo:roiRefersTo" INTEGER, "nfo:roiRefersTo:graph" INTEGER); >CREATE TABLE "nfo:RegionOfInterestContent" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:MimePart_nmo:mimeHeader" (ID INTEGER NOT NULL, "nmo:mimeHeader" INTEGER NOT NULL, "nmo:mimeHeader:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:MimePart_nmo:mimeHeader_ID_ID" ON "nmo:MimePart_nmo:mimeHeader" (ID, "nmo:mimeHeader"); >CREATE TABLE "nmo:MimePart" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:charSet" TEXT COLLATE TRACKER, "nmo:charSet:graph" INTEGER, "nmo:contentId" TEXT COLLATE TRACKER, "nmo:contentId:graph" INTEGER, "nmo:contentTransferEncoding" TEXT COLLATE TRACKER, "nmo:contentTransferEncoding:graph" INTEGER, "nmo:contentDescription" TEXT COLLATE TRACKER, "nmo:contentDescription:graph" INTEGER, "nmo:contentDisposition" TEXT COLLATE TRACKER, "nmo:contentDisposition:graph" INTEGER); >CREATE TABLE "nmo:Multipart_nmo:partBoundary" (ID INTEGER NOT NULL, "nmo:partBoundary" TEXT NOT NULL, "nmo:partBoundary:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Multipart_nmo:partBoundary_ID_ID" ON "nmo:Multipart_nmo:partBoundary" (ID, "nmo:partBoundary"); >CREATE TABLE "nmo:Multipart" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:Message_nmo:recipient" (ID INTEGER NOT NULL, "nmo:recipient" INTEGER NOT NULL, "nmo:recipient:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:recipient_ID_ID" ON "nmo:Message_nmo:recipient" (ID, "nmo:recipient"); >CREATE TABLE "nmo:Message_nmo:references" (ID INTEGER NOT NULL, "nmo:references" INTEGER NOT NULL, "nmo:references:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:references_ID_ID" ON "nmo:Message_nmo:references" (ID, "nmo:references"); >CREATE TABLE "nmo:Message_nmo:inReplyTo" (ID INTEGER NOT NULL, "nmo:inReplyTo" INTEGER NOT NULL, "nmo:inReplyTo:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:inReplyTo_ID_ID" ON "nmo:Message_nmo:inReplyTo" (ID, "nmo:inReplyTo"); >CREATE TABLE "nmo:Message_nmo:messageHeader" (ID INTEGER NOT NULL, "nmo:messageHeader" INTEGER NOT NULL, "nmo:messageHeader:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:messageHeader_ID_ID" ON "nmo:Message_nmo:messageHeader" (ID, "nmo:messageHeader"); >CREATE TABLE "nmo:Message_nmo:to" (ID INTEGER NOT NULL, "nmo:to" INTEGER NOT NULL, "nmo:to:graph" INTEGER); >CREATE INDEX "nmo:Message_nmo:to_ID" ON "nmo:Message_nmo:to" (ID); >CREATE UNIQUE INDEX "nmo:Message_nmo:to_ID_ID" ON "nmo:Message_nmo:to" ("nmo:to", ID); >CREATE TABLE "nmo:Message_nmo:bcc" (ID INTEGER NOT NULL, "nmo:bcc" INTEGER NOT NULL, "nmo:bcc:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:bcc_ID_ID" ON "nmo:Message_nmo:bcc" (ID, "nmo:bcc"); >CREATE TABLE "nmo:Message_nmo:cc" (ID INTEGER NOT NULL, "nmo:cc" INTEGER NOT NULL, "nmo:cc:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:cc_ID_ID" ON "nmo:Message_nmo:cc" (ID, "nmo:cc"); >CREATE TABLE "nmo:Message_nmo:hasAttachment" (ID INTEGER NOT NULL, "nmo:hasAttachment" INTEGER NOT NULL, "nmo:hasAttachment:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Message_nmo:hasAttachment_ID_ID" ON "nmo:Message_nmo:hasAttachment" (ID, "nmo:hasAttachment"); >CREATE TABLE "nmo:Message" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, "nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, "nmo:from" INTEGER, "nmo:from:graph" INTEGER, "nmo:isAnswered" INTEGER, "nmo:isAnswered:graph" INTEGER, "nmo:isDeleted" INTEGER, "nmo:isDeleted:graph" INTEGER, "nmo:isDraft" INTEGER, "nmo:isDraft:graph" INTEGER, "nmo:isRead" INTEGER, "nmo:isRead:graph" INTEGER, "nmo:isSent" INTEGER, "nmo:isSent:graph" INTEGER, "nmo:isEmergency" INTEGER, "nmo:isEmergency:graph" INTEGER, "nmo:htmlMessageContent" TEXT COLLATE TRACKER, "nmo:htmlMessageContent:graph" INTEGER, "nmo:messageId" TEXT COLLATE TRACKER, "nmo:messageId:graph" INTEGER, "nmo:messageSubject" TEXT COLLATE TRACKER, "nmo:messageSubject:graph" INTEGER, "nmo:receivedDate" INTEGER, "nmo:receivedDate:graph" INTEGER, "nmo:receivedDate:localDate" INTEGER, "nmo:receivedDate:localTime" INTEGER, "nmo:replyTo" INTEGER, "nmo:replyTo:graph" INTEGER, "nmo:sender" INTEGER, "nmo:sender:graph" INTEGER, "nmo:conversation" INTEGER, "nmo:conversation:graph" INTEGER, "nmo:communicationChannel" INTEGER, "nmo:communicationChannel:graph" INTEGER, "nmo:deliveryStatus" INTEGER, "nmo:deliveryStatus:graph" INTEGER, "nmo:reportDelivery" INTEGER, "nmo:reportDelivery:graph" INTEGER, "nmo:sentWithReportRead" INTEGER, "nmo:sentWithReportRead:graph" INTEGER, "nmo:reportReadStatus" INTEGER, "nmo:reportReadStatus:graph" INTEGER, "nmo:mustAnswerReportRead" INTEGER, "nmo:mustAnswerReportRead:graph" INTEGER, "nmo:mmsId" TEXT COLLATE TRACKER, "nmo:mmsId:graph" INTEGER); >CREATE INDEX "nmo:Message_nmo:communicationChannel" ON "nmo:Message" ("nmo:communicationChannel", "nmo:receivedDate"); >CREATE INDEX "nmo:Message_nmo:conversation" ON "nmo:Message" ("nmo:conversation"); >CREATE INDEX "nmo:Message_nmo:sender" ON "nmo:Message" ("nmo:sender"); >CREATE INDEX "nmo:Message_nmo:from" ON "nmo:Message" ("nmo:from"); >CREATE INDEX "nmo:Message_nmo:sentDate" ON "nmo:Message" ("nmo:sentDate"); >CREATE TABLE "nmo:Email_nmo:contentMimeType" (ID INTEGER NOT NULL, "nmo:contentMimeType" TEXT NOT NULL, "nmo:contentMimeType:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:Email_nmo:contentMimeType_ID_ID" ON "nmo:Email_nmo:contentMimeType" (ID, "nmo:contentMimeType"); >CREATE TABLE "nmo:Email" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:hasContent" INTEGER, "nmo:hasContent:graph" INTEGER, "nmo:isFlagged" INTEGER, "nmo:isFlagged:graph" INTEGER, "nmo:isRecent" INTEGER, "nmo:isRecent:graph" INTEGER, "nmo:status" TEXT COLLATE TRACKER, "nmo:status:graph" INTEGER, "nmo:responseType" TEXT COLLATE TRACKER, "nmo:responseType:graph" INTEGER); >CREATE TABLE "nmo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:MailAccount" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:accountName" TEXT COLLATE TRACKER, "nmo:accountName:graph" INTEGER, "nmo:accountDisplayName" TEXT COLLATE TRACKER, "nmo:accountDisplayName:graph" INTEGER, "nmo:fromAddress" INTEGER, "nmo:fromAddress:graph" INTEGER, "nmo:signature" TEXT COLLATE TRACKER, "nmo:signature:graph" INTEGER); >CREATE TABLE "nmo:MailboxDataObject" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:MessageHeader" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:headerName" TEXT COLLATE TRACKER, "nmo:headerName:graph" INTEGER, "nmo:headerValue" TEXT COLLATE TRACKER, "nmo:headerValue:graph" INTEGER); >CREATE TABLE "nmo:IMMessage" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:Conversation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:CommunicationChannel_nmo:hasParticipant" (ID INTEGER NOT NULL, "nmo:hasParticipant" INTEGER NOT NULL, "nmo:hasParticipant:graph" INTEGER); >CREATE INDEX "nmo:CommunicationChannel_nmo:hasParticipant_ID" ON "nmo:CommunicationChannel_nmo:hasParticipant" (ID); >CREATE UNIQUE INDEX "nmo:CommunicationChannel_nmo:hasParticipant_ID_ID" ON "nmo:CommunicationChannel_nmo:hasParticipant" ("nmo:hasParticipant", ID); >CREATE TABLE "nmo:CommunicationChannel" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:lastMessageDate" INTEGER, "nmo:lastMessageDate:graph" INTEGER, "nmo:lastMessageDate:localDate" INTEGER, "nmo:lastMessageDate:localTime" INTEGER, "nmo:lastSuccessfulMessageDate" INTEGER, "nmo:lastSuccessfulMessageDate:graph" INTEGER, "nmo:lastSuccessfulMessageDate:localDate" INTEGER, "nmo:lastSuccessfulMessageDate:localTime" INTEGER); >CREATE INDEX "nmo:CommunicationChannel_nmo:lastMessageDate" ON "nmo:CommunicationChannel" ("nmo:lastMessageDate"); >CREATE TABLE "nmo:PermanentChannel" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:TransientChannel" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:Call" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, "nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, "nmo:duration" INTEGER, "nmo:duration:graph" INTEGER); >CREATE INDEX "nmo:Call_nmo:sentDate" ON "nmo:Call" ("nmo:sentDate"); >CREATE TABLE "nmo:VOIPCall" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:MailFolder" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:folderName" TEXT COLLATE TRACKER, "nmo:folderName:graph" INTEGER, "nmo:serverCount" INTEGER, "nmo:serverCount:graph" INTEGER, "nmo:serverUnreadCount" INTEGER, "nmo:serverUnreadCount:graph" INTEGER); >CREATE TABLE "nmo:PhoneMessage_nmo:toVCard" (ID INTEGER NOT NULL, "nmo:toVCard" INTEGER NOT NULL, "nmo:toVCard:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:PhoneMessage_nmo:toVCard_ID_ID" ON "nmo:PhoneMessage_nmo:toVCard" (ID, "nmo:toVCard"); >CREATE TABLE "nmo:PhoneMessage" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:fromVCard" INTEGER, "nmo:fromVCard:graph" INTEGER, "nmo:encoding" TEXT COLLATE TRACKER, "nmo:encoding:graph" INTEGER, "nmo:phoneMessageId" INTEGER, "nmo:phoneMessageId:graph" INTEGER, "nmo:validityPeriod" INTEGER, "nmo:validityPeriod:graph" INTEGER); >CREATE TABLE "nmo:SMSMessage" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" (ID INTEGER NOT NULL, "nmo:containsPhoneMessageFolder" INTEGER NOT NULL, "nmo:containsPhoneMessageFolder:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder_ID_ID" ON "nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" (ID, "nmo:containsPhoneMessageFolder"); >CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID INTEGER NOT NULL, "nmo:containsPhoneMessage" INTEGER NOT NULL, "nmo:containsPhoneMessage:graph" INTEGER); >CREATE UNIQUE INDEX "nmo:PhoneMessageFolder_nmo:containsPhoneMessage_ID_ID" ON "nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID, "nmo:containsPhoneMessage"); >CREATE TABLE "nmo:PhoneMessageFolder" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:phoneMessageFolderId" TEXT COLLATE TRACKER, "nmo:phoneMessageFolderId:graph" INTEGER); >CREATE TABLE "nmo:DeliveryStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:ReportReadStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmo:MMSMessage" (ID INTEGER NOT NULL PRIMARY KEY, "nmo:mmsHasContent" INTEGER, "nmo:mmsHasContent:graph" INTEGER); >CREATE TABLE "ncal:UnionParentClass_ncal:attach" (ID INTEGER NOT NULL, "ncal:attach" INTEGER NOT NULL, "ncal:attach:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attach_ID_ID" ON "ncal:UnionParentClass_ncal:attach" (ID, "ncal:attach"); >CREATE TABLE "ncal:UnionParentClass_ncal:resources" (ID INTEGER NOT NULL, "ncal:resources" TEXT NOT NULL, "ncal:resources:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:resources_ID_ID" ON "ncal:UnionParentClass_ncal:resources" (ID, "ncal:resources"); >CREATE TABLE "ncal:UnionParentClass_ncal:attendee" (ID INTEGER NOT NULL, "ncal:attendee" INTEGER NOT NULL, "ncal:attendee:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attendee_ID_ID" ON "ncal:UnionParentClass_ncal:attendee" (ID, "ncal:attendee"); >CREATE TABLE "ncal:UnionParentClass_ncal:rrule" (ID INTEGER NOT NULL, "ncal:rrule" INTEGER NOT NULL, "ncal:rrule:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rrule_ID_ID" ON "ncal:UnionParentClass_ncal:rrule" (ID, "ncal:rrule"); >CREATE TABLE "ncal:UnionParentClass_ncal:ncalRelation" (ID INTEGER NOT NULL, "ncal:ncalRelation" TEXT NOT NULL, "ncal:ncalRelation:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:ncalRelation_ID_ID" ON "ncal:UnionParentClass_ncal:ncalRelation" (ID, "ncal:ncalRelation"); >CREATE TABLE "ncal:UnionParentClass_ncal:exdate" (ID INTEGER NOT NULL, "ncal:exdate" INTEGER NOT NULL, "ncal:exdate:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exdate_ID_ID" ON "ncal:UnionParentClass_ncal:exdate" (ID, "ncal:exdate"); >CREATE TABLE "ncal:UnionParentClass_ncal:rdate" (ID INTEGER NOT NULL, "ncal:rdate" INTEGER NOT NULL, "ncal:rdate:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rdate_ID_ID" ON "ncal:UnionParentClass_ncal:rdate" (ID, "ncal:rdate"); >CREATE TABLE "ncal:UnionParentClass_ncal:hasAlarm" (ID INTEGER NOT NULL, "ncal:hasAlarm" INTEGER NOT NULL, "ncal:hasAlarm:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:hasAlarm_ID_ID" ON "ncal:UnionParentClass_ncal:hasAlarm" (ID, "ncal:hasAlarm"); >CREATE TABLE "ncal:UnionParentClass_ncal:exrule" (ID INTEGER NOT NULL, "ncal:exrule" INTEGER NOT NULL, "ncal:exrule:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exrule_ID_ID" ON "ncal:UnionParentClass_ncal:exrule" (ID, "ncal:exrule"); >CREATE TABLE "ncal:UnionParentClass_ncal:categories" (ID INTEGER NOT NULL, "ncal:categories" TEXT NOT NULL, "ncal:categories:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:categories_ID_ID" ON "ncal:UnionParentClass_ncal:categories" (ID, "ncal:categories"); >CREATE TABLE "ncal:UnionParentClass_ncal:relatedToChild" (ID INTEGER NOT NULL, "ncal:relatedToChild" TEXT NOT NULL, "ncal:relatedToChild:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToChild_ID_ID" ON "ncal:UnionParentClass_ncal:relatedToChild" (ID, "ncal:relatedToChild"); >CREATE TABLE "ncal:UnionParentClass_ncal:relatedToParent" (ID INTEGER NOT NULL, "ncal:relatedToParent" TEXT NOT NULL, "ncal:relatedToParent:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToParent_ID_ID" ON "ncal:UnionParentClass_ncal:relatedToParent" (ID, "ncal:relatedToParent"); >CREATE TABLE "ncal:UnionParentClass" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:lastModified" INTEGER, "ncal:lastModified:graph" INTEGER, "ncal:lastModified:localDate" INTEGER, "ncal:lastModified:localTime" INTEGER, "ncal:trigger" INTEGER, "ncal:trigger:graph" INTEGER, "ncal:created" INTEGER, "ncal:created:graph" INTEGER, "ncal:created:localDate" INTEGER, "ncal:created:localTime" INTEGER, "ncal:url" INTEGER, "ncal:url:graph" INTEGER, "ncal:comment" TEXT COLLATE TRACKER, "ncal:comment:graph" INTEGER, "ncal:summaryAltRep" INTEGER, "ncal:summaryAltRep:graph" INTEGER, "ncal:priority" INTEGER, "ncal:priority:graph" INTEGER, "ncal:location" TEXT COLLATE TRACKER, "ncal:location:graph" INTEGER, "ncal:uid" TEXT COLLATE TRACKER, "ncal:uid:graph" INTEGER, "ncal:requestStatus" INTEGER, "ncal:requestStatus:graph" INTEGER, "ncal:recurrenceId" INTEGER, "ncal:recurrenceId:graph" INTEGER, "ncal:dtstamp" INTEGER, "ncal:dtstamp:graph" INTEGER, "ncal:dtstamp:localDate" INTEGER, "ncal:dtstamp:localTime" INTEGER, "ncal:class" INTEGER, "ncal:class:graph" INTEGER, "ncal:organizer" INTEGER, "ncal:organizer:graph" INTEGER, "ncal:dtend" INTEGER, "ncal:dtend:graph" INTEGER, "ncal:summary" TEXT COLLATE TRACKER, "ncal:summary:graph" INTEGER, "ncal:descriptionAltRep" INTEGER, "ncal:descriptionAltRep:graph" INTEGER, "ncal:commentAltRep" INTEGER, "ncal:commentAltRep:graph" INTEGER, "ncal:sequence" INTEGER, "ncal:sequence:graph" INTEGER, "ncal:contact" TEXT COLLATE TRACKER, "ncal:contact:graph" INTEGER, "ncal:contactAltRep" INTEGER, "ncal:contactAltRep:graph" INTEGER, "ncal:locationAltRep" INTEGER, "ncal:locationAltRep:graph" INTEGER, "ncal:geo" INTEGER, "ncal:geo:graph" INTEGER, "ncal:resourcesAltRep" INTEGER, "ncal:resourcesAltRep:graph" INTEGER, "ncal:dtstart" INTEGER, "ncal:dtstart:graph" INTEGER, "ncal:description" TEXT COLLATE TRACKER, "ncal:description:graph" INTEGER, "ncal:relatedToSibling" TEXT COLLATE TRACKER, "ncal:relatedToSibling:graph" INTEGER, "ncal:duration" INTEGER, "ncal:duration:graph" INTEGER); >CREATE TABLE "ncal:RecurrenceIdentifier" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:range" INTEGER, "ncal:range:graph" INTEGER, "ncal:recurrenceIdDateTime" INTEGER, "ncal:recurrenceIdDateTime:graph" INTEGER); >CREATE TABLE "ncal:AttachmentEncoding" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:RecurrenceFrequency" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Attachment" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:attachmentUri" INTEGER, "ncal:attachmentUri:graph" INTEGER, "ncal:fmttype" TEXT COLLATE TRACKER, "ncal:fmttype:graph" INTEGER, "ncal:encoding" INTEGER, "ncal:encoding:graph" INTEGER, "ncal:attachmentContent" TEXT COLLATE TRACKER, "ncal:attachmentContent:graph" INTEGER); >CREATE TABLE "ncal:AccessClassification" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:CalendarDataObject" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:RecurrenceIdentifierRange" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:AttendeeOrOrganizer" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:dir" INTEGER, "ncal:dir:graph" INTEGER, "ncal:involvedContact" INTEGER, "ncal:involvedContact:graph" INTEGER, "ncal:sentBy" INTEGER, "ncal:sentBy:graph" INTEGER); >CREATE TABLE "ncal:AlarmAction" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:RecurrenceRule_ncal:bysecond" (ID INTEGER NOT NULL, "ncal:bysecond" INTEGER NOT NULL, "ncal:bysecond:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysecond_ID_ID" ON "ncal:RecurrenceRule_ncal:bysecond" (ID, "ncal:bysecond"); >CREATE TABLE "ncal:RecurrenceRule_ncal:byday" (ID INTEGER NOT NULL, "ncal:byday" INTEGER NOT NULL, "ncal:byday:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byday_ID_ID" ON "ncal:RecurrenceRule_ncal:byday" (ID, "ncal:byday"); >CREATE TABLE "ncal:RecurrenceRule_ncal:byweekno" (ID INTEGER NOT NULL, "ncal:byweekno" INTEGER NOT NULL, "ncal:byweekno:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byweekno_ID_ID" ON "ncal:RecurrenceRule_ncal:byweekno" (ID, "ncal:byweekno"); >CREATE TABLE "ncal:RecurrenceRule_ncal:bymonthday" (ID INTEGER NOT NULL, "ncal:bymonthday" INTEGER NOT NULL, "ncal:bymonthday:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonthday_ID_ID" ON "ncal:RecurrenceRule_ncal:bymonthday" (ID, "ncal:bymonthday"); >CREATE TABLE "ncal:RecurrenceRule_ncal:bysetpos" (ID INTEGER NOT NULL, "ncal:bysetpos" INTEGER NOT NULL, "ncal:bysetpos:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysetpos_ID_ID" ON "ncal:RecurrenceRule_ncal:bysetpos" (ID, "ncal:bysetpos"); >CREATE TABLE "ncal:RecurrenceRule_ncal:byhour" (ID INTEGER NOT NULL, "ncal:byhour" INTEGER NOT NULL, "ncal:byhour:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byhour_ID_ID" ON "ncal:RecurrenceRule_ncal:byhour" (ID, "ncal:byhour"); >CREATE TABLE "ncal:RecurrenceRule_ncal:byminute" (ID INTEGER NOT NULL, "ncal:byminute" INTEGER NOT NULL, "ncal:byminute:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byminute_ID_ID" ON "ncal:RecurrenceRule_ncal:byminute" (ID, "ncal:byminute"); >CREATE TABLE "ncal:RecurrenceRule_ncal:byyearday" (ID INTEGER NOT NULL, "ncal:byyearday" INTEGER NOT NULL, "ncal:byyearday:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byyearday_ID_ID" ON "ncal:RecurrenceRule_ncal:byyearday" (ID, "ncal:byyearday"); >CREATE TABLE "ncal:RecurrenceRule_ncal:bymonth" (ID INTEGER NOT NULL, "ncal:bymonth" INTEGER NOT NULL, "ncal:bymonth:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonth_ID_ID" ON "ncal:RecurrenceRule_ncal:bymonth" (ID, "ncal:bymonth"); >CREATE TABLE "ncal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:until" INTEGER, "ncal:until:graph" INTEGER, "ncal:until:localDate" INTEGER, "ncal:until:localTime" INTEGER, "ncal:wkst" INTEGER, "ncal:wkst:graph" INTEGER, "ncal:interval" INTEGER, "ncal:interval:graph" INTEGER, "ncal:count" INTEGER, "ncal:count:graph" INTEGER, "ncal:freq" INTEGER, "ncal:freq:graph" INTEGER); >CREATE TABLE "ncal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:TimeTransparency" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:NcalTimeEntity" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:CalendarScale" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:BydayRulePart_ncal:bydayModifier" (ID INTEGER NOT NULL, "ncal:bydayModifier" INTEGER NOT NULL, "ncal:bydayModifier:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayModifier_ID_ID" ON "ncal:BydayRulePart_ncal:bydayModifier" (ID, "ncal:bydayModifier"); >CREATE TABLE "ncal:BydayRulePart_ncal:bydayWeekday" (ID INTEGER NOT NULL, "ncal:bydayWeekday" INTEGER NOT NULL, "ncal:bydayWeekday:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayWeekday_ID_ID" ON "ncal:BydayRulePart_ncal:bydayWeekday" (ID, "ncal:bydayWeekday"); >CREATE TABLE "ncal:BydayRulePart" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Weekday" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Trigger" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:related" INTEGER, "ncal:related:graph" INTEGER, "ncal:triggerDateTime" INTEGER, "ncal:triggerDateTime:graph" INTEGER, "ncal:triggerDateTime:localDate" INTEGER, "ncal:triggerDateTime:localTime" INTEGER, "ncal:triggerDuration" INTEGER, "ncal:triggerDuration:graph" INTEGER); >CREATE TABLE "ncal:FreebusyType" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:ParticipationStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:RequestStatus" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:statusDescription" TEXT COLLATE TRACKER, "ncal:statusDescription:graph" INTEGER, "ncal:returnStatus" TEXT COLLATE TRACKER, "ncal:returnStatus:graph" INTEGER, "ncal:requestStatusData" TEXT COLLATE TRACKER, "ncal:requestStatusData:graph" INTEGER); >CREATE TABLE "ncal:NcalDateTime" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:ncalTimezone" INTEGER, "ncal:ncalTimezone:graph" INTEGER, "ncal:date" INTEGER, "ncal:date:graph" INTEGER, "ncal:date:localDate" INTEGER, "ncal:date:localTime" INTEGER, "ncal:dateTime" INTEGER, "ncal:dateTime:graph" INTEGER, "ncal:dateTime:localDate" INTEGER, "ncal:dateTime:localTime" INTEGER); >CREATE TABLE "ncal:TimezoneObservance" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:tzoffsetfrom" TEXT COLLATE TRACKER, "ncal:tzoffsetfrom:graph" INTEGER, "ncal:tzoffsetto" TEXT COLLATE TRACKER, "ncal:tzoffsetto:graph" INTEGER, "ncal:tzname" TEXT COLLATE TRACKER, "ncal:tzname:graph" INTEGER); >CREATE TABLE "ncal:Organizer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:delegatedTo" INTEGER, "ncal:delegatedTo:graph" INTEGER, "ncal:delegatedFrom" INTEGER, "ncal:delegatedFrom:graph" INTEGER, "ncal:cutype" INTEGER, "ncal:cutype:graph" INTEGER, "ncal:member" INTEGER, "ncal:member:graph" INTEGER, "ncal:role" INTEGER, "ncal:role:graph" INTEGER, "ncal:rsvp" INTEGER, "ncal:rsvp:graph" INTEGER, "ncal:partstat" INTEGER, "ncal:partstat:graph" INTEGER); >CREATE TABLE "ncal:NcalPeriod" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:periodBegin" INTEGER, "ncal:periodBegin:graph" INTEGER, "ncal:periodBegin:localDate" INTEGER, "ncal:periodBegin:localTime" INTEGER, "ncal:periodDuration" INTEGER, "ncal:periodDuration:graph" INTEGER, "ncal:periodEnd" INTEGER, "ncal:periodEnd:graph" INTEGER, "ncal:periodEnd:localDate" INTEGER, "ncal:periodEnd:localTime" INTEGER); >CREATE TABLE "ncal:Calendar_ncal:component" (ID INTEGER NOT NULL, "ncal:component" INTEGER NOT NULL, "ncal:component:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:Calendar_ncal:component_ID_ID" ON "ncal:Calendar_ncal:component" (ID, "ncal:component"); >CREATE TABLE "ncal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:method" TEXT COLLATE TRACKER, "ncal:method:graph" INTEGER, "ncal:calscale" INTEGER, "ncal:calscale:graph" INTEGER, "ncal:prodid" TEXT COLLATE TRACKER, "ncal:prodid:graph" INTEGER, "ncal:version" TEXT COLLATE TRACKER, "ncal:version:graph" INTEGER); >CREATE TABLE "ncal:FreebusyPeriod" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:fbtype" INTEGER, "ncal:fbtype:graph" INTEGER); >CREATE TABLE "ncal:TriggerRelation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Alarm_ncal:action" (ID INTEGER NOT NULL, "ncal:action" INTEGER NOT NULL, "ncal:action:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:Alarm_ncal:action_ID_ID" ON "ncal:Alarm_ncal:action" (ID, "ncal:action"); >CREATE TABLE "ncal:Alarm" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:repeat" INTEGER, "ncal:repeat:graph" INTEGER); >CREATE TABLE "ncal:Event" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:eventStatus" INTEGER, "ncal:eventStatus:graph" INTEGER, "ncal:transp" INTEGER, "ncal:transp:graph" INTEGER); >CREATE TABLE "ncal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:percentComplete" INTEGER, "ncal:percentComplete:graph" INTEGER, "ncal:completed" INTEGER, "ncal:completed:graph" INTEGER, "ncal:completed:localDate" INTEGER, "ncal:completed:localTime" INTEGER, "ncal:todoStatus" INTEGER, "ncal:todoStatus:graph" INTEGER, "ncal:due" INTEGER, "ncal:due:graph" INTEGER); >CREATE TABLE "ncal:Freebusy_ncal:freebusy" (ID INTEGER NOT NULL, "ncal:freebusy" INTEGER NOT NULL, "ncal:freebusy:graph" INTEGER); >CREATE UNIQUE INDEX "ncal:Freebusy_ncal:freebusy_ID_ID" ON "ncal:Freebusy_ncal:freebusy" (ID, "ncal:freebusy"); >CREATE TABLE "ncal:Freebusy" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "ncal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:journalStatus" INTEGER, "ncal:journalStatus:graph" INTEGER); >CREATE TABLE "ncal:Timezone" (ID INTEGER NOT NULL PRIMARY KEY, "ncal:tzurl" INTEGER, "ncal:tzurl:graph" INTEGER, "ncal:standard" INTEGER, "ncal:standard:graph" INTEGER, "ncal:daylight" INTEGER, "ncal:daylight:graph" INTEGER, "ncal:tzid" TEXT COLLATE TRACKER, "ncal:tzid:graph" INTEGER); >CREATE TABLE "scal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:CalendarItem_scal:belongsToCalendar" (ID INTEGER NOT NULL, "scal:belongsToCalendar" INTEGER NOT NULL, "scal:belongsToCalendar:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:belongsToCalendar_ID_ID" ON "scal:CalendarItem_scal:belongsToCalendar" (ID, "scal:belongsToCalendar"); >CREATE TABLE "scal:CalendarItem_scal:attendee" (ID INTEGER NOT NULL, "scal:attendee" INTEGER NOT NULL, "scal:attendee:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:attendee_ID_ID" ON "scal:CalendarItem_scal:attendee" (ID, "scal:attendee"); >CREATE TABLE "scal:CalendarItem_scal:contact" (ID INTEGER NOT NULL, "scal:contact" INTEGER NOT NULL, "scal:contact:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:contact_ID_ID" ON "scal:CalendarItem_scal:contact" (ID, "scal:contact"); >CREATE TABLE "scal:CalendarItem_scal:access" (ID INTEGER NOT NULL, "scal:access" INTEGER NOT NULL, "scal:access:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:access_ID_ID" ON "scal:CalendarItem_scal:access" (ID, "scal:access"); >CREATE TABLE "scal:CalendarItem_scal:attachment" (ID INTEGER NOT NULL, "scal:attachment" INTEGER NOT NULL, "scal:attachment:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:attachment_ID_ID" ON "scal:CalendarItem_scal:attachment" (ID, "scal:attachment"); >CREATE TABLE "scal:CalendarItem_scal:rrule" (ID INTEGER NOT NULL, "scal:rrule" INTEGER NOT NULL, "scal:rrule:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarItem_scal:rrule_ID_ID" ON "scal:CalendarItem_scal:rrule" (ID, "scal:rrule"); >CREATE TABLE "scal:CalendarItem" (ID INTEGER NOT NULL PRIMARY KEY, "scal:textLocation" INTEGER, "scal:textLocation:graph" INTEGER, "scal:resources" TEXT COLLATE TRACKER, "scal:resources:graph" INTEGER, "scal:transparency" INTEGER, "scal:transparency:graph" INTEGER, "scal:calendarItemAlarm" INTEGER, "scal:calendarItemAlarm:graph" INTEGER, "scal:start" INTEGER, "scal:start:graph" INTEGER, "scal:end" INTEGER, "scal:end:graph" INTEGER, "scal:isAllDay" INTEGER, "scal:isAllDay:graph" INTEGER, "scal:priority" INTEGER, "scal:priority:graph" INTEGER, "scal:rdate" INTEGER, "scal:rdate:graph" INTEGER, "scal:exceptionRDate" INTEGER, "scal:exceptionRDate:graph" INTEGER); >CREATE TABLE "scal:TransparencyValues" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:Attendee_scal:member" (ID INTEGER NOT NULL, "scal:member" INTEGER NOT NULL, "scal:member:graph" INTEGER); >CREATE UNIQUE INDEX "scal:Attendee_scal:member_ID_ID" ON "scal:Attendee_scal:member" (ID, "scal:member"); >CREATE TABLE "scal:Attendee_scal:delegated-to" (ID INTEGER NOT NULL, "scal:delegated-to" INTEGER NOT NULL, "scal:delegated-to:graph" INTEGER); >CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-to_ID_ID" ON "scal:Attendee_scal:delegated-to" (ID, "scal:delegated-to"); >CREATE TABLE "scal:Attendee_scal:delegated-from" (ID INTEGER NOT NULL, "scal:delegated-from" INTEGER NOT NULL, "scal:delegated-from:graph" INTEGER); >CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-from_ID_ID" ON "scal:Attendee_scal:delegated-from" (ID, "scal:delegated-from"); >CREATE TABLE "scal:Attendee_scal:sent-by" (ID INTEGER NOT NULL, "scal:sent-by" INTEGER NOT NULL, "scal:sent-by:graph" INTEGER); >CREATE UNIQUE INDEX "scal:Attendee_scal:sent-by_ID_ID" ON "scal:Attendee_scal:sent-by" (ID, "scal:sent-by"); >CREATE TABLE "scal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, "scal:attendanceStatus" INTEGER, "scal:attendanceStatus:graph" INTEGER, "scal:attendeeRole" INTEGER, "scal:attendeeRole:graph" INTEGER, "scal:attendeeContact" INTEGER, "scal:attendeeContact:graph" INTEGER, "scal:rsvp" INTEGER, "scal:rsvp:graph" INTEGER, "scal:calendarUserType" INTEGER, "scal:calendarUserType:graph" INTEGER); >CREATE TABLE "scal:AttendanceStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:RSVPValues" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:Event" (ID INTEGER NOT NULL PRIMARY KEY, "scal:eventStatus" INTEGER, "scal:eventStatus:graph" INTEGER); >CREATE TABLE "scal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, "scal:todoStatus" INTEGER, "scal:todoStatus:graph" INTEGER, "scal:due" INTEGER, "scal:due:graph" INTEGER, "scal:completed" INTEGER, "scal:completed:graph" INTEGER, "scal:percentComplete" INTEGER, "scal:percentComplete:graph" INTEGER); >CREATE TABLE "scal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, "scal:journalStatus" INTEGER, "scal:journalStatus:graph" INTEGER); >CREATE TABLE "scal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:CalendarAlarm_scal:alarmAttendee" (ID INTEGER NOT NULL, "scal:alarmAttendee" INTEGER NOT NULL, "scal:alarmAttendee:graph" INTEGER); >CREATE UNIQUE INDEX "scal:CalendarAlarm_scal:alarmAttendee_ID_ID" ON "scal:CalendarAlarm_scal:alarmAttendee" (ID, "scal:alarmAttendee"); >CREATE TABLE "scal:CalendarAlarm" (ID INTEGER NOT NULL PRIMARY KEY, "scal:alarmOffset" INTEGER, "scal:alarmOffset:graph" INTEGER); >CREATE TABLE "scal:TimePoint" (ID INTEGER NOT NULL PRIMARY KEY, "scal:dateTime" INTEGER, "scal:dateTime:graph" INTEGER, "scal:dateTime:localDate" INTEGER, "scal:dateTime:localTime" INTEGER, "scal:TimeZone" TEXT COLLATE TRACKER, "scal:TimeZone:graph" INTEGER); >CREATE TABLE "scal:AccessLevel" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "scal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, "scal:recurrencePattern" TEXT COLLATE TRACKER, "scal:recurrencePattern:graph" INTEGER, "scal:recurrenceStartDate" INTEGER, "scal:recurrenceStartDate:graph" INTEGER, "scal:exception" INTEGER, "scal:exception:graph" INTEGER); >CREATE TABLE "nid3:ID3Audio_nid3:leadArtist" (ID INTEGER NOT NULL, "nid3:leadArtist" INTEGER NOT NULL, "nid3:leadArtist:graph" INTEGER); >CREATE UNIQUE INDEX "nid3:ID3Audio_nid3:leadArtist_ID_ID" ON "nid3:ID3Audio_nid3:leadArtist" (ID, "nid3:leadArtist"); >CREATE TABLE "nid3:ID3Audio" (ID INTEGER NOT NULL PRIMARY KEY, "nid3:title" TEXT COLLATE TRACKER, "nid3:title:graph" INTEGER, "nid3:albumTitle" TEXT COLLATE TRACKER, "nid3:albumTitle:graph" INTEGER, "nid3:contentType" TEXT COLLATE TRACKER, "nid3:contentType:graph" INTEGER, "nid3:length" INTEGER, "nid3:length:graph" INTEGER, "nid3:recordingYear" INTEGER, "nid3:recordingYear:graph" INTEGER, "nid3:trackNumber" TEXT COLLATE TRACKER, "nid3:trackNumber:graph" INTEGER, "nid3:partOfSet" TEXT COLLATE TRACKER, "nid3:partOfSet:graph" INTEGER, "nid3:comments" TEXT COLLATE TRACKER, "nid3:comments:graph" INTEGER); >CREATE TABLE "nmm:MusicPiece_nmm:lyrics" (ID INTEGER NOT NULL, "nmm:lyrics" INTEGER NOT NULL, "nmm:lyrics:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:MusicPiece_nmm:lyrics_ID_ID" ON "nmm:MusicPiece_nmm:lyrics" (ID, "nmm:lyrics"); >CREATE TABLE "nmm:MusicPiece" (ID INTEGER NOT NULL PRIMARY KEY, "nie:title" TEXT COLLATE TRACKER, "nie:title:graph" INTEGER, "nmm:musicAlbum" INTEGER, "nmm:musicAlbum:graph" INTEGER, "nmm:musicAlbumDisc" INTEGER, "nmm:musicAlbumDisc:graph" INTEGER, "nmm:beatsPerMinute" INTEGER, "nmm:beatsPerMinute:graph" INTEGER, "nmm:performer" INTEGER, "nmm:performer:graph" INTEGER, "nmm:composer" INTEGER, "nmm:composer:graph" INTEGER, "nmm:lyricist" INTEGER, "nmm:lyricist:graph" INTEGER, "nmm:trackNumber" INTEGER, "nmm:trackNumber:graph" INTEGER, "nmm:internationalStandardRecordingCode" TEXT COLLATE TRACKER, "nmm:internationalStandardRecordingCode:graph" INTEGER); >CREATE INDEX "nmm:MusicPiece_nmm:performer" ON "nmm:MusicPiece" ("nmm:performer"); >CREATE INDEX "nmm:MusicPiece_nmm:musicAlbum" ON "nmm:MusicPiece" ("nmm:musicAlbum"); >CREATE INDEX "nmm:MusicPiece_nie:title" ON "nmm:MusicPiece" ("nie:title"); >CREATE TABLE "nmm:MusicAlbum_nmm:albumArtist" (ID INTEGER NOT NULL, "nmm:albumArtist" INTEGER NOT NULL, "nmm:albumArtist:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:MusicAlbum_nmm:albumArtist_ID_ID" ON "nmm:MusicAlbum_nmm:albumArtist" (ID, "nmm:albumArtist"); >CREATE TABLE "nmm:MusicAlbum" (ID INTEGER NOT NULL PRIMARY KEY, "nie:title" TEXT COLLATE TRACKER, "nie:title:graph" INTEGER, "nmm:albumTrackCount" INTEGER, "nmm:albumTrackCount:graph" INTEGER, "nmm:albumTitle" TEXT COLLATE TRACKER, "nmm:albumTitle:graph" INTEGER, "nmm:albumDuration" INTEGER, "nmm:albumDuration:graph" INTEGER, "nmm:albumGain" INTEGER, "nmm:albumGain:graph" INTEGER, "nmm:albumPeakGain" INTEGER, "nmm:albumPeakGain:graph" INTEGER); >CREATE INDEX "nmm:MusicAlbum_nie:title" ON "nmm:MusicAlbum" ("nie:title"); >CREATE TABLE "nmm:MusicAlbumDisc" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:albumDiscAlbum" INTEGER, "nmm:albumDiscAlbum:graph" INTEGER, "nmm:musicCDIdentifier" TEXT COLLATE TRACKER, "nmm:musicCDIdentifier:graph" INTEGER, "nmm:setNumber" INTEGER, "nmm:setNumber:graph" INTEGER); >CREATE TABLE "nmm:SynchronizedText" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:isForHearingImpaired" INTEGER, "nmm:isForHearingImpaired:graph" INTEGER); >CREATE TABLE "nmm:Video_nmm:director" (ID INTEGER NOT NULL, "nmm:director" INTEGER NOT NULL, "nmm:director:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:Video_nmm:director_ID_ID" ON "nmm:Video_nmm:director" (ID, "nmm:director"); >CREATE TABLE "nmm:Video_nmm:leadActor" (ID INTEGER NOT NULL, "nmm:leadActor" INTEGER NOT NULL, "nmm:leadActor:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:Video_nmm:leadActor_ID_ID" ON "nmm:Video_nmm:leadActor" (ID, "nmm:leadActor"); >CREATE TABLE "nmm:Video_nmm:subtitle" (ID INTEGER NOT NULL, "nmm:subtitle" INTEGER NOT NULL, "nmm:subtitle:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:Video_nmm:subtitle_ID_ID" ON "nmm:Video_nmm:subtitle" (ID, "nmm:subtitle"); >CREATE TABLE "nmm:Video_mtp:scantype" (ID INTEGER NOT NULL, "mtp:scantype" INTEGER NOT NULL, "mtp:scantype:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:Video_mtp:scantype_ID_ID" ON "nmm:Video_mtp:scantype" (ID, "mtp:scantype"); >CREATE TABLE "nmm:Video" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:videoAlbum" INTEGER, "nmm:videoAlbum:graph" INTEGER, "nmm:isSeries" INTEGER, "nmm:isSeries:graph" INTEGER, "nmm:season" INTEGER, "nmm:season:graph" INTEGER, "nmm:episodeNumber" INTEGER, "nmm:episodeNumber:graph" INTEGER, "nmm:runTime" INTEGER, "nmm:runTime:graph" INTEGER, "nmm:synopsis" TEXT COLLATE TRACKER, "nmm:synopsis:graph" INTEGER, "nmm:MPAARating" TEXT COLLATE TRACKER, "nmm:MPAARating:graph" INTEGER, "nmm:category" TEXT COLLATE TRACKER, "nmm:category:graph" INTEGER, "nmm:producedBy" INTEGER, "nmm:producedBy:graph" INTEGER, "nmm:hasSubtitle" INTEGER, "nmm:hasSubtitle:graph" INTEGER, "nmm:isContentEncrypted" INTEGER, "nmm:isContentEncrypted:graph" INTEGER, "mtp:fourCC" TEXT COLLATE TRACKER, "mtp:fourCC:graph" INTEGER, "mtp:waveformat" TEXT COLLATE TRACKER, "mtp:waveformat:graph" INTEGER); >CREATE TABLE "nmm:Artist" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:artistName" TEXT COLLATE TRACKER, "nmm:artistName:graph" INTEGER); >CREATE INDEX "nmm:Artist_nmm:artistName" ON "nmm:Artist" ("nmm:artistName"); >CREATE TABLE "nmm:Playlist" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmm:ImageList" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmm:Photo" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:exposureTime" REAL, "nmm:exposureTime:graph" INTEGER, "nmm:flash" INTEGER, "nmm:flash:graph" INTEGER, "nmm:fnumber" REAL, "nmm:fnumber:graph" INTEGER, "nmm:focalLength" REAL, "nmm:focalLength:graph" INTEGER, "nmm:isoSpeed" REAL, "nmm:isoSpeed:graph" INTEGER, "nmm:meteringMode" INTEGER, "nmm:meteringMode:graph" INTEGER, "nmm:whiteBalance" INTEGER, "nmm:whiteBalance:graph" INTEGER, "nmm:isCropped" INTEGER, "nmm:isCropped:graph" INTEGER, "nmm:isColorCorrected" INTEGER, "nmm:isColorCorrected:graph" INTEGER); >CREATE TABLE "nmm:Flash" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmm:MeteringMode" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmm:WhiteBalance" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "nmm:RadioStation_nmm:carrier" (ID INTEGER NOT NULL, "nmm:carrier" INTEGER NOT NULL, "nmm:carrier:graph" INTEGER); >CREATE UNIQUE INDEX "nmm:RadioStation_nmm:carrier_ID_ID" ON "nmm:RadioStation_nmm:carrier" (ID, "nmm:carrier"); >CREATE TABLE "nmm:RadioStation" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:radioIcon" INTEGER, "nmm:radioIcon:graph" INTEGER, "nmm:radioPTY" INTEGER, "nmm:radioPTY:graph" INTEGER); >CREATE TABLE "nmm:DigitalRadio" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:streamingBitrate" INTEGER, "nmm:streamingBitrate:graph" INTEGER, "nmm:encoding" TEXT COLLATE TRACKER, "nmm:encoding:graph" INTEGER, "nmm:protocol" TEXT COLLATE TRACKER, "nmm:protocol:graph" INTEGER); >CREATE TABLE "nmm:AnalogRadio" (ID INTEGER NOT NULL PRIMARY KEY, "nmm:modulation" INTEGER, "nmm:modulation:graph" INTEGER, "nmm:frequency" INTEGER, "nmm:frequency:graph" INTEGER); >CREATE TABLE "nmm:RadioModulation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mto:TransferElement" (ID INTEGER NOT NULL PRIMARY KEY, "mto:source" INTEGER, "mto:source:graph" INTEGER, "mto:destination" INTEGER, "mto:destination:graph" INTEGER, "mto:startedTime" INTEGER, "mto:startedTime:graph" INTEGER, "mto:startedTime:localDate" INTEGER, "mto:startedTime:localTime" INTEGER, "mto:completedTime" INTEGER, "mto:completedTime:graph" INTEGER, "mto:completedTime:localDate" INTEGER, "mto:completedTime:localTime" INTEGER, "mto:state" INTEGER, "mto:state:graph" INTEGER); >CREATE TABLE "mto:Transfer_mto:transferList" (ID INTEGER NOT NULL, "mto:transferList" INTEGER NOT NULL, "mto:transferList:graph" INTEGER); >CREATE UNIQUE INDEX "mto:Transfer_mto:transferList_ID_ID" ON "mto:Transfer_mto:transferList" (ID, "mto:transferList"); >CREATE TABLE "mto:Transfer_mto:transferPrivacyLevel" (ID INTEGER NOT NULL, "mto:transferPrivacyLevel" TEXT NOT NULL, "mto:transferPrivacyLevel:graph" INTEGER); >CREATE UNIQUE INDEX "mto:Transfer_mto:transferPrivacyLevel_ID_ID" ON "mto:Transfer_mto:transferPrivacyLevel" (ID, "mto:transferPrivacyLevel"); >CREATE TABLE "mto:Transfer" (ID INTEGER NOT NULL PRIMARY KEY, "mto:transferState" INTEGER, "mto:transferState:graph" INTEGER, "mto:method" INTEGER, "mto:method:graph" INTEGER, "mto:created" INTEGER, "mto:created:graph" INTEGER, "mto:created:localDate" INTEGER, "mto:created:localTime" INTEGER, "mto:account" TEXT COLLATE TRACKER, "mto:account:graph" INTEGER, "mto:starter" INTEGER, "mto:starter:graph" INTEGER, "mto:agent" INTEGER, "mto:agent:graph" INTEGER); >CREATE TABLE "mto:UploadTransfer_mto:transferCategory" (ID INTEGER NOT NULL, "mto:transferCategory" TEXT NOT NULL, "mto:transferCategory:graph" INTEGER); >CREATE UNIQUE INDEX "mto:UploadTransfer_mto:transferCategory_ID_ID" ON "mto:UploadTransfer_mto:transferCategory" (ID, "mto:transferCategory"); >CREATE TABLE "mto:UploadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mto:DownloadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mto:SyncTransfer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mto:State" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mto:TransferMethod" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:GeoLocation_mlo:asBoundingBox" (ID INTEGER NOT NULL, "mlo:asBoundingBox" INTEGER NOT NULL, "mlo:asBoundingBox:graph" INTEGER); >CREATE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID" ON "mlo:GeoLocation_mlo:asBoundingBox" (ID); >CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID_ID" ON "mlo:GeoLocation_mlo:asBoundingBox" ("mlo:asBoundingBox", ID); >CREATE TABLE "mlo:GeoLocation_mlo:asGeoPoint" (ID INTEGER NOT NULL, "mlo:asGeoPoint" INTEGER NOT NULL, "mlo:asGeoPoint:graph" INTEGER); >CREATE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID" ON "mlo:GeoLocation_mlo:asGeoPoint" (ID); >CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID_ID" ON "mlo:GeoLocation_mlo:asGeoPoint" ("mlo:asGeoPoint", ID); >CREATE TABLE "mlo:GeoLocation_mlo:asPostalAddress" (ID INTEGER NOT NULL, "mlo:asPostalAddress" INTEGER NOT NULL, "mlo:asPostalAddress:graph" INTEGER); >CREATE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID" ON "mlo:GeoLocation_mlo:asPostalAddress" (ID); >CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID_ID" ON "mlo:GeoLocation_mlo:asPostalAddress" ("mlo:asPostalAddress", ID); >CREATE TABLE "mlo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:GeoPoint_mlo:latitude" (ID INTEGER NOT NULL, "mlo:latitude" REAL NOT NULL, "mlo:latitude:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:latitude_ID_ID" ON "mlo:GeoPoint_mlo:latitude" (ID, "mlo:latitude"); >CREATE TABLE "mlo:GeoPoint_mlo:longitude" (ID INTEGER NOT NULL, "mlo:longitude" REAL NOT NULL, "mlo:longitude:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:longitude_ID_ID" ON "mlo:GeoPoint_mlo:longitude" (ID, "mlo:longitude"); >CREATE TABLE "mlo:GeoPoint_mlo:altitude" (ID INTEGER NOT NULL, "mlo:altitude" REAL NOT NULL, "mlo:altitude:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:altitude_ID_ID" ON "mlo:GeoPoint_mlo:altitude" (ID, "mlo:altitude"); >CREATE TABLE "mlo:GeoPoint_mlo:timestamp" (ID INTEGER NOT NULL, "mlo:timestamp" INTEGER NOT NULL, "mlo:timestamp:graph" INTEGER, "mlo:timestamp:localDate" INTEGER NOT NULL, "mlo:timestamp:localTime" INTEGER NOT NULL); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:timestamp_ID_ID" ON "mlo:GeoPoint_mlo:timestamp" (ID, "mlo:timestamp"); >CREATE TABLE "mlo:GeoPoint_mlo:city" (ID INTEGER NOT NULL, "mlo:city" TEXT NOT NULL, "mlo:city:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:city_ID_ID" ON "mlo:GeoPoint_mlo:city" (ID, "mlo:city"); >CREATE TABLE "mlo:GeoPoint_mlo:country" (ID INTEGER NOT NULL, "mlo:country" TEXT NOT NULL, "mlo:country:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:country_ID_ID" ON "mlo:GeoPoint_mlo:country" (ID, "mlo:country"); >CREATE TABLE "mlo:GeoPoint_mlo:state" (ID INTEGER NOT NULL, "mlo:state" TEXT NOT NULL, "mlo:state:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:state_ID_ID" ON "mlo:GeoPoint_mlo:state" (ID, "mlo:state"); >CREATE TABLE "mlo:GeoPoint_mlo:address" (ID INTEGER NOT NULL, "mlo:address" TEXT NOT NULL, "mlo:address:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:address_ID_ID" ON "mlo:GeoPoint_mlo:address" (ID, "mlo:address"); >CREATE TABLE "mlo:GeoPoint" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:GeoSphere_mlo:radius" (ID INTEGER NOT NULL, "mlo:radius" REAL NOT NULL, "mlo:radius:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoSphere_mlo:radius_ID_ID" ON "mlo:GeoSphere_mlo:radius" (ID, "mlo:radius"); >CREATE TABLE "mlo:GeoSphere" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:GeoBoundingBox_mlo:bbNorthWest" (ID INTEGER NOT NULL, "mlo:bbNorthWest" INTEGER NOT NULL, "mlo:bbNorthWest:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbNorthWest_ID_ID" ON "mlo:GeoBoundingBox_mlo:bbNorthWest" (ID, "mlo:bbNorthWest"); >CREATE TABLE "mlo:GeoBoundingBox_mlo:bbSouthEast" (ID INTEGER NOT NULL, "mlo:bbSouthEast" INTEGER NOT NULL, "mlo:bbSouthEast:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbSouthEast_ID_ID" ON "mlo:GeoBoundingBox_mlo:bbSouthEast" (ID, "mlo:bbSouthEast"); >CREATE TABLE "mlo:GeoBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID INTEGER NOT NULL, "mlo:boxSouthWestCorner" INTEGER NOT NULL, "mlo:boxSouthWestCorner:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxSouthWestCorner_ID_ID" ON "mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID, "mlo:boxSouthWestCorner"); >CREATE TABLE "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID INTEGER NOT NULL, "mlo:boxEastLimit" INTEGER NOT NULL, "mlo:boxEastLimit:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxEastLimit_ID_ID" ON "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID, "mlo:boxEastLimit"); >CREATE TABLE "mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID INTEGER NOT NULL, "mlo:boxVerticalLimit" INTEGER NOT NULL, "mlo:boxVerticalLimit:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxVerticalLimit_ID_ID" ON "mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID, "mlo:boxVerticalLimit"); >CREATE TABLE "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID INTEGER NOT NULL, "mlo:boxNorthLimit" INTEGER NOT NULL, "mlo:boxNorthLimit:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxNorthLimit_ID_ID" ON "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID, "mlo:boxNorthLimit"); >CREATE TABLE "mlo:LocationBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:Route_mlo:startTime" (ID INTEGER NOT NULL, "mlo:startTime" INTEGER NOT NULL, "mlo:startTime:graph" INTEGER, "mlo:startTime:localDate" INTEGER NOT NULL, "mlo:startTime:localTime" INTEGER NOT NULL); >CREATE UNIQUE INDEX "mlo:Route_mlo:startTime_ID_ID" ON "mlo:Route_mlo:startTime" (ID, "mlo:startTime"); >CREATE TABLE "mlo:Route_mlo:endTime" (ID INTEGER NOT NULL, "mlo:endTime" INTEGER NOT NULL, "mlo:endTime:graph" INTEGER, "mlo:endTime:localDate" INTEGER NOT NULL, "mlo:endTime:localTime" INTEGER NOT NULL); >CREATE UNIQUE INDEX "mlo:Route_mlo:endTime_ID_ID" ON "mlo:Route_mlo:endTime" (ID, "mlo:endTime"); >CREATE TABLE "mlo:Route_mlo:routeDetails" (ID INTEGER NOT NULL, "mlo:routeDetails" TEXT NOT NULL, "mlo:routeDetails:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:Route_mlo:routeDetails_ID_ID" ON "mlo:Route_mlo:routeDetails" (ID, "mlo:routeDetails"); >CREATE TABLE "mlo:Route" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:LandmarkCategory_mlo:isRemovable" (ID INTEGER NOT NULL, "mlo:isRemovable" INTEGER NOT NULL, "mlo:isRemovable:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:LandmarkCategory_mlo:isRemovable_ID_ID" ON "mlo:LandmarkCategory_mlo:isRemovable" (ID, "mlo:isRemovable"); >CREATE TABLE "mlo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:Landmark_mlo:belongsToCategory" (ID INTEGER NOT NULL, "mlo:belongsToCategory" INTEGER NOT NULL, "mlo:belongsToCategory:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:Landmark_mlo:belongsToCategory_ID_ID" ON "mlo:Landmark_mlo:belongsToCategory" (ID, "mlo:belongsToCategory"); >CREATE TABLE "mlo:Landmark_mlo:poiLocation" (ID INTEGER NOT NULL, "mlo:poiLocation" INTEGER NOT NULL, "mlo:poiLocation:graph" INTEGER); >CREATE UNIQUE INDEX "mlo:Landmark_mlo:poiLocation_ID_ID" ON "mlo:Landmark_mlo:poiLocation" (ID, "mlo:poiLocation"); >CREATE TABLE "mlo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mlo:PointOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mfo:FeedElement" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:image" TEXT COLLATE TRACKER, "mfo:image:graph" INTEGER, "mfo:feedSettings" INTEGER, "mfo:feedSettings:graph" INTEGER); >CREATE TABLE "mfo:FeedChannel" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:updatedTime" INTEGER, "mfo:updatedTime:graph" INTEGER, "mfo:updatedTime:localDate" INTEGER, "mfo:updatedTime:localTime" INTEGER, "mfo:unreadCount" INTEGER, "mfo:unreadCount:graph" INTEGER, "mfo:totalCount" INTEGER, "mfo:totalCount:graph" INTEGER, "mfo:action" INTEGER, "mfo:action:graph" INTEGER, "mfo:type" INTEGER, "mfo:type:graph" INTEGER); >CREATE TABLE "mfo:FeedMessage_mfo:enclosureList" (ID INTEGER NOT NULL, "mfo:enclosureList" INTEGER NOT NULL, "mfo:enclosureList:graph" INTEGER); >CREATE UNIQUE INDEX "mfo:FeedMessage_mfo:enclosureList_ID_ID" ON "mfo:FeedMessage_mfo:enclosureList" (ID, "mfo:enclosureList"); >CREATE TABLE "mfo:FeedMessage" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:downloadedTime" INTEGER, "mfo:downloadedTime:graph" INTEGER, "mfo:downloadedTime:localDate" INTEGER, "mfo:downloadedTime:localTime" INTEGER); >CREATE TABLE "mfo:Enclosure" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:remoteLink" INTEGER, "mfo:remoteLink:graph" INTEGER, "mfo:groupDefault" INTEGER, "mfo:groupDefault:graph" INTEGER, "mfo:localLink" INTEGER, "mfo:localLink:graph" INTEGER, "mfo:optional" INTEGER, "mfo:optional:graph" INTEGER); >CREATE TABLE "mfo:FeedSettings" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:updateInterval" INTEGER, "mfo:updateInterval:graph" INTEGER, "mfo:expiryInterval" INTEGER, "mfo:expiryInterval:graph" INTEGER, "mfo:downloadPath" TEXT COLLATE TRACKER, "mfo:downloadPath:graph" INTEGER, "mfo:downloadFlag" INTEGER, "mfo:downloadFlag:graph" INTEGER, "mfo:maxSize" INTEGER, "mfo:maxSize:graph" INTEGER); >CREATE TABLE "mfo:Action" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "mfo:FeedType" (ID INTEGER NOT NULL PRIMARY KEY, "mfo:name" TEXT COLLATE TRACKER, "mfo:name:graph" INTEGER); >CREATE TABLE "mtp:ScanType" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE TABLE "tracker:Volume" (ID INTEGER NOT NULL PRIMARY KEY, "tracker:isMounted" INTEGER, "tracker:isMounted:graph" INTEGER, "tracker:unmountDate" INTEGER, "tracker:unmountDate:graph" INTEGER, "tracker:unmountDate:localDate" INTEGER, "tracker:unmountDate:localTime" INTEGER, "tracker:mountPoint" INTEGER, "tracker:mountPoint:graph" INTEGER, "tracker:isRemovable" INTEGER, "tracker:isRemovable:graph" INTEGER, "tracker:isOptical" INTEGER, "tracker:isOptical:graph" INTEGER); >CREATE TABLE "slo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY, "slo:isRemovable" INTEGER, "slo:isRemovable:graph" INTEGER, "slo:categoryIconUrl" INTEGER, "slo:categoryIconUrl:graph" INTEGER); >CREATE TABLE "slo:Landmark_slo:belongsToCategory" (ID INTEGER NOT NULL, "slo:belongsToCategory" INTEGER NOT NULL, "slo:belongsToCategory:graph" INTEGER); >CREATE UNIQUE INDEX "slo:Landmark_slo:belongsToCategory_ID_ID" ON "slo:Landmark_slo:belongsToCategory" (ID, "slo:belongsToCategory"); >CREATE TABLE "slo:Landmark_slo:hasContact" (ID INTEGER NOT NULL, "slo:hasContact" INTEGER NOT NULL, "slo:hasContact:graph" INTEGER); >CREATE UNIQUE INDEX "slo:Landmark_slo:hasContact_ID_ID" ON "slo:Landmark_slo:hasContact" (ID, "slo:hasContact"); >CREATE TABLE "slo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY, "slo:iconUrl" INTEGER, "slo:iconUrl:graph" INTEGER); >CREATE TABLE "slo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY, "slo:latitude" REAL, "slo:latitude:graph" INTEGER, "slo:longitude" REAL, "slo:longitude:graph" INTEGER, "slo:verticalAccuracy" REAL, "slo:verticalAccuracy:graph" INTEGER, "slo:horizontalAccuracy" REAL, "slo:horizontalAccuracy:graph" INTEGER, "slo:altitude" REAL, "slo:altitude:graph" INTEGER, "slo:boundingLatitudeMin" REAL, "slo:boundingLatitudeMin:graph" INTEGER, "slo:boundingLatitudeMax" REAL, "slo:boundingLatitudeMax:graph" INTEGER, "slo:boundingLongitudeMin" REAL, "slo:boundingLongitudeMin:graph" INTEGER, "slo:boundingLongitudeMax" REAL, "slo:boundingLongitudeMax:graph" INTEGER, "slo:radius" REAL, "slo:radius:graph" INTEGER, "slo:timestamp" INTEGER, "slo:timestamp:graph" INTEGER, "slo:timestamp:localDate" INTEGER, "slo:timestamp:localTime" INTEGER, "slo:postalAddress" INTEGER, "slo:postalAddress:graph" INTEGER); >CREATE INDEX "slo:GeoLocation_slo:postalAddress" ON "slo:GeoLocation" ("slo:postalAddress"); >CREATE TABLE "slo:Route_slo:routeDetails" (ID INTEGER NOT NULL, "slo:routeDetails" TEXT NOT NULL, "slo:routeDetails:graph" INTEGER); >CREATE UNIQUE INDEX "slo:Route_slo:routeDetails_ID_ID" ON "slo:Route_slo:routeDetails" (ID, "slo:routeDetails"); >CREATE TABLE "slo:Route" (ID INTEGER NOT NULL PRIMARY KEY, "slo:startTime" INTEGER, "slo:startTime:graph" INTEGER, "slo:startTime:localDate" INTEGER, "slo:startTime:localTime" INTEGER, "slo:endTime" INTEGER, "slo:endTime:graph" INTEGER, "slo:endTime:localDate" INTEGER, "slo:endTime:localTime" INTEGER); >CREATE TABLE "osinfo:Installer" (ID INTEGER NOT NULL PRIMARY KEY); >CREATE VIEW fts_view AS SELECT Resource.ID as rowid , "nfo:FileDataObject"."nfo:fileName" AS "nfo:fileName" , "nco:Affiliation_nco:title"."nco:title" AS "nco:title" , "nfo:Media"."nfo:genre" AS "nfo:genre" , "nfo:Media"."nmm:genre" AS "nmm:genre" , "nfo:Media"."mtp:creator" AS "mtp:creator" , "nco:PersonContact"."nco:nameFamily" AS "nco:nameFamily" , "nco:PersonContact"."nco:nameGiven" AS "nco:nameGiven" , "nco:PersonContact"."nco:nameAdditional" AS "nco:nameAdditional" , "nco:PersonContact"."nco:hobby" AS "nco:hobby" , "nco:PhoneNumber"."nco:phoneNumber" AS "nco:phoneNumber" , "nao:Tag"."nao:prefLabel" AS "nao:prefLabel" , "nao:Tag"."nao:description" AS "nao:description" , "nco:Contact"."nco:fullname" AS "nco:fullname" , "nco:Contact"."nco:nickname" AS "nco:nickname" , "nco:ContactGroup"."nco:contactGroupName" AS "nco:contactGroupName" , "nfo:Document"."nfo:tableOfContents" AS "nfo:tableOfContents" , "ncal:UnionParentClass"."ncal:comment" AS "ncal:comment" , "ncal:UnionParentClass"."ncal:location" AS "ncal:location" , "ncal:UnionParentClass"."ncal:summary" AS "ncal:summary" , "ncal:UnionParentClass"."ncal:contact" AS "ncal:contact" , "ncal:UnionParentClass"."ncal:description" AS "ncal:description" , "nmo:Message"."nmo:messageSubject" AS "nmo:messageSubject" , "nmm:MusicAlbum"."nmm:albumTitle" AS "nmm:albumTitle" , "nmm:Artist"."nmm:artistName" AS "nmm:artistName" , "nco:Affiliation"."nco:department" AS "nco:department" , "nco:Affiliation"."nco:role" AS "nco:role" , "nco:Contact_nco:note"."nco:note" AS "nco:note" , "nie:InformationElement_nie:keyword"."nie:keyword" AS "nie:keyword" , "nco:IMAddress"."nco:imID" AS "nco:imID" , "nco:IMAddress"."nco:imNickname" AS "nco:imNickname" , "nco:EmailAddress"."nco:emailAddress" AS "nco:emailAddress" , "nmm:Video"."nmm:category" AS "nmm:category" , "nfo:Font"."nfo:fontFamily" AS "nfo:fontFamily" , "nco:PostalAddress"."nco:region" AS "nco:region" , "nco:PostalAddress"."nco:country" AS "nco:country" , "nco:PostalAddress"."nco:extendedAddress" AS "nco:extendedAddress" , "nco:PostalAddress"."nco:streetAddress" AS "nco:streetAddress" , "nco:PostalAddress"."nco:postalcode" AS "nco:postalcode" , "nco:PostalAddress"."nco:locality" AS "nco:locality" , "nco:PostalAddress"."nco:county" AS "nco:county" , "nco:PostalAddress"."nco:district" AS "nco:district" , "nco:PostalAddress"."nco:pobox" AS "nco:pobox" , "nie:InformationElement"."nie:title" AS "nie:title" , "nie:InformationElement"."nie:subject" AS "nie:subject" , "nie:InformationElement"."nie:plainTextContent" AS "nie:plainTextContent" , "nie:InformationElement"."nie:description" AS "nie:description" , "nie:InformationElement"."nie:comment" AS "nie:comment" , "nid3:ID3Audio"."nid3:title" AS "nid3:title" , "nid3:ID3Audio"."nid3:albumTitle" AS "nid3:albumTitle" , "nid3:ID3Audio"."nid3:contentType" AS "nid3:contentType" FROM Resource LEFT OUTER JOIN "nfo:FileDataObject" ON Resource.ID = "nfo:FileDataObject".ID LEFT OUTER JOIN "nco:Affiliation_nco:title" ON Resource.ID = "nco:Affiliation_nco:title".ID LEFT OUTER JOIN "nfo:Media" ON Resource.ID = "nfo:Media".ID LEFT OUTER JOIN "nco:PersonContact" ON Resource.ID = "nco:PersonContact".ID LEFT OUTER JOIN "nco:PhoneNumber" ON Resource.ID = "nco:PhoneNumber".ID LEFT OUTER JOIN "nao:Tag" ON Resource.ID = "nao:Tag".ID LEFT OUTER JOIN "nco:Contact" ON Resource.ID = "nco:Contact".ID LEFT OUTER JOIN "nco:ContactGroup" ON Resource.ID = "nco:ContactGroup".ID LEFT OUTER JOIN "nfo:Document" ON Resource.ID = "nfo:Document".ID LEFT OUTER JOIN "ncal:UnionParentClass" ON Resource.ID = "ncal:UnionParentClass".ID LEFT OUTER JOIN "nmo:Message" ON Resource.ID = "nmo:Message".ID LEFT OUTER JOIN "nmm:MusicAlbum" ON Resource.ID = "nmm:MusicAlbum".ID LEFT OUTER JOIN "nmm:Artist" ON Resource.ID = "nmm:Artist".ID LEFT OUTER JOIN "nco:Affiliation" ON Resource.ID = "nco:Affiliation".ID LEFT OUTER JOIN "nco:Contact_nco:note" ON Resource.ID = "nco:Contact_nco:note".ID LEFT OUTER JOIN "nie:InformationElement_nie:keyword" ON Resource.ID = "nie:InformationElement_nie:keyword".ID LEFT OUTER JOIN "nco:IMAddress" ON Resource.ID = "nco:IMAddress".ID LEFT OUTER JOIN "nco:EmailAddress" ON Resource.ID = "nco:EmailAddress".ID LEFT OUTER JOIN "nmm:Video" ON Resource.ID = "nmm:Video".ID LEFT OUTER JOIN "nfo:Font" ON Resource.ID = "nfo:Font".ID LEFT OUTER JOIN "nco:PostalAddress" ON Resource.ID = "nco:PostalAddress".ID LEFT OUTER JOIN "nie:InformationElement" ON Resource.ID = "nie:InformationElement".ID LEFT OUTER JOIN "nid3:ID3Audio" ON Resource.ID = "nid3:ID3Audio".ID; >CREATE VIRTUAL TABLE fts USING fts4(content="fts_view", "nfo:fileName", "nco:title", "nfo:genre", "nmm:genre", "mtp:creator", "nco:nameFamily", "nco:nameGiven", "nco:nameAdditional", "nco:hobby", "nco:phoneNumber", "nao:prefLabel", "nao:description", "nco:fullname", "nco:nickname", "nco:contactGroupName", "nfo:tableOfContents", "ncal:comment", "ncal:location", "ncal:summary", "ncal:contact", "ncal:description", "nmo:messageSubject", "nmm:albumTitle", "nmm:artistName", "nco:department", "nco:role", "nco:note", "nie:keyword", "nco:imID", "nco:imNickname", "nco:emailAddress", "nmm:category", "nfo:fontFamily", "nco:region", "nco:country", "nco:extendedAddress", "nco:streetAddress", "nco:postalcode", "nco:locality", "nco:county", "nco:district", "nco:pobox", "nie:title", "nie:subject", "nie:plainTextContent", "nie:description", "nie:comment", "nid3:title", "nid3:albumTitle", "nid3:contentType", tokenize=TrackerTokenizer); >CREATE TABLE 'fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB); >CREATE TABLE 'fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx)); >CREATE TABLE 'fts_docsize'(docid INTEGER PRIMARY KEY, size BLOB); >CREATE TABLE 'fts_stat'(id INTEGER PRIMARY KEY, value BLOB);
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=889745">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 1075889
:
873800
|
873801
|
873802
|
873803
|
873804
|
873805
|
873806
|
873807
|
873808
|
873809
|
873810
|
889642
| 889745