· 9 years ago · Dec 03, 2016, 05:48 PM
1--
2-- Structura de tabel pentru tabelul `graffiti`
3--
4
5CREATE TABLE IF NOT EXISTS `graffiti` (
6 `ID` int(10) NOT NULL,
7 `X` float NOT NULL,
8 `Y` float NOT NULL,
9 `Z` float NOT NULL,
10 `Rot` float NOT NULL,
11 `Owned` int(10) NOT NULL
12) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
13
14--
15-- Salvarea datelor din tabel `graffiti`
16--
17
18INSERT INTO `graffiti` (`ID`, `X`, `Y`, `Z`, `Rot`, `Owned`) VALUES
19(1, 1673.76, -1887.19, 14.0777, 0, 1),
20(2, 1417.01, -1892.43, 14.4683, 0, 0),
21(3, 1176.65, -1796.85, 14.3122, 0, 0),
22(4, 1673.68, -1701.18, 14.2847, 0, 0),
23(5, 1603.79, -1650.1, 14.3359, 0, 0),
24(6, 1264.66, -1695.05, 14.2473, 90, 0),
25(7, 1334.17, -1539.31, 13.93, 83.64, 0),
26(8, 1182.02, -1348.67, 14.3842, 0, 0),
27(9, 1182.89, -1201.48, 20.5486, 90.06, 0),
28(10, 1017.05, -1251.42, 15.6977, 0, 0),
29(11, 782.799, -1130.14, 24.2619, -90.06, 0),
30(12, 823.333, -996.36, 27.9567, -51.24, 0),
31(13, 922.892, -944.277, 40.9296, 92.7001, 0),
32(14, 1073.74, -897.131, 43.0716, 0, 0),
33(15, 1211.74, -975.194, 44.0208, 90.6, 0),
34(16, 1702.96, -1125.12, 24.6669, 0, 0),
35(17, 1305.6, -1248.6, 14.1569, 0, 0);
36--
37-- Indexes for table `graffiti`
38--
39ALTER TABLE `graffiti`
40 ADD PRIMARY KEY (`ID`);