Page Menu
Home
GitPull.it
Search
Configure Global Search
Log In
Files
F15171854
updateDb.v1.5.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Authored By
Unknown
Size
966 B
Referenced Files
None
Subscribers
None
updateDb.v1.5.sql
View Options
-- MySQL Workbench Synchronization
-- Generated: 2017-04-21 16:40
-- 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
`
categories
`
CHANGE
COLUMN
`
created
`
`
created
`
DATETIME
NOT
NULL
DEFAULT
now
()
,
CHANGE
COLUMN
`
modified
`
`
modified
`
DATETIME
NOT
NULL
DEFAULT
now
()
,
ADD
COLUMN
`
iconClass
`
VARCHAR
(
45
)
NOT
NULL
DEFAULT
'fa fa-folder'
AFTER
`
modified
`
;
ALTER
TABLE
`
configurations
`
CHANGE
COLUMN
`
modified
`
`
modified
`
DATETIME
NOT
NULL
DEFAULT
now
()
,
CHANGE
COLUMN
`
created
`
`
created
`
DATETIME
NOT
NULL
DEFAULT
now
()
;
UPDATE
configurations
SET
version
=
'1.5'
,
modified
=
now
()
WHERE
id
=
1
;
SET
SQL_MODE
=@
OLD_SQL_MODE
;
SET
FOREIGN_KEY_CHECKS
=@
OLD_FOREIGN_KEY_CHECKS
;
SET
UNIQUE_CHECKS
=@
OLD_UNIQUE_CHECKS
;
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Thu, Nov 19, 00:48 (1 d, 11 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263286
Default Alt Text
updateDb.v1.5.sql (966 B)
Attached To
Mode
R58 TurboFlop
Attached
Detach File
Event Timeline