root/tags/1.0.3/mysql/sams_db.txt

Revision 2, 7.2 KB (checked in by blaze, 3 years ago)

Import SAMS v.2007-01-29
Line 
1CREATE TABLE `sams` 
2`endvalue` bigint(20),
3`redirect_to` varchar(100),
4`denied_to` varchar(100),
5`redirector` varchar(25),
6`delaypool` char(1),
7`useraccess` char(1),
8`auth` varchar(4),
9`wbinfopath` varchar(100) - ÐÕÔØ Ë wbinfo × ÓÉÓÔÅÍÅ,
10`urlaccess` char(1) - ÄÏÓÔÕÐ ÐÏÌØÚÏ×ÁÔÅÌÅÊ Ë ÒÁÚÒÅÛÅÎ,
11`separator` varchar(15) default '+',
12`ntlmdomain` char(1),
13`bigd` char(1) ,
14`bigu` char(1),
15`sleep` int(3),
16`parser_on` char(1),
17`parser` varchar(10),
18`parser_time` int(2),
19`count_clean` char(1),
20`nameencode` char(1),
21`iconset` varchar(25) - ÎÁÂÏÒ ÉËÏÎÏË, ÉÓÐÏÌØÚÕÅÍÙÈ × sams
22`days` varchar(14),
23`shour` tinyint(2),
24`smin` tinyint(2),
25`ehour` tinyint(2),
26`emin` tinyint(2),
27`autherrorc` tinyint(1),
28`autherrort` varchar(16),
29`realsize` varchar(4) ,
30`checkdns` varchar(1),
31`loglevel` tinyint(1) NOT NULL default '0',
32`defaultdomain` char(25) NOT NULL default 'workgroup',
33`squidbase` tinyint(2) NOT NULL default '0',
34udscript char(25) NOT NULL default 'NONE',
35adminaddr char(25) default ''
36
37
38TABLE `groups` (
39`count` int(11) - ×ÒÏÄÅ ÎÅ ÉÓÐÏÌØÚÕÅÔÓÑ
40`name` char(25) - id ÇÒÕÐÐÙ × sams
41`nick` char(25) - ÎÁÚ×ÁÎÉÅ ÇÒÕÐÐÙ
42`value` char(10) - ÎÅ ÉÓÐÏÌØÚÕÅÔÓÑ
43
44TABLE `squidusers`
45 `id` char(25)  - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÐÏÌØÚÏ×ÁÔÅÌÑ × sams
46 `nick` char(25) - ÎÉË ÐÏÌØÚÏ×ÁÔÅÌÑ
47 `family` char(25) - ÆÁÍÉÌÉÑ ÐÏÌØÚÏ×ÁÔÅÌÑ
48 `name` char(25) - ÉÍÑ ÐÏÌØÚÏ×ÁÔÅÌÑ
49 `soname` char(25), - ÏÔÞÅÓÔ×Ï
50 `group` char(25), - ÇÒÕÐÐÁ (name × ÔÁÂÌÉÃÅ group) ÐÏÌØÚÏ×ÁÔÅÌÑ
51 `domain` char(25) - ÄÏÍÅÎ ÐÏÌØÚÏ×ÁÔÅÌÑ
52 `shablon` char(25) - ÛÁÂÌÏÎ (id) ÐÏÌØÚÏ×ÁÔÅÌÑ 
53 `quotes` bigint(20) - Ë×ÏÔÁ ÐÏÌØÚÏ×ÁÔÅÌÑ
54 `size` bigint(20) - ÒÁÚÍÅÒ ÔÒÁÆÉËÁ ÐÏÌØÚÏ×ÁÔÅÌÑ
55 `enabled` int(11) - ÐÏÌØÚÏ×ÁÔÅÌØ ×ËÌÀÞÅÎ
56                1 - ÁËÔÉ×ÅÎ,
57                0 - ÔÒÁÆÉË ÐÒÅ×ÙÛÅÎ,ÐÏÌØÚÏ×ÁÔÅÌØ ÏÔËÌÀÞÅÎ
58                -1 - ÐÏÌØÚÏ×ÁÔÅÌØ ÏÔËÌÀÞÅÎ
59 `ip` char(15) - ip ÁÄÒÅÓ
60 `ipmask` char(15) - ip ÍÁÓËÁ
61 `passwd` char(20) - ÐÁÒÏÌØ ÐÏÌØÚÏ×ÁÔÅÌÀ (ÐÒÉ ip, ncsa Á×ÔÏÒÉÚÁÃÉÉ)
62 `gauditor` int(1) - ÐÏÌØÚÏ×ÁÔÅÌØ - ÒÕËÏ×ÏÄÉÔÅÌØ ÇÒÕÐÐÙ (1)
63 `hit`  - ÒÁÚÍÅÒ ÔÒÁÆÉËÁ, ÐÏÌÕÞÅÎÎÏÇÏ ÉÚ ËÜÛÁ
64 `autherrorc`  -
65 `autherrort`
66
67 #
68 TABLE `shablons`
69  `name` varchar(25) - id ÛÁÂÌÏÎÁ × sams
70  `nick` varchar(25) - ÉÍÑ ÛÁÂÌÏÎÁ
71  `shablonpool` bigint - ÒÁÚÍÅÒ ÐÕÌÁ ÇÒÕÐÐÙ
72  `userpool` bigint
73  `redirect_to` varchar(100)
74  `auth` varchar(4) - ÓÐÏÓÏ Á×ÔÏÒÉÚÁÃÉÉ ÐÏÌØÚÏ×ÁÔÅÌÅÊ × ÛÁÂÌÏÎÅ
75  `traffic` int(25) - ÒÁÚÍÅÒ ÔÒÁÆÆÉËÁ ÐÏÌØÚÏ×ÁÔÅÌÅÊ ÇÒÕÐÐÙ ÐÏ-ÕÍÏÌÞÁÎÉÀ
76  `days` varchar(14) -
77  `shour` tinyint(2)
78  `smin` tinyint(2)
79  `ehour` tinyint(2)
80  `emin` tinyint(2)
81  `period` char(3) NOT NULL default 'M'  - ÐÅÒÉÏÄ ÐÏÄÓÞÅÔÁ ÔÒÁÆÉËÁ ÐÏÌØÚÏ×ÁÔÅÌÅÊ, ÚÎÁÞÅÎÉÑ
82                M - ÍÅÓÑÃ
83                W - ÎÅÄÅÌÑ
84                ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ
85  `clrdate`  - ÄÁÔÁ ÓÌÅÄÕÀÝÅÇÏ ÏÂÎÕÌÅÎÉÑ ÓÞÅÔÞÉËÏ× ÔÒÁÆÉËÁ ÐÏÌØÚÏ×ÁÔÅÌÅÊ
86  `alldenied`
87 
88
89 DROP TABLE IF EXISTS `ipreplace`;
90 CREATE TABLE `ipreplace` ( `ip` char(15), `user` char(25), `domain` char(25)) TYPE=MyISAM;
91 DROP TABLE IF EXISTS `log`;
92 CREATE TABLE `log` ( `user` char(25), `date` date, `time` time, `value` char(60), `code` char(2)) TYPE=MyISAM;
93 DROP TABLE IF EXISTS `passwd`;
94 CREATE TABLE `passwd` ( `user` char(25), `pass` char(60), `access` int(11)) TYPE=MyISAM;
95 INSERT INTO passwd VALUES('Admin','00YfpO1MXDzqQ','1');
96 INSERT INTO passwd VALUES('Auditor','00MTbxknCTtNs','1');
97 DROP TABLE IF EXISTS `reconfig`;
98 CREATE TABLE `reconfig` ( `number` int(2),`service` varchar (15),`action` varchar(10)) TYPE=MyISAM;
99 INSERT INTO reconfig VALUES('1','sams','');
100 DROP TABLE IF EXISTS `redirect`;
101 CREATE TABLE `redirect` ( `name` varchar(25), `filename` varchar(25), `type` varchar(25), `show` int(10) unsigned, `redirect_to` varchar(100)) TYPE=MyISAM;
102 INSERT INTO redirect VALUES('Banners','banners','redir','0','');
103 INSERT INTO redirect VALUES('Counters','counters','redir','0','');
104 INSERT INTO redirect VALUES('Chats','chat','denied','0','');
105 INSERT INTO redirect VALUES('Porno','porno','denied','0','');
106 INSERT INTO redirect VALUES('Localdomains','localhosts','denied','0','');
107 DROP TABLE IF EXISTS `sams`;
108 CREATE TABLE `sams` ( `endvalue` bigint(20), `redirect_to` varchar(100), `denied_to` varchar(100), `redirector` varchar(25), `delaypool` char(1), `useraccess` char(1), `auth` varchar(4), `wbinfopath` varchar(100),`urlaccess` char(1),`separator` varchar(15) default '+',`ntlmdomain` char(1),`bigd` char(1),`bigu` char(1),`sleep` int(3),`parser_on` char(1),`parser` varchar(10),`parser_time` int(2),`count_clean` char(1),`nameencode` char(1),`iconset` varchar(25),`days` varchar(14),`shour` tinyint(2),`smin` tinyint(2),`ehour` tinyint(2),`emin` tinyint(2),`autherrorc` tinyint(1), `autherrort` varchar(16), `realsize` varchar(4), `checkdns` varchar(1), `loglevel` tinyint(1) NOT NULL default '0',`defaultdomain` char(25) NOT NULL default 'workgroup', `squidbase` tinyint(2) NOT NULL default '0', udscript char(25) NOT NULL default 'NONE', adminaddr char(25) default '' ) TYPE=MyISAM;
109 INSERT INTO sams VALUES('0','http://your.ip.address/sams/icon/classic/blank.gif','http://your.ip.address/sams/messages','sams','Y','Y','ntlm','/usr/bin','Y','+','Y','','','1','','','','Y','N','classic','MTWHFAS','0','0','24','0','0','0','real','N','0','workgroup','0','NONE','');
110 DROP TABLE IF EXISTS `sconfig`;
111 CREATE TABLE `sconfig` ( `sname` char(25), `set` char(25)) TYPE=MyISAM;
112 DROP TABLE IF EXISTS `sguard`;
113 CREATE TABLE `sguard` ( `sname` varchar(25), `name` varchar(100), `domain` char(1), `url` char(1), `expr` char(1)) TYPE=MyISAM;
114 DROP TABLE IF EXISTS `shablons`;
115 INSERT INTO shablons VALUES('default','Default','64000','64000','','','100','MTWHFAS','0','0','24','0','M','0000-00-00','0');
116 DROP TABLE IF EXISTS `squidusers`;
117 CREATE TABLE `squidusers` ( `id` char(25), `nick` char(25), `family` char(25), `name` char(25), `soname` char(25), `group` char(25), `domain` char(25), `shablon` char(25), `quotes` bigint(20), `size` bigint(20), `enabled` int(11), `ip` char(15), `ipmask` char(15), `passwd` char(20), `gauditor` int(1),`hit` bigint(20) NOT NULL default '0', `autherrorc` tinyint(1) default '0', `autherrort` varchar(16) default '0' ) TYPE=MyISAM;
118 DROP TABLE IF EXISTS `tree`;
119 CREATE TABLE `tree` ( `name` char(25), `value` tinyint(4)) TYPE=MyISAM;
120 DROP TABLE IF EXISTS `urlreplace`;
121 CREATE TABLE `urlreplace` ( `user` char(25), `domain` char(25), `url` char(50), `newurl` char(50)) TYPE=MyISAM;
122 DROP TABLE IF EXISTS `urls`;
123 CREATE TABLE `urls` ( `url` char(90), `type` char(25)) TYPE=MyISAM;
124 DROP TABLE IF EXISTS `globalsettings`;
125 CREATE TABLE `globalsettings` (`lang` varchar(15) NOT NULL default 'EN', `iconset`varchar(25) NOT NULL default 'classic', `useraccess` char(1) NOT NULL default 'Y', `urlaccess` char(1) NOT NULL default 'Y', `showutree` char(1) NOT NULL default 'Y' , `showname` varchar(5) NOT NULL default 'nick', `kbsize` char(15) NOT NULL default '1024', `mbsize` char(15) NOT NULL default '1048576', `showgraph` char(1) NOT NULL default 'N', `createpdf` varchar(6) NOT NULL default 'none') TYPE=MyISAM;
126 INSERT INTO `globalsettings` VALUES('EN','classic','Y','Y','Y','nick','1024','1048576','N','none');
127 UPDATE squidctrl.passwd SET passwd.pass=ENCRYPT("qwerty","00") WHERE passwd.user='Admin';
128 ALTER TABLE squidusers ADD INDEX (`nick`);
129 ALTER TABLE squidusers ADD INDEX (`group`);
130 ALTER TABLE squidusers ADD INDEX (`family`);
131 DROP TABLE IF EXISTS `proxyes`;
132 CREATE TABLE `proxyes` ( `id` tinyint(3) default '0', `description` varchar(50) default 'Proxy server') TYPE=MyISAM;
133
134
Note: See TracBrowser for help on using the browser.