upgrade/account/02_forums.sql

   1 # Move forums tables to x4dat
   2 #RENAME  forums.list
   3 #    TO  x4dat.forums;
   4 #RENAME  forums.abos
   5 #    TO  x4dat.forum_subs;
   6 #RENAME  forums.innd
   7 #    TO  x4dat.forum_innd;
   8 #RENAME  forums.porfils
   9 #    TO  x4dat.forum_profiles;
  10 #DROP DATABASE forums;
  11
  12 ## Dev version of previous line
  13 # (non destructive)
  14 CREATE TABLE  x4dat.forums
  15         LIKE  forums.list;
  16 INSERT INTO  x4dat.forums
  17      SELECT  *
  18        FROM  forums.list;
  19
  20 CREATE TABLE  x4dat.forum_subs
  21         LIKE  forums.abos;
  22 INSERT INTO  x4dat.forum_subs
  23      SELECT  *
  24        FROM  forums.abos;
  25
  26 CREATE TABLE  x4dat.forum_innd
  27         LIKE  forums.innd;
  28 INSERT INTO  x4dat.forum_innd
  29      SELECT  *
  30        FROM  forums.innd;
  31
  32 CREATE TABLE  x4dat.forum_profiles
  33         LIKE  forums.profils;
  34 INSERT INTO  x4dat.forum_profiles
  35      SELECT  *
  36        FROM  forums.profils;
  37
  38
  39 # Conform to naming convention.
  40   ALTER TABLE  forums
  41 CHANGE COLUMN  nom name VARCHAR(64) NOT NULL;
  42
  43   ALTER TABLE  forum_profiles
  44 CHANGE COLUMN  nom name VARCHAR(64) NOT NULL,
  45    ADD COLUMN  last_seen TIMESTAMP NOT NULL DEFAULT '0000-00-00';
  46
  47 # vim:set syntax=mysql: