db upgrade with sql problem.....

hanpedro

I have a db and running site.
I found some good program, and tried to install it.

But the program's sql file is problem.

This sql try to make and manage tables, phpmyadmin can't work for it.

Some of the sql is as follows.

Any comment would be highly appreciated.

ALTER TABLE `$g4[board_table]` ADD `bo_source` TINYINT( 4 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_notice_comment_allow` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_comment_notice` TEXT NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_related` TINYINT( 4 ) NOT NULL ;

DROP TABLE IF EXISTS `$g4[mb_nick_table]`;
CREATE TABLE `$g4[mb_nick_table]` (
  `nick_no` int(11) NOT NULL auto_increment,
  `mb_id` varchar(20) NOT NULL,
  `mb_nick` varchar(255) NOT NULL,
  `start_datetime` datetime NOT NULL,
  `end_datetime` datetime NOT NULL,
  PRIMARY KEY  (`nick_no`)
);

ALTER TABLE `$g4[popular_table]` ADD `bo_table` VARCHAR( 20 ) NOT NULL ,
ADD `mb_id` VARCHAR( 255 ) NOT NULL,
ADD `sfl` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `$g4[popular_table]` ADD INDEX `idx1` ( `bo_table` , `mb_id` ) ;

ALTER TABLE `$g4[popular_table]` DROP INDEX `index1` ,
ADD UNIQUE `index1` ( `pp_date` , `pp_word` , `pp_ip` , `bo_table` , `mb_id` ) ;

ALTER TABLE `$g4[member_table]` ADD `mb_realmemo` TINYINT( 4 ) NOT NULL ,
ADD `mb_realmemo_sound` TINYINT( 4 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_comment_read_level` TINYINT( 4 ) NOT NULL AFTER `bo_comment_level` ;

DROP TABLE IF EXISTS `$g4[singo_table]`;
CREATE TABLE `$g4[singo_table]` ( 
  `sg_id` int(11) NOT NULL auto_increment, 
  `mb_id` varchar(20) NOT NULL default '', 
  `bo_table` varchar(20) NOT NULL default '', 
  `wr_id` int(11) NOT NULL default '0', 
  `wr_parent` int(11) NOT NULL default '0', 
  `sg_mb_id` varchar(20) NOT NULL default '', 
  `sg_reason` varchar(255) NOT NULL default '', 
  `sg_datetime` datetime NOT NULL default '0000-00-00 00:00:00', 
  `sg_ip` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`sg_id`), 
  KEY `fk1` (`bo_table`,`wr_id`), 
  KEY `fk2` (`bo_table`,`wr_parent`) 
); 

ALTER TABLE `$g4[board_table]` ADD `bo_singo` TINYINT NOT NULL;

ALTER TABLE `$g4[config_table]` ADD `cf_singo_intercept_count` INT( 11 ) NOT NULL ,
                        ADD `cf_singo_point` INT( 11 ) NOT NULL ,
                        ADD `cf_singo_today_count` INT( 11 ) NOT NULL ;


DROP TABLE IF EXISTS `$g4[my_board_table]`;
CREATE TABLE `$g4[my_board_table]` (
  `my_id` int(11) NOT NULL auto_increment,
  `mb_id` varchar(20) NOT NULL,
  `bo_table` varchar(20) NOT NULL,
  `my_datetime` datetime NOT NULL,
  PRIMARY KEY  (`my_id`),
  KEY `mb_id` (`mb_id`,`my_datetime`)
) ;

djjjozsi

lets read the "readme_first".txt..

in rge sql creates, you can see variables, beggining with $ sign.

somewhere there is a configuration file, where you must add the table names.

$g4[board_table]="xxxxx";

if i'm not mistaken, its enought if you add value in the top of the php program.

$g4["board_table"]="my_table";

hanpedro;10892398 wrote:

I have a db and running site.
I found some good program, and tried to install it.

But the program's sql file is problem.

This sql try to make and manage tables, phpmyadmin can't work for it.

Some of the sql is as follows.

Any comment would be highly appreciated.

ALTER TABLE `$g4[board_table]` ADD `bo_source` TINYINT( 4 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_notice_comment_allow` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_comment_notice` TEXT NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_related` TINYINT( 4 ) NOT NULL ;

DROP TABLE IF EXISTS `$g4[mb_nick_table]`;
CREATE TABLE `$g4[mb_nick_table]` (
  `nick_no` int(11) NOT NULL auto_increment,
  `mb_id` varchar(20) NOT NULL,
  `mb_nick` varchar(255) NOT NULL,
  `start_datetime` datetime NOT NULL,
  `end_datetime` datetime NOT NULL,
  PRIMARY KEY  (`nick_no`)
);

ALTER TABLE `$g4[popular_table]` ADD `bo_table` VARCHAR( 20 ) NOT NULL ,
ADD `mb_id` VARCHAR( 255 ) NOT NULL,
ADD `sfl` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `$g4[popular_table]` ADD INDEX `idx1` ( `bo_table` , `mb_id` ) ;

ALTER TABLE `$g4[popular_table]` DROP INDEX `index1` ,
ADD UNIQUE `index1` ( `pp_date` , `pp_word` , `pp_ip` , `bo_table` , `mb_id` ) ;

ALTER TABLE `$g4[member_table]` ADD `mb_realmemo` TINYINT( 4 ) NOT NULL ,
ADD `mb_realmemo_sound` TINYINT( 4 ) NOT NULL ;

ALTER TABLE `$g4[board_table]` ADD `bo_comment_read_level` TINYINT( 4 ) NOT NULL AFTER `bo_comment_level` ;

DROP TABLE IF EXISTS `$g4[singo_table]`;
CREATE TABLE `$g4[singo_table]` ( 
  `sg_id` int(11) NOT NULL auto_increment, 
  `mb_id` varchar(20) NOT NULL default '', 
  `bo_table` varchar(20) NOT NULL default '', 
  `wr_id` int(11) NOT NULL default '0', 
  `wr_parent` int(11) NOT NULL default '0', 
  `sg_mb_id` varchar(20) NOT NULL default '', 
  `sg_reason` varchar(255) NOT NULL default '', 
  `sg_datetime` datetime NOT NULL default '0000-00-00 00:00:00', 
  `sg_ip` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`sg_id`), 
  KEY `fk1` (`bo_table`,`wr_id`), 
  KEY `fk2` (`bo_table`,`wr_parent`) 
); 

ALTER TABLE `$g4[board_table]` ADD `bo_singo` TINYINT NOT NULL;

ALTER TABLE `$g4[config_table]` ADD `cf_singo_intercept_count` INT( 11 ) NOT NULL ,
                        ADD `cf_singo_point` INT( 11 ) NOT NULL ,
                        ADD `cf_singo_today_count` INT( 11 ) NOT NULL ;


DROP TABLE IF EXISTS `$g4[my_board_table]`;
CREATE TABLE `$g4[my_board_table]` (
  `my_id` int(11) NOT NULL auto_increment,
  `mb_id` varchar(20) NOT NULL,
  `bo_table` varchar(20) NOT NULL,
  `my_datetime` datetime NOT NULL,
  PRIMARY KEY  (`my_id`),
  KEY `mb_id` (`mb_id`,`my_datetime`)
) ;

hanpedro

djjjozsi ,

Thanks for your kind comment.

I should study php more.....