github.com/iasthc/atlas/cmd/atlas@v0.0.0-20230523071841-73246df3f88d/internal/cmdapi/testdata/sqlitetx2/20220925094021_second.sql (about)

     1  -- create "friendships" table
     2  CREATE TABLE `friendships` (`user_id` integer NOT NULL, `friend_id` integer NOT NULL, PRIMARY KEY (`user_id`, `friend_id`), CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `friend_id_fk` FOREIGN KEY (`friend_id`) REFERENCES `users` (`id`) ON DELETE CASCADE);
     3  
     4  INSERT INTO `users` (`id`) VALUES (1), (2);
     5  INSERT INTO `friendships` (`user_id`, `friend_id`) VALUES (1,2), (2,1);