Page Menu
Home
GitPull.it
Search
Configure Global Search
Log In
Files
F15166510
updateDb.v1.8.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Authored By
Unknown
Size
998 B
Referenced Files
None
Subscribers
None
updateDb.v1.8.sql
View Options
-- MySQL Workbench Synchronization
-- Generated: 2017-04-24 14:51
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: Daniel
SET
@
OLD_UNIQUE_CHECKS
=@@
UNIQUE_CHECKS
,
UNIQUE_CHECKS
=
0
;
SET
@
OLD_FOREIGN_KEY_CHECKS
=@@
FOREIGN_KEY_CHECKS
,
FOREIGN_KEY_CHECKS
=
0
;
SET
@
OLD_SQL_MODE
=@@
SQL_MODE
,
SQL_MODE
=
'TRADITIONAL,ALLOW_INVALID_DATES'
;
ALTER
TABLE
`
videos_statistics
`
DROP
FOREIGN
KEY
`
fk_videos_statistics_users1
`
,
DROP
FOREIGN
KEY
`
fk_videos_statistics_videos1
`
;
ALTER
TABLE
`
videos_statistics
`
ADD
CONSTRAINT
`
fk_videos_statistics_users1
`
FOREIGN
KEY
(
`
users_id
`
)
REFERENCES
`
users
`
(
`
id
`
)
ON
DELETE
CASCADE
ON
UPDATE
CASCADE
,
ADD
CONSTRAINT
`
fk_videos_statistics_videos1
`
FOREIGN
KEY
(
`
videos_id
`
)
REFERENCES
`
videos
`
(
`
id
`
)
ON
DELETE
CASCADE
ON
UPDATE
CASCADE
;
SET
SQL_MODE
=@
OLD_SQL_MODE
;
SET
FOREIGN_KEY_CHECKS
=@
OLD_FOREIGN_KEY_CHECKS
;
SET
UNIQUE_CHECKS
=@
OLD_UNIQUE_CHECKS
;
UPDATE
configurations
SET
version
=
'1.8'
,
modified
=
now
()
WHERE
id
=
1
;
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Wed, Nov 18, 23:10 (16 h, 26 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263052
Default Alt Text
updateDb.v1.8.sql (998 B)
Attached To
Mode
R58 TurboFlop
Attached
Detach File
Event Timeline