diff options
Diffstat (limited to 'tests/unit/Data/SqlMap/scripts/mysql/other-init.sql')
-rw-r--r-- | tests/unit/Data/SqlMap/scripts/mysql/other-init.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/tests/unit/Data/SqlMap/scripts/mysql/other-init.sql b/tests/unit/Data/SqlMap/scripts/mysql/other-init.sql new file mode 100644 index 00000000..409de6d3 --- /dev/null +++ b/tests/unit/Data/SqlMap/scripts/mysql/other-init.sql @@ -0,0 +1,18 @@ + +TRUNCATE `Others`; +TRUNCATE `A`; +TRUNCATE `B`; +TRUNCATE `C`; +TRUNCATE `D`; +TRUNCATE `E`; +TRUNCATE `F`; + +INSERT INTO Others VALUES(1, 8888888, 0, 'Oui'); +INSERT INTO Others VALUES(2, 9999999999, 1, 'Non'); + +INSERT INTO F VALUES('f', 'fff'); +INSERT INTO E VALUES('e', 'eee'); +INSERT INTO D VALUES('d', 'ddd'); +INSERT INTO C VALUES('c', 'ccc'); +INSERT INTO B VALUES('b', 'c', null, 'bbb'); +INSERT INTO A VALUES('a', 'b', 'e', null, 'aaa');
\ No newline at end of file |