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

Changeset 1387


Ignore:
Timestamp:
Dec 26, 2006, 2:44:43 AM (13 years ago)
Author:
takanashi
Message:

UPGRADE用SQLが新しすぎた

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

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/upgrade/pnebiz-mysql40.sql

    r1385 r1387  
    44  `value` text NOT NULL,
    55  PRIMARY KEY  (`biz_admin_config_id`)
    6 ) TYPE=MyISAM;
     6) TYPE=MyISAM ;
    77INSERT INTO `biz_admin_config` VALUES (1, 'IS_CLOSED_SHISETSU', '0');
    88
     
    1111  `name` text NOT NULL,
    1212  `info` text NOT NULL,
    13   `admin_id` int(11) NOT NULL default '0',
     13  `admin_id` int(11) NOT NULL,
    1414  `image_filename` text NOT NULL,
    1515  PRIMARY KEY  (`biz_group_id`)
    16 ) TYPE=MyISAM;
    17 
     16) TYPE=MyISAM ;
    1817
    1918CREATE TABLE `biz_group_member` (
    2019  `biz_group_member_id` int(11) NOT NULL auto_increment,
    21   `c_member_id` int(11) NOT NULL default '0',
    22   `biz_group_id` int(11) NOT NULL default '0',
     20  `c_member_id` int(11) NOT NULL,
     21  `biz_group_id` int(11) NOT NULL,
    2322  PRIMARY KEY  (`biz_group_member_id`)
    24 ) TYPE=MyISAM;
    25 
     23) TYPE=MyISAM ;
    2624
    2725CREATE TABLE `biz_schedule` (
    2826  `biz_schedule_id` int(11) NOT NULL auto_increment,
    2927  `title` mediumtext NOT NULL,
    30   `c_member_id` int(11) NOT NULL default '0',
    31   `begin_date` date NOT NULL default '0000-00-00',
    32   `finish_date` date NOT NULL default '0000-00-00',
     28  `c_member_id` int(11) NOT NULL,
     29  `begin_date` date NOT NULL,
     30  `finish_date` date NOT NULL,
    3331  `begin_time` time default NULL,
    3432  `finish_time` time default NULL,
    3533  `value` mediumtext NOT NULL,
    36   `rep_type` int(11) NOT NULL default '0',
    37   `rep_first` int(11) NOT NULL default '0',
    38   `is_read` int(11) NOT NULL default '0',
    39   `public_flag` enum('public','group','private') NOT NULL default 'public',
    40   `biz_group_id` int(11) default NULL,
     34  `rep_type` int(11) NOT NULL,
     35  `rep_first` int(11) NOT NULL,
     36  `is_read` int(11) NOT NULL,
    4137  PRIMARY KEY  (`biz_schedule_id`)
    42 ) TYPE=MyISAM;
    43 
     38) TYPE=MyISAM ;
    4439
    4540CREATE TABLE `biz_schedule_member` (
    4641  `biz_schedule_member_id` int(11) NOT NULL auto_increment,
    47   `c_member_id` int(11) NOT NULL default '0',
    48   `biz_schedule_id` int(11) NOT NULL default '0',
    49   `is_read` tinyint(4) NOT NULL default '0',
     42  `c_member_id` int(11) NOT NULL,
     43  `biz_schedule_id` int(11) NOT NULL,
     44  `is_read` tinyint(4) NOT NULL,
    5045  PRIMARY KEY  (`biz_schedule_member_id`)
    51 ) TYPE=MyISAM;
    52 
     46) TYPE=MyISAM ;
    5347
    5448CREATE TABLE `biz_shisetsu` (
     
    5650  `name` text NOT NULL,
    5751  `image_filename` text NOT NULL,
    58   `info` text NOT NULL,
    5952  PRIMARY KEY  (`biz_shisetsu_id`)
    60 ) TYPE=MyISAM;
    61 
     53) TYPE=MyISAM ;
    6254
    6355CREATE TABLE `biz_shisetsu_schedule` (
    6456  `biz_shisetsu_schedule_id` int(11) NOT NULL auto_increment,
    65   `biz_shisetsu_id` int(11) NOT NULL default '0',
    66   `c_member_id` int(11) NOT NULL default '0',
    67   `date` date NOT NULL default '0000-00-00',
    68   `begin_time` time NOT NULL default '00:00:00',
    69   `finish_time` time NOT NULL default '00:00:00',
     57  `biz_shisetsu_id` int(11) NOT NULL,
     58  `c_member_id` int(11) NOT NULL,
     59  `date` date NOT NULL,
     60  `begin_time` time NOT NULL,
     61  `finish_time` time NOT NULL,
    7062  PRIMARY KEY  (`biz_shisetsu_schedule_id`)
    71 ) TYPE=MyISAM;
     63) TYPE=MyISAM ;
    7264
     65CREATE TABLE `biz_state` (
     66  `biz_state_id` int(11) NOT NULL auto_increment,
     67  `member_id` int(11) NOT NULL,
     68  `state` text,
     69  PRIMARY KEY  (`biz_state_id`)
     70) TYPE=MyISAM ;
    7371
    7472CREATE TABLE `biz_todo` (
     
    7876  `is_check` tinyint(1) NOT NULL default '0',
    7977  `writer_id` int(11) NOT NULL default '0',
    80   `sort_order` int(11) NOT NULL default '0',
     78  `sort_order` int(11) NOT NULL,
    8179  `r_datetime` datetime default NULL,
    82   `due_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    83   `finish_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    84   `priority` int(11) NOT NULL default '3',
    85   `public_flag` enum('public','group','private') NOT NULL default 'public',
    86   `biz_group_id` int(11) NOT NULL default '0',
    8780  PRIMARY KEY  (`biz_todo_id`)
    8881) TYPE=MyISAM;
    8982
     83REPLACE INTO `c_siteadmin` VALUES (NULL, 'inc_page_top', '<table width="100%" cellpadding="0" cellspacing="0" border="0" style="margin:0;">\n<tr>\n<td style="padding:3px 9px;" align="right" class="bg_13">\nグループウェア機能はこちら →\n <a href="?m=biz&a=page_s_list">施設予約</a>\n <a href="?m=biz&a=page_fh_biz_schedule_add">予定登録</a>\n <a href="?m=biz&a=page_h_biz_group_find_all">グループ</a></td></tr>\n</table>', NOW());
  • OpenPNE/trunk/setup/sql/upgrade/pnebiz-mysql41.sql

    r1385 r1387  
    44  `value` text NOT NULL,
    55  PRIMARY KEY  (`biz_admin_config_id`)
    6 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    7 
     6) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
     7INSERT INTO `biz_admin_config` VALUES (1, 'IS_CLOSED_SHISETSU', '0');
    88
    99CREATE TABLE `biz_group` (
     
    1111  `name` text NOT NULL,
    1212  `info` text NOT NULL,
    13   `admin_id` int(11) NOT NULL default '0',
     13  `admin_id` int(11) NOT NULL,
    1414  `image_filename` text NOT NULL,
    1515  PRIMARY KEY  (`biz_group_id`)
    16 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    17 
     16) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    1817
    1918CREATE TABLE `biz_group_member` (
    2019  `biz_group_member_id` int(11) NOT NULL auto_increment,
    21   `c_member_id` int(11) NOT NULL default '0',
    22   `biz_group_id` int(11) NOT NULL default '0',
     20  `c_member_id` int(11) NOT NULL,
     21  `biz_group_id` int(11) NOT NULL,
    2322  PRIMARY KEY  (`biz_group_member_id`)
    24 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    25 
     23) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    2624
    2725CREATE TABLE `biz_schedule` (
    2826  `biz_schedule_id` int(11) NOT NULL auto_increment,
    2927  `title` mediumtext NOT NULL,
    30   `c_member_id` int(11) NOT NULL default '0',
    31   `begin_date` date NOT NULL default '0000-00-00',
    32   `finish_date` date NOT NULL default '0000-00-00',
     28  `c_member_id` int(11) NOT NULL,
     29  `begin_date` date NOT NULL,
     30  `finish_date` date NOT NULL,
    3331  `begin_time` time default NULL,
    3432  `finish_time` time default NULL,
    3533  `value` mediumtext NOT NULL,
    36   `rep_type` int(11) NOT NULL default '0',
    37   `rep_first` int(11) NOT NULL default '0',
    38   `is_read` int(11) NOT NULL default '0',
    39   `public_flag` enum('public','group','private') NOT NULL default 'public',
    40   `biz_group_id` int(11) default NULL,
     34  `rep_type` int(11) NOT NULL,
     35  `rep_first` int(11) NOT NULL,
     36  `is_read` int(11) NOT NULL,
    4137  PRIMARY KEY  (`biz_schedule_id`)
    42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    43 
     38) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    4439
    4540CREATE TABLE `biz_schedule_member` (
    4641  `biz_schedule_member_id` int(11) NOT NULL auto_increment,
    47   `c_member_id` int(11) NOT NULL default '0',
    48   `biz_schedule_id` int(11) NOT NULL default '0',
    49   `is_read` tinyint(4) NOT NULL default '0',
     42  `c_member_id` int(11) NOT NULL,
     43  `biz_schedule_id` int(11) NOT NULL,
     44  `is_read` tinyint(4) NOT NULL,
    5045  PRIMARY KEY  (`biz_schedule_member_id`)
    51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    52 
     46) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    5347
    5448CREATE TABLE `biz_shisetsu` (
     
    5650  `name` text NOT NULL,
    5751  `image_filename` text NOT NULL,
    58   `info` text NOT NULL,
    5952  PRIMARY KEY  (`biz_shisetsu_id`)
    60 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    61 
     53) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    6254
    6355CREATE TABLE `biz_shisetsu_schedule` (
    6456  `biz_shisetsu_schedule_id` int(11) NOT NULL auto_increment,
    65   `biz_shisetsu_id` int(11) NOT NULL default '0',
    66   `c_member_id` int(11) NOT NULL default '0',
    67   `date` date NOT NULL default '0000-00-00',
    68   `begin_time` time NOT NULL default '00:00:00',
    69   `finish_time` time NOT NULL default '00:00:00',
     57  `biz_shisetsu_id` int(11) NOT NULL,
     58  `c_member_id` int(11) NOT NULL,
     59  `date` date NOT NULL,
     60  `begin_time` time NOT NULL,
     61  `finish_time` time NOT NULL,
    7062  PRIMARY KEY  (`biz_shisetsu_schedule_id`)
    71 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     63) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    7264
     65CREATE TABLE `biz_state` (
     66  `biz_state_id` int(11) NOT NULL auto_increment,
     67  `member_id` int(11) NOT NULL,
     68  `state` text,
     69  PRIMARY KEY  (`biz_state_id`)
     70) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
    7371
    7472CREATE TABLE `biz_todo` (
     
    7876  `is_check` tinyint(1) NOT NULL default '0',
    7977  `writer_id` int(11) NOT NULL default '0',
    80   `sort_order` int(11) NOT NULL default '0',
     78  `sort_order` int(11) NOT NULL,
    8179  `r_datetime` datetime default NULL,
    82   `due_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    83   `finish_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    84   `priority` int(11) NOT NULL default '3',
    85   `public_flag` enum('public','group','private') NOT NULL default 'public',
    86   `biz_group_id` int(11) NOT NULL default '0',
    8780  PRIMARY KEY  (`biz_todo_id`)
    8881) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    8982
     83REPLACE INTO `c_siteadmin` VALUES (NULL, 'inc_page_top', '<table width="100%" cellpadding="0" cellspacing="0" border="0" style="margin:0;">\n<tr>\n<td style="padding:3px 9px;" align="right" class="bg_13">\nグループウェア機能はこちら →\n <a href="?m=biz&a=page_s_list">施設予約</a>\n <a href="?m=biz&a=page_fh_biz_schedule_add">予定登録</a>\n <a href="?m=biz&a=page_h_biz_group_find_all">グループ</a></td></tr>\n</table>', NOW());
Note: See TracChangeset for help on using the changeset viewer.