Project

General

Profile

Download (17.5 KB)

Defect #27319 » dump-defs-4.2.3.diff

Jonathan Cormier, 2022-01-04 23:23

View differences:

dump-defs-4.2.3-migrated-noplugins-trimmed.sql 2022-01-04 17:04:41.108871469 -0500
23 22 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
24 23 
/*!40101 SET character_set_client = utf8 */;
25 24 
CREATE TABLE `ar_internal_metadata` (
26 
  `key` varchar(255) NOT NULL,
25 
  `key` varchar(255) CHARACTER SET utf8 NOT NULL,
27 26 
  `value` varchar(255) DEFAULT NULL,
28 27 
  `created_at` datetime NOT NULL,
29 28 
  `updated_at` datetime NOT NULL,
......
42 41 
  `id` int(11) NOT NULL AUTO_INCREMENT,
43 42 
  `container_id` int(11) DEFAULT NULL,
44 43 
  `container_type` varchar(30) DEFAULT NULL,
45 
  `filename` varchar(255) NOT NULL DEFAULT '',
46 
  `disk_filename` varchar(255) NOT NULL DEFAULT '',
44 
  `filename` varchar(255) NOT NULL,
45 
  `disk_filename` varchar(255) NOT NULL,
47 46 
  `filesize` bigint(20) NOT NULL DEFAULT '0',
48 
  `content_type` varchar(255) DEFAULT '',
49 
  `digest` varchar(64) NOT NULL DEFAULT '',
47 
  `content_type` varchar(255) DEFAULT NULL,
48 
  `digest` varchar(64) NOT NULL,
50 49 
  `downloads` int(11) NOT NULL DEFAULT '0',
51 50 
  `author_id` int(11) NOT NULL DEFAULT '0',
52 
  `created_on` timestamp NULL DEFAULT NULL,
51 
  `created_on` datetime DEFAULT NULL,
53 52 
  `description` varchar(255) DEFAULT NULL,
54 53 
  `disk_directory` varchar(255) DEFAULT NULL,
55 54 
  PRIMARY KEY (`id`),
......
69 68 
/*!40101 SET character_set_client = utf8 */;
70 69 
CREATE TABLE `auth_sources` (
71 70 
  `id` int(11) NOT NULL AUTO_INCREMENT,
72 
  `type` varchar(30) NOT NULL DEFAULT '',
73 
  `name` varchar(60) NOT NULL DEFAULT '',
71 
  `type` varchar(30) NOT NULL,
72 
  `name` varchar(60) NOT NULL,
74 73 
  `host` varchar(60) DEFAULT NULL,
75 74 
  `port` int(11) DEFAULT NULL,
76 75 
  `account` varchar(255) DEFAULT NULL,
77 
  `account_password` varchar(255) DEFAULT '',
76 
  `account_password` varchar(255) DEFAULT NULL,
78 77 
  `base_dn` varchar(255) DEFAULT NULL,
79 78 
  `attr_login` varchar(30) DEFAULT NULL,
80 79 
  `attr_firstname` varchar(30) DEFAULT NULL,
......
82 81 
  `attr_mail` varchar(30) DEFAULT NULL,
83 82 
  `onthefly_register` tinyint(1) NOT NULL DEFAULT '0',
84 83 
  `tls` tinyint(1) NOT NULL DEFAULT '0',
85 
  `filter` text
84 
  `filter` mediumtext
86 85 
  `timeout` int(11) DEFAULT NULL,
87 86 
  `verify_peer` tinyint(1) NOT NULL DEFAULT '1',
88 87 
  PRIMARY KEY (`id`),
......
100 99 
CREATE TABLE `boards` (
101 100 
  `id` int(11) NOT NULL AUTO_INCREMENT,
102 101 
  `project_id` int(11) NOT NULL,
103 
  `name` varchar(255) NOT NULL DEFAULT '',
102 
  `name` varchar(255) NOT NULL,
104 103 
  `description` varchar(255) DEFAULT NULL,
105 104 
  `position` int(11) DEFAULT NULL,
106 105 
  `topics_count` int(11) NOT NULL DEFAULT '0',
......
123 122 
CREATE TABLE `changes` (
124 123 
  `id` int(11) NOT NULL AUTO_INCREMENT,
125 124 
  `changeset_id` int(11) NOT NULL,
126 
  `action` varchar(1) NOT NULL DEFAULT '',
127 
  `path` text NOT NULL,
128 
  `from_path` text
125 
  `action` varchar(1) NOT NULL,
126 
  `path` mediumtext NOT NULL,
127 
  `from_path` mediumtext
129 128 
  `from_revision` varchar(255) DEFAULT NULL,
130 129 
  `revision` varchar(255) DEFAULT NULL,
131 130 
  `branch` varchar(255) DEFAULT NULL,
......
199 198 
/*!40101 SET character_set_client = utf8 */;
200 199 
CREATE TABLE `comments` (
201 200 
  `id` int(11) NOT NULL AUTO_INCREMENT,
202 
  `commented_type` varchar(30) NOT NULL DEFAULT '',
201 
  `commented_type` varchar(30) NOT NULL,
203 202 
  `commented_id` int(11) NOT NULL DEFAULT '0',
204 203 
  `author_id` int(11) NOT NULL DEFAULT '0',
205 
  `content` text
204 
  `content` mediumtext
206 205 
  `created_on` datetime NOT NULL,
207 206 
  `updated_on` datetime NOT NULL,
208 207 
  PRIMARY KEY (`id`),
......
237 236 
/*!40101 SET character_set_client = utf8 */;
238 237 
CREATE TABLE `custom_fields` (
239 238 
  `id` int(11) NOT NULL AUTO_INCREMENT,
240 
  `type` varchar(30) NOT NULL DEFAULT '',
241 
  `name` varchar(30) NOT NULL DEFAULT '',
242 
  `field_format` varchar(30) NOT NULL DEFAULT '',
243 
  `possible_values` text
244 
  `regexp` varchar(255) DEFAULT '',
239 
  `type` varchar(30) NOT NULL,
240 
  `name` varchar(30) NOT NULL,
241 
  `field_format` varchar(30) NOT NULL,
242 
  `possible_values` mediumtext
243 
  `regexp` varchar(255) DEFAULT NULL,
245 244 
  `min_length` int(11) DEFAULT NULL,
246 245 
  `max_length` int(11) DEFAULT NULL,
247 246 
  `is_required` tinyint(1) NOT NULL DEFAULT '0',
......
249 248 
  `is_filter` tinyint(1) NOT NULL DEFAULT '0',
250 249 
  `position` int(11) DEFAULT NULL,
251 250 
  `searchable` tinyint(1) DEFAULT '0',
252 
  `default_value` text
251 
  `default_value` mediumtext
253 252 
  `editable` tinyint(1) DEFAULT '1',
254 253 
  `visible` tinyint(1) NOT NULL DEFAULT '1',
255 254 
  `multiple` tinyint(1) DEFAULT '0',
256 
  `format_store` text
257 
  `description` text
255 
  `format_store` mediumtext
256 
  `description` mediumtext
258 257 
  PRIMARY KEY (`id`),
259 258 
  KEY `index_custom_fields_on_id_and_type` (`id`,`type`)
260 259 
) ENGINE=InnoDB
......
311 310 
/*!40101 SET character_set_client = utf8 */;
312 311 
CREATE TABLE `custom_values` (
313 312 
  `id` int(11) NOT NULL AUTO_INCREMENT,
314 
  `customized_type` varchar(30) NOT NULL DEFAULT '',
313 
  `customized_type` varchar(30) NOT NULL,
315 314 
  `customized_id` int(11) NOT NULL DEFAULT '0',
316 315 
  `custom_field_id` int(11) NOT NULL DEFAULT '0',
317 316 
  `value` longtext
......
332 331 
  `id` int(11) NOT NULL AUTO_INCREMENT,
333 332 
  `project_id` int(11) NOT NULL DEFAULT '0',
334 333 
  `category_id` int(11) NOT NULL DEFAULT '0',
335 
  `title` varchar(255) NOT NULL DEFAULT '',
336 
  `description` text
337 
  `created_on` timestamp NULL DEFAULT NULL,
334 
  `title` varchar(255) NOT NULL,
335 
  `description` mediumtext
336 
  `created_on` datetime DEFAULT NULL,
338 337 
  PRIMARY KEY (`id`),
339 338 
  KEY `documents_project_id` (`project_id`),
340 339 
  KEY `index_documents_on_category_id` (`category_id`),
......
387 386 
/*!40101 SET character_set_client = utf8 */;
388 387 
CREATE TABLE `enumerations` (
389 388 
  `id` int(11) NOT NULL AUTO_INCREMENT,
390 
  `name` varchar(30) NOT NULL DEFAULT '',
389 
  `name` varchar(30) NOT NULL,
391 390 
  `position` int(11) DEFAULT NULL,
392 391 
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
393 392 
  `type` varchar(255) DEFAULT NULL,
......
465 464 
CREATE TABLE `issue_categories` (
466 465 
  `id` int(11) NOT NULL AUTO_INCREMENT,
467 466 
  `project_id` int(11) NOT NULL DEFAULT '0',
468 
  `name` varchar(60) NOT NULL DEFAULT '',
467 
  `name` varchar(60) NOT NULL,
469 468 
  `assigned_to_id` int(11) DEFAULT NULL,
470 469 
  PRIMARY KEY (`id`),
471 470 
  KEY `issue_categories_project_id` (`project_id`),
......
484 483 
  `id` int(11) NOT NULL AUTO_INCREMENT,
485 484 
  `issue_from_id` int(11) NOT NULL,
486 485 
  `issue_to_id` int(11) NOT NULL,
487 
  `relation_type` varchar(255) NOT NULL DEFAULT '',
486 
  `relation_type` varchar(255) NOT NULL,
488 487 
  `delay` int(11) DEFAULT NULL,
489 488 
  PRIMARY KEY (`id`),
490 489 
  UNIQUE KEY `index_issue_relations_on_issue_from_id_and_issue_to_id` (`issue_from_id`,`issue_to_id`),
......
502 501 
/*!40101 SET character_set_client = utf8 */;
503 502 
CREATE TABLE `issue_statuses` (
504 503 
  `id` int(11) NOT NULL AUTO_INCREMENT,
505 
  `name` varchar(30) NOT NULL DEFAULT '',
504 
  `name` varchar(30) NOT NULL,
506 505 
  `is_closed` tinyint(1) NOT NULL DEFAULT '0',
507 506 
  `position` int(11) DEFAULT NULL,
508 507 
  `default_done_ratio` int(11) DEFAULT NULL,
......
523 522 
  `id` int(11) NOT NULL AUTO_INCREMENT,
524 523 
  `tracker_id` int(11) NOT NULL,
525 524 
  `project_id` int(11) NOT NULL,
526 
  `subject` varchar(255) NOT NULL DEFAULT '',
525 
  `subject` varchar(255) NOT NULL,
527 526 
  `description` longtext
528 527 
  `due_date` date DEFAULT NULL,
529 528 
  `category_id` int(11) DEFAULT NULL,
......
533 532 
  `fixed_version_id` int(11) DEFAULT NULL,
534 533 
  `author_id` int(11) NOT NULL,
535 534 
  `lock_version` int(11) NOT NULL DEFAULT '0',
536 
  `created_on` timestamp NULL DEFAULT NULL,
537 
  `updated_on` timestamp NULL DEFAULT NULL,
535 
  `created_on` datetime DEFAULT NULL,
536 
  `updated_on` datetime DEFAULT NULL,
538 537 
  `start_date` date DEFAULT NULL,
539 538 
  `done_ratio` int(11) NOT NULL DEFAULT '0',
540 539 
  `estimated_hours` float DEFAULT NULL,
......
569 568 
CREATE TABLE `journal_details` (
570 569 
  `id` int(11) NOT NULL AUTO_INCREMENT,
571 570 
  `journal_id` int(11) NOT NULL DEFAULT '0',
572 
  `property` varchar(30) NOT NULL DEFAULT '',
573 
  `prop_key` varchar(30) NOT NULL DEFAULT '',
571 
  `property` varchar(30) NOT NULL,
572 
  `prop_key` varchar(30) NOT NULL,
574 573 
  `old_value` longtext
575 574 
  `value` longtext
576 575 
  PRIMARY KEY (`id`),
......
588 587 
CREATE TABLE `journals` (
589 588 
  `id` int(11) NOT NULL AUTO_INCREMENT,
590 589 
  `journalized_id` int(11) NOT NULL DEFAULT '0',
591 
  `journalized_type` varchar(30) NOT NULL DEFAULT '',
590 
  `journalized_type` varchar(30) NOT NULL,
592 591 
  `user_id` int(11) NOT NULL DEFAULT '0',
593 592 
  `notes` longtext
594 593 
  `created_on` datetime NOT NULL,
......
631 630 
  `id` int(11) NOT NULL AUTO_INCREMENT,
632 631 
  `user_id` int(11) NOT NULL DEFAULT '0',
633 632 
  `project_id` int(11) NOT NULL DEFAULT '0',
634 
  `created_on` timestamp NULL DEFAULT NULL,
633 
  `created_on` datetime DEFAULT NULL,
635 634 
  `mail_notification` tinyint(1) NOT NULL DEFAULT '0',
636 635 
  PRIMARY KEY (`id`),
637 636 
  UNIQUE KEY `index_members_on_user_id_and_project_id` (`user_id`,`project_id`),
......
651 650 
  `id` int(11) NOT NULL AUTO_INCREMENT,
652 651 
  `board_id` int(11) NOT NULL,
653 652 
  `parent_id` int(11) DEFAULT NULL,
654 
  `subject` varchar(255) NOT NULL DEFAULT '',
653 
  `subject` varchar(255) NOT NULL,
655 654 
  `content` text
656 655 
  `author_id` int(11) DEFAULT NULL,
657 656 
  `replies_count` int(11) NOT NULL DEFAULT '0',
......
679 678 
CREATE TABLE `news` (
680 679 
  `id` int(11) NOT NULL AUTO_INCREMENT,
681 680 
  `project_id` int(11) DEFAULT NULL,
682 
  `title` varchar(60) NOT NULL DEFAULT '',
683 
  `summary` varchar(255) DEFAULT '',
681 
  `title` varchar(60) NOT NULL,
682 
  `summary` varchar(255) DEFAULT NULL,
684 683 
  `description` text
685 684 
  `author_id` int(11) NOT NULL DEFAULT '0',
686 
  `created_on` timestamp NULL DEFAULT NULL,
685 
  `created_on` datetime DEFAULT NULL,
687 686 
  `comments_count` int(11) NOT NULL DEFAULT '0',
688 687 
  PRIMARY KEY (`id`),
689 688 
  KEY `news_project_id` (`project_id`),
......
736 735 
/*!40101 SET character_set_client = utf8 */;
737 736 
CREATE TABLE `projects` (
738 737 
  `id` int(11) NOT NULL AUTO_INCREMENT,
739 
  `name` varchar(255) NOT NULL DEFAULT '',
738 
  `name` varchar(255) NOT NULL,
740 739 
  `description` text
741 
  `homepage` varchar(255) DEFAULT '',
740 
  `homepage` varchar(255) DEFAULT NULL,
742 741 
  `is_public` tinyint(1) NOT NULL DEFAULT '1',
743 742 
  `parent_id` int(11) DEFAULT NULL,
744 
  `created_on` timestamp NULL DEFAULT NULL,
745 
  `updated_on` timestamp NULL DEFAULT NULL,
743 
  `created_on` datetime DEFAULT NULL,
744 
  `updated_on` datetime DEFAULT NULL,
746 745 
  `identifier` varchar(255) DEFAULT NULL,
747 746 
  `status` int(11) NOT NULL DEFAULT '1',
748 747 
  `lft` int(11) DEFAULT NULL,
749 748 
  `rgt` int(11) DEFAULT NULL,
750 749 
  `inherit_members` tinyint(1) NOT NULL DEFAULT '0',
751 750 
  `default_version_id` int(11) DEFAULT NULL,
751 
  `text_formatting` varchar(255) DEFAULT NULL,
752 
  `modules_for_formatting` text
752 753 
  `default_assigned_to_id` int(11) DEFAULT NULL,
754 
  `new_ticket_message` text
755 
  `enable_new_ticket_message` int(11) NOT NULL DEFAULT '1',
753 756 
  PRIMARY KEY (`id`),
754 757 
  KEY `index_projects_on_lft` (`lft`),
755 758 
  KEY `index_projects_on_rgt` (`rgt`)
......
781 784 
CREATE TABLE `queries` (
782 785 
  `id` int(11) NOT NULL AUTO_INCREMENT,
783 786 
  `project_id` int(11) DEFAULT NULL,
784 
  `name` varchar(255) NOT NULL DEFAULT '',
787 
  `name` varchar(255) NOT NULL,
785 788 
  `filters` text
786 789 
  `user_id` int(11) NOT NULL DEFAULT '0',
787 790 
  `column_names` text
......
820 823 
CREATE TABLE `repositories` (
821 824 
  `id` int(11) NOT NULL AUTO_INCREMENT,
822 825 
  `project_id` int(11) NOT NULL DEFAULT '0',
823 
  `url` varchar(255) NOT NULL DEFAULT '',
824 
  `login` varchar(60) DEFAULT '',
825 
  `password` varchar(255) DEFAULT '',
826 
  `root_url` varchar(255) DEFAULT '',
826 
  `url` varchar(255) NOT NULL,
827 
  `login` varchar(60) DEFAULT NULL,
828 
  `password` varchar(255) DEFAULT NULL,
829 
  `root_url` varchar(255) DEFAULT NULL,
827 830 
  `type` varchar(255) DEFAULT NULL,
828 831 
  `path_encoding` varchar(64) DEFAULT NULL,
829 832 
  `log_encoding` varchar(64) DEFAULT NULL,
830 833 
  `extra_info` longtext
831 834 
  `identifier` varchar(255) DEFAULT NULL,
832 835 
  `is_default` tinyint(1) DEFAULT '0',
833 
  `created_on` timestamp NULL DEFAULT NULL,
836 
  `created_on` datetime DEFAULT NULL,
834 837 
  PRIMARY KEY (`id`),
835 838 
  KEY `index_repositories_on_project_id` (`project_id`)
836 839 
) ENGINE=InnoDB
......
850 853 
  `assignable` tinyint(1) DEFAULT '1',
851 854 
  `builtin` int(11) NOT NULL DEFAULT '0',
852 855 
  `permissions` text
853 
  `issues_visibility` varchar(30) NOT NULL DEFAULT 'default',
854 
  `users_visibility` varchar(30) NOT NULL DEFAULT 'all',
855 
  `time_entries_visibility` varchar(30) NOT NULL DEFAULT 'all',
856 
  `issues_visibility` varchar(30) NOT NULL,
857 
  `users_visibility` varchar(30) NOT NULL,
858 
  `time_entries_visibility` varchar(30) NOT NULL,
856 859 
  `all_roles_managed` tinyint(1) NOT NULL DEFAULT '1',
857 860 
  `settings` text
861 
  `hide` tinyint(1) NOT NULL DEFAULT '0',
858 862 
  PRIMARY KEY (`id`)
859 863 
) ENGINE=InnoDB
860 864 
/*!40101 SET character_set_client = @saved_cs_client */;
......
882 886 
/*!40101 SET character_set_client = utf8 */;
883 887 
CREATE TABLE `schema_migrations` (
884 888 
  `version` varchar(255) NOT NULL,
885 
  PRIMARY KEY (`version`)
889 
  UNIQUE KEY `unique_schema_migrations` (`version`)
886 890 
) ENGINE=InnoDB
887 891 
/*!40101 SET character_set_client = @saved_cs_client */;
888 892 

  		




  ......




  895
  899
  
    
/*!40101 SET character_set_client = utf8 */;

  		




  896
  900
  
    
CREATE TABLE `settings` (

  		




  897
  901
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  898
  
  
    
  `name` varchar(255) NOT NULL DEFAULT '',

  		




  
  902
  
    
  `name` varchar(255) NOT NULL,

  		




  899
  903
  
    
  `value` text 

  		




  900
  
  
    
  `updated_on` timestamp NULL DEFAULT NULL,

  		




  
  904
  
    
  `updated_on` datetime DEFAULT NULL,

  		




  901
  905
  
    
  PRIMARY KEY (`id`),

  		




  902
  906
  
    
  KEY `index_settings_on_name` (`name`)

  		




  903
  907
  
    
) ENGINE=InnoDB 

  		




  ......




  944
  948
  
    
CREATE TABLE `tokens` (

  		




  945
  949
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  946
  950
  
    
  `user_id` int(11) NOT NULL DEFAULT '0',

  		




  947
  
  
    
  `action` varchar(30) NOT NULL DEFAULT '',

  		




  948
  
  
    
  `value` varchar(40) NOT NULL DEFAULT '',

  		




  
  951
  
    
  `action` varchar(30) NOT NULL,

  		




  
  952
  
    
  `value` varchar(40) NOT NULL,

  		




  949
  953
  
    
  `created_on` datetime NOT NULL,

  		




  950
  
  
    
  `updated_on` timestamp NULL DEFAULT NULL,

  		




  
  954
  
    
  `updated_on` datetime DEFAULT NULL,

  		




  951
  955
  
    
  PRIMARY KEY (`id`),

  		




  952
  956
  
    
  UNIQUE KEY `tokens_value` (`value`),

  		




  953
  957
  
    
  KEY `index_tokens_on_user_id` (`user_id`)

  		




  ......




  963
  967
  
    
/*!40101 SET character_set_client = utf8 */;

  		




  964
  968
  
    
CREATE TABLE `trackers` (

  		




  965
  969
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  966
  
  
    
  `name` varchar(30) NOT NULL DEFAULT '',

  		




  
  970
  
    
  `name` varchar(30) NOT NULL,

  		




  967
  971
  
    
  `description` varchar(255) DEFAULT NULL,

  		




  968
  972
  
    
  `is_in_chlog` tinyint(1) NOT NULL DEFAULT '0',

  		




  969
  973
  
    
  `position` int(11) DEFAULT NULL,

  		




  ......




  987
  991
  
    
  `others` text 

  		




  988
  992
  
    
  `hide_mail` tinyint(1) DEFAULT '1',

  		




  989
  993
  
    
  `time_zone` varchar(255) DEFAULT NULL,

  		




  
  994
  
    
  `autowatch_involved_issue` tinyint(1) NOT NULL DEFAULT '1',

  		




  990
  995
  
    
  PRIMARY KEY (`id`),

  		




  991
  996
  
    
  KEY `index_user_preferences_on_user_id` (`user_id`)

  		




  992
  997
  
    
) ENGINE=InnoDB 

  		




  ......




  1001
  1006
  
    
/*!40101 SET character_set_client = utf8 */;

  		




  1002
  1007
  
    
CREATE TABLE `users` (

  		




  1003
  1008
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  1004
  
  
    
  `login` varchar(255) NOT NULL DEFAULT '',

  		




  1005
  
  
    
  `hashed_password` varchar(40) NOT NULL DEFAULT '',

  		




  1006
  
  
    
  `firstname` varchar(30) NOT NULL DEFAULT '',

  		




  1007
  
  
    
  `lastname` varchar(255) NOT NULL DEFAULT '',

  		




  
  1009
  
    
  `login` varchar(255) NOT NULL,

  		




  
  1010
  
    
  `hashed_password` varchar(40) NOT NULL,

  		




  
  1011
  
    
  `firstname` varchar(30) NOT NULL,

  		




  
  1012
  
    
  `lastname` varchar(255) NOT NULL,

  		




  1008
  1013
  
    
  `admin` tinyint(1) NOT NULL DEFAULT '0',

  		




  1009
  1014
  
    
  `status` int(11) NOT NULL DEFAULT '1',

  		




  1010
  1015
  
    
  `last_login_on` datetime DEFAULT NULL,

  		




  1011
  
  
    
  `language` varchar(5) DEFAULT '',

  		




  
  1016
  
    
  `language` varchar(5) DEFAULT NULL,

  		




  1012
  1017
  
    
  `auth_source_id` int(11) DEFAULT NULL,

  		




  1013
  
  
    
  `created_on` timestamp NULL DEFAULT NULL,

  		




  1014
  
  
    
  `updated_on` timestamp NULL DEFAULT NULL,

  		




  
  1018
  
    
  `created_on` datetime DEFAULT NULL,

  		




  
  1019
  
    
  `updated_on` datetime DEFAULT NULL,

  		




  1015
  1020
  
    
  `type` varchar(255) DEFAULT NULL,

  		




  1016
  1021
  
    
  `identity_url` varchar(255) DEFAULT NULL,

  		




  1017
  
  
    
  `mail_notification` varchar(255) NOT NULL DEFAULT '',

  		




  
  1022
  
    
  `mail_notification` varchar(255) NOT NULL,

  		




  1018
  1023
  
    
  `salt` varchar(64) DEFAULT NULL,

  		




  1019
  1024
  
    
  `must_change_passwd` tinyint(1) NOT NULL DEFAULT '0',

  		




  1020
  1025
  
    
  `passwd_changed_on` datetime DEFAULT NULL,

  		




  
  1026
  
    
  `old_hashed_passwords` varchar(3968) DEFAULT NULL,

  		




  
  1027
  
    
  `old_salts` text 

  		




  1021
  1028
  
    
  `twofa_scheme` varchar(255) DEFAULT NULL,

  		




  1022
  1029
  
    
  `twofa_totp_key` varchar(255) DEFAULT NULL,

  		




  1023
  1030
  
    
  `twofa_totp_last_used_at` int(11) DEFAULT NULL,

  		




  ......




  1038
  1045
  
    
CREATE TABLE `versions` (

  		




  1039
  1046
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  1040
  1047
  
    
  `project_id` int(11) NOT NULL DEFAULT '0',

  		




  1041
  
  
    
  `name` varchar(255) NOT NULL DEFAULT '',

  		




  1042
  
  
    
  `description` varchar(255) DEFAULT '',

  		




  
  1048
  
    
  `name` varchar(255) NOT NULL,

  		




  
  1049
  
    
  `description` varchar(255) DEFAULT NULL,

  		




  1043
  1050
  
    
  `effective_date` date DEFAULT NULL,

  		




  1044
  
  
    
  `created_on` timestamp NULL DEFAULT NULL,

  		




  1045
  
  
    
  `updated_on` timestamp NULL DEFAULT NULL,

  		




  
  1051
  
    
  `created_on` datetime DEFAULT NULL,

  		




  
  1052
  
    
  `updated_on` datetime DEFAULT NULL,

  		




  1046
  1053
  
    
  `wiki_page_title` varchar(255) DEFAULT NULL,

  		




  1047
  
  
    
  `status` varchar(255) DEFAULT 'open',

  		




  1048
  
  
    
  `sharing` varchar(255) NOT NULL DEFAULT 'none',

  		




  
  1054
  
    
  `status` varchar(255) DEFAULT NULL,

  		




  
  1055
  
    
  `sharing` varchar(255) NOT NULL,

  		




  1049
  1056
  
    
  PRIMARY KEY (`id`),

  		




  1050
  1057
  
    
  KEY `versions_project_id` (`project_id`),

  		




  1051
  1058
  
    
  KEY `index_versions_on_sharing` (`sharing`)

  		




  ......




  1061
  1068
  
    
/*!40101 SET character_set_client = utf8 */;

  		




  1062
  1069
  
    
CREATE TABLE `watchers` (

  		




  1063
  1070
  
    
  `id` int(11) NOT NULL AUTO_INCREMENT,

  		




  1064
  
  
    
  `watchable_type` varchar(255) NOT NULL DEFAULT '',

  		




  
  1071
  
    
  `watchable_type` varchar(255) NOT NULL,

  		




  1065
  1072
  
    
  `watchable_id` int(11) NOT NULL DEFAULT '0',

  		




  1066
  1073
  
    
  `user_id` int(11) DEFAULT NULL,

  		




  1067
  1074
  
    
  PRIMARY KEY (`id`),

  		




  ......




  1084
  1091
  
    
  `page_id` int(11) NOT NULL,

  		




  1085
  1092
  
    
  `author_id` int(11) DEFAULT NULL,

  		




  1086
  1093
  
    
  `data` longblob,

  		




  1087
  
  
    
  `compression` varchar(6) DEFAULT '',

  		




  1088
  
  
    
  `comments` varchar(1024) DEFAULT '',

  		




  
  1094
  
    
  `compression` varchar(6) DEFAULT NULL,

  		




  
  1095
  
    
  `comments` varchar(1024) DEFAULT NULL,

  		




  1089
  1096
  
    
  `updated_on` datetime NOT NULL,

  		




  1090
  1097
  
    
  `version` int(11) NOT NULL,

  		




  1091
  1098
  
    
  PRIMARY KEY (`id`),

  		




  ......




  1106
  1113
  
    
  `page_id` int(11) NOT NULL,

  		




  1107
  1114
  
    
  `author_id` int(11) DEFAULT NULL,

  		




  1108
  1115
  
    
  `text` longtext 

  		




  1109
  
  
    
  `comments` varchar(1024) DEFAULT '',

  		




  
  1116
  
    
  `comments` varchar(1024) DEFAULT NULL,

  		




  1110
  1117
  
    
  `updated_on` datetime NOT NULL,

  		




  1111
  1118
  
    
  `version` int(11) NOT NULL,

  		




  1112
  1119
  
    
  PRIMARY KEY (`id`),

  		




  ......




  1209
  1216
  
    
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

  		




  1210
  1217
  
    
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

  		




  1211
  1218
  
    

  		




  1212
  
  
    
-- Dump completed on 2022-01-05  2:59:09

  		




  
  1219
  
    
-- Dump completed on 2022-01-04 21:23:33

  		















  (4-4/4)