-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `rt-math-1`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `owner`
-- 

CREATE TABLE `owner` (
 `ownerId` varchar(12) NOT NULL DEFAULT '',
 `name` varchar(30) NOT NULL DEFAULT '',
 `isRole` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`ownerId`),
 UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `owner`
-- 

INSERT INTO `owner` (`ownerId`, `name`, `isRole`) VALUES ('accounts', 'Accounts', 1),
('arpepper', 'Adrian Pepper', 0),
('cahowell', 'Carrie Howells', 0),
('ccalzone', 'Chris Calzonetti', 0),
('cmroth', 'Chris Roth', 0),
('cmulay', 'Chaitali Mulay', 0),
('consulta', 'Consultants', 1),
('ctucker', 'Clayton Tucker', 0),
('dabrown', 'Debbie Brown', 0),
('daroloso', 'Dani Roloson', 0),
('dhergott', 'Dan Hergott', 0),
('dkeenan', 'Dawn Keenan', 0),
('dlgawley', 'Dave Gawley', 0),
('drallen', 'Daniel Allen', 0),
('echrzano', 'Ed Chrzanowski', 0),
('emfox', 'Evan Fox', 0),
('fhgunn', 'Fraser Gunn', 0),
('fyeung', 'Franky Yeung', 0),
('gboerke', 'Gord Boerke', 0),
('gxshen', 'Guoxiang Shen', 0),
('hchotara', 'Hari Chotara', 0),
('ijmorlan', 'Isaac Morland', 0),
('inventory', 'Inventory', 1),
('iturner', 'Ian Turner', 0),
('jjohnsto', 'Jim Johnston', 0),
('lcsuess', 'Lori Suess', 0),
('lfolland', 'Lawrence Folland', 0),
('m4cormie', 'Michael Cormier', 0),
('magore', 'Mike Gore', 0),
('mfries', 'Matthew Fries', 0),
('nalamron', 'Naji Alamrony', 0),
('nvidovic', 'Nina Vidovic', 0),
('omnafees', 'Omar Nafees', 0),
('operator', 'Operator', 1),
('pbeldows', 'Philip Beldowski', 0),
('proutled', 'Peter Routledge', 0),
('q35chen', 'Qu Chen', 0),
('rblander', 'Robyn Landers', 0),
('rbutterw', 'Ray Butterworth', 0),
('rgarcia', 'Ronaldo Garcia', 0),
('rmmathar', 'Ray Manpreet Matharu', 0),
('rrahal', 'Rupinder Rahal', 0),
('rwlewis', 'William Lewis', 0),
('sm3scott', 'Sean Scott', 0),
('snickers', 'Steve Nickerson', 0),
('trg', 'Trevor Grove', 0),
('tserviss', 'Tom Serviss', 0),
('vpathak', 'Vinayak Pathak', 0),
('wcwince', 'Bill Ince', 0),
('y75wu', 'Yijing Wu', 0);

-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `rt-math-1`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `ownerOrganization`
-- 

CREATE TABLE `ownerOrganization` (
 `ownerId` varchar(12) NOT NULL DEFAULT '',
 `orgId` int(11) NOT NULL DEFAULT '0',
 `roles` set('RSG') DEFAULT NULL,
 PRIMARY KEY (`ownerId`,`orgId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ownerOrganization`
-- 

INSERT INTO `ownerOrganization` (`ownerId`, `orgId`, `roles`) VALUES ('accounts', 1, NULL),
('accounts', 2, NULL),
('arpepper', 1, NULL),
('cahowell', 2, NULL),
('ccalzone', 2, NULL),
('cmroth', 2, NULL),
('cmulay', 2, NULL),
('consulta', 1, NULL),
('consulta', 2, NULL),
('ctucker', 1, NULL),
('dabrown', 2, NULL),
('daroloso', 2, NULL),
('dhergott', 1, NULL),
('dkeenan', 1, NULL),
('dlgawley', 1, NULL),
('drallen', 1, NULL),
('echrzano', 1, NULL),
('emfox ', 2, NULL),
('fhgunn', 1, NULL),
('fyeung', 2, NULL),
('gboerke', 1, 'RSG'),
('gxshen', 1, NULL),
('hchotara', 2, NULL),
('ijmorlan', 1, NULL),
('inventory', 1, NULL),
('inventory', 2, NULL),
('iturner', 1, NULL),
('jjohnsto', 2, NULL),
('lcsuess', 2, NULL),
('lfolland', 1, 'RSG'),
('m4cormie', 2, NULL),
('magore', 1, 'RSG'),
('mfries', 2, NULL),
('nalamron', 2, NULL),
('nvidovic', 1, ''),
('omnafees', 1, NULL),
('operator', 2, NULL),
('pbeldows', 1, NULL),
('proutled', 2, NULL),
('q35chen', 2, NULL),
('rblander', 2, NULL),
('rbutterw', 2, NULL),
('rgarcia', 1, 'RSG'),
('rmmathar', 2, NULL),
('rrahal', 2, NULL),
('rwlewis', 2, NULL),
('sm3scott', 2, NULL),
('snickers', 1, NULL),
('trg', 1, NULL),
('tserviss', 2, NULL),
('vpathak', 2, NULL),
('wcwince', 1, NULL),
('y75wu', 1, NULL);

-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `ownerOrganization`
-- 
ALTER TABLE `ownerOrganization`
 ADD CONSTRAINT `0_372` FOREIGN KEY (`ownerId`) REFERENCES `owner` (`ownerId`) ON DELETE CASCADE;
