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