{"action":"created","issue":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/1031","labels_url":"https://api.github.com/repos/propelorm/Propel2/issues/1031/labels{/name}","comments_url":"https://api.github.com/repos/propelorm/Propel2/issues/1031/comments","events_url":"https://api.github.com/repos/propelorm/Propel2/issues/1031/events","html_url":"https://github.com/propelorm/Propel2/issues/1031","id":115832762,"number":1031,"title":"Propel repeatedly generating the same migrations in subsequent diffs.","user":{"login":"williamlang","id":264728,"avatar_url":"https://avatars.githubusercontent.com/u/264728?v=3","gravatar_id":"","url":"https://api.github.com/users/williamlang","html_url":"https://github.com/williamlang","followers_url":"https://api.github.com/users/williamlang/followers","following_url":"https://api.github.com/users/williamlang/following{/other_user}","gists_url":"https://api.github.com/users/williamlang/gists{/gist_id}","starred_url":"https://api.github.com/users/williamlang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/williamlang/subscriptions","organizations_url":"https://api.github.com/users/williamlang/orgs","repos_url":"https://api.github.com/users/williamlang/repos","events_url":"https://api.github.com/users/williamlang/events{/privacy}","received_events_url":"https://api.github.com/users/williamlang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-11-09T08:52:02Z","updated_at":"2015-11-10T01:28:25Z","closed_at":null,"body":"Propel is repeatedly generating the same diff over and over regardless of whether or not I run the migration.\r\n\r\nThe columns appear to always be integers.\r\n\r\nThey're all non nullable columns.\r\n\r\nSome are auto increment.\r\n\r\nHere's a model that is generating the diff, despite not being different:\r\n\r\n    <table name=\"viz_pages\" phpName=\"VizPage\">\r\n        <column name=\"id\" type=\"integer\" required=\"true\" primaryKey=\"true\" autoIncrement=\"true\" />\r\n        <column name=\"viz_id\" type=\"integer\" required=\"true\" size=\"11\" />\r\n        <column name=\"page\" type=\"varchar\" size=\"255\" required=\"true\" />\r\n\r\n        <foreign-key foreignTable=\"vizzes\">\r\n            <reference local=\"viz_id\" foreign=\"id\" />\r\n        </foreign-key>\r\n\r\n        <behavior name=\"timestampable\" />\r\n    </table>\r\n\r\nThe SQL Create Table statement (generated from MySQL workbench)\r\n\r\n    CREATE TABLE `viz_pages` (\r\n      `id` int(11) NOT NULL AUTO_INCREMENT,\r\n      `viz_id` int(11) NOT NULL,\r\n      `page` varchar(255) NOT NULL,\r\n      `created_at` datetime DEFAULT NULL,\r\n      `updated_at` datetime DEFAULT NULL,\r\n      PRIMARY KEY (`id`),\r\n      KEY `viz_pages_fi_f3cf89` (`viz_id`),\r\n      CONSTRAINT `viz_pages_fk_f3cf89` FOREIGN KEY (`viz_id`) REFERENCES `vizzes` (`id`)\r\n    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;\r\n\r\n\r\nJust as a side note, the bug doesn't prevent me from doing any work -- it just adds unnecessary queries (that do nothing in the end) to my migrations.\r\n\r\nThe query that gets generated in the migration is:\r\n\r\n    ALTER TABLE `viz_pages`\r\n\r\n      CHANGE `viz_id` `viz_id` INTEGER(11) NOT NULL;"},"comment":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/comments/155253704","html_url":"https://github.com/propelorm/Propel2/issues/1031#issuecomment-155253704","issue_url":"https://api.github.com/repos/propelorm/Propel2/issues/1031","id":155253704,"user":{"login":"williamlang","id":264728,"avatar_url":"https://avatars.githubusercontent.com/u/264728?v=3","gravatar_id":"","url":"https://api.github.com/users/williamlang","html_url":"https://github.com/williamlang","followers_url":"https://api.github.com/users/williamlang/followers","following_url":"https://api.github.com/users/williamlang/following{/other_user}","gists_url":"https://api.github.com/users/williamlang/gists{/gist_id}","starred_url":"https://api.github.com/users/williamlang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/williamlang/subscriptions","organizations_url":"https://api.github.com/users/williamlang/orgs","repos_url":"https://api.github.com/users/williamlang/repos","events_url":"https://api.github.com/users/williamlang/events{/privacy}","received_events_url":"https://api.github.com/users/williamlang/received_events","type":"User","site_admin":false},"created_at":"2015-11-10T01:28:25Z","updated_at":"2015-11-10T01:28:25Z","body":"Removing the size property fixed the issue.\r\n\r\nStill a small bug."}}