芝麻web文件管理V1.00
编辑当前文件:/home/shaabmuni/www/public/migrations.tar
2016_02_16_140450_create_banlist_table.php 0000644 00000001247 14756622514 0013517 0 ustar 00 increments('id'); $table->boolean('ban_status'); $table->string('email_address'); $table->string('internal_notes'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('banlist'); } } 2016_02_16_140450_create_emails_table.php 0000644 00000004127 14756622514 0013335 0 ustar 00 increments('id'); $table->string('email_address'); $table->string('email_name'); $table->integer('department')->unsigned()->nullable(); $table->integer('priority')->unsigned()->nullable()->index('priority'); $table->integer('help_topic')->unsigned()->nullable()->index('help_topic'); $table->string('user_name'); $table->string('password'); $table->string('fetching_host'); $table->string('fetching_port'); $table->string('fetching_protocol'); $table->string('fetching_encryption'); $table->string('mailbox_protocol'); $table->string('imap_config'); $table->string('folder'); $table->string('sending_host'); $table->string('sending_port'); $table->string('sending_protocol'); $table->string('sending_encryption'); $table->string('smtp_validate'); $table->string('smtp_authentication'); $table->string('internal_notes'); $table->boolean('auto_response'); $table->boolean('fetching_status'); $table->boolean('move_to_folder'); $table->boolean('delete_email'); $table->boolean('do_nothing'); $table->boolean('sending_status'); $table->boolean('authentication'); $table->boolean('header_spoofing'); $table->timestamps(); $table->index(['department', 'priority', 'help_topic'], 'department'); $table->index(['department', 'priority', 'help_topic'], 'department_2'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('emails'); } } 2016_02_16_140450_create_version_check_table.php 0000644 00000001214 14756622514 0014677 0 ustar 00 increments('id'); $table->string('current_version'); $table->string('new_version'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('version_check'); } } 2016_02_16_140450_create_custom_form_fields_table.php 0000644 00000001443 14756622514 0015744 0 ustar 00 increments('id'); $table->integer('forms_id'); $table->string('label'); $table->string('name'); $table->string('type'); $table->string('value'); $table->string('required'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('custom_form_fields'); } } 2016_02_16_140450_create_ticket_status_table.php 0000644 00000001621 14756622514 0014745 0 ustar 00 increments('id'); $table->string('name'); $table->string('state'); $table->integer('mode'); $table->string('message'); $table->integer('flags'); $table->integer('sort'); $table->integer('email_user'); $table->string('icon_class'); $table->string('properties'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_status'); } } 2016_02_16_140450_create_plugins_table.php 0000644 00000001220 14756622514 0013533 0 ustar 00 increments('id'); $table->string('name'); $table->string('path'); $table->integer('status'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('plugins'); } } 2016_02_16_140450_create_ticket_collaborator_table.php 0000644 00000001471 14756622514 0016110 0 ustar 00 increments('id'); $table->boolean('isactive'); $table->integer('ticket_id')->unsigned()->nullable()->index('ticket_id'); $table->integer('user_id')->unsigned()->nullable()->index('user_id'); $table->string('role'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_collaborator'); } } 2016_03_31_061239_create_notifications_table.php 0000644 00000001263 14756622514 0014737 0 ustar 00 increments('id'); $table->integer('model_id'); $table->integer('userid_created'); $table->integer('type_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('notifications'); } } 2016_02_16_140450_create_ticket_thread_table.php 0000644 00000002304 14756622514 0014670 0 ustar 00 increments('id'); $table->integer('ticket_id')->unsigned()->nullable()->index('ticket_id_2'); $table->integer('user_id')->unsigned()->nullable()->index('user_id'); $table->string('poster'); $table->integer('source')->unsigned()->nullable()->index('source'); $table->integer('reply_rating'); $table->integer('rating_count'); $table->boolean('is_internal'); $table->string('title'); $table->text('body', 65535); $table->string('format'); $table->string('ip_address'); $table->timestamps(); }); \DB::statement('ALTER TABLE `ticket_thread` MODIFY `body` LONGBLOB'); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_thread'); } } 2016_02_16_140450_create_kb_article_relationship_table.php 0000644 00000001443 14756622514 0016741 0 ustar 00 increments('id'); $table->integer('article_id')->unsigned()->index('article_relationship_article_id_foreign'); $table->integer('category_id')->unsigned()->index('article_relationship_category_id_foreign'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_article_relationship'); } } 2016_02_16_140454_add_foreign_keys_to_organization_table.php 0000644 00000001334 14756622514 0017323 0 ustar 00 foreign('head', 'organization_ibfk_1')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('NO ACTION'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('organization', function (Blueprint $table) { $table->dropForeign('organization_ibfk_1'); }); } } 2016_02_16_140450_create_settings_system_table.php 0000644 00000002743 14756622514 0015331 0 ustar 00 increments('id'); $table->boolean('status'); $table->string('url'); $table->string('name'); $table->string('department'); $table->string('page_size'); $table->string('log_level'); $table->string('purge_log'); $table->integer('api_enable'); $table->integer('api_key_mandatory'); $table->string('api_key'); $table->string('name_format'); $table->integer('time_farmat')->unsigned()->nullable()->index('time_farmat'); $table->integer('date_format')->unsigned()->nullable()->index('date_format'); $table->integer('date_time_format')->unsigned()->nullable()->index('date_time_format'); $table->string('day_date_time'); $table->integer('time_zone')->unsigned()->nullable()->index('time_zone'); $table->string('content'); $table->string('version'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_system'); } } 2016_03_31_061740_create_user_notification_table.php 0000644 00000001276 14756622514 0015613 0 ustar 00 increments('id'); $table->integer('notification_id'); $table->integer('user_id'); $table->integer('is_read'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('user_notification'); } } 2016_02_16_140454_add_foreign_keys_to_help_topic_table.php 0000644 00000003311 14756622514 0016742 0 ustar 00 foreign('custom_form', 'help_topic_ibfk_1')->references('id')->on('custom_forms')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('department', 'help_topic_ibfk_2')->references('id')->on('department')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('ticket_status', 'help_topic_ibfk_3')->references('id')->on('ticket_status')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('priority', 'help_topic_ibfk_4')->references('priority_id')->on('ticket_priority')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('sla_plan', 'help_topic_ibfk_5')->references('id')->on('sla_plan')->onUpdate('RESTRICT')->onDelete('RESTRICT'); $table->foreign('auto_assign', 'help_topic_ibfk_6')->references('id')->on('users')->onUpdate('RESTRICT')->onDelete('SET NULL'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('help_topic', function (Blueprint $table) { $table->dropForeign('help_topic_ibfk_1'); $table->dropForeign('help_topic_ibfk_2'); $table->dropForeign('help_topic_ibfk_3'); $table->dropForeign('help_topic_ibfk_4'); $table->dropForeign('help_topic_ibfk_5'); $table->dropForeign('help_topic_ibfk_6'); }); } } 2016_06_02_094420_create_template_types_table.php 0000644 00000001131 14756622514 0015116 0 ustar 00 increments('id'); $table->string('name'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_types'); } } 2016_02_16_140450_create_widgets_table.php 0000644 00000001303 14756622514 0013522 0 ustar 00 integer('id', true); $table->string('name', 30)->nullable(); $table->string('title', 50)->nullable(); $table->text('value', 65535)->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('widgets'); } } 2016_02_16_140454_add_foreign_keys_to_ticket_thread_table.php 0000644 00000002167 14756622514 0017436 0 ustar 00 foreign('ticket_id', 'ticket_thread_ibfk_1')->references('id')->on('tickets')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('user_id', 'ticket_thread_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('source', 'ticket_thread_ibfk_3')->references('id')->on('ticket_source')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('ticket_thread', function (Blueprint $table) { $table->dropForeign('ticket_thread_ibfk_1'); $table->dropForeign('ticket_thread_ibfk_2'); $table->dropForeign('ticket_thread_ibfk_3'); }); } } 2016_02_16_140450_create_languages_table.php 0000644 00000001117 14756622514 0014025 0 ustar 00 increments('id'); $table->string('name'); $table->string('locale'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('languages'); } } 2016_02_16_140450_create_user_assign_organization_table.php 0000644 00000001364 14756622514 0017171 0 ustar 00 increments('id'); $table->integer('org_id')->unsigned()->nullable()->index('org_id'); $table->integer('user_id')->unsigned()->nullable()->index('user_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('user_assign_organization'); } } 2016_07_26_095020_create_queue_services_table.php 0000644 00000001344 14756622514 0015120 0 ustar 00 increments('id'); $table->string('name'); $table->string('short_name'); $table->integer('status'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('queue_services'); } } 2016_02_16_140454_add_foreign_keys_to_users_table.php 0000644 00000001577 14756622514 0015771 0 ustar 00 foreign('assign_group', 'users_ibfk_1')->references('id')->on('groups')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('primary_dpt', 'users_ibfk_2')->references('id')->on('department')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('users', function (Blueprint $table) { $table->dropForeign('users_ibfk_1'); $table->dropForeign('users_ibfk_2'); }); } } 2016_02_16_140454_add_foreign_keys_to_group_assign_department_table.php 0000644 00000001771 14756622514 0021547 0 ustar 00 foreign('group_id', 'group_assign_department_ibfk_1')->references('id')->on('groups')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('department_id', 'group_assign_department_ibfk_2')->references('id')->on('department')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('group_assign_department', function (Blueprint $table) { $table->dropForeign('group_assign_department_ibfk_1'); $table->dropForeign('group_assign_department_ibfk_2'); }); } } 2016_02_16_140450_create_timezone_table.php 0000644 00000001116 14756622514 0013710 0 ustar 00 increments('id'); $table->string('name'); $table->string('location'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('timezone'); } } 2016_02_16_140454_add_foreign_keys_to_user_assign_organization_table.php 0000644 00000001771 14756622514 0021732 0 ustar 00 foreign('org_id', 'user_assign_organization_ibfk_1')->references('id')->on('organization')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('user_id', 'user_assign_organization_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('user_assign_organization', function (Blueprint $table) { $table->dropForeign('user_assign_organization_ibfk_1'); $table->dropForeign('user_assign_organization_ibfk_2'); }); } } 2018_08_13_075015_alter_emails_table_make_username_column_nullable.php 0000644 00000001302 14756622514 0021331 0 ustar 00 string('user_name')->nullable()->change(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('emails', function (Blueprint $table) { $table->string('user_name')->nullable(false)->change(); }); } } 2016_02_16_140450_create_ticket_priority_table.php 0000644 00000001556 14756622514 0015312 0 ustar 00 increments('priority_id'); $table->string('priority'); $table->string('status'); $table->string('priority_desc'); $table->string('priority_color'); $table->boolean('priority_urgency'); $table->boolean('ispublic'); $table->string('is_default'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_priority'); } } 2016_02_16_140454_add_foreign_keys_to_kb_comment_table.php 0000644 00000001354 14756622514 0016737 0 ustar 00 foreign('article_id', 'comment_article_id_foreign')->references('id')->on('kb_article')->onUpdate('RESTRICT')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('kb_comment', function (Blueprint $table) { $table->dropForeign('comment_article_id_foreign'); }); } } 2016_06_02_080005_create_ratings_table.php 0000644 00000001446 14756622514 0013531 0 ustar 00 increments('id'); $table->string('name'); $table->integer('display_order'); $table->integer('allow_modification'); $table->integer('rating_scale'); $table->string('rating_area'); $table->string('restrict'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ratings'); } } 2016_02_16_140450_create_users_table.php 0000644 00000003545 14756622514 0013227 0 ustar 00 increments('id'); $table->string('user_name'); $table->string('first_name'); $table->string('last_name'); $table->boolean('gender'); $table->string('email')->nullable()->unique(); $table->boolean('ban'); $table->string('password', 60); $table->integer('active'); $table->boolean('is_delete')->default(0); $table->string('ext'); $table->integer('country_code'); $table->string('phone_number'); $table->string('mobile')->nullable()->unique(); $table->text('agent_sign', 65535); $table->string('account_type'); $table->string('account_status'); $table->integer('assign_group')->unsigned()->nullable()->index('assign_group_3'); $table->integer('primary_dpt')->unsigned()->nullable()->index('primary_dpt_2'); $table->string('agent_tzone'); $table->string('daylight_save'); $table->string('limit_access'); $table->string('directory_listing'); $table->string('vacation_mode'); $table->string('company'); $table->string('role'); $table->string('internal_note'); $table->string('profile_pic'); $table->string('remember_token', 100)->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('users'); } } 2016_05_10_102604_create_bar_notifications_table.php 0000644 00000001555 14756622514 0015556 0 ustar 00 increments('id'); $table->string('key'); $table->string('value'); $table->timestamps(); }); $version = \Config::get('app.version'); $date = date('Y-m-d H:i:s'); //\DB::table('bar_notifications')->insert(['key'=>'new-install','value'=>"Congrates ! You have installed $version",'created_at'=>$date]); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('bar_notifications'); } } 2016_06_02_081020_create_rating_ref_table.php 0000644 00000001324 14756622514 0014173 0 ustar 00 increments('id'); $table->integer('rating_id'); $table->integer('ticket_id'); $table->integer('thread_id'); $table->integer('rating_value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('rating_ref'); } } 2016_02_16_140450_create_date_time_format_table.php 0000644 00000001076 14756622514 0015366 0 ustar 00 increments('id'); $table->string('format'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('date_time_format'); } } 2016_02_16_140450_create_groups_table.php 0000644 00000002353 14756622514 0013401 0 ustar 00 increments('id'); $table->string('name'); $table->boolean('group_status'); $table->boolean('can_create_ticket'); $table->boolean('can_edit_ticket'); $table->boolean('can_post_ticket'); $table->boolean('can_close_ticket'); $table->boolean('can_assign_ticket'); $table->boolean('can_transfer_ticket'); $table->boolean('can_delete_ticket'); $table->boolean('can_ban_email'); $table->boolean('can_manage_canned'); $table->boolean('can_manage_faq'); $table->boolean('can_view_agent_stats'); $table->boolean('department_access'); $table->string('admin_notes'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('groups'); } } 2016_02_16_140450_create_team_assign_agent_table.php 0000644 00000001343 14756622514 0015530 0 ustar 00 increments('id'); $table->integer('team_id')->unsigned()->nullable()->index('team_id'); $table->integer('agent_id')->unsigned()->nullable()->index('agent_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('team_assign_agent'); } } 2016_02_16_140450_create_date_format_table.php 0000644 00000001060 14756622514 0014341 0 ustar 00 increments('id'); $table->string('format'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('date_format'); } } 2016_02_16_140450_create_settings_auto_response_table.php 0000644 00000001451 14756622514 0016666 0 ustar 00 increments('id'); $table->boolean('new_ticket'); $table->boolean('agent_new_ticket'); $table->boolean('submitter'); $table->boolean('participants'); $table->boolean('overlimit'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_auto_response'); } } 2016_02_16_140450_create_teams_table.php 0000644 00000001424 14756622514 0013171 0 ustar 00 increments('id'); $table->string('name'); $table->boolean('status'); $table->integer('team_lead')->unsigned()->nullable()->index('team_lead'); $table->boolean('assign_alert'); $table->string('admin_notes'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('teams'); } } 2016_02_16_140454_add_foreign_keys_to_settings_system_table.php 0000644 00000002564 14756622514 0020071 0 ustar 00 foreign('time_zone', 'settings_system_ibfk_1')->references('id')->on('timezone')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('time_farmat', 'settings_system_ibfk_2')->references('id')->on('time_format')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('date_format', 'settings_system_ibfk_3')->references('id')->on('date_format')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('date_time_format', 'settings_system_ibfk_4')->references('id')->on('date_time_format')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('settings_system', function (Blueprint $table) { $table->dropForeign('settings_system_ibfk_1'); $table->dropForeign('settings_system_ibfk_2'); $table->dropForeign('settings_system_ibfk_3'); $table->dropForeign('settings_system_ibfk_4'); }); } } 2016_06_02_090628_create_templates_table.php 0000644 00000001466 14756622514 0014076 0 ustar 00 increments('id'); $table->string('name'); $table->string('variable'); $table->integer('type'); $table->string('subject'); $table->text('message'); $table->string('description'); $table->integer('set_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('templates'); } } 2016_02_16_140450_create_ticket_attachment_table.php 0000644 00000001570 14756622514 0015555 0 ustar 00 increments('id'); $table->string('name'); $table->integer('thread_id')->unsigned()->nullable()->index('thread_id'); $table->string('size'); $table->string('type'); $table->string('poster'); $table->timestamps(); }); \DB::statement('ALTER TABLE `ticket_attachment` ADD `file` MEDIUMBLOB'); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_attachment'); } } 2016_02_16_140450_create_settings_alert_notice_table.php 0000644 00000004155 14756622514 0016454 0 ustar 00 increments('id'); $table->boolean('ticket_status'); $table->boolean('ticket_admin_email'); $table->boolean('ticket_department_manager'); $table->boolean('ticket_department_member'); $table->boolean('ticket_organization_accmanager'); $table->boolean('message_status'); $table->boolean('message_last_responder'); $table->boolean('message_assigned_agent'); $table->boolean('message_department_manager'); $table->boolean('message_organization_accmanager'); $table->boolean('internal_status'); $table->boolean('internal_last_responder'); $table->boolean('internal_assigned_agent'); $table->boolean('internal_department_manager'); $table->boolean('assignment_status'); $table->boolean('assignment_assigned_agent'); $table->boolean('assignment_team_leader'); $table->boolean('assignment_team_member'); $table->boolean('transfer_status'); $table->boolean('transfer_assigned_agent'); $table->boolean('transfer_department_manager'); $table->boolean('transfer_department_member'); $table->boolean('overdue_status'); $table->boolean('overdue_assigned_agent'); $table->boolean('overdue_department_manager'); $table->boolean('overdue_department_member'); $table->boolean('system_error'); $table->boolean('sql_error'); $table->boolean('excessive_failure'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_alert_notice'); } } 2016_02_16_140450_create_settings_company_table.php 0000644 00000001650 14756622514 0015447 0 ustar 00 increments('id'); $table->string('company_name'); $table->string('website'); $table->string('phone'); $table->string('address'); $table->string('landing_page'); $table->string('offline_page'); $table->string('thank_page'); $table->string('logo'); $table->string('use_logo'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_company'); } } 2016_08_12_104410_create_user_additional_infos_table.php 0000644 00000001352 14756622514 0016422 0 ustar 00 increments('id'); $table->integer('owner'); $table->string('service'); $table->string('key'); $table->string('value')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('user_additional_infos'); } } 2016_06_02_095357_create_ticket_token_table.php 0000644 00000001176 14756622514 0014565 0 ustar 00 increments('id'); $table->integer('ticket_id'); $table->string('token'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_token'); } } 2016_02_16_140454_add_foreign_keys_to_team_assign_agent_table.php 0000644 00000001703 14756622514 0020267 0 ustar 00 foreign('team_id', 'team_assign_agent_ibfk_1')->references('id')->on('teams')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('agent_id', 'team_assign_agent_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('team_assign_agent', function (Blueprint $table) { $table->dropForeign('team_assign_agent_ibfk_1'); $table->dropForeign('team_assign_agent_ibfk_2'); }); } } 2016_02_16_140450_create_settings_email_table.php 0000644 00000002105 14756622514 0015064 0 ustar 00 increments('id'); $table->string('template'); $table->string('sys_email')->nullable(); $table->string('alert_email'); $table->string('admin_email'); $table->string('mta'); $table->boolean('email_fetching'); $table->boolean('notification_cron'); $table->boolean('strip'); $table->boolean('separator'); $table->boolean('all_emails'); $table->boolean('email_collaborator'); $table->boolean('attachment'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_email'); } } 2016_08_08_095744_create_social_media_table.php 0000644 00000001237 14756622514 0014521 0 ustar 00 increments('id'); $table->string('provider'); $table->string('key'); $table->string('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('social_media'); } } 2016_02_16_140450_create_tickets_table.php 0000644 00000004410 14756622514 0013524 0 ustar 00 increments('id'); $table->string('ticket_number'); $table->integer('user_id')->unsigned()->nullable()->index('user_id'); $table->integer('dept_id')->unsigned()->nullable()->index('dept_id'); $table->integer('team_id')->unsigned()->nullable()->index('team_id'); $table->integer('priority_id')->unsigned()->nullable()->index('priority_id'); $table->integer('sla')->unsigned()->nullable()->index('sla'); $table->integer('help_topic_id')->unsigned()->nullable()->index('help_topic_id'); $table->integer('status')->unsigned()->nullable()->index('status'); $table->boolean('rating'); $table->boolean('ratingreply'); $table->integer('flags'); $table->integer('ip_address'); $table->integer('assigned_to')->unsigned()->nullable()->index('assigned_to'); $table->integer('lock_by'); $table->dateTime('lock_at')->nullable(); $table->integer('source')->unsigned()->nullable()->index('source'); $table->integer('isoverdue'); $table->integer('reopened'); $table->integer('isanswered'); $table->integer('html'); $table->integer('is_deleted'); $table->integer('closed'); $table->boolean('is_transferred'); $table->dateTime('transferred_at'); $table->dateTime('reopened_at')->nullable(); $table->dateTime('duedate')->nullable(); $table->dateTime('closed_at')->nullable(); $table->dateTime('last_message_at')->nullable(); $table->dateTime('last_response_at')->nullable(); $table->integer('approval'); $table->integer('follow_up'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('tickets'); } } 2016_02_16_140450_create_canned_response_table.php 0000644 00000001317 14756622514 0015227 0 ustar 00 increments('id'); $table->integer('user_id')->unsigned()->index('user_id'); $table->string('title'); $table->text('message', 65535); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('canned_response'); } } 2016_02_16_140450_create_settings_ratings_table.php 0000644 00000001343 14756622514 0015447 0 ustar 00 increments('id'); $table->string('rating_name'); $table->integer('publish'); $table->integer('modify'); $table->string('slug')->unique(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_ratings'); } } 2016_03_31_061534_create_notification_types_table.php 0000644 00000001266 14756622514 0016001 0 ustar 00 increments('id'); $table->string('message'); $table->string('type'); $table->string('icon_class'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('notification_types'); } } 2016_06_02_072210_create_common_settings_table.php 0000644 00000001343 14756622514 0015265 0 ustar 00 increments('id'); $table->string('option_name'); $table->string('option_value'); $table->string('status'); $table->string('optional_field'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('common_settings'); } } 2016_07_26_090201_create_faveo_queues_table.php 0000644 00000001242 14756622514 0014551 0 ustar 00 increments('id'); $table->integer('service_id'); $table->string('key'); $table->string('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('faveo_queues'); } } 2016_08_16_104539_alter_ticket_source_table.php 0000644 00000001326 14756622514 0014606 0 ustar 00 string('css_class'); } ); } } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('ticket_source', function (Blueprint $table) { // }); } } 2016_06_02_094409_create_template_sets_table.php 0000644 00000001175 14756622514 0014747 0 ustar 00 increments('id'); $table->string('name'); $table->integer('active'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('template_sets'); } } 2016_07_02_051439_create_failed_jobs_table.php 0000644 00000001270 14756622514 0014330 0 ustar 00 increments('id'); $table->text('connection'); $table->text('queue'); $table->longText('payload'); $table->timestamp('failed_at')->useCurrent(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('failed_jobs'); } } 2016_02_16_140450_create_log_notification_table.php 0000644 00000001136 14756622514 0015407 0 ustar 00 increments('id'); $table->string('log'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('log_notification'); } } 2016_02_16_140454_add_foreign_keys_to_canned_response_table.php 0000644 00000001355 14756622514 0017770 0 ustar 00 foreign('user_id', 'canned_response_ibfk_1')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('NO ACTION'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('canned_response', function (Blueprint $table) { $table->dropForeign('canned_response_ibfk_1'); }); } } 2016_02_16_140450_create_sla_plan_table.php 0000644 00000001435 14756622514 0013653 0 ustar 00 increments('id'); $table->string('name'); $table->string('grace_period'); $table->string('admin_note'); $table->boolean('status'); $table->boolean('transient'); $table->boolean('ticket_overdue'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('sla_plan'); } } 2016_05_11_105244_create_api_settings_table.php 0000644 00000001167 14756622514 0014555 0 ustar 00 increments('id'); $table->string('key'); $table->string('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('api_settings'); } } 2016_06_02_090225_create_settings_security_table.php 0000644 00000001463 14756622514 0015655 0 ustar 00 increments('id'); $table->string('lockout_message'); $table->integer('backlist_offender'); $table->integer('backlist_threshold'); $table->integer('lockout_period'); $table->integer('days_to_keep_logs'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_security'); } } 2016_02_16_140454_add_foreign_keys_to_department_table.php 0000644 00000001622 14756622514 0016762 0 ustar 00 foreign('sla', 'department_ibfk_1')->references('id')->on('sla_plan')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('manager', 'department_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('department', function (Blueprint $table) { $table->dropForeign('department_ibfk_1'); $table->dropForeign('department_ibfk_2'); }); } } 2016_02_16_140450_create_kb_category_table.php 0000644 00000001362 14756622514 0014352 0 ustar 00 increments('id'); $table->string('name'); $table->string('slug'); $table->text('description', 65535); $table->boolean('status'); $table->integer('parent'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_category'); } } 2016_02_16_140450_create_template_table.php 0000644 00000001371 14756622514 0013674 0 ustar 00 increments('id'); $table->string('name'); $table->boolean('status'); $table->string('template_set_to_clone'); $table->string('language'); $table->string('internal_note'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('template'); } } 2016_02_16_140454_add_foreign_keys_to_emails_table.php 0000644 00000002122 14756622514 0016065 0 ustar 00 foreign('department', 'emails_ibfk_1')->references('id')->on('department')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('priority', 'emails_ibfk_2')->references('priority_id')->on('ticket_priority')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('help_topic', 'emails_ibfk_3')->references('id')->on('help_topic')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('emails', function (Blueprint $table) { $table->dropForeign('emails_ibfk_1'); $table->dropForeign('emails_ibfk_2'); $table->dropForeign('emails_ibfk_3'); }); } } 2016_02_16_140450_create_department_table.php 0000644 00000002273 14756622514 0014226 0 ustar 00 increments('id'); $table->string('name'); $table->string('type'); $table->integer('sla')->unsigned()->nullable()->index('sla'); $table->integer('manager')->unsigned()->nullable()->index('manager_2'); $table->string('ticket_assignment'); $table->string('outgoing_email'); $table->string('template_set'); $table->string('auto_ticket_response'); $table->string('auto_message_response'); $table->string('auto_response_email'); $table->string('recipient'); $table->string('group_access'); $table->string('department_sign'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('department'); } } 2016_04_18_115900_create_workflow_rule_table.php 0000644 00000002231 14756622514 0014764 0 ustar 00 increments('id'); $table->integer('workflow_id')->unsigned(); $table->string('matching_criteria'); $table->string('matching_scenario'); $table->string('matching_relation'); $table->text('matching_value'); $table->timestamps(); }); Schema::table('workflow_rules', function (Blueprint $table) { $table->foreign('workflow_id', 'workflow_rules_1')->references('id')->on('workflow_name')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('workflow_rules', function (Blueprint $table) { $table->dropForeign('workflow_rules_1'); }); Schema::drop('workflow_rules'); } } 2016_07_26_094753_create_mail_services_table.php 0000644 00000001266 14756622514 0014735 0 ustar 00 increments('id'); $table->string('name'); $table->string('short_name'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('mail_services'); } } 2016_02_16_140450_create_group_assign_department_table.php 0000644 00000001351 14756622514 0017002 0 ustar 00 increments('id'); $table->integer('group_id')->unsigned()->index('group_id'); $table->integer('department_id')->unsigned()->index('department_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('group_assign_department'); } } 2016_02_16_140450_create_ticket_source_table.php 0000644 00000001131 14756622514 0014716 0 ustar 00 increments('id'); $table->string('name'); $table->string('value'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_source'); } } 2016_02_16_140454_add_foreign_keys_to_ticket_collaborator_table.php 0000644 00000001725 14756622514 0020651 0 ustar 00 foreign('ticket_id', 'ticket_collaborator_ibfk_1')->references('id')->on('tickets')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('user_id', 'ticket_collaborator_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('ticket_collaborator', function (Blueprint $table) { $table->dropForeign('ticket_collaborator_ibfk_1'); $table->dropForeign('ticket_collaborator_ibfk_2'); }); } } 2016_07_26_084458_create_faveo_mails_table.php 0000644 00000001302 14756622514 0014365 0 ustar 00 increments('id'); $table->integer('email_id'); $table->string('drive'); $table->string('key'); $table->string('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('faveo_mails'); } } 2016_02_16_140454_add_foreign_keys_to_kb_article_relationship_table.php 0000644 00000002042 14756622514 0021474 0 ustar 00 foreign('article_id', 'article_relationship_article_id_foreign')->references('id')->on('kb_article')->onUpdate('RESTRICT')->onDelete('RESTRICT'); $table->foreign('category_id', 'article_relationship_category_id_foreign')->references('id')->on('kb_category')->onUpdate('RESTRICT')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('kb_article_relationship', function (Blueprint $table) { $table->dropForeign('article_relationship_article_id_foreign'); $table->dropForeign('article_relationship_category_id_foreign'); }); } } 2016_02_16_140454_add_foreign_keys_to_ticket_attachment_table.php 0000644 00000001400 14756622514 0020304 0 ustar 00 foreign('thread_id', 'ticket_attachment_ibfk_1')->references('id')->on('ticket_thread')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('ticket_attachment', function (Blueprint $table) { $table->dropForeign('ticket_attachment_ibfk_1'); }); } } 2016_07_19_071910_create_field_values_table.php 0000644 00000001562 14756622514 0014541 0 ustar 00 increments('id'); $table->integer('field_id')->nullable()->unsigned(); $table->foreign('field_id')->references('id')->on('custom_form_fields'); $table->integer('child_id')->nullable()->unsigned(); $table->string('field_key')->nullable(); $table->string('field_value')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('field_values'); } } 2016_02_16_140450_create_settings_ticket_table.php 0000644 00000002453 14756622514 0015266 0 ustar 00 increments('id'); $table->string('num_format'); $table->string('num_sequence'); $table->string('priority'); $table->string('sla'); $table->string('help_topic'); $table->string('max_open_ticket'); $table->string('collision_avoid'); $table->string('lock_ticket_frequency')->default(0); $table->string('captcha'); $table->boolean('status'); $table->boolean('claim_response'); $table->boolean('assigned_ticket'); $table->boolean('answered_ticket'); $table->boolean('agent_mask'); $table->boolean('html'); $table->boolean('client_update'); $table->boolean('max_file_size'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('settings_ticket'); } } 2016_02_16_140450_create_custom_forms_table.php 0000644 00000001127 14756622514 0014600 0 ustar 00 increments('id'); $table->string('formname'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('custom_forms'); } } 2016_02_16_140450_create_kb_article_table.php 0000644 00000001445 14756622514 0014162 0 ustar 00 increments('id'); $table->text('name'); $table->string('slug'); $table->text('description', 65535); $table->boolean('status'); $table->boolean('type'); $table->dateTime('publish_time')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_article'); } } 2016_02_16_140454_add_foreign_keys_to_teams_table.php 0000644 00000001275 14756622514 0015734 0 ustar 00 foreign('team_lead', 'teams_ibfk_1')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('teams', function (Blueprint $table) { $table->dropForeign('teams_ibfk_1'); }); } } 2016_02_16_140450_create_kb_settings_table.php 0000644 00000001127 14756622514 0014374 0 ustar 00 increments('id'); $table->integer('pagination'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_settings'); } } 2016_02_16_140454_add_foreign_keys_to_tickets_table.php 0000644 00000004305 14756622514 0016266 0 ustar 00 foreign('user_id', 'tickets_ibfk_1')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('dept_id', 'tickets_ibfk_2')->references('id')->on('department')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('team_id', 'tickets_ibfk_3')->references('id')->on('teams')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('priority_id', 'tickets_ibfk_4')->references('priority_id')->on('ticket_priority')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('sla', 'tickets_ibfk_5')->references('id')->on('sla_plan')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('help_topic_id', 'tickets_ibfk_6')->references('id')->on('help_topic')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('status', 'tickets_ibfk_7')->references('id')->on('ticket_status')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('source', 'tickets_ibfk_8')->references('id')->on('ticket_source')->onUpdate('NO ACTION')->onDelete('RESTRICT'); $table->foreign('assigned_to', 'tickets_ibfk_9')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('tickets', function (Blueprint $table) { $table->dropForeign('tickets_ibfk_1'); $table->dropForeign('tickets_ibfk_2'); $table->dropForeign('tickets_ibfk_3'); $table->dropForeign('tickets_ibfk_4'); $table->dropForeign('tickets_ibfk_5'); $table->dropForeign('tickets_ibfk_6'); $table->dropForeign('tickets_ibfk_7'); $table->dropForeign('tickets_ibfk_8'); $table->dropForeign('tickets_ibfk_9'); }); } } 2016_02_16_140450_create_kb_pages_table.php 0000644 00000001355 14756622514 0013636 0 ustar 00 increments('id'); $table->string('name'); $table->boolean('status'); $table->boolean('visibility'); $table->string('slug'); $table->text('description', 65535); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_pages'); } } 2016_02_16_140450_create_ticket_form_data_table.php 0000644 00000001346 14756622514 0015362 0 ustar 00 increments('id'); $table->integer('ticket_id')->unsigned()->nullable()->index('ticket_id'); $table->text('title', 65535); $table->text('content', 65535); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('ticket_form_data'); } } 2016_07_02_051247_create_jobs_table.php 0000644 00000001642 14756622514 0013024 0 ustar 00 bigIncrements('id'); $table->string('queue'); $table->longText('payload'); $table->tinyInteger('attempts')->unsigned(); $table->tinyInteger('reserved')->unsigned(); $table->unsignedInteger('reserved_at')->nullable(); $table->unsignedInteger('available_at'); $table->unsignedInteger('created_at'); $table->index(['queue', 'reserved', 'reserved_at']); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('jobs'); } } 2018_08_08_094653_alter_users_table_add_user_language_column.php 0000644 00000001340 14756622514 0020176 0 ustar 00 string('user_language', 10)->default(null)->nullable(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('users', function (Blueprint $table) { $table->dropIfExists('user_language'); }); } } 2016_02_16_140450_create_time_format_table.php 0000644 00000001060 14756622514 0014362 0 ustar 00 increments('id'); $table->string('format'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('time_format'); } } 2016_02_16_140450_create_mailbox_protocol_table.php 0000644 00000001162 14756622514 0015433 0 ustar 00 increments('id'); $table->string('name'); $table->string('value', 50)->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('mailbox_protocol'); } } 2016_04_18_115908_create_workflow_action_table.php 0000644 00000002065 14756622514 0015307 0 ustar 00 increments('id'); $table->integer('workflow_id')->unsigned(); $table->string('condition'); $table->string('action'); $table->timestamps(); }); Schema::table('workflow_action', function (Blueprint $table) { $table->foreign('workflow_id', 'workflow_action_1')->references('id')->on('workflow_name')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('workflow_action'); Schema::table('workflow_action', function (Blueprint $table) { $table->dropForeign('workflow_action_idfk_1'); }); } } 2016_02_16_140450_create_organization_table.php 0000644 00000001501 14756622514 0014560 0 ustar 00 increments('id'); $table->string('name'); $table->string('phone'); $table->string('website'); $table->string('address'); $table->integer('head')->unsigned()->nullable()->index('head'); $table->string('internal_notes'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('organization'); } } 2016_06_28_141613_version1079table.php 0000644 00000002277 14756622514 0012424 0 ustar 00 where('id', '=', '1')->first(); if ($settings_system != null) { DB::table('settings_system')->insert(['version' => $current_version]); DB::table('common_settings') ->insert( ['option_name' => 'enable_rtl', 'option_value' => ''], ['option_name' => 'user_set_ticket_status', 'status' => 1], ['option_name' => 'send_otp', 'status' => 0], ['option_name' => 'email_mandatory', 'status' => 1] ); } if (Schema::hasTable('common_settings')) { $settings = DB::table('common_settings')->where('option_name', 'itil')->first(); if (!$settings) { DB::table('common_settings')->insert(['option_name'=>'itil', 'status'=>'0']); } } } } 2016_02_16_140450_create_password_resets_table.php 0000644 00000001230 14756622514 0015302 0 ustar 00 string('email')->index(); $table->string('token')->index(); $table->dateTime('created_at')->default('0000-00-00 00:00:00'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('password_resets'); } } 2016_02_16_140450_create_help_topic_table.php 0000644 00000002621 14756622514 0014206 0 ustar 00 increments('id'); $table->string('topic'); $table->string('parent_topic'); $table->integer('custom_form')->unsigned()->nullable()->index('custom_form'); $table->integer('department')->unsigned()->nullable()->index('department'); $table->integer('ticket_status')->unsigned()->nullable()->index('ticket_status'); $table->integer('priority')->unsigned()->nullable()->index('priority'); $table->integer('sla_plan')->unsigned()->nullable()->index('sla_plan'); $table->string('thank_page'); $table->string('ticket_num_format'); $table->string('internal_notes'); $table->boolean('status'); $table->boolean('type'); $table->integer('auto_assign')->unsigned()->nullable()->index('auto_assign_2'); $table->boolean('auto_response'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('help_topic'); } } 2016_07_29_113012_create_conditions_table.php 0000644 00000001162 14756622514 0014233 0 ustar 00 increments('id'); $table->string('job'); $table->string('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('conditions'); } } 2016_02_16_140450_create_kb_comment_table.php 0000644 00000001503 14756622514 0014174 0 ustar 00 increments('id'); $table->integer('article_id')->unsigned()->index('comment_article_id_foreign'); $table->string('name'); $table->string('email'); $table->string('website'); $table->string('comment'); $table->boolean('status'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('kb_comment'); } } 2016_05_19_055008_create_workflow_close_table.php 0000644 00000001326 14756622514 0015132 0 ustar 00 increments('id'); $table->integer('days'); $table->integer('condition'); $table->integer('send_email'); $table->integer('status'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('workflow_close'); } } 2016_02_16_140454_add_foreign_keys_to_ticket_form_data_table.php 0000644 00000001364 14756622514 0020121 0 ustar 00 foreign('ticket_id', 'ticket_form_data_ibfk_1')->references('id')->on('tickets')->onUpdate('NO ACTION')->onDelete('RESTRICT'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('ticket_form_data', function (Blueprint $table) { $table->dropForeign('ticket_form_data_ibfk_1'); }); } } 2016_05_10_102423_create_country_code_table.php 0000644 00000001445 14756622514 0014553 0 ustar 00 increments('id'); $table->char('iso', 2); $table->string('name', 100); $table->string('nicename', 100); $table->char('iso3', 3); $table->smallInteger('numcode'); $table->integer('phonecode'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('country_code'); } } 2016_04_18_115852_create_workflow_name_table.php 0000644 00000001364 14756622514 0014751 0 ustar 00 increments('id'); $table->string('name'); $table->integer('status'); $table->integer('order'); $table->string('target'); $table->text('internal_note'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('workflow_name'); } } 2016_06_02_074913_create_login_attempts_table.php 0000644 00000001316 14756622514 0015122 0 ustar 00 increments('id'); $table->string('User'); $table->string('IP'); $table->string('Attempts'); $table->datetime('LastLogin'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('login_attempts'); } }