-- update01

ALTER TABLE c_diary ADD INDEX c_member_id_r_datetime_public_flag(c_member_id, r_datetime, public_flag);
ALTER TABLE c_commu ADD INDEX c_commu_category_id_r_datetime(c_commu_category_id, r_datetime);

-- update02
ALTER TABLE `biz_shisetsu` ADD `info` TEXT NOT NULL;

-- update03
ALTER TABLE c_profile ADD COLUMN info text NOT NULL after caption;
ALTER TABLE c_profile MODIFY form_type enum('text','textlong','textarea','select','checkbox','radio') NOT NULL default 'text';

-- update04
CREATE TABLE c_free_page (
  c_free_page_id bigint(20) NOT NULL auto_increment,
  body text NOT NULL,
  PRIMARY KEY  (c_free_page_id)
) TYPE=MyISAM;


-- update05
CREATE TABLE `c_diary_category` (
  `c_diary_category_id` int(11) NOT NULL auto_increment,
  `category_name` text collate utf8_unicode_ci NOT NULL,
  `c_member_id` int(11) NOT NULL,
  `r_datetime` datetime NOT NULL,
  PRIMARY KEY  (`c_diary_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `c_diary_category_diary` (
  `c_diary_category_diary_id` int(11) NOT NULL auto_increment,
  `c_diary_category_id` int(11) NOT NULL,
  `c_diary_id` int(11) NOT NULL,
  PRIMARY KEY  (`c_diary_category_diary_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- update06
CREATE TABLE `c_api` (
  `c_api_id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `ip` text,
  PRIMARY KEY  (`c_api_id`),
  KEY `name` (`name`(100))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- update07
INSERT INTO c_api VALUES (1,'000_auth','');
INSERT INTO c_api VALUES (2,'001_get_c_member','');
INSERT INTO c_api VALUES (3,'002_get_member_point','');
INSERT INTO c_api VALUES (4,'101_add_point','');
INSERT INTO c_api VALUES (5,'smtp2pne','');

-- update08
CREATE TABLE `c_cmd` (
  `c_cmd_id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `permit` int NOT NULL DEFAULT 0,
  PRIMARY KEY  (`c_cmd_id`),
  KEY `name` (`name`(100)),
  UNIQUE KEY (`name`(100))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- update09
INSERT INTO c_cmd VALUES (1,'youtube',7);
INSERT INTO c_cmd VALUES (2,'www.youtube.com',7);
INSERT INTO c_cmd VALUES (3,'watchme',7);
INSERT INTO c_cmd VALUES (4,'www.watchme.tv',7);
INSERT INTO c_cmd VALUES (5,'www.grouper.com',7);
INSERT INTO c_cmd VALUES (6,'www.flipclip.net',7);
INSERT INTO c_cmd VALUES (7,'www.ebitv.jp',7);
INSERT INTO c_cmd VALUES (8,'video.google.com',7);
INSERT INTO c_cmd VALUES (9,'kakaku.com',7);
INSERT INTO c_cmd VALUES (10,'grouper.com',7);
INSERT INTO c_cmd VALUES (11,'flipclip.net',7);
INSERT INTO c_cmd VALUES (12,'youtube.com',7);

-- update10
ALTER TABLE `biz_schedule` ADD `public_flag` ENUM( 'public', 'group', 'private' ) NOT NULL DEFAULT 'public',
ADD `biz_group_id` INT NULL ;


-- update12
ALTER TABLE `biz_todo` ADD `due_datetime` DATETIME NOT NULL ,
ADD `finish_datetime` DATETIME NOT NULL ,
ADD `priority` INT NOT NULL DEFAULT '3',
ADD `public_flag` ENUM( 'public', 'group', 'private' ) NOT NULL DEFAULT 'public',
ADD `biz_group_id` INT NOT NULL ;

-- update13
CREATE TABLE `c_holiday` (
  `c_holiday_id` int(11) NOT NULL auto_increment,
  `name` text collate utf8_unicode_ci NOT NULL,
  `month` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  PRIMARY KEY  (`c_holiday_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

alter table c_sns_config ADD COLUMN bg_14 text NOT NULL after bg_13;
UPDATE c_sns_config SET bg_14 = 'FFFFFF';

-- update14
ALTER TABLE `c_member` ADD `schedule_start_day` INT NOT NULL DEFAULT '0';

-- update15
INSERT INTO `c_image` VALUES ('','skin_no_image_master.gif','[encoded data, 9920 characters]',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_no_logo_master.gif','[encoded data, 9576 characters]',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_no_logo_small_master.gif','R0lGODlhUABQAPcAANja36+xts7Q1oWIjs7P1cbIzYeKkKCjqNLU2YqNk8XHzL/AxsDBx56hpn6Bh5ibodHS2MvM0sfJzpyfpLq7wJKVm7Cyt4qOk9TW3Hd7gdPV29LT2cnL0ImMkvv7/Le5xubn7vDx9eHi6/f4+vr6/N3f6Pn6+/P099/h6t7g6fHy9vv8/eLk7ODi6t3f6fn5++Xm7efo7/r7/PLy9vj4+uHj6/T09+bo7/Lz9vX2+ePk7N7f6ePl7Pj5+t/g6eDh6t7g6uTm7e/w9fX1+PX2+Pb2+fT1+O/w9OPl7fb3+eXn7vf3+u7v9O3u8+bo7uvs8efp7+Lj6Ozt8uTl7OPk6eHi6Nzd493e5Orr8dvc4ujp7unq8Orr8Onq7+bn7dna4OXn7eDh5+Pk6uDh5t/g5trb4XF1e+Tl6efo7ebn7Ofo7t/g5eHi5+jp7+Xm7OPk693e49bX3H+CiOjp8IyPlebn67u9wt7f5Ovs8tfY3ayvtOLj6dnZ3+Dh6NjZ3uTm7Nvc4d7f5eXm6ouOlI6Rl4aJj5qdo7q8wcbHzdnZ3uTl6trb4KqtssrM0Y2QlsTGy6SnrNzd4n+DiaWnrcPFyrGzuePl6+Tl672/xLa4vqaprqyus8zN07i6wLe5vra4xcHDydjZ3bu9w5CTmcLEyeTk6tXW2+Xm642RlsHDyLa4xISHjairsZeaoLi6v7S2u83O1Kuus8zN0snKz+Pl6qOlq9bX26WoraWorqGkqtTV2qepr9fY3Lq8wtDR1qqssqutsn6CiIyQlsDCyLy+w6uts8XGy6apr46Sl42Rl8PEyszM0r7Axbm7wKirsKmrsdLT16Olqq6wvK+xvbW3vMPFy4+SmK2vtbGyv5uepIuPlbu9wYyQlYaKj5+ip6Omq6GkqaKkqa+yuKeqr5SXnbS2w5aZntHS1oCDibGzwLO1wqSmrKaorqeprtbY3JmcoZmcosLEyq2wteLk6auutLm7wby+xLy/xL2+xJ+iqKmrsKyutM/Q1qSmq4uPlKKkqiH5BAAAAAAALAAAAABQAFAAQAj/AD8IHEiwoMGDCBMqXMhwIImHECNKnEixosWLGDMKHMGxo8ePIEOKHEmypEmBRlKqXMmypcuXMGPKnCkwhM2bOHPq3Mmzp8+fQD+kWzOg0Zk6VNjcsYNBzoajVNbAOfQAmpkC5rqkgaOvXQcK4fqRg6CFSiIHFAYBIqSlSRMtZ+DQSTSJQSNkY+qMGZdKGSOkawA5opLmzJg7mAhR8SPHlJZPH0BM2dOnTxUxU0DAeEPZMmYYU95MCb0H8xQxqEW/EbNHdOjQYqpUriIaNAwQc+ZIRo0ZRIwYtmPknhND8u3hAoMoX868ufPn0KNLn05doIjr2LNr3869u/fv4MML/9xBvrz58+jTq1/Pvr17gR7iy59Pv779+/jz698v8IX//wAGKOCABBZo4IEIClTEggw26OCDEEYo4YQUVigQDhhmqOGGHHbo4YcghiiiQEww0YQUKDZRYoknpriiWyuy6NaMMZpIY40zqhhjjlI84eOPT0ih445MfDANH8dko8YWXihyRTCN5FNJG1uoUUUWo1BjlR9+DBLBAH4gkAAF60ySByatVFJMHnYkEIcccWzRBhVXVPLAF6wgQkUYXzRyQQMLgMKIGm5UYYUjbmChqBthlHEMImooKhAIlFZq6aWYZqrpppx26qlALIQq6qiklmrqqaimquqqAqHg6quwxv8q66y01mrrrbgK5MKuvPbq66/ABivssMQWK9AKyCar7LLMNuvss9BGKy18+1Vr7bXY2ieQCdx26+234IYr7rjklmuuQD2kq+667Lbr7rvwxivvvAItYe+9+Oar77789uvvvwALRMTABBds8MEIJ6zwwgw3LNAJEEcs8cQUV2zxxRhnrLFAKnTs8ccghyzyyCSXbPLJAgmh8sost+zyyzDHLPPMNH/wSRd1dNKNJ4h0YgApaAjyjSM8V2LAIYaZYcA8TTyRRhSOyEGJM5LogWIXZzwiBypnWPOEW09oIQghbPxigCg9ahWLBAUwossjyqRSyCOIFGCKAZz0qEUdmzT/oIo0fJihCBZ4YNHGlcYIcwoehSsSiC4ZEGBGHNeIQ4Yxo/jSQTP/1PKFHGFgmUozg/CRjBeMe7HHF4N8sQsoVlxhSCZZ4MJAPMW0ofoVpxfuRRVl5DHALlRE+oE6ZGRRxiuG0HHAMFYonwU1zeczTBllfAGPFV8QUIEEV/ABSSP1iFJGHBbkc4UVnODCRxn85CIMHftgcMUVmRCghhd8xgGJArPohBfcEIUr1MINW0igF6hAhvxRaQsC+Y0EJ0jBClrwghjMoAY3GAOBKOGDIAyhCEdIwhKa8IQoTKFAeMDCFrrwhTCMoQxnSMMa2lAgNcihDnfIwx768IdADKIQ/4cokB8Y8YhITKISl8jEJjrxiVAUSAqmSMUqWvGKWMyiFrfIxS4KpARgDKMYx0jGMprxjGhMoxoF0oI2uvGNcIyjHOdIxzra8Y7UypYe98jH+BxLWoAMpCAH2aw89vGQiMSPQGTAyEY68pGQjKQkJ0nJSlpSIBnJpCY3ycmKbMtcoAylKEcZrv4g6JSoTKUqByQQGrjylbCMpSxnScta2vKWuNyISXbJy176MiQCSYIwh0nMYhrzmMhMpjKXyUyB5OCZ0IymNKdJzWpa85rYzKZAhsDNbnrzm+AMpzjHSc5ymlMgNkinOtfJzna6853wjKc85/kwjdnznvjMZ8UEMv+DfvrznwANqEAHStCCGvSgHDuZQhfK0IaKrCZAiahEJ0rRnQjkCBjNqEY3ytGOevSjIA2pSAXStC6MwQ56IAYtTsQFLQAApdWghRRaSgkFqKikX3iFFtggj0uwqKWiQAAXmKEjlhJDCwi4hxRM1CNOLGIRjeCAHjYRi03oQQ/XQIBNS9SjoX6iHGfARCEWMYY1rCERklhEAAwxBjas4Q5fKMQsQmGGXNjhCV1ggyxWMQhMQMIbkuDCE+oAh3dMgA5rQEYX3IKzMXBjEZqwAyGEioYoPIMSj/hFFMYQCQDQYQxJWQMn0MEGuCigG2hQxTQAYYYooKELQVtDJJYhByr/aAG2UYDDORwACzPwQhLuoAIAHDCLDrgCHNF4xQQEsYYATMAVF1gEIdCAIjRQARD+SMQthhEJT0wgCnfQBANIAQw0PA0OqEgDF6x7h0gcQBN0sIcguvABaSRCDrYQbEvZwIBlZOAUPuLCGe6wjQT4wrcEGAAgGmABaCTgENGARCLecQgEOMAWh7hAKLqRBh+dQq+DWIQzHnEYQNBBAbdgBnm1cN70+qgLgoBDKCZBCfU+4QPYUJ4hJhCHKGxAG/TwgwYKwYgrRAECFWhFHuJghi/4QRqreMD5EmCHSbCDD6ZwwABg8QV8DCIPvSiEABRBhl4EAxZZeIYEmmSFPFAj/wOBGlShDpUoRamhgKyQQBskpYpShOEKWciCFQJRBSpE4c9WSDShq1AFMkSh0Vm4QhiiEIhETzoM0XN0o8NAhkoH+gpkqEIUokAFN7ShDZfA9KCrcIn9laIKpfBCAqt0CVKbOoECgYITwPAHS/wBDE6Agq557Wtg69oJyN51sncNbGSDodnLJravg51sYQvb2ci2drWtfe1gW1sgNwi3uMdN7nKb+9zoTre61z0pT7n73fCOd6YEAoN62/ve+M63vvfN7377+98CQYLAB07wghv84AhPuMIXznCB6ODhEI+4xCdO8Ypb/OIYzzioVsXxjnv846ayTnhGTvKSm5w7bF28o8pXzvKWy7FVuIq5zGdO81kJxAc4z7nOd87znvv850APutCl2MWiG/3oSMeirorF9KY7/enA+qIap071qlu9jAIBgta3zvWue/3rYA+72MdO9oaY/exoT7tBAgIAOw==',NOW(),'gif');

-- update16
CREATE TABLE `c_commu_sub_admin_confirm` (
  `c_commu_sub_admin_confirm_id` int(11) NOT NULL auto_increment,
  `c_commu_id` int(11) NOT NULL default '0',
  `c_member_id_to` int(11) NOT NULL default '0',
  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `message` text NOT NULL,
  PRIMARY KEY  (`c_commu_sub_admin_confirm_id`),
  KEY `c_member_id_to` (`c_member_id_to`),
  KEY `c_commu_id` (`c_commu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- update17
ALTER TABLE `c_commu` ADD COLUMN `c_member_id_sub_admin` INT(11) NOT NULL after `c_member_id_admin`;
ALTER TABLE `c_commu` ADD COLUMN `topic_authority` enum('public','admin_only') NOT NULL DEFAULT 'public' after `c_member_id_sub_admin`;


-- update18
CREATE TABLE `c_username` (
  `c_username_id` int(11) NOT NULL auto_increment,
  `c_member_id` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`c_username_id`),
  KEY `c_member_id` (`c_member_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- update19

CREATE TABLE c_send_messages_history (
  c_send_messages_history_id bigint(20) NOT NULL auto_increment,
  subject text NOT NULL,
  body text NOT NULL,
  send_num bigint(20) NOT NULL default '0',
  type enum('mail','message') NOT NULL default 'mail',
  c_member_ids text NOT NULL,
  r_datetime datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (c_send_messages_history_id)
) TYPE=MyISAM;


CREATE TABLE c_message_queue (
  c_message_queue_id bigint(20) NOT NULL auto_increment,
  c_member_id_from bigint(20) NOT NULL default '0',
  c_member_id_to bigint(20) NOT NULL default '0',
  subject text NOT NULL,
  body text NOT NULL,
  PRIMARY KEY  (c_message_queue_id)
) TYPE=MyISAM;

-- update20
CREATE TABLE c_action (
  c_action_id bigint(20) NOT NULL auto_increment,
  name text NOT NULL,
  point bigint(20) NOT NULL default '0',
  PRIMARY KEY  (c_action_id)
) TYPE=MyISAM;


CREATE TABLE c_rank (
  c_rank_id bigint(20) NOT NULL auto_increment,
  name text NOT NULL,
  image_filename text NOT NULL,
  point bigint(20) NOT NULL default '0',
  PRIMARY KEY  (c_rank_id)
) TYPE=MyISAM;

-- update21
INSERT c_action VALUE('','入会する',0);
INSERT c_action VALUE('','日記にコメントされる',0);
INSERT c_action VALUE('','日記にコメントする',0);
INSERT c_action VALUE('','日記を書く',0);
INSERT c_action VALUE('','紹介文を書く',0);
INSERT c_action VALUE('','レビューを書く',0);
INSERT c_action VALUE('','友達を誘う',0);
INSERT c_action VALUE('','友人を紹介する',0);

INSERT INTO c_rank VALUES ('','rank1','skin_rank1.gif','200');
INSERT INTO c_rank VALUES ('','rank2','skin_rank2.gif','1000');
INSERT INTO c_rank VALUES ('','rank3','skin_rank3.gif','5000');
INSERT INTO c_rank VALUES ('','rank4','skin_rank4.gif','50000');
INSERT INTO c_rank VALUES ('','rank5','skin_rank5.gif','99999');

INSERT INTO `c_image` VALUES ('','skin_rank5.gif','R0lGODlheAAUAOYAALe5xv///+nr8Ofp7/39/eLk7OXn7v7+/uTm7fr6+/v7/PLy9uvs8u/w9Pj4+vT19+3v8/b2+To6OkRERElJSYKCg0tLS1BQUJmbnT8/P4yMj3h5ekJCQnt7fKGhoz09PX9/gKenqHZ2eFZWVpycn6WlppeYm6OjpXR0dmZmZmhoaNfY3Nzd35qam729vo6Oj0ZGRp6eoZeXmMfIzbGztX1+fomKinNzdNXV1snLzoeHiKioqZ2dnWFhYVNTU5WWlkdHR9PU2eDg4mNjZEpKSq+wtNXX2pCRkk5OTo6OkMvMz1xcXYCAguLi45CQkFBQUdDR08DAwVpaWgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAQAf/gACCg4SFhoeIiYqLjI2OjwARkpOUlZaXmJQnExcykhMgNzefFyedmxEqKpigFyCZsLGykoIGtre4ubq7vL2+v8DBwsGCBMbHyMnKy8zNzs/Q0dLRghDW19jZ2tvc2Bgw1zQS3xI0EBLWIiIY6OxG2xIiORJJ3fb3+BCCAfz9/v8AAwocSLCgwYMIDwpKwLChw4cQI0qcSJFhCAoVezgJEaJJxY8gIwpaQLKkyZMoU6o0GcOCSR0ZhrhckIFkhw4xMmSYuXJBB549gwpNKUiA0aNIkypdyrSp06dQo0qNKqiA1atYs2rdyrWr169gw4oNuy+h2bNo06o1KOiA27dw/+PKnUu3rt27ePPqzStIgd+/gAMLHky4sGG/O4gc5jGicZTDkCMPFuSgsuXLmDNr3nwZR4sSLSq7qFBBSOUKOCq8cFACSOUXLjT7KMG5tu3blwU92M27t+/fwIP39sBhOAsbSHZzYPGgRg3iKVIIl2IDCocfwrNr3/5AUIPv4MOLH0++fHgSFMAr+bAC/fcP3zdsIAGfwhHyKzbET2++v///gjAg4IAEFmjggQgSOIMGBKLwRBFMMIiCgCaYMMOEDGhgwoFBLDEBgwmGKOKIDAgywIkopqjiiiy26OKLMMYo44wyCoLAjTjmqOOOPPbo449ABinkkEJCYuSRSCappAMigQAAOw==',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_rank4.gif','R0lGODlheAAUAOYAALe5xv///+nr8Ofp7/39/eLk7P7+/uXn7uTm7fv7/Pr6++vs8u3v8/T19/j4+vLy9u/w9Pb2+UlJST8/Pzo6OkRERHt7fHR0doKCgz09PaGho5mbnUJCQpeYm0tLS1BQUJycn4yMj46Oj6OjpXZ2eEZGRmZmZqWlpp6eoUdHR3NzdH1+fpqam8fIzZeXmNXV1rGztdzd3729vnh5emhoaEpKSk5OTpCRknZ2d2NjZICAgomKiqenqKioqdjY2MvMz39/gFBQUdLS1eDg4tfY3JOTlFVVVYeHiNXX2t7e4a+wtAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAQAf/gACCg4SFhoeIiYqLjI2OjwARkpOUlZaXmJQjFR8ukhVAKiqfHyOdmxE0NJhCFUkVmbGys5KCB7e4ubq7vL2+v8DBwsPCggTHyMnKy8zNzs/Q0dLT0oIM19jZ2tvc3dkbJdgwFOAUMAwU1yQkG+ntSN7o8fP084IB+Pn6+/z9/v8AAwocSHCgIAUIEypcyLChw4cQEfKQEBGhEYoVM2pUKOiBx48gQ4ocSRIkCg8gj0zIgfLBBI8WLKCYMKGlyCITYuYsybOnzweCBAgdSrSo0aNIkypdyrSp06aCCkidSrWq1atYs2rdyrWr1673CoodS7asWYGCDKhdy7at27dw+ePKnUu3rt26ghLo3cu3r9+/gAML1tujxmC9PgwfXsyYryAHkCNLnky5smXJL1icYAFZBgYMQyBjeIFBhIMTKSCLkGFZBI7Ul2PLnu1AUIPbuHPr3s27d24NHH7H2GHjNocYDVasAG7ChG8bGhoE9029uvUGgiBo3869u/fv4LmDkLD9RwYi47Vn0D5jBoj1Em58vyGhfgby4fPr3y9ogf//AAYo4IAEAthCCABeEIQSOiB4gX8ddNDCgwuE0EGBC1CI4YYcFijIACCGKOKIJJZo4okopqjiiiyuKAgCMMYo44w01mjjjTjmqOOOPO4IyY9ABinkkIoEAgA7',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_rank3.gif','R0lGODlheAAUAOYAALe5xv///+nr8OTm7efp7+Xn7v39/eLk7P7+/vv7/Pr6+/Ly9uvs8vT19+/w9Pj4+vb2+e3v8zo6OklJSURERJmbnYKCgz8/P5eYm6OjpUpKSpycn1BQUEtLS0JCQsfIzT09PYyMj31+fnh5eqGho3R0do6Oj9zd36WlpnZ2eLGztXNzdL29vmZmZp6eoWhoaMvMz0ZGRpqam3t7fNfY3E5OTuDg4peXmNXV1pycnG9vcIeHiN7e4X9/gFBQUXFycomKimNjZFVVVYCAgpCRksDAwdXX2lNTU21tbouLjKioqVxcXa+wtEdHR6enqF5eXwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAQAf/gACCg4SFhoeIiYqLjI2OjwAQkpOUlZaXmJQZFBw3khQ9KyufHBmdmxAvL5kZSRQ8mbGysxCCBbe4ubq7vL2+v8DBwsPCggbHyMnKy8zNzs/Q0dLT0oIR19jZ2tvc3dkVMdgqEuASKhES1ykpFentRtwST+0V3vb3+BGCAfz9/v8AAwocSLCgwYMIDwpSwLChw4cQI0qcSJGhkwkVJ+RQoLGix48RBS0YSbKkyZMoU5Z00aHkjgtBWi64MHLGDBcXLshUuUCHDp5Ag/IUJKCo0aNIkypdyrSp06dQo0IVdKCq1atYs2rdyrWr169gw4Ldl7Cs2bNo0xoUhKCt27dw/+PKnUu3rt27ePPiFZSgr9+/gAMLHky4cF8lGgwX0aABieHHkAcLekC5suXLmDNrtoxDBgoZlFlYsGCDsgUcFkw8QNGEsgkWmVGUPqJ6s+3buAU12M27t+/fwIP3JuFh+AkgNXZ7ONFAhAjiLVoIb/6jBvPp2LMLF+Sgu/fv4MOLH/99wwTvMEDQMN8dRPcRIza4n0BEPIwJNByMEEK+v///DgjCwIAEFmjggQgmWOAHIRRYgg9MDNFgCQNigMEHFDIQAgYIfrAEBRwqKOKIJDIgCAEopqjiiiy26OKLMMYo44w0zijIADjmqOOOPPbo449ABinkkEQOCcmRSCap5ASSigQCADs=',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_rank2.gif','R0lGODlheAAUAOYAALe5xv///+nr8Ofp7+Lk7P39/eXn7v7+/uTm7fr6+/v7/O/w9PLy9vT19+vs8vb2+fj4+u3v83R0djo6Oj8/P4KCg0RERElJSYyMj3Z2eEpKSpmbnUJCQqOjpdzd36Gho1BQUJycn5eYmz09PUtLS2ZmZnh5esfIzUZGRp6eoZqam2hoaJeXmKWlpuDg4mNjZHNzdHt7fL29vrGztY6Oj31+ftXV1qenqI6OkFBQUX9/gE5OTqioqVNTU+Pj5N7e4dfY3EdHR1VVVXh4eNXX2svMz5CRksDAwV9fX9ra3q+wtGxsbYmKil5eX4eHiICAggAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAQAf/gACCg4SFhoeIiYqLjI2OjwAPkpOUlZaXmJQdFiAskhY6MDCfIB2dmw8rK5kPPxYdrLGyrIIGtre4ubq7vL2+v8DBwsGCBcbHyMnKy8zNzs/Q0dLRghHW19jZ2tvc2Bso1zMT3xMzERPWGRkb6OxE2xNN6jjd9fb3EYIB+/z9/v8AAwocSLCgwYMGBSVYyLChw4cQI0qcuPDGBYoXbiRYMoSix48QBTEYSbKkyZMoU5ZMQaKkEwovWjKgMDJGjBQUKMhEmQSmyp9Ag5IUJKCo0aNIkypdyrSp06dQo0IVRKCq1atYs2rdyrWr169gw4LVh7Cs2bNo0xYUdKCt27dw/uPKnUu3rt27ePPiFaSgr9+/gAMLHky4cF8eGgwf0cDYh+HHkAULgkC5suXLmDNrtmxDRQsVlGVUqOCCcgUbFWhAaBGEMg0ZmF30MI1ks+3buCEIasC7t+/fwIML9/2BA3EPTHbw5uChQY0axUuUGN7AA4fp1LNrpy5ogffv4MOLH08efIgL34uMAHLe+wjvJkyEeH/BCHkTQsrr388fvCAHAAYo4IAEFmiggCdgIKAEOSjxhIISACiCCCdE6AAGIhQowYYSKHjghyCGKMgAJJZo4okopqjiiiy26OKLML4oCAI01mjjjTjmqOOOPPbo449A/gjJkEQWaeSRigQCADs=',NOW(),'gif');
INSERT INTO `c_image` VALUES ('','skin_rank1.gif','R0lGODlheAAUAOYAALe5xv////7+/uTm7eLk7Ofp7+Xn7unr8P39/fv7/Pr6+/Ly9vT19+/w9Ovs8u3v8/j4+vb2+To6Oj8/P0lJSURERD09PYKCg3R0dkJCQpmbnVBQUJeYm0tLS5ycn6OjpaGho4yMj0dHR3Z2eJ6eoZeXmJqam3t7fNXV1mZmZqWlpn1+fnh5emhoaEZGRnNzdEpKSsfIzY6Oj7Gztb29vtzd34WFhZCRkqenqImKimNjZGFhYWxsbdXX2tfY3K+wtE5OTuDg4oeHiMvMz6ioqcDAwX9/gFBQUYCAggAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAQAf/gACCg4SFhoeIiYqLjI2OjwARkpOUlZaXmJQfFRslkhVGLy+fGx+dmxEtLZkRFayvsLCCBrS1tre4ubq7vL2+v8C/ggjExcbHyMnKy8zNzs/Qz4IP1NXW19jZ2tYaLtUzEt0SMw8S1CMjGubqPdvm2/Dx8tSCAfb3+Pn6+/z9/v8AAwoMKEiBwYMIEypcyLChQ4M4KDzcwUPiw4sYGQpawLGjx48gQ4r0SKKDRyETdJhcMIHjiRMkJkxYObLlyJs4c3IUdKCnz59AgwodSrSo0aNIkyIVRKCp06dQo0qdSrWq1atYs2KtN7Cr169gwwIUJKCs2bNo06pdy7at27dw5+PCFZSgrt27ePPq3cu3b10iMPwWsRHYr+HDewVBWMy4sePHkCM3RmFChYnFNC5cCLL4AooLMiCoELFYBg3JpCWrXs16sSAGsGPLnk27tm3ZIDLgrpEDCOwMNRisWJE7RYrbv5ErX75cUIPn0KNLn069enQPFKAPseAD+3MLz1mw8ACewg3rDcCjX89+vSAH8OPLn0+/vn35MULIx3DkBxL9GMDHAQcxBOhACBzcZ+B9DDbooAOCFCDhhBRWaOGFGGao4YYcduhhh4IMIOKIJJZo4okopqjiiiy26GKLkMQo44w01qhIIAA7',NOW(),'gif');

-- update22
ALTER TABLE c_username DROP INDEX `c_member_id`;
ALTER TABLE c_username DROP INDEX `username`;

ALTER TABLE c_username ADD UNIQUE INDEX `c_member_id`(c_member_id);
ALTER TABLE c_username ADD UNIQUE INDEX `username`(username);

