26 lines
573 B
SQL
26 lines
573 B
SQL
# drop the "prod" table if it exists, then recreate it
|
|
|
|
DROP TABLE IF EXISTS prod;
|
|
|
|
CREATE TABLE prod
|
|
(
|
|
# /********************\
|
|
#|* Datos Básicos *|
|
|
# \********************/
|
|
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
familia SMALLINT,
|
|
desc VARCHAR(30),
|
|
Imagen BLOB,
|
|
filetype VARCHAR(50)
|
|
|
|
# /************************\
|
|
#|* CLAVES PK, SK *|
|
|
# \************************/
|
|
|
|
PRIMARY KEY (id),
|
|
);
|
|
|
|
# Cargamos otros datos suministrados por defecto...
|
|
# LOAD DATA LOCAL INFILE "pelis.txt" INTO TABLE personas;
|
|
|