uQni4izT

1
2    if exists (select 1 from sys.objects where object_id = OBJECT_ID(N'[FK7867CB2431A8C8E6]') AND parent_object_id = OBJECT_ID('[Vehicle]'))
3alter table [Vehicle]  drop constraint FK7867CB2431A8C8E6
4
5
6    if exists (select * from dbo.sysobjects where id = object_id(N'[VehicleCollector]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [VehicleCollector]
7
8    if exists (select * from dbo.sysobjects where id = object_id(N'[Vehicle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [Vehicle]
9
10    create table [VehicleCollector] (
11        Id INT IDENTITY NOT NULL,
12       primary key (Id)
13    )
14
15    create table [Vehicle] (
16        Id INT IDENTITY NOT NULL,
17       type NVARCHAR(255) not null,
18       foo_id INT null,
19       primary key (Id)
20    )
21
22    alter table [Vehicle] 
23        add constraint FK7867CB2431A8C8E6 
24        foreign key (foo_id) 
25        references [VehicleCollector]
26NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
27NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
28NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
29NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
30NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
31NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
32NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
33NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
34NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
35NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
36NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
37NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
38NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
39NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
40NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
41NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
42NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
43NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
44NHibernate: INSERT INTO [Vehicle] (type) VALUES ('1'); select SCOPE_IDENTITY()
45NHibernate: INSERT INTO [Vehicle] (type) VALUES ('2'); select SCOPE_IDENTITY()
46NHibernate: INSERT INTO [VehicleCollector] DEFAULT VALUES; select SCOPE_IDENTITY()
47NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 1 [Type: Int32 (0)]
48NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 3 [Type: Int32 (0)]
49NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 5 [Type: Int32 (0)]
50NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 7 [Type: Int32 (0)]
51NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 9 [Type: Int32 (0)]
52NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 11 [Type: Int32 (0)]
53NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 13 [Type: Int32 (0)]
54NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 15 [Type: Int32 (0)]
55NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 17 [Type: Int32 (0)]
56NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 19 [Type: Int32 (0)]
57NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 2 [Type: Int32 (0)]
58NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 4 [Type: Int32 (0)]
59NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 6 [Type: Int32 (0)]
60NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 8 [Type: Int32 (0)]
61NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 10 [Type: Int32 (0)]
62NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 12 [Type: Int32 (0)]
63NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 14 [Type: Int32 (0)]
64NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 16 [Type: Int32 (0)]
65NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 18 [Type: Int32 (0)]
66NHibernate: UPDATE [Vehicle] SET foo_id = @p0 WHERE Id = @p1;@p0 = 1 [Type: Int32 (0)], @p1 = 20 [Type: Int32 (0)]
67
681 passed, 0 failed, 0 skipped, took 1.67 seconds (Ad hoc).