-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinit.sql
More file actions
32 lines (32 loc) · 4.46 KB
/
init.sql
File metadata and controls
32 lines (32 loc) · 4.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn1', '6', '7', 'cell55', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn2', '6', '6', 'cell54', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn3', '6', '5', 'cell53', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn4', '6', '4', 'cell52', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn5', '6', '3', 'cell51', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn6', '6', '2', 'cell50', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn7', '6', '1', 'cell49', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhitePawn8', '6', '0', 'cell48', 'White', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn2', '1', '1', 'cell9', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn3', '1', '2', 'cell10', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteKing1', '7', '4', 'cell60', 'White', 'King', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn5', '1', '4', 'cell12', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn6', '1', '5', 'cell13', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackRook1', '0', '0', 'cell0', 'Black', 'Rook', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackRook2', '0', '7', 'cell7', 'Black', 'Rook', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteRook1', '7', '7', 'cell63', 'White', 'Rook', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteKnight1', '7', '6', 'cell62', 'White', 'Knight', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteKnight2', '7', '1', 'cell57', 'White', 'Knight', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackKnight1', '0', '1', 'cell1', 'Black', 'Knight', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackKnight2', '0', '6', 'cell6', 'Black', 'Knight', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackBishop1', '0', '2', 'cell2', 'Black', 'Bishop', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackBishop2', '0', '5', 'cell5', 'Black', 'Bishop', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteRook', '7', '0', 'cell56', 'White', 'Rook', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteQueen2', '7', '3', 'cell59', 'White', 'Queen', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackKing1', '0', '3', 'cell3', 'Black', 'King', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn7', '1', '6', 'cell14', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn8', '1', '7', 'cell15', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackQueen1', '0', '4', 'cell4', 'Black', 'Queen', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteBishop1', '7', '5', 'cell61', 'White', 'Bishop', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('WhiteBishop2', '7', '2', 'cell58', 'White', 'Bishop', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn4', '1', '3', 'cell11', 'Black', 'Pawn', true);
INSERT INTO public.init_board (id, ycor, xcor, cellid, color, type, status) VALUES ('BlackPawn1', '1', '0', 'cell8', 'Black', 'Pawn', true);