simple as always. Thanks! Le lun. 9 janv. 2023 à 20:00, Jeremy Evans <[email protected]> a écrit :
> On Mon, Jan 9, 2023 at 9:57 AM Thiebo <[email protected]> wrote: > >> Hello ! >> >> I have this migration : >> >> create_table(:deleted_categories) do >> primary_key :id, :type=>:Bignum >> String :intitule, size: 250, null: false >> String :sens, size: 10, null: false, default: 'depense' >> DateTime :created_at, :null=>false, :default=>Sequel::CURRENT_TIMESTAMP >> > > foreign_key [:id, :intitule], :categories, key: [:id, :intitule] > > Thanks, > Jeremy > > end >> >> To this, I would like to add a foreign key constraint: >> >> FOREIGN KEY (id, intitule) REFERENCES categories (id, intitule) >> >> Reading through the documentation on migrations, there's a add_constraint >> method, but I don't see how to integrate this in migration upon create >> table. >> >> Thanks ! >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sequel-talk" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/sequel-talk/898fd1dc-cbd8-449e-b95e-853a52f9999bn%40googlegroups.com >> <https://groups.google.com/d/msgid/sequel-talk/898fd1dc-cbd8-449e-b95e-853a52f9999bn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sequel-talk/CADGZSSdBau2TTQnJ%3DhoReLYqo-9_u3NsAR08jG5oc4L1-aksFA%40mail.gmail.com > <https://groups.google.com/d/msgid/sequel-talk/CADGZSSdBau2TTQnJ%3DhoReLYqo-9_u3NsAR08jG5oc4L1-aksFA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/CANpyn0GuN4rL7ghjS2YSRixwefhWWoF3S9R28EKVSZ9e9bJvvw%40mail.gmail.com.
