Mercurial > pub > bltoolkit
diff Data/Create Scripts/DB2.sql @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Data/Create Scripts/DB2.sql Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,89 @@ +DROP TABLE "Doctor" +GO + +DROP TABLE "Patient" +GO + +DROP TABLE "Person" +GO + +CREATE TABLE "Person" +( + "PersonID" INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL, + "FirstName" VARCHAR(50) NOT NULL, + "LastName" VARCHAR(50) NOT NULL, + "MiddleName" VARCHAR(50), + "Gender" CHAR(1) NOT NULL +) +GO + +INSERT INTO "Person" ("FirstName", "LastName", "Gender") VALUES ('John', 'Pupkin', 'M') +GO +INSERT INTO "Person" ("FirstName", "LastName", "Gender") VALUES ('Tester', 'Testerson', 'M') +GO + +-- Doctor Table Extension + +CREATE TABLE "Doctor" +( + "PersonID" INTEGER NOT NULL, + "Taxonomy" VARCHAR(50) NOT NULL +) +GO + +INSERT INTO "Doctor" ("PersonID", "Taxonomy") VALUES (1, 'Psychiatry') +GO + +-- Patient Table Extension + +CREATE TABLE "Patient" +( + "PersonID" INTEGER NOT NULL, + "Diagnosis" VARCHAR(256) NOT NULL +) +GO + +INSERT INTO "Patient" ("PersonID", "Diagnosis") VALUES (2, 'Hallucination with Paranoid Bugs'' Delirium of Persecution') +GO + + +DROP TABLE "Parent" +GO +DROP TABLE "Child" +GO +DROP TABLE "GrandChild" +GO + +CREATE TABLE "Parent" ("ParentID" int, "Value1" int) +GO +CREATE TABLE "Child" ("ParentID" int, "ChildID" int) +GO +CREATE TABLE "GrandChild" ("ParentID" int, "ChildID" int, "GrandChildID" int) +GO + + +DROP TABLE "LinqDataTypes" +GO + +CREATE TABLE "LinqDataTypes" +( + "ID" int, + "MoneyValue" decimal(10,4), + "DateTimeValue" timestamp, + "DateTimeValue2" timestamp NULL, + "BoolValue" smallint, + "GuidValue" char(16) for bit DATA, + "BinaryValue" blob(5000) NULL, + "SmallIntValue" smallint, + "IntValue" int NULL, + "BigIntValue" bigint NULL +) +GO + +DROP TABLE "TestIdentity" +GO + +CREATE TABLE "TestIdentity" ( + "ID" INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL +) +GO