--DBとユーザ設定
CREATE DATABASE `itojuku_seiseki` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

localhost→特権→tojuku_odbcの右端の編集ボタン
データベースに特権を追加からDBを選択
データベースに固有の特権からSELECTを選択し、実行するを押下

--table作成
CREATE TABLE IF NOT EXISTS `smsevent` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `shortname` varchar(12) DEFAULT NULL,
  `description` text,
  `parent_id` varchar(36) DEFAULT NULL,
  `syllabus_id` varchar(36) DEFAULT NULL,
  `smsdocument_id` varchar(36) DEFAULT NULL,
  `category` varchar(15) DEFAULT 'course',
  `status` tinyint(1) DEFAULT NULL,
  `school_id` char(36) DEFAULT NULL,
  `vacation_type` int(11) DEFAULT NULL,
  `vacation_count` float DEFAULT NULL,
  `subtype` varchar(255) DEFAULT NULL,
  `event_credit` varchar(10) DEFAULT NULL,
  `schedule_reminder` bigint(20) unsigned DEFAULT NULL,
  `common_code` varchar(36) DEFAULT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  `class_code` varchar(100) DEFAULT NULL,
  `kamoku` varchar(100) DEFAULT NULL,
  `kaikonen` varchar(5) DEFAULT NULL,
  `class_teacher` varchar(36) DEFAULT NULL,
  `curriculum_id` varchar(100) DEFAULT NULL,
  `teiin` int(11) DEFAULT NULL,
  `no_current_student` int(11) DEFAULT '0',
  `net_haishin_umu` varchar(5) DEFAULT NULL,
  `net_haishin_kigen` date DEFAULT NULL,
  `web_de_doriru_taisho` varchar(5) DEFAULT NULL,
  `shikenshu` varchar(5) DEFAULT NULL,
  `kozabunrui` varchar(36) DEFAULT NULL,
  `common_code_a` varchar(36) DEFAULT NULL,
  `common_code_b` varchar(36) DEFAULT NULL,
  `siyoujyoukyou` varchar(5) DEFAULT NULL,
  `itojukunet_class` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `seiseki_curriculum_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `school_id` (`school_id`),
  KEY `category` (`category`),
  KEY `name` (`name`),
  KEY `assigned_user_id` (`assigned_user_id`),
  KEY `curriculum_id` (`curriculum_id`),
  KEY `syllabus_id` (`syllabus_id`),
  KEY `smsdocument_id` (`smsdocument_id`),
  KEY `date_entered` (`date_entered`),
  KEY `date_modified` (`date_modified`),
  KEY `class_code` (`class_code`),
  KEY `kamoku` (`kamoku`),
  KEY `class_teacher` (`class_teacher`),
  KEY `common_code_a` (`common_code_a`),
  KEY `common_code_b` (`common_code_b`),
  KEY `itojukunet_class` (`itojukunet_class`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49011 ;

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `salutation` varchar(5) DEFAULT NULL,
  `first_name` varchar(40) DEFAULT NULL,
  `last_name` varchar(40) DEFAULT NULL,
  `first_name_furigana` varchar(40) DEFAULT NULL,
  `last_name_furigana` varchar(40) DEFAULT NULL,
  `lead_source` varchar(100) DEFAULT NULL,
  `lead_source_description` varchar(64) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `reports_to_id` char(36) DEFAULT NULL,
  `commission_company_id` varchar(36) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `do_not_call` tinyint(1) DEFAULT '0',
  `phone_home` varchar(25) DEFAULT NULL,
  `phone_mobile` varchar(25) DEFAULT NULL,
  `phone_work` varchar(25) DEFAULT NULL,
  `phone_other` varchar(25) DEFAULT NULL,
  `phone_fax` varchar(25) DEFAULT NULL,
  `email1` varchar(100) DEFAULT NULL,
  `email2` varchar(100) DEFAULT NULL,
  `assistant` varchar(75) DEFAULT NULL,
  `assistant_phone` varchar(25) DEFAULT NULL,
  `email_opt_out` tinyint(1) DEFAULT '0',
  `primary_address_street` varchar(150) DEFAULT NULL,
  `primary_address_city` varchar(100) DEFAULT NULL,
  `primary_address_state` varchar(100) DEFAULT NULL,
  `primary_address_postalcode` varchar(20) DEFAULT NULL,
  `primary_address_country` varchar(100) DEFAULT NULL,
  `primary_address_kana` varchar(250) DEFAULT NULL,
  `alt_address_street` varchar(150) DEFAULT NULL,
  `alt_address_city` varchar(160) DEFAULT NULL,
  `alt_address_state` varchar(100) DEFAULT NULL,
  `alt_address_postalcode` varchar(20) DEFAULT NULL,
  `alt_address_country` varchar(100) DEFAULT NULL,
  `alt_address_kana` varchar(250) DEFAULT NULL,
  `description` text,
  `portal_name` varchar(255) DEFAULT NULL,
  `portal_active` tinyint(3) DEFAULT '0',
  `portal_app` varchar(255) DEFAULT NULL,
  `invalid_email` tinyint(1) DEFAULT '0',
  `smsgroup` varchar(15) DEFAULT NULL,
  `contact_status` varchar(3) DEFAULT NULL,
  `picture_filename` varchar(255) DEFAULT NULL,
  `picture_file_mime_type` varchar(24) DEFAULT NULL,
  `school_id` char(36) DEFAULT NULL,
  `vacation_total` float DEFAULT NULL,
  `vacation_used` float DEFAULT NULL,
  `is_available_strict` tinyint(1) DEFAULT '0',
  `major` varchar(32) DEFAULT NULL,
  `send_document_home` tinyint(1) DEFAULT '0',
  `send_document_work` tinyint(1) DEFAULT '0',
  `company_name` varchar(100) DEFAULT NULL,
  `idnumber` varchar(32) DEFAULT NULL,
  `nationality` varchar(16) DEFAULT NULL,
  `gender` varchar(8) DEFAULT NULL,
  `work_school` varchar(3) DEFAULT NULL,
  `last_school_name` varchar(64) DEFAULT NULL,
  `last_school_dept` varchar(64) DEFAULT NULL,
  `study_aim` varchar(64) DEFAULT NULL,
  `transport_fee_type` varchar(16) DEFAULT NULL,
  `transportfee` int(11) DEFAULT NULL,
  `incometax_rate` varchar(4) DEFAULT '0.1',
  `leave_date` date DEFAULT NULL,
  `enroll_date` date DEFAULT NULL,
  `grade` varchar(10) DEFAULT NULL,
  `grade_entered` varchar(10) DEFAULT NULL,
  `grade_entrance_date` date DEFAULT NULL,
  `application_date` date DEFAULT NULL,
  `extra_date` date DEFAULT NULL,
  `id_card_field1` text,
  `id_card_field2` varchar(50) DEFAULT NULL,
  `id_card_field3` varchar(50) DEFAULT NULL,
  `id_card_field4` text,
  `renmei_label` text,
  `card_id` char(36) DEFAULT NULL,
  `nyutai_mail_notice` tinyint(3) DEFAULT '0',
  `account_id` varchar(36) DEFAULT NULL,
  `phone_mobile_cleaned` varchar(25) DEFAULT NULL,
  `phone_home_cleaned` varchar(25) DEFAULT NULL,
  `phone_work_cleaned` varchar(25) DEFAULT NULL,
  `phone_other_cleaned` varchar(25) DEFAULT NULL,
  `bank_payment_type` varchar(1) DEFAULT NULL,
  `bank_code` varchar(4) DEFAULT NULL,
  `bank_branch_code` varchar(4) DEFAULT NULL,
  `bank_name` varchar(20) DEFAULT NULL,
  `bank_branch_name` varchar(20) DEFAULT NULL,
  `bank_account_type` varchar(1) DEFAULT NULL,
  `bank_account_no` varchar(20) DEFAULT NULL,
  `bank_account_name` varchar(20) DEFAULT NULL,
  `taiokyohi` tinyint(1) DEFAULT '0',
  `jukouseicard_uid` varchar(100) DEFAULT NULL,
  `jukouseicard_enterd` date DEFAULT NULL,
  `snsdate_out` date DEFAULT NULL,
  `rank_shihoushiken` varchar(3) DEFAULT NULL,
  `rank_koumuin` varchar(3) DEFAULT NULL,
  `rank_shihoushoshi` varchar(3) DEFAULT NULL,
  `rank_gyouseishoshi` varchar(3) DEFAULT NULL,
  `houka_graduate_school` varchar(100) DEFAULT NULL,
  `kishu_mishu` varchar(5) DEFAULT NULL,
  `graduate_school` varchar(100) DEFAULT NULL,
  `vocational` varchar(100) DEFAULT NULL,
  `university` varchar(100) DEFAULT NULL,
  `gakubu` varchar(100) DEFAULT NULL,
  `gakka` varchar(100) DEFAULT NULL,
  `hougakukei_circle` varchar(100) DEFAULT NULL,
  `circle_title` varchar(5) DEFAULT NULL,
  `highschool` varchar(100) DEFAULT NULL,
  `work_school_etc` varchar(100) DEFAULT NULL,
  `name_work` varchar(100) DEFAULT NULL,
  `address_work` varchar(300) DEFAULT NULL,
  `email_work` varchar(100) DEFAULT NULL,
  `obog_members` bigint(20) unsigned DEFAULT '0',
  `jikanshitei` varchar(3) DEFAULT NULL,
  `kyokudome` varchar(3) DEFAULT NULL,
  `urgency_name` varchar(100) DEFAULT NULL,
  `urgency_phone` varchar(25) DEFAULT NULL,
  `urgency_phone_cleaned` varchar(25) DEFAULT NULL,
  `kiseisaki_address_postalcode` varchar(20) DEFAULT NULL,
  `kiseisaki_address_state` varchar(100) DEFAULT NULL,
  `kiseisaki_address_city` varchar(160) DEFAULT NULL,
  `kiseisaki_address_street` varchar(150) DEFAULT NULL,
  `kiseisaki_address_kana` varchar(250) DEFAULT NULL,
  `kiseisaki_phone` varchar(25) DEFAULT NULL,
  `kiseisaki_phone_cleaned` varchar(25) DEFAULT NULL,
  `kiseisaki_date_entered` date DEFAULT NULL,
  `kiseisaki_date_end` date DEFAULT NULL,
  `kyokudome_address_postalcode` varchar(20) DEFAULT NULL,
  `kyokudome_address_state` varchar(100) DEFAULT NULL,
  `kyokudome_address_city` varchar(100) DEFAULT NULL,
  `kyokudome_address_street` varchar(150) DEFAULT NULL,
  `kyokudome_address_kana` varchar(250) DEFAULT NULL,
  `deletedate` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_cont_last_first` (`last_name`,`first_name`,`deleted`),
  KEY `idx_contacts_del_last` (`deleted`,`last_name`),
  KEY `idx_cont_del_reports` (`deleted`,`reports_to_id`,`last_name`),
  KEY `smsgroup` (`smsgroup`,`contact_status`),
  KEY `school_id` (`school_id`),
  KEY `card_id` (`card_id`),
  KEY `idnumber` (`idnumber`),
  KEY `date_modified` (`date_modified`),
  KEY `phone_home` (`phone_home`),
  KEY `phone_mobile` (`phone_mobile`),
  KEY `leave_date` (`leave_date`),
  KEY `last_first_deleted` (`last_name`,`first_name`,`deleted`),
  KEY `first` (`first_name`),
  KEY `date_entered` (`date_entered`),
  KEY `phone_other` (`phone_other`),
  KEY `application_date` (`application_date`),
  KEY `enroll_date` (`enroll_date`),
  KEY `email1` (`email1`),
  KEY `last_name_furigana` (`last_name_furigana`),
  KEY `first_name_furigana` (`first_name_furigana`),
  KEY `phone_home_cleaned` (`phone_home_cleaned`),
  KEY `phone_mobile_cleaned` (`phone_mobile_cleaned`),
  KEY `phone_other_cleaned` (`phone_other_cleaned`),
  KEY `phone_work_cleaned` (`phone_work_cleaned`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `curriculum` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `curriculum_name` varchar(100) DEFAULT NULL,
  `curriculum_code` varchar(50) DEFAULT NULL,
  `kaikonen` varchar(5) DEFAULT NULL,
  `shikenshu` varchar(5) DEFAULT NULL,
  `kozabunrui` varchar(36) DEFAULT NULL,
  `common_code_a` varchar(36) DEFAULT NULL,
  `common_code_b` varchar(36) DEFAULT NULL,
  `netohaishin_no` varchar(100) DEFAULT NULL,
  `web_de_doriru_haishin` varchar(5) DEFAULT NULL,
  `web_de_doriru_course` varchar(100) DEFAULT NULL,
  `itojukunet_curriculum` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `curriculum_code` (`curriculum_code`),
  KEY `common_code_a` (`common_code_a`),
  KEY `common_code_b` (`common_code_b`),
  KEY `curriculum_name` (`curriculum_name`),
  KEY `itojukunet_curriculum` (`itojukunet_curriculum`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4409 ;

CREATE TABLE IF NOT EXISTS `event_contacts` (
  `id` char(36) NOT NULL,
  `contact_id` char(36) DEFAULT NULL,
  `event_id` char(36) DEFAULT NULL,
  `date_modified` datetime NOT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `event_contact_status` varchar(4) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `event_credit` varchar(10) DEFAULT NULL,
  `description` text,
  `koza_id` char(36) DEFAULT NULL,
  `class_change_date` date DEFAULT NULL,
  `class_cancellation_date` date DEFAULT NULL,
  `to_class_change_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`),
  KEY `contact_id` (`contact_id`,`event_id`),
  KEY `start_date` (`start_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `koza` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `school_id` char(36) DEFAULT NULL,
  `common_code` varchar(100) DEFAULT NULL,
  `jukoukeitai_code` varchar(100) DEFAULT NULL,
  `koza_name` varchar(100) DEFAULT NULL,
  `jukoukeitai_name` varchar(100) DEFAULT NULL,
  `shikenshu` varchar(5) DEFAULT NULL,
  `jukoukeitai` varchar(36) DEFAULT NULL,
  `common_code_a` varchar(36) DEFAULT NULL,
  `common_code_b` varchar(36) DEFAULT NULL,
  `kozabunrui` varchar(36) DEFAULT NULL,
  `ki` varchar(36) DEFAULT NULL,
  `teacher_name` varchar(36) DEFAULT NULL,
  `taishou_status` varchar(5) DEFAULT NULL,
  `kaikonen` varchar(5) DEFAULT NULL,
  `mokuhyonen` varchar(5) DEFAULT NULL,
  `koza_start_date` date DEFAULT NULL,
  `koza_end_date` date DEFAULT NULL,
  `shikenbi` date DEFAULT NULL,
  `if_code` varchar(36) DEFAULT NULL,
  `hanbaikahi` varchar(36) DEFAULT NULL,
  `kouza_kingaku` double DEFAULT NULL,
  `shohin_kobestu_number` int(11) DEFAULT NULL,
  `csv_export_date` date DEFAULT NULL,
  `itojukunet_koza` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `school_id` (`school_id`),
  KEY `common_code` (`common_code`),
  KEY `common_code_a` (`common_code_a`),
  KEY `common_code_b` (`common_code_b`),
  KEY `date_entered` (`date_entered`),
  KEY `date_modified` (`date_modified`),
  KEY `koza_start_date` (`koza_start_date`),
  KEY `koza_end_date` (`koza_end_date`),
  KEY `shikenbi` (`shikenbi`),
  KEY `csv_export_date` (`csv_export_date`),
  KEY `koza_name` (`koza_name`),
  KEY `itojukunet_koza` (`itojukunet_koza`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=92111 ;

CREATE TABLE IF NOT EXISTS `koza_code_master` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `common_code_a` varchar(36) DEFAULT NULL,
  `common_code_name` varchar(100) DEFAULT NULL,
  `common_code_b` varchar(6) DEFAULT NULL,
  `common_code_kamoku` varchar(10) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `koza_code_type` char(36) DEFAULT NULL,
  `shikenshu` varchar(5) DEFAULT NULL,
  `shohin_kobestu_number` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `common_code_a` (`common_code_a`),
  KEY `common_code_b` (`common_code_b`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `resource` (
  `id` char(36) NOT NULL,
  `school_id` char(36) DEFAULT NULL,
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `shortname` varchar(12) DEFAULT NULL,
  `description` text,
  `category` varchar(50) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `capacity` int(4) DEFAULT NULL,
  `resource_attributes` text,
  `common_code` char(36) DEFAULT NULL,
  `activation_key` varchar(36) DEFAULT NULL,
  `area_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `school_id` (`school_id`),
  KEY `category` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `smsevent_instances` (
  `id` varchar(36) NOT NULL DEFAULT '',
  `date_modified` datetime DEFAULT '0000-00-00 00:00:00',
  `event_id` varchar(36) NOT NULL DEFAULT '',
  `event_type` varchar(15) DEFAULT NULL,
  `instance_id` varchar(36) NOT NULL DEFAULT '',
  `target_id` varchar(36) NOT NULL DEFAULT '',
  `category` varchar(25) DEFAULT '',
  `from_datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `to_datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `status` int(11) DEFAULT '0',
  `from_instance_id` varchar(36) DEFAULT NULL,
  `to_instance_id` varchar(36) DEFAULT NULL,
  `attendance_status` smallint(6) DEFAULT NULL,
  `instance_contact_status` tinyint(1) DEFAULT NULL,
  `name` text,
  `description` text,
  `early_late_time2` tinyint(3) DEFAULT '0',
  `early_late_time3` tinyint(3) DEFAULT '0',
  `attendance_memo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`event_id`,`instance_id`,`target_id`),
  UNIQUE KEY `id_index` (`id`),
  KEY `event_id` (`event_id`,`event_type`),
  KEY `instance_id` (`instance_id`,`status`),
  KEY `target_from` (`target_id`,`from_datetime`),
  KEY `target_to` (`target_id`,`to_datetime`),
  KEY `target_id` (`target_id`,`from_datetime`,`to_datetime`),
  KEY `from_datetime` (`from_datetime`,`to_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `sms_event_instance` (
  `id` varchar(36) NOT NULL DEFAULT '',
  `parent_id` varchar(36) DEFAULT '',
  `event_type` varchar(15) DEFAULT NULL,
  `from_datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `to_datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `name` text,
  `description` text,
  `description2` text,
  `description3` text,
  `date_modified` datetime DEFAULT '0000-00-00 00:00:00',
  `deleted` tinyint(3) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `from_id` varchar(36) DEFAULT NULL,
  `to_id` varchar(36) DEFAULT NULL,
  `reason` text,
  PRIMARY KEY (`id`),
  KEY `from_to_datetime` (`from_datetime`,`to_datetime`,`status`),
  KEY `from_id` (`from_id`),
  KEY `to_id` (`to_id`),
  KEY `parent_id` (`parent_id`,`from_datetime`,`to_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `sms_event_instance_sub` (
  `instance_id` varchar(36) NOT NULL,
  `ins_order` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `users` (
  `id` varchar(36) NOT NULL DEFAULT '',
  `user_name` varchar(60) DEFAULT NULL,
  `user_password` varchar(30) DEFAULT NULL,
  `user_hash` varchar(32) DEFAULT NULL,
  `is_admin` varchar(3) DEFAULT '0',
  `receive_notifications` char(1) DEFAULT '1',
  `description` text,
  `date_entered` datetime DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` varchar(36) DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  `user_preferences` mediumtext,
  `deleted` tinyint(3) DEFAULT '0',
  `portal_only` tinyint(1) DEFAULT '0',
  `is_group` tinyint(1) DEFAULT '0',
  `contact_id` varchar(36) DEFAULT NULL,
  `smsgroup` varchar(15) DEFAULT NULL,
  `kantan_login_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_name` (`user_name`),
  KEY `user_password` (`user_password`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;