Mercurial > epgrec.yaz
view tableStruct.inc.php @ 125:ef3df87f3c7d
mod: チャンネルスキップの大まかな実装終了
| author | Sushi-k <epgrec@park.mda.or.jp> |
|---|---|
| date | Wed, 17 Mar 2010 18:12:01 +0900 |
| parents | 7a64d5e3baee |
| children | 9c5e597ef6c6 |
line wrap: on
line source
<?php // 若帥若鴻若絎臂 // 篋膣若 define( "RESERVE_STRUCT", "id integer not null auto_increment primary key,". // ID "channel_disc varchar(128) not null default 'none',". // channel disc "channel_id integer not null default '0',". // channel ID "program_id integer not null default '0',". // Program ID "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚 "channel varchar(10) not null default '0',". // ｃ潟 "title varchar(512) not null default 'none',". // 帥ゃ "description varchar(512) not null default 'none',". // 茯 text->varchar "category_id integer not null default '0',". // 眼ID "starttime datetime not null default '1970-01-01 00:00:00',". // 紮 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋 "job integer not null default '0',". // job "path blob default null,". // 牙祉＜ゃ "complete boolean not null default '0',". // 絎篋 "reserve_disc varchar(128) not null default 'none',". // 茘ョhash "autorec integer not null default '0',". // 若若ID "mode integer not null default '0',". // 牙祉≪若 "index reserve_ch_idx (channel_disc),". // ゃ潟 "index reserve_st_idx (starttime)". "" ); // 腟茵若 define( "PROGRAM_STRUCT", "id integer not null auto_increment primary key,". // ID "channel_disc varchar(128) not null default 'none',". // channel disc "channel_id integer not null default '0',". // channel ID "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚 "channel varchar(10) not null default '0',". // ｃ潟 "title varchar(512) not null default 'none',". // 帥ゃ "description varchar(512) not null default 'none',". // 茯 text->varchar "category_id integer not null default '0',". // 眼ID "starttime datetime not null default '1970-01-01 00:00:00',". // 紮 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋 "program_disc varchar(128) not null default 'none',". // 茘ョhash "autorec boolean not null default '1',". // 牙紙合≦ "index program_ch_idx (channel_disc),". // ゃ潟 "index program_st_idx (starttime)". "" ); define( "CHANNEL_STRUCT", "id integer not null auto_increment primary key,". // ID "type varchar(8) not null default 'GR',". // 腮 "channel varchar(10) not null default '0',". // channel "name varchar(512) not null default 'none',". // 茵腓阪 "channel_disc varchar(128) not null default 'none',". // 茘ョhash "sid varchar(64) not null default 'hd',". // 泣若ID02/23/2010菴遵 "skip boolean not null default '0'". // ｃ潟鴻03/13/2010菴遵 "" ); define( "CATEGORY_STRUCT", "id integer not null auto_increment primary key,". // ID "name_jp varchar(512) not null default 'none',". // 茵腓阪 "name_en varchar(512) not null default 'none',". // 筝 "category_disc varchar(128) not null default 'none'" // 茘ョhash ); define( "KEYWORD_STRUCT", "id integer not null auto_increment primary key,". // ID "keyword varchar(512) not null default '*',". // 茵腓阪 "type varchar(8) not null default '*',". // 腮 "channel_id integer not null default '0',". // channel ID "category_id integer not null default '0',". // 眼ID "use_regexp boolean not null default '0',". // 罩ｈ頫憗篏睡1 "autorec_mode integer not null default '0',". // 牙祉≪若02/23/2010菴遵 "weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'".// ャ菴遵 ",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菴遵 "" ); ?>