1 | /*!40101 SET NAMES utf8 */; |
---|
2 | |
---|
3 | -- update01 |
---|
4 | ALTER TABLE c_message ADD INDEX c_member_id_to_is_read_is_send(c_member_id_to, is_read, is_send); |
---|
5 | ALTER TABLE c_commu_topic ADD INDEX r_datetime_c_commu_id(r_datetime, c_commu_id); |
---|
6 | |
---|
7 | -- update02 |
---|
8 | |
---|
9 | INSERT INTO `c_review_category` (category,category_disp,sort_order) VALUES ('hpc-jp','ヘルス&ビューティー',12); |
---|
10 | |
---|
11 | -- update03 |
---|
12 | |
---|
13 | ALTER TABLE `c_commu` ADD COLUMN `is_adult` tinyint(1) NOT NULL DEFAULT '0'; |
---|
14 | |
---|
15 | -- update04 |
---|
16 | |
---|
17 | ALTER TABLE `c_commu_topic` ADD COLUMN `capacity` int(11) NOT NULL DEFAULT '0' after `event_flag`; |
---|
18 | |
---|
19 | -- update05 |
---|
20 | |
---|
21 | ALTER TABLE `c_free_page` ADD COLUMN `title` text NOT NULL DEFAULT '' after `c_free_page_id`; |
---|
22 | ALTER TABLE `c_free_page` ADD COLUMN `type` enum('pc','ktai') NOT NULL default 'pc' after `body`; |
---|
23 | ALTER TABLE `c_free_page` ADD COLUMN `auth` tinyint(1) NOT NULL DEFAULT 1 after `type`; |
---|
24 | ALTER TABLE `c_free_page` CHANGE COLUMN `body` `body` MEDIUMTEXT NOT NULL DEFAULT ''; |
---|
25 | |
---|
26 | -- update06 |
---|
27 | |
---|
28 | ALTER TABLE c_commu_topic_comment ADD INDEX r_datetime_c_commu_id(r_datetime, c_commu_id); |
---|
29 | |
---|
30 | -- update07 |
---|
31 | |
---|
32 | CREATE TABLE `c_black_list` ( |
---|
33 | `c_black_list_id` int(11) NOT NULL auto_increment, |
---|
34 | `address` blob NOT NULL, |
---|
35 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
36 | `memo` text NOT NULL, |
---|
37 | PRIMARY KEY (`c_black_list_id`), |
---|
38 | UNIQUE KEY `address` (`address`(100)) |
---|
39 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
40 | |
---|
41 | -- update08 |
---|
42 | |
---|
43 | ALTER TABLE `c_commu_topic_comment` ADD COLUMN `filename` varchar(200) NOT NULL DEFAULT '' after `image_filename3`; |
---|
44 | |
---|
45 | CREATE TABLE `c_file` ( |
---|
46 | `c_file_id` int(11) NOT NULL auto_increment, |
---|
47 | `filename` text NOT NULL, |
---|
48 | `bin` longblob NOT NULL, |
---|
49 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
50 | `type` text, |
---|
51 | PRIMARY KEY (`c_file_id`), |
---|
52 | KEY `filename` (`filename`(100)) |
---|
53 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
54 | |
---|
55 | -- update09 |
---|
56 | |
---|
57 | INSERT INTO c_cmd VALUES (NULL,'r.tabelog.com',127); |
---|
58 | INSERT INTO c_cmd VALUES (NULL,'maps.google.com',127); |
---|
59 | INSERT INTO c_cmd VALUES (NULL,'maps.google.co.jp',127); |
---|
60 | INSERT INTO c_cmd VALUES (NULL,'www.google.com',127); |
---|
61 | INSERT INTO c_cmd VALUES (NULL,'www.google.co.jp',127); |
---|
62 | |
---|
63 | -- update10 |
---|
64 | |
---|
65 | ALTER TABLE c_file DROP COLUMN type; |
---|
66 | ALTER TABLE c_file ADD (original_filename text); |
---|
67 | |
---|
68 | -- update11 |
---|
69 | |
---|
70 | INSERT INTO c_cmd VALUES (NULL,'blog-apart.com',127); |
---|
71 | INSERT INTO c_cmd VALUES (NULL,'livlyisland',127); |
---|
72 | INSERT INTO c_cmd VALUES (NULL,'tagfriends',127); |
---|
73 | INSERT INTO c_cmd VALUES (NULL,'www.blog-apart.com',127); |
---|
74 | INSERT INTO c_cmd VALUES (NULL,'slurl.com',127); |
---|
75 | INSERT INTO c_cmd VALUES (NULL,'www.netprice.co.jp',127); |
---|
76 | |
---|
77 | -- update12 |
---|
78 | |
---|
79 | DROP TABLE `c_black_list`; |
---|
80 | |
---|
81 | -- update13 |
---|
82 | |
---|
83 | ALTER TABLE `c_commu` DROP COLUMN `is_adult`; |
---|
84 | |
---|
85 | -- update14 |
---|
86 | |
---|
87 | CREATE TABLE `c_tmp_file` ( |
---|
88 | `c_tmp_file_id` int(11) NOT NULL auto_increment, |
---|
89 | `filename` text NOT NULL, |
---|
90 | `bin` longblob NOT NULL, |
---|
91 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
92 | `original_filename` text, |
---|
93 | PRIMARY KEY (`c_tmp_file_id`), |
---|
94 | KEY `filename` (`filename`(100)) |
---|
95 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
96 | |
---|
97 | -- update15 |
---|
98 | |
---|
99 | UPDATE `c_action` SET name = '入会する' WHERE c_action_id = 1; |
---|
100 | UPDATE `c_action` SET name = '自分の日記にコメントされる' WHERE c_action_id = 2; |
---|
101 | UPDATE `c_action` SET name = '他人の日記にコメントする' WHERE c_action_id = 3; |
---|
102 | UPDATE `c_action` SET name = '日記を書く' WHERE c_action_id = 4; |
---|
103 | UPDATE `c_action` SET name = 'マイフレンドの紹介文を書く' WHERE c_action_id = 5; |
---|
104 | UPDATE `c_action` SET name = 'レビューを書く' WHERE c_action_id = 6; |
---|
105 | UPDATE `c_action` SET name = '友人を招待する' WHERE c_action_id = 7; |
---|
106 | UPDATE `c_action` SET name = 'マイフレンドにメンバーを紹介する' WHERE c_action_id = 8; |
---|
107 | INSERT INTO `c_action` VALUES (9,'コミュニティにトピックを作成する',0); |
---|
108 | INSERT INTO `c_action` VALUES (10,'コミュニティにイベントを作成する',0); |
---|
109 | INSERT INTO `c_action` VALUES (11,'コミュニティのトピック・イベントにコメントする',0); |
---|
110 | |
---|
111 | -- update16 |
---|
112 | |
---|
113 | DELETE FROM biz_schedule_member |
---|
114 | USING biz_schedule_member, biz_schedule |
---|
115 | WHERE biz_schedule.biz_group_id > 0 |
---|
116 | AND biz_schedule.biz_schedule_id = biz_schedule_member.biz_schedule_id; |
---|
117 | |
---|
118 | INSERT INTO biz_schedule_member(c_member_id, biz_schedule_id) |
---|
119 | SELECT biz_group_member.c_member_id, biz_schedule.biz_schedule_id |
---|
120 | FROM biz_schedule, biz_group_member |
---|
121 | WHERE biz_schedule.biz_group_id > 0 |
---|
122 | AND biz_schedule.biz_group_id = biz_group_member.biz_group_id; |
---|
123 | |
---|
124 | UPDATE biz_schedule SET public_flag = 'private' |
---|
125 | WHERE public_flag = 'group'; |
---|