diff config.php.sample @ 77:cb7da56c4198

modified: Keyword.class.php modified: config.php.sample modified: index.php modified: install/step1.php modified: keywordTable.php modified: programTable.php modified: simpleReservation.php modified: templates/index.html modified: templates/keywordTable.html modified: templates/programTable.html
author Sushi-k <epgrec@park.mda.or.jp>
date Wed, 24 Feb 2010 20:22:19 +0900
parents 69e0dabc765a
children cce6f88590fd
line wrap: on
line diff
--- a/config.php.sample	Tue Feb 23 19:58:30 2010 +0900
+++ b/config.php.sample	Wed Feb 24 20:22:19 2010 +0900
@@ -225,7 +225,8 @@
 	"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'"						//録画モード
+	"mode integer not null default '0',".						//録画モード
+	"index reserve_idx (channel_disc, starttime)"			// インデックス
 );
 
 
@@ -242,7 +243,9 @@
 	"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'"					// 自動録画有効無効
+	"autorec boolean not null default '1',".					// 自動録画有効無効
+	"index program_idx (channel_disc, starttime)"			// インデックス
+
 );
 
 
@@ -270,6 +273,7 @@
 	"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 defult '0'"						// 自動録画のモード02/23/2010追加
+	"autorec_mode integer not null default '0',".						// 自動録画のモード02/23/2010追加
+	"weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'"		// 曜日
 );
 ?>
\ No newline at end of file