Files.sql:
CREATE TABLE files (
id MEDIUMINT,
user_id MEDIUMINT,
name TEXT,
path TEXT
).
Load_files.sql:
INSERT INTO files VALUES ( 1, 1, test1.jpg , files/test1.jpg ).
INSERT INTO files VALUES ( 2, 1, test2.jpg , files/test2.jpg ).
Users.sql:
DROP TABLE IF EXISTS users.
CREATE TABLE users (
id MEDIUMINT,
login TEXT,
password TEXT
).
Load_users.sql:
INSERT INTO users VALUES ( 1, jack , pass ).
INSERT INTO users VALUES ( 2, jon , pass ).
|