Mercurial > epgrec.yaz

comparison tableStruct.inc.php @ 114:f854f6606fa5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod: DBテーブル構造をconfig.phpから切り離した
author yoneda <epgrec@park.mda.or.jp>
date Sat, 13 Mar 2010 21:37:27 +0900
parents
children 7a64d5e3baee
comparison
equal deleted inserted replaced
111:3bed74eca373 114:f854f6606fa5
1 <?php
2 // 若帥若鴻若絎臂
3
4
5 // 篋膣若
6 define( "RESERVE_STRUCT",
7 "id integer not null auto_increment primary key,". // ID
8 "channel_disc varchar(128) not null default 'none',". // channel disc
9 "channel_id integer not null default '0',". // channel ID
10 "program_id integer not null default '0',". // Program ID
11 "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚
12 "channel varchar(10) not null default '0',". // ｃ潟
13 "title varchar(512) not null default 'none',". // 帥ゃ
14 "description varchar(512) not null default 'none',". // 茯 text->varchar
15 "category_id integer not null default '0',". // 眼ID
16 "starttime datetime not null default '1970-01-01 00:00:00',". // 紮
17 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋
18 "job integer not null default '0',". // job
19 "path blob default null,". // 牙祉＜ゃ
20 "complete boolean not null default '0',". // 絎篋
21 "reserve_disc varchar(128) not null default 'none',". // 茘ョhash
22 "autorec integer not null default '0',". // 若若ID
23 "mode integer not null default '0',". //牙祉≪若
24 "index reserve_ch_idx (channel_disc),". // ゃ潟
25 "index reserve_st_idx (starttime)".
26 ""
27 );
28
29
30 // 腟茵若
31 define( "PROGRAM_STRUCT",
32 "id integer not null auto_increment primary key,". // ID
33 "channel_disc varchar(128) not null default 'none',". // channel disc
34 "channel_id integer not null default '0',". // channel ID
35 "type varchar(8) not null default 'GR',". // 腮ワGR/BS/CS鐚
36 "channel varchar(10) not null default '0',". // ｃ潟
37 "title varchar(512) not null default 'none',". // 帥ゃ
38 "description varchar(512) not null default 'none',". // 茯 text->varchar
39 "category_id integer not null default '0',". // 眼ID
40 "starttime datetime not null default '1970-01-01 00:00:00',". // 紮
41 "endtime datetime not null default '1970-01-01 00:00:00',". // 腟篋
42 "program_disc varchar(128) not null default 'none',". // 茘ョhash
43 "autorec boolean not null default '1',". // 牙紙合≦
44 "index program_ch_idx (channel_disc),". // ゃ潟
45 "index program_st_idx (starttime)".
46 ""
47 );
48
49
50 define( "CHANNEL_STRUCT",
51 "id integer not null auto_increment primary key,". // ID
52 "type varchar(8) not null default 'GR',". // 腮
53 "channel varchar(10) not null default '0',". // channel
54 "name varchar(512) not null default 'none',". // 茵腓阪
55 "channel_disc varchar(128) not null default 'none',". // 茘ョhash
56 "sid varchar(64) not null default 'hd',". // 泣若ID02/23/2010菴遵
57 "skip boolean not null default '0'". // ｃ潟鴻03/13/2010菴遵
58 ""
59 );
60
61 define( "CATEGORY_STRUCT",
62 "id integer not null auto_increment primary key,". // ID
63 "name_jp varchar(512) not null default 'none',". // 茵腓阪
64 "name_en varchar(512) not null default 'none',". // 筝
65 "category_disc varchar(128) not null default 'none'" // 茘ョhash
66 );
67
68
69 define( "KEYWORD_STRUCT",
70 "id integer not null auto_increment primary key,". // ID
71 "keyword varchar(512) not null default '*',". // 茵腓阪
72 "type varchar(8) not null default '*',". // 腮
73 "channel_id integer not null default '0',". // channel ID
74 "category_id integer not null default '0',". // 眼ID
75 "use_regexp boolean not null default '0',". // 罩ｈ頫憗篏睡1
76 "autorec_mode integer not null default '0',". // 牙祉≪若02/23/2010菴遵
77 "weekofday enum ('0','1','2','3','4','5','6','7' ) 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 ""
80 );
81
82 ?>