view tableStruct.inc.php @ 136:6754b6aa50cf

mod: ログ機能のためにconfig.phpを変更
author epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp>
date Sun, 21 Mar 2010 00:00:58 +0900
parents 9c5e597ef6c6
children 481e789605e3
line wrap: on
line source

<?php
// 若帥若鴻若絎臂


// 篋膣若
define( "RESERVE_STRUCT", 
	"id integer not null auto_increment primary key,".				// ID
	"channel_disc varchar(128) not null default 'none',".			// channel disc
	"channel_id integer not null  default '0',".					// channel ID
	"program_id integer not null default '0',".						// Program ID
	"type varchar(8) not null default 'GR',".						// 腮ワGR/BS/CS鐚
	"channel varchar(10) not null default '0',".					// c潟
	"title varchar(512) not null default 'none',".					// 帥ゃ
	"description varchar(512) not null default 'none',".			// 茯 text->varchar
	"category_id integer not null default '0',".					// 眼ID
	"starttime datetime not null default '1970-01-01 00:00:00',".	// 紮
	"endtime datetime not null default '1970-01-01 00:00:00',".		// 腟篋
	"job integer not null default '0',".							// job
	"path blob default null,".										// 牙祉<ゃ
	"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',".							// 牙祉≪若
	"index reserve_ch_idx (channel_disc),".							// ゃ潟
	"index reserve_st_idx (starttime)".
	""
);


// 腟茵若
define( "PROGRAM_STRUCT",
	"id integer not null auto_increment primary key,".				// ID
	"channel_disc varchar(128) not null default 'none',".			// channel disc
	"channel_id integer not null default '0',".						// channel ID
	"type varchar(8) not null default 'GR',".						// 腮ワGR/BS/CS鐚
	"channel varchar(10) not null default '0',".					// c潟
	"title varchar(512) not null default 'none',".					// 帥ゃ
	"description varchar(512) not null default 'none',".			// 茯 text->varchar
	"category_id integer not null default '0',".					// 眼ID
	"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',".						// 牙紙合≦
	"index program_ch_idx (channel_disc),".							// ゃ潟
	"index program_st_idx (starttime)".
	""
);


define( "CHANNEL_STRUCT",
	"id integer not null auto_increment primary key,".				// ID
	"type varchar(8) not null default 'GR',".						// 腮
	"channel varchar(10) not null default '0',".					// channel
	"name varchar(512) not null default 'none',".					// 茵腓阪
	"channel_disc varchar(128) not null default 'none',".			// 茘ョhash
	"sid varchar(64) not null default 'hd',".						// 泣若ID02/23/2010菴遵
	"skip boolean not null default '0'".							// c潟鴻03/13/2010菴遵
	""
);

define( "CATEGORY_STRUCT",
	"id integer not null auto_increment primary key,".				// ID
	"name_jp varchar(512) not null default 'none',".				// 茵腓阪
	"name_en varchar(512) not null default 'none',".				// 筝
	"category_disc varchar(128) not null default 'none'"			// 茘ョhash
);


define( "KEYWORD_STRUCT",
	"id integer not null auto_increment primary key,".				// ID
	"keyword varchar(512) not null default '*',".					// 茵腓阪
	"type varchar(8) not null default '*',".						// 腮
	"channel_id integer not null default '0',".						// channel ID
	"category_id integer not null default '0',".					// 眼ID
	"use_regexp boolean not null default '0',".						// 罩h頫憗篏睡1
	"autorec_mode integer not null default '0',".					// 牙祉≪若02/23/2010菴遵
	"weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'".// ャ菴遵
	",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菴遵
	""
);

define( "LOG_STRUCT",
	"id integer not null auto_increment primary key".				// ID
	",logtime  datetime not null default '1970-01-01 00:00:00'".	// 荐我ユ
	",level integer not null default '0'".							// 若
	",message varchar(512) not null default ''".
	""
);

?>