DERs/DERS-DB1

From DER's LLC
Revision as of 19:12, 2 June 2023 by Admin (talk | contribs) (Created page with "== 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');")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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');