ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 5862


Ignore:
Timestamp:
Mar 18, 2008, 9:31:39 PM (15 years ago)
Author:
ebihara
Message:

#2019:MySQL4.0用SQLを追加

File:
1 copied

Legend:

Unmodified
Added
Removed

  • OpenPNE/trunk/setup/sql/mysql40/option/install-portal.sql

    r5860 r5862  
    88  PRIMARY KEY  (`portal_config_id`),
    99  UNIQUE KEY `name` (`name`)
    10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     10) ENGINE=MyISAM;
    1111
    1212DROP TABLE IF EXISTS `portal_layout`;
    … …  
    1919  UNIQUE KEY `content_name` (`content_name`),
    2020  UNIQUE KEY `position` (`position`)
    21 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     21) ENGINE=MyISAM;
    2222
    2323DROP TABLE IF EXISTS `portal_free_area`;
    … …  
    2727  `name` varchar(64) NOT NULL,
    2828  PRIMARY KEY  (`portal_free_area_id`)
    29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     29) ENGINE=MyISAM;
    3030
    3131DROP TABLE IF EXISTS `portal_rss`;
    … …  
    3535  `name` varchar(64) NOT NULL,
    3636  PRIMARY KEY  (`portal_rss_id`)
    37 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     37) ENGINE=MyISAM;
    3838
    3939DROP TABLE IF EXISTS `portal_link`;
    … …  
    4646  `is_enabled` tinyint(4) default NULL default '0',
    4747  PRIMARY KEY  (`portal_link_id`)
    48 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     48) ENGINE=MyISAM;
    4949
    5050DROP TABLE IF EXISTS `portal_image`;
    … …  
    5353  `image_filename` text NOT NULL,
    5454  PRIMARY KEY  (`portal_image_id`)
    55 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     55) ENGINE=MyISAM;
    5656
    5757DROP TABLE IF EXISTS `portal_layout_ktai`;
    … …  
    6363  UNIQUE KEY `content_name` (`content_name`),
    6464  UNIQUE KEY `postion` (`position`)
    65 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     65) ENGINE=MyISAM;
    6666
    6767DROP TABLE IF EXISTS `portal_free_area_ktai`;
    … …  
    7171  `html` text NOT NULL,
    7272  PRIMARY KEY  (`portal_free_area_ktai_id`)
    73 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     73) ENGINE=MyISAM;
    7474
    7575INSERT IGNORE INTO `portal_config` VALUES
Note: See TracChangeset for help on using the changeset viewer.