· 8 years ago · Mar 09, 2018, 04:22 AM
1CREATE TABLE IF NOT EXISTS `data_raw` (
2 `acctsessionid` varchar(32) COLLATE utf8_czech_ci DEFAULT NULL,
3 `username` varchar(64) COLLATE utf8_czech_ci DEFAULT NULL,
4 `nasipaddress` varchar(15) COLLATE utf8_czech_ci DEFAULT NULL,
5 `acctsessiontime` int(11) DEFAULT NULL,
6 `acctinputoctets` bigint(20) DEFAULT NULL,
7 `acctoutputoctets` bigint(20) DEFAULT NULL,
8 `prev_acctsessiontime` int(11) DEFAULT NULL,
9 `prev_acctinputoctets` bigint(20) DEFAULT NULL,
10 `prev_acctoutputoctets` bigint(20) DEFAULT NULL,
11 `diff_acctsessiontime` int(11) DEFAULT NULL,
12 `diff_acctinputoctets` bigint(20) DEFAULT NULL,
13 `diff_acctoutputoctets` bigint(20) DEFAULT NULL,
14 `framedipaddress` varchar(15) COLLATE utf8_czech_ci DEFAULT NULL,
15 `timenow` datetime DEFAULT NULL,
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 PRIMARY KEY (`id`),
18 KEY `data_raw_acctsessionid_index` (`acctsessionid`),
19 KEY `data_raw_username_index` (`username`),
20 KEY `data_raw_nasipaddress_index` (`nasipaddress`),
21 KEY `data_raw_framedipaddress_index` (`framedipaddress`)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;