Файл: sys/preinstall/base.create.advertising.ini
Строк: 106
; saved by ini.class.php
[`id`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL";
ai =
"AUTO_INCREMENT";
comment = "";
[`space`]
type =
"varchar(32)";
default_and_null = "NOT NULL";
ai =
"";
comment = "";
[`url_link`]
type =
"varchar(1024)";
default_and_null = "NOT NULL";
ai =
"";
comment = "";
[`name`]
type =
"varchar(64)";
default_and_null = "NOT NULL";
ai =
"";
comment = "";
[`url_img`]
type =
"varchar(1024)";
default_and_null = "NOT NULL";
ai =
"";
comment = "";
[`page_main`]
type =
"enum('0','1')";
default_and_null
= "NOT NULL DEFAULT '1'";
ai =
"";
comment = "";
[`page_other`]
type =
"enum('0','1')";
default_and_null
= "NOT NULL DEFAULT '1'";
ai =
"";
comment = "";
[`time_create`]
type =
"int(10) unsigned";
default_and_null = "NOT NULL";
ai
= "";
comment = "COMMENT 'Время
добавления'";
[`time_start`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL";
ai =
"";
comment = "COMMENT 'Время начала
показа'";
[`time_end`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL";
ai =
"";
comment = "COMMENT 'Время
завершения показа'";
[`bold`]
type =
"enum('0','1')";
default_and_null
= "NOT NULL DEFAULT '0'";
ai =
"";
comment = "COMMENT 'Жирный
шрифт'";
[`count_show_light`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
показов'";
[`count_out_light`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
переходов'";
[`count_show_full`]
type =
"int(10) unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
показов'";
[`count_out_full`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
переходов'";
[`count_show_mobile`]
type =
"int(10) unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
показов'";
[`count_out_mobile`]
type = "int(10)
unsigned";
default_and_null = "NOT NULL DEFAULT
'0'";
ai = "";
comment = "COMMENT
'Количество
переходов'";
[PRIMARY KEY]
fields =
"`id`";
[KEY `space`]
fields = "`space`";
[KEY
`time_start`]
fields = "`time_start`, `time_end`";
[KEY
`url_link`]
fields = "`url_link`";
[~TABLE~PROPERTIES~]
name =
"advertising";
engine =
"ENGINE=MyISAM";
auto_increment =
"AUTO_INCREMENT=1";
comment =
"COMMENT='реклама'";