[limb-svn] r7008 - 3.x/trunk/limb/active_record/tests/cases/.fixture

[svn at limb-project.com]

Author: korchasa
Date: 2008-05-12 12:57:46 +0400 (Mon, 12 May 2008)
New Revision: 7008
URL: http://fisheye.limb-project.com/changelog/limb/?cs=7008

Added:
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.mysqli
Log:
-- added fixture for mysqli driver

Added: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.mysqli
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.mysqli	                        (rev 0)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.mysqli	2008-05-12 08:57:46 UTC (rev 7008)
@@ -0,0 +1,123 @@
+
+DROP TABLE IF EXISTS `test_one_table_object`;
+CREATE TABLE `test_one_table_object` (
+  `id` int(11) NOT NULL auto_increment,
+  `annotation` varchar(50),
+  `content` varchar(50),
+  `news_date` date default NULL,
+  `ordr` int(11) NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `test_auto_times_object`;
+CREATE TABLE `test_auto_times_object` (
+  `id` int(11) NOT NULL auto_increment,
+  `content` varchar(50),
+  `ctime` int(11) NULL,
+  `utime` int(11) NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `test_one_table_typed_object`;
+CREATE TABLE `test_one_table_typed_object` (
+  `id` bigint(11) NOT NULL auto_increment,
+  `title` varchar(50) default NULL,
+  `kind` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `course_for_typed_test`;
+CREATE TABLE `course_for_typed_test` (
+ `id` int(11) NOT NULL auto_increment,
+ `title` varchar(50) default NULL,
+ PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `lecture_for_typed_test`;
+CREATE TABLE `lecture_for_typed_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `title` varchar(50) default NULL,
+  `course_id` int(11) default NULL,
+  `kind` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+
+DROP TABLE IF EXISTS `social_security_for_test`;
+CREATE TABLE `social_security_for_test` (
+`id` int(11) NOT NULL auto_increment,
+`code` varchar(50) default NULL,
+PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `person_for_test`;
+CREATE TABLE `person_for_test` (
+`id` int(11) NOT NULL auto_increment,
+`name` varchar(50) default NULL,
+`ss_id` int(11) default NULL,
+PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `program_for_test`;
+CREATE TABLE `program_for_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `title` varchar(50) default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `course_for_test`;
+CREATE TABLE `course_for_test` (
+ `id` int(11) NOT NULL auto_increment,
+ `program_id` int(11) default NULL,
+ `title` varchar(50) default NULL,
+ PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `lecture_for_test`;
+CREATE TABLE `lecture_for_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `title` varchar(50) default NULL,
+  `course_id` int(11) default NULL,
+  `alt_course_id` int(11) default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `lesson_for_test`;
+CREATE TABLE `lesson_for_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `date_start` int(11) default NULL,
+  `date_end` int(11) default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `group_for_test`;
+CREATE TABLE `group_for_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `title` varchar(50) default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `user_for_test`;
+CREATE TABLE `user_for_test` (
+  `id` int(11) NOT NULL auto_increment,
+  `first_name` varchar(50) default NULL,
+  `linked_object_id` int(11) default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `user2group_for_test`;
+CREATE TABLE `user2group_for_test` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) default NULL,
+ `group_id` int(11) default NULL,
+ PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `extended_user2group_for_test`;
+CREATE TABLE `extended_user2group_for_test` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) default NULL,
+ `group_id` int(11) default NULL,
+ `other_id` int(11) default NULL,
+ PRIMARY KEY  (`id`)
+) ENGINE=Memory DEFAULT CHARSET=utf8;