API tools faq
paste
hitteshahuja

Untitled

hitteshahuja
Mar 30th, 2015
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Diff 45.13 KB | None | 0 0
raw download clone embed print report
  1. # server1 on <server>: ... connected.
  2. # server2 on <server>: ... connected.
  3. # Comparing `mahara` to `maharatest`                               [FAIL]
  4. # Object definitions differ. (--changes-for=server1)
  5. #
  6.  
  7. - CREATE DATABASE `mahara` /*!40100 DEFAULT CHARACTER SET utf8 */
  8. + CREATE DATABASE `maharatest` /*!40100 DEFAULT CHARACTER SET utf8 */
  9. ?                        ++++
  10. # Comparing `mahara`.`activity_queue` to `maharatest`.`activity_queue`   [PASS]
  11. # WARNING: Table options are ignored and differences were found:
  12. #   ENGINE=InnoDB
  13. # - AUTO_INCREMENT=242
  14. # ?                ^^^
  15. # + AUTO_INCREMENT=6
  16. # ?                ^
  17. #   DEFAULT
  18. #   CHARSET=utf8
  19. # Comparing `mahara`.`activity_type` to `maharatest`.`activity_type`   [FAIL]
  20. # Object definitions differ. (--changes-for=server1)
  21. #
  22.  
  23.   CREATE TABLE `activity_type` (
  24.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  25.     `name` varchar(50) NOT NULL,
  26.     `admin` tinyint(1) NOT NULL DEFAULT '0',
  27.     `delay` tinyint(1) NOT NULL DEFAULT '1',
  28. -   `allownonemethod` varchar(255) NOT NULL DEFAULT '1',
  29. ?                     ^^^^^^^ ^^^
  30. +   `allownonemethod` tinyint(1) NOT NULL DEFAULT '1',
  31. ?                     ^^^^^^^ ^
  32.     `defaultmethod` varchar(255) DEFAULT 'email',
  33.     `plugintype` varchar(25) DEFAULT NULL,
  34.     `pluginname` varchar(255) DEFAULT NULL,
  35.     PRIMARY KEY (`id`),
  36.     UNIQUE KEY `actitype_nampluplu_uk` (`name`,`plugintype`,`pluginname`)
  37.   )
  38. # Comparing `mahara`.`application` to `maharatest`.`application`   [PASS]
  39. # Comparing `mahara`.`archived_submissions` to `maharatest`.`archived_submissions`   [FAIL]
  40. # Object definitions differ. (--changes-for=server1)
  41. #
  42.  
  43.   CREATE TABLE `archived_submissions` (
  44.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  45.     `archiveid` bigint(10) NOT NULL,
  46. -   `group` bigint(10) DEFAULT NULL,
  47. ?                      ^^^^^^
  48. +   `group` bigint(10) NOT NULL,
  49. ?                      ^^
  50.     `externalhost` varchar(50) DEFAULT NULL,
  51.     `externalid` varchar(255) DEFAULT NULL,
  52.     PRIMARY KEY (`id`),
  53. +   KEY `archsubm_arc_ix` (`archiveid`),
  54.     KEY `archsubm_gro_ix` (`group`),
  55. -   KEY `archsubm_arc_ix` (`archiveid`),
  56.     CONSTRAINT `archsubm_arc_fk` FOREIGN KEY (`archiveid`) REFERENCES `export_archive` (`id`),
  57.     CONSTRAINT `archsubm_gro_fk` FOREIGN KEY (`group`) REFERENCES `group` (`id`)
  58.   )
  59. # Comparing `mahara`.`artefact` to `maharatest`.`artefact`         [PASS]
  60. # WARNING: Table options are ignored and differences were found:
  61. #   ENGINE=InnoDB
  62. # - AUTO_INCREMENT=42438
  63. # ?                ^ ---
  64. # + AUTO_INCREMENT=12
  65. # ?                ^
  66. #   DEFAULT
  67. #   CHARSET=utf8
  68. # Comparing `mahara`.`artefact_access` to `maharatest`.`artefact_access`   [PASS]
  69. # Comparing `mahara`.`artefact_access_role` to `maharatest`.`artefact_access_role`   [PASS]
  70. # Comparing `mahara`.`artefact_access_usr` to `maharatest`.`artefact_access_usr`   [PASS]
  71. # Comparing `mahara`.`artefact_attachment` to `maharatest`.`artefact_attachment`   [PASS]
  72. # Comparing `mahara`.`artefact_blog_blogpost` to `maharatest`.`artefact_blog_blogpost`   [PASS]
  73. # Comparing `mahara`.`artefact_comment_comment` to `maharatest`.`artefact_comment_comment`   [FAIL]
  74. # Object definitions differ. (--changes-for=server1)
  75. #
  76.  
  77.   CREATE TABLE `artefact_comment_comment` (
  78.     `artefact` bigint(10) NOT NULL,
  79.     `onview` bigint(10) DEFAULT NULL,
  80.     `onartefact` bigint(10) DEFAULT NULL,
  81.     `private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  82.     `deletedby` varchar(50) DEFAULT NULL,
  83.     `requestpublic` varchar(50) DEFAULT NULL,
  84. -   `rating` bigint(10) unsigned DEFAULT NULL,
  85. ?                       ---------
  86. +   `rating` bigint(10) DEFAULT NULL,
  87.     `lastcontentupdate` datetime DEFAULT NULL,
  88.     PRIMARY KEY (`artefact`),
  89.     KEY `artecommcomm_art_ix` (`artefact`),
  90.     KEY `artecommcomm_onv_ix` (`onview`),
  91.     KEY `artecommcomm_ona_ix` (`onartefact`),
  92.     KEY `artecommcomm_del_ix` (`deletedby`),
  93.     KEY `artecommcomm_req_ix` (`requestpublic`),
  94.     CONSTRAINT `artecommcomm_art_fk` FOREIGN KEY (`artefact`) REFERENCES `artefact` (`id`),
  95.     CONSTRAINT `artecommcomm_del_fk` FOREIGN KEY (`deletedby`) REFERENCES `artefact_comment_deletedby` (`name`),
  96.     CONSTRAINT `artecommcomm_ona_fk` FOREIGN KEY (`onartefact`) REFERENCES `artefact` (`id`),
  97.     CONSTRAINT `artecommcomm_onv_fk` FOREIGN KEY (`onview`) REFERENCES `view` (`id`),
  98.     CONSTRAINT `artecommcomm_req_fk` FOREIGN KEY (`requestpublic`) REFERENCES `artefact_comment_deletedby` (`name`)
  99.   )
  100. # Comparing `mahara`.`artefact_comment_deletedby` to `maharatest`.`artefact_comment_deletedby`   [PASS]
  101. # Comparing `mahara`.`artefact_config` to `maharatest`.`artefact_config`   [PASS]
  102. # Comparing `mahara`.`artefact_cron` to `maharatest`.`artefact_cron`   [PASS]
  103. # Comparing `mahara`.`artefact_event_subscription` to `maharatest`.`artefact_event_subscription`   [PASS]
  104. # Comparing `mahara`.`artefact_file_files` to `maharatest`.`artefact_file_files`   [PASS]
  105. # Comparing `mahara`.`artefact_file_image` to `maharatest`.`artefact_file_image`   [PASS]
  106. # Comparing `mahara`.`artefact_file_mime_types` to `maharatest`.`artefact_file_mime_types`   [PASS]
  107. # Comparing `mahara`.`artefact_installed` to `maharatest`.`artefact_installed`   [PASS]
  108. # Comparing `mahara`.`artefact_installed_type` to `maharatest`.`artefact_installed_type`   [PASS]
  109. # Comparing `mahara`.`artefact_internal_profile_email` to `maharatest`.`artefact_internal_profile_email`   [PASS]
  110. # Comparing `mahara`.`artefact_license` to `maharatest`.`artefact_license`   [FAIL]
  111. # Object definitions differ. (--changes-for=server1)
  112. #
  113.  
  114.   CREATE TABLE `artefact_license` (
  115.     `name` varchar(255) NOT NULL,
  116.     `displayname` varchar(255) DEFAULT NULL,
  117.     `shortname` varchar(255) DEFAULT NULL,
  118. -   `icon` varchar(255) DEFAULT NULL,
  119. ?                       ^^^^^^
  120. +   `icon` varchar(255) NOT NULL,
  121. ?                       ^^
  122.     PRIMARY KEY (`name`)
  123.   )
  124. # Comparing `mahara`.`artefact_log` to `maharatest`.`artefact_log`   [PASS]
  125. # Comparing `mahara`.`artefact_multirecipient_notification` to `maharatest`.`artefact_multirecipient_notification`   [PASS]
  126. # Comparing `mahara`.`artefact_multirecipient_userrelation` to `maharatest`.`artefact_multirecipient_userrelation`   [PASS]
  127. # Comparing `mahara`.`artefact_plans_task` to `maharatest`.`artefact_plans_task`   [PASS]
  128. # WARNING: Table options are ignored and differences were found:
  129. #   ENGINE=InnoDB
  130. # - AUTO_INCREMENT=36144
  131. #   DEFAULT
  132. #   CHARSET=utf8
  133. # Comparing `mahara`.`artefact_resume_book` to `maharatest`.`artefact_resume_book`   [FAIL]
  134. # Object definitions differ. (--changes-for=server1)
  135. #
  136.  
  137.   CREATE TABLE `artefact_resume_book` (
  138.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  139.     `artefact` bigint(10) NOT NULL,
  140.     `date` text NOT NULL,
  141.     `title` text NOT NULL,
  142.     `contribution` text NOT NULL,
  143.     `description` text,
  144. +   `url` text,
  145.     `displayorder` bigint(10) NOT NULL,
  146. -   `url` text,
  147.     PRIMARY KEY (`id`),
  148.     KEY `arteresubook_art_ix` (`artefact`),
  149.     CONSTRAINT `arteresubook_art_fk` FOREIGN KEY (`artefact`) REFERENCES `artefact` (`id`)
  150.   )
  151. # Comparing `mahara`.`artefact_resume_certification` to `maharatest`.`artefact_resume_certification`   [PASS]
  152. # WARNING: Table options are ignored and differences were found:
  153. #   ENGINE=InnoDB
  154. # - AUTO_INCREMENT=562
  155. #   DEFAULT
  156. #   CHARSET=utf8
  157. # Comparing `mahara`.`artefact_resume_educationhistory` to `maharatest`.`artefact_resume_educationhistory`   [PASS]
  158. # WARNING: Table options are ignored and differences were found:
  159. #   ENGINE=InnoDB
  160. # - AUTO_INCREMENT=1192
  161. #   DEFAULT
  162. #   CHARSET=utf8
  163. # Comparing `mahara`.`artefact_resume_employmenthistory` to `maharatest`.`artefact_resume_employmenthistory`   [PASS]
  164. # WARNING: Table options are ignored and differences were found:
  165. #   ENGINE=InnoDB
  166. # - AUTO_INCREMENT=451
  167. #   DEFAULT
  168. #   CHARSET=utf8
  169. # Comparing `mahara`.`artefact_resume_membership` to `maharatest`.`artefact_resume_membership`   [PASS]
  170. # WARNING: Table options are ignored and differences were found:
  171. #   ENGINE=InnoDB
  172. # - AUTO_INCREMENT=52
  173. #   DEFAULT
  174. #   CHARSET=utf8
  175. # Comparing `mahara`.`artefact_resume_personal_information` to `maharatest`.`artefact_resume_personal_information`   [PASS]
  176. # Comparing `mahara`.`artefact_tag` to `maharatest`.`artefact_tag`   [PASS]
  177. # Comparing `mahara`.`auth_config` to `maharatest`.`auth_config`   [PASS]
  178. # Comparing `mahara`.`auth_cron` to `maharatest`.`auth_cron`       [PASS]
  179. # Comparing `mahara`.`auth_event_subscription` to `maharatest`.`auth_event_subscription`   [PASS]
  180. # Comparing `mahara`.`auth_installed` to `maharatest`.`auth_installed`   [PASS]
  181. # Comparing `mahara`.`auth_instance` to `maharatest`.`auth_instance`   [PASS]
  182. # WARNING: Table options are ignored and differences were found:
  183. #   ENGINE=InnoDB
  184. # - AUTO_INCREMENT=4
  185. # ?                ^
  186. # + AUTO_INCREMENT=7
  187. # ?                ^
  188. #   DEFAULT
  189. #   CHARSET=utf8
  190. # Comparing `mahara`.`auth_instance_config` to `maharatest`.`auth_instance_config`   [PASS]
  191. # Comparing `mahara`.`auth_remote_user` to `maharatest`.`auth_remote_user`   [PASS]
  192. # Comparing `mahara`.`block_instance` to `maharatest`.`block_instance`   [FAIL]
  193. # Object definitions differ. (--changes-for=server1)
  194. #
  195.  
  196.   CREATE TABLE `block_instance` (
  197.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  198.     `blocktype` varchar(255) NOT NULL,
  199.     `title` varchar(255) NOT NULL,
  200.     `configdata` text,
  201.     `view` bigint(10) NOT NULL,
  202. +   `row` tinyint(2) NOT NULL DEFAULT '1',
  203.     `column` tinyint(2) NOT NULL,
  204.     `order` tinyint(2) NOT NULL,
  205. -   `row` tinyint(2) NOT NULL DEFAULT '1',
  206.     PRIMARY KEY (`id`),
  207.     UNIQUE KEY `blocinst_vierowcolord_uk` (`view`,`row`,`column`,`order`),
  208.     KEY `blocinst_blo_ix` (`blocktype`),
  209.     KEY `blocinst_vie_ix` (`view`),
  210.     CONSTRAINT `blocinst_blo_fk` FOREIGN KEY (`blocktype`) REFERENCES `blocktype_installed` (`name`),
  211.     CONSTRAINT `blocinst_vie_fk` FOREIGN KEY (`view`) REFERENCES `view` (`id`)
  212.   )
  213. # Comparing `mahara`.`blocktype_category` to `maharatest`.`blocktype_category`   [FAIL]
  214. # Object definitions differ. (--changes-for=server1)
  215. #
  216.  
  217.   CREATE TABLE `blocktype_category` (
  218.     `name` varchar(50) NOT NULL,
  219. -   `sort` tinyint(2) unsigned DEFAULT NULL,
  220. ?                     ---------
  221. +   `sort` tinyint(2) DEFAULT NULL,
  222.     PRIMARY KEY (`name`),
  223.     UNIQUE KEY `bloccate_sor_uix` (`sort`)
  224.   )
  225. # Comparing `mahara`.`blocktype_config` to `maharatest`.`blocktype_config`   [PASS]
  226. # Comparing `mahara`.`blocktype_cron` to `maharatest`.`blocktype_cron`   [PASS]
  227. # Comparing `mahara`.`blocktype_event_subscription` to `maharatest`.`blocktype_event_subscription`   [PASS]
  228. # Comparing `mahara`.`blocktype_externalfeed_data` to `maharatest`.`blocktype_externalfeed_data`   [FAIL]
  229. # Object definitions differ. (--changes-for=server1)
  230. #
  231.  
  232.   CREATE TABLE `blocktype_externalfeed_data` (
  233.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  234.     `url` text NOT NULL,
  235. +   `insecuresslmode` tinyint(1) NOT NULL DEFAULT '0',
  236. +   `authuser` text,
  237. +   `authpassword` text,
  238.     `link` text,
  239.     `title` text,
  240.     `description` text,
  241.     `content` longtext,
  242.     `lastupdate` datetime DEFAULT NULL,
  243.     `image` text,
  244. -   `authuser` text,
  245. -   `authpassword` text,
  246. -   `insecuresslmode` tinyint(1) NOT NULL DEFAULT '0',
  247.     PRIMARY KEY (`id`),
  248.     KEY `blocextedata_urlautaut_ix` (`url`(255),`authuser`(255),`authpassword`(255))
  249.   )
  250. # Comparing `mahara`.`blocktype_installed` to `maharatest`.`blocktype_installed`   [PASS]
  251. # Comparing `mahara`.`blocktype_installed_category` to `maharatest`.`blocktype_installed_category`   [PASS]
  252. # Comparing `mahara`.`blocktype_installed_viewtype` to `maharatest`.`blocktype_installed_viewtype`   [PASS]
  253. # Comparing `mahara`.`blocktype_wall_post` to `maharatest`.`blocktype_wall_post`   [PASS]
  254. # WARNING: Table options are ignored and differences were found:
  255. #   ENGINE=InnoDB
  256. # - AUTO_INCREMENT=151
  257. #   DEFAULT
  258. #   CHARSET=utf8
  259. # Comparing `mahara`.`collection` to `maharatest`.`collection`     [PASS]
  260. # WARNING: Table options are ignored and differences were found:
  261. #   ENGINE=InnoDB
  262. # - AUTO_INCREMENT=298
  263. #   DEFAULT
  264. #   CHARSET=utf8
  265. # Comparing `mahara`.`collection_tag` to `maharatest`.`collection_tag`   [PASS]
  266. # Comparing `mahara`.`collection_view` to `maharatest`.`collection_view`   [PASS]
  267. # Comparing `mahara`.`config` to `maharatest`.`config`             [PASS]
  268. # Comparing `mahara`.`cron` to `maharatest`.`cron`                 [PASS]
  269. # WARNING: Table options are ignored and differences were found:
  270. #   ENGINE=InnoDB
  271. # - AUTO_INCREMENT=29
  272. # ?                 ^
  273. # + AUTO_INCREMENT=27
  274. # ?                 ^
  275. #   DEFAULT
  276. #   CHARSET=utf8
  277. # Comparing `mahara`.`event_log` to `maharatest`.`event_log`       [FAIL]
  278. # Object definitions differ. (--changes-for=server1)
  279. #
  280.  
  281.   CREATE TABLE `event_log` (
  282.     `usr` bigint(10) NOT NULL,
  283.     `realusr` bigint(10) NOT NULL,
  284. +   `time` datetime NOT NULL,
  285. -   `event` varchar(255) NOT NULL,
  286. ?                        ^^
  287. +   `event` varchar(255) DEFAULT NULL,
  288. ?                        ^^^^^^
  289.     `data` text,
  290. -   `time` datetime NOT NULL,
  291.     KEY `evenlog_usr_ix` (`usr`),
  292.     KEY `evenlog_rea_ix` (`realusr`),
  293.     CONSTRAINT `evenlog_rea_fk` FOREIGN KEY (`realusr`) REFERENCES `usr` (`id`),
  294.     CONSTRAINT `evenlog_usr_fk` FOREIGN KEY (`usr`) REFERENCES `usr` (`id`)
  295.   )
  296. # Comparing `mahara`.`event_subscription` to `maharatest`.`event_subscription`   [PASS]
  297. # Comparing `mahara`.`event_type` to `maharatest`.`event_type`     [PASS]
  298. # Comparing `mahara`.`export_archive` to `maharatest`.`export_archive`   [PASS]
  299. # Comparing `mahara`.`export_config` to `maharatest`.`export_config`   [PASS]
  300. # Comparing `mahara`.`export_cron` to `maharatest`.`export_cron`   [PASS]
  301. # Comparing `mahara`.`export_event_subscription` to `maharatest`.`export_event_subscription`   [PASS]
  302. # Comparing `mahara`.`export_installed` to `maharatest`.`export_installed`   [PASS]
  303. # Comparing `mahara`.`export_queue` to `maharatest`.`export_queue`   [PASS]
  304. # Comparing `mahara`.`export_queue_items` to `maharatest`.`export_queue_items`   [PASS]
  305. # Comparing `mahara`.`favorite` to `maharatest`.`favorite`         [FAIL]
  306. # Object definitions differ. (--changes-for=server1)
  307. #
  308.  
  309.   CREATE TABLE `favorite` (
  310.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  311.     `owner` bigint(10) NOT NULL,
  312.     `shortname` varchar(255) NOT NULL,
  313.     `institution` varchar(255) DEFAULT NULL,
  314. -   `ctime` datetime DEFAULT NULL,
  315. ?                    ^^^^^^
  316. +   `ctime` datetime NOT NULL,
  317. ?                    ^^
  318. -   `mtime` datetime DEFAULT NULL,
  319. ?                    ^^^^^^
  320. +   `mtime` datetime NOT NULL,
  321. ?                    ^^
  322.     PRIMARY KEY (`id`),
  323.     UNIQUE KEY `favo_ownsho_uix` (`owner`,`shortname`),
  324.     KEY `favo_own_ix` (`owner`),
  325.     KEY `favo_ins_ix` (`institution`),
  326.     CONSTRAINT `favo_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`),
  327.     CONSTRAINT `favo_own_fk` FOREIGN KEY (`owner`) REFERENCES `usr` (`id`)
  328.   )
  329. # Comparing `mahara`.`favorite_usr` to `maharatest`.`favorite_usr`   [PASS]
  330. # Comparing `mahara`.`group` to `maharatest`.`group`               [FAIL]
  331. # Object definitions differ. (--changes-for=server1)
  332. #
  333.  
  334.   CREATE TABLE `group` (
  335.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  336.     `name` varchar(128) NOT NULL,
  337.     `description` text,
  338.     `grouptype` varchar(20) NOT NULL,
  339.     `jointype` enum('open','controlled','approve') NOT NULL DEFAULT 'open',
  340.     `ctime` datetime NOT NULL,
  341.     `mtime` datetime NOT NULL,
  342.     `public` tinyint(1) NOT NULL DEFAULT '0',
  343.     `usersautoadded` tinyint(1) NOT NULL DEFAULT '0',
  344.     `deleted` tinyint(1) NOT NULL DEFAULT '0',
  345.     `category` bigint(10) DEFAULT NULL,
  346.     `viewnotify` tinyint(1) NOT NULL DEFAULT '1',
  347.     `quota` bigint(10) DEFAULT NULL,
  348.     `quotaused` bigint(10) NOT NULL DEFAULT '0',
  349.     `institution` varchar(255) DEFAULT NULL,
  350.     `shortname` varchar(255) DEFAULT NULL,
  351.     `request` tinyint(1) NOT NULL DEFAULT '0',
  352.     `submittableto` tinyint(1) NOT NULL DEFAULT '0',
  353.     `editroles` enum('all','notmember','admin') NOT NULL DEFAULT 'all',
  354.     `hidden` tinyint(1) NOT NULL DEFAULT '0',
  355.     `hidemembers` tinyint(1) NOT NULL DEFAULT '0',
  356.     `hidemembersfrommembers` tinyint(1) NOT NULL DEFAULT '0',
  357. +   `groupparticipationreports` tinyint(1) NOT NULL DEFAULT '0',
  358.     `invitefriends` tinyint(1) NOT NULL DEFAULT '0',
  359.     `suggestfriends` tinyint(1) NOT NULL DEFAULT '0',
  360.     `urlid` varchar(30) DEFAULT NULL,
  361. -   `groupparticipationreports` tinyint(1) NOT NULL DEFAULT '0',
  362.     `editwindowstart` datetime DEFAULT NULL,
  363.     `editwindowend` datetime DEFAULT NULL,
  364.     `sendnow` tinyint(1) NOT NULL DEFAULT '0',
  365.     `feedbacknotify` tinyint(1) NOT NULL DEFAULT '1',
  366.     `allowarchives` tinyint(1) NOT NULL DEFAULT '0',
  367.     PRIMARY KEY (`id`),
  368.     UNIQUE KEY `grou_nam_uk` (`name`),
  369.     UNIQUE KEY `grou_inssho_uix` (`institution`,`shortname`),
  370.     UNIQUE KEY `grou_url_uix` (`urlid`),
  371.     KEY `grou_gro_ix` (`grouptype`),
  372.     KEY `grou_cat_ix` (`category`),
  373.     KEY `grou_ins_ix` (`institution`),
  374.     CONSTRAINT `grou_cat_fk` FOREIGN KEY (`category`) REFERENCES `group_category` (`id`),
  375.     CONSTRAINT `grou_gro_fk` FOREIGN KEY (`grouptype`) REFERENCES `grouptype` (`name`),
  376.     CONSTRAINT `grou_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`)
  377.   )
  378. # Comparing `mahara`.`group_category` to `maharatest`.`group_category`   [PASS]
  379. # Comparing `mahara`.`group_member` to `maharatest`.`group_member`   [PASS]
  380. # Comparing `mahara`.`group_member_invite` to `maharatest`.`group_member_invite`   [PASS]
  381. # Comparing `mahara`.`group_member_request` to `maharatest`.`group_member_request`   [PASS]
  382. # Comparing `mahara`.`grouptype` to `maharatest`.`grouptype`       [PASS]
  383. # Comparing `mahara`.`grouptype_config` to `maharatest`.`grouptype_config`   [PASS]
  384. # Comparing `mahara`.`grouptype_cron` to `maharatest`.`grouptype_cron`   [PASS]
  385. # Comparing `mahara`.`grouptype_event_subscription` to `maharatest`.`grouptype_event_subscription`   [PASS]
  386. # Comparing `mahara`.`grouptype_installed` to `maharatest`.`grouptype_installed`   [PASS]
  387. # Comparing `mahara`.`grouptype_roles` to `maharatest`.`grouptype_roles`   [PASS]
  388. # Comparing `mahara`.`host` to `maharatest`.`host`                 [PASS]
  389. # Comparing `mahara`.`iframe_source` to `maharatest`.`iframe_source`   [PASS]
  390. # Comparing `mahara`.`iframe_source_icon` to `maharatest`.`iframe_source_icon`   [PASS]
  391. # Comparing `mahara`.`import_config` to `maharatest`.`import_config`   [PASS]
  392. # Comparing `mahara`.`import_cron` to `maharatest`.`import_cron`   [PASS]
  393. # Comparing `mahara`.`import_entry_requests` to `maharatest`.`import_entry_requests`   [PASS]
  394. # Comparing `mahara`.`import_event_subscription` to `maharatest`.`import_event_subscription`   [PASS]
  395. # Comparing `mahara`.`import_installed` to `maharatest`.`import_installed`   [PASS]
  396. # Comparing `mahara`.`import_queue` to `maharatest`.`import_queue`   [FAIL]
  397. # Object definitions differ. (--changes-for=server1)
  398. #
  399.  
  400.   CREATE TABLE `import_queue` (
  401.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  402.     `host` varchar(255) NOT NULL,
  403.     `usr` bigint(10) NOT NULL,
  404. -   `queue` tinyint(1) NOT NULL,
  405. +   `queue` tinyint(1) NOT NULL DEFAULT '1',
  406. ?                              ++++++++++++
  407. -   `ready` tinyint(1) NOT NULL,
  408. +   `ready` tinyint(1) NOT NULL DEFAULT '0',
  409. ?                              ++++++++++++
  410.     `expirytime` datetime NOT NULL,
  411.     `format` varchar(50) DEFAULT NULL,
  412.     `data` text,
  413.     `token` varchar(40) NOT NULL,
  414.     PRIMARY KEY (`id`),
  415.     KEY `impoqueu_usr_ix` (`usr`),
  416.     KEY `impoqueu_hos_ix` (`host`),
  417.     CONSTRAINT `impoqueu_hos_fk` FOREIGN KEY (`host`) REFERENCES `host` (`wwwroot`),
  418.     CONSTRAINT `impoqueu_usr_fk` FOREIGN KEY (`usr`) REFERENCES `usr` (`id`)
  419.   )
  420. # Comparing `mahara`.`institution` to `maharatest`.`institution`   [FAIL]
  421. # Object definitions differ. (--changes-for=server1)
  422. #
  423.  
  424.   CREATE TABLE `institution` (
  425. +   `id` bigint(10) NOT NULL AUTO_INCREMENT,
  426.     `name` varchar(255) NOT NULL,
  427. -   `id` bigint(10) NOT NULL AUTO_INCREMENT,
  428.     `displayname` varchar(255) NOT NULL,
  429.     `registerallowed` tinyint(1) NOT NULL DEFAULT '0',
  430.     `theme` varchar(255) DEFAULT NULL,
  431.     `defaultmembershipperiod` bigint(10) DEFAULT NULL,
  432.     `maxuseraccounts` bigint(10) DEFAULT NULL,
  433.     `expiry` datetime DEFAULT NULL,
  434.     `expirymailsent` tinyint(1) NOT NULL DEFAULT '0',
  435.     `suspended` tinyint(1) NOT NULL DEFAULT '0',
  436.     `priority` bigint(10) NOT NULL DEFAULT '1',
  437.     `defaultquota` bigint(10) DEFAULT NULL,
  438.     `showonlineusers` bigint(10) NOT NULL DEFAULT '2',
  439. -   `allowinstitutionpublicviews` tinyint(1) NOT NULL DEFAULT '1',
  440. ?                                                              ^
  441. +   `allowinstitutionpublicviews` tinyint(1) NOT NULL DEFAULT '0',
  442. ?                                                              ^
  443.     `registerconfirm` tinyint(1) NOT NULL DEFAULT '1',
  444.     `logo` bigint(10) DEFAULT NULL,
  445.     `style` bigint(10) DEFAULT NULL,
  446. +   `licensemandatory` tinyint(1) NOT NULL DEFAULT '0',
  447.     `licensedefault` varchar(255) DEFAULT NULL,
  448. -   `licensemandatory` tinyint(1) NOT NULL DEFAULT '0',
  449.     `dropdownmenu` tinyint(1) NOT NULL DEFAULT '0',
  450.     `skins` tinyint(1) NOT NULL DEFAULT '1',
  451.     PRIMARY KEY (`name`),
  452.     UNIQUE KEY `inst_id_uk` (`id`),
  453. +   KEY `inst_sty_ix` (`style`),
  454.     KEY `inst_log_ix` (`logo`),
  455. -   KEY `inst_sty_ix` (`style`),
  456.     CONSTRAINT `inst_log_fk` FOREIGN KEY (`logo`) REFERENCES `artefact` (`id`),
  457.     CONSTRAINT `inst_sty_fk` FOREIGN KEY (`style`) REFERENCES `style` (`id`)
  458.   )
  459. # Comparing `mahara`.`institution_config` to `maharatest`.`institution_config`   [PASS]
  460. # WARNING: Table options are ignored and differences were found:
  461. #   ENGINE=InnoDB
  462. # - AUTO_INCREMENT=6
  463. # ?                ^
  464. # + AUTO_INCREMENT=11
  465. # ?                ^^
  466. #   DEFAULT
  467. #   CHARSET=utf8
  468. # Comparing `mahara`.`institution_data` to `maharatest`.`institution_data`   [FAIL]
  469. # Object definitions differ. (--changes-for=server1)
  470. #
  471.  
  472.   CREATE TABLE `institution_data` (
  473. -   `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  474. +   `ctime` datetime NOT NULL,
  475. -   `institution` varchar(255) NOT NULL DEFAULT '',
  476. ?                                      -----------
  477. +   `institution` varchar(255) NOT NULL,
  478.     `type` varchar(255) NOT NULL,
  479.     `value` text,
  480.     PRIMARY KEY (`ctime`,`institution`,`type`),
  481.     KEY `instdata_ins_ix` (`institution`),
  482.     CONSTRAINT `instdata_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`)
  483.   )
  484. # Comparing `mahara`.`institution_locked_profile_field` to `maharatest`.`institution_locked_profile_field`   [PASS]
  485. # Comparing `mahara`.`institution_registration` to `maharatest`.`institution_registration`   [FAIL]
  486. # Object definitions differ. (--changes-for=server1)
  487. #
  488.  
  489.   CREATE TABLE `institution_registration` (
  490.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  491.     `time` datetime NOT NULL,
  492. -   `institution` varchar(255) DEFAULT NULL,
  493. ?                              ^^^^^^
  494. +   `institution` varchar(255) NOT NULL,
  495. ?                              ^^
  496.     PRIMARY KEY (`id`),
  497.     KEY `instregi_ins_ix` (`institution`),
  498.     CONSTRAINT `instregi_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`)
  499.   )
  500. # Comparing `mahara`.`institution_registration_data` to `maharatest`.`institution_registration_data`   [PASS]
  501. # Comparing `mahara`.`interaction_config` to `maharatest`.`interaction_config`   [PASS]
  502. # Comparing `mahara`.`interaction_cron` to `maharatest`.`interaction_cron`   [PASS]
  503. # Comparing `mahara`.`interaction_event_subscription` to `maharatest`.`interaction_event_subscription`   [PASS]
  504. # Comparing `mahara`.`interaction_forum_edit` to `maharatest`.`interaction_forum_edit`   [PASS]
  505. # Comparing `mahara`.`interaction_forum_instance_config` to `maharatest`.`interaction_forum_instance_config`   [PASS]
  506. # Comparing `mahara`.`interaction_forum_moderator` to `maharatest`.`interaction_forum_moderator`   [PASS]
  507. # Comparing `mahara`.`interaction_forum_post` to `maharatest`.`interaction_forum_post`   [FAIL]
  508. # Object definitions differ. (--changes-for=server1)
  509. #
  510.  
  511.   CREATE TABLE `interaction_forum_post` (
  512.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  513.     `topic` bigint(10) NOT NULL,
  514.     `parent` bigint(10) DEFAULT NULL,
  515.     `poster` bigint(10) NOT NULL,
  516.     `subject` varchar(255) DEFAULT NULL,
  517.     `body` text NOT NULL,
  518.     `ctime` datetime NOT NULL,
  519.     `deleted` tinyint(1) NOT NULL DEFAULT '0',
  520.     `sent` tinyint(1) NOT NULL DEFAULT '0',
  521.     `path` varchar(2048) DEFAULT NULL,
  522.     PRIMARY KEY (`id`),
  523. +   KEY `inteforupost_pat_ix` (`path`(255)),
  524.     KEY `inteforupost_top_ix` (`topic`),
  525.     KEY `inteforupost_par_ix` (`parent`),
  526.     KEY `inteforupost_pos_ix` (`poster`),
  527. -   KEY `inteforupost_pat_ix` (`path`(255)),
  528.     CONSTRAINT `inteforupost_par_fk` FOREIGN KEY (`parent`) REFERENCES `interaction_forum_post` (`id`),
  529.     CONSTRAINT `inteforupost_pos_fk` FOREIGN KEY (`poster`) REFERENCES `usr` (`id`),
  530.     CONSTRAINT `inteforupost_top_fk` FOREIGN KEY (`topic`) REFERENCES `interaction_forum_topic` (`id`)
  531.   )
  532. # Comparing `mahara`.`interaction_forum_subscription_forum` to `maharatest`.`interaction_forum_subscription_forum`   [PASS]
  533. # Comparing `mahara`.`interaction_forum_subscription_topic` to `maharatest`.`interaction_forum_subscription_topic`   [PASS]
  534. # Comparing `mahara`.`interaction_forum_topic` to `maharatest`.`interaction_forum_topic`   [PASS]
  535. # WARNING: Table options are ignored and differences were found:
  536. #   ENGINE=InnoDB
  537. # - AUTO_INCREMENT=239
  538. #   DEFAULT
  539. #   CHARSET=utf8
  540. # Comparing `mahara`.`interaction_installed` to `maharatest`.`interaction_installed`   [PASS]
  541. # Comparing `mahara`.`interaction_instance` to `maharatest`.`interaction_instance`   [PASS]
  542. # WARNING: Table options are ignored and differences were found:
  543. #   ENGINE=InnoDB
  544. # - AUTO_INCREMENT=114
  545. # ?                ^^^
  546. # + AUTO_INCREMENT=3
  547. # ?                ^
  548. #   DEFAULT
  549. #   CHARSET=utf8
  550. # Comparing `mahara`.`module_config` to `maharatest`.`module_config`   [PASS]
  551. # Comparing `mahara`.`module_cron` to `maharatest`.`module_cron`   [PASS]
  552. # WARNING: The tables structure is the same, but the columns order is different. Use --change-for to take the order into account.
  553. # Comparing `mahara`.`module_event_subscription` to `maharatest`.`module_event_subscription`   [FAIL]
  554. # Object definitions differ. (--changes-for=server1)
  555. #
  556.  
  557.   CREATE TABLE `module_event_subscription` (
  558. -   `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  559. ?                   ---------
  560. +   `id` bigint(10) NOT NULL AUTO_INCREMENT,
  561.     `plugin` varchar(255) NOT NULL,
  562.     `event` varchar(50) NOT NULL,
  563.     `callfunction` varchar(255) NOT NULL,
  564.     PRIMARY KEY (`id`),
  565.     UNIQUE KEY `moduevensubs_pluevecal_uk` (`plugin`,`event`,`callfunction`),
  566.     KEY `moduevensubs_plu_ix` (`plugin`),
  567.     KEY `moduevensubs_eve_ix` (`event`),
  568.     CONSTRAINT `moduevensubs_eve_fk` FOREIGN KEY (`event`) REFERENCES `event_type` (`name`),
  569.     CONSTRAINT `moduevensubs_plu_fk` FOREIGN KEY (`plugin`) REFERENCES `module_installed` (`name`)
  570.   )
  571. # Comparing `mahara`.`module_installed` to `maharatest`.`module_installed`   [FAIL]
  572. # Object definitions differ. (--changes-for=server1)
  573. #
  574.  
  575.   CREATE TABLE `module_installed` (
  576.     `name` varchar(255) NOT NULL,
  577. -   `version` bigint(10) unsigned NOT NULL,
  578. ?                        ---------
  579. +   `version` bigint(10) NOT NULL,
  580.     `release` text NOT NULL,
  581. -   `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  582. ?                       ---------
  583. +   `active` tinyint(1) NOT NULL DEFAULT '1',
  584.     PRIMARY KEY (`name`)
  585.   )
  586. # Comparing `mahara`.`notification_config` to `maharatest`.`notification_config`   [PASS]
  587. # Comparing `mahara`.`notification_cron` to `maharatest`.`notification_cron`   [PASS]
  588. # Comparing `mahara`.`notification_emaildigest_queue` to `maharatest`.`notification_emaildigest_queue`   [PASS]
  589. # Comparing `mahara`.`notification_event_subscription` to `maharatest`.`notification_event_subscription`   [PASS]
  590. # Comparing `mahara`.`notification_installed` to `maharatest`.`notification_installed`   [PASS]
  591. # Comparing `mahara`.`notification_internal_activity` to `maharatest`.`notification_internal_activity`   [PASS]
  592. # WARNING: Table options are ignored and differences were found:
  593. #   ENGINE=InnoDB
  594. # - AUTO_INCREMENT=23564
  595. # ?                - ---
  596. # + AUTO_INCREMENT=3
  597. #   DEFAULT
  598. #   CHARSET=utf8
  599. # Comparing `mahara`.`objectionable` to `maharatest`.`objectionable`   [PASS]
  600. # Comparing `mahara`.`search_config` to `maharatest`.`search_config`   [PASS]
  601. # Comparing `mahara`.`search_cron` to `maharatest`.`search_cron`   [PASS]
  602. # Comparing `mahara`.`search_elasticsearch_queue` to `maharatest`.`search_elasticsearch_queue`   [PASS]
  603. # Comparing `mahara`.`search_event_subscription` to `maharatest`.`search_event_subscription`   [PASS]
  604. # Comparing `mahara`.`search_installed` to `maharatest`.`search_installed`   [PASS]
  605. # Comparing `mahara`.`site_content` to `maharatest`.`site_content`   [FAIL]
  606. # Object definitions differ. (--changes-for=server1)
  607. #
  608.  
  609.   CREATE TABLE `site_content` (
  610.     `name` varchar(50) NOT NULL,
  611.     `content` text NOT NULL,
  612. -   `ctime` datetime DEFAULT NULL,
  613. ?                    ^^^^^^
  614. +   `ctime` datetime NOT NULL,
  615. ?                    ^^
  616.     `mtime` datetime NOT NULL,
  617.     `mauthor` bigint(10) DEFAULT NULL,
  618. -   `institution` varchar(255) NOT NULL DEFAULT '',
  619. ?                                      -----------
  620. +   `institution` varchar(255) NOT NULL,
  621.     PRIMARY KEY (`name`,`institution`),
  622.     KEY `sitecont_mau_ix` (`mauthor`),
  623.     KEY `sitecont_ins_ix` (`institution`),
  624.     CONSTRAINT `sitecont_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`),
  625.     CONSTRAINT `sitecont_mau_fk` FOREIGN KEY (`mauthor`) REFERENCES `usr` (`id`)
  626.   )
  627. # Comparing `mahara`.`site_data` to `maharatest`.`site_data`       [PASS]
  628. # Comparing `mahara`.`site_menu` to `maharatest`.`site_menu`       [PASS]
  629. # Comparing `mahara`.`site_registration` to `maharatest`.`site_registration`   [PASS]
  630. # WARNING: Table options are ignored and differences were found:
  631. #   ENGINE=InnoDB
  632. # - AUTO_INCREMENT=79
  633. #   DEFAULT
  634. #   CHARSET=utf8
  635. # Comparing `mahara`.`site_registration_data` to `maharatest`.`site_registration_data`   [PASS]
  636. # Comparing `mahara`.`skin` to `maharatest`.`skin`                 [FAIL]
  637. # Object definitions differ. (--changes-for=server1)
  638. #
  639.  
  640.   CREATE TABLE `skin` (
  641.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  642.     `title` varchar(255) NOT NULL,
  643.     `description` text,
  644.     `owner` bigint(10) NOT NULL,
  645. -   `type` varchar(10) NOT NULL,
  646. +   `type` varchar(10) NOT NULL DEFAULT 'private',
  647. ?                              ++++++++++++++++++
  648.     `viewskin` text NOT NULL,
  649.     `bodybgimg` bigint(10) DEFAULT NULL,
  650.     `viewbgimg` bigint(10) DEFAULT NULL,
  651.     `ctime` datetime DEFAULT NULL,
  652.     `mtime` datetime DEFAULT NULL,
  653.     PRIMARY KEY (`id`),
  654.     KEY `skin_own_ix` (`owner`),
  655.     CONSTRAINT `skin_own_fk` FOREIGN KEY (`owner`) REFERENCES `usr` (`id`)
  656.   )
  657. # Comparing `mahara`.`skin_favorites` to `maharatest`.`skin_favorites`   [PASS]
  658. # Comparing `mahara`.`skin_fonts` to `maharatest`.`skin_fonts`     [FAIL]
  659. # Object definitions differ. (--changes-for=server1)
  660. #
  661.  
  662.   CREATE TABLE `skin_fonts` (
  663.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  664.     `name` varchar(100) NOT NULL,
  665.     `title` varchar(255) NOT NULL,
  666.     `licence` varchar(255) DEFAULT NULL,
  667.     `notice` text,
  668.     `previewfont` varchar(255) NOT NULL,
  669.     `variants` text NOT NULL,
  670. -   `fonttype` varchar(10) NOT NULL,
  671. +   `fonttype` varchar(10) NOT NULL DEFAULT 'site',
  672. ?                                  +++++++++++++++
  673. -   `onlyheading` tinyint(1) NOT NULL,
  674. +   `onlyheading` tinyint(1) NOT NULL DEFAULT '0',
  675. ?                                    ++++++++++++
  676.     `fontstack` text NOT NULL,
  677.     `genericfont` enum('cursive','fantasy','monospace','sans-serif','serif') NOT NULL,
  678.     PRIMARY KEY (`id`),
  679.     UNIQUE KEY `skinfont_nam_uk` (`name`)
  680.   )
  681. # Comparing `mahara`.`sso_session` to `maharatest`.`sso_session`   [PASS]
  682. # Comparing `mahara`.`style` to `maharatest`.`style`               [PASS]
  683. # Comparing `mahara`.`style_property` to `maharatest`.`style_property`   [PASS]
  684. # Comparing `mahara`.`usr` to `maharatest`.`usr`                   [PASS]
  685. # WARNING: Table options are ignored and differences were found:
  686. #   ENGINE=InnoDB
  687. # - AUTO_INCREMENT=1521
  688. # ?                ^^^^
  689. # + AUTO_INCREMENT=3
  690. # ?                ^
  691. #   DEFAULT
  692. #   CHARSET=utf8
  693. # Comparing `mahara`.`usr_account_preference` to `maharatest`.`usr_account_preference`   [PASS]
  694. # Comparing `mahara`.`usr_activity_preference` to `maharatest`.`usr_activity_preference`   [PASS]
  695. # Comparing `mahara`.`usr_custom_layout` to `maharatest`.`usr_custom_layout`   [PASS]
  696. # WARNING: The tables structure is the same, but the columns order is different. Use --change-for to take the order into account.
  697. # Comparing `mahara`.`usr_friend` to `maharatest`.`usr_friend`     [PASS]
  698. # Comparing `mahara`.`usr_friend_request` to `maharatest`.`usr_friend_request`   [PASS]
  699. # Comparing `mahara`.`usr_infectedupload` to `maharatest`.`usr_infectedupload`   [PASS]
  700. # Comparing `mahara`.`usr_institution` to `maharatest`.`usr_institution`   [PASS]
  701. # Comparing `mahara`.`usr_institution_request` to `maharatest`.`usr_institution_request`   [PASS]
  702. # Comparing `mahara`.`usr_password_request` to `maharatest`.`usr_password_request`   [PASS]
  703. # Comparing `mahara`.`usr_registration` to `maharatest`.`usr_registration`   [PASS]
  704. # Comparing `mahara`.`usr_session` to `maharatest`.`usr_session`   [PASS]
  705. # Comparing `mahara`.`usr_tag` to `maharatest`.`usr_tag`           [PASS]
  706. # Comparing `mahara`.`usr_watchlist_view` to `maharatest`.`usr_watchlist_view`   [PASS]
  707. # Comparing `mahara`.`view` to `maharatest`.`view`                 [FAIL]
  708. # Object definitions differ. (--changes-for=server1)
  709. #
  710.  
  711.   CREATE TABLE `view` (
  712.     `id` bigint(10) NOT NULL AUTO_INCREMENT,
  713.     `title` text NOT NULL,
  714.     `description` text,
  715.     `owner` bigint(10) DEFAULT NULL,
  716.     `ownerformat` text,
  717.     `group` bigint(10) DEFAULT NULL,
  718.     `institution` varchar(255) DEFAULT NULL,
  719.     `startdate` datetime DEFAULT NULL,
  720.     `stopdate` datetime DEFAULT NULL,
  721.     `ctime` datetime NOT NULL,
  722.     `mtime` datetime NOT NULL,
  723.     `atime` datetime NOT NULL,
  724.     `submittedgroup` bigint(10) DEFAULT NULL,
  725.     `submittedhost` varchar(255) DEFAULT NULL,
  726.     `submittedtime` datetime DEFAULT NULL,
  727.     `submittedstatus` tinyint(1) NOT NULL DEFAULT '0',
  728. +   `numrows` tinyint(2) NOT NULL DEFAULT '1',
  729.     `numcolumns` tinyint(2) NOT NULL,
  730.     `layout` bigint(10) DEFAULT NULL,
  731. +   `skin` bigint(10) DEFAULT NULL,
  732.     `theme` varchar(255) DEFAULT NULL,
  733.     `template` tinyint(1) NOT NULL DEFAULT '0',
  734. +   `retainview` tinyint(1) NOT NULL DEFAULT '0',
  735.     `copynewuser` tinyint(1) NOT NULL DEFAULT '0',
  736.     `type` varchar(50) NOT NULL,
  737.     `visits` bigint(10) NOT NULL DEFAULT '0',
  738.     `allowcomments` tinyint(1) NOT NULL DEFAULT '1',
  739.     `approvecomments` tinyint(1) NOT NULL DEFAULT '0',
  740.     `accessconf` varchar(40) DEFAULT NULL,
  741. -   `retainview` tinyint(1) NOT NULL DEFAULT '0',
  742.     `locked` tinyint(1) NOT NULL DEFAULT '0',
  743.     `urlid` varchar(100) DEFAULT NULL,
  744. -   `numrows` tinyint(2) NOT NULL DEFAULT '1',
  745. -   `skin` bigint(10) DEFAULT NULL,
  746.     `anonymise` tinyint(1) NOT NULL DEFAULT '0',
  747.     PRIMARY KEY (`id`),
  748.     UNIQUE KEY `view_urlowngroins_uix` (`urlid`,`owner`,`group`,`institution`),
  749.     KEY `view_own_ix` (`owner`),
  750.     KEY `view_sub_ix` (`submittedgroup`),
  751.     KEY `view_sub2_ix` (`submittedhost`),
  752.     KEY `view_lay_ix` (`layout`),
  753.     KEY `view_gro_ix` (`group`),
  754.     KEY `view_ins_ix` (`institution`),
  755.     KEY `view_typ_ix` (`type`),
  756.     CONSTRAINT `view_gro_fk` FOREIGN KEY (`group`) REFERENCES `group` (`id`),
  757.     CONSTRAINT `view_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`),
  758.     CONSTRAINT `view_lay_fk` FOREIGN KEY (`layout`) REFERENCES `view_layout` (`id`),
  759.     CONSTRAINT `view_own_fk` FOREIGN KEY (`owner`) REFERENCES `usr` (`id`),
  760.     CONSTRAINT `view_sub2_fk` FOREIGN KEY (`submittedhost`) REFERENCES `host` (`wwwroot`),
  761.     CONSTRAINT `view_sub_fk` FOREIGN KEY (`submittedgroup`) REFERENCES `group` (`id`),
  762.     CONSTRAINT `view_typ_fk` FOREIGN KEY (`type`) REFERENCES `view_type` (`type`)
  763.   )
  764. # Comparing `mahara`.`view_access` to `maharatest`.`view_access`   [FAIL]
  765. # Object definitions differ. (--changes-for=server1)
  766. #
  767.  
  768.   CREATE TABLE `view_access` (
  769.     `view` bigint(10) NOT NULL,
  770.     `accesstype` enum('public','loggedin','friends') DEFAULT NULL,
  771.     `group` bigint(10) DEFAULT NULL,
  772.     `role` varchar(255) DEFAULT NULL,
  773.     `usr` bigint(10) DEFAULT NULL,
  774. +   `institution` varchar(255) DEFAULT NULL,
  775.     `token` varchar(100) DEFAULT NULL,
  776.     `visible` tinyint(1) NOT NULL DEFAULT '1',
  777.     `startdate` datetime DEFAULT NULL,
  778.     `stopdate` datetime DEFAULT NULL,
  779.     `allowcomments` tinyint(1) NOT NULL DEFAULT '0',
  780.     `approvecomments` tinyint(1) NOT NULL DEFAULT '1',
  781. -   `ctime` datetime DEFAULT NULL,
  782. ?                    ^^^^^^
  783. +   `ctime` datetime NOT NULL,
  784. ?                    ^^
  785. -   `institution` varchar(255) DEFAULT NULL,
  786.     KEY `viewacce_tok_ix` (`token`),
  787. +   KEY `viewacce_acc_ix` (`accesstype`),
  788.     KEY `viewacce_vie_ix` (`view`),
  789.     KEY `viewacce_gro_ix` (`group`),
  790.     KEY `viewacce_usr_ix` (`usr`),
  791. -   KEY `viewacce_acc_ix` (`accesstype`),
  792.     KEY `viewacce_ins_ix` (`institution`),
  793.     CONSTRAINT `viewacce_gro_fk` FOREIGN KEY (`group`) REFERENCES `group` (`id`),
  794.     CONSTRAINT `viewacce_ins_fk` FOREIGN KEY (`institution`) REFERENCES `institution` (`name`),
  795.     CONSTRAINT `viewacce_usr_fk` FOREIGN KEY (`usr`) REFERENCES `usr` (`id`),
  796.     CONSTRAINT `viewacce_vie_fk` FOREIGN KEY (`view`) REFERENCES `view` (`id`)
  797.   )
  798. # Comparing `mahara`.`view_artefact` to `maharatest`.`view_artefact`   [PASS]
  799. # WARNING: Table options are ignored and differences were found:
  800. #   ENGINE=InnoDB
  801. # - AUTO_INCREMENT=112474
  802. # ?                ^^^^^^
  803. # + AUTO_INCREMENT=5
  804. # ?                ^
  805. #   DEFAULT
  806. #   CHARSET=utf8
  807. # Comparing `mahara`.`view_autocreate_grouptype` to `maharatest`.`view_autocreate_grouptype`   [PASS]
  808. # Comparing `mahara`.`view_layout` to `maharatest`.`view_layout`   [PASS]
  809. # Comparing `mahara`.`view_layout_columns` to `maharatest`.`view_layout_columns`   [PASS]
  810. # Comparing `mahara`.`view_layout_rows_columns` to `maharatest`.`view_layout_rows_columns`   [PASS]
  811. # Comparing `mahara`.`view_rows_columns` to `maharatest`.`view_rows_columns`   [FAIL]
  812. # Object definitions differ. (--changes-for=server1)
  813. #
  814.  
  815.   CREATE TABLE `view_rows_columns` (
  816. +   `id` bigint(10) NOT NULL AUTO_INCREMENT,
  817.     `view` bigint(10) NOT NULL,
  818. -   `id` bigint(10) NOT NULL AUTO_INCREMENT,
  819.     `row` tinyint(1) NOT NULL,
  820.     `columns` tinyint(1) NOT NULL,
  821.     PRIMARY KEY (`id`),
  822.     KEY `viewrowscolu_vie_ix` (`view`),
  823.     CONSTRAINT `viewrowscolu_vie_fk` FOREIGN KEY (`view`) REFERENCES `view` (`id`)
  824.   )
  825. # Comparing `mahara`.`view_tag` to `maharatest`.`view_tag`         [PASS]
  826. # Comparing `mahara`.`view_type` to `maharatest`.`view_type`       [FAIL]
  827. # Object definitions differ. (--changes-for=server1)
  828. #
  829.  
  830.   CREATE TABLE `view_type` (
  831. -   `type` varchar(50) NOT NULL DEFAULT '',
  832. ?                              -----------
  833. +   `type` varchar(50) NOT NULL,
  834.     PRIMARY KEY (`type`)
  835.   )
  836. # Comparing `mahara`.`view_visit` to `maharatest`.`view_visit`     [PASS]
  837. # Comparing `mahara`.`watchlist_queue` to `maharatest`.`watchlist_queue`   [PASS]
  838. # Comparing `mahara`.`unmark_quota_exceed_upd_usr_set_trigger` to `maharatest`.`unmark_quota_exceed_upd_usr_set_trigger`   [FAIL]
  839. # Object definitions differ. (--changes-for=server1)
  840. #
  841.  
  842. - CREATE DEFINER="mahara"@"localhost" TRIGGER "unmark_quota_exceed_upd_usr_set_trigger" AFTER UPDATE
  843. ?                          ^^^^^^^^^
  844. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "unmark_quota_exceed_upd_usr_set_trigger" AFTER UPDATE
  845. ?                       +++++++   ^
  846.                   ON "usr" FOR EACH ROW
  847.                   BEGIN
  848.  
  849.                   UPDATE "usr_account_preference", "artefact_config"
  850.                   SET "usr_account_preference".value = 0
  851.                   WHERE "usr_account_preference".field = 'quota_exceeded_notified'
  852.                   AND "usr_account_preference".usr = NEW.id
  853.                   AND "artefact_config".plugin = 'file'
  854.                   AND "artefact_config".field = 'quotanotifylimit'
  855.                   AND NEW.quotaused/NEW.quota < "artefact_config".value/100;
  856.                   END
  857. # Comparing `mahara`.`update_unread_delete2_trigger` to `maharatest`.`update_unread_delete2_trigger`   [FAIL]
  858. # Object definitions differ. (--changes-for=server1)
  859. #
  860.  
  861. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_delete2_trigger" AFTER DELETE
  862. ?                          ^^^^^^^^^
  863. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_delete2_trigger" AFTER DELETE
  864. ?                       +++++++   ^
  865.                   ON "artefact_multirecipient_userrelation" FOR EACH ROW
  866.                   BEGIN
  867.  
  868.                   IF OLD.read = '0' AND OLD.role = 'recipient' THEN
  869.                       UPDATE "usr" SET unread = unread - 1 WHERE id = OLD.usr;
  870.                   END IF;
  871.                   END
  872. # Comparing `mahara`.`update_unread_delete_trigger` to `maharatest`.`update_unread_delete_trigger`   [FAIL]
  873. # Object definitions differ. (--changes-for=server1)
  874. #
  875.  
  876. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_delete_trigger" AFTER DELETE
  877. ?                          ^^^^^^^^^
  878. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_delete_trigger" AFTER DELETE
  879. ?                       +++++++   ^
  880.                   ON "notification_internal_activity" FOR EACH ROW
  881.                   BEGIN
  882.  
  883. -             IF OLD.read = 0 THEN
  884. +                 IF OLD.read = 0 THEN
  885. ? ++++
  886. -                 UPDATE "usr" SET unread = unread - 1 WHERE id = OLD.usr;
  887. +                     UPDATE "usr" SET unread = unread - 1 WHERE id = OLD.usr;
  888. ? ++++
  889. -             END IF;
  890. +                 END IF;
  891. ? ++++
  892.                   END
  893. # Comparing `mahara`.`update_unread_insert2_trigger` to `maharatest`.`update_unread_insert2_trigger`   [FAIL]
  894. # Object definitions differ. (--changes-for=server1)
  895. #
  896.  
  897. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_insert2_trigger" AFTER INSERT
  898. ?                          ^^^^^^^^^
  899. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_insert2_trigger" AFTER INSERT
  900. ?                       +++++++   ^
  901.                   ON "artefact_multirecipient_userrelation" FOR EACH ROW
  902.                   BEGIN
  903.  
  904.                   IF NEW.role = 'recipient' AND NEW.read = '0' THEN
  905.                       UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  906.                   END IF;
  907.                   END
  908. # Comparing `mahara`.`update_unread_insert_trigger` to `maharatest`.`update_unread_insert_trigger`   [FAIL]
  909. # Object definitions differ. (--changes-for=server1)
  910. #
  911.  
  912. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_insert_trigger" AFTER INSERT
  913. ?                          ^^^^^^^^^
  914. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_insert_trigger" AFTER INSERT
  915. ?                       +++++++   ^
  916.                   ON "notification_internal_activity" FOR EACH ROW
  917.                   BEGIN
  918.  
  919. -             IF NEW.read = 0 THEN
  920. +                 IF NEW.read = 0 THEN
  921. ? ++++
  922. -                 UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  923. +                     UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  924. ? ++++
  925. -             END IF;
  926. +                 END IF;
  927. ? ++++
  928.                   END
  929. # Comparing `mahara`.`update_unread_update2_trigger` to `maharatest`.`update_unread_update2_trigger`   [FAIL]
  930. # Object definitions differ. (--changes-for=server1)
  931. #
  932.  
  933. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_update2_trigger" AFTER UPDATE
  934. ?                          ^^^^^^^^^
  935. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_update2_trigger" AFTER UPDATE
  936. ?                       +++++++   ^
  937.                   ON "artefact_multirecipient_userrelation" FOR EACH ROW
  938.                   BEGIN
  939.  
  940.                   IF OLD.read = '0' AND NEW.read = '1' AND NEW.role = 'recipient' THEN
  941.                       UPDATE "usr" SET unread = unread - 1 WHERE id = NEW.usr;
  942.                   ELSEIF OLD.read = '1' AND NEW.read = '0' AND NEW.role = 'recipient' THEN
  943.                       UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  944.                   END IF;
  945.                   END
  946. # Comparing `mahara`.`update_unread_update_trigger` to `maharatest`.`update_unread_update_trigger`   [FAIL]
  947. # Object definitions differ. (--changes-for=server1)
  948. #
  949.  
  950. - CREATE DEFINER="mahara"@"localhost" TRIGGER "update_unread_update_trigger" AFTER UPDATE
  951. ?                          ^^^^^^^^^
  952. + CREATE DEFINER="maharadevelop"@"%" TRIGGER "update_unread_update_trigger" AFTER UPDATE
  953. ?                       +++++++   ^
  954.                   ON "notification_internal_activity" FOR EACH ROW
  955.                   BEGIN
  956.  
  957. -             IF OLD.read = 0 AND NEW.read = 1 THEN
  958. +                 IF OLD.read = 0 AND NEW.read = 1 THEN
  959. ? ++++
  960. -                 UPDATE "usr" SET unread = unread - 1 WHERE id = NEW.usr;
  961. +                     UPDATE "usr" SET unread = unread - 1 WHERE id = NEW.usr;
  962. ? ++++
  963. -             ELSEIF OLD.read = 1 AND NEW.read = 0 THEN
  964. +                 ELSEIF OLD.read = 1 AND NEW.read = 0 THEN
  965. ? ++++
  966. -                 UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  967. +                     UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr;
  968. ? ++++
  969. -             END IF;
  970. +                 END IF;
  971. ? ++++
  972.                   END
  973. Compare failed. One or more differences found.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!