master

分支 (2)

管理

管理

master

development

lowcode-demo
/
db
/
init_data.sql



#
# ATTENTION:
# Customize this section for your installation.
# Recommended changes include:
#   New admin username -> replace {admin}
#   New admin password -> replace {passwd]
#   New admin email -> replace {admin@example.com}
#

INSERT INTO `dot_user` VALUES (1,1,'admin',MD5('passwd'),0,1,0,0,0,'');
INSERT INTO `dot_contact` (id, first_name, last_name, email)
VALUES (1,'Admin','Person','admin@example.com');

INSERT INTO `dot_permission` VALUES (1,1,'all',-1, -1);

INSERT INTO `dot_user_preference` VALUES('0', 'LOCALE', 'en');
INSERT INTO `dot_user_preference` VALUES('0', 'TABVIEW', '0');
INSERT INTO `dot_user_preference` VALUES('0', 'SHDATEFORMAT', '%d/%m/%Y');
INSERT INTO `dot_user_preference` VALUES('0', 'TIMEFORMAT', '%I:%M %p');
INSERT INTO `dot_user_preference` VALUES('0', 'UISTYLE', 'default');
INSERT INTO `dot_user_preference` VALUES('0', 'TASKASSIGNMAX', '100');
INSERT INTO `dot_user_preference` VALUES('0', 'USERFORMAT', 'user');
INSERT INTO `dot_user_preference` VALUES('0', 'USEDIGESTS', '0');


#
# Dumping data for table 'modules'
#
INSERT INTO `dot_module` VALUES("1", "Company", "company", "1.0.0", "", "core", "1", "Companies", "handshake.png", "1", "1", "", "companies", "id", "name");
INSERT INTO `dot_module` VALUES("2", "Project", "project", "1.0.0", "", "core", "1", "Projects", "applet3-48.png", "2", "1", "", "projects", "id", "name");
INSERT INTO `dot_module` VALUES("3", "Task", "task", "1.0.0", "", "core", "1", "Task", "applet-48.png", "3", "1", "", "task", "id", "name");
INSERT INTO `dot_module` VALUES("4", "Calendar", "calendar", "1.0.0", "", "core", "1", "Calendar", "myevo-appointments.png", "4", "1", "", "event", "id", "title");
INSERT INTO `dot_module` VALUES("5", "File", "file", "1.0.0", "", "core", "1", "File", "folder5.png", "5", "1", "", "file", "id", "name");
INSERT INTO `dot_module` VALUES("6", "Contact", "contact", "1.0.0", "", "core", "1", "Contact", "monkeychat-48.png", "6", "1", "", "contact", "id", "title");
INSERT INTO `dot_module` VALUES("7", "Forum", "forum", "1.0.0", "", "core", "1", "Forum", "support.png", "7", "1", "", "forum", "id", "name");
INSERT INTO `dot_module` VALUES("8", "Ticket", "ticketsmith", "1.0.0", "", "core", "1", "Ticket", "ticketsmith.gif", "8", "1", "", "", "", "");
INSERT INTO `dot_module` VALUES("9", "User Administration", "admin", "1.0.0", "", "core", "1", "User Admin", "helix-setup-users.png", "9", "1", "", "user", "id", "username");
INSERT INTO `dot_module` VALUES("10", "System Administration", "system", "1.0.0", "", "core", "1", "System Admin", "48_my_computer.png", "10", "1", "", "", "", "");
INSERT INTO `dot_module` VALUES("11", "Department", "department", "1.0.0", "", "core", "1", "Department", "users.gif", "11", "0", "", "department", "id", "name");
INSERT INTO `dot_module` VALUES("12", "Help", "help", "1.0.0", "", "core", "1", "Help", "dp.gif", "12", "0", "", "", "", "");
INSERT INTO `dot_module` VALUES("13", "Public", "public", "1.0.0", "", "core", "1", "Public", "users.gif", "13", "0", "", "", "", "");

#
# Table structure for table 'sysval'
#

INSERT INTO `dot_syskey` VALUES (1, "SelectList", "Enter values for list", "0", "\n", "|");
INSERT INTO `dot_syskey` VALUES (2, 'CustomField', "Serialized array in the following format:\r\n<KEY>|<SERIALIZED ARRAY>\r\n\r\nSerialized Array:\r\n[type] => text | checkbox | select | textarea | label\r\n[name] => <Field\'s name>\r\n[options] => <html capture options>\r\n[selects] => <options for select and checkbox>", 0, '\n', '|');
INSERT INTO `dot_syskey` VALUES (3, "ColorSelection", "Hex color values for type=>color association.", "0", "\n", "|");

INSERT INTO `dot_sysval` (`key_id`,`title`,`value`) VALUES (1, "ProjectStatus", "0|Not Defined\r\n1|Proposed\r\n2|In Planning\r\n3|In Progress\r\n4|On Hold\r\n5|Complete\r\n6|Template\r\n7|Archived");
INSERT INTO `dot_sysval` (`key_id`,`title`,`value`) VALUES (1, "CompanyType", "0|Not Applicable\n1|Client\n2|Vendor\n3|Supplier\n4|Consultant\n5|Government\n6|Internal");
INSERT INTO `dot_sysval` (`key_id`,`title`,`value`) VALUES (1, "TaskDurationType", "1|hours\n24|days");
INSERT INTO `dot_sysval` (`key_id`,`title`,`value`) VALUES (1, "EventType", "0|General\n1|Appointment\n2|Meeting\n3|All Day Event\n4|Anniversary\n5|Reminder");
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TaskStatus', '0|Active\n-1|Inactive');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TaskType', '0|Unknown\n1|Administrative\n2|Operative');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'ProjectType', '0|Unknown\n1|Administrative\n2|Operative');
INSERT INTO `dot_sysval` (`key_id`,`title`,`value`) VALUES(3, "ProjectColors", "Web|FFE0AE\nEngineering|AEFFB2\nHelpDesk|FFFCAE\nSystem Administration|FFAEAE");
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'FileType', '0|Unknown\n1|Document\n2|Application');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TaskPriority', '-1|low\n0|normal\n1|high');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'ProjectPriority', '-1|low\n0|normal\n1|high');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'ProjectPriorityColor', '-1|#E5F7FF\n0|\n1|#FFDCB3');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TaskLogReference', '0|Not Defined\n1|Email\n2|Helpdesk\n3|Phone Call\n4|Fax');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TaskLogReferenceImage', '0| 1|./images/obj/email.gif 2|./modules/helpdesk/images/helpdesk.png 3|./images/obj/phone.gif 4|./images/icons/stock_print-16.png');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'UserType', '0|Default User\r\n1|Administrator\r\n2|CEO\r\n3|Director\r\n4|Branch Manager\r\n5|Manager\r\n6|Supervisor\r\n7|Employee');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'ProjectRequiredFields', 'f.project_name.value.length|<3\r\nf.project_color_identifier.value.length|<3\r\nf.project_company.options[f.project_company.selectedIndex].value|<1' );
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 2, 'TicketNotify', '0|admin@example.com\n1|admin@example.com\n2|admin@example.com\r\n3|admin@example.com\r\n4|admin@example.com');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TicketPriority', '0|Low\n1|Normal\n2|High\n3|Highest\n4|911');
INSERT INTO `dot_sysval` ( `id` , `key_id` , `title` , `value` ) VALUES (null, 1, 'TicketStatus', '0|Open\n1|Closed\n2|Deleted');


#
# Dumping data for table `config`
#

INSERT INTO `dot_config` VALUES (0, 'host_locale', 'en', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'check_overallocation', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'currency_symbol', '$', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'host_style', 'default', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'company_name', 'My Company', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'page_title', 'dotProject', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'site_domain', 'example.com', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'email_prefix', '[dotProject]', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'admin_username', 'admin', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'username_min_len', '4', 'auth', 'text');
INSERT INTO `dot_config` VALUES (0, 'password_min_len', '4', 'auth', 'text');
INSERT INTO `dot_config` VALUES (0, 'enable_gantt_charts', 'true', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'log_changes', 'false', '', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'check_task_dates', 'true', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'check_task_empty_dynamic', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'locale_warn', 'false', 'ui', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'locale_alert', '^', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'daily_working_hours', '8.0', 'tasks', 'text');
INSERT INTO `dot_config` VALUES (0, 'display_debug', 'false', 'ui', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'link_tickets_kludge', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'show_all_task_assignees', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'direct_edit_assignment', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'restrict_color_selection', 'false', 'ui', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'cal_day_view_show_minical', 'true', 'calendar', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'cal_day_start', '8', 'calendar', 'text');
INSERT INTO `dot_config` VALUES (0, 'cal_day_end', '17', 'calendar', 'text');
INSERT INTO `dot_config` VALUES (0, 'cal_day_increment', '15', 'calendar', 'text');
INSERT INTO `dot_config` VALUES (0, 'cal_working_days', '1,2,3,4,5', 'calendar', 'text');
INSERT INTO `dot_config` VALUES (0, 'restrict_task_time_editing', 'false', 'tasks', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'default_view_m', 'calendar', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'default_view_a', 'day_view', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'default_view_tab', '1', 'ui', 'text');
INSERT INTO `dot_config` VALUES (0, 'index_max_file_size', '-1', 'file', 'text');
INSERT INTO `dot_config` VALUES (0, 'session_handling', 'app', 'session', 'select');
INSERT INTO `dot_config` VALUES (0, 'session_idle_time', '2d', 'session', 'text');
INSERT INTO `dot_config` VALUES (0, 'session_max_lifetime', '1m', 'session', 'text');
INSERT INTO `dot_config` VALUES (0, 'debug', '1', '', 'text');
INSERT INTO `dot_config` VALUES (0, 'parser_default', '/usr/bin/strings', 'file', 'text');
INSERT INTO `dot_config` VALUES (0, 'parser_application/msword', '/usr/bin/strings', 'file', 'text');
INSERT INTO `dot_config` VALUES (0, 'parser_text/html', '/usr/bin/strings', 'file', 'text');
INSERT INTO `dot_config` VALUES (0, 'parser_application/pdf', '/usr/bin/pdftotext', 'file', 'text');

# 20050222
# moved new config variables by cyberhorse from config-php to a new table
INSERT INTO `dot_config` VALUES (0, 'files_ci_preserve_attr', 'true', 'file', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'files_show_versions_edit', 'false', 'file', 'checkbox');

# 20050302
# ldap system config variables
INSERT INTO `dot_config` VALUES (0, 'auth_method', 'sql', 'auth', 'select');
INSERT INTO `dot_config` VALUES (0, 'ldap_host', 'localhost', 'ldap', 'text');
INSERT INTO `dot_config` VALUES (0, 'ldap_port', '389', 'ldap', 'text');
INSERT INTO `dot_config` VALUES (0, 'ldap_version', '3', 'ldap', 'text');
INSERT INTO `dot_config` VALUES (0, 'ldap_base_dn', 'dc=saki,dc=com,dc=au', 'ldap', 'text');
INSERT INTO `dot_config` VALUES (0, 'ldap_user_filter', '(uid=%USERNAME%)', 'ldap', 'text');

# 20050302
# PostNuke authentication variables
INSERT INTO `dot_config` VALUES (0, 'postnuke_allow_login', 'true', 'auth', 'checkbox');

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'sql'
	FROM dot_config
	WHERE name = 'auth_method';

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'ldap'
	FROM dot_config
	WHERE name = 'auth_method';

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'pn'
	FROM dot_config
	WHERE name = 'auth_method';

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'app'
	FROM dot_config
	WHERE name = 'session_handling';

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'php'
	FROM dot_config
	WHERE name = 'session_handling';

# 20050405 - temporarily reset the memory limit for gantt charts
INSERT INTO `dot_config` VALUES (0, 'reset_memory_limit', '32M', 'tasks', 'text');

# 20050303
# New mail handling options
INSERT INTO `dot_config` VALUES (0, 'mail_transport', 'php', 'mail', 'select');
INSERT INTO `dot_config` VALUES (0, 'mail_host', 'localhost', 'mail', 'text');
INSERT INTO `dot_config` VALUES (0, 'mail_port', '25', 'mail', 'text');
INSERT INTO `dot_config` VALUES (0, 'mail_auth', 'false', 'mail', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'mail_user', '', 'mail', 'text');
INSERT INTO `dot_config` VALUES (0, 'mail_pass', '', 'mail', 'password');
INSERT INTO `dot_config` VALUES (0, 'mail_defer', 'false', 'mail', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'mail_timeout', '30', 'mail', 'text');

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'php'
	FROM dot_config
	WHERE name = 'mail_transport';

INSERT INTO dot_config_list (`config_id`, `name`)
  SELECT id as config_id, 'smtp'
	FROM dot_config
	WHERE name = 'mail_transport';

# 20050303
# Queue scanning on garbage collection
INSERT INTO dot_config VALUES (NULL, 'session_gc_scan_queue', 'false', 'session', 'checkbox');

# 20060321
# Backport of task reminders.
INSERT INTO `dot_config` VALUES (0, 'task_reminder_control', 'false', 'task_reminder', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'task_reminder_days_before', '1', 'task_reminder', 'text');
INSERT INTO `dot_config` VALUES (0, 'task_reminder_repeat', '100', 'task_reminder', 'text');

# 20080702
# GACL Caching options
INSERT INTO dot_config VALUES
(NULL, 'gacl_cache', 'false', 'gacl', 'checkbox'),
(NULL, 'gacl_expire', 'true', 'gacl', 'checkbox'),
(NULL, 'gacl_cache_dir', '/tmp', 'gacl', 'text'),
(NULL, 'gacl_timeout', '600', 'gacl', 'text');

# 20090427
# adding config value to toggle use of TLS in SMTP connections
INSERT INTO `dot_config` (`id`, `name`, `value`, `_group`, `type`)
VALUES (0, 'mail_smtp_tls', 'false', 'mail', 'checkbox');


INSERT INTO dot_dpversion VALUES ('2.1.8', 2, '2013-01-05', '2013-07-27');

# 20050307
# Additional LDAP search user and search password fields for Active Directory compatible LDAP authentication
INSERT INTO `dot_config` VALUES (0, 'ldap_search_user', 'Manager', 'ldap', 'text');
INSERT INTO `dot_config` VALUES (0, 'ldap_search_pass', 'secret', 'ldap', 'password');
INSERT INTO `dot_config` VALUES (0, 'ldap_allow_login', 'true', 'ldap', 'checkbox');


# 20101216
# Manage contacts properly
INSERT INTO `dot_config` VALUES (0, 'user_contact_inactivate', 'true', 'auth', 'checkbox');
INSERT INTO `dot_config` VALUES (0, 'user_contact_activate', 'false', 'auth', 'checkbox');

# 20130105
INSERT INTO `dot_config` VALUES (0, 'task_reminder_batch', 'false', 'task_reminder', 'checkbox');