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