Mercurial > pub > bltoolkit

comparison Data/Create Scripts/Informix.sql @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 DROP TABLE Doctor
2 GO
3
4 DROP TABLE Patient
5 GO
6
7 DROP TABLE Person
8 GO
9
10 CREATE TABLE Person
11 (
12 PersonID SERIAL NOT NULL,
13 FirstName NVARCHAR(50) NOT NULL,
14 LastName NVARCHAR(50) NOT NULL,
15 MiddleName NVARCHAR(50),
16 Gender CHAR(1) NOT NULL,
17
18 PRIMARY KEY(PersonID)
19 )
20 GO
21
22 INSERT INTO Person (FirstName, LastName, Gender) VALUES ('John', 'Pupkin', 'M')
23 GO
24 INSERT INTO Person (FirstName, LastName, Gender) VALUES ('Tester', 'Testerson', 'M')
25 GO
26
27 -- Doctor Table Extension
28
29 CREATE TABLE Doctor
30 (
31 PersonID int NOT NULL,
32 Taxonomy nvarchar(50) NOT NULL
33 )
34 GO
35
36 INSERT INTO Doctor (PersonID, Taxonomy) VALUES (1, 'Psychiatry')
37 GO
38
39 -- Patient Table Extension
40
41 CREATE TABLE Patient
42 (
43 PersonID int NOT NULL,
44 Diagnosis nvarchar(100) NOT NULL
45 )
46 GO
47
48 INSERT INTO Patient (PersonID, Diagnosis) VALUES (2, 'Hallucination with Paranoid Bugs'' Delirium of Persecution')
49 GO
50
51
52 DROP TABLE Parent
53 GO
54 DROP TABLE Child
55 GO
56 DROP TABLE GrandChild
57 GO
58
59 CREATE TABLE Parent (ParentID int, Value1 int)
60 GO
61 CREATE TABLE Child (ParentID int, ChildID int)
62 GO
63 CREATE TABLE GrandChild (ParentID int, ChildID int, GrandChildID int)
64 GO
65
66
67 DROP TABLE LinqDataTypes
68 GO
69
70 CREATE TABLE LinqDataTypes
71 (
72 ID int,
73 MoneyValue decimal(10,4),
74 DateTimeValue datetime year to fraction(3),
75 DateTimeValue2 datetime year to fraction(3),
76 BoolValue boolean,
77 GuidValue char(36),
78 BinaryValue byte,
79 SmallIntValue smallint,
80 IntValue int,
81 BigIntValue bigint
82 )
83 GO
84
85 DROP TABLE TestIdentity
86 GO
87
88 CREATE TABLE TestIdentity (
89 ID SERIAL NOT NULL,
90 PRIMARY KEY(ID)
91 )
92 GO