I was bored today. I imported the Jira database (MySQL version) and checked it in navicat. Summarize the following points:
I. Various types:
Tables: N
Views: 0
Functions: 0
Trigger: 0
Ii. Foreign Key Usage:
Foreign keys are rarely used in table design. Except for a set of tables that appear to be automatically generated, there are basically no foreign keys.
There is a lot of debate over the use of foreign keys on the Internet:
Work, often to create accounts for multiple users, in order to reduce the workload, wrote an automated script to help me batch create usersThe code is as follows:"""Automatic creation of Jira student accounts""" fromSeleniumImportWebdriver fromTimeImportSleepImportCsvdriver= Webdriver. Chrome (R'D:\selenium\tools\chromedriver.exe') Driver.get ("http://xxx:8090/login.jsp")#Jira's websiteData_set = R'C:\Users\xxx\Desktop\data.csv'Sleep (10)#Enter user n
ChatTR 1. Role Modify the exT2 and Ext3 File System Properties (attribute), using the privilege superuser. 2. Format chattr [-RV] [-+=aacddijssu] [-V Version] file or directory 3. Main parameters -R: Recursively processes all files and subdirectories. -V: Displays the modified content in detail and prints the output. -: Invalid property. +: Activates the attribute. =: Specifies the property. A:Atime, tell the system not to modify the last access times for this file. S:syNC, o
1 , select items 2 , click "Question"-"all questions " 3 , select Status (General development concerns "new, in Process", testing concerns "resolved, obsolete") 4 , select the More " , Tick "resolve version", "Impact version", "Resolution of the person", we generally add these three to accurately filter, and then set a value 5 , save the filter conditions of the settings, only need to click on the saved filter to filter the required Bug6 , remove the filters you don't want
Functional requirements:When a defect is created, some options are required for the project, but the default fields in Jira are not required.Eg:When creating a problem, the submitter must set "fixed version ".1. Go to System Management"2. Question field-"field preparation"3. Go to the "view field configurations" configuration page and click "Default Field Configuration" to connect4. Go to the field settings page and select the "required" option in the
Customize workflows suitable for projectsJIRA provides a default workflow and a series of problem types, which are ideal for defect tracking and software development. During use, you can adjust the process at any time according to the actual
1. Schemes-> workflow schemes can be configured with different issue types to use different workflows.
Assign a workflow to an issue type for this scheme
2. Issue settings-> Issue types Scheme
You can set the issue type visible to a project.
Preface:JIRA is an excellent problem-tracking management software tool developed by the Australian Atlassian Company to track and manage various types of issues, including defects, tasks, requirements, improvements, and more. Jira uses the Java EE technology to deploy across platforms. It is being used by a wide range of open source software organizations, as well as world-renowned companies.Jira products are very complete and powerful, simple install
prototype tool has a unique hand-painted style. The software's built-in components and drag-and-drop support provide a convenient design. The tool has a desktop version and can also be used as a plugin for Google Drive,confluence and Jira.
3. Justinmind
Difficulty: ★★★★★
Price:
Trial period-30 days
Professional version-$29/month (package year $19/month)
Justinmind is a prototype tool produced by the Spanish Justinmind company, primarily de
1. Installing the Java EnvironmentBecause Jira is developed in Java, all the Java environments need to be configured, and if you are not downloading a standalone installation package, you need to install the Tomcat container environment because Jira is a Java Web project.2, download Jira installation package and installationWe are directly using the standalone pa
Jira4.2 installation on Ubuntu (including cracking, with postgreSQL database)
1. Installation
1-1. Install Ubuntu (a little bit, you will never forget to read it :))
1-2. Install JDK by referring to the following address (of course there are many other methods)
Http://blog.csdn.net/guo_rui22/article/details/6698643
1-3. Install the PostgreSQL database by referring to the following address
Http://blog.csdn.net/guo_rui22/article/details/3862282
1-4. Create a database to be used by jira_4.2.
Installation Environment: Windows xpMySQL-5.5.28Jdk1.6.0_21 The Jira features a comprehensive, user-friendly interface, simple installation, flexible configuration, privilege management, and scalability.MySQL build database and build account1. Create database in MySQL jiradbCreate Database character Set ' UTF8 ';2. Create database users and assign permissionsCreate UserJirauser identified by 'Jira';//creat
pre-prepared 1 : JDK Download and install: jdk-6u45-windows-i586.exe 2 : MySQL JDBC Connection driver: Mysql-connector-java-5.1.25.zip 3 : MySQL database download and install: This xampp-win32-1.8.2-0-vc9.zip is recommended here, without the hassle of installing MySQL and configuration. NBSP 4 : Create Jira user in MySQL, jira database, set user rights (also can be created and set through the p
Installation Preparation:System: centos6.5 x64Software: mysql5.x,jira6.3.6Chinese documents: Jira-6.3.3-language-pack-zh_cn.jarHack file: Atlassian-extras-2.2.2.jar Atlassian-universal-plugin-manager-plugin-2.17.4.jarTo start the installation:Because Jira needs to use the Java environment, it is necessary to install the JDK first, it is recommended to install the jdk1.6 version and the above versionMy versi
centos6.5+jira6.3.6+mysql5.1+ installation + crack + ChineseA: IntroductionProcess summary, make a memo.:jira6.3.6:Http://pan.baidu.com/s/1eQgTYKEChinese Packaging:http://download.csdn.net/download/mchdba/7943421 Cracked package:http://download.csdn.net/detail/mchdba/7950429 MySQL online yum installs and drives its own.II: Required ToolsWhere MySQL is installed online using CentOS.III: JDK Installation and configurationSelf-Baidu.Four: MySQL RelatedBecause MySQL not only needs to install, but al
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.