21 lines
485 B
SQL
21 lines
485 B
SQL
# drop the "prod_user" table if it exists, then recreate it
|
|
|
|
DROP TABLE IF EXISTS prod_user;
|
|
|
|
CREATE TABLE prod_user
|
|
(
|
|
# /********************\
|
|
#|* Datos Básicos *|
|
|
# \********************/
|
|
user SMALLINT UNSIGNED NOT NULL REFERENCES users,
|
|
prod SMALLINT UNSIGNED NOT NULL REFERENCES prod,
|
|
stock SMALLINT
|
|
|
|
PRIMARY KEY (user, prod)
|
|
|
|
);
|
|
|
|
# Cargamos otros datos suministrados por defecto...
|
|
# LOAD DATA LOCAL INFILE "pelis_user.txt" INTO TABLE personas;
|
|
|