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