[Summary view] [Print] [Text view]

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