Page Menu
Home
GitPull.it
Search
Configure Global Search
Log In
Files
F15162177
updateDb.v1.1.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Authored By
Unknown
Size
799 B
Referenced Files
None
Subscribers
None
updateDb.v1.1.sql
View Options
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'
;
-- version 1.1
ALTER
TABLE
`
configurations
`
CHARACTER
SET
=
utf8
,
COLLATE
=
utf8_general_ci
,
ADD
COLUMN
`
webSiteTitle
`
VARCHAR
(
45
)
NOT
NULL
DEFAULT
'YouPHPTube'
AFTER
`
version
`
,
ADD
COLUMN
`
language
`
VARCHAR
(
6
)
NOT
NULL
DEFAULT
'en'
AFTER
`
webSiteTitle
`
,
ADD
COLUMN
`
contactEmail
`
VARCHAR
(
45
)
NOT
NULL
AFTER
`
language
`
,
CHANGE
COLUMN
`
modified
`
`
modified
`
DATETIME
NOT
NULL
DEFAULT
now
()
AFTER
`
contactEmail
`
,
CHANGE
COLUMN
`
created
`
`
created
`
DATETIME
NOT
NULL
DEFAULT
now
()
;
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
Wed, Nov 18, 21:18 (1 d, 14 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263140
Default Alt Text
updateDb.v1.1.sql (799 B)
Attached To
Mode
R58 TurboFlop
Attached
Detach File
Event Timeline