comparison config.php.sample @ 114:f854f6606fa5

mod: DBテーブル構造をconfig.phpから切り離した
author yoneda <epgrec@park.mda.or.jp>
date Sat, 13 Mar 2010 21:37:27 +0900
parents 549d799d73ae
children 6754b6aa50cf
comparison
equal deleted inserted replaced
111:3bed74eca373 114:f854f6606fa5
221 define( "PROGRAM_TBL", "programTbl" ); // 腟茵 221 define( "PROGRAM_TBL", "programTbl" ); // 腟茵
222 define( "CHANNEL_TBL", "channelTbl" ); // c潟若 222 define( "CHANNEL_TBL", "channelTbl" ); // c潟若
223 define( "CATEGORY_TBL", "categoryTbl" ); // 眼若 223 define( "CATEGORY_TBL", "categoryTbl" ); // 眼若
224 define( "KEYWORD_TBL", "keywordTbl" ); // 若若若 224 define( "KEYWORD_TBL", "keywordTbl" ); // 若若若
225 225
226 // 篋膣若 226
227 define( "RESERVE_STRUCT",
228 "id integer not null auto_increment primary key,". // ID
229 "channel_disc varchar(128) not null default 'none',". // channel disc
230 "channel_id integer not null default '0',". // channel ID
231 "program_id integer not null default '0',". // Program ID
232 "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚
233 "channel varchar(10) not null default '0',". // c潟
234 "title varchar(512) not null default 'none',". // 帥ゃ
235 "description varchar(512) not null default 'none',". // 茯 text->varchar
236 "category_id integer not null default '0',". // 眼ID
237 "starttime datetime not null default '1970-01-01 00:00:00',". // 紮
238 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋
239 "job integer not null default '0',". // job
240 "path blob default null,". // 牙祉<ゃ
241 "complete boolean not null default '0',". // 絎篋
242 "reserve_disc varchar(128) not null default 'none',". // 茘ョhash
243 "autorec integer not null default '0',". // 若若ID
244 "mode integer not null default '0',". //牙祉≪若
245 "index reserve_ch_idx (channel_disc),". // ゃ潟
246 "index reserve_st_idx (starttime)".
247 ""
248 );
249
250
251 // 腟茵若
252 define( "PROGRAM_STRUCT",
253 "id integer not null auto_increment primary key,". // ID
254 "channel_disc varchar(128) not null default 'none',". // channel disc
255 "channel_id integer not null default '0',". // channel ID
256 "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚
257 "channel varchar(10) not null default '0',". // c潟
258 "title varchar(512) not null default 'none',". // 帥ゃ
259 "description varchar(512) not null default 'none',". // 茯 text->varchar
260 "category_id integer not null default '0',". // 眼ID
261 "starttime datetime not null default '1970-01-01 00:00:00',". // 紮
262 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋
263 "program_disc varchar(128) not null default 'none',". // 茘ョhash
264 "autorec boolean not null default '1',". // 牙紙合≦
265 "index program_ch_idx (channel_disc),". // ゃ潟
266 "index program_st_idx (starttime)".
267 ""
268 );
269
270
271 define( "CHANNEL_STRUCT",
272 "id integer not null auto_increment primary key,". // ID
273 "type varchar(8) not null default 'GR',". // 腮
274 "channel varchar(10) not null default '0',". // channel
275 "name varchar(512) not null default 'none',". // 茵腓阪
276 "channel_disc varchar(128) not null default 'none',". // 茘ョhash
277 "sid varchar(64) not null default 'hd'" // 泣若ID02/23/2010菴遵
278 );
279
280 define( "CATEGORY_STRUCT",
281 "id integer not null auto_increment primary key,". // ID
282 "name_jp varchar(512) not null default 'none',". // 茵腓阪
283 "name_en varchar(512) not null default 'none',". // 筝
284 "category_disc varchar(128) not null default 'none'" // 茘ョhash
285 );
286
287
288 define( "KEYWORD_STRUCT",
289 "id integer not null auto_increment primary key,". // ID
290 "keyword varchar(512) not null default '*',". // 茵腓阪
291 "type varchar(8) not null default '*',". // 腮
292 "channel_id integer not null default '0',". // channel ID
293 "category_id integer not null default '0',". // 眼ID
294 "use_regexp boolean not null default '0',". // 罩h頫憗篏睡1
295 "autorec_mode integer not null default '0',". // 牙祉≪若02/23/2010菴遵
296 "weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'" // ャ菴遵
297 );
298 ?> 227 ?>