· 8 years ago · Mar 03, 2018, 10:54 PM
1--
2-- Table structure for table `privileges`
3--
4
5CREATE TABLE IF NOT EXISTS `privileges` (
6 `privilege` tinyint(1) NOT NULL default '4',
7 `name` varchar(255) NOT NULL,
8 `description` varchar(255) NOT NULL
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11--
12-- Dumping data for table `privileges`
13--
14
15INSERT INTO `privileges` (`privilege`, `name`, `description`) VALUES
16(1, 'admin', 'can modify/control all aspects of any assigned resource'),
17(2, 'read-only admin', 'can only view information about the machines they own.'),
18(3, 'none', 'no privs whatsoever, placeholder only, expired or not-yet-activated accounts, etc'),
19
20-- --------------------------------------------------------