--2013-11-14 kato sampledb_itojuku反映済 INSERT INTO `config` (`category`, `name`, `value`) VALUES ('student_idnumber', 'student', '0'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'shohin_kobestu_number', '10000'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'if_code', '1000000000000'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'shiryo', '0'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'fb', '0'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'event', '0'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('buppin', 'shohin_kobestu_number', '70000'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('buppin', 'if_code', '2000000000000'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hacchu', 'hacchu_number', '0001'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hassocode', 'shukka_kobetsu', '1'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'iclassNo', '0010000'); ALTER TABLE resource_sub1 ADD COLUMN school_code varchar(3) DEFAULT NULL; ALTER TABLE resource_sub1 ADD COLUMN eshop_code varchar(5) DEFAULT NULL; -- Naeem CREATE TABLE IF NOT EXISTS `master_kanri` ( `id` int(11) NOT NULL AUTO_INCREMENT, `deleted` tinyint(1) NOT NULL DEFAULT '0', `date_entered` datetime NOT NULL, `date_modified` datetime NOT NULL, `modified_user_id` char(36) NOT NULL, `created_by` char(36) NOT NULL, `inactive` tinyint(1) DEFAULT '0', `display_order` int(11) DEFAULT NULL, `master_name` varchar(40) DEFAULT NULL, `master_group` varchar(40) DEFAULT NULL, `school_id` char(36) DEFAULT NULL, `master_category1` varchar(40) DEFAULT NULL, `master_category2` varchar(40) DEFAULT NULL, `field1` varchar(40) DEFAULT NULL, `field2` varchar(40) DEFAULT NULL, `field3` varchar(40) DEFAULT NULL, `field4` varchar(40) DEFAULT NULL, `field5` varchar(40) DEFAULT NULL, `field6` varchar(40) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2920 ; -- shimoju -- DB_Kanriを実行してmanual_contactを再構築した後、以下のカラムを追加 ALTER TABLE `manual_contact` ADD `obog1` TINYINT NULL; ALTER TABLE `manual_contact` ADD `obog2` TINYINT NULL; ALTER TABLE `manual_contact` ADD `obog3` TINYINT NULL; ALTER TABLE `manual_contact` ADD `obog4` TINYINT NULL; ALTER TABLE `manual_contact` ADD `rel_kobaimikomi` VARCHAR( 5 ) NULL; ALTER TABLE `manual_contact` ADD `rel_school_id` VARCHAR( 36 ) NULL; ALTER TABLE `manual_contact` ADD `rel_description` TEXT NULL; ALTER TABLE `manual_contact` ADD `spiral_number` VARCHAR( 128 ) NULL; ALTER TABLE `manual_contact` ADD `raw_import_data` TEXT NULL; ALTER TABLE `manual_contact` ADD `import_serial_no` int(11) NULL; ALTER TABLE `manual_contact` ADD `import_source` VARCHAR( 40 ) NULL; ALTER TABLE `manual_contact` ADD `status` TINYINT( 1 ) NOT NULL DEFAULT '0'; --2013-11-21 kato 以下、sampledb_itojukuに未反映 --2013-11-21 shimoju 　manual_contact追加 ALTER TABLE `manual_contact` ADD `payment_type` varchar(16) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `nyuukinsaki_card_credit` varchar(5) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `koza_id` char(36) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `buppin_id` varbinary(36) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `basic_fee` double DEFAULT '0'; ALTER TABLE `manual_contact` ADD `suryo` int(11) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `t_date` datetime DEFAULT NULL; ALTER TABLE `manual_contact` ADD `nyuukinsaki_shori_number` varchar(100) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `waribiki_name` varchar(100) DEFAULT NULL; ALTER TABLE `manual_contact` ADD `waribiki_fee` double DEFAULT '0'; ALTER TABLE `manual_contact` ADD `syohin_code` varchar(13) DEFAULT NULL; --2013-11-22 kato INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hassocode', 'buppin', '1'); INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hassocode', 'shukka_iraisho', '1'); --2013-11-22 kato カラム削除 ALTER TABLE `smsevent` DROP `web_de_doriru_haishin` ; --2013-12-02 kato 保留 --ALTER TABLE `sms_transaction` DROP `waribiki_category` ; --ALTER TABLE `sms_transaction` DROP `buppin_category` ; --2013-12-03 kato 売上訂正の仕様変更 ALTER TABLE `sms_salesgroup` ADD `teisei_flg` tinyint(1) DEFAULT 0; -- 2013-12-03 metehan unncessary fields ALTER TABLE `smsevent` DROP `custom_var31`, DROP `custom_var32`, DROP `custom_var33`, DROP `custom_var34`, DROP `custom_var35`, DROP `custom_var36`, DROP `custom_var37`, DROP `custom_var38`, DROP `custom_var39`, DROP `custom_var40`; 1,6,11,16,21,26,31,36,41,46,51,56 * * * * cd /home/sites/itojuku.e-school.jp/htdocs/test2; /usr/bin/php /home/sites/itojuku.e-school.jp/htdocs/test2/emailmandelivery.php crontab_server_name=itojuku.e-school.jp crontab_php_self=itojuku.e-school.jp/test2 0,5,10,15,20,25,30,35,40,45,50,55 * * * * cd /home/sites/itojuku.e-school.jp/htdocs/test; /usr/bin/php /home/sites/itojuku.e-school.jp/htdocs/test/emailmandelivery.php crontab_server_name=itojuku.e-school.jp crontab_php_self=itojuku.e-school.jp/test; --2014-01-07 kato 大文字小文字の対応 --localで型変更したＳＱＬをピックアップしました --移行した物品を使用する可能性があるので、移行データの有無に関わらず実施します --buppin_id ALTER TABLE `buppin` CHANGE `buppin_code` `buppin_code` VARBINARY( 100 ) NULL DEFAULT NULL ; ALTER TABLE `buppin` CHANGE `id` `id` VARBINARY( 36 ) NOT NULL ; ALTER TABLE `buppin_class` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `buppin_curriculum` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hacchu` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hassocode_buppin` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hasso_contacts` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `manual_contact` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `nyuka` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `rejidata_torikomi_history` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_kobetsu_buppin` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `sms_fee` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `sms_transaction` CHANGE `buppin_id` `buppin_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_1` `buppin_id_1` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_2` `buppin_id_2` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_3` `buppin_id_3` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_4` `buppin_id_4` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_5` `buppin_id_5` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_6` `buppin_id_6` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_7` `buppin_id_7` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_8` `buppin_id_8` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_9` `buppin_id_9` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_10` `buppin_id_10` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_11` `buppin_id_11` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_12` `buppin_id_12` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_13` `buppin_id_13` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_14` `buppin_id_14` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_15` `buppin_id_15` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_16` `buppin_id_16` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_17` `buppin_id_17` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_18` `buppin_id_18` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_19` `buppin_id_19` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_20` `buppin_id_20` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_21` `buppin_id_21` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_22` `buppin_id_22` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_23` `buppin_id_23` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_24` `buppin_id_24` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `shukka_iraisho` CHANGE `buppin_id_25` `buppin_id_25` VARBINARY( 36 ) NULL DEFAULT NULL ; --hassocode_id ALTER TABLE `hassocode` CHANGE `hassocode` `hassocode` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hassocode` CHANGE `id` `id` VARBINARY( 36 ) NOT NULL ; ALTER TABLE `curriculum_hassocode` CHANGE `hassocode_id` `hassocode_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hassocode_buppin` CHANGE `hassocode_id` `hassocode_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hassocode_contacts` CHANGE `hassocode_id` `hassocode_id` VARBINARY( 36 ) NULL DEFAULT NULL ; ALTER TABLE `hassocode_hassobi` CHANGE `hassocode_id` `hassocode_id` VARBINARY( 36 ) NULL DEFAULT NULL ; --データ移行のidの構成要素として使用 ALTER TABLE `hassocode_buppin` CHANGE `id` `id` VARBINARY( 36 ) NOT NULL ; ALTER TABLE `hassocode_contacts` CHANGE `id` `id` VARBINARY( 36 ) NOT NULL ; ALTER TABLE `hasso_contacts` CHANGE `id` `id` VARBINARY( 50 ) NOT NULL ; ALTER TABLE `hasso_contacts` CHANGE `hassocode_contacts_id` `hassocode_contacts_id` VARBINARY( 36 ) NOT NULL ; --2014-01-08 kato 移行時期なので個別に反映 ALTER TABLE `smsevent` CHANGE `name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ; -- 2014-01-14 mon for auto increment and zerofill ALTER TABLE `smsevent` ADD `itojukunet_class` INT NOT NULL ; ALTER TABLE `smsevent` CHANGE `itojukunet_class` `itojukunet_class` INT(9) ZEROFILL NOT NULL AUTO_INCREMENT, ADD KEY(`itojukunet_class`); ALTER TABLE `curriculum` ADD `itojukunet_curriculum` INT NOT NULL ; ALTER TABLE `curriculum` CHANGE `itojukunet_curriculum` `itojukunet_curriculum` INT(9) ZEROFILL NOT NULL AUTO_INCREMENT, ADD KEY(`itojukunet_curriculum`); ALTER TABLE `koza` ADD `itojukunet_koza` INT NOT NULL ; ALTER TABLE `koza` CHANGE `itojukunet_koza` `itojukunet_koza` INT(6) ZEROFILL NOT NULL AUTO_INCREMENT, ADD KEY(`itojukunet_koza`); --2014-02-19 kato クラス受講生関連と出荷情報関連のリカバリー用ワークテーブル 下記ＳＱＬを参照 recovery_ec_shukka.sql --2014-02-07 shimoju 　manual_contact追加 　 --2/7時点でtest, test2, test3, trainingに反映済み --3/6 本番反映済 ALTER TABLE `manual_contact` ADD `event_id` VARCHAR( 36 ) NULL; ALTER TABLE `manual_contact` ADD `fb_id` VARCHAR( 36 ) NULL; --2014-02-13 kato 変更先カリキュラムの項目追加の初期値 　 --2/13時点でtest, test2, trainingに反映済み --3/27 本番反映済 update smsevent set seiseki_curriculum_id=curriculum_id where seiseki_curriculum_id is null ; -- 2014-04-01 grade updates SELECT id, last_name, date_modified, grade, grade_entrance_date, grade_entered, date_modified, date_entered, contact_status FROM contacts WHERE smsgroup='student' AND grade IN ("12", "13", "14", "15", "16", "17", "18", "19", "20", "21") UPDATE contacts SET grade=grade+1 WHERE smsgroup='student' AND grade IN ("12", "13", "14", "15", "16", "17", "18", "19", "20", "21") SELECT id, last_name, date_modified, grade, grade_entrance_date, grade_entered, date_modified, date_entered, contact_status FROM contacts WHERE smsgroup='student' AND grade IN ("houka1", "houka2", "houka3", "houka4") SELECT id, last_name, date_modified, grade, grade_entrance_date, grade_entered, date_modified, date_entered, contact_status FROM contacts WHERE smsgroup='student' AND grade ="houka1" UPDATE contacts SET grade="houka4" WHERE smsgroup='student' AND grade ="houka3" UPDATE contacts SET grade="houka3" WHERE smsgroup='student' AND grade ="houka2" UPDATE contacts SET grade="houka2" WHERE smsgroup='student' AND grade ="houka1" --2014-02-17 kato 入退室履歴のテストデバイス --2/17時点でtest2, trainingに反映済み --4/3 本番反映済 INSERT INTO `resource` (`id`, `school_id`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `name`, `shortname`, `description`, `category`, `location`, `deleted`, `capacity`, `resource_attributes`, `common_code`, `activation_key`, `area_id`) VALUES ('nyutai_tokyo_1', 'sssssss-1111', '2014-04-03 00:00:00', '2014-04-03 00:00:00', '1', '1', 'tokyo_1', 'tokyo_1', '', 'entrance', NULL, 0, 1, '', NULL, '', NULL), ('nyutai_tokyo_2', 'sssssss-1111', '2014-04-03 00:00:00', '2014-04-03 00:00:00', '1', '1', 'tokyo_2', 'tokyo_2', '', 'entrance', NULL, 0, 1, '', NULL, '', NULL), ('nyutai_tokyo_3', 'sssssss-1111', '2014-04-03 00:00:00', '2014-04-03 00:00:00', '1', '1', 'tokyo_3', 'tokyo_3', '', 'entrance', NULL, 0, 1, '', NULL, '', NULL); --2014-04-03 kato --cron起動のバッチの多重起動制御　GENELにも記載済 --4/7 test2, trainingに反映 --4/8 本番, test3, testに反映 ALTER TABLE `batch_manager` ADD `last_run_start` DATETIME NULL ; ALTER TABLE `batch_manager` ADD INDEX `idx_category` ( `category` ) ; ALTER TABLE `batch_items` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `batch_items` ADD INDEX `idx_batch_id` ( `batch_id` ) ; ALTER TABLE `batch_items` ADD INDEX `idx_item_key` ( `item_key` ) ; --2014-03-12 shimoju 　config_import_infoの種別を追加 　 --3/13 test2, test3, trainingに反映 --4/8 本番反映 ALTER TABLE `config_import_info` CHANGE `main_category` `main_category` ENUM( 'contact', 'event', 'fee', 'schedule', 'shinro_1', 'shinro_2', 'shinro_3', 'shinro_4' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ; ALTER TABLE `config_import_info` CHANGE `sub_category` `sub_category` ENUM( 'Student', 'Teacher', 'Contact', 'Staff', 'Course', 'Fee', 'Shinro_1', 'Shinro_2', 'Shinro_3', 'Shinro_4' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; --2014-04-10 shimoju 　校舎にe-shop用csvデータ出力用のの種別を追加 　 --4/10 test2, trainingに反映 --5/13 本番反映 ALTER TABLE resource_sub1 ADD COLUMN eshop_jukoukeitai_01d varchar(5) DEFAULT NULL; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='T'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='K'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='C'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='N'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='U'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='B'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='M'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='Y'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='S'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='G'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="100" WHERE school_code='D'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="200" WHERE school_code='X'; UPDATE resource_sub1 SET eshop_jukoukeitai_01d="200" WHERE school_code='Z'; --2014-05-15 shimoju 　受講生住所マルチ検索用テーブル作成 　 --5/15 test2　test3　に反映 --5/27 本番反映 CREATE TABLE `state_master` ( `id` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `name` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , PRIMARY KEY ( `id` ) ) ENGINE = InnoDB; CREATE TABLE `state_area` ( `id` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `area_id` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `state_id` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , PRIMARY KEY ( `id` ) ) ENGINE = InnoDB; INSERT INTO state_master (id, name) VALUES ("01","東北地方"); INSERT INTO state_master (id, name) VALUES ("02","関東地方"); INSERT INTO state_master (id, name) VALUES ("03","中部地方"); INSERT INTO state_master (id, name) VALUES ("04","近畿地方"); INSERT INTO state_master (id, name) VALUES ("05","中国地方"); INSERT INTO state_master (id, name) VALUES ("06","四国地方"); INSERT INTO state_master (id, name) VALUES ("07","九州地方"); INSERT INTO state_master (id, name) VALUES ("10","北海道"); INSERT INTO state_master (id, name) VALUES ("11","青森県"); INSERT INTO state_master (id, name) VALUES ("12","岩手県"); INSERT INTO state_master (id, name) VALUES ("13","宮城県"); INSERT INTO state_master (id, name) VALUES ("14","秋田県"); INSERT INTO state_master (id, name) VALUES ("15","山形県"); INSERT INTO state_master (id, name) VALUES ("16","福島県"); INSERT INTO state_master (id, name) VALUES ("17","茨城県"); INSERT INTO state_master (id, name) VALUES ("18","栃木県"); INSERT INTO state_master (id, name) VALUES ("19","群馬県"); INSERT INTO state_master (id, name) VALUES ("20","埼玉県"); INSERT INTO state_master (id, name) VALUES ("21","千葉県"); INSERT INTO state_master (id, name) VALUES ("22","東京都"); INSERT INTO state_master (id, name) VALUES ("23","神奈川県"); INSERT INTO state_master (id, name) VALUES ("24","新潟県"); INSERT INTO state_master (id, name) VALUES ("25","富山県"); INSERT INTO state_master (id, name) VALUES ("26","石川県"); INSERT INTO state_master (id, name) VALUES ("27","福井県"); INSERT INTO state_master (id, name) VALUES ("28","山梨県"); INSERT INTO state_master (id, name) VALUES ("29","長野県"); INSERT INTO state_master (id, name) VALUES ("30","岐阜県"); INSERT INTO state_master (id, name) VALUES ("31","静岡県"); INSERT INTO state_master (id, name) VALUES ("32","愛知県"); INSERT INTO state_master (id, name) VALUES ("33","三重県"); INSERT INTO state_master (id, name) VALUES ("34","滋賀県"); INSERT INTO state_master (id, name) VALUES ("35","京都府"); INSERT INTO state_master (id, name) VALUES ("36","大阪府"); INSERT INTO state_master (id, name) VALUES ("37","兵庫県"); INSERT INTO state_master (id, name) VALUES ("38","奈良県"); INSERT INTO state_master (id, name) VALUES ("39","和歌山県"); INSERT INTO state_master (id, name) VALUES ("40","鳥取県"); INSERT INTO state_master (id, name) VALUES ("41","島根県"); INSERT INTO state_master (id, name) VALUES ("42","岡山県"); INSERT INTO state_master (id, name) VALUES ("43","広島県"); INSERT INTO state_master (id, name) VALUES ("44","山口県"); INSERT INTO state_master (id, name) VALUES ("45","徳島県"); INSERT INTO state_master (id, name) VALUES ("46","香川県"); INSERT INTO state_master (id, name) VALUES ("47","愛媛県"); INSERT INTO state_master (id, name) VALUES ("48","高知県"); INSERT INTO state_master (id, name) VALUES ("49","福岡県"); INSERT INTO state_master (id, name) VALUES ("50","佐賀県"); INSERT INTO state_master (id, name) VALUES ("51","長崎県"); INSERT INTO state_master (id, name) VALUES ("52","熊本県"); INSERT INTO state_master (id, name) VALUES ("53","大分県"); INSERT INTO state_master (id, name) VALUES ("54","宮崎県"); INSERT INTO state_master (id, name) VALUES ("55","鹿児島県"); INSERT INTO state_master (id, name) VALUES ("56","沖縄"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0001","01","11"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0002","01","12"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0003","01","13"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0004","01","14"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0005","01","15"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0006","01","16"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0007","02","17"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0008","02","18"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0009","02","19"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0010","02","20"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0011","02","21"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0012","02","22"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0013","02","23"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0014","03","24"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0015","03","25"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0016","03","26"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0017","03","27"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0018","03","28"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0019","03","29"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0020","03","30"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0021","03","31"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0022","03","32"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0023","04","33"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0024","04","34"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0025","04","35"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0026","04","36"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0027","04","37"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0028","04","38"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0029","04","39"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0030","05","40"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0031","05","41"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0032","05","42"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0033","05","43"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0034","05","44"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0035","06","45"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0036","06","46"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0037","06","47"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0038","06","48"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0039","07","49"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0040","07","50"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0041","07","51"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0042","07","52"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0043","07","53"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0044","07","54"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0045","07","55"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0046","10","10"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0047","11","11"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0048","12","12"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0049","13","13"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0050","14","14"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0051","15","15"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0052","16","16"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0053","17","17"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0054","18","18"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0055","19","19"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0056","20","20"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0057","21","21"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0058","22","22"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0059","23","23"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0060","24","24"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0061","25","25"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0062","26","26"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0063","27","27"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0064","28","28"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0065","29","29"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0066","30","30"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0067","31","31"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0068","32","32"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0069","33","33"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0070","34","34"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0071","35","35"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0072","36","36"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0073","37","37"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0074","38","38"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0075","39","39"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0076","40","40"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0077","41","41"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0078","42","42"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0079","43","43"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0080","44","44"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0081","45","45"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0082","46","46"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0083","47","47"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0084","48","48"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0085","49","49"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0086","50","50"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0087","51","51"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0088","52","52"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0089","53","53"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0090","54","54"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0091","55","55"); INSERT INTO state_area (id,area_id,state_id) VALUES ("0092","56","56"); --2014/11/27 kato 売上登録時のリカバリー対応 CREATE TABLE IF NOT EXISTS `uriagetoroku_recovery_history` ( `id` char(36) NOT NULL, `date_entered` datetime NOT NULL, `date_modified` datetime NOT NULL, `created_by` char(36) DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `contact_id` char(36) DEFAULT NULL, `koza_id` char(36) DEFAULT NULL, `event_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --2014/11/20 kato 再要件定義 スケジュールのコマ番号対応 --2016/02/26 再要件定義凍結のため以下の更新は不要 --ALTER TABLE sms_event_instance_sub ADD COLUMN koma_no int(11) NOT NULL; --ALTER TABLE sms_event_instance_sub ADD COLUMN shuseki_flg varchar(5) NOT NULL DEFAULT '0'; --ALTER TABLE sms_event_instance_sub ADD COLUMN henkin_flg varchar(5) NOT NULL DEFAULT '0'; --ALTER TABLE sms_event_instance_sub ADD INDEX ( ins_order, koma_no ); ----------------------------------------------- -- 以下成績管理用UPDATE -- Update SQLs for Seiseki project below -- 2016/2/26 shimoju ----------------------------------------------- -- 2016/04/05 mon update based on the TABLE DEF ALTER TABLE master_kanri MODIFY field6 VARCHAR(150); -- (rio) 74778 : Add jukoukeitai record INSERT INTO master_kanri ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `inactive`, `display_order`, `master_name`, `master_group`, `school_id`, `master_category1`, `master_category2`, `field1` ) VALUES ( '600009', '0', '2019-04-23 00:00:00', '2019-04-23 00:00:00', '1', '1', '0', '0', 'ライブ中継', 'jukoukeitai', NULL, NULL, NULL, 'R' );