matis bug 管理系统的主要表格

╰半橙微兮° 2022-09-20 12:54 128阅读 0赞

![None.gif][] drop   index  " PRIMARY "  on  mantis\_user\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_user\_cookie\_string  on  mantis\_user\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_user\_username  on  mantis\_user\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_enable  on  mantis\_user\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_access  on  mantis\_user\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_user\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_user\_table                                     \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_user\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   username                        **varchar** ( **32** )                     not   null ,  
![None.gif][]   realname                        **varchar** ( **64** )                     not   null ,  
![None.gif][]   email                           **varchar** ( **64** )                     not   null ,  
![None.gif][]   "password"                      **varchar** ( **32** )                     not   null ,  
![None.gif][]   date\_created                    **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   last\_visit                      **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   enabled                         **tinyint** ( **3** )                      not   null   default   **1** ,  
![None.gif][]   protected                       **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   access\_level                    **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   login\_count                     **integer** ( **10** )                     not   null   default   **0** ,  
![None.gif][]   lost\_password\_request\_          **smallint** ( **5** )                     not   null   default   **0** ,  
![None.gif][]   failed\_login\_count              **smallint** ( **5** )                     not   null   default   **0** ,  
![None.gif][]   cookie\_string                   **varchar** ( **64** )                     not   null ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_user\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_user\_cookie\_string                                \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  idx\_user\_cookie\_string  on  mantis\_user\_table  
![None.gif][](  
![None.gif][]   cookie\_string  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_user\_username                                     \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  idx\_user\_username  on  mantis\_user\_table  
![None.gif][](  
![None.gif][]   username  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_enable                                            \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_enable  on  mantis\_user\_table  
![None.gif][](  
![None.gif][]   enabled  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_access                                            \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_access  on  mantis\_user\_table  
![None.gif][](  
![None.gif][]   access\_level  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_project\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_project\_name  on  mantis\_project\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_project\_id  on  mantis\_project\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_project\_view  on  mantis\_project\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_project\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_project\_table                                  \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_project\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   项目名称                            **varchar** ( **128** )                    not   null ,  
![None.gif][]   "status"                        **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   enabled                         **tinyint** ( **3** )                      not   null   default   **1** ,  
![None.gif][]   view\_state                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   access\_min                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   file\_path                       **varchar** ( **250** )                    not   null ,  
![None.gif][]   description                     **text**                             not   null ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_project\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_project\_name                                      \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  idx\_project\_name  on  mantis\_project\_table  
![None.gif][](  
![None.gif][]   项目名称  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_project\_id                                        \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_project\_id  on  mantis\_project\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_project\_view                                      \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_project\_view  on  mantis\_project\_table  
![None.gif][](  
![None.gif][]   view\_state  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_bug\_file\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_bug\_file\_bug\_id  on  mantis\_bug\_file\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_bug\_file\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_bug\_file\_table                                 \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_bug\_file\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   bug\_id                          **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   title                           **varchar** ( **250** )                    not   null ,  
![None.gif][]   description                     **varchar** ( **250** )                    not   null ,  
![None.gif][]   diskfile                        **varchar** ( **250** )                    not   null ,  
![None.gif][]   filename                        **varchar** ( **250** )                    not   null ,  
![None.gif][]   folder                          **varchar** ( **250** )                    not   null ,  
![None.gif][]   filesize                        **integer** ( **10** )                     not   null   default   **0** ,  
![None.gif][]   file\_type                       **varchar** ( **250** )                    not   null ,  
![None.gif][]   date\_added                      **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   content                        blob                            not   null ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_bug\_file\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_bug\_file\_bug\_id                                   \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_bug\_file\_bug\_id  on  mantis\_bug\_file\_table  
![None.gif][](  
![None.gif][]   bug\_id  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_bug\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_bug\_sponsorship\_to  on  mantis\_bug\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_bug\_fixed\_in\_versi  on  mantis\_bug\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_bug\_status  on  mantis\_bug\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_project  on  mantis\_bug\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_bug\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_bug\_table                                      \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   project\_id                      **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   reporter\_id                     **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   handler\_id                      **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   duplicate\_id                    **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   priority                        **smallint** ( **5** )                     not   null   default   **30** ,  
![None.gif][]   severity                        **smallint** ( **5** )                     not   null   default   **50** ,  
![None.gif][]   reproducibility                 **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   "status"                        **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   resolution                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   projection                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   category                        **varchar** ( **64** )                     not   null ,  
![None.gif][]   date\_submitted                  **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   last\_updated                    **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   eta                             **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   bug\_text\_id                     **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   os                              **varchar** ( **32** )                     not   null ,  
![None.gif][]   os\_build                        **varchar** ( **32** )                     not   null ,  
![None.gif][]   platform                        **varchar** ( **32** )                     not   null ,  
![None.gif][]   version                         **varchar** ( **64** )                     not   null ,  
![None.gif][]   fixed\_in\_version                **varchar** ( **64** )                     not   null ,  
![None.gif][]   build                           **varchar** ( **32** )                     not   null ,  
![None.gif][]   profile\_id                      **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   view\_state                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   summary                         **varchar** ( **128** )                    not   null ,  
![None.gif][]   sponsorship\_total               **integer** ( **10** )                     not   null   default   **0** ,  
![None.gif][]   sticky                          **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_bug\_sponsorship\_to                                \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_bug\_sponsorship\_to  on  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   sponsorship\_total  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_bug\_fixed\_in\_versi                                \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_bug\_fixed\_in\_versi  on  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   fixed\_in\_version  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_bug\_status                                        \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_bug\_status  on  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   "status"  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_project                                           \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_project  on  mantis\_bug\_table  
![None.gif][](  
![None.gif][]   project\_id  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_bugnote\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_bug  on  mantis\_bugnote\_table;  
![None.gif][]  
![None.gif][] drop   index  idx\_last\_mod  on  mantis\_bugnote\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_bugnote\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_bugnote\_table                                  \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_bugnote\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   bug\_id                          **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   reporter\_id                     **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   bugnote\_text\_id                 **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   view\_state                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   date\_submitted                  **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   last\_modified                   **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   note\_type                       **integer** ( **10** )                     default   **0** ,  
![None.gif][]   note\_attr                       **varchar** ( **250** ),  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_bugnote\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_bug                                               \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_bug  on  mantis\_bugnote\_table  
![None.gif][](  
![None.gif][]   bug\_id  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: idx\_last\_mod                                          \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   index  idx\_last\_mod  on  mantis\_bugnote\_table  
![None.gif][](  
![None.gif][]   last\_modified  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_news\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_news\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_news\_table                                     \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_news\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]   project\_id                      **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   poster\_id                       **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   date\_posted                     **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   last\_modified                   **datetime**                         not   null   default   ' 1970-01-01 00:00:01 ' ,  
![None.gif][]   view\_state                      **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   announcement                    **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   headline                        **varchar** ( **64** )                     not   null ,  
![None.gif][]   body                            **text**                             not   null ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_news\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]

![None.gif][] drop   index  " PRIMARY "  on  mantis\_user\_pref\_table;  
![None.gif][]  
![None.gif][] drop   table   if   exists  mantis\_user\_pref\_table;  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Table: mantis\_user\_pref\_table                                \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   table   if   not   exists  mantis\_user\_pref\_table  
![None.gif][](  
![None.gif][]   id                              **integer**  unsigne( **10** )             default   ' 0 ' ,  
![None.gif][]    user\_id                          **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   project\_id                      **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   default\_profile                 **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   default\_project                 **integer**  unsigne( **10** )             not   null   default   ' 0 ' ,  
![None.gif][]   advanced\_report                 **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   advanced\_view                   **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   advanced\_update                 **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   refresh\_delay                   **integer** ( **10** )                     not   null   default   **0** ,  
![None.gif][]   redirect\_delay                  **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   bugnote\_order                   **varchar** ( **4** )                      not   null   default   ' ASC ' ,  
![None.gif][]   email\_on\_new                    **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_assigned               **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_feedback               **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_resolved               **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_closed                 **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_reopened               **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_bugnote                **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_status                 **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_priority               **tinyint** ( **3** )                      not   null   default   **0** ,  
![None.gif][]   email\_on\_priority\_min\_          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_status\_min\_se          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_bugnote\_min\_s          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_reopened\_min\_          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_closed\_min\_se          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_resolved\_min\_          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_feedback\_min\_          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_assigned\_min\_          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_on\_new\_min\_sever          **smallint** ( **5** )                     not   null   default   **10** ,  
![None.gif][]   email\_bugnote\_limit             **smallint** ( **5** )                     not   null   default   **0** ,  
![None.gif][]   language                        **varchar** ( **32** )                     not   null   default   ' english ' ,  
![None.gif][]    primary   key  (id)  
![None.gif][]);  
![None.gif][]  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\* Index: "PRIMARY"                                             \*/   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] /\*\*/ /\*==============================================================\*/   
![None.gif][] create   unique   index  " PRIMARY "  on  mantis\_user\_pref\_table  
![None.gif][](  
![None.gif][]   id  
![None.gif][]);  
![None.gif][]

[None.gif]: /images/20220828/81c529a3acbb49cb8d04a645469a5682.png
[ExpandedBlockStart.gif]: http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif
[ContractedBlock.gif]: /images/20220828/75344184bfd14c49abee1954ab14d674.png