function CheckTables()
{
if (!config_get('check-database')) {
return;
}
db_create_table_safe('tester_contests', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'lid' => 'INT', 'status' => 'INT', 'settings' => 'TEXT NOT NULL DEFAULT ""'));
}
function file_check_tables()
{
if (config_get('check-database')) {
if (!db_table_exists('files')) {
db_create_table_safe('files', array('id' => 'INT NOT NULL ' . 'PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'orig_name' => 'TEXT', 'access' => 'INT', 'blocked' => 'BOOL'));
}
}
}
function CheckTables()
{
if (!config_get('check-database')) {
return;
}
if (!db_table_exists('market_basket')) {
db_create_table_safe('market_basket', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'user_id' => 'INT', 'session_id' => 'TEXT DEFAULT ""', 'item_id' => 'INT', 'timestamp' => 'INT'));
}
}
function wiki_initialize()
{
if (config_get('check-database')) {
if (!db_table_exists('content')) {
db_create_table_safe('content', array('id' => 'INT NOT NULL PRIMARY ' . 'KEY AUTO_INCREMENT', 'order' => 'INT', 'pid' => 'INT DEFAULT 1', 'class' => 'TEXT', 'name' => 'TEXT', 'path' => 'TEXT', 'settings' => 'TEXT DEFAULT ""'));
db_insert('content', array('order' => '1', 'pid' => '0', 'name' => '"Корневой раздел"', 'path' => '"/"', 'settings' => '"' . addslashes('a:1:{s:8:"security";a:1:' . '{s:3:"ALL";a:2:{s:5:"order";s:10:"allow_deny";s:4:"acts";' . 'a:1:{i:0;a:2:{s:3:"act";s:8:"AllowAll";s:3:"val";' . 's:0:"";}}}}}') . '"'));
}
}
}
function CheckTables()
{
if (!config_get('check-database')) {
return;
}
if (!db_table_exists('tester')) {
db_create_table_safe('tester', array('security' => 'TEXT DEFAULT ""', 'content' => 'TEXT DEFAULT ""'));
db_insert('tester', array('security' => '"' . serialize(array()) . '"', 'content' => '"' . serialize(array()) . '"'));
}
if (!db_table_exists('tester_problems')) {
db_create_table_safe('tester_problems', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'lid' => 'INT', 'name' => 'TEXT DEFAULT ""', 'description' => 'LONGTEXT DEFAULT ""', 'settings' => 'LONGTEXT DEFAULT ""', 'uploaded' => 'INT DEFAULT 0'));
manage_settings_create('Количество задач на странице редактирования', 'Олимпиады', 'WT_problems_per_page', 'CSCNumber');
manage_settings_create('Количество задач на странице браузера', 'Олимпиады', 'WT_problems_per_browser_page', 'CSCNumber');
manage_settings_create('Количество записей на странице статуса', 'Олимпиады', 'WT_items_per_status_page', 'CSCNumber');
opt_set('WT_problems_per_page', 15);
opt_set('WT_problems_per_browser_page', 10);
opt_set('WT_items_per_status_page', 15);
manage_setting_use('WT_problems_per_page');
manage_setting_use('WT_items_per_status_page');
manage_setting_use('WT_problems_per_browser_page');
}
if (!db_table_exists('tester_tasks')) {
db_create_table_safe('tester_tasks', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'contest_id' => 'INT', 'problem_id' => 'INT', 'letter' => 'INT', 'catid' => 'INT DEFAULT 0', 'settings' => 'LONGTEXT DEFAULT ""'));
}
if (!db_table_exists('tester_checkers')) {
db_create_table_safe('tester_checkers', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'LONGTEXT', 'uploaded' => 'BOOL DEFAULT 0', 'settings' => 'LONGTEXT DEFAULT ""'));
}
if (!db_table_exists('tester_solutions')) {
db_create_table_safe('tester_solutions', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'lid' => 'INT', 'contest_id' => 'INT', 'problem_id' => 'INT', 'user_id' => 'INT', 'timestamp' => 'INT', 'status' => 'INT', 'parameters' => 'LONGTEXT DEFAULT ""', 'errors' => 'TEXT', 'points' => 'INT', 'ignored' => 'BOOL DEFAULT 0'));
}
if (!db_table_exists('tester_contestgroup')) {
db_create_table_safe('tester_contestgroup', array('contest_id' => 'INT', 'group_id' => 'INT'));
}
if (!db_table_exists('tester_judgegroup')) {
db_create_table_safe('tester_judgegroup', array('contest_id' => 'INT', 'group_id' => 'INT'));
}
if (!db_table_exists('tester_disabled_problems')) {
db_create_table_safe('tester_disabled_problems', array('contest_id' => 'INT', 'problem_id' => 'INT'));
}
if (!db_table_exists('tester_tags_dict')) {
db_create_table_safe('tester_tags_dict', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'tag' => 'TEXT'));
}
if (!db_table_exists('tester_problem_tags')) {
db_create_table_safe('tester_problem_tags', array('problem_id' => 'INT', 'tag_id' => 'INT'));
}
}
function manage_check_tables()
{
db_create_table_safe('datatypes', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'class' => 'TEXT', 'refcount' => 'INT DEFAULT 0', 'settings' => 'TEXT DEFAULT ""'));
db_create_table_safe('dataset', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'refcount' => 'INT DEFAULT 0'));
db_create_table_safe('dataset_assoc', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'order' => 'INT', 'dataset' => 'INT', 'datatype' => 'INT', 'title' => 'TEXT', 'field' => 'TEXT', 'settings' => 'TEXT DEFAULT ""'));
if (!db_table_exists('settings')) {
db_create_table('settings', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'section' => 'TEXT', 'name' => 'TEXT', 'ident' => 'TEXT', 'class' => 'TEXT', 'used' => 'INT DEFAULT 0', 'settings' => 'TEXT DEFAULT ""'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Максимальная длина логина пользователя"', 'ident' => '"max_user_login_len"', 'class' => '"CSCNumber"', 'settings' => '"' . addslashes('a:1:{s:5:"value";s:2:"14";}') . '"', 'used' => '1'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Максимальная длина имени пользователя"', 'ident' => '"max_user_name_len"', 'class' => '"CSCNumber"', 'settings' => '"' . addslashes('a:1:{s:5:"value";s:2:"32";}') . '"', 'used' => '1'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Максимальная длина пароля пользователя"', 'ident' => '"max_user_passwd_len"', 'class' => '"CSCNumber"', 'settings' => '"' . addslashes('a:1:{s:5:"value";s:2:"16";}') . '"', 'used' => '1'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Количество записей на странице «Пользователи и группы»"', 'ident' => '"user_count"', 'class' => '"CSCNumber"', 'settings' => '"' . addslashes('a:1:{s:5:"value";s:2:"15";}') . '"', 'used' => '1'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Блокировать сайт"', 'ident' => '"site_lock"', 'class' => '"CSCCheckBox"', 'settings' => '"' . addslashes('a:1:{s:5:"value";b:0;}') . '"', 'used' => '1'));
db_insert('settings', array('section' => '"Системные"', 'name' => '"Стартовый каталог"', 'ident' => '"start_root"', 'class' => '"CSCText"', 'settings' => '"' . addslashes('a:1:{s:5:"value";s:1:"/";}') . '"', 'used' => '1'));
}
db_create_table_safe('storage', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'path' => 'TEXT', 'refcount' => 'INT DEFAULT 0'));
if (!db_table_exists('templates')) {
db_create_table_safe('templates', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'text' => 'LONGTEXT', 'refcount' => 'INT DEFAULT 0', 'settings' => 'TEXT DEFAULT ""'));
}
manage_template_register_default();
}
function content_initialize()
{
if (config_get('check-database')) {
db_create_table_safe('content_support_tables', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'content_id' => 'INT', 'dataset_id' => 'INT', 'unique' => 'INT DEFAULT -1'));
}
}
function security_initialize()
{
if (config_get('check-database')) {
if (!db_table_exists('user')) {
db_create_table('user', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'login' => 'TEXT', 'password' => 'TEXT', 'access' => 'INT', 'email' => 'TEXT', 'authorized' => 'BOOL', 'timestamp' => 'INT DEFAULT 0', 'last_act' => 'INT DEFAULT 0', 'settings' => 'TEXT DEFAULT ""'));
db_insert('user', array('name' => '"root"', 'login' => '"root"', 'password' => 'MD5("root#RANDOM_SEED#assword")', 'access' => '7', 'authorized' => '1', 'settings' => '""', 'email' => '"postmaster@localhost"'));
}
db_create_table_safe('group', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'default' => 'INT', 'refcount' => 'INT DEFAULT 0', 'settings' => 'TEXT DEFAULT ""'));
db_create_table_safe('usergroup', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'user_id' => 'INT', 'group_id' => 'INT'));
}
}
function CreateTables()
{
if (config_get('check-database')) {
if (!db_table_exists('tester_categories')) {
db_create_table_safe('tester_categories', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'order' => 'INT', 'contest_id' => 'INT', 'name' => 'TEXT'));
}
}
}
function service_checktables()
{
if (!db_table_exists('service')) {
db_create_table_safe('service', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'name' => 'TEXT', 'sclass' => 'TEXT', 'settings' => 'TEXT DEFAULT ""'));
}
}
function Create()
{
db_create_table_safe('log', array('id' => 'INT NOT NULL PRIMARY KEY AUTO_INCREMENT', 'timestamp' => 'INT', 'module' => 'TEXT', 'status' => 'TEXT', 'message' => 'TEXT'));
$this->ReceiveSettings();
$this->AppendEntry('CORE', 'MESSAGE', 'Подключен сервис журналирования');
}
