users.sql 430 B

12345678910
  1. CREATE TABLE IF NOT EXISTS users (
  2. user_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  3. name varchar(100) NOT NULL,
  4. email varchar(100) NOT NULL,
  5. PRIMARY KEY (user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  6. insert into users(name,email) values ('user1', 'user1@example.com');
  7. insert into users(name,email) values ('user2', 'user2@example.com');
  8. insert into users(name,email) values ('user3', 'user3@example.com');