[Summary view] [Print] [Text view]

   1  
   2  DROP TABLE "test_one_table_object";
   3  CREATE TABLE "test_one_table_object" (
   4    "id" INTEGER PRIMARY KEY,
   5    "annotation" text,
   6    "content" text,
   7    "news_date" date default NULL,
   8    "ordr" int(11) NULL
   9  );
  10  
  11  DROP TABLE "test_auto_times_object";
  12  CREATE TABLE "test_auto_times_object" (
  13    "id" INTEGER PRIMARY KEY,
  14    "content" text,
  15    "ctime" int(11) NULL,
  16    "utime" int(11) NULL
  17  );
  18  
  19  DROP TABLE "test_one_table_typed_object";
  20  CREATE TABLE "test_one_table_typed_object" (
  21    "id" INTEGER PRIMARY KEY,
  22    "title" varchar(255) default NULL,
  23    "kind" varchar(255) NOT NULL
  24  );
  25  
  26  DROP TABLE "course_for_typed_test";
  27  CREATE TABLE "course_for_typed_test" (
  28   "id" INTEGER PRIMARY KEY,
  29   "title" varchar(255) default NULL
  30  );
  31  
  32  DROP TABLE "lecture_for_typed_test";
  33  CREATE TABLE "lecture_for_typed_test" (
  34    "id" INTEGER PRIMARY KEY,
  35    "title" varchar(255) default NULL,
  36    "course_id" bigint(20) default NULL,
  37    "kind" varchar(255) NOT NULL
  38  );
  39  
  40  
  41  DROP TABLE "social_security_for_test";
  42  CREATE TABLE "social_security_for_test" (
  43  "id" INTEGER PRIMARY KEY,
  44  "code" varchar(255) default NULL
  45  );
  46  
  47  DROP TABLE "person_for_test";
  48  CREATE TABLE "person_for_test" (
  49  "id" INTEGER PRIMARY KEY,
  50  "name" varchar(255) default NULL,
  51  "ss_id" bigint(20) default NULL
  52  );
  53  
  54  DROP TABLE "course_for_test";
  55  CREATE TABLE "course_for_test" (
  56   "id" INTEGER PRIMARY KEY,
  57   "title" varchar(255) default NULL
  58  );
  59  
  60  DROP TABLE "lecture_for_test";
  61  CREATE TABLE "lecture_for_test" (
  62    "id" INTEGER PRIMARY KEY,
  63    "title" varchar(255) default NULL,
  64    "course_id" bigint(20) default NULL,
  65    "alt_course_id" bigint(20) default NULL
  66  );
  67  
  68  DROP TABLE "lesson_for_test";
  69  CREATE TABLE "lesson_for_test" (
  70    "id" INTEGER PRIMARY KEY,
  71    "date_start" bigint(20) default NULL,
  72    "date_end" bigint(20) default NULL
  73  );
  74  
  75  DROP TABLE "group_for_test";
  76  CREATE TABLE "group_for_test" (
  77    "id" INTEGER PRIMARY KEY,
  78    "title" varchar(255) default NULL
  79  );
  80  
  81  DROP TABLE "user_for_test";
  82  CREATE TABLE "user_for_test" (
  83    "id" INTEGER PRIMARY KEY,
  84    "first_name" varchar(255) default NULL
  85  );
  86  
  87  DROP TABLE "user2group_for_test";
  88  CREATE TABLE "user2group_for_test" (
  89   "id" INTEGER PRIMARY KEY,
  90   "user_id" bigint(20) default NULL,
  91   "group_id" bigint(20) default NULL
  92  );
  93  
  94  DROP TABLE "extended_user2group_for_test";
  95  CREATE TABLE "extended_user2group_for_test" (
  96   "id" INTEGER PRIMARY KEY,
  97   "user_id" bigint(20) default NULL,
  98   "group_id" bigint(20) default NULL,
  99   "other_id" bigint(20) default NULL
 100  );