· 7 years ago · Dec 12, 2018, 07:24 AM
1# SQL Manager 2007 for MySQL 4.4.0.5
2# ---------------------------------------
3# Host : 127.0.0.1
4# Port : 3306
5# Database : arma
6
7
8SET FOREIGN_KEY_CHECKS=0;
9
10USE `arma`;
11
12
13#
14# Structure for the `players` table :
15#
16
17DROP TABLE IF EXISTS `players`;
18
19CREATE TABLE `players` (
20 `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
21 `na` VARCHAR(255) NOT NULL DEFAULT '',
22 `pid` VARCHAR(20) NOT NULL DEFAULT '',
23 `sc` INTEGER(11) DEFAULT '0',
24 `pos` VARCHAR(255) DEFAULT NULL,
25 `wea` VARCHAR(1000) DEFAULT '',
26 `mag` VARCHAR(1000) DEFAULT '',
27 `mid` INTEGER(11) DEFAULT NULL,
28 `dam` FLOAT DEFAULT '0',
29 `dhe` FLOAT DEFAULT '0',
30 `dbo` FLOAT DEFAULT '0',
31 `dha` FLOAT DEFAULT '0',
32 `dle` FLOAT DEFAULT '0',
33 `dir` FLOAT DEFAULT '0',
34 `sta` VARCHAR(10) DEFAULT 'Stand',
35 `sid` VARCHAR(10) DEFAULT NULL,
36 `veh` VARCHAR(255) DEFAULT '',
37 `sea` VARCHAR(10) DEFAULT '',
38 `awb` VARCHAR(1000) DEFAULT '',
39 `arc` VARCHAR(45) DEFAULT '',
40 `aw` VARCHAR(1000) DEFAULT '',
41 `arm` VARCHAR(1000) DEFAULT '',
42 `typ` VARCHAR(45) DEFAULT '',
43 `rat` INTEGER(11) DEFAULT '0',
44 `vd` INTEGER(11) DEFAULT '1600',
45 `td` INTEGER(11) DEFAULT '2',
46 `ran` VARCHAR(45) DEFAULT '',
47 `fir` INTEGER(11) DEFAULT '0',
48 `ek` INTEGER(11) DEFAULT '0',
49 `ck` INTEGER(11) DEFAULT '0',
50 `fk` INTEGER(11) DEFAULT '0',
51 `sui` INTEGER(11) DEFAULT '0',
52 `lif` VARCHAR(45) DEFAULT 'ALIVE',
53 `dea` INTEGER(11) DEFAULT '0',
54 `tp` INTEGER(11) DEFAULT '0',
55 `grp` VARCHAR(45) DEFAULT '',
56 `rck` VARCHAR(45) DEFAULT '',
57 `rwe` VARCHAR(1000) DEFAULT '',
58 `rma` VARCHAR(1000) DEFAULT '',
59 `lc` VARCHAR(45) DEFAULT '',
60 `ld` VARCHAR(45) DEFAULT '',
61 `prp` VARCHAR(255) NOT NULL DEFAULT '0' COMMENT 'player respawn point',
62 PRIMARY KEY (`id`),
63 KEY `missionid` (`mid`),
64 KEY `puid` (`pid`),
65 KEY `pname` (`na`)
66)ENGINE=MyISAM
67AUTO_INCREMENT=1 CHARACTER SET 'latin1';
68
69
70#
71# Structure for the `modules` table :
72#
73
74CREATE TABLE `modules` (
75 `id` INTEGER(11) NOT NULL AUTO_INCREMENT COMMENT 'db id',
76 `na` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'module name',
77 `ty` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'type',
78 PRIMARY KEY (`id`),
79 UNIQUE KEY `na` (`na`),
80)ENGINE=InnoDB
81AUTO_INCREMENT=3;
82
83
84#
85# Structure for the `configs` table :
86#
87
88CREATE TABLE `configs` (
89 `id` INTEGER(11) NOT NULL AUTO_INCREMENT COMMENT 'db id',
90 `mid` INTEGER(11) DEFAULT NULL COMMENT 'mission id',
91 `modid` INTEGER(11) DEFAULT NULL COMMENT 'module id',
92 `ke` VARCHAR(255) DEFAULT NULL COMMENT 'data key',
93 `val` VARCHAR(1000) DEFAULT NULL COMMENT 'data value',
94 PRIMARY KEY (`id`),
95 UNIQUE KEY `mid` (`mid`),
96 KEY `modid` (`modid`),
97 KEY `ke` (`ke`)
98)ENGINE=InnoDB
99AUTO_INCREMENT=1;
100
101
102#
103# Data for the `modules` table (LIMIT 0,500)
104#
105
106INSERT INTO `modules` (`id`, `na`, `ty`) VALUES
107 (1,'WHB_Multispawn','Support'),
108 (2,'vehicleIgnitionKeys','Core');
109COMMIT;
110
111
112
113
114#
115# Definition for the `GetAllModules` procedure :
116#
117
118CREATE DEFINER = 'arma'@'localhost' PROCEDURE `GetAllModules`()
119 NOT DETERMINISTIC
120 CONTAINS SQL
121 SQL SECURITY DEFINER
122 COMMENT ''
123BEGIN
124 SELECT id,na,ty FROM modules;
125END$$
126
127
128#
129# Definition for the `InsertConfigData` procedure :
130#
131
132CREATE DEFINER = 'arma'@'localhost' PROCEDURE `InsertConfigData`(IN tmid INTEGER(11), IN tmodid INTEGER(11), IN tke VARCHAR(255), IN tval VARCHAR(1000))
133 NOT DETERMINISTIC
134 CONTAINS SQL
135 SQL SECURITY DEFINER
136 COMMENT ''
137BEGIN
138 INSERT INTO configs (ke,val,mid,modid) values (tke,tval,tmid,tmodid);
139END$$
140
141
142#
143# Definition for the `UpdateConfigData` procedure :
144#
145
146CREATE DEFINER = 'arma'@'localhost' PROCEDURE `UpdateConfigData`(IN tmid INTEGER(11), IN tmodid INTEGER(11), IN tke VARCHAR(255), IN tval VARCHAR(1000))
147 NOT DETERMINISTIC
148 CONTAINS SQL
149 SQL SECURITY DEFINER
150 COMMENT ''
151BEGIN
152 UPDATE configs SET val=tval WHERE mid=tmid AND modid=tmodid AND ke=tke;
153END$$
154
155
156
157#
158# Definition for the `GetKeyValuesbyModuleIDANDByMission` procedure :
159#
160
161CREATE DEFINER = 'arma'@'localhost' PROCEDURE `GetKeyValuesbyModuleIDANDByMission`(IN tmid INTEGER(11), IN tmodid INTEGER(11))
162 NOT DETERMINISTIC
163 CONTAINS SQL
164 SQL SECURITY DEFINER
165 COMMENT ''
166BEGIN
167 SELECT ke,val FROM configs WHERE mid=tmid AND modid=tmodid;
168END$$
169
170
171
172#
173# Definition for the `UpdatePlayer` procedure :
174#
175
176CREATE DEFINER = 'arma'@'localhost' PROCEDURE `UpdatePlayer`(IN tsc INTEGER(11), IN tpos VARCHAR(255), IN tdam FLOAT, IN tdhe FLOAT, IN tdbo FLOAT, IN tdha FLOAT, IN tdle FLOAT, IN tdir FLOAT, IN tsta VARCHAR(10), IN tsid VARCHAR(10), IN tveh VARCHAR(255), IN tsea VARCHAR(10), IN ttyp VARCHAR(45), IN trat INT(11), IN tvd INT(11), IN ttd INT(11), IN tran VARCHAR(45), IN tfir INT(11), IN tek INT(11), IN tck INT(11), IN tfk INT(11), IN tsui INT(11), IN tlif VARCHAR(45), IN tdea INT(11), IN ttp INT(11), IN tlc VARCHAR(45), IN tld VARCHAR(45), IN tpid INTEGER(11), IN tna VARCHAR(255), IN tmid INTEGER(11), IN tprp VARCHAR(255))
177 NOT DETERMINISTIC
178 CONTAINS SQL
179 SQL SECURITY DEFINER
180 COMMENT ''
181BEGIN
182 UPDATE players SET sc = tsc, pos = tpos, dam = tdam, dhe = tdhe, dbo = tdbo, dha = tdha, dle = tdle, dir = tdir, sta = tsta, sid = tsid, veh = tveh, sea = tsea, typ = ttyp, rat = trat, vd = tvd, td = ttd, ran = tran, fir = tfir, ek = tek, ck = tck, fk = tfk, sui = tsui, lif = tlif, dea = tdea, tp = ttp, lc = tlc, ld = tld, prp = tprp WHERE pid = tpid AND na = tna AND mid = tmid;
183END;
184
185
186#
187# Definition for the `GetPlayer` procedure :
188#
189
190CREATE DEFINER = 'arma'@'localhost' PROCEDURE `GetPlayer`(IN tmid INTEGER(11), IN tpid INTEGER(11))
191 NOT DETERMINISTIC
192 CONTAINS SQL
193 SQL SECURITY DEFINER
194 COMMENT ''
195BEGIN
196 SELECT id,na,pid,mid,sc,pos,dam,dhe,dbo,dha,dle,dir,sta,sid,veh,sea,typ,rat,vd,td,ran,fir,ek,ck,fk,sui,lif,dea,tp,lc,ld,prp FROM players WHERE mid=tmid AND pid=tpid;
197END;