Startsida Utforska Hjälp
Registrera dig Logga in
zxhx
/
xiaoben-as2-php
3
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 605e6357c5
Grenar Taggar
xiaoben-as2-...
/
protected
/
data
/
schema.mysql.sql

schema.mysql.sql 2.2 KB
Historik Rå

12345678910111213141516171819202122232425262728 
  1. CREATE TABLE tbl_user (
    2. 

  2.     id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
    3. 

  3.     username VARCHAR(128) NOT NULL,
    4. 

  4.     password VARCHAR(128) NOT NULL,
    5. 

  5.     email VARCHAR(128) NOT NULL
    6. 

  6. );
    7. 

  7. 

  8. INSERT INTO tbl_user (username, password, email) VALUES ('test1', 'pass1', 'test1@example.com');
    9. 

  9. INSERT INTO tbl_user (username, password, email) VALUES ('test2', 'pass2', 'test2@example.com');
    10. 

  10. INSERT INTO tbl_user (username, password, email) VALUES ('test3', 'pass3', 'test3@example.com');
    11. 

  11. INSERT INTO tbl_user (username, password, email) VALUES ('test4', 'pass4', 'test4@example.com');
    12. 

  12. INSERT INTO tbl_user (username, password, email) VALUES ('test5', 'pass5', 'test5@example.com');
    13. 

  13. INSERT INTO tbl_user (username, password, email) VALUES ('test6', 'pass6', 'test6@example.com');
    14. 

  14. INSERT INTO tbl_user (username, password, email) VALUES ('test7', 'pass7', 'test7@example.com');
    15. 

  15. INSERT INTO tbl_user (username, password, email) VALUES ('test8', 'pass8', 'test8@example.com');
    16. 

  16. INSERT INTO tbl_user (username, password, email) VALUES ('test9', 'pass9', 'test9@example.com');
    17. 

  17. INSERT INTO tbl_user (username, password, email) VALUES ('test10', 'pass10', 'test10@example.com');
    18. 

  18. INSERT INTO tbl_user (username, password, email) VALUES ('test11', 'pass11', 'test11@example.com');
    19. 

  19. INSERT INTO tbl_user (username, password, email) VALUES ('test12', 'pass12', 'test12@example.com');
    20. 

  20. INSERT INTO tbl_user (username, password, email) VALUES ('test13', 'pass13', 'test13@example.com');
    21. 

  21. INSERT INTO tbl_user (username, password, email) VALUES ('test14', 'pass14', 'test14@example.com');
    22. 

  22. INSERT INTO tbl_user (username, password, email) VALUES ('test15', 'pass15', 'test15@example.com');
    23. 

  23. INSERT INTO tbl_user (username, password, email) VALUES ('test16', 'pass16', 'test16@example.com');
    24. 

  24. INSERT INTO tbl_user (username, password, email) VALUES ('test17', 'pass17', 'test17@example.com');
    25. 

  25. INSERT INTO tbl_user (username, password, email) VALUES ('test18', 'pass18', 'test18@example.com');
    26. 

  26. INSERT INTO tbl_user (username, password, email) VALUES ('test19', 'pass19', 'test19@example.com');
    27. 

  27. INSERT INTO tbl_user (username, password, email) VALUES ('test20', 'pass20', 'test20@example.com');
    28. 

  28. INSERT INTO tbl_user (username, password, email) VALUES ('test21', 'pass21', 'test21@example.com');
    29.