|
114
|
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
|
|
115
|
23 "mode integer not null default '0',". // 牙祉≪若
|
|
114
|
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 ?> |
