Mercurial > epgrec.yaz
annotate config.php.sample @ 87:36ac7c416bd7
merged with upstream
author | Yoshiki Yazawa <yaz@honeyplanet.jp> |
---|---|
date | Mon, 01 Mar 2010 20:51:36 +0900 |
parents | 549d799d73ae |
children | f854f6606fa5 |
rev | line source |
---|---|
1 | 1 <?php |
2 | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
3 // settings/gr_channel.phpが作成された場合、 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
4 // config.php内の$GR_CHANNEL_MAPは無視されます |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
5 |
1 | 6 // 首都圏用地上デジタルチャンネルマップ |
7 // 識別子 => チャンネル番号 | |
8 $GR_CHANNEL_MAP = array( | |
9 "GR27" => "27", // NHK | |
10 "GR26" => "26", // 教育 | |
11 "GR25" => "25", // 日テレ | |
12 "GR22" => "22", // 東京 | |
13 "GR21" => "21", // フジ | |
14 "GR24" => "24", // テレ朝 | |
15 "GR23" => "23", // テレ東 | |
16 // "GR20" => "20", // MX TV | |
17 // "GR18" => "18", // テレ神 | |
18 "GR30" => "30", // 千葉 | |
19 // "GR32" => "32", // テレ玉 | |
20 "GR28" => "28", // 大学 | |
21 ); | |
22 | |
23 /* | |
24 // 大阪地区デジタルチャンネルマップ(参考) | |
25 $GR_CHANNEL_MAP = array( | |
26 "GR24" => "24", // NHK | |
27 "GR13" => "13", // 教育 | |
28 "GR16" => "16", // 毎日 | |
29 "GR15" => "15", // 朝日 | |
30 "GR17" => "17", // 関西 | |
31 "GR14" => "14", // 読売 | |
32 "GR18" => "18", // テレビ大阪 | |
33 ); | |
34 */ | |
35 | |
36 | |
37 // 録画モード(option) | |
38 | |
39 $RECORD_MODE = array( | |
40 // ※ 0は必須で、変更不可です。 | |
41 0 => array( | |
3 | 42 'name' => 'Full TS', // モードの表示名 |
43 'suffix' => '.ts', // ファイル名のサフィックス | |
1 | 44 ), |
45 | |
46 1 => array( | |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
47 'name' => 'Minimum TS', // 最小のTS |
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
48 'suffix' => '_tss.ts', // do-record.shのカスタマイズが必要 |
1 | 49 ), |
50 | |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
51 /* Example is as follows. |
1 | 52 2 => array( |
53 'name' => '12Mbps MPEG4', | |
54 'suffix' => '.avi', | |
55 ), | |
56 */ | |
57 ); | |
58 | |
85 | 59 |
60 // BSチューナーとして黒Friioを用いているのなら下のfalseをtrueに変えてください。 | |
61 | |
62 define( "USE_KUROBON", false ); | |
63 | |
64 | |
65 | |
66 ////////////////////////////////////////////////////////////////////////////// | |
67 // 以降の変数・定数はほとんどの場合、変更する必要はありません | |
68 | |
1 | 69 |
32
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
19
diff
changeset
|
70 define( "INSTALL_PATH", dirname(__FILE__) ); // インストールパス |
1 | 71 |
72 // 以降は必要に応じて変更する | |
73 | |
74 define( "PADDING_TIME", 180 ); // 詰め物時間 | |
75 define( "DO_RECORD", INSTALL_PATH . "/do-record.sh" ); // レコードスクリプト | |
76 define( "COMPLETE_CMD", INSTALL_PATH . "/recomplete.php" ); // 録画終了コマンド | |
47 | 77 define( "GEN_THUMBNAIL", INSTALL_PATH . "/gen-thumbnail.sh" ); // サムネール生成スクリプト |
1 | 78 |
85 | 79 // BS/CSでEPGを取得するチャンネル |
80 // 通常は変える必要はありません | |
81 // BSでepgdumpが頻繁に落ちる場合は、受信状態のいいチャンネルに変えることで | |
82 // 改善するかもしれません | |
83 | |
84 define( "BS_EPG_CHANNEL", "211" ); // BS | |
85 define( "CS1_EPG_CHANNEL", "CS8" ); // CS1 | |
86 define( "CS2_EPG_CHANNEL", "CS24" ); // CS2 | |
87 | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
88 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
89 // 地上デジタルチャンネルテーブルsettings/gr_channel.phpが存在するならそれを |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
90 // 優先する |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
91 if( file_exists( INSTALL_PATH."/settings/gr_channel.php" ) ) { |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
92 unset($GR_CHANNEL_MAP); |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
93 include_once( INSTALL_PATH."/settings/gr_channel.php" ); |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
94 } |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
95 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
96 |
1 | 97 // 全国用BSデジタルチャンネルマップ |
98 $BS_CHANNEL_MAP = array( | |
99 "3001.ontvjapan.com" => "101", | |
100 "3002.ontvjapan.com" => "102", | |
101 "3003.ontvjapan.com" => "103", | |
102 "3004.ontvjapan.com" => "141", | |
103 "3005.ontvjapan.com" => "151", | |
104 "3006.ontvjapan.com" => "161", | |
105 "3007.ontvjapan.com" => "171", | |
106 "3008.ontvjapan.com" => "181", | |
107 "3009.ontvjapan.com" => "191", | |
108 "3010.ontvjapan.com" => "192", | |
109 "3011.ontvjapan.com" => "193", | |
110 "3013.ontvjapan.com" => "211", | |
111 "3014.ontvjapan.com" => "222", | |
112 ); | |
113 | |
114 if( USE_KUROBON ) { | |
115 $BS_CHANNEL_MAP = array( | |
116 "3001.ontvjapan.com" => "B10", | |
117 "3002.ontvjapan.com" => "B10", | |
118 "3003.ontvjapan.com" => "B11", | |
119 "3004.ontvjapan.com" => "B8", | |
120 "3005.ontvjapan.com" => "B1", | |
121 "3006.ontvjapan.com" => "B2", | |
122 "3007.ontvjapan.com" => "B4", | |
123 "3008.ontvjapan.com" => "B9", | |
124 "3009.ontvjapan.com" => "B3", | |
125 "3010.ontvjapan.com" => "B3", | |
126 "3011.ontvjapan.com" => "B3", | |
127 "3013.ontvjapan.com" => "B5", | |
128 "3014.ontvjapan.com" => "B7", | |
129 ); | |
130 } | |
131 | |
68 | 132 // 全国用CSデジタルチャンネルマップ |
133 $CS_CHANNEL_MAP = array( | |
134 "1002.ontvjapan.com" => "CS2", // 237, // "スターchプラス" | |
135 "1086.ontvjapan.com" => "CS2", // 239, // "日本映画専門chHD" | |
136 "306ch.epgdata.ontvjapan" => "CS2", // 306, // "フジテレビCSHD" | |
137 | |
138 "100ch.epgdata.ontvjapan" => "CS4", // 100, // "e2プロモ" | |
139 "1025.ontvjapan.com" => "CS4", // 256, // "Jスポーツ ESPN" | |
140 "1016.ontvjapan.com" => "CS4", // 312, // "FOX" | |
141 "1018.ontvjapan.com" => "CS4", // 322, // "スペースシャワーTV" | |
142 "1046.ontvjapan.com" => "CS4", // 331, // "カートゥーン ネット" | |
143 "194ch.epgdata.ontvjapan" => "CS4", // 194, // "インターローカルTV" | |
144 "1213.ontvjapan.com" => "CS4", // 334, // "トゥーン・ディズニー" | |
145 | |
146 "1010.ontvjapan.com" => "CS6", // 221, // "東映チャンネル" | |
147 "1005.ontvjapan.com" => "CS6", // 222, // "衛星劇場" | |
148 "1008.ontvjapan.com" => "CS6", // 223, // "チャンネルNECO" | |
149 "1009.ontvjapan.com" => "CS6", // 224, // "洋画★シネフィル" | |
150 "1133.ontvjapan.com" => "CS6", // 292, // "時代劇専門チャンネル" | |
151 "1003.ontvjapan.com" => "CS6", // 238, // "スター・クラシック" | |
152 "1006.ontvjapan.com" => "CS6", // 310, // "スーパードラマ" | |
153 "1014.ontvjapan.com" => "CS6", // 311, // "AXN" | |
154 "1204.ontvjapan.com" => "CS6", // 343, // "ナショジオチャンネル" | |
155 | |
156 "1059.ontvjapan.com" => "CS8", // 55, // "ショップチャンネル" | |
157 | |
158 "1217.ontvjapan.com" => "CS10", // 228, // "ザ・シネマ" | |
159 "800ch.epgdata.ontvjapan" => "CS10", // 800, // "スカチャンHD800" | |
160 "801ch.epgdata.ontvjapan" => "CS10", // 801, // "スカチャン801" | |
161 "802ch.epgdata.ontvjapan" => "CS10", // 802, // "スカチャン802" | |
162 | |
163 "1028.ontvjapan.com" => "CS12", // 260, // "ゴルフチャンネル" | |
164 "1092.ontvjapan.com" => "CS12", // 303, // "テレ朝チャンネル" | |
165 "1019.ontvjapan.com" => "CS12", // 323, // "MTV" | |
166 "1024.ontvjapan.com" => "CS12", // 324, // "ミュージック・エア" | |
167 "1067.ontvjapan.com" => "CS12", // 352, // "朝日ニュースター" | |
168 "1070.ontvjapan.com" => "CS12", // 353, // "BBCワールド" | |
169 "1069.ontvjapan.com" => "CS12", // 354, // "CNNj" | |
170 "361ch.epgdata.ontvjapan" => "CS12", // 361, // "ジャスト・アイ" | |
171 | |
172 "1041.ontvjapan.com" => "CS14", // 251, // "Jスポーツ 1" | |
173 "1042.ontvjapan.com" => "CS14", // 252, // "Jスポーツ 2" | |
174 "1043.ontvjapan.com" => "CS14", // 253, // "JスポーツPlusH" | |
175 "1026.ontvjapan.com" => "CS14", // 254, // "GAORA" | |
176 "1040.ontvjapan.com" => "CS14", // 255, // "sky・Aスポーツ+" | |
177 | |
178 "305ch.epgdata.ontvjapan" => "CS16", // 305, // "チャンネル銀河" | |
179 "1201.ontvjapan.com" => "CS16", // 333, // "AT-X" | |
180 "1050.ontvjapan.com" => "CS16", // 342, // "ヒストリーチャンネル" | |
181 "803ch.epgdata.ontvjapan" => "CS16", // 803, // "スカチャン803" | |
182 "804ch.epgdata.ontvjapan" => "CS16", // 804, // "スカチャン804" | |
183 "1207.ontvjapan.com" => "CS16", // 290, // "SKY・STAGE" | |
184 | |
185 "1007.ontvjapan.com" => "CS18", // 240, // "ムービープラスHD" | |
186 "1027.ontvjapan.com" => "CS18", // 262, // "ゴルフネットワーク" | |
187 "1074.ontvjapan.com" => "CS18", // 314, // "LaLa HD" | |
188 | |
189 "1073.ontvjapan.com" => "CS20", // 258, // "フジテレビ739" | |
190 "1072.ontvjapan.com" => "CS20", // 302, // "フジテレビ721" | |
191 "1047.ontvjapan.com" => "CS20", // 332, // "アニマックス" | |
192 "1062.ontvjapan.com" => "CS20", // 340, // "ディスカバリー" | |
193 "1193.ontvjapan.com" => "CS20", // 341, // "アニマルプラネット" | |
194 | |
195 "160ch.epgdata.ontvjapan" => "CS22", // 160, // "C-TBSウエルカム" | |
196 //"1120.ontvjapan.com" => "CS22", // 161, // "QVC" | |
197 "185ch.epgdata.ontvjapan" => "CS22", // 185, // "プライム365.TV" | |
198 "1015.ontvjapan.com" => "CS22", // 293, // "ファミリー劇場" | |
199 "3201.ontvjapan.com" => "CS22", // 301, // "TBSチャンネル" | |
200 "1090.ontvjapan.com" => "CS22", // 304, // "ディズニーチャンネル" | |
201 "1022.ontvjapan.com" => "CS22", // 325, // "MUSIC ON! TV" | |
202 "1045.ontvjapan.com" => "CS22", // 330, // "キッズステーション" | |
203 "1076.ontvjapan.com" => "CS22", // 351, // "TBSニュースバード" | |
204 | |
205 "1068.ontvjapan.com" => "CS24", // 257, // "日テレG+" | |
206 "5004.ontvjapan.com" => "CS24", // 291, // "fashion TV" | |
207 "300ch.epgdata.ontvjapan" => "CS24", // 300, // "日テレプラス" | |
208 "1023.ontvjapan.com" => "CS24", // 320, // "エコミュージックTV" | |
209 "1208.ontvjapan.com" => "CS24", // 321, // "Music Japan TV" | |
210 "2002.ontvjapan.com" => "CS24", // 350, // "日テレNEWS24" | |
211 /* | |
212 "110ch.epgdata.ontvjapan" => "CS22", 110, // "ワンテンポータル" | |
213 "101ch.epgdata.ontvjapan" => "CS22", 101, // "宝塚プロモチャンネル" | |
214 "147ch.epgdata.ontvjapan" => "CS22", 147, // "CS日本番組ガイド" | |
215 */ | |
216 ); | |
1 | 217 |
218 // DBテーブル情報 以下は変更しないでください | |
219 | |
220 define( "RESERVE_TBL", "reserveTbl" ); // 予約テーブル | |
221 define( "PROGRAM_TBL", "programTbl" ); // 番組表 | |
222 define( "CHANNEL_TBL", "channelTbl" ); // チャンネルテーブル | |
223 define( "CATEGORY_TBL", "categoryTbl" ); // カテゴリテーブル | |
224 define( "KEYWORD_TBL", "keywordTbl" ); // キーワードテーブル | |
225 | |
226 // 予約テーブル | |
227 define( "RESERVE_STRUCT", | |
228 "id integer not null auto_increment primary key,". // ID | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
229 "channel_disc varchar(128) not null default 'none',". // channel disc |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
230 "channel_id integer not null default '0',". // channel ID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
231 "program_id integer not null default '0',". // Program ID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
232 "type varchar(8) not null default 'GR',". // 種別(GR/BS/CS) |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
233 "channel varchar(10) not null default '0',". // チャンネル |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
234 "title varchar(512) not null default 'none',". // タイトル |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
235 "description varchar(512) not null default 'none',". // 説明 text->varchar |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
236 "category_id integer not null default '0',". // カテゴリID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
237 "starttime datetime not null default '1970-01-01 00:00:00',". // 開始時刻 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
238 "endtime datetime not null default '1970-01-01 00:00:00',". // 終了時刻 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
239 "job integer not null default '0',". // job番号 |
19
9648e3af1777
change: field type ( title, path )
Sushi-k <epgrec@park.mda.or.jp>
parents:
11
diff
changeset
|
240 "path blob default null,". // 録画ファイルパス |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
241 "complete boolean not null default '0',". // 完了フラグ |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
242 "reserve_disc varchar(128) not null default 'none',". // 識別用hash |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
243 "autorec integer not null default '0',". // キーワードID |
77 | 244 "mode integer not null default '0',". //録画モード |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
245 "index reserve_ch_idx (channel_disc),". // インデックス |
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
246 "index reserve_st_idx (starttime)". |
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
247 "" |
1 | 248 ); |
249 | |
250 | |
251 // 番組表テーブル | |
252 define( "PROGRAM_STRUCT", | |
253 "id integer not null auto_increment primary key,". // ID | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
254 "channel_disc varchar(128) not null default 'none',". // channel disc |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
255 "channel_id integer not null default '0',". // channel ID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
256 "type varchar(8) not null default 'GR',". // 種別(GR/BS/CS) |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
257 "channel varchar(10) not null default '0',". // チャンネル |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
258 "title varchar(512) not null default 'none',". // タイトル |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
259 "description varchar(512) not null default 'none',". // 説明 text->varchar |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
260 "category_id integer not null default '0',". // カテゴリID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
261 "starttime datetime not null default '1970-01-01 00:00:00',". // 開始時刻 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
262 "endtime datetime not null default '1970-01-01 00:00:00',". // 終了時刻 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
263 "program_disc varchar(128) not null default 'none',". // 識別用hash |
77 | 264 "autorec boolean not null default '1',". // 自動録画有効無効 |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
265 "index program_ch_idx (channel_disc),". // インデックス |
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
266 "index program_st_idx (starttime)". |
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
267 "" |
1 | 268 ); |
269 | |
270 | |
271 define( "CHANNEL_STRUCT", | |
272 "id integer not null auto_increment primary key,". // ID | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
273 "type varchar(8) not null default 'GR',". // 種別 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
274 "channel varchar(10) not null default '0',". // channel |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
275 "name varchar(512) not null default 'none',". // 表示名 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
276 "channel_disc varchar(128) not null default 'none',". // 識別用hash |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
277 "sid varchar(64) not null default 'hd'" // サービスID用02/23/2010追加 |
1 | 278 ); |
279 | |
280 define( "CATEGORY_STRUCT", | |
281 "id integer not null auto_increment primary key,". // ID | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
282 "name_jp varchar(512) not null default 'none',". // 表示名 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
283 "name_en varchar(512) not null default 'none',". // 同上 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
284 "category_disc varchar(128) not null default 'none'" // 識別用hash |
1 | 285 ); |
286 | |
287 | |
288 define( "KEYWORD_STRUCT", | |
289 "id integer not null auto_increment primary key,". // ID | |
76
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
290 "keyword varchar(512) not null default '*',". // 表示名 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
291 "type varchar(8) not null default '*',". // 種別 |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
292 "channel_id integer not null default '0',". // channel ID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
293 "category_id integer not null default '0',". // カテゴリID |
69e0dabc765a
fixed: Reservation.class.php
Sushi-k <epgrec@park.mda.or.jp>
parents:
68
diff
changeset
|
294 "use_regexp boolean not null default '0',". // 正規表現を使用するなら1 |
77 | 295 "autorec_mode integer not null default '0',". // 自動録画のモード02/23/2010追加 |
80
cce6f88590fd
add: db table updater script.
Sushi-k <epgrec@park.mda.or.jp>
parents:
77
diff
changeset
|
296 "weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'" // 曜日、同追加 |
1 | 297 ); |
85 | 298 ?> |