blob: 6bbfb28c946133873230a6cb194cb0ea9daf8d09 (
plain) (
tree)
|
|
7� -� &�����r}�� &���=����$��SQLite format 3 @ .f�
@ |*�
��
�
@ j7�
indexIX_Property_VersionIdProperty CREATE INDEX "IX_Property_VersionId" ON "Property" ("VersionId")m9�indexIX_Property_LanguageIdPropertyCREATE INDEX "IX_Property_LanguageId" ON "Property" ("LanguageId")j7�
indexIX_Property_ContentIdPropertyCREATE INDEX "IX_Property_ContentId" ON "Property" ("ContentId")�r�7tablePropertyPropertyCREATE TABLE "Property" (
"Id" INTEGER NOT NULL CONSTRAINT "PK_Property" PRIMARY KEY AUTOINCREMENT,
"Text" TEXT NOT NULL,
"ContentId" INTEGER NOT NULL,
"LanguageId" INTEGER NOT NULL,
"VersionId" INTEGER NOT NULL,
CONSTRAINT "FK_Property_Content_ContentId" FOREIGN KEY ("ContentId") REFERENCES "Content" ("Id") ON DELETE CASCADE,
CONSTRAINT "FK_Property_Language_LanguageId" FOREIGN KEY ("LanguageId") REFERENCES "Language" ("Id") ON DELETE CASCADE,
CONSTRAINT "FK_Property_Version_VersionId" FOREIGN KEY ("VersionId") REFERENCES "Version" ("Id") ON DELETE CASCADE
)��YtableVersionVersionCREATE TABLE "Version" (
"Id" INTEGER NOT NULL CONSTRAINT "PK_Version" PRIMARY KEY AUTOINCREMENT
)�'�!tableLanguageLanguageCREATE TABLE "Language" (
"Id" INTEGER NOT NULL CONSTRAINT "PK_Language" PRIMARY KEY AUTOINCREMENT,
"LanguageCode" TEXT NOT NULL
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��YtableContentContentCREATE TABLE "Content" (
"Id" INTEGER NOT NULL CONSTRAINT "PK_Content" PRIMARY KEY AUTOINCREMENT
) &�����c��B�
&���)���X��
&����n�|��}
&���<&~~I"k�
&���/���9
&�����
���X)
&���}� 8j`9�
&���xK.���p�
&���S��l6y
� � Language &���Y�m�%
� ��� en-US nn-NO nb-NO
|