-- -- Add user admin (change the password!) (usr id 1) -- LOCK TABLES `usr` WRITE; /*!40000 ALTER TABLE `usr` DISABLE KEYS */; REPLACE INTO `usr` VALUES (1,'admin','LSR Administrator','youremail@example.com',2,'yourpassword',0,1); /*!40000 ALTER TABLE `usr` ENABLE KEYS */; UNLOCK TABLES; -- -- Add group superadmin (group id 2) -- LOCK TABLES `grp` WRITE; /*!40000 ALTER TABLE `grp` DISABLE KEYS */; REPLACE INTO `grp` VALUES (2,'superadmin'); /*!40000 ALTER TABLE `grp` ENABLE KEYS */; UNLOCK TABLES; -- -- Add user admin (usr id 1) to group superadmin (group id 2) -- LOCK TABLES `belongs` WRITE; /*!40000 ALTER TABLE `belongs` DISABLE KEYS */; REPLACE INTO `belongs` VALUES (1,1,2); /*!40000 ALTER TABLE `belongs` ENABLE KEYS */; UNLOCK TABLES; -- -- Give group superadmin (group id 2) all editing rights to all types: -- LOCK TABLES `grpauth` WRITE; /*!40000 ALTER TABLE `grpauth` DISABLE KEYS */; REPLACE INTO `grpauth` VALUES (1,2,1,'1','1','1','1','1','1','1','1','1','1'), (2,2,2,'1','1','1','1','1','1','1','1','1','1'), (3,2,3,'1','1','1','1','1','1','1','1','1','1'), (4,2,4,'1','1','1','1','1','1','1','1','1','1'), (5,2,5,'1','1','1','1','1','1','1','1','1','1'), (6,2,6,'1','1','1','1','1','1','1','1','1','1'), (7,2,7,'1','1','1','1','1','1','1','1','1','1'), (8,2,8,'1','1','1','1','1','1','1','1','1','1'); /*!40000 ALTER TABLE `grpauth` ENABLE KEYS */; UNLOCK TABLES;