1LRsTAKL

1--
2-- Структура таблиці `users`
3--
4
5CREATE TABLE IF NOT EXISTS `users` (
6  `login` varchar(50) NOT NULL DEFAULT '',
7  `Password` varchar(150) NOT NULL DEFAULT '*',
8  `Passive` int(3) DEFAULT '0',
9  `Down` int(3) DEFAULT '0',
10  `DisabledDetailStat` int(3) DEFAULT '0',
11  `AlwaysOnline` int(3) DEFAULT '0',
12  `Tariff` varchar(40) NOT NULL DEFAULT '',
13  `Address` varchar(254) NOT NULL DEFAULT '',
14  `Phone` varchar(128) NOT NULL DEFAULT '',
15  `Email` varchar(50) NOT NULL DEFAULT '',
16  `Note` text NOT NULL,
17  `RealName` varchar(254) NOT NULL DEFAULT '',
18  `StgGroup` varchar(40) NOT NULL DEFAULT '',
19  `Credit` double DEFAULT '0',
20  `TariffChange` varchar(40) NOT NULL DEFAULT '',
21  `Userdata0` varchar(254) NOT NULL,
22  `Userdata1` varchar(254) NOT NULL,
23  `Userdata2` varchar(254) NOT NULL,
24  `Userdata3` varchar(254) NOT NULL,
25  `Userdata4` varchar(254) NOT NULL,
26  `Userdata5` varchar(254) NOT NULL,
27  `Userdata6` varchar(254) NOT NULL,
28  `Userdata7` varchar(254) NOT NULL,
29  `Userdata8` varchar(254) NOT NULL,
30  `Userdata9` varchar(254) NOT NULL,
31  `CreditExpire` int(11) DEFAULT '0',
32  `IP` varchar(254) DEFAULT '*',
33  `D0` bigint(30) DEFAULT '0',
34  `U0` bigint(30) DEFAULT '0',
35  `D1` bigint(30) DEFAULT '0',
36  `U1` bigint(30) DEFAULT '0',
37  `D2` bigint(30) DEFAULT '0',
38  `U2` bigint(30) DEFAULT '0',
39  `D3` bigint(30) DEFAULT '0',
40  `U3` bigint(30) DEFAULT '0',
41  `D4` bigint(30) DEFAULT '0',
42  `U4` bigint(30) DEFAULT '0',
43  `D5` bigint(30) DEFAULT '0',
44  `U5` bigint(30) DEFAULT '0',
45  `D6` bigint(30) DEFAULT '0',
46  `U6` bigint(30) DEFAULT '0',
47  `D7` bigint(30) DEFAULT '0',
48  `U7` bigint(30) DEFAULT '0',
49  `D8` bigint(30) DEFAULT '0',
50  `U8` bigint(30) DEFAULT '0',
51  `D9` bigint(30) DEFAULT '0',
52  `U9` bigint(30) DEFAULT '0',
53  `Cash` double DEFAULT '0',
54  `FreeMb` double DEFAULT '0',
55  `LastCashAdd` double DEFAULT '0',
56  `LastCashAddTime` int(11) DEFAULT '0',
57  `PassiveTime` int(11) DEFAULT '0',
58  `LastActivityTime` int(11) DEFAULT '0',
59  `NAS` varchar(17) NOT NULL,
60  PRIMARY KEY (`login`),
61  KEY `AlwaysOnline` (`AlwaysOnline`),
62  KEY `IP` (`IP`),
63  KEY `Address` (`Address`),
64  KEY `Tariff` (`Tariff`),
65  KEY `Phone` (`Phone`),
66  KEY `Email` (`Email`),
67  KEY `RealName` (`RealName`)
68) ENGINE=MyISAM DEFAULT CHARSET=latin1;