init.sql

INSERT INTO Bar
(`id`, `name`)
VALUES
('natationjone', 'Natation Jône'),
('avironjone', 'Aviron Jône');


INSERT INTO User
(`id`, `name`,          `login`,   `password`)
VALUES
(1,  'Basile Bruneau',    'bb',                  'bb'),
(2,  'Thomas Dupond',     'fgdfg',               'kjhiuy'),
(3,  'Arthur Content',    'bdfgb',               'kjhiuy'),
(4,  'Benjamin Fleuri',   'bsfdsb',              'kjhiuy'),
(5,  'Amandine Rosier',   'df.fgh',              'kjhiuy'),
(6,  'Edouard Twilight',  'sdfsdfsdgery.fhgfh',  'kjhiuy'),
(7,  'Eric LeGrand',      'dfdfdfd',             'kjhiuy'),
(8,  'Etienne Marrant',   '12345',               'kjhiuy'),
(9,  'Admin',             'admin',               'admin' );


INSERT INTO Account
(`user_id`, `bar_id`, `money`)
VALUES
(1, 'avironjone',    23.3),
(2, 'avironjone',    -10.2),
(3, 'avironjone',    12),
(4, 'avironjone',    11.11),
(5, 'avironjone',    10.34),
(6, 'avironjone',    90.23),
(7, 'avironjone',    1.2),
(8, 'avironjone',    9.1),
(9, 'natationjone',  100.0),
(9, 'avironjone',    150.0);


INSERT INTO StockItem
(`bar_id`, `name`, `qty`, `unit`, `price`, `tax`)
VALUES
('natationjone', 'Chocolat', 20, 'g', 0.1, 0),
('natationjone', 'Pain', 40, 'g', 0.2, 0),
('avironjone', 'Pizza', 4, '', 2, 0),
('avironjone', 'Tomate', 40, '', 0.4, 0),
('avironjone', 'Fromage', 1.34, 'kg', 7.1, 0),
('avironjone', 'Galette', 4, '', 0.4, 0),
('avironjone', 'Yaourt', 8, '', 0.67, 0),
('avironjone', 'Pates', 12.34, 'kg', 1.23, 0),
('avironjone', 'Steak', 20, '', 0.87, 0);