summaryrefslogtreecommitdiff
path: root/tests/unit/Data/SqlMap/scripts/mysql/account-init.sql
blob: 6b10259735fe0aa1cbc28eef10625607aaa90344 (plain)
1
2
3
4
5
6
7
TRUNCATE `Accounts`;

INSERT INTO Accounts VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com', 'Oui', 200);
INSERT INTO Accounts VALUES(2,'Averel', 'Dalton', 'Averel.Dalton@somewhere.com', 'Oui', 200);
INSERT INTO Accounts VALUES(3,'William', 'Dalton', null, 'Non', 100);
INSERT INTO Accounts VALUES(4,'Jack', 'Dalton', 'Jack.Dalton@somewhere.com', 'Non', 100);
INSERT INTO Accounts VALUES(5,'Gilles', 'Bayon', null, 'Oui', 100);