|
SQL query:
-- __^__ __^__
- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | |
-- | / | Fireboard 1.0.1 to 1.0.3 Stable | |
-- |___| Rename jos_ to your db prefix |___|
- - ( _____ ) ----------------------------------------- - ( _____ ) --
/* Alter table in Second database */ ALTER TABLE `jos_fb_categories` ADD COLUMN `headerdesc` text NOT NULL AFTER `description` ,
ADD COLUMN `class_sfx` varchar( 20 ) NOT NULL AFTER `headerdesc` ,
ADD COLUMN `id_last_msg` int( 10 ) NOT NULL DEFAULT '0' AFTER `class_sfx` ,
ADD COLUMN `numTopics` mediumint( 8 ) NOT NULL DEFAULT '0' AFTER `id_last_msg` ,
ADD COLUMN `numPosts` mediumint( 8 ) NOT NULL DEFAULT '0' AFTER `numTopics` ,
ADD COLUMN `time_last_msg` int( 11 ) NULL AFTER `numPosts` ,
ADD KEY `msg_id` ( `id_last_msg` ) ,
COMMENT = ''
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--( ___ )------------------------------------------( ___ )
-- | / | ' at line 2
|