File:
0.01.1a/sql/default.fdsql (
View as Code)
1: -- FreeDESK System Defaults
2:
3: -- Admin User
4: INSERT INTO `%%$%%user`(`username`, `realname`) VALUES("admin", "Administrator");
5: INSERT INTO `%%$%%permissions`(`permissiontype`, `permission`, `usergroupid`, `allowed`) VALUES("user", "default", "admin", 1);
6:
7: -- System Defaults
8: INSERT INTO `%%$%%sysconfig`(`sc_option`,`sc_value`) VALUES("system.live", "1");
9: INSERT INTO `%%$%%sysconfig`(`sc_option`,`sc_value`) VALUES("auth.default", "standard");
10:
11: -- Requests
12: INSERT INTO `%%$%%requestclass` (`classid`, `classname`, `classclass`) VALUES(1, 'Standard Request', '');
13:
14: -- Statuses
15: INSERT INTO `%%$%%status` (`status`, `description`) VALUES(0, 'Closed');
16: INSERT INTO `%%$%%status` (`status`, `description`) VALUES(1, 'Open - Standard');
17:
18: