4f44b9ag

1-- Ubilling updates from 0.2.4
2-- see more at ubilling.net.ua
3
4-- 0.2.5 update
5
6CREATE TABLE `genocide` (
7`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
8`tariff` VARCHAR( 255 ) NOT NULL ,
9`speed` INT NOT NULL
10) ENGINE = MYISAM CHARSET=utf8 AUTO_INCREMENT=1;
11
12-- 0.2.6 update
13
14CREATE TABLE `ubstats` (
15`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
16`key` VARCHAR( 40 ) NULL ,
17`value` VARCHAR ( 255 ) NULL
18) ENGINE = MYISAM CHARSET=utf8 AUTO_INCREMENT=1;
19
20-- 0.2.7 update
21CREATE TABLE `bankstaraw` (
22`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
23`filename` VARCHAR( 255 ) NOT NULL ,
24`rawdata` TEXT NOT NULL
25) ENGINE = MYISAM CHARSET=utf8 AUTO_INCREMENT=1;
26
27
28CREATE TABLE IF NOT EXISTS `bankstaparsed` (
29  `id` int(11) NOT NULL auto_increment,
30  `hash` varchar(255) NOT NULL,
31  `date` datetime NOT NULL,
32  `row` int(11) NOT NULL,
33  `realname` varchar(255) NOT NULL,
34  `address` varchar(255) NOT NULL,
35  `summ` float NOT NULL,
36  `state` int(11) NOT NULL,
37  `login` varchar(255) NOT NULL,
38  PRIMARY KEY  (`id`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
40
41-- 0.2.8 update
42
43CREATE TABLE `nastemplates` (
44`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
45`nasid` INT NOT NULL ,
46`template` TEXT NOT NULL
47) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
48
49
50
51CREATE TABLE `radattr` (
52  `id` int(11) NOT NULL auto_increment,
53  `login` varchar(255) NOT NULL,
54  `attr` varchar(255) NOT NULL,
55  `value` varchar(255) NOT NULL,
56  PRIMARY KEY  (`id`)
57) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
58
59-- 0.2.9 update
60
61CREATE TABLE `ubstorage` (
62  `id` int(11) NOT NULL auto_increment,
63  `key` varchar(255) default NULL,
64  `value` text,
65  PRIMARY KEY  (`id`),
66  KEY `key` (`key`),
67  FULLTEXT KEY `value` (`value`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
69
70CREATE TABLE `sigreq` (
71`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
72`date` DATETIME NOT NULL ,
73`state` TINYINT NOT NULL ,
74`ip` VARCHAR( 40 ) NOT NULL ,
75`street` VARCHAR( 255 ) NOT NULL ,
76`build` VARCHAR( 40 ) NOT NULL ,
77`apt` VARCHAR( 40 ) NOT NULL ,
78`realname` VARCHAR( 255 ) NOT NULL ,
79`phone` VARCHAR( 255 ) NOT NULL ,
80`service` VARCHAR( 255 ) NOT NULL ,
81`notes` TEXT default NULL
82) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;