{"comment":{"created_at":"2011-10-20T22:10:38Z","body":"schema.xml example:\r\n\r\n<table name=\"sites_users\" phpName=\"SiteUser\" isCrossRef=\"true\">\r\n        <column name=\"site_id\"              type=\"integer\" sqlType=\"INT UNSIGNED\" primaryKey=\"true\" required=\"true\" />\r\n        <column name=\"user_id\"              type=\"integer\" sqlType=\"INT UNSIGNED\" primaryKey=\"true\" required=\"true\" />\r\n        <column name=\"create_time\"          type=\"timestamp\" required=\"true\" />\r\n        <column name=\"update_time\"          type=\"timestamp\" required=\"true\" />\r\n\r\n        <foreign-key foreignTable=\"sites\" skipSql=\"true\">\r\n            <reference local=\"site_id\" foreign=\"id\" />\r\n        </foreign-key>\r\n        <foreign-key foreignTable=\"users\" skipSql=\"true\">\r\n            <reference local=\"user_id\" foreign=\"id\" />\r\n        </foreign-key>\r\n    </table>","updated_at":"2011-10-20T22:10:38Z","url":"https://api.github.com/repos/propelorm/Propel/issues/comments/2475109","id":2475109,"user":{"avatar_url":"https://secure.gravatar.com/avatar/c4a915ee82bd09969defcd5b960a50f9?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"c4a915ee82bd09969defcd5b960a50f9","url":"https://api.github.com/users/jlammertink","id":127651,"login":"jlammertink"}},"action":"created","issue":{"number":154,"created_at":"2011-10-20T22:09:54Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"When generating a many 2 many table Propel generates an extra key which isn't nccessary in schema.sql.\r\n\r\nPRIMARY: site_id, user_id <- which is what we want\r\nsites_users_FI_2: \tuser_id <- loop continues but not necessary (already in PRIMARY)\r\n\r\nHope it's clear enough","comments":1,"title":"duplicate key in schema.sql","updated_at":"2011-10-20T22:10:38Z","url":"https://api.github.com/repos/propelorm/Propel/issues/154","id":2010056,"assignee":null,"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/c4a915ee82bd09969defcd5b960a50f9?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"c4a915ee82bd09969defcd5b960a50f9","url":"https://api.github.com/users/jlammertink","id":127651,"login":"jlammertink"},"html_url":"https://github.com/propelorm/Propel/issues/154","labels":[],"state":"open"},"legacy":{"issue_id":2010056,"comment_id":2475109}}