comparison tableStruct.inc.php @ 142:481e789605e3

mod: EPGの更新と同時に予約情報を更新するように変更、ログビューアの追加
author epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp>
date Sun, 21 Mar 2010 16:42:58 +0900
parents 9c5e597ef6c6
children
comparison
equal deleted inserted replaced
136:6754b6aa50cf 142:481e789605e3
19 "path blob default null,". // 牙祉<ゃ 19 "path blob default null,". // 牙祉<ゃ
20 "complete boolean not null default '0',". // 絎篋 20 "complete boolean not null default '0',". // 絎篋
21 "reserve_disc varchar(128) not null default 'none',". // 茘ョhash 21 "reserve_disc varchar(128) not null default 'none',". // 茘ョhash
22 "autorec integer not null default '0',". // 若若ID 22 "autorec integer not null default '0',". // 若若ID
23 "mode integer not null default '0',". // 牙祉≪若 23 "mode integer not null default '0',". // 牙祉≪若
24 "dirty boolean not null default '0',". // 若c
24 "index reserve_ch_idx (channel_disc),". // ゃ潟 25 "index reserve_ch_idx (channel_disc),". // ゃ潟
25 "index reserve_st_idx (starttime)". 26 "index reserve_st_idx (starttime)".
26 "" 27 ""
27 ); 28 );
28 29
72 "type varchar(8) not null default '*',". // 腮 73 "type varchar(8) not null default '*',". // 腮
73 "channel_id integer not null default '0',". // channel ID 74 "channel_id integer not null default '0',". // channel ID
74 "category_id integer not null default '0',". // 眼ID 75 "category_id integer not null default '0',". // 眼ID
75 "use_regexp boolean not null default '0',". // 罩h頫憗篏睡1 76 "use_regexp boolean not null default '0',". // 罩h頫憗篏睡1
76 "autorec_mode integer not null default '0',". // 牙祉≪若02/23/2010菴遵 77 "autorec_mode integer not null default '0',". // 牙祉≪若02/23/2010菴遵
77 "weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'".// ャ菴遵 78 "weekofday enum ('0','1','2','3','4','5','6','7' ) not null default '7'".// ャ菴遵
78 ",prgtime enum ('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24') default '24'". // 03/13/2010菴遵 79 ",prgtime enum ('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24') not null default '24'". // 03/13/2010菴遵
79 "" 80 ""
80 ); 81 );
81 82
82 define( "LOG_STRUCT", 83 define( "LOG_STRUCT",
83 "id integer not null auto_increment primary key". // ID 84 "id integer not null auto_increment primary key". // ID