· 8 years ago · Jan 17, 2018, 11:02 PM
1CREATE TABLE IF NOT EXISTS `businesses` (
2 `Id` int(11) NOT NULL AUTO_INCREMENT,
3 `Name` varchar(40) NOT NULL DEFAULT 'Unnamed Business',
4 `Type` int(11) NOT NULL DEFAULT '0',
5 `Value` int(11) NOT NULL DEFAULT '0',
6 `OwnerID` int(11) NOT NULL DEFAULT '0',
7 `OwnerName` varchar(40) NOT NULL DEFAULT 'None',
8 `Months` int(11) NOT NULL DEFAULT '0',
9 `SafeBalance` int(11) NOT NULL DEFAULT '0',
10 `Inventory` int(11) NOT NULL DEFAULT '0',
11 `InventoryCapacity` int(11) NOT NULL DEFAULT '1000',
12 `Status` int(11) NOT NULL DEFAULT '1',
13 `Level` tinyint(4) NOT NULL DEFAULT '1',
14 `LevelProgress` int(11) NOT NULL DEFAULT '0',
15 `AutoSale` tinyint(4) NOT NULL DEFAULT '1',
16 `OrderDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
17 `OrderAmount` int(11) NOT NULL DEFAULT '0',
18 `OrderBy` varchar(24) NOT NULL DEFAULT '',
19 `OrderState` int(11) NOT NULL DEFAULT '0',
20 `TotalSales` int(11) NOT NULL DEFAULT '0',
21 `Bargain` tinyint(4) NOT NULL DEFAULT '0',
22 `ExteriorX` float NOT NULL DEFAULT '0',
23 `ExteriorY` float NOT NULL DEFAULT '0',
24 `ExteriorZ` float NOT NULL DEFAULT '0',
25 `ExteriorA` float NOT NULL DEFAULT '0',
26 `InteriorX` float NOT NULL DEFAULT '0',
27 `InteriorY` float NOT NULL DEFAULT '0',
28 `InteriorZ` float NOT NULL DEFAULT '0',
29 `InteriorA` float NOT NULL DEFAULT '0',
30 `Interior` tinyint(4) NOT NULL DEFAULT '0',
31 `CustomExterior` int(11) NOT NULL DEFAULT '0',
32 `CustomInterior` int(11) NOT NULL DEFAULT '0',
33 `SupplyPointX` float NOT NULL DEFAULT '0',
34 `SupplyPointY` float NOT NULL DEFAULT '0',
35 `SupplyPointZ` float NOT NULL DEFAULT '0',
36 `Item1Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
37 `Item2Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
38 `Item3Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
39 `Item4Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
40 `Item5Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
41 `Item6Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
42 `Item7Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
43 `Item8Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
44 `Item9Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
45 `Item10Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
46 `Item11Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
47 `Item12Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
48 `Item13Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
49 `Item14Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
50 `Item15Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
51 `Item16Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
52 `Item17Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
53 `Item18Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
54 `Item19Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
55 `Rank0Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
56 `Rank1Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
57 `Rank2Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
58 `Rank3Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
59 `Rank4Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
60 `Rank5Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
61 `Pay` tinyint(4) NOT NULL DEFAULT '0',
62 `GasPrice` float unsigned NOT NULL DEFAULT '0',
63 `MinInviteRank` tinyint(4) NOT NULL DEFAULT '4',
64 `MinSupplyRank` tinyint(4) NOT NULL DEFAULT '5',
65 `MinGiveRankRank` tinyint(4) NOT NULL DEFAULT '5',
66 `MinSafeRank` tinyint(4) NOT NULL DEFAULT '5',
67 `GasPump1PosX` float NOT NULL DEFAULT '0',
68 `GasPump1PosY` float NOT NULL DEFAULT '0',
69 `GasPump1PosZ` float NOT NULL DEFAULT '0',
70 `GasPump1Angle` float NOT NULL DEFAULT '0',
71 `GasPump1Model` float NOT NULL DEFAULT '0',
72 `GasPump1Capacity` float NOT NULL DEFAULT '0',
73 `GasPump1Gas` float NOT NULL DEFAULT '0',
74 `GasPump2PosX` float NOT NULL DEFAULT '0',
75 `GasPump2PosY` float NOT NULL DEFAULT '0',
76 `GasPump2PosZ` float NOT NULL DEFAULT '0',
77 `GasPump2Angle` float NOT NULL DEFAULT '0',
78 `GasPump2Model` float NOT NULL DEFAULT '0',
79 `GasPump2Capacity` float NOT NULL DEFAULT '0',
80 `GasPump2Gas` float NOT NULL DEFAULT '0',
81 `Car0PosX` float NOT NULL DEFAULT '0',
82 `Car0PosY` float NOT NULL DEFAULT '0',
83 `Car0PosZ` float NOT NULL DEFAULT '0',
84 `Car0PosAngle` float NOT NULL DEFAULT '0',
85 `Car0ModelId` int(11) NOT NULL DEFAULT '0',
86 `Car0Price` int(11) NOT NULL DEFAULT '0',
87 `Car1PosX` float NOT NULL DEFAULT '0',
88 `Car1PosY` float NOT NULL DEFAULT '0',
89 `Car1PosZ` float NOT NULL DEFAULT '0',
90 `Car1PosAngle` float NOT NULL DEFAULT '0',
91 `Car1ModelId` int(11) NOT NULL DEFAULT '0',
92 `Car1Price` int(11) NOT NULL DEFAULT '0',
93 `Car2PosX` float NOT NULL DEFAULT '0',
94 `Car2PosY` float NOT NULL DEFAULT '0',
95 `Car2PosZ` float NOT NULL DEFAULT '0',
96 `Car2PosAngle` float NOT NULL DEFAULT '0',
97 `Car2ModelId` int(11) NOT NULL DEFAULT '0',
98 `Car2Price` int(11) NOT NULL DEFAULT '0',
99 `Car3PosX` float NOT NULL DEFAULT '0',
100 `Car3PosY` float NOT NULL DEFAULT '0',
101 `Car3PosZ` float NOT NULL DEFAULT '0',
102 `Car3PosAngle` float NOT NULL DEFAULT '0',
103 `Car3ModelId` int(11) NOT NULL DEFAULT '0',
104 `Car3Price` int(11) NOT NULL DEFAULT '0',
105 `Car1Stock` int(11) NOT NULL DEFAULT '0',
106 `Car2Stock` int(11) NOT NULL DEFAULT '0',
107 `Car3Stock` int(11) NOT NULL DEFAULT '0',
108 `Car1Order` int(11) NOT NULL DEFAULT '0',
109 `Car2Order` int(11) NOT NULL DEFAULT '0',
110 `Car3Order` int(11) NOT NULL DEFAULT '0',
111 `Car4PosX` float NOT NULL DEFAULT '0',
112 `Car4PosY` float NOT NULL DEFAULT '0',
113 `Car4PosZ` float NOT NULL DEFAULT '0',
114 `Car4PosAngle` float NOT NULL DEFAULT '0',
115 `Car4ModelId` int(11) NOT NULL DEFAULT '0',
116 `Car4Price` int(11) NOT NULL DEFAULT '0',
117 `Car5PosX` int(11) NOT NULL DEFAULT '0',
118 `Car5PosY` float NOT NULL DEFAULT '0',
119 `Car5PosZ` float NOT NULL DEFAULT '0',
120 `Car5PosAngle` float NOT NULL DEFAULT '0',
121 `Car5ModelId` int(11) NOT NULL DEFAULT '0',
122 `Car5Price` int(11) NOT NULL DEFAULT '0',
123 `Car6PosX` float NOT NULL DEFAULT '0',
124 `Car6PosY` float NOT NULL DEFAULT '0',
125 `Car6PosZ` float NOT NULL DEFAULT '0',
126 `Car6PosAngle` float NOT NULL DEFAULT '0',
127 `Car6ModelId` int(11) NOT NULL DEFAULT '0',
128 `Car6Price` int(11) NOT NULL DEFAULT '0',
129 `Car7PosX` float NOT NULL DEFAULT '0',
130 `Car7PosY` float NOT NULL DEFAULT '0',
131 `Car7PosZ` float NOT NULL DEFAULT '0',
132 `Car7PosAngle` float NOT NULL DEFAULT '0',
133 `Car7ModelId` int(11) NOT NULL DEFAULT '0',
134 `Car7Price` int(11) NOT NULL DEFAULT '0',
135 `Car8PosX` float NOT NULL DEFAULT '0',
136 `Car8PosY` float NOT NULL DEFAULT '0',
137 `Car8PosZ` float NOT NULL DEFAULT '0',
138 `Car8PosAngle` float NOT NULL DEFAULT '0',
139 `Car8ModelId` int(11) NOT NULL DEFAULT '0',
140 `Car8Price` int(11) NOT NULL DEFAULT '0',
141 `Car9PosX` float NOT NULL DEFAULT '0',
142 `Car9PosY` float NOT NULL DEFAULT '0',
143 `Car9PosZ` float NOT NULL DEFAULT '0',
144 `Car9PosAngle` float NOT NULL DEFAULT '0',
145 `Car9ModelId` int(11) NOT NULL DEFAULT '0',
146 `Car9Price` int(11) NOT NULL DEFAULT '0',
147 `PurchaseX` float NOT NULL DEFAULT '0',
148 `PurchaseY` float NOT NULL DEFAULT '0',
149 `PurchaseZ` float NOT NULL DEFAULT '0',
150 `PurchaseAngle` float NOT NULL DEFAULT '0',
151 `TotalProfits` int(11) NOT NULL DEFAULT '0',
152 `GymEntryFee` int(11) NOT NULL DEFAULT '0',
153 `GymType` int(11) NOT NULL DEFAULT '0',
154 `CustomVW` int(11) NOT NULL DEFAULT '0',
155 `Grade` int(11) NOT NULL DEFAULT '0',
156 `MaxLevel` int(11) NOT NULL DEFAULT '0',
157 PRIMARY KEY (`Id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;