|
1
|
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
|
|
2
|
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
|
|
3
|
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
|
|
4
|
| attachments | InnoDB | 10 | Compact | 3388 | 469 | 1589248 | 0 | 344064 | 0 | 3814 | 2010-06-10 10:08:37 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
5
|
| auth_sources | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 0 | 2 | 2010-06-10 10:07:50 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
6
|
| boards | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 32768 | 0 | 8 | 2010-06-10 10:07:56 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
7
|
| changes | InnoDB | 10 | Compact | 3450672 | 140 | 485425152 | 0 | 47792128 | 0 | 305864965 | 2010-06-10 10:03:35 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 13312 kB |
|
|
8
|
| changesets | InnoDB | 10 | Compact | 36785 | 699 | 25739264 | 0 | 8994816 | 0 | 793873 | 2010-06-10 10:08:42 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 7168 kB |
|
|
9
|
| changesets_issues | InnoDB | 10 | Compact | 167 | 98 | 16384 | 0 | 0 | 0 | NULL | 2010-06-10 10:05:42 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
10
|
| comments | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2010-06-10 10:07:47 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
11
|
| custom_fields | InnoDB | 10 | Compact | 79 | 622 | 49152 | 0 | 16384 | 0 | 74 | 2010-06-10 10:08:11 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
12
|
| custom_fields_projects | InnoDB | 10 | Compact | 1631 | 50 | 81920 | 0 | 49152 | 0 | NULL | 2010-06-10 10:07:47 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
13
|
| custom_fields_trackers | InnoDB | 10 | Compact | 145 | 112 | 16384 | 0 | 16384 | 0 | NULL | 2010-06-10 10:08:26 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
14
|
| custom_values | InnoDB | 10 | Compact | 260983 | 54 | 14172160 | 0 | 14712832 | 0 | 311302 | 2010-06-10 10:08:18 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 5120 kB |
|
|
15
|
| documents | InnoDB | 10 | Compact | 131 | 1250 | 163840 | 0 | 49152 | 0 | 147 | 2010-06-10 10:08:37 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
16
|
| enabled_modules | InnoDB | 10 | Compact | 919 | 89 | 81920 | 0 | 16384 | 0 | 1515 | 2010-06-10 10:05:47 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
17
|
| enumerations | InnoDB | 10 | Compact | 23 | 712 | 16384 | 0 | 32768 | 0 | 26 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
18
|
| groups_users | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-06-10 10:07:46 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
19
|
| issue_categories | InnoDB | 10 | Compact | 571 | 114 | 65536 | 0 | 32768 | 0 | 653 | 2010-06-10 10:07:56 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
20
|
| issue_relations | InnoDB | 10 | Compact | 2607 | 62 | 163840 | 0 | 212992 | 0 | 3176 | 2010-06-10 10:08:25 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
21
|
| issue_statuses | InnoDB | 10 | Compact | 27 | 606 | 16384 | 0 | 49152 | 0 | 30 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
22
|
| issues | InnoDB | 10 | Compact | 17502 | 1528 | 26755072 | 0 | 2916352 | 0 | 15914 | 2010-06-10 10:08:36 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
23
|
| journal_details | InnoDB | 10 | Compact | 90849 | 63 | 5783552 | 0 | 1589248 | 0 | 93034 | 2010-06-10 10:05:50 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
24
|
| journals | InnoDB | 10 | Compact | 64865 | 510 | 33095680 | 0 | 8454144 | 0 | 65896 | 2010-06-10 10:08:30 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 5120 kB |
|
|
25
|
| member_roles | InnoDB | 10 | Compact | 2899 | 39 | 114688 | 0 | 131072 | 0 | 2314 | 2010-06-10 10:07:56 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
26
|
| members | InnoDB | 10 | Compact | 2353 | 55 | 131072 | 0 | 147456 | 0 | 2475 | 2010-06-10 10:08:11 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
27
|
| messages | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 81920 | 0 | 10 | 2010-06-10 10:08:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
28
|
| news | InnoDB | 10 | Compact | 94 | 697 | 65536 | 0 | 49152 | 0 | 85 | 2010-06-10 10:08:36 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
29
|
| open_id_authentication_associations | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2010-06-10 10:07:35 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
30
|
| open_id_authentication_nonces | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2010-06-10 10:07:35 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
31
|
| plugin_schema_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-06-10 10:05:56 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
32
|
| projects | InnoDB | 10 | Compact | 171 | 287 | 49152 | 0 | 32768 | 0 | 144 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
33
|
| projects_trackers | InnoDB | 10 | Compact | 1043 | 47 | 49152 | 0 | 16384 | 0 | NULL | 2010-06-10 10:07:37 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
34
|
| queries | InnoDB | 10 | Compact | 1277 | 295 | 376832 | 0 | 98304 | 0 | 1514 | 2010-06-10 10:08:11 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
35
|
| repositories | InnoDB | 10 | Compact | 32 | 512 | 16384 | 0 | 16384 | 0 | 93 | 2010-06-10 10:07:47 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
36
|
| roles | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 0 | 0 | 7 | 2010-06-10 10:05:57 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
37
|
| schema_migrations | InnoDB | 10 | Compact | 167 | 98 | 16384 | 0 | 0 | 0 | NULL | 2010-06-10 10:05:57 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
38
|
| settings | InnoDB | 10 | Compact | 43 | 381 | 16384 | 0 | 16384 | 0 | 44 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
39
|
| time_entries | InnoDB | 10 | Compact | 5170 | 91 | 475136 | 0 | 655360 | 0 | 5077 | 2010-06-10 10:08:37 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
40
|
| tokens | InnoDB | 10 | Compact | 1090 | 105 | 114688 | 0 | 16384 | 0 | 1017 | 2010-06-10 10:07:50 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
41
|
| trackers | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 0 | 0 | 19 | 2010-06-10 10:05:57 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
42
|
| user_preferences | InnoDB | 10 | Compact | 469 | 174 | 81920 | 0 | 16384 | 0 | 514 | 2010-06-10 10:07:56 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
43
|
| users | InnoDB | 10 | Compact | 506 | 259 | 131072 | 0 | 32768 | 0 | 531 | 2010-06-10 10:08:12 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
44
|
| versions | InnoDB | 10 | Compact | 1279 | 140 | 180224 | 0 | 98304 | 0 | 1283 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
45
|
| watchers | InnoDB | 10 | Compact | 37760 | 42 | 1589248 | 0 | 4767744 | 0 | 39372 | 2010-06-10 10:07:50 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
46
|
| wiki_content_versions | InnoDB | 10 | Compact | 3570 | 1032 | 3686400 | 0 | 196608 | 0 | 3708 | 2010-06-10 10:08:39 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
47
|
| wiki_contents | InnoDB | 10 | Compact | 1026 | 1548 | 1589248 | 0 | 32768 | 0 | 725 | 2010-06-10 10:08:38 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
48
|
| wiki_pages | InnoDB | 10 | Compact | 679 | 120 | 81920 | 0 | 98304 | 0 | 725 | 2010-06-10 10:07:48 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
49
|
| wiki_redirects | InnoDB | 10 | Compact | 32 | 512 | 16384 | 0 | 32768 | 0 | 36 | 2010-06-10 10:08:25 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
50
|
| wikis | InnoDB | 10 | Compact | 65 | 252 | 16384 | 0 | 16384 | 0 | 72 | 2010-06-10 10:05:59 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
|
|
51
|
| workflows | InnoDB | 10 | Compact | 6386 | 46 | 294912 | 0 | 802816 | 0 | 29661 | 2010-06-10 10:07:47 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 4096 kB |
|
|
52
|
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
|