Spaces:

PShowdown
/

Pokemon_server

Paused

Pokemon_server / databases /schemas /friends-startup.sql

Upload 4781 files

5c2ed06 verified over 1 year ago

247 Bytes

--- This is a separate file so migrations don't have to be done.

CREATE TEMPORARY VIEW friends_simplified (
	userid, friend
) AS SELECT user1 as friend, user2 as userid FROM friends UNION ALL SELECT user2 as friend, user1 as userid FROM friends;

	--- This is a separate file so migrations don't have to be done.

	CREATE TEMPORARY VIEW friends_simplified (
	userid, friend
	) AS SELECT user1 as friend, user2 as userid FROM friends UNION ALL SELECT user2 as friend, user1 as userid FROM friends;