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

[svn at limb-project.com]

Author: svk
Date: 2008-03-14 19:16:22 +0300 (Fri, 14 Mar 2008)
New Revision: 6838
URL: http://fisheye.limb-project.com/changelog/limb/?cs=6838

Added:
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.linter
Modified:
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql
Log:
-- postgres fixture fixed
-- linter fixture added

Added: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.linter
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.linter	                        (rev 0)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.linter	2008-03-14 16:16:22 UTC (rev 6838)
@@ -0,0 +1,121 @@
+CREATE OR REPLACE TABLE "test_one_table_object" (
+  "id" INT NOT NULL AUTOINC,
+  "annotation" blob,
+  "content" blob,
+  "news_date" date default NULL,
+  "ordr" int NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+CREATE OR REPLACE TABLE "test_auto_times_object" (
+  "id" INT NOT NULL AUTOINC,
+  "content" blob,
+  "ctime" int NULL,
+  "utime" int NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "test_one_table_typed_object" (
+  "id" INT NOT NULL AUTOINC,
+  "title" blob,
+  "kind" varchar(255) NOT NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE course_for_typed_test (
+ "id" INT NOT NULL AUTOINC,
+ "title" varchar(255) default NULL,
+ PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "lecture_for_typed_test" (
+  "id" INT NOT NULL AUTOINC,
+  "title" varchar(255) default NULL,
+  "course_id" int default NULL,
+  "kind" varchar(255) NOT NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+
+CREATE OR REPLACE TABLE social_security_for_test (
+"id" INT NOT NULL AUTOINC,
+"code" varchar(255) default NULL,
+PRIMARY   KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "person_for_test" (
+"id" INT NOT NULL AUTOINC,
+name varchar(255) default NULL,
+"ss_id" int default NULL,
+PRIMARY   KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "program_for_test" (
+ "id" INT NOT NULL AUTOINC,
+ "title" varchar(255) default NULL,
+ PRIMARY KEY  ("id")
+)  ;
+
+
+
+CREATE OR REPLACE TABLE "course_for_test" (
+ "id" INT NOT NULL AUTOINC,
+ "title" varchar(255) default NULL,
+ "program_id" int default NULL,
+ PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "lecture_for_test" (
+  "id" INT NOT NULL AUTOINC,
+  "title" varchar(255) default NULL,
+  "course_id" int default NULL,
+  "alt_course_id" int default NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR TABLE "lesson_for_test" (
+  "id" INT NOT NULL AUTOINC,
+  "date_start" int default NULL,
+  "date_end" int default NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "group_for_test" (
+  "id" INT NOT NULL AUTOINC,
+  "title" varchar(255)  default NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "user_for_test" (
+  "id" INT NOT NULL AUTOINC,
+  "first_name" varchar(255)  default NULL,
+  "linked_object_id" int default NULL,
+  PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "user2group_for_test" (
+ "id" INT NOT NULL AUTOINC,
+ "user_id" int default NULL,
+ "group_id" int default NULL,
+ PRIMARY KEY  ("id")
+)  ;
+
+
+CREATE OR REPLACE TABLE "extended_user2group_for_test" (
+ "id" INT NOT NULL AUTOINC,
+ "user_id" int default NULL,
+ "group_id" int default NULL,
+ "other_id" int default NULL,
+ PRIMARY KEY  ("id")
+)  ;

Modified: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql	2008-03-14 15:48:44 UTC (rev 6837)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql	2008-03-14 16:16:22 UTC (rev 6838)
@@ -15,7 +15,7 @@
   "id" SERIAL,
   "content" text,
   "ctime" int8 NULL,
-  "mtime" int8 NULL,
+  "utime" int8 NULL,
   PRIMARY KEY  (id)
 )  ;