Mercurial > epgrec.yaz
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 |