File: 0.01.1a/sql/default.fdsql (View as HTML)

  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: