# HG changeset patch # User yoneda # Date 1268483847 -32400 # Node ID f854f6606fa5aa5a5b884e7424d55b0cf600572a # Parent 3bed74eca373826bd08cce7f33df0d30341028b0 mod: DBテーブル構造をconfig.phpから切り離した diff -r 3bed74eca373 -r f854f6606fa5 config.php.sample --- a/config.php.sample Sat Mar 13 16:45:29 2010 +0900 +++ b/config.php.sample Sat Mar 13 21:37:27 2010 +0900 @@ -223,76 +223,5 @@ define( "CATEGORY_TBL", "categoryTbl" ); // 眼若 define( "KEYWORD_TBL", "keywordTbl" ); // 若若若 -// 篋膣若 -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',". // ｃ潟 - "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',". // ｃ潟 - "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菴遵 -); - -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',". // 罩ｈ頫憗篏睡1 - "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 diff -r 3bed74eca373 -r f854f6606fa5 install/step3.php --- a/install/step3.php Sat Mar 13 16:45:29 2010 +0900 +++ b/install/step3.php Sat Mar 13 21:37:27 2010 +0900 @@ -4,6 +4,7 @@ include_once("../DBRecord.class.php"); include_once("../Settings.class.php"); include_once("../reclib.php" ); +include_once("../tableStruct.inc.php"); $settings = Settings::factory(); $settings->post(); // ｃ篆絖 diff -r 3bed74eca373 -r f854f6606fa5 tableStruct.inc.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/tableStruct.inc.php Sat Mar 13 21:37:27 2010 +0900 @@ -0,0 +1,82 @@ +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',". // ｃ潟 + "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'". // ｃ潟鴻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',". // 罩ｈ頫憗篏睡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菴遵 + "" +); + +?> \ No newline at end of file