Commit | Line | Data |
---|---|---|
7d15f750 FB |
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) | |
06490196 VZ |
14 | CREATE TABLE #x4dat#.forums |
15 | LIKE #forums#.list; | |
16 | INSERT INTO #x4dat#.forums | |
7d15f750 | 17 | SELECT * |
06490196 | 18 | FROM #forums#.list; |
7d15f750 | 19 | |
06490196 VZ |
20 | CREATE TABLE #x4dat#.forum_subs |
21 | LIKE #forums#.abos; | |
22 | INSERT INTO #x4dat#.forum_subs | |
7d15f750 | 23 | SELECT * |
06490196 | 24 | FROM #forums#.abos; |
7d15f750 | 25 | |
06490196 VZ |
26 | CREATE TABLE #x4dat#.forum_innd |
27 | LIKE #forums#.innd; | |
28 | INSERT INTO #x4dat#.forum_innd | |
7d15f750 | 29 | SELECT * |
06490196 | 30 | FROM #forums#.innd; |
7d15f750 | 31 | |
06490196 VZ |
32 | CREATE TABLE #x4dat#.forum_profiles |
33 | LIKE forums#.profils; | |
34 | INSERT INTO #x4dat#.forum_profiles | |
7d15f750 FB |
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: |