Difference between revisions of "Test db for user creation"

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');