Viewing File sql/default.fdsql of 0.01.1a
|
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: