summaryrefslogtreecommitdiff
path: root/tests/unit/Data/SqlMap/scripts/mysql/account-init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/unit/Data/SqlMap/scripts/mysql/account-init.sql')
-rw-r--r--tests/unit/Data/SqlMap/scripts/mysql/account-init.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/tests/unit/Data/SqlMap/scripts/mysql/account-init.sql b/tests/unit/Data/SqlMap/scripts/mysql/account-init.sql
new file mode 100644
index 00000000..6b102597
--- /dev/null
+++ b/tests/unit/Data/SqlMap/scripts/mysql/account-init.sql
@@ -0,0 +1,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); \ No newline at end of file