upgrade/account/08_groups.sql

   1 CREATE TABLE  group_announces
   2         LIKE  groupex.announces;
   3  INSERT INTO  group_announces
   4       SELECT  *
   5         FROM  groupex.announces;
   6
   7 CREATE TABLE  group_announces_photo
   8         LIKE  groupex.announces_photo;
   9  INSERT INTO  group_announces_photo
  10       SELECT  *
  11         FROM  groupex.announces_photo;
  12
  13 CREATE TABLE  group_announces_read
  14         LIKE  groupex.announces_read;
  15  INSERT INTO  group_announces_read
  16       SELECT  *
  17         FROM  groupex.announces_read;
  18
  19 CREATE TABLE  groups
  20         LIKE  groupex.asso;
  21  INSERT INTO  groups
  22       SELECT  *
  23         FROM  groupex.asso;
  24
  25 CREATE TABLE  group_dom
  26         LIKE  groupex.dom;
  27  INSERT INTO  group_dom
  28       SELECT  *
  29         FROM  groupex.dom;
  30
  31 CREATE TABLE  group_events
  32         LIKE  groupex.evenements;
  33  INSERT INTO  group_events
  34       SELECT  *
  35         FROM  groupex.evenements;
  36
  37 CREATE TABLE  group_event_items
  38         LIKE  groupex.evenements_items;
  39  INSERT INTO  group_event_items
  40       SELECT  *
  41         FROM  groupex.evenements_items;
  42
  43 CREATE TABLE  group_event_participants
  44         LIKE  groupex.evenements_participants;
  45  INSERT INTO  group_event_participants
  46       SELECT  *
  47         FROM  groupex.evenements_participants;
  48
  49 CREATE TABLE  group_members
  50         LIKE  groupex.membres;
  51  INSERT INTO  group_members
  52       SELECT  *
  53         FROM  groupex.membres;
  54
  55 CREATE TABLE  group_member_sub_requests
  56         LIKE  groupex.membres_sub_requests;
  57  INSERT INTO  group_member_sub_requests
  58       SELECT  *
  59         FROM  groupex.membres_sub_requests;
  60
  61 CREATE TABLE  group_auth
  62         LIKE  x4dat.groupesx_auth;
  63  INSERT INTO  group_auth
  64       SELECT  *
  65         FROM  x4dat.groupesx_auth;
  66
  67 # vim:set ft=mysql: