-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinserts_ini.sql
More file actions
28 lines (17 loc) · 1.17 KB
/
inserts_ini.sql
File metadata and controls
28 lines (17 loc) · 1.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SELECT * FROM appinit.users;
--
SELECT * FROM appinit.videos;
INSERT INTO `appinit`.`videos` (`name_vd`, `date_vd`, `url_vd`, `id_autor_vd`) VALUES ('3 AUTOS de LUJO USADOS MUY BARATOS', now(), './static/videos/3_AUTOS_de_LUJO_USADOS_MUY_BARATOS!.mp4',1);
UPDATE `appinit`.`videos` SET `url_vd` = './static/videos/3_AUTOS_de_LUJO_USADOS_MUY_BARATOS!.mp4' WHERE (`id_vd` = '1');
ALTER TABLE `appinit`.`videos`
CHANGE COLUMN `name_vd` `name_vd` VARCHAR(128) NOT NULL ;
--
SELECT * FROM appinit.thumbnails;
INSERT INTO `appinit`.`thumbnails` (`name_thn`, `url_thn`, `description_thn`, `date_thn`, `id_video_thn`) VALUES ('3 AUTOS de LUJO USADOS MUY BARATOS', './static/images/thumbnail/3_AUTOS_de_LUJO_USADOS_MUY_BARATOS!.jpg', '--',now(), '1');
UPDATE `appinit`.`thumbnails` SET `url_thn` = './static/images/thumbnail/3_AUTOS_de_LUJO_USADOS_MUY_BARATOS!.jpg' WHERE (`id_thn` = '1');
ALTER TABLE `appinit`.`thumbnails`
CHANGE COLUMN `name_thn` `name_thn` VARCHAR(128) NOT NULL ;
--
ALTER TABLE `appinit`.`comments`
ADD COLUMN `date_cmt` DATETIME NOT NULL DEFAULT now() AFTER `id_comment_cmt`;