Test db for user creation

From MyWiki
Revision as of 17:59, 25 October 2014 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
CREATE TABLE gdb (
uid VARCHAR(20) PRIMARY KEY,
name VARCHAR(100),
code VARCHAR(3)
);
 
INSERT INTO gdb (uid,name,code) VALUES('1234556','James Duff','fr');
INSERT INTO gdb (uid,name,code) VALUES('1234554','Derek Galway','ry');
INSERT INTO gdb (uid,name,code) VALUES('1234552','Rob Jones','pr');
INSERT INTO gdb (uid,name,code) VALUES('1234536','James Gibbon','ex');
INSERT INTO gdb (uid,name,code) VALUES('1234528','James Galway','fr');
INSERT INTO gdb (uid,name,code) VALUES('1234523','James Galway','ry');