· 7 years ago · Sep 29, 2018, 01:13 PM
1
2 mysql_tquery(DB, "CREATE TABLE IF NOT EXISTS "APARTMENT_DB" (\
3 `sSQLID` INT NOT NULL, \
4 `sImaVlasnika` INT NOT NULL, \
5 `sVlasnik` VARCHAR(24) NOT NULL, \
6 `sVrsta` INT NOT NULL, \
7 `sUlazX` FLOAT NOT NULL, \
8 `sUlazY` FLOAT NOT NULL, \
9 `sUlazZ` FLOAT NOT NULL, \
10 `sIzlazX` FLOAT NOT NULL, \
11 `sIzlazY` FLOAT NOT NULL, \
12 `sIzlazZ` FLOAT NOT NULL, \
13 `sLevel` INT NOT NULL, \
14 `sCena` INT NOT NULL, \
15 `sKasa` INT NOT NULL, \
16 `sGun` INT NOT NULL, \
17 `sAmmo` INT NOT NULL, \
18 `sZatvoreno` INT NOT NULL, \
19 `sVW` INT NOT NULL, \
20 `sNeakt` INT NOT NULL, \
21 `sPostavljena` INT NOT NULL, \
22 `sVWex` INT NOT NULL, \
23 `sRent` INT NOT NULL, \
24 `sRentCena` INT NOT NULL, \
25\
26 PRIMARY KEY (`sSQLID`))");