text: IF OBJECT_ID('[dbo].[order_item]', 'U') IS NOT NULL DROP TABLE [dbo].[order_item];
  IF OBJECT_ID('[dbo].[order_item_with_null_fk]', 'U') IS NOT NULL DROP TABLE [dbo].[order_item_with_null_fk];
  IF OBJECT_ID('[dbo].[item]', 'U') IS NOT NULL DROP TABLE [dbo].[item];
  IF OBJECT_ID('[dbo].[order]', 'U') IS NOT NULL DROP TABLE [dbo].[order];
  IF OBJECT_ID('[dbo].[order_with_null_fk]', 'U') IS NOT NULL DROP TABLE [dbo].[order_with_null_fk];
  IF OBJECT_ID('[dbo].[category]', 'U') IS NOT NULL DROP TABLE [dbo].[category];
  IF OBJECT_ID('[dbo].[customer]', 'U') IS NOT NULL DROP TABLE [dbo].[customer];
  IF OBJECT_ID('[dbo].[profile]', 'U') IS NOT NULL DROP TABLE [dbo].[profile];
  IF OBJECT_ID('[dbo].[type]', 'U') IS NOT NULL DROP TABLE [dbo].[type];
  IF OBJECT_ID('[dbo].[null_values]', 'U') IS NOT NULL DROP TABLE [dbo].[null_values];
  IF OBJECT_ID('[dbo].[animal]', 'U') IS NOT NULL DROP TABLE [dbo].[animal];
  
  CREATE TABLE [dbo].[profile] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[description] [varchar](128) NOT NULL,
  	CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  );
  
  CREATE TABLE [dbo].[customer] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[email] [varchar](128) NOT NULL,
  	[name] [varchar](128),
  	[address] [text],
  	[status] [int] DEFAULT 0,
    [profile_id] [int],
  	CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  );
  
  CREATE TABLE [dbo].[category] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[name] [varchar](128) NOT NULL,
  	CONSTRAINT [PK_category] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  );
  
  CREATE TABLE [dbo].[item] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[name] [varchar](128) NOT NULL,
  	[category_id] [int] NOT NULL,
  	CONSTRAINT [PK_item] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  );
  
  CREATE TABLE [dbo].[order] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[customer_id] [int] NOT NULL,
  	[created_at] [int] NOT NULL,
  	[total] [decimal](10,0) NOT NULL,
  	CONSTRAINT [PK_order] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  );
  
  CREATE TABLE [dbo].[order_with_null_fk] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[customer_id] [int] ,
  	[created_at] [int] NOT NULL,
  	[total] [decimal](10,0) NOT NULL
  );
  
  CREATE TABLE [dbo].[order_item] (
  	[order_id] [int] NOT NULL,
  	[item_id] [int] NOT NULL,
  	[quantity] [int] NOT NULL,
  	[subtotal] [decimal](10,0) NOT NULL,
  	CONSTRAINT [PK_order_item] PRIMARY KEY CLUSTERED (
  		[order_id] ASC,
  		[item_id] ASC
  	) ON [PRIMARY]
  
  );CREATE TABLE [dbo].[order_item_with_null_fk] (
  	[order_id] [int],
  	[item_id] [int],
  	[quantity] [int] NOT NULL,
  	[subtotal] [decimal](10,0) NOT NULL
  );
  
  CREATE TABLE [dbo].[null_values] (
    id [int] UNSIGNED NOT NULL,
    var1 [int] UNSIGNED NULL,
    var2 [int] NULL,
    var3 [int] DEFAULT NULL,
    stringcol [varchar](32) DEFAULT NULL,
    PRIMARY KEY (id)
  );
  
  CREATE TABLE [dbo].[type] (
  	[int_col] [int] NOT NULL,
  	[int_col2] [int] DEFAULT '1',
  	[smallint_col] [smallint] DEFAULT '1',
  	[char_col] [char](100) NOT NULL,
  	[char_col2] [varchar](100) DEFAULT 'something',
  	[char_col3] [text],
  	[float_col] [decimal](4,3) NOT NULL,
  	[float_col2] [float] DEFAULT '1.23',
  	[blob_col] [varbinary](MAX),
  	[numeric_col] [decimal](5,2) DEFAULT '33.22',
  	[time] [datetime] NOT NULL DEFAULT '2002-01-01 00:00:00',
  	[bool_col] [tinyint] NOT NULL,
  	[bool_col2] [tinyint] DEFAULT '1'
  );
  
  CREATE TABLE [dbo].[animal] (
  	[id] [int] IDENTITY(1,1) NOT NULL,
  	[type] [varchar](255) NOT NULL,
  	CONSTRAINT [PK_animal] PRIMARY KEY CLUSTERED (
  		[id] ASC
  	) ON [PRIMARY]
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO [dbo].[animal] (type) VALUES ('yiiunit\data\ar\Cat');
  INSERT INTO [dbo].[animal] (type) VALUES ('yiiunit\data\ar\Dog');
  
  INSERT INTO [dbo].[profile] ([description]) VALUES ('profile customer 1');
  INSERT INTO [dbo].[profile] ([description]) VALUES ('profile customer 3');
  
  INSERT INTO [dbo].[customer] ([email], [name], [address], [status], [profile_id]) VALUES ('user1@example.com', 'user1', 'address1', 1, 1);
  INSERT INTO [dbo].[customer] ([email], [name], [address], [status]) VALUES ('user2@example.com', 'user2', 'address2', 1);
  INSERT INTO [dbo].[customer] ([email], [name], [address], [status], [profile_id]) VALUES ('user3@example.com', 'user3', 'address3', 2, 2);
  
  INSERT INTO [dbo].[category] ([name]) VALUES ('Books');
  INSERT INTO [dbo].[category] ([name]) VALUES ('Movies');
  
  INSERT INTO [dbo].[item] ([name], [category_id]) VALUES ('Agile Web Application Development with Yii1.1 and PHP5', 1);
  INSERT INTO [dbo].[item] ([name], [category_id]) VALUES ('Yii 1.1 Application Development Cookbook', 1);
  INSERT INTO [dbo].[item] ([name], [category_id]) VALUES ('Ice Age', 2);
  INSERT INTO [dbo].[item] ([name], [category_id]) VALUES ('Toy Story', 2);
  INSERT INTO [dbo].[item] ([name], [category_id]) VALUES ('Cars', 2);
  
  INSERT INTO [dbo].[order] ([customer_id], [created_at], [total]) VALUES (1, 1325282384, 110.0);
  INSERT INTO [dbo].[order] ([customer_id], [created_at], [total]) VALUES (2, 1325334482, 33.0);
  INSERT INTO [dbo].[order] ([customer_id], [created_at], [total]) VALUES (2, 1325502201, 40.0);
  
  INSERT INTO [dbo].[order_with_null_fk] ([customer_id], [created_at], [total]) VALUES (1, 1325282384, 110.0);
  INSERT INTO [dbo].[order_with_null_fk] ([customer_id], [created_at], [total]) VALUES (2, 1325334482, 33.0);
  INSERT INTO [dbo].[order_with_null_fk] ([customer_id], [created_at], [total]) VALUES (2, 1325502201, 40.0);
  
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (1, 1, 1, 30.0);
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (1, 2, 2, 40.0);
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 4, 1, 10.0);
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 5, 1, 15.0);
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 3, 1, 8.0);
  INSERT INTO [dbo].[order_item] ([order_id], [item_id], [quantity], [subtotal]) VALUES (3, 2, 1, 40.0);
  
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (1, 1, 1, 30.0);
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (1, 2, 2, 40.0);
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 4, 1, 10.0);
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 5, 1, 15.0);
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (2, 3, 1, 8.0);
  INSERT INTO [dbo].[order_item_with_null_fk] ([order_id], [item_id], [quantity], [subtotal]) VALUES (3, 2, 1, 40.0);
  