FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
scriptdev2-tbc/sql/scriptdev2_create_structure_mysql.sql at master · scriptdev2/scriptdev2-tbc · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
scriptdev2
/
scriptdev2-tbc
Public
Notifications
You must be signed in to change notification settings
Fork
26
Star
28
Code
Issues
11
Pull requests
1
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
scriptdev2-tbc
/
sql
/
scriptdev2_create_structure_mysql.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
72 lines (68 loc) · 2.44 KB
Breadcrumbs
scriptdev2-tbc
/
sql
/
scriptdev2_create_structure_mysql.sql
Copy path
File metadata and controls
72 lines (68 loc) · 2.44 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
DROP
TABLE
IF EXISTS
`
custom_texts
`
;
CREATE
TABLE
`
custom_texts
` (
`
entry
`
mediumint(
8
)
NOT NULL
,
`
content_default
`
text
NOT NULL
,
`
content_loc1
`
text
,
`
content_loc2
`
text
,
`
content_loc3
`
text
,
`
content_loc4
`
text
,
`
content_loc5
`
text
,
`
content_loc6
`
text
,
`
content_loc7
`
text
,
`
content_loc8
`
text
,
`
sound
`
mediumint(
8
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
type
`
tinyint
(
3
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
language
`
tinyint
(
3
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
emote
`
smallint
(
5
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
comment
`
text
,
PRIMARY KEY
(
`
entry
`
)
) ENGINE
=
MyISAM DEFAULT CHARSET
=
utf8 ROW_FORMAT
=
FIXED COMMENT
=
'
Custom Texts
'
;
DROP
TABLE
IF EXISTS
`
gossip_texts
`
;
CREATE
TABLE
`
gossip_texts
` (
`
entry
`
mediumint(
8
)
NOT NULL
,
`
content_default
`
text
NOT NULL
,
`
content_loc1
`
text
,
`
content_loc2
`
text
,
`
content_loc3
`
text
,
`
content_loc4
`
text
,
`
content_loc5
`
text
,
`
content_loc6
`
text
,
`
content_loc7
`
text
,
`
content_loc8
`
text
,
`
comment
`
text
,
PRIMARY KEY
(
`
entry
`
)
) ENGINE
=
MyISAM DEFAULT CHARSET
=
utf8 ROW_FORMAT
=
FIXED COMMENT
=
'
Gossip Texts
'
;
DROP
TABLE
IF EXISTS
`
script_texts
`
;
CREATE
TABLE
`
script_texts
` (
`
entry
`
mediumint(
8
)
NOT NULL
,
`
content_default
`
text
NOT NULL
,
`
content_loc1
`
text
,
`
content_loc2
`
text
,
`
content_loc3
`
text
,
`
content_loc4
`
text
,
`
content_loc5
`
text
,
`
content_loc6
`
text
,
`
content_loc7
`
text
,
`
content_loc8
`
text
,
`
sound
`
mediumint(
8
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
type
`
tinyint
(
3
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
language
`
tinyint
(
3
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
emote
`
smallint
(
5
) unsigned
NOT NULL
DEFAULT
'
0
'
,
`
comment
`
text
,
PRIMARY KEY
(
`
entry
`
)
) ENGINE
=
MyISAM DEFAULT CHARSET
=
utf8 ROW_FORMAT
=
FIXED COMMENT
=
'
Script Texts
'
;
DROP
TABLE
IF EXISTS script_waypoint;
CREATE
TABLE
script_waypoint
(
entry mediumint(
8
) unsigned
NOT NULL
DEFAULT
'
0
'
COMMENT
'
creature_template entry
'
,
pointid mediumint(
8
) unsigned
NOT NULL
DEFAULT
'
0
'
,
location_x float
NOT NULL
DEFAULT
'
0
'
,
location_y float
NOT NULL
DEFAULT
'
0
'
,
location_z float
NOT NULL
DEFAULT
'
0
'
,
waittime
int
(
10
) unsigned
NOT NULL
DEFAULT
'
0
'
COMMENT
'
waittime in millisecs
'
,
point_comment
text
,
PRIMARY KEY
(entry, pointid)
) ENGINE
=
MyISAM DEFAULT CHARSET
=
utf8 ROW_FORMAT
=
FIXED COMMENT
=
'
Script Creature waypoints
'
;
DROP
TABLE
IF EXISTS
`
sd2_db_version
`
;
CREATE
TABLE
`
sd2_db_version
` (
`
version
`
varchar
(
255
)
NOT NULL
default
'
'
COMMENT
'
Database version string
'
) ENGINE
=
MyISAM DEFAULT CHARSET
=
utf8;
Back
|
FazBrowse Home
|
New Git URL