· 9 years ago · Nov 27, 2016, 02:30 PM
1MySQL.yml config:
2
3MySQL: true
4MySQLSetup:
5 Host: "localhost"
6 Username: "yourusername"
7 Password: "yourpassword"
8 Database: "yourdatabase"
9
10
11Testscript.sk file:
12
13on load:
14 set mysql host to "localhost"
15 set mysql username to "yourusername"
16 set mysql password to "yourpassword"
17 set mysql database to "yourdatabase"
18 connect to mysql
19
20command /createnewtable:
21 trigger:
22 mysql update "CREATE TABLE IF NOT EXISTS `Testtable` (`VarName` varchar(255),`VarValue` longtext)"
23 mysql update "ALTER TABLE `Testtable` ADD UNIQUE (VarName)"