DERs/DERS-DB1

From DER's LLC
Jump to navigation Jump to search

USERS TABLE

CREATE TABLE IF NOT EXISTS `users` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `user` varchar(30),
 `level` varchar(2),
 PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
INSERT INTO users (user, level) VALUES('admin', 'CL');
INSERT INTO users (user, level) VALUES('pbuser', 'CL');