[Summary view] [Print] [Text view]

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