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

Changeset 6823


Ignore:
Timestamp:
Apr 29, 2008, 4:49:58 AM (11 years ago)
Author:
ebihara
Message:

#2303:CREATE TABLE の直前に DROP TABLE を発行するようにした(MySQL)

Location:
OpenPNE/trunk/setup/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/mysql40/upgrade/upgrade-2.10to2.12.sql

    r6816 r6823  
    4040
    4141-- update06
     42DROP TABLE IF EXISTS `c_module`;
    4243CREATE TABLE `c_module` (
    4344  `c_module_id` int(11) NOT NULL auto_increment,
     
    131132
    132133-- update08
     134DROP TABLE IF EXISTS `c_config_decoration`;
    133135CREATE TABLE `c_config_decoration` (
    134136  `c_config_decoration_id` int(11) NOT NULL auto_increment,
     
    151153
    152154-- update09, update16, update17
     155DROP TABLE IF EXISTS `c_member_config`;
    153156CREATE TABLE `c_member_config` (
    154157  `c_member_config_id` int(11) NOT NULL auto_increment,
     
    164167
    165168-- update11
     169DROP TABLE IF EXISTS `c_album`;
    166170CREATE TABLE `c_album` (
    167171  `c_album_id` int(11) NOT NULL auto_increment,
     
    177181) ENGINE=MyISAM;
    178182
     183DROP TABLE IF EXISTS `c_album_image`;
    179184CREATE TABLE `c_album_image` (
    180185  `c_album_image_id` int(11) NOT NULL auto_increment,
     
    218223DROP TABLE tmp_c_commu_topic;
    219224
     225DROP TABLE IF EXISTS `c_diary_comment_log`;
    220226CREATE TABLE `c_diary_comment_log` (
    221227  `c_diary_comment_log_id` int(11) NOT NULL auto_increment,
     
    257263
    258264-- update15
     265DROP TABLE IF EXISTS `c_cmd_caster`;
    259266CREATE TABLE `c_cmd_caster` (
    260267  `c_cmd_caster_id` int(11) NOT NULL auto_increment,
  • OpenPNE/trunk/setup/sql/mysql41/upgrade/upgrade-2.10to2.12.sql

    r6816 r6823  
    4242
    4343-- update06
     44DROP TABLE IF EXISTS `c_module`;
    4445CREATE TABLE `c_module` (
    4546  `c_module_id` int(11) NOT NULL auto_increment,
     
    133134
    134135-- update08
     136DROP TABLE IF EXISTS `c_config_decoration`;
    135137CREATE TABLE `c_config_decoration` (
    136138  `c_config_decoration_id` int(11) NOT NULL auto_increment,
     
    153155
    154156-- update09, update16, update17
     157DROP TABLE IF EXISTS `c_member_config`;
    155158CREATE TABLE `c_member_config` (
    156159  `c_member_config_id` int(11) NOT NULL auto_increment,
     
    167170-- update11
    168171DROP TABLE IF EXISTS `c_album`;
    169 CREATE TABLE IF NOT EXISTS `c_album` (
     172CREATE TABLE `c_album` (
    170173  `c_album_id` int(11) NOT NULL auto_increment,
    171174  `c_member_id` int(11) NOT NULL default '0',
     
    181184
    182185DROP TABLE IF EXISTS `c_album_image`;
    183 CREATE TABLE IF NOT EXISTS `c_album_image` (
     186CREATE TABLE `c_album_image` (
    184187  `c_album_image_id` int(11) NOT NULL auto_increment,
    185188  `c_album_id` int(11) NOT NULL default '0',
     
    222225DROP TABLE tmp_c_commu_topic;
    223226
     227DROP TABLE IF EXISTS `c_diary_comment_log`;
    224228CREATE TABLE `c_diary_comment_log` (
    225229  `c_diary_comment_log_id` int(11) NOT NULL auto_increment,
     
    261265
    262266-- update15
     267DROP TABLE IF EXISTS `c_cmd_caster`;
    263268CREATE TABLE `c_cmd_caster` (
    264269  `c_cmd_caster_id` int(11) NOT NULL auto_increment,
Note: See TracChangeset for help on using the changeset viewer.