1 #
Move forums
tables to x4dat
9 #
TO x4dat.forum_profiles
;
10 #
DROP DATABASE forums
;
12 ## Dev
version of previous line
14 CREATE TABLE #x4dat#.forums
16 INSERT INTO #x4dat#.forums
20 CREATE TABLE #x4dat#.forum_subs
22 INSERT INTO #x4dat#.forum_subs
26 CREATE TABLE #x4dat#.forum_innd
28 INSERT INTO #x4dat#.forum_innd
32 CREATE TABLE #x4dat#.forum_profiles
34 INSERT INTO #x4dat#.forum_profiles
39 # Conform
to naming convention.
41 CHANGE
COLUMN nom
name VARCHAR(64) NOT NULL;
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';
47 # vim
:set syntax
=mysql
: