wok-next rev 20179
Up ocsinventory (2.2) opencc (0.4.3)
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Thu Nov 02 11:09:53 2017 +0100 (2017-11-02) |
parents | 85b9676f2614 |
children | 66ea853c51e4 |
files | mudraw/receipt mupdf-dev/receipt mupdf/receipt nagvis-doc/receipt nagvis-flex/receipt nagvis/receipt ntop-dev/receipt ntop-man/receipt ntop/receipt ocsinventory-server/receipt ocsinventory/receipt ocsinventory/stuff/dbconfig.inc.php ocsinventory/stuff/ocsbase.sql ocsreports/receipt ocsreports/stuff/dbconfig.inc.php ocsreports/stuff/ocsbase.sql opencc-dev/receipt opencc-tools/receipt opencc/receipt |
line diff
1.1 --- a/mudraw/receipt Thu Nov 02 09:44:39 2017 +0100 1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 1.3 @@ -1,19 +0,0 @@ 1.4 -# SliTaz package receipt. 1.5 - 1.6 -PACKAGE="mudraw" 1.7 -VERSION="1.4" 1.8 -CATEGORY="development" 1.9 -SHORT_DESC="A lightweight PDF and XPS viewer (mudraw)" 1.10 -MAINTAINER="al.bobylev@gmail.com" 1.11 -LICENSE="GPL3" 1.12 -WEB_SITE="http://mupdf.com/" 1.13 - 1.14 -DEPENDS="bzlib freetype jbig2dec openjpeg" 1.15 -WANTED="mupdf" 1.16 - 1.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 1.18 -genpkg_rules() 1.19 -{ 1.20 - mkdir -p $fs/usr/bin 1.21 - cp -a $install/usr/bin/mudraw $fs/usr/bin 1.22 -}
2.1 --- a/mupdf-dev/receipt Thu Nov 02 09:44:39 2017 +0100 2.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 2.3 @@ -1,20 +0,0 @@ 2.4 -# SliTaz package receipt. 2.5 - 2.6 -PACKAGE="mupdf-dev" 2.7 -VERSION="1.4" 2.8 -CATEGORY="development" 2.9 -SHORT_DESC="Development files for mupdf" 2.10 -MAINTAINER="al.bobylev@gmail.com" 2.11 -LICENSE="GPL3" 2.12 -WEB_SITE="http://mupdf.com/" 2.13 - 2.14 -DEPENDS="mupdf mudraw" 2.15 -WANTED="mupdf" 2.16 - 2.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 2.18 -genpkg_rules() 2.19 -{ 2.20 - mkdir -p $fs/usr 2.21 - cp -a $install/usr/include $fs/usr 2.22 - cp -a $install/usr/lib $fs/usr 2.23 -}
3.1 --- a/mupdf/receipt Thu Nov 02 09:44:39 2017 +0100 3.2 +++ b/mupdf/receipt Thu Nov 02 11:09:53 2017 +0100 3.3 @@ -1,4 +1,4 @@ 3.4 -# SliTaz package receipt. 3.5 +# SliTaz package receipt v2. 3.6 3.7 PACKAGE="mupdf" 3.8 VERSION="1.11" 3.9 @@ -11,9 +11,9 @@ 3.10 WGET_URL="http://mupdf.com/downloads/$TARBALL" 3.11 #HOST_ARCH="i486 arm" 3.12 3.13 -DEPENDS="bzlib freetype fontconfig jbig2dec openjpeg xorg-libXext" 3.14 BUILD_DEPENDS="freetype-dev fontconfig-dev jbig2dec-dev jpeg-dev \ 3.15 openjpeg-dev zlib-dev xorg-dev" 3.16 +SPLIT="mupdf mudraw mupdf-dev" 3.17 3.18 # Rules to configure and make the package. 3.19 compile_rules() 3.20 @@ -49,6 +49,24 @@ 3.21 # Rules to gen a SliTaz package suitable for Tazpkg. 3.22 genpkg_rules() 3.23 { 3.24 - mkdir -p $fs/usr/bin 3.25 - cp -a $install/usr/bin/mupdf* $fs/usr/bin 3.26 + case $PACKAGE in 3.27 + mupdf) 3.28 + DEPENDS="bzlib freetype fontconfig jbig2dec openjpeg xorg-libXext" 3.29 + mkdir -p $fs/usr/bin 3.30 + cp -a $install/usr/bin/mupdf* $fs/usr/bin 3.31 + ;; 3.32 + mudraw) 3.33 + CAT="development|A lightweight PDF and XPS viewer (mudraw)" 3.34 + DEPENDS="bzlib freetype jbig2dec openjpeg" 3.35 + mkdir -p $fs/usr/bin 3.36 + cp -a $install/usr/bin/mudraw $fs/usr/bin 3.37 + ;; 3.38 + mupdf-dev) 3.39 + CAT="development|Development files for mupdf" 3.40 + DEPENDS="mupdf mudraw" 3.41 + mkdir -p $fs/usr 3.42 + cp -a $install/usr/include $fs/usr 3.43 + cp -a $install/usr/lib $fs/usr 3.44 + ;; 3.45 + esac 3.46 }
4.1 --- a/nagvis-doc/receipt Thu Nov 02 09:44:39 2017 +0100 4.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 4.3 @@ -1,27 +0,0 @@ 4.4 -# SliTaz package receipt. 4.5 - 4.6 -PACKAGE="nagvis-doc" 4.7 -VERSION="1.5.7" 4.8 -CATEGORY="network" 4.9 -SHORT_DESC="Nagvis documentation and licence" 4.10 -MAINTAINER="erjo@slitaz.org" 4.11 -LICENSE="GPL2" 4.12 -WEB_SITE="http://www.nagvis.org/" 4.13 -WANTED="nagvis" 4.14 - 4.15 -DEPENDS="nagvis" 4.16 - 4.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 4.18 -genpkg_rules() 4.19 -{ 4.20 - mkdir -p $fs/usr/share/doc/nagvis \ 4.21 - $fs/usr/share/nagvis 4.22 - 4.23 - # Copy doc and licence 4.24 - cp -a $src/INSTALL $fs/usr/share/doc/nagvis 4.25 - cp -a $src/LICENCE $fs/usr/share/doc/nagvis 4.26 - cp -a $src/README $fs/usr/share/doc/nagvis 4.27 - cp -a $src/ChangeLog $fs/usr/share/doc/nagvis 4.28 - cp -pa $src/docs $fs/usr/share/nagvis 4.29 -} 4.30 -
5.1 --- a/nagvis-flex/receipt Thu Nov 02 09:44:39 2017 +0100 5.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 5.3 @@ -1,22 +0,0 @@ 5.4 -# SliTaz package receipt. 5.5 - 5.6 -PACKAGE="nagvis-flex" 5.7 -VERSION="1.5.7" 5.8 -CATEGORY="network" 5.9 -SHORT_DESC="Nagvis Flex" 5.10 -MAINTAINER="erjo@slitaz.org" 5.11 -LICENSE="GPL2" 5.12 -WEB_SITE="http://www.nagvis.org/" 5.13 -WANTED="nagvis" 5.14 - 5.15 -DEPENDS="nagvis" 5.16 - 5.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 5.18 -genpkg_rules() 5.19 -{ 5.20 - mkdir -p $fs/usr/share/nagvis 5.21 - 5.22 - # Copy doc and licence 5.23 - cp -a $src/uifx $fs/usr/share/nagvis 5.24 -} 5.25 -
6.1 --- a/nagvis/receipt Thu Nov 02 09:44:39 2017 +0100 6.2 +++ b/nagvis/receipt Thu Nov 02 11:09:53 2017 +0100 6.3 @@ -1,4 +1,4 @@ 6.4 -# SliTaz package receipt. 6.5 +# SliTaz package receipt v2. 6.6 6.7 PACKAGE="nagvis" 6.8 VERSION="1.5.7" 6.9 @@ -9,9 +9,8 @@ 6.10 TARBALL="$PACKAGE-$VERSION.tar.gz" 6.11 WEB_SITE="http://www.nagvis.org/" 6.12 WGET_URL="$SF_MIRROR/$PACKAGE/$TARBALL" 6.13 -SUGGESTED="graphviz" 6.14 6.15 -DEPENDS="nagios php-mysql php-gd ndoutils mk-livestatus" 6.16 +SPLIT="nagvis nagvis-doc nagvis-flex" 6.17 6.18 # Rules to configure and make the package. 6.19 compile_rules() 6.20 @@ -22,85 +21,111 @@ 6.21 # Rules to gen a SliTaz package suitable for Tazpkg. 6.22 genpkg_rules() 6.23 { 6.24 - mkdir -p $fs/usr/share/nagvis \ 6.25 - $fs/etc/apache/conf.d \ 6.26 - $fs/var/lib/nagvis/var/tmpl/cache \ 6.27 - $fs/var/lib/nagvis/var/tmpl/compile \ 6.28 - $fs/usr/share/doc/nagvis 6.29 + case $PACKAGE in 6.30 + nagivs) 6.31 + SUGGESTED="graphviz" 6.32 + DEPENDS="nagios php-mysql php-gd ndoutils mk-livestatus" 6.33 + mkdir -p $fs/usr/share/nagvis \ 6.34 + $fs/etc/apache/conf.d \ 6.35 + $fs/var/lib/nagvis/var/tmpl/cache \ 6.36 + $fs/var/lib/nagvis/var/tmpl/compile \ 6.37 + $fs/usr/share/doc/nagvis 6.38 6.39 - cp -a $src/share $fs/usr/share/nagvis 6.40 - cp -a $src/etc $fs/etc/nagvis 6.41 + cp -a $src/share $fs/usr/share/nagvis 6.42 + cp -a $src/etc $fs/etc/nagvis 6.43 6.44 - # copy demo maps. 6.45 - #~ cp $fs/usr/share/nagios/nagvis/nagvis/images/maps/nagvis-demo.png \ 6.46 - #~ $fs/var/lib/nagvis/automap.png 6.47 + # copy demo maps. 6.48 + #~ cp $fs/usr/share/nagios/nagvis/nagvis/images/maps/nagvis-demo.png \ 6.49 + #~ $fs/var/lib/nagvis/automap.png 6.50 6.51 - # link var direcxtory (FHS) 6.52 - ln -s /var/lib/nagvis/var $fs/usr/share/nagvis/var 6.53 + # link var direcxtory (FHS) 6.54 + ln -s /var/lib/nagvis/var $fs/usr/share/nagvis/var 6.55 6.56 - # move config files 6.57 - ln -s /etc/nagvis $fs/usr/share/nagvis/etc 6.58 + # move config files 6.59 + ln -s /etc/nagvis $fs/usr/share/nagvis/etc 6.60 6.61 - # nagvis config 6.62 - mv $fs/etc/nagvis/nagvis.ini.php-sample $fs/etc/nagvis/nagvis.ini.php 6.63 - sed -i -e 's|;language=|language=|' \ 6.64 - -e 's|;dateformat="Y-m-d H:i:s"|dateformat="d-m-Y H:i:s"|' \ 6.65 - -e 's|;base=.*|base="/usr/share/nagvis/"|' \ 6.66 - -e 's|;htmlbase=|htmlbase=|' \ 6.67 - -e 's|;htmlcgi=|htmlcgi=|' \ 6.68 - -e 's|;backendtype=|backendtype=|' \ 6.69 - -e 's|;dbhost=|dbhost=|' \ 6.70 - -e 's|;dbport=|dbport=|' \ 6.71 - -e 's|;dbname=|dbname=|' \ 6.72 - -e 's|;dbname=|dbname=|' \ 6.73 - -e 's|;dbuser=|dbuser=|' \ 6.74 - -e 's|;dbpass=""|dbpass=|' \ 6.75 - -e 's|;dbprefix=|dbprefix=|' \ 6.76 - -e 's|;dbinstancename=|dbinstancename=|' \ 6.77 - $fs/etc/nagvis/nagvis.ini.php 6.78 + # nagvis config 6.79 + mv $fs/etc/nagvis/nagvis.ini.php-sample $fs/etc/nagvis/nagvis.ini.php 6.80 + sed -i -e 's|;language=|language=|' \ 6.81 + -e 's|;dateformat="Y-m-d H:i:s"|dateformat="d-m-Y H:i:s"|' \ 6.82 + -e 's|;base=.*|base="/usr/share/nagvis/"|' \ 6.83 + -e 's|;htmlbase=|htmlbase=|' \ 6.84 + -e 's|;htmlcgi=|htmlcgi=|' \ 6.85 + -e 's|;backendtype=|backendtype=|' \ 6.86 + -e 's|;dbhost=|dbhost=|' \ 6.87 + -e 's|;dbport=|dbport=|' \ 6.88 + -e 's|;dbname=|dbname=|' \ 6.89 + -e 's|;dbname=|dbname=|' \ 6.90 + -e 's|;dbuser=|dbuser=|' \ 6.91 + -e 's|;dbpass=""|dbpass=|' \ 6.92 + -e 's|;dbprefix=|dbprefix=|' \ 6.93 + -e 's|;dbinstancename=|dbinstancename=|' \ 6.94 + $fs/etc/nagvis/nagvis.ini.php 6.95 6.96 - sed -i -e '/;logonmodule=/ { 6.97 - a\logonmodule="LogonEnv"\ 6.98 + sed -i -e '/;logonmodule=/ { 6.99 + a\logonmodule="LogonEnv"\ 6.100 logonenvvar="REMOTE_USER"\ 6.101 logonenvcreateuser="0" 6.102 - }' $fs/etc/nagvis/nagvis.ini.php 6.103 - sed -i -e '/;socket/ a\socket="unix:/var/lib/nagios/rw/live"' $fs/etc/nagvis/nagvis.ini.php 6.104 - sed -i -e 's/;showautomaps=1/showautomaps=0/' $fs/etc/nagvis/nagvis.ini.php 6.105 + }' $fs/etc/nagvis/nagvis.ini.php 6.106 + sed -i -e '/;socket/ a\socket="unix:/var/lib/nagios/rw/live"' $fs/etc/nagvis/nagvis.ini.php 6.107 + sed -i -e 's/;showautomaps=1/showautomaps=0/' $fs/etc/nagvis/nagvis.ini.php 6.108 6.109 - # Apache config 6.110 - mv $fs/etc/nagvis/apache2-nagvis.conf-sample $fs/etc/nagvis/apache2-nagvis.conf 6.111 - ln -s /etc/nagvis/apache2-nagvis.conf $fs/etc/apache/conf.d/nagvis.conf 6.112 - sed -i -e 's|@NAGVIS_WEB@|/nagvis|' \ 6.113 - -e 's|@NAGVIS_PATH@|/usr/share/nagvis|' \ 6.114 - -e 's|#AuthName|AuthName|' \ 6.115 - -e 's|#AuthType|AuthType|' \ 6.116 - -e 's|#AuthUserFile|AuthUserFile|' \ 6.117 - -e 's|@NAGIOS_PATH@.*|/etc/nagios/htpasswd.users|' \ 6.118 - -e 's| #Require|Require|' $fs/etc/nagvis/apache2-nagvis.conf 6.119 + # Apache config 6.120 + mv $fs/etc/nagvis/apache2-nagvis.conf-sample $fs/etc/nagvis/apache2-nagvis.conf 6.121 + ln -s /etc/nagvis/apache2-nagvis.conf $fs/etc/apache/conf.d/nagvis.conf 6.122 + sed -i -e 's|@NAGVIS_WEB@|/nagvis|' \ 6.123 + -e 's|@NAGVIS_PATH@|/usr/share/nagvis|' \ 6.124 + -e 's|#AuthName|AuthName|' \ 6.125 + -e 's|#AuthType|AuthType|' \ 6.126 + -e 's|#AuthUserFile|AuthUserFile|' \ 6.127 + -e 's|@NAGIOS_PATH@.*|/etc/nagios/htpasswd.users|' \ 6.128 + -e 's| #Require|Require|' $fs/etc/nagvis/apache2-nagvis.conf 6.129 6.130 - # Fix perms 6.131 - chown -R www.www $fs/usr/share/nagvis $fs/var/lib/nagvis 6.132 - chown -R root.www $fs/etc/nagvis 6.133 + # Fix perms 6.134 + chown -R www.www $fs/usr/share/nagvis $fs/var/lib/nagvis 6.135 + chown -R root.www $fs/etc/nagvis 6.136 6.137 - chmod 664 $fs/etc/nagvis/nagvis.ini.php 6.138 - chmod 775 $fs/etc/nagvis/maps 6.139 - chmod 664 $fs/etc/nagvis/maps/* 6.140 - chmod 664 $fs/etc/nagvis/geomap/* 6.141 - chmod 664 $fs/etc/nagvis/automaps/* 6.142 - chmod 775 $fs/var/lib/nagvis 6.143 + chmod 664 $fs/etc/nagvis/nagvis.ini.php 6.144 + chmod 775 $fs/etc/nagvis/maps 6.145 + chmod 664 $fs/etc/nagvis/maps/* 6.146 + chmod 664 $fs/etc/nagvis/geomap/* 6.147 + chmod 664 $fs/etc/nagvis/automaps/* 6.148 + chmod 775 $fs/var/lib/nagvis 6.149 6.150 - # Cleanup 6.151 - rm -f $fs/usr/share/nagvis/install.* 6.152 - rm -f $fs/usr/share/nagvis/share/uifx 6.153 + # Cleanup 6.154 + rm -f $fs/usr/share/nagvis/install.* 6.155 + rm -f $fs/usr/share/nagvis/share/uifx 6.156 6.157 - mv $fs/usr/share/nagvis/share/userfiles/images/maps $fs/var/lib/nagvis 6.158 - chmod 775 $fs/var/lib/nagvis/maps 6.159 - chmod 664 $fs/var/lib/nagvis/maps/* 6.160 - ln -s /var/lib/nagvis/maps $fs/usr/share/nagvis/share/userfiles/images/ 6.161 - 6.162 + mv $fs/usr/share/nagvis/share/userfiles/images/maps $fs/var/lib/nagvis 6.163 + chmod 775 $fs/var/lib/nagvis/maps 6.164 + chmod 664 $fs/var/lib/nagvis/maps/* 6.165 + ln -s /var/lib/nagvis/maps $fs/usr/share/nagvis/share/userfiles/images/ 6.166 + ;; 6.167 + nagvis-doc) 6.168 + CAT="network|Nagvis documentation and licence" 6.169 + DEPENDS="nagvis" 6.170 + mkdir -p $fs/usr/share/doc/nagvis \ 6.171 + $fs/usr/share/nagvis 6.172 + 6.173 + # Copy doc and licence 6.174 + cp -a $src/INSTALL $fs/usr/share/doc/nagvis 6.175 + cp -a $src/LICENCE $fs/usr/share/doc/nagvis 6.176 + cp -a $src/README $fs/usr/share/doc/nagvis 6.177 + cp -a $src/ChangeLog $fs/usr/share/doc/nagvis 6.178 + cp -pa $src/docs $fs/usr/share/nagvis 6.179 + ;; 6.180 + nagvis-flex) 6.181 + CAT="network|Nagvis Flex" 6.182 + DEPENDS="nagvis" 6.183 + mkdir -p $fs/usr/share/nagvis 6.184 + 6.185 + # Copy doc and licence 6.186 + cp -a $src/uifx $fs/usr/share/nagvis 6.187 + ;; 6.188 + esac 6.189 } 6.190 6.191 -post_install() 6.192 +post_install_nagvis() 6.193 { 6.194 cat <<EOT 6.195 Now visit http://localhost/nagvis
7.1 --- a/ntop-dev/receipt Thu Nov 02 09:44:39 2017 +0100 7.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 7.3 @@ -1,18 +0,0 @@ 7.4 -# SliTaz package receipt. 7.5 - 7.6 -PACKAGE="ntop-dev" 7.7 -VERSION="4.1.0" 7.8 -CATEGORY="development" 7.9 -SHORT_DESC="Network traffic probe development files." 7.10 -MAINTAINER="pascal.bellard@slitaz.org" 7.11 -LICENSE="GPL3" 7.12 -WEB_SITE="http://www.ntop.org/" 7.13 -WANTED="ntop" 7.14 - 7.15 -# Rules to gen a SliTaz package suitable for Tazpkg. 7.16 -genpkg_rules() 7.17 -{ 7.18 - mkdir -p $fs/usr/lib 7.19 - cp -a $install/usr/lib/*.a $fs/usr/lib 7.20 -} 7.21 -
8.1 --- a/ntop-man/receipt Thu Nov 02 09:44:39 2017 +0100 8.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 8.3 @@ -1,18 +0,0 @@ 8.4 -# SliTaz package receipt. 8.5 - 8.6 -PACKAGE="ntop-man" 8.7 -VERSION="4.1.0" 8.8 -CATEGORY="development" 8.9 -SHORT_DESC="Network traffic probe man page." 8.10 -MAINTAINER="pascal.bellard@slitaz.org" 8.11 -LICENSE="GPL3" 8.12 -WEB_SITE="http://www.ntop.org/" 8.13 -WANTED="ntop" 8.14 - 8.15 -# Rules to gen a SliTaz package suitable for Tazpkg. 8.16 -genpkg_rules() 8.17 -{ 8.18 - mkdir -p $fs/usr/share 8.19 - cp -a $install/usr/share/man $fs/usr/share 8.20 -} 8.21 -
9.1 --- a/ntop/receipt Thu Nov 02 09:44:39 2017 +0100 9.2 +++ b/ntop/receipt Thu Nov 02 11:09:53 2017 +0100 9.3 @@ -1,4 +1,4 @@ 9.4 -# SliTaz package receipt. 9.5 +# SliTaz package receipt v2. 9.6 9.7 PACKAGE="ntop" 9.8 VERSION="4.1.0" 9.9 @@ -9,19 +9,16 @@ 9.10 TARBALL="$PACKAGE-$VERSION.tar.gz" 9.11 WEB_SITE="http://www.ntop.org/" 9.12 WGET_URL="$SF_MIRROR/$PACKAGE/$TARBALL" 9.13 -CONFIG_FILES="/etc/ntop" 9.14 TAGS="network" 9.15 9.16 -DEPENDS="zlib openssl libpng libpcap glibc gdbm rrdtool perl pcre geoip \ 9.17 -libwrap" 9.18 BUILD_DEPENDS="zlib-dev openssl-dev libpng-dev libpcap-dev libtool \ 9.19 glibc-dev gdbm-dev rrdtool autoconf automake rrdtool-dev wget geoip-dev \ 9.20 libwrap libtool" 9.21 +SPLIT="ntop ntop-dev ntop-man" 9.22 9.23 # Rules to configure and make the package. 9.24 compile_rules() 9.25 { 9.26 - cd $src 9.27 ./autogen.sh --prefix=/usr \ 9.28 --sysconfdir=/etc \ 9.29 --localstatedir=/var/lib \ 9.30 @@ -33,25 +30,42 @@ 9.31 # Rules to gen a SliTaz package suitable for Tazpkg. 9.32 genpkg_rules() 9.33 { 9.34 - mkdir -p $fs/usr/lib/plugins \ 9.35 - $fs/usr/share \ 9.36 - $fs/var/log/ntop 9.37 + case $PACKAGE in 9.38 + ntop) 9.39 + CONFIG_FILES="/etc/ntop" 9.40 + DEPENDS="zlib openssl libpng libpcap glibc gdbm rrdtool perl \ 9.41 + pcre geoip libwrap" 9.42 + mkdir -p $fs/usr/lib/plugins \ 9.43 + $fs/usr/share \ 9.44 + $fs/var/log/ntop 9.45 9.46 - cp -a $install/usr/lib/*.so* $fs/usr/lib 9.47 - cp -a $install/usr/lib/ntop $fs/usr/lib 9.48 - cp -a $install/usr/bin $fs/usr 9.49 - cp -a $install/usr/share/ntop $fs/usr/share 9.50 - chown -R www.www $fs/usr/share/ntop 9.51 - cp -a $install/usr/bin $fs 9.52 - cp -a $install/etc $fs 9.53 - cp -a $install/var $fs 9.54 + cp -a $install/usr/lib/*.so* $fs/usr/lib 9.55 + cp -a $install/usr/lib/ntop $fs/usr/lib 9.56 + cp -a $install/usr/bin $fs/usr 9.57 + cp -a $install/usr/share/ntop $fs/usr/share 9.58 + chown -R www.www $fs/usr/share/ntop 9.59 + cp -a $install/usr/bin $fs 9.60 + cp -a $install/etc $fs 9.61 + cp -a $install/var $fs 9.62 9.63 - # Copy startup script and fix perms 9.64 - cp -a stuff/etc $fs 9.65 - chown root.root $fs/etc/init.d/ntop 9.66 + # Copy startup script and fix perms 9.67 + cp -a stuff/etc $fs 9.68 + chown root.root $fs/etc/init.d/ntop 9.69 + ;; 9.70 + ntop-dev) 9.71 + CAT="development|Network traffic probe development files." 9.72 + mkdir -p $fs/usr/lib 9.73 + cp -a $install/usr/lib/*.a $fs/usr/lib 9.74 + ;; 9.75 + ntop-man) 9.76 + CAT="development|Network traffic probe man page." 9.77 + mkdir -p $fs/usr/share 9.78 + cp -a $install/usr/share/man $fs/usr/share 9.79 + ;; 9.80 + esac 9.81 } 9.82 9.83 -post_install() 9.84 +post_install_ntop() 9.85 { 9.86 user=ntop 9.87 group=ntop 9.88 @@ -75,12 +89,12 @@ 9.89 echo -e "Or add $PACKAGE to RUN_DAEMONS in /etc/rcS.conf\n" 9.90 } 9.91 9.92 -pre_remove() 9.93 +pre_remove_ntop() 9.94 { 9.95 [ "$1" ] || /etc/init.d/$PACKAGE stop 9.96 } 9.97 9.98 -post_remove() 9.99 +post_remove_ntop() 9.100 { 9.101 user=ntop 9.102 group=ntop
10.1 --- a/ocsinventory-server/receipt Thu Nov 02 09:44:39 2017 +0100 10.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 10.3 @@ -1,67 +0,0 @@ 10.4 -# SliTaz package receipt. 10.5 - 10.6 -PACKAGE="ocsinventory-server" 10.7 -VERSION="2.0.4" 10.8 -CATEGORY="network" 10.9 -SHORT_DESC="Iventory and package deployment system" 10.10 -MAINTAINER="pascal.bellard@slitaz.org" 10.11 -LICENSE="GPL2" 10.12 -SOURCE="OCSNG_UNIX_SERVER" 10.13 -WEB_SITE="http://www.ocsinventory-ng.org/index.php?page=English" 10.14 -WANTED="ocsinventory" 10.15 - 10.16 -DEPENDS="apache php-apache mysql perl perl-xml-simple perl-compress-raw-zlib 10.17 - perl-dbi perl-dbd-mysql perl-apache-dbi perl-net-ip perl-soap-lite 10.18 - perl-xml-parser perl-xml-sax-writer apache-mod-perl" 10.19 - 10.20 -# Rules to gen a SliTaz package suitable for Tazpkg. 10.21 -genpkg_rules() 10.22 -{ 10.23 - mkdir -p $fs/usr 10.24 - cp -a $install/usr/lib $fs/usr 10.25 - 10.26 - install -o www -g www -m 0775 -d $fs/var/log/ocsinventory-server 10.27 - install -o root -g www -m 0775 -d $fs/var/lib/ocsinventory-server/ipd 10.28 - install -o root -g www -m 0775 -d $fs/var/lib/ocsinventory-server/download 10.29 - 10.30 - mkdir -p $fs/etc/logrotate.d 10.31 - cp -f $src/etc/logrotate.d/ocsinventory-server \ 10.32 - $fs/etc/logrotate.d/ocsinventory-server 10.33 - sed -i "s#PATH_TO_LOG_DIRECTORY#/var/log/ocsinventory-server#g" \ 10.34 - $fs/etc/logrotate.d/ocsinventory-server 10.35 - 10.36 - mkdir -p $fs/etc/apache/conf.d 10.37 - cp $src/etc/ocsinventory/ocsinventory-server.conf \ 10.38 - $fs/etc/apache/conf.d/ocsinventory-server.conf 10.39 - sed -i -e "s#DATABASE_SERVER#localhost#g" \ 10.40 - -e "s#DATABASE_PORT#3306#g" \ 10.41 - -e "s#VERSION_MP#2#g" \ 10.42 - -e "s#PATH_TO_LOG_DIRECTORY#/var/log/ocsinventory-server#g" \ 10.43 - $fs/etc/apache/conf.d/ocsinventory-server.conf 10.44 - 10.45 - if ! grep -q mod_perl.so $fs/etc/apache/conf.d/ocsinventory-server.conf; 10.46 - then 10.47 - cat > $fs/etc/apache/conf.d/ocsinventory-server.tmp <<EOT 10.48 -<IfModule !mod_perl.c> 10.49 - loadmodule perl_module share/apache/modules/mod_perl.so 10.50 -</IfModule> 10.51 - 10.52 -$(cat $fs/etc/apache/conf.d/ocsinventory-server.conf) 10.53 -EOT 10.54 - mv $fs/etc/apache/conf.d/ocsinventory-server.tmp \ 10.55 - $fs/etc/apache/conf.d/ocsinventory-server 10.56 - [ -f $fs/etc/apache/conf.d/ocsinventory-server.conf ] && \ 10.57 - rm -f $fs/etc/apache/conf.d/ocsinventory-server.conf 10.58 - fi 10.59 -} 10.60 - 10.61 -post_install() 10.62 -{ 10.63 - if [ -z "$1" ]; then 10.64 - echo "Now you can connect to http://$(hostname)/ocsreports" 10.65 - # Restart Apache if is running 10.66 - [ -f /var/run/apache/httpd.pid ] && /etc/init.d/apache reload 10.67 - fi 10.68 -} 10.69 - 10.70 -
11.1 --- a/ocsinventory/receipt Thu Nov 02 09:44:39 2017 +0100 11.2 +++ b/ocsinventory/receipt Thu Nov 02 11:09:53 2017 +0100 11.3 @@ -1,7 +1,7 @@ 11.4 -# SliTaz package receipt. 11.5 +# SliTaz package receipt v2. 11.6 11.7 PACKAGE="ocsinventory" 11.8 -VERSION="2.0.4" 11.9 +VERSION="2.2" 11.10 CATEGORY="meta" 11.11 SHORT_DESC="Automated inventory and deployement system." 11.12 MAINTAINER="pascal.bellard@slitaz.org" 11.13 @@ -12,8 +12,8 @@ 11.14 WGET_URL="https://launchpad.net/ocsinventory-server/stable-${VERSION%.*}/$VERSION/+download/$TARBALL" 11.15 TAGS="system administration" 11.16 11.17 -DEPENDS="ocsinventory-server ocsinventory-agent ocsreports" 11.18 BUILD_DEPENDS="perl perl-dbd-mysql perl-apache-dbi perl-net-ip wget" 11.19 +SPLIT="ocsinventory ocsinventory-server ocsreports" 11.20 11.21 # Rules to configure and make the package. 11.22 compile_rules() 11.23 @@ -26,5 +26,162 @@ 11.24 11.25 genpkg_rules() 11.26 { 11.27 - mkdir $fs/usr 11.28 + case $PACKAGE in 11.29 + ocsinventory) 11.30 + DEPENDS="ocsinventory-server ocsinventory-agent ocsreports" 11.31 + mkdir $fs/usr 11.32 + ;; 11.33 + ocsinventory-server) 11.34 + CAT="network|Iventory and package deployment system" 11.35 + DEPENDS="apache php-apache mysql perl perl-xml-simple \ 11.36 + perl-compress-raw-zlib perl-dbi perl-dbd-mysql \ 11.37 + perl-apache-dbi perl-net-ip perl-soap-lite \ 11.38 + perl-xml-parser perl-xml-sax-writer apache-mod-perl" 11.39 + mkdir -p $fs/usr 11.40 + cp -a $install/usr/lib $fs/usr 11.41 + 11.42 + install -o www -g www -m 0775 -d $fs/var/log/ocsinventory-server 11.43 + install -o root -g www -m 0775 -d $fs/var/lib/ocsinventory-server/ipd 11.44 + install -o root -g www -m 0775 -d $fs/var/lib/ocsinventory-server/download 11.45 + 11.46 + mkdir -p $fs/etc/logrotate.d 11.47 + cp -f $src/etc/logrotate.d/ocsinventory-server \ 11.48 + $fs/etc/logrotate.d/ocsinventory-server 11.49 + sed -i "s#PATH_TO_LOG_DIRECTORY#/var/log/ocsinventory-server#g" \ 11.50 + $fs/etc/logrotate.d/ocsinventory-server 11.51 + 11.52 + mkdir -p $fs/etc/apache/conf.d 11.53 + cp $src/etc/ocsinventory/ocsinventory-server.conf \ 11.54 + $fs/etc/apache/conf.d/ocsinventory-server.conf 11.55 + sed -i -e "s#DATABASE_SERVER#localhost#g" \ 11.56 + -e "s#DATABASE_PORT#3306#g" \ 11.57 + -e "s#VERSION_MP#2#g" \ 11.58 + -e "s#PATH_TO_LOG_DIRECTORY#/var/log/ocsinventory-server#g" \ 11.59 + $fs/etc/apache/conf.d/ocsinventory-server.conf 11.60 + 11.61 + if ! grep -q mod_perl.so $fs/etc/apache/conf.d/ocsinventory-server.conf; 11.62 + then 11.63 + cat > $fs/etc/apache/conf.d/ocsinventory-server.tmp <<EOT 11.64 +<IfModule !mod_perl.c> 11.65 + loadmodule perl_module share/apache/modules/mod_perl.so 11.66 +</IfModule> 11.67 + 11.68 +$(cat $fs/etc/apache/conf.d/ocsinventory-server.conf) 11.69 +EOT 11.70 + mv $fs/etc/apache/conf.d/ocsinventory-server.tmp \ 11.71 + $fs/etc/apache/conf.d/ocsinventory-server 11.72 + [ -f $fs/etc/apache/conf.d/ocsinventory-server.conf ] && \ 11.73 + rm -f $fs/etc/apache/conf.d/ocsinventory-server.conf 11.74 + fi 11.75 + ;; 11.76 + ocsreports) 11.77 + CAT="network|Inventory and package deployement system" 11.78 + TAGS="system administration" 11.79 + DEPENDS="php-apache php-mysql mysql" 11.80 + mkdir -p $fs/usr/share \ 11.81 + $fs/etc/ocsreports 11.82 + 11.83 + cp -a $src/${PACKAGE} $fs/usr/share/ 11.84 + cat > $fs/etc/ocsreports/dbconfig.inc.php <<EOT 11.85 +<?php 11.86 +define("DB_NAME", "ocsweb"); 11.87 +define("SERVER_READ","localhost"); 11.88 +define("SERVER_WRITE","localhost"); 11.89 +define("COMPTE_BASE","ocs"); 11.90 +define("PSWD_BASE","ocs"); 11.91 +?> 11.92 +EOT 11.93 + 11.94 + install -o root -g www -m 0755 $src/binutils/*.pl \ 11.95 + $fs/usr/share/ocsreports/ 11.96 + 11.97 + rm -f $fs/usr/share/${PACKAGE}/dbconfig.inc.php 11.98 + cd $fs/usr/share/${PACKAGE} ; ln -s /etc/ocsreports/dbconfig.inc.php ; cd - 11.99 + 11.100 + # Remove doc file. 11.101 + rm -f $fs/usr/share/ocsreports/files/*.pdf 11.102 + ;; 11.103 + esac 11.104 } 11.105 + 11.106 +post_install_ocsinventory_server() 11.107 +{ 11.108 + if [ -z "$1" ]; then 11.109 + echo "Now you can connect to http://$(hostname)/ocsreports" 11.110 + # Restart Apache if is running 11.111 + [ -f /var/run/apache/httpd.pid ] && /etc/init.d/apache reload 11.112 + fi 11.113 +} 11.114 + 11.115 +post_install_ocsreports() 11.116 +{ 11.117 + # Configure apache server 11.118 + if [ -f "$1/etc/apache/httpd.conf" ]; then 11.119 + if [ ! -f "$1/etc/apache/conf.d/$PACKAGE" ]; then 11.120 + cat > "$1/etc/apache/conf.d/$PACKAGE" <<EOT 11.121 +<IfModule mod_alias.c> 11.122 + Alias /$PACKAGE /usr/share/$PACKAGE/ 11.123 +</IfModule> 11.124 +<Directory "/usr/share/$PACKAGE"> 11.125 + Options Indexes FollowSymLinks 11.126 + AllowOverride None 11.127 + Order deny,allow 11.128 + Allow from all 11.129 +</Directory> 11.130 + 11.131 +EOT 11.132 + if [ -z "$1" ]; then 11.133 + # Start Web server. 11.134 + test -f /var/run/apache/httpd.pid && \ 11.135 + ( kill -0 $(cat /var/run/apache/httpd.pid) && /etc/init.d/apache restart ) 11.136 + fi 11.137 + fi 11.138 + fi 11.139 + 11.140 + # Configure every thing for ocsweb. 11.141 + if [ -z "$1" ]; then 11.142 + if ( ! mysqladmin -s ping > /dev/null ); then 11.143 + echo "Starting MySQL server" 11.144 + ( /etc/init.d/mysql start ; status ) || exit 11.145 + sleep 4 #let the mysql daemon start 11.146 + fi 11.147 + if ( ! mysql -Be 'show databases' | grep -q ocsweb ); then 11.148 + echo -n "Create $PACKAGE database and schema" 11.149 + mysql -Be "create database ocsweb CHARACTER SET utf8 COLLATE utf8_bin" ; status 11.150 + mysql -s -u root ocsweb < /usr/share/$PACKAGE/files/ocsbase_new.sql > /dev/null 2>&1 11.151 + # We suppose that ocs user does not exist. 11.152 + # It may be false. 11.153 + echo -n "Create user ocs with password ocs" 11.154 + mysql -Be "grant all privileges on ocsweb.* to 'ocs'@'localhost' 11.155 + identified by 'ocs'" ; status 11.156 + fi 11.157 + 11.158 + fi 11.159 + true 11.160 +} 11.161 + 11.162 +post_remove_ocsreports() 11.163 +{ 11.164 + 11.165 + if [ -z "$1" ]; then 11.166 + echo -n "Would you like to remove data and database files.(y/n) " 11.167 + read answer 11.168 + 11.169 + case $answer in 11.170 + y|Y) 11.171 + echo -n "Removing data directories..." 11.172 + rm -rf /usr/share/ocsreports 11.173 + if ( mysql -Be 'show databases' | grep -q ocsweb ); then 11.174 + echo -n "Deleting ocsreports database;" 11.175 + mysql -u root -Be "drop database ocsweb;" ; status 11.176 + echo -n "Delete user ocs" 11.177 + mysql -u root -Be "delete from mysql.db where user=ocs;" ; status 11.178 + fi 11.179 + unset $answer 11.180 + ;; 11.181 + *) 11.182 + ;; 11.183 + esac 11.184 + fi 11.185 + 11.186 +}
12.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 12.2 +++ b/ocsinventory/stuff/dbconfig.inc.php Thu Nov 02 11:09:53 2017 +0100 12.3 @@ -0,0 +1,5 @@ 12.4 +<?php 12.5 +$_SESSION["SERVEUR_SQL"]="localhost"; 12.6 +$_SESSION["COMPTE_BASE"]="ocs"; 12.7 +$_SESSION["PSWD_BASE"]="ocs"; 12.8 +?> 12.9 \ No newline at end of file
13.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 13.2 +++ b/ocsinventory/stuff/ocsbase.sql Thu Nov 02 11:09:53 2017 +0100 13.3 @@ -0,0 +1,1086 @@ 13.4 +-- MySQL dump 10.11 13.5 +-- 13.6 +-- Host: localhost Database: ocsweb 13.7 +-- ------------------------------------------------------ 13.8 +-- Server version 5.0.51b-log 13.9 + 13.10 +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 13.11 +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 13.12 +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 13.13 +/*!40101 SET NAMES utf8 */; 13.14 +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 13.15 +/*!40103 SET TIME_ZONE='+00:00' */; 13.16 +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 13.17 +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 13.18 +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 13.19 +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 13.20 + 13.21 +-- 13.22 +-- Table structure for table `accesslog` 13.23 +-- 13.24 +USE ocsweb; 13.25 + 13.26 +DROP TABLE IF EXISTS `accesslog`; 13.27 +SET @saved_cs_client = @@character_set_client; 13.28 +SET character_set_client = utf8; 13.29 +CREATE TABLE `accesslog` ( 13.30 + `ID` int(11) NOT NULL auto_increment, 13.31 + `HARDWARE_ID` int(11) NOT NULL, 13.32 + `USERID` varchar(255) default NULL, 13.33 + `LOGDATE` datetime default NULL, 13.34 + `PROCESSES` text, 13.35 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.36 + KEY `ID` (`ID`) 13.37 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.38 +SET character_set_client = @saved_cs_client; 13.39 + 13.40 +-- 13.41 +-- Dumping data for table `accesslog` 13.42 +-- 13.43 + 13.44 +LOCK TABLES `accesslog` WRITE; 13.45 +/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */; 13.46 +/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */; 13.47 +UNLOCK TABLES; 13.48 + 13.49 +-- 13.50 +-- Table structure for table `accountinfo` 13.51 +-- 13.52 + 13.53 +DROP TABLE IF EXISTS `accountinfo`; 13.54 +SET @saved_cs_client = @@character_set_client; 13.55 +SET character_set_client = utf8; 13.56 +CREATE TABLE `accountinfo` ( 13.57 + `HARDWARE_ID` int(11) NOT NULL, 13.58 + `TAG` varchar(255) default 'NA', 13.59 + PRIMARY KEY (`HARDWARE_ID`), 13.60 + KEY `TAG` (`TAG`) 13.61 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.62 +SET character_set_client = @saved_cs_client; 13.63 + 13.64 +-- 13.65 +-- Dumping data for table `accountinfo` 13.66 +-- 13.67 + 13.68 +LOCK TABLES `accountinfo` WRITE; 13.69 +/*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */; 13.70 +/*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */; 13.71 +UNLOCK TABLES; 13.72 + 13.73 +-- 13.74 +-- Table structure for table `bios` 13.75 +-- 13.76 + 13.77 +DROP TABLE IF EXISTS `bios`; 13.78 +SET @saved_cs_client = @@character_set_client; 13.79 +SET character_set_client = utf8; 13.80 +CREATE TABLE `bios` ( 13.81 + `HARDWARE_ID` int(11) NOT NULL, 13.82 + `SMANUFACTURER` varchar(255) default NULL, 13.83 + `SMODEL` varchar(255) default NULL, 13.84 + `SSN` varchar(255) default NULL, 13.85 + `TYPE` varchar(255) default NULL, 13.86 + `BMANUFACTURER` varchar(255) default NULL, 13.87 + `BVERSION` varchar(255) default NULL, 13.88 + `BDATE` varchar(255) default NULL, 13.89 + PRIMARY KEY (`HARDWARE_ID`), 13.90 + KEY `SSN` (`SSN`) 13.91 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.92 +SET character_set_client = @saved_cs_client; 13.93 + 13.94 +-- 13.95 +-- Dumping data for table `bios` 13.96 +-- 13.97 + 13.98 +LOCK TABLES `bios` WRITE; 13.99 +/*!40000 ALTER TABLE `bios` DISABLE KEYS */; 13.100 +/*!40000 ALTER TABLE `bios` ENABLE KEYS */; 13.101 +UNLOCK TABLES; 13.102 + 13.103 +-- 13.104 +-- Table structure for table `config` 13.105 +-- 13.106 + 13.107 +DROP TABLE IF EXISTS `config`; 13.108 +SET @saved_cs_client = @@character_set_client; 13.109 +SET character_set_client = utf8; 13.110 +CREATE TABLE `config` ( 13.111 + `NAME` varchar(50) NOT NULL, 13.112 + `IVALUE` int(11) default NULL, 13.113 + `TVALUE` varchar(255) default NULL, 13.114 + `COMMENTS` text, 13.115 + PRIMARY KEY (`NAME`) 13.116 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.117 +SET character_set_client = @saved_cs_client; 13.118 + 13.119 +-- 13.120 +-- Dumping data for table `config` 13.121 +-- 13.122 + 13.123 +LOCK TABLES `config` WRITE; 13.124 +/*!40000 ALTER TABLE `config` DISABLE KEYS */; 13.125 +INSERT INTO `config` VALUES ('FREQUENCY',0,'','Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),('PROLOG_FREQ',24,'','Specify the frequency (hours) of prolog, on agents'),('IPDISCOVER',2,'','Max number of computers per gateway retrieving IP on the network'),('INVENTORY_DIFF',1,'','Activate/Deactivate inventory incremental writing'),('IPDISCOVER_LATENCY',100,'','Default latency between two arp requests'),('INVENTORY_TRANSACTION',1,'','Enable/disable db commit at each inventory section'),('REGISTRY',0,'','Activates or not the registry query function'),('IPDISCOVER_MAX_ALIVE',7,'','Max number of days before an Ip Discover computer is replaced'),('DEPLOY',1,'','Activates or not the automatic deployment option'),('UPDATE',0,'','Activates or not the update feature'),('GUI_VERSION',0,'4100','Version of the installed GUI and database'),('TRACE_DELETED',0,'','Trace deleted/duplicated computers (Activated by GLPI)'),('LOGLEVEL',0,'','ocs engine loglevel'),('AUTO_DUPLICATE_LVL',7,'','Duplicates bitmap'),('DOWNLOAD',0,'','Activate softwares auto deployment feature'),('DOWNLOAD_CYCLE_LATENCY',60,'','Time between two cycles (seconds)'),('DOWNLOAD_PERIOD_LENGTH',10,'','Number of cycles in a period'),('DOWNLOAD_FRAG_LATENCY',10,'','Time between two downloads (seconds)'),('DOWNLOAD_PERIOD_LATENCY',0,'','Time between two periods (seconds)'),('DOWNLOAD_TIMEOUT',30,'','Validity of a package (in days)'),('LOCAL_SERVER',0,'localhost','Server address used for local import'),('LOCAL_PORT',80,'','Server port used for local import'); 13.126 +/*!40000 ALTER TABLE `config` ENABLE KEYS */; 13.127 +UNLOCK TABLES; 13.128 + 13.129 +-- 13.130 +-- Table structure for table `conntrack` 13.131 +-- 13.132 + 13.133 +DROP TABLE IF EXISTS `conntrack`; 13.134 +SET @saved_cs_client = @@character_set_client; 13.135 +SET character_set_client = utf8; 13.136 +CREATE TABLE `conntrack` ( 13.137 + `IP` varchar(255) NOT NULL default '', 13.138 + `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 13.139 + PRIMARY KEY (`IP`) 13.140 +) ENGINE=MEMORY DEFAULT CHARSET=latin1; 13.141 +SET character_set_client = @saved_cs_client; 13.142 + 13.143 +-- 13.144 +-- Dumping data for table `conntrack` 13.145 +-- 13.146 + 13.147 +LOCK TABLES `conntrack` WRITE; 13.148 +/*!40000 ALTER TABLE `conntrack` DISABLE KEYS */; 13.149 +/*!40000 ALTER TABLE `conntrack` ENABLE KEYS */; 13.150 +UNLOCK TABLES; 13.151 + 13.152 +-- 13.153 +-- Table structure for table `controllers` 13.154 +-- 13.155 + 13.156 +DROP TABLE IF EXISTS `controllers`; 13.157 +SET @saved_cs_client = @@character_set_client; 13.158 +SET character_set_client = utf8; 13.159 +CREATE TABLE `controllers` ( 13.160 + `ID` int(11) NOT NULL auto_increment, 13.161 + `HARDWARE_ID` int(11) NOT NULL, 13.162 + `MANUFACTURER` varchar(255) default NULL, 13.163 + `NAME` varchar(255) default NULL, 13.164 + `CAPTION` varchar(255) default NULL, 13.165 + `DESCRIPTION` varchar(255) default NULL, 13.166 + `VERSION` varchar(255) default NULL, 13.167 + `TYPE` varchar(255) default NULL, 13.168 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.169 + KEY `ID` (`ID`) 13.170 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.171 +SET character_set_client = @saved_cs_client; 13.172 + 13.173 +-- 13.174 +-- Dumping data for table `controllers` 13.175 +-- 13.176 + 13.177 +LOCK TABLES `controllers` WRITE; 13.178 +/*!40000 ALTER TABLE `controllers` DISABLE KEYS */; 13.179 +/*!40000 ALTER TABLE `controllers` ENABLE KEYS */; 13.180 +UNLOCK TABLES; 13.181 + 13.182 +-- 13.183 +-- Table structure for table `deleted_equiv` 13.184 +-- 13.185 + 13.186 +DROP TABLE IF EXISTS `deleted_equiv`; 13.187 +SET @saved_cs_client = @@character_set_client; 13.188 +SET character_set_client = utf8; 13.189 +CREATE TABLE `deleted_equiv` ( 13.190 + `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 13.191 + `DELETED` varchar(255) NOT NULL, 13.192 + `EQUIVALENT` varchar(255) default NULL 13.193 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.194 +SET character_set_client = @saved_cs_client; 13.195 + 13.196 +-- 13.197 +-- Dumping data for table `deleted_equiv` 13.198 +-- 13.199 + 13.200 +LOCK TABLES `deleted_equiv` WRITE; 13.201 +/*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */; 13.202 +/*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */; 13.203 +UNLOCK TABLES; 13.204 + 13.205 +-- 13.206 +-- Table structure for table `deploy` 13.207 +-- 13.208 + 13.209 +DROP TABLE IF EXISTS `deploy`; 13.210 +SET @saved_cs_client = @@character_set_client; 13.211 +SET character_set_client = utf8; 13.212 +CREATE TABLE `deploy` ( 13.213 + `NAME` varchar(255) NOT NULL, 13.214 + `CONTENT` longblob NOT NULL, 13.215 + PRIMARY KEY (`NAME`) 13.216 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.217 +SET character_set_client = @saved_cs_client; 13.218 + 13.219 +-- 13.220 +-- Dumping data for table `deploy` 13.221 +-- 13.222 + 13.223 +LOCK TABLES `deploy` WRITE; 13.224 +/*!40000 ALTER TABLE `deploy` DISABLE KEYS */; 13.225 +/*!40000 ALTER TABLE `deploy` ENABLE KEYS */; 13.226 +UNLOCK TABLES; 13.227 + 13.228 +-- 13.229 +-- Table structure for table `devices` 13.230 +-- 13.231 + 13.232 +DROP TABLE IF EXISTS `devices`; 13.233 +SET @saved_cs_client = @@character_set_client; 13.234 +SET character_set_client = utf8; 13.235 +CREATE TABLE `devices` ( 13.236 + `HARDWARE_ID` int(11) NOT NULL, 13.237 + `NAME` varchar(50) NOT NULL, 13.238 + `IVALUE` int(11) default NULL, 13.239 + `TVALUE` varchar(255) default NULL, 13.240 + `COMMENTS` text, 13.241 + KEY `HARDWARE_ID` (`HARDWARE_ID`), 13.242 + KEY `TVALUE` (`TVALUE`) 13.243 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.244 +SET character_set_client = @saved_cs_client; 13.245 + 13.246 +-- 13.247 +-- Dumping data for table `devices` 13.248 +-- 13.249 + 13.250 +LOCK TABLES `devices` WRITE; 13.251 +/*!40000 ALTER TABLE `devices` DISABLE KEYS */; 13.252 +/*!40000 ALTER TABLE `devices` ENABLE KEYS */; 13.253 +UNLOCK TABLES; 13.254 + 13.255 +-- 13.256 +-- Table structure for table `devicetype` 13.257 +-- 13.258 + 13.259 +DROP TABLE IF EXISTS `devicetype`; 13.260 +SET @saved_cs_client = @@character_set_client; 13.261 +SET character_set_client = utf8; 13.262 +CREATE TABLE `devicetype` ( 13.263 + `ID` int(11) NOT NULL auto_increment, 13.264 + `NAME` varchar(255) default NULL, 13.265 + PRIMARY KEY (`ID`) 13.266 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.267 +SET character_set_client = @saved_cs_client; 13.268 + 13.269 +-- 13.270 +-- Dumping data for table `devicetype` 13.271 +-- 13.272 + 13.273 +LOCK TABLES `devicetype` WRITE; 13.274 +/*!40000 ALTER TABLE `devicetype` DISABLE KEYS */; 13.275 +/*!40000 ALTER TABLE `devicetype` ENABLE KEYS */; 13.276 +UNLOCK TABLES; 13.277 + 13.278 +-- 13.279 +-- Table structure for table `dico_cat` 13.280 +-- 13.281 + 13.282 +DROP TABLE IF EXISTS `dico_cat`; 13.283 +SET @saved_cs_client = @@character_set_client; 13.284 +SET character_set_client = utf8; 13.285 +CREATE TABLE `dico_cat` ( 13.286 + `NAME` varchar(255) NOT NULL, 13.287 + `PERMANENT` tinyint(4) default '0', 13.288 + PRIMARY KEY (`NAME`) 13.289 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.290 +SET character_set_client = @saved_cs_client; 13.291 + 13.292 +-- 13.293 +-- Dumping data for table `dico_cat` 13.294 +-- 13.295 + 13.296 +LOCK TABLES `dico_cat` WRITE; 13.297 +/*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */; 13.298 +/*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */; 13.299 +UNLOCK TABLES; 13.300 + 13.301 +-- 13.302 +-- Table structure for table `dico_ignored` 13.303 +-- 13.304 + 13.305 +DROP TABLE IF EXISTS `dico_ignored`; 13.306 +SET @saved_cs_client = @@character_set_client; 13.307 +SET character_set_client = utf8; 13.308 +CREATE TABLE `dico_ignored` ( 13.309 + `EXTRACTED` varchar(255) NOT NULL, 13.310 + PRIMARY KEY (`EXTRACTED`) 13.311 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.312 +SET character_set_client = @saved_cs_client; 13.313 + 13.314 +-- 13.315 +-- Dumping data for table `dico_ignored` 13.316 +-- 13.317 + 13.318 +LOCK TABLES `dico_ignored` WRITE; 13.319 +/*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */; 13.320 +/*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */; 13.321 +UNLOCK TABLES; 13.322 + 13.323 +-- 13.324 +-- Table structure for table `dico_soft` 13.325 +-- 13.326 + 13.327 +DROP TABLE IF EXISTS `dico_soft`; 13.328 +SET @saved_cs_client = @@character_set_client; 13.329 +SET character_set_client = utf8; 13.330 +CREATE TABLE `dico_soft` ( 13.331 + `EXTRACTED` varchar(255) NOT NULL, 13.332 + `FORMATTED` varchar(255) NOT NULL, 13.333 + PRIMARY KEY (`EXTRACTED`) 13.334 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.335 +SET character_set_client = @saved_cs_client; 13.336 + 13.337 +-- 13.338 +-- Dumping data for table `dico_soft` 13.339 +-- 13.340 + 13.341 +LOCK TABLES `dico_soft` WRITE; 13.342 +/*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */; 13.343 +/*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */; 13.344 +UNLOCK TABLES; 13.345 + 13.346 +-- 13.347 +-- Table structure for table `download_available` 13.348 +-- 13.349 + 13.350 +DROP TABLE IF EXISTS `download_available`; 13.351 +SET @saved_cs_client = @@character_set_client; 13.352 +SET character_set_client = utf8; 13.353 +CREATE TABLE `download_available` ( 13.354 + `FILEID` varchar(255) NOT NULL, 13.355 + `NAME` varchar(255) NOT NULL, 13.356 + `PRIORITY` int(11) NOT NULL, 13.357 + `FRAGMENTS` int(11) NOT NULL, 13.358 + `SIZE` int(11) NOT NULL, 13.359 + `OSNAME` varchar(255) NOT NULL, 13.360 + `COMMENT` text, 13.361 + PRIMARY KEY (`FILEID`) 13.362 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.363 +SET character_set_client = @saved_cs_client; 13.364 + 13.365 +-- 13.366 +-- Dumping data for table `download_available` 13.367 +-- 13.368 + 13.369 +LOCK TABLES `download_available` WRITE; 13.370 +/*!40000 ALTER TABLE `download_available` DISABLE KEYS */; 13.371 +/*!40000 ALTER TABLE `download_available` ENABLE KEYS */; 13.372 +UNLOCK TABLES; 13.373 + 13.374 +-- 13.375 +-- Table structure for table `download_enable` 13.376 +-- 13.377 + 13.378 +DROP TABLE IF EXISTS `download_enable`; 13.379 +SET @saved_cs_client = @@character_set_client; 13.380 +SET character_set_client = utf8; 13.381 +CREATE TABLE `download_enable` ( 13.382 + `ID` int(11) NOT NULL auto_increment, 13.383 + `FILEID` varchar(255) NOT NULL, 13.384 + `INFO_LOC` varchar(255) NOT NULL, 13.385 + `PACK_LOC` varchar(255) NOT NULL, 13.386 + `CERT_PATH` varchar(255) default NULL, 13.387 + `CERT_FILE` varchar(255) default NULL, 13.388 + PRIMARY KEY (`ID`) 13.389 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.390 +SET character_set_client = @saved_cs_client; 13.391 + 13.392 +-- 13.393 +-- Dumping data for table `download_enable` 13.394 +-- 13.395 + 13.396 +LOCK TABLES `download_enable` WRITE; 13.397 +/*!40000 ALTER TABLE `download_enable` DISABLE KEYS */; 13.398 +/*!40000 ALTER TABLE `download_enable` ENABLE KEYS */; 13.399 +UNLOCK TABLES; 13.400 + 13.401 +-- 13.402 +-- Table structure for table `download_history` 13.403 +-- 13.404 + 13.405 +DROP TABLE IF EXISTS `download_history`; 13.406 +SET @saved_cs_client = @@character_set_client; 13.407 +SET character_set_client = utf8; 13.408 +CREATE TABLE `download_history` ( 13.409 + `HARDWARE_ID` int(11) NOT NULL, 13.410 + `PKG_ID` int(11) NOT NULL default '0', 13.411 + `PKG_NAME` varchar(255) default NULL, 13.412 + PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`) 13.413 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.414 +SET character_set_client = @saved_cs_client; 13.415 + 13.416 +-- 13.417 +-- Dumping data for table `download_history` 13.418 +-- 13.419 + 13.420 +LOCK TABLES `download_history` WRITE; 13.421 +/*!40000 ALTER TABLE `download_history` DISABLE KEYS */; 13.422 +/*!40000 ALTER TABLE `download_history` ENABLE KEYS */; 13.423 +UNLOCK TABLES; 13.424 + 13.425 +-- 13.426 +-- Table structure for table `drives` 13.427 +-- 13.428 + 13.429 +DROP TABLE IF EXISTS `drives`; 13.430 +SET @saved_cs_client = @@character_set_client; 13.431 +SET character_set_client = utf8; 13.432 +CREATE TABLE `drives` ( 13.433 + `ID` int(11) NOT NULL auto_increment, 13.434 + `HARDWARE_ID` int(11) NOT NULL, 13.435 + `LETTER` varchar(255) default NULL, 13.436 + `TYPE` varchar(255) default NULL, 13.437 + `FILESYSTEM` varchar(255) default NULL, 13.438 + `TOTAL` int(11) default NULL, 13.439 + `FREE` int(11) default NULL, 13.440 + `NUMFILES` int(11) default NULL, 13.441 + `VOLUMN` varchar(255) default NULL, 13.442 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.443 + KEY `ID` (`ID`) 13.444 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.445 +SET character_set_client = @saved_cs_client; 13.446 + 13.447 +-- 13.448 +-- Dumping data for table `drives` 13.449 +-- 13.450 + 13.451 +LOCK TABLES `drives` WRITE; 13.452 +/*!40000 ALTER TABLE `drives` DISABLE KEYS */; 13.453 +/*!40000 ALTER TABLE `drives` ENABLE KEYS */; 13.454 +UNLOCK TABLES; 13.455 + 13.456 +-- 13.457 +-- Table structure for table `files` 13.458 +-- 13.459 + 13.460 +DROP TABLE IF EXISTS `files`; 13.461 +SET @saved_cs_client = @@character_set_client; 13.462 +SET character_set_client = utf8; 13.463 +CREATE TABLE `files` ( 13.464 + `NAME` varchar(255) NOT NULL, 13.465 + `VERSION` varchar(255) NOT NULL, 13.466 + `OS` varchar(255) NOT NULL, 13.467 + `CONTENT` longblob NOT NULL, 13.468 + PRIMARY KEY (`NAME`,`OS`,`VERSION`) 13.469 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.470 +SET character_set_client = @saved_cs_client; 13.471 + 13.472 +-- 13.473 +-- Dumping data for table `files` 13.474 +-- 13.475 + 13.476 +LOCK TABLES `files` WRITE; 13.477 +/*!40000 ALTER TABLE `files` DISABLE KEYS */; 13.478 +/*!40000 ALTER TABLE `files` ENABLE KEYS */; 13.479 +UNLOCK TABLES; 13.480 + 13.481 +-- 13.482 +-- Table structure for table `hardware` 13.483 +-- 13.484 + 13.485 +DROP TABLE IF EXISTS `hardware`; 13.486 +SET @saved_cs_client = @@character_set_client; 13.487 +SET character_set_client = utf8; 13.488 +CREATE TABLE `hardware` ( 13.489 + `ID` int(11) NOT NULL auto_increment, 13.490 + `DEVICEID` varchar(255) NOT NULL, 13.491 + `NAME` varchar(255) default NULL, 13.492 + `WORKGROUP` varchar(255) default NULL, 13.493 + `USERDOMAIN` varchar(255) default NULL, 13.494 + `OSNAME` varchar(255) default NULL, 13.495 + `OSVERSION` varchar(255) default NULL, 13.496 + `OSCOMMENTS` varchar(255) default NULL, 13.497 + `PROCESSORT` varchar(255) default NULL, 13.498 + `PROCESSORS` int(11) default '0', 13.499 + `PROCESSORN` smallint(6) default NULL, 13.500 + `MEMORY` int(11) default NULL, 13.501 + `SWAP` int(11) default NULL, 13.502 + `IPADDR` varchar(255) default NULL, 13.503 + `ETIME` datetime default NULL, 13.504 + `LASTDATE` datetime default NULL, 13.505 + `LASTCOME` datetime default NULL, 13.506 + `QUALITY` decimal(4,3) default '0.000', 13.507 + `FIDELITY` bigint(20) default '1', 13.508 + `USERID` varchar(255) default NULL, 13.509 + `TYPE` int(11) default NULL, 13.510 + `DESCRIPTION` varchar(255) default NULL, 13.511 + `WINCOMPANY` varchar(255) default NULL, 13.512 + `WINOWNER` varchar(255) default NULL, 13.513 + `WINPRODID` varchar(255) default NULL, 13.514 + `WINPRODKEY` varchar(255) default NULL, 13.515 + `USERAGENT` varchar(50) default NULL, 13.516 + `CHECKSUM` int(11) default '131071', 13.517 + PRIMARY KEY (`DEVICEID`,`ID`), 13.518 + KEY `NAME` (`NAME`), 13.519 + KEY `CHECKSUM` (`CHECKSUM`), 13.520 + KEY `DEVICEID` (`DEVICEID`), 13.521 + KEY `ID` (`ID`) 13.522 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.523 +SET character_set_client = @saved_cs_client; 13.524 + 13.525 +-- 13.526 +-- Dumping data for table `hardware` 13.527 +-- 13.528 + 13.529 +LOCK TABLES `hardware` WRITE; 13.530 +/*!40000 ALTER TABLE `hardware` DISABLE KEYS */; 13.531 +/*!40000 ALTER TABLE `hardware` ENABLE KEYS */; 13.532 +UNLOCK TABLES; 13.533 + 13.534 +-- 13.535 +-- Table structure for table `inputs` 13.536 +-- 13.537 + 13.538 +DROP TABLE IF EXISTS `inputs`; 13.539 +SET @saved_cs_client = @@character_set_client; 13.540 +SET character_set_client = utf8; 13.541 +CREATE TABLE `inputs` ( 13.542 + `ID` int(11) NOT NULL auto_increment, 13.543 + `HARDWARE_ID` int(11) NOT NULL, 13.544 + `TYPE` varchar(255) default NULL, 13.545 + `MANUFACTURER` varchar(255) default NULL, 13.546 + `CAPTION` varchar(255) default NULL, 13.547 + `DESCRIPTION` varchar(255) default NULL, 13.548 + `INTERFACE` varchar(255) default NULL, 13.549 + `POINTTYPE` varchar(255) default NULL, 13.550 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.551 + KEY `ID` (`ID`) 13.552 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.553 +SET character_set_client = @saved_cs_client; 13.554 + 13.555 +-- 13.556 +-- Dumping data for table `inputs` 13.557 +-- 13.558 + 13.559 +LOCK TABLES `inputs` WRITE; 13.560 +/*!40000 ALTER TABLE `inputs` DISABLE KEYS */; 13.561 +/*!40000 ALTER TABLE `inputs` ENABLE KEYS */; 13.562 +UNLOCK TABLES; 13.563 + 13.564 +-- 13.565 +-- Table structure for table `locks` 13.566 +-- 13.567 + 13.568 +DROP TABLE IF EXISTS `locks`; 13.569 +SET @saved_cs_client = @@character_set_client; 13.570 +SET character_set_client = utf8; 13.571 +CREATE TABLE `locks` ( 13.572 + `HARDWARE_ID` int(11) NOT NULL, 13.573 + `ID` int(11) default NULL, 13.574 + `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 13.575 + PRIMARY KEY (`HARDWARE_ID`), 13.576 + KEY `SINCE` (`SINCE`) 13.577 +) ENGINE=MEMORY DEFAULT CHARSET=latin1; 13.578 +SET character_set_client = @saved_cs_client; 13.579 + 13.580 +-- 13.581 +-- Dumping data for table `locks` 13.582 +-- 13.583 + 13.584 +LOCK TABLES `locks` WRITE; 13.585 +/*!40000 ALTER TABLE `locks` DISABLE KEYS */; 13.586 +/*!40000 ALTER TABLE `locks` ENABLE KEYS */; 13.587 +UNLOCK TABLES; 13.588 + 13.589 +-- 13.590 +-- Table structure for table `memories` 13.591 +-- 13.592 + 13.593 +DROP TABLE IF EXISTS `memories`; 13.594 +SET @saved_cs_client = @@character_set_client; 13.595 +SET character_set_client = utf8; 13.596 +CREATE TABLE `memories` ( 13.597 + `ID` int(11) NOT NULL auto_increment, 13.598 + `HARDWARE_ID` int(11) NOT NULL, 13.599 + `CAPTION` varchar(255) default NULL, 13.600 + `DESCRIPTION` varchar(255) default NULL, 13.601 + `CAPACITY` varchar(255) default NULL, 13.602 + `PURPOSE` varchar(255) default NULL, 13.603 + `TYPE` varchar(255) default NULL, 13.604 + `SPEED` varchar(255) default NULL, 13.605 + `NUMSLOTS` smallint(6) default NULL, 13.606 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.607 + KEY `ID` (`ID`) 13.608 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.609 +SET character_set_client = @saved_cs_client; 13.610 + 13.611 +-- 13.612 +-- Dumping data for table `memories` 13.613 +-- 13.614 + 13.615 +LOCK TABLES `memories` WRITE; 13.616 +/*!40000 ALTER TABLE `memories` DISABLE KEYS */; 13.617 +/*!40000 ALTER TABLE `memories` ENABLE KEYS */; 13.618 +UNLOCK TABLES; 13.619 + 13.620 +-- 13.621 +-- Table structure for table `modems` 13.622 +-- 13.623 + 13.624 +DROP TABLE IF EXISTS `modems`; 13.625 +SET @saved_cs_client = @@character_set_client; 13.626 +SET character_set_client = utf8; 13.627 +CREATE TABLE `modems` ( 13.628 + `ID` int(11) NOT NULL auto_increment, 13.629 + `HARDWARE_ID` int(11) NOT NULL, 13.630 + `NAME` varchar(255) default NULL, 13.631 + `MODEL` varchar(255) default NULL, 13.632 + `DESCRIPTION` varchar(255) default NULL, 13.633 + `TYPE` varchar(255) default NULL, 13.634 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.635 + KEY `ID` (`ID`) 13.636 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.637 +SET character_set_client = @saved_cs_client; 13.638 + 13.639 +-- 13.640 +-- Dumping data for table `modems` 13.641 +-- 13.642 + 13.643 +LOCK TABLES `modems` WRITE; 13.644 +/*!40000 ALTER TABLE `modems` DISABLE KEYS */; 13.645 +/*!40000 ALTER TABLE `modems` ENABLE KEYS */; 13.646 +UNLOCK TABLES; 13.647 + 13.648 +-- 13.649 +-- Table structure for table `monitors` 13.650 +-- 13.651 + 13.652 +DROP TABLE IF EXISTS `monitors`; 13.653 +SET @saved_cs_client = @@character_set_client; 13.654 +SET character_set_client = utf8; 13.655 +CREATE TABLE `monitors` ( 13.656 + `ID` int(11) NOT NULL auto_increment, 13.657 + `HARDWARE_ID` int(11) NOT NULL, 13.658 + `MANUFACTURER` varchar(255) default NULL, 13.659 + `CAPTION` varchar(255) default NULL, 13.660 + `DESCRIPTION` varchar(255) default NULL, 13.661 + `TYPE` varchar(255) default NULL, 13.662 + `SERIAL` varchar(255) default NULL, 13.663 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.664 + KEY `ID` (`ID`) 13.665 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.666 +SET character_set_client = @saved_cs_client; 13.667 + 13.668 +-- 13.669 +-- Dumping data for table `monitors` 13.670 +-- 13.671 + 13.672 +LOCK TABLES `monitors` WRITE; 13.673 +/*!40000 ALTER TABLE `monitors` DISABLE KEYS */; 13.674 +/*!40000 ALTER TABLE `monitors` ENABLE KEYS */; 13.675 +UNLOCK TABLES; 13.676 + 13.677 +-- 13.678 +-- Table structure for table `netmap` 13.679 +-- 13.680 + 13.681 +DROP TABLE IF EXISTS `netmap`; 13.682 +SET @saved_cs_client = @@character_set_client; 13.683 +SET character_set_client = utf8; 13.684 +CREATE TABLE `netmap` ( 13.685 + `IP` varchar(15) NOT NULL, 13.686 + `MAC` varchar(17) NOT NULL, 13.687 + `MASK` varchar(15) NOT NULL, 13.688 + `NETID` varchar(15) NOT NULL, 13.689 + `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP, 13.690 + `NAME` varchar(255) default NULL, 13.691 + PRIMARY KEY (`MAC`), 13.692 + KEY `IP` (`IP`), 13.693 + KEY `NETID` (`NETID`) 13.694 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.695 +SET character_set_client = @saved_cs_client; 13.696 + 13.697 +-- 13.698 +-- Dumping data for table `netmap` 13.699 +-- 13.700 + 13.701 +LOCK TABLES `netmap` WRITE; 13.702 +/*!40000 ALTER TABLE `netmap` DISABLE KEYS */; 13.703 +/*!40000 ALTER TABLE `netmap` ENABLE KEYS */; 13.704 +UNLOCK TABLES; 13.705 + 13.706 +-- 13.707 +-- Table structure for table `network_devices` 13.708 +-- 13.709 + 13.710 +DROP TABLE IF EXISTS `network_devices`; 13.711 +SET @saved_cs_client = @@character_set_client; 13.712 +SET character_set_client = utf8; 13.713 +CREATE TABLE `network_devices` ( 13.714 + `ID` int(11) NOT NULL auto_increment, 13.715 + `DESCRIPTION` varchar(255) default NULL, 13.716 + `TYPE` varchar(255) default NULL, 13.717 + `MACADDR` varchar(255) default NULL, 13.718 + `USER` varchar(255) default NULL, 13.719 + PRIMARY KEY (`ID`), 13.720 + KEY `MACADDR` (`MACADDR`) 13.721 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.722 +SET character_set_client = @saved_cs_client; 13.723 + 13.724 +-- 13.725 +-- Dumping data for table `network_devices` 13.726 +-- 13.727 + 13.728 +LOCK TABLES `network_devices` WRITE; 13.729 +/*!40000 ALTER TABLE `network_devices` DISABLE KEYS */; 13.730 +/*!40000 ALTER TABLE `network_devices` ENABLE KEYS */; 13.731 +UNLOCK TABLES; 13.732 + 13.733 +-- 13.734 +-- Table structure for table `networks` 13.735 +-- 13.736 + 13.737 +DROP TABLE IF EXISTS `networks`; 13.738 +SET @saved_cs_client = @@character_set_client; 13.739 +SET character_set_client = utf8; 13.740 +CREATE TABLE `networks` ( 13.741 + `ID` int(11) NOT NULL auto_increment, 13.742 + `HARDWARE_ID` int(11) NOT NULL, 13.743 + `DESCRIPTION` varchar(255) default NULL, 13.744 + `TYPE` varchar(255) default NULL, 13.745 + `TYPEMIB` varchar(255) default NULL, 13.746 + `SPEED` varchar(255) default NULL, 13.747 + `MACADDR` varchar(255) default NULL, 13.748 + `STATUS` varchar(255) default NULL, 13.749 + `IPADDRESS` varchar(255) default NULL, 13.750 + `IPMASK` varchar(255) default NULL, 13.751 + `IPGATEWAY` varchar(255) default NULL, 13.752 + `IPSUBNET` varchar(255) default NULL, 13.753 + `IPDHCP` varchar(255) default NULL, 13.754 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.755 + KEY `MACADDR` (`MACADDR`), 13.756 + KEY `IPSUBNET` (`IPSUBNET`), 13.757 + KEY `ID` (`ID`) 13.758 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.759 +SET character_set_client = @saved_cs_client; 13.760 + 13.761 +-- 13.762 +-- Dumping data for table `networks` 13.763 +-- 13.764 + 13.765 +LOCK TABLES `networks` WRITE; 13.766 +/*!40000 ALTER TABLE `networks` DISABLE KEYS */; 13.767 +/*!40000 ALTER TABLE `networks` ENABLE KEYS */; 13.768 +UNLOCK TABLES; 13.769 + 13.770 +-- 13.771 +-- Table structure for table `operators` 13.772 +-- 13.773 + 13.774 +DROP TABLE IF EXISTS `operators`; 13.775 +SET @saved_cs_client = @@character_set_client; 13.776 +SET character_set_client = utf8; 13.777 +CREATE TABLE `operators` ( 13.778 + `ID` varchar(255) NOT NULL default '', 13.779 + `FIRSTNAME` varchar(255) default NULL, 13.780 + `LASTNAME` varchar(255) default NULL, 13.781 + `PASSWD` varchar(50) default NULL, 13.782 + `ACCESSLVL` int(11) default NULL, 13.783 + `COMMENTS` text, 13.784 + PRIMARY KEY (`ID`) 13.785 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.786 +SET character_set_client = @saved_cs_client; 13.787 + 13.788 +-- 13.789 +-- Dumping data for table `operators` 13.790 +-- 13.791 + 13.792 +LOCK TABLES `operators` WRITE; 13.793 +/*!40000 ALTER TABLE `operators` DISABLE KEYS */; 13.794 +INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account'); 13.795 +/*!40000 ALTER TABLE `operators` ENABLE KEYS */; 13.796 +UNLOCK TABLES; 13.797 + 13.798 +-- 13.799 +-- Table structure for table `ports` 13.800 +-- 13.801 + 13.802 +DROP TABLE IF EXISTS `ports`; 13.803 +SET @saved_cs_client = @@character_set_client; 13.804 +SET character_set_client = utf8; 13.805 +CREATE TABLE `ports` ( 13.806 + `ID` int(11) NOT NULL auto_increment, 13.807 + `HARDWARE_ID` int(11) NOT NULL, 13.808 + `TYPE` varchar(255) default NULL, 13.809 + `NAME` varchar(255) default NULL, 13.810 + `CAPTION` varchar(255) default NULL, 13.811 + `DESCRIPTION` varchar(255) default NULL, 13.812 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.813 + KEY `ID` (`ID`) 13.814 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.815 +SET character_set_client = @saved_cs_client; 13.816 + 13.817 +-- 13.818 +-- Dumping data for table `ports` 13.819 +-- 13.820 + 13.821 +LOCK TABLES `ports` WRITE; 13.822 +/*!40000 ALTER TABLE `ports` DISABLE KEYS */; 13.823 +/*!40000 ALTER TABLE `ports` ENABLE KEYS */; 13.824 +UNLOCK TABLES; 13.825 + 13.826 +-- 13.827 +-- Table structure for table `printers` 13.828 +-- 13.829 + 13.830 +DROP TABLE IF EXISTS `printers`; 13.831 +SET @saved_cs_client = @@character_set_client; 13.832 +SET character_set_client = utf8; 13.833 +CREATE TABLE `printers` ( 13.834 + `ID` int(11) NOT NULL auto_increment, 13.835 + `HARDWARE_ID` int(11) NOT NULL, 13.836 + `NAME` varchar(255) default NULL, 13.837 + `DRIVER` varchar(255) default NULL, 13.838 + `PORT` varchar(255) default NULL, 13.839 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.840 + KEY `ID` (`ID`) 13.841 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.842 +SET character_set_client = @saved_cs_client; 13.843 + 13.844 +-- 13.845 +-- Dumping data for table `printers` 13.846 +-- 13.847 + 13.848 +LOCK TABLES `printers` WRITE; 13.849 +/*!40000 ALTER TABLE `printers` DISABLE KEYS */; 13.850 +/*!40000 ALTER TABLE `printers` ENABLE KEYS */; 13.851 +UNLOCK TABLES; 13.852 + 13.853 +-- 13.854 +-- Table structure for table `regconfig` 13.855 +-- 13.856 + 13.857 +DROP TABLE IF EXISTS `regconfig`; 13.858 +SET @saved_cs_client = @@character_set_client; 13.859 +SET character_set_client = utf8; 13.860 +CREATE TABLE `regconfig` ( 13.861 + `ID` int(11) NOT NULL auto_increment, 13.862 + `NAME` varchar(255) default NULL, 13.863 + `REGTREE` int(11) default NULL, 13.864 + `REGKEY` text, 13.865 + `REGVALUE` varchar(255) default NULL, 13.866 + PRIMARY KEY (`ID`), 13.867 + KEY `NAME` (`NAME`) 13.868 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.869 +SET character_set_client = @saved_cs_client; 13.870 + 13.871 +-- 13.872 +-- Dumping data for table `regconfig` 13.873 +-- 13.874 + 13.875 +LOCK TABLES `regconfig` WRITE; 13.876 +/*!40000 ALTER TABLE `regconfig` DISABLE KEYS */; 13.877 +/*!40000 ALTER TABLE `regconfig` ENABLE KEYS */; 13.878 +UNLOCK TABLES; 13.879 + 13.880 +-- 13.881 +-- Table structure for table `registry` 13.882 +-- 13.883 + 13.884 +DROP TABLE IF EXISTS `registry`; 13.885 +SET @saved_cs_client = @@character_set_client; 13.886 +SET character_set_client = utf8; 13.887 +CREATE TABLE `registry` ( 13.888 + `ID` int(11) NOT NULL auto_increment, 13.889 + `HARDWARE_ID` int(11) NOT NULL, 13.890 + `NAME` varchar(255) default NULL, 13.891 + `REGVALUE` varchar(255) default NULL, 13.892 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.893 + KEY `NAME` (`NAME`), 13.894 + KEY `ID` (`ID`) 13.895 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.896 +SET character_set_client = @saved_cs_client; 13.897 + 13.898 +-- 13.899 +-- Dumping data for table `registry` 13.900 +-- 13.901 + 13.902 +LOCK TABLES `registry` WRITE; 13.903 +/*!40000 ALTER TABLE `registry` DISABLE KEYS */; 13.904 +/*!40000 ALTER TABLE `registry` ENABLE KEYS */; 13.905 +UNLOCK TABLES; 13.906 + 13.907 +-- 13.908 +-- Table structure for table `slots` 13.909 +-- 13.910 + 13.911 +DROP TABLE IF EXISTS `slots`; 13.912 +SET @saved_cs_client = @@character_set_client; 13.913 +SET character_set_client = utf8; 13.914 +CREATE TABLE `slots` ( 13.915 + `ID` int(11) NOT NULL auto_increment, 13.916 + `HARDWARE_ID` int(11) NOT NULL, 13.917 + `NAME` varchar(255) default NULL, 13.918 + `DESCRIPTION` varchar(255) default NULL, 13.919 + `DESIGNATION` varchar(255) default NULL, 13.920 + `PURPOSE` varchar(255) default NULL, 13.921 + `STATUS` varchar(255) default NULL, 13.922 + `PSHARE` tinyint(4) default NULL, 13.923 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.924 + KEY `ID` (`ID`) 13.925 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.926 +SET character_set_client = @saved_cs_client; 13.927 + 13.928 +-- 13.929 +-- Dumping data for table `slots` 13.930 +-- 13.931 + 13.932 +LOCK TABLES `slots` WRITE; 13.933 +/*!40000 ALTER TABLE `slots` DISABLE KEYS */; 13.934 +/*!40000 ALTER TABLE `slots` ENABLE KEYS */; 13.935 +UNLOCK TABLES; 13.936 + 13.937 +-- 13.938 +-- Table structure for table `softwares` 13.939 +-- 13.940 + 13.941 +DROP TABLE IF EXISTS `softwares`; 13.942 +SET @saved_cs_client = @@character_set_client; 13.943 +SET character_set_client = utf8; 13.944 +CREATE TABLE `softwares` ( 13.945 + `ID` int(11) NOT NULL auto_increment, 13.946 + `HARDWARE_ID` int(11) NOT NULL, 13.947 + `PUBLISHER` varchar(255) default NULL, 13.948 + `NAME` varchar(255) default NULL, 13.949 + `VERSION` varchar(255) default NULL, 13.950 + `FOLDER` text, 13.951 + `COMMENTS` text, 13.952 + `FILENAME` varchar(255) default NULL, 13.953 + `FILESIZE` int(11) default '0', 13.954 + `SOURCE` int(11) default NULL, 13.955 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.956 + KEY `NAME` (`NAME`), 13.957 + KEY `ID` (`ID`) 13.958 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.959 +SET character_set_client = @saved_cs_client; 13.960 + 13.961 +-- 13.962 +-- Dumping data for table `softwares` 13.963 +-- 13.964 + 13.965 +LOCK TABLES `softwares` WRITE; 13.966 +/*!40000 ALTER TABLE `softwares` DISABLE KEYS */; 13.967 +/*!40000 ALTER TABLE `softwares` ENABLE KEYS */; 13.968 +UNLOCK TABLES; 13.969 + 13.970 +-- 13.971 +-- Table structure for table `sounds` 13.972 +-- 13.973 + 13.974 +DROP TABLE IF EXISTS `sounds`; 13.975 +SET @saved_cs_client = @@character_set_client; 13.976 +SET character_set_client = utf8; 13.977 +CREATE TABLE `sounds` ( 13.978 + `ID` int(11) NOT NULL auto_increment, 13.979 + `HARDWARE_ID` int(11) NOT NULL, 13.980 + `MANUFACTURER` varchar(255) default NULL, 13.981 + `NAME` varchar(255) default NULL, 13.982 + `DESCRIPTION` varchar(255) default NULL, 13.983 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.984 + KEY `ID` (`ID`) 13.985 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.986 +SET character_set_client = @saved_cs_client; 13.987 + 13.988 +-- 13.989 +-- Dumping data for table `sounds` 13.990 +-- 13.991 + 13.992 +LOCK TABLES `sounds` WRITE; 13.993 +/*!40000 ALTER TABLE `sounds` DISABLE KEYS */; 13.994 +/*!40000 ALTER TABLE `sounds` ENABLE KEYS */; 13.995 +UNLOCK TABLES; 13.996 + 13.997 +-- 13.998 +-- Table structure for table `storages` 13.999 +-- 13.1000 + 13.1001 +DROP TABLE IF EXISTS `storages`; 13.1002 +SET @saved_cs_client = @@character_set_client; 13.1003 +SET character_set_client = utf8; 13.1004 +CREATE TABLE `storages` ( 13.1005 + `ID` int(11) NOT NULL auto_increment, 13.1006 + `HARDWARE_ID` int(11) NOT NULL, 13.1007 + `MANUFACTURER` varchar(255) default NULL, 13.1008 + `NAME` varchar(255) default NULL, 13.1009 + `MODEL` varchar(255) default NULL, 13.1010 + `DESCRIPTION` varchar(255) default NULL, 13.1011 + `TYPE` varchar(255) default NULL, 13.1012 + `DISKSIZE` int(11) default NULL, 13.1013 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.1014 + KEY `ID` (`ID`) 13.1015 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.1016 +SET character_set_client = @saved_cs_client; 13.1017 + 13.1018 +-- 13.1019 +-- Dumping data for table `storages` 13.1020 +-- 13.1021 + 13.1022 +LOCK TABLES `storages` WRITE; 13.1023 +/*!40000 ALTER TABLE `storages` DISABLE KEYS */; 13.1024 +/*!40000 ALTER TABLE `storages` ENABLE KEYS */; 13.1025 +UNLOCK TABLES; 13.1026 + 13.1027 +-- 13.1028 +-- Table structure for table `subnet` 13.1029 +-- 13.1030 + 13.1031 +DROP TABLE IF EXISTS `subnet`; 13.1032 +SET @saved_cs_client = @@character_set_client; 13.1033 +SET character_set_client = utf8; 13.1034 +CREATE TABLE `subnet` ( 13.1035 + `NETID` varchar(15) NOT NULL, 13.1036 + `NAME` varchar(255) default NULL, 13.1037 + `ID` int(11) default NULL, 13.1038 + `MASK` varchar(255) default NULL, 13.1039 + PRIMARY KEY (`NETID`) 13.1040 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 13.1041 +SET character_set_client = @saved_cs_client; 13.1042 + 13.1043 +-- 13.1044 +-- Dumping data for table `subnet` 13.1045 +-- 13.1046 + 13.1047 +LOCK TABLES `subnet` WRITE; 13.1048 +/*!40000 ALTER TABLE `subnet` DISABLE KEYS */; 13.1049 +/*!40000 ALTER TABLE `subnet` ENABLE KEYS */; 13.1050 +UNLOCK TABLES; 13.1051 + 13.1052 +-- 13.1053 +-- Table structure for table `videos` 13.1054 +-- 13.1055 + 13.1056 +DROP TABLE IF EXISTS `videos`; 13.1057 +SET @saved_cs_client = @@character_set_client; 13.1058 +SET character_set_client = utf8; 13.1059 +CREATE TABLE `videos` ( 13.1060 + `ID` int(11) NOT NULL auto_increment, 13.1061 + `HARDWARE_ID` int(11) NOT NULL, 13.1062 + `NAME` varchar(255) default NULL, 13.1063 + `CHIPSET` varchar(255) default NULL, 13.1064 + `MEMORY` varchar(255) default NULL, 13.1065 + `RESOLUTION` varchar(255) default NULL, 13.1066 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 13.1067 + KEY `ID` (`ID`) 13.1068 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 13.1069 +SET character_set_client = @saved_cs_client; 13.1070 + 13.1071 +-- 13.1072 +-- Dumping data for table `videos` 13.1073 +-- 13.1074 + 13.1075 +LOCK TABLES `videos` WRITE; 13.1076 +/*!40000 ALTER TABLE `videos` DISABLE KEYS */; 13.1077 +/*!40000 ALTER TABLE `videos` ENABLE KEYS */; 13.1078 +UNLOCK TABLES; 13.1079 +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 13.1080 + 13.1081 +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 13.1082 +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 13.1083 +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 13.1084 +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 13.1085 +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 13.1086 +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 13.1087 +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 13.1088 + 13.1089 +-- Dump completed on 2009-04-25 0:01:16
14.1 --- a/ocsreports/receipt Thu Nov 02 09:44:39 2017 +0100 14.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 14.3 @@ -1,115 +0,0 @@ 14.4 -# SliTaz package receipt. 14.5 - 14.6 -PACKAGE="ocsreports" 14.7 -VERSION="2.0.4" 14.8 -CATEGORY="network" 14.9 -SHORT_DESC="Inventory and package deployement system" 14.10 -MAINTAINER="pascal.bellard@slitaz.org" 14.11 -LICENSE="GPL2" 14.12 -WANTED="ocsinventory" 14.13 -SOURCE="OCSNG_UNIX_SERVER" 14.14 -WEB_SITE="http://www.ocsinventory-ng.org/" 14.15 -TAGS="system administration" 14.16 - 14.17 -DEPENDS="php-apache php-mysql mysql" 14.18 - 14.19 -# Rules to gen a SliTaz package suitable for Tazpkg. 14.20 -genpkg_rules() 14.21 -{ 14.22 - mkdir -p $fs/usr/share \ 14.23 - $fs/etc/ocsreports 14.24 - 14.25 - cp -a $src/${PACKAGE} $fs/usr/share/ 14.26 - cat > $fs/etc/ocsreports/dbconfig.inc.php <<EOT 14.27 -<?php 14.28 -define("DB_NAME", "ocsweb"); 14.29 -define("SERVER_READ","localhost"); 14.30 -define("SERVER_WRITE","localhost"); 14.31 -define("COMPTE_BASE","ocs"); 14.32 -define("PSWD_BASE","ocs"); 14.33 -?> 14.34 -EOT 14.35 - 14.36 - install -o root -g www -m 0755 $src/binutils/*.pl \ 14.37 - $fs/usr/share/ocsreports/ 14.38 - 14.39 - rm -f $fs/usr/share/${PACKAGE}/dbconfig.inc.php 14.40 - cd $fs/usr/share/${PACKAGE} ; ln -s /etc/ocsreports/dbconfig.inc.php ; cd - 14.41 - 14.42 - # Remove doc file. 14.43 - rm -f $fs/usr/share/ocsreports/files/*.pdf 14.44 -} 14.45 - 14.46 -post_install() 14.47 -{ 14.48 - # Configure apache server 14.49 - if [ -f "$1/etc/apache/httpd.conf" ]; then 14.50 - if [ ! -f "$1/etc/apache/conf.d/$PACKAGE" ]; then 14.51 - cat > "$1/etc/apache/conf.d/$PACKAGE" <<EOT 14.52 -<IfModule mod_alias.c> 14.53 - Alias /$PACKAGE /usr/share/$PACKAGE/ 14.54 -</IfModule> 14.55 -<Directory "/usr/share/$PACKAGE"> 14.56 - Options Indexes FollowSymLinks 14.57 - AllowOverride None 14.58 - Order deny,allow 14.59 - Allow from all 14.60 -</Directory> 14.61 - 14.62 -EOT 14.63 - if [ -z "$1" ]; then 14.64 - # Start Web server. 14.65 - test -f /var/run/apache/httpd.pid && \ 14.66 - ( kill -0 $(cat /var/run/apache/httpd.pid) && /etc/init.d/apache restart ) 14.67 - fi 14.68 - fi 14.69 - fi 14.70 - 14.71 - # Configure every thing for ocsweb. 14.72 - if [ -z "$1" ]; then 14.73 - if ( ! mysqladmin -s ping > /dev/null ); then 14.74 - echo "Starting MySQL server" 14.75 - ( /etc/init.d/mysql start ; status ) || exit 14.76 - sleep 4 #let the mysql daemon start 14.77 - fi 14.78 - if ( ! mysql -Be 'show databases' | grep -q ocsweb ); then 14.79 - echo -n "Create $PACKAGE database and schema" 14.80 - mysql -Be "create database ocsweb CHARACTER SET utf8 COLLATE utf8_bin" ; status 14.81 - mysql -s -u root ocsweb < /usr/share/$PACKAGE/files/ocsbase_new.sql > /dev/null 2>&1 14.82 - # We suppose that ocs user does not exist. 14.83 - # It may be false. 14.84 - echo -n "Create user ocs with password ocs" 14.85 - mysql -Be "grant all privileges on ocsweb.* to 'ocs'@'localhost' 14.86 - identified by 'ocs'" ; status 14.87 - fi 14.88 - 14.89 - fi 14.90 - true 14.91 -} 14.92 - 14.93 -post_remove() 14.94 -{ 14.95 - 14.96 - if [ -z "$1" ]; then 14.97 - echo -n "Would you like to remove data and database files.(y/n) " 14.98 - read answer 14.99 - 14.100 - case $answer in 14.101 - y|Y) 14.102 - echo -n "Removing data directories..." 14.103 - rm -rf /usr/share/ocsreports 14.104 - if ( mysql -Be 'show databases' | grep -q ocsweb ); then 14.105 - echo -n "Deleting ocsreports database;" 14.106 - mysql -u root -Be "drop database ocsweb;" ; status 14.107 - echo -n "Delete user ocs" 14.108 - mysql -u root -Be "delete from mysql.db where user=ocs;" ; status 14.109 - fi 14.110 - unset $answer 14.111 - ;; 14.112 - *) 14.113 - ;; 14.114 - esac 14.115 - fi 14.116 - 14.117 -} 14.118 -
15.1 --- a/ocsreports/stuff/dbconfig.inc.php Thu Nov 02 09:44:39 2017 +0100 15.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 15.3 @@ -1,5 +0,0 @@ 15.4 -<?php 15.5 -$_SESSION["SERVEUR_SQL"]="localhost"; 15.6 -$_SESSION["COMPTE_BASE"]="ocs"; 15.7 -$_SESSION["PSWD_BASE"]="ocs"; 15.8 -?> 15.9 \ No newline at end of file
16.1 --- a/ocsreports/stuff/ocsbase.sql Thu Nov 02 09:44:39 2017 +0100 16.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 16.3 @@ -1,1086 +0,0 @@ 16.4 --- MySQL dump 10.11 16.5 --- 16.6 --- Host: localhost Database: ocsweb 16.7 --- ------------------------------------------------------ 16.8 --- Server version 5.0.51b-log 16.9 - 16.10 -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 16.11 -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16.12 -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 16.13 -/*!40101 SET NAMES utf8 */; 16.14 -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 16.15 -/*!40103 SET TIME_ZONE='+00:00' */; 16.16 -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 16.17 -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 16.18 -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 16.19 -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 16.20 - 16.21 --- 16.22 --- Table structure for table `accesslog` 16.23 --- 16.24 -USE ocsweb; 16.25 - 16.26 -DROP TABLE IF EXISTS `accesslog`; 16.27 -SET @saved_cs_client = @@character_set_client; 16.28 -SET character_set_client = utf8; 16.29 -CREATE TABLE `accesslog` ( 16.30 - `ID` int(11) NOT NULL auto_increment, 16.31 - `HARDWARE_ID` int(11) NOT NULL, 16.32 - `USERID` varchar(255) default NULL, 16.33 - `LOGDATE` datetime default NULL, 16.34 - `PROCESSES` text, 16.35 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.36 - KEY `ID` (`ID`) 16.37 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.38 -SET character_set_client = @saved_cs_client; 16.39 - 16.40 --- 16.41 --- Dumping data for table `accesslog` 16.42 --- 16.43 - 16.44 -LOCK TABLES `accesslog` WRITE; 16.45 -/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */; 16.46 -/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */; 16.47 -UNLOCK TABLES; 16.48 - 16.49 --- 16.50 --- Table structure for table `accountinfo` 16.51 --- 16.52 - 16.53 -DROP TABLE IF EXISTS `accountinfo`; 16.54 -SET @saved_cs_client = @@character_set_client; 16.55 -SET character_set_client = utf8; 16.56 -CREATE TABLE `accountinfo` ( 16.57 - `HARDWARE_ID` int(11) NOT NULL, 16.58 - `TAG` varchar(255) default 'NA', 16.59 - PRIMARY KEY (`HARDWARE_ID`), 16.60 - KEY `TAG` (`TAG`) 16.61 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.62 -SET character_set_client = @saved_cs_client; 16.63 - 16.64 --- 16.65 --- Dumping data for table `accountinfo` 16.66 --- 16.67 - 16.68 -LOCK TABLES `accountinfo` WRITE; 16.69 -/*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */; 16.70 -/*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */; 16.71 -UNLOCK TABLES; 16.72 - 16.73 --- 16.74 --- Table structure for table `bios` 16.75 --- 16.76 - 16.77 -DROP TABLE IF EXISTS `bios`; 16.78 -SET @saved_cs_client = @@character_set_client; 16.79 -SET character_set_client = utf8; 16.80 -CREATE TABLE `bios` ( 16.81 - `HARDWARE_ID` int(11) NOT NULL, 16.82 - `SMANUFACTURER` varchar(255) default NULL, 16.83 - `SMODEL` varchar(255) default NULL, 16.84 - `SSN` varchar(255) default NULL, 16.85 - `TYPE` varchar(255) default NULL, 16.86 - `BMANUFACTURER` varchar(255) default NULL, 16.87 - `BVERSION` varchar(255) default NULL, 16.88 - `BDATE` varchar(255) default NULL, 16.89 - PRIMARY KEY (`HARDWARE_ID`), 16.90 - KEY `SSN` (`SSN`) 16.91 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.92 -SET character_set_client = @saved_cs_client; 16.93 - 16.94 --- 16.95 --- Dumping data for table `bios` 16.96 --- 16.97 - 16.98 -LOCK TABLES `bios` WRITE; 16.99 -/*!40000 ALTER TABLE `bios` DISABLE KEYS */; 16.100 -/*!40000 ALTER TABLE `bios` ENABLE KEYS */; 16.101 -UNLOCK TABLES; 16.102 - 16.103 --- 16.104 --- Table structure for table `config` 16.105 --- 16.106 - 16.107 -DROP TABLE IF EXISTS `config`; 16.108 -SET @saved_cs_client = @@character_set_client; 16.109 -SET character_set_client = utf8; 16.110 -CREATE TABLE `config` ( 16.111 - `NAME` varchar(50) NOT NULL, 16.112 - `IVALUE` int(11) default NULL, 16.113 - `TVALUE` varchar(255) default NULL, 16.114 - `COMMENTS` text, 16.115 - PRIMARY KEY (`NAME`) 16.116 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.117 -SET character_set_client = @saved_cs_client; 16.118 - 16.119 --- 16.120 --- Dumping data for table `config` 16.121 --- 16.122 - 16.123 -LOCK TABLES `config` WRITE; 16.124 -/*!40000 ALTER TABLE `config` DISABLE KEYS */; 16.125 -INSERT INTO `config` VALUES ('FREQUENCY',0,'','Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),('PROLOG_FREQ',24,'','Specify the frequency (hours) of prolog, on agents'),('IPDISCOVER',2,'','Max number of computers per gateway retrieving IP on the network'),('INVENTORY_DIFF',1,'','Activate/Deactivate inventory incremental writing'),('IPDISCOVER_LATENCY',100,'','Default latency between two arp requests'),('INVENTORY_TRANSACTION',1,'','Enable/disable db commit at each inventory section'),('REGISTRY',0,'','Activates or not the registry query function'),('IPDISCOVER_MAX_ALIVE',7,'','Max number of days before an Ip Discover computer is replaced'),('DEPLOY',1,'','Activates or not the automatic deployment option'),('UPDATE',0,'','Activates or not the update feature'),('GUI_VERSION',0,'4100','Version of the installed GUI and database'),('TRACE_DELETED',0,'','Trace deleted/duplicated computers (Activated by GLPI)'),('LOGLEVEL',0,'','ocs engine loglevel'),('AUTO_DUPLICATE_LVL',7,'','Duplicates bitmap'),('DOWNLOAD',0,'','Activate softwares auto deployment feature'),('DOWNLOAD_CYCLE_LATENCY',60,'','Time between two cycles (seconds)'),('DOWNLOAD_PERIOD_LENGTH',10,'','Number of cycles in a period'),('DOWNLOAD_FRAG_LATENCY',10,'','Time between two downloads (seconds)'),('DOWNLOAD_PERIOD_LATENCY',0,'','Time between two periods (seconds)'),('DOWNLOAD_TIMEOUT',30,'','Validity of a package (in days)'),('LOCAL_SERVER',0,'localhost','Server address used for local import'),('LOCAL_PORT',80,'','Server port used for local import'); 16.126 -/*!40000 ALTER TABLE `config` ENABLE KEYS */; 16.127 -UNLOCK TABLES; 16.128 - 16.129 --- 16.130 --- Table structure for table `conntrack` 16.131 --- 16.132 - 16.133 -DROP TABLE IF EXISTS `conntrack`; 16.134 -SET @saved_cs_client = @@character_set_client; 16.135 -SET character_set_client = utf8; 16.136 -CREATE TABLE `conntrack` ( 16.137 - `IP` varchar(255) NOT NULL default '', 16.138 - `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 16.139 - PRIMARY KEY (`IP`) 16.140 -) ENGINE=MEMORY DEFAULT CHARSET=latin1; 16.141 -SET character_set_client = @saved_cs_client; 16.142 - 16.143 --- 16.144 --- Dumping data for table `conntrack` 16.145 --- 16.146 - 16.147 -LOCK TABLES `conntrack` WRITE; 16.148 -/*!40000 ALTER TABLE `conntrack` DISABLE KEYS */; 16.149 -/*!40000 ALTER TABLE `conntrack` ENABLE KEYS */; 16.150 -UNLOCK TABLES; 16.151 - 16.152 --- 16.153 --- Table structure for table `controllers` 16.154 --- 16.155 - 16.156 -DROP TABLE IF EXISTS `controllers`; 16.157 -SET @saved_cs_client = @@character_set_client; 16.158 -SET character_set_client = utf8; 16.159 -CREATE TABLE `controllers` ( 16.160 - `ID` int(11) NOT NULL auto_increment, 16.161 - `HARDWARE_ID` int(11) NOT NULL, 16.162 - `MANUFACTURER` varchar(255) default NULL, 16.163 - `NAME` varchar(255) default NULL, 16.164 - `CAPTION` varchar(255) default NULL, 16.165 - `DESCRIPTION` varchar(255) default NULL, 16.166 - `VERSION` varchar(255) default NULL, 16.167 - `TYPE` varchar(255) default NULL, 16.168 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.169 - KEY `ID` (`ID`) 16.170 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.171 -SET character_set_client = @saved_cs_client; 16.172 - 16.173 --- 16.174 --- Dumping data for table `controllers` 16.175 --- 16.176 - 16.177 -LOCK TABLES `controllers` WRITE; 16.178 -/*!40000 ALTER TABLE `controllers` DISABLE KEYS */; 16.179 -/*!40000 ALTER TABLE `controllers` ENABLE KEYS */; 16.180 -UNLOCK TABLES; 16.181 - 16.182 --- 16.183 --- Table structure for table `deleted_equiv` 16.184 --- 16.185 - 16.186 -DROP TABLE IF EXISTS `deleted_equiv`; 16.187 -SET @saved_cs_client = @@character_set_client; 16.188 -SET character_set_client = utf8; 16.189 -CREATE TABLE `deleted_equiv` ( 16.190 - `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 16.191 - `DELETED` varchar(255) NOT NULL, 16.192 - `EQUIVALENT` varchar(255) default NULL 16.193 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.194 -SET character_set_client = @saved_cs_client; 16.195 - 16.196 --- 16.197 --- Dumping data for table `deleted_equiv` 16.198 --- 16.199 - 16.200 -LOCK TABLES `deleted_equiv` WRITE; 16.201 -/*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */; 16.202 -/*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */; 16.203 -UNLOCK TABLES; 16.204 - 16.205 --- 16.206 --- Table structure for table `deploy` 16.207 --- 16.208 - 16.209 -DROP TABLE IF EXISTS `deploy`; 16.210 -SET @saved_cs_client = @@character_set_client; 16.211 -SET character_set_client = utf8; 16.212 -CREATE TABLE `deploy` ( 16.213 - `NAME` varchar(255) NOT NULL, 16.214 - `CONTENT` longblob NOT NULL, 16.215 - PRIMARY KEY (`NAME`) 16.216 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.217 -SET character_set_client = @saved_cs_client; 16.218 - 16.219 --- 16.220 --- Dumping data for table `deploy` 16.221 --- 16.222 - 16.223 -LOCK TABLES `deploy` WRITE; 16.224 -/*!40000 ALTER TABLE `deploy` DISABLE KEYS */; 16.225 -/*!40000 ALTER TABLE `deploy` ENABLE KEYS */; 16.226 -UNLOCK TABLES; 16.227 - 16.228 --- 16.229 --- Table structure for table `devices` 16.230 --- 16.231 - 16.232 -DROP TABLE IF EXISTS `devices`; 16.233 -SET @saved_cs_client = @@character_set_client; 16.234 -SET character_set_client = utf8; 16.235 -CREATE TABLE `devices` ( 16.236 - `HARDWARE_ID` int(11) NOT NULL, 16.237 - `NAME` varchar(50) NOT NULL, 16.238 - `IVALUE` int(11) default NULL, 16.239 - `TVALUE` varchar(255) default NULL, 16.240 - `COMMENTS` text, 16.241 - KEY `HARDWARE_ID` (`HARDWARE_ID`), 16.242 - KEY `TVALUE` (`TVALUE`) 16.243 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.244 -SET character_set_client = @saved_cs_client; 16.245 - 16.246 --- 16.247 --- Dumping data for table `devices` 16.248 --- 16.249 - 16.250 -LOCK TABLES `devices` WRITE; 16.251 -/*!40000 ALTER TABLE `devices` DISABLE KEYS */; 16.252 -/*!40000 ALTER TABLE `devices` ENABLE KEYS */; 16.253 -UNLOCK TABLES; 16.254 - 16.255 --- 16.256 --- Table structure for table `devicetype` 16.257 --- 16.258 - 16.259 -DROP TABLE IF EXISTS `devicetype`; 16.260 -SET @saved_cs_client = @@character_set_client; 16.261 -SET character_set_client = utf8; 16.262 -CREATE TABLE `devicetype` ( 16.263 - `ID` int(11) NOT NULL auto_increment, 16.264 - `NAME` varchar(255) default NULL, 16.265 - PRIMARY KEY (`ID`) 16.266 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.267 -SET character_set_client = @saved_cs_client; 16.268 - 16.269 --- 16.270 --- Dumping data for table `devicetype` 16.271 --- 16.272 - 16.273 -LOCK TABLES `devicetype` WRITE; 16.274 -/*!40000 ALTER TABLE `devicetype` DISABLE KEYS */; 16.275 -/*!40000 ALTER TABLE `devicetype` ENABLE KEYS */; 16.276 -UNLOCK TABLES; 16.277 - 16.278 --- 16.279 --- Table structure for table `dico_cat` 16.280 --- 16.281 - 16.282 -DROP TABLE IF EXISTS `dico_cat`; 16.283 -SET @saved_cs_client = @@character_set_client; 16.284 -SET character_set_client = utf8; 16.285 -CREATE TABLE `dico_cat` ( 16.286 - `NAME` varchar(255) NOT NULL, 16.287 - `PERMANENT` tinyint(4) default '0', 16.288 - PRIMARY KEY (`NAME`) 16.289 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.290 -SET character_set_client = @saved_cs_client; 16.291 - 16.292 --- 16.293 --- Dumping data for table `dico_cat` 16.294 --- 16.295 - 16.296 -LOCK TABLES `dico_cat` WRITE; 16.297 -/*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */; 16.298 -/*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */; 16.299 -UNLOCK TABLES; 16.300 - 16.301 --- 16.302 --- Table structure for table `dico_ignored` 16.303 --- 16.304 - 16.305 -DROP TABLE IF EXISTS `dico_ignored`; 16.306 -SET @saved_cs_client = @@character_set_client; 16.307 -SET character_set_client = utf8; 16.308 -CREATE TABLE `dico_ignored` ( 16.309 - `EXTRACTED` varchar(255) NOT NULL, 16.310 - PRIMARY KEY (`EXTRACTED`) 16.311 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.312 -SET character_set_client = @saved_cs_client; 16.313 - 16.314 --- 16.315 --- Dumping data for table `dico_ignored` 16.316 --- 16.317 - 16.318 -LOCK TABLES `dico_ignored` WRITE; 16.319 -/*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */; 16.320 -/*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */; 16.321 -UNLOCK TABLES; 16.322 - 16.323 --- 16.324 --- Table structure for table `dico_soft` 16.325 --- 16.326 - 16.327 -DROP TABLE IF EXISTS `dico_soft`; 16.328 -SET @saved_cs_client = @@character_set_client; 16.329 -SET character_set_client = utf8; 16.330 -CREATE TABLE `dico_soft` ( 16.331 - `EXTRACTED` varchar(255) NOT NULL, 16.332 - `FORMATTED` varchar(255) NOT NULL, 16.333 - PRIMARY KEY (`EXTRACTED`) 16.334 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.335 -SET character_set_client = @saved_cs_client; 16.336 - 16.337 --- 16.338 --- Dumping data for table `dico_soft` 16.339 --- 16.340 - 16.341 -LOCK TABLES `dico_soft` WRITE; 16.342 -/*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */; 16.343 -/*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */; 16.344 -UNLOCK TABLES; 16.345 - 16.346 --- 16.347 --- Table structure for table `download_available` 16.348 --- 16.349 - 16.350 -DROP TABLE IF EXISTS `download_available`; 16.351 -SET @saved_cs_client = @@character_set_client; 16.352 -SET character_set_client = utf8; 16.353 -CREATE TABLE `download_available` ( 16.354 - `FILEID` varchar(255) NOT NULL, 16.355 - `NAME` varchar(255) NOT NULL, 16.356 - `PRIORITY` int(11) NOT NULL, 16.357 - `FRAGMENTS` int(11) NOT NULL, 16.358 - `SIZE` int(11) NOT NULL, 16.359 - `OSNAME` varchar(255) NOT NULL, 16.360 - `COMMENT` text, 16.361 - PRIMARY KEY (`FILEID`) 16.362 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.363 -SET character_set_client = @saved_cs_client; 16.364 - 16.365 --- 16.366 --- Dumping data for table `download_available` 16.367 --- 16.368 - 16.369 -LOCK TABLES `download_available` WRITE; 16.370 -/*!40000 ALTER TABLE `download_available` DISABLE KEYS */; 16.371 -/*!40000 ALTER TABLE `download_available` ENABLE KEYS */; 16.372 -UNLOCK TABLES; 16.373 - 16.374 --- 16.375 --- Table structure for table `download_enable` 16.376 --- 16.377 - 16.378 -DROP TABLE IF EXISTS `download_enable`; 16.379 -SET @saved_cs_client = @@character_set_client; 16.380 -SET character_set_client = utf8; 16.381 -CREATE TABLE `download_enable` ( 16.382 - `ID` int(11) NOT NULL auto_increment, 16.383 - `FILEID` varchar(255) NOT NULL, 16.384 - `INFO_LOC` varchar(255) NOT NULL, 16.385 - `PACK_LOC` varchar(255) NOT NULL, 16.386 - `CERT_PATH` varchar(255) default NULL, 16.387 - `CERT_FILE` varchar(255) default NULL, 16.388 - PRIMARY KEY (`ID`) 16.389 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.390 -SET character_set_client = @saved_cs_client; 16.391 - 16.392 --- 16.393 --- Dumping data for table `download_enable` 16.394 --- 16.395 - 16.396 -LOCK TABLES `download_enable` WRITE; 16.397 -/*!40000 ALTER TABLE `download_enable` DISABLE KEYS */; 16.398 -/*!40000 ALTER TABLE `download_enable` ENABLE KEYS */; 16.399 -UNLOCK TABLES; 16.400 - 16.401 --- 16.402 --- Table structure for table `download_history` 16.403 --- 16.404 - 16.405 -DROP TABLE IF EXISTS `download_history`; 16.406 -SET @saved_cs_client = @@character_set_client; 16.407 -SET character_set_client = utf8; 16.408 -CREATE TABLE `download_history` ( 16.409 - `HARDWARE_ID` int(11) NOT NULL, 16.410 - `PKG_ID` int(11) NOT NULL default '0', 16.411 - `PKG_NAME` varchar(255) default NULL, 16.412 - PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`) 16.413 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.414 -SET character_set_client = @saved_cs_client; 16.415 - 16.416 --- 16.417 --- Dumping data for table `download_history` 16.418 --- 16.419 - 16.420 -LOCK TABLES `download_history` WRITE; 16.421 -/*!40000 ALTER TABLE `download_history` DISABLE KEYS */; 16.422 -/*!40000 ALTER TABLE `download_history` ENABLE KEYS */; 16.423 -UNLOCK TABLES; 16.424 - 16.425 --- 16.426 --- Table structure for table `drives` 16.427 --- 16.428 - 16.429 -DROP TABLE IF EXISTS `drives`; 16.430 -SET @saved_cs_client = @@character_set_client; 16.431 -SET character_set_client = utf8; 16.432 -CREATE TABLE `drives` ( 16.433 - `ID` int(11) NOT NULL auto_increment, 16.434 - `HARDWARE_ID` int(11) NOT NULL, 16.435 - `LETTER` varchar(255) default NULL, 16.436 - `TYPE` varchar(255) default NULL, 16.437 - `FILESYSTEM` varchar(255) default NULL, 16.438 - `TOTAL` int(11) default NULL, 16.439 - `FREE` int(11) default NULL, 16.440 - `NUMFILES` int(11) default NULL, 16.441 - `VOLUMN` varchar(255) default NULL, 16.442 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.443 - KEY `ID` (`ID`) 16.444 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.445 -SET character_set_client = @saved_cs_client; 16.446 - 16.447 --- 16.448 --- Dumping data for table `drives` 16.449 --- 16.450 - 16.451 -LOCK TABLES `drives` WRITE; 16.452 -/*!40000 ALTER TABLE `drives` DISABLE KEYS */; 16.453 -/*!40000 ALTER TABLE `drives` ENABLE KEYS */; 16.454 -UNLOCK TABLES; 16.455 - 16.456 --- 16.457 --- Table structure for table `files` 16.458 --- 16.459 - 16.460 -DROP TABLE IF EXISTS `files`; 16.461 -SET @saved_cs_client = @@character_set_client; 16.462 -SET character_set_client = utf8; 16.463 -CREATE TABLE `files` ( 16.464 - `NAME` varchar(255) NOT NULL, 16.465 - `VERSION` varchar(255) NOT NULL, 16.466 - `OS` varchar(255) NOT NULL, 16.467 - `CONTENT` longblob NOT NULL, 16.468 - PRIMARY KEY (`NAME`,`OS`,`VERSION`) 16.469 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.470 -SET character_set_client = @saved_cs_client; 16.471 - 16.472 --- 16.473 --- Dumping data for table `files` 16.474 --- 16.475 - 16.476 -LOCK TABLES `files` WRITE; 16.477 -/*!40000 ALTER TABLE `files` DISABLE KEYS */; 16.478 -/*!40000 ALTER TABLE `files` ENABLE KEYS */; 16.479 -UNLOCK TABLES; 16.480 - 16.481 --- 16.482 --- Table structure for table `hardware` 16.483 --- 16.484 - 16.485 -DROP TABLE IF EXISTS `hardware`; 16.486 -SET @saved_cs_client = @@character_set_client; 16.487 -SET character_set_client = utf8; 16.488 -CREATE TABLE `hardware` ( 16.489 - `ID` int(11) NOT NULL auto_increment, 16.490 - `DEVICEID` varchar(255) NOT NULL, 16.491 - `NAME` varchar(255) default NULL, 16.492 - `WORKGROUP` varchar(255) default NULL, 16.493 - `USERDOMAIN` varchar(255) default NULL, 16.494 - `OSNAME` varchar(255) default NULL, 16.495 - `OSVERSION` varchar(255) default NULL, 16.496 - `OSCOMMENTS` varchar(255) default NULL, 16.497 - `PROCESSORT` varchar(255) default NULL, 16.498 - `PROCESSORS` int(11) default '0', 16.499 - `PROCESSORN` smallint(6) default NULL, 16.500 - `MEMORY` int(11) default NULL, 16.501 - `SWAP` int(11) default NULL, 16.502 - `IPADDR` varchar(255) default NULL, 16.503 - `ETIME` datetime default NULL, 16.504 - `LASTDATE` datetime default NULL, 16.505 - `LASTCOME` datetime default NULL, 16.506 - `QUALITY` decimal(4,3) default '0.000', 16.507 - `FIDELITY` bigint(20) default '1', 16.508 - `USERID` varchar(255) default NULL, 16.509 - `TYPE` int(11) default NULL, 16.510 - `DESCRIPTION` varchar(255) default NULL, 16.511 - `WINCOMPANY` varchar(255) default NULL, 16.512 - `WINOWNER` varchar(255) default NULL, 16.513 - `WINPRODID` varchar(255) default NULL, 16.514 - `WINPRODKEY` varchar(255) default NULL, 16.515 - `USERAGENT` varchar(50) default NULL, 16.516 - `CHECKSUM` int(11) default '131071', 16.517 - PRIMARY KEY (`DEVICEID`,`ID`), 16.518 - KEY `NAME` (`NAME`), 16.519 - KEY `CHECKSUM` (`CHECKSUM`), 16.520 - KEY `DEVICEID` (`DEVICEID`), 16.521 - KEY `ID` (`ID`) 16.522 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.523 -SET character_set_client = @saved_cs_client; 16.524 - 16.525 --- 16.526 --- Dumping data for table `hardware` 16.527 --- 16.528 - 16.529 -LOCK TABLES `hardware` WRITE; 16.530 -/*!40000 ALTER TABLE `hardware` DISABLE KEYS */; 16.531 -/*!40000 ALTER TABLE `hardware` ENABLE KEYS */; 16.532 -UNLOCK TABLES; 16.533 - 16.534 --- 16.535 --- Table structure for table `inputs` 16.536 --- 16.537 - 16.538 -DROP TABLE IF EXISTS `inputs`; 16.539 -SET @saved_cs_client = @@character_set_client; 16.540 -SET character_set_client = utf8; 16.541 -CREATE TABLE `inputs` ( 16.542 - `ID` int(11) NOT NULL auto_increment, 16.543 - `HARDWARE_ID` int(11) NOT NULL, 16.544 - `TYPE` varchar(255) default NULL, 16.545 - `MANUFACTURER` varchar(255) default NULL, 16.546 - `CAPTION` varchar(255) default NULL, 16.547 - `DESCRIPTION` varchar(255) default NULL, 16.548 - `INTERFACE` varchar(255) default NULL, 16.549 - `POINTTYPE` varchar(255) default NULL, 16.550 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.551 - KEY `ID` (`ID`) 16.552 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.553 -SET character_set_client = @saved_cs_client; 16.554 - 16.555 --- 16.556 --- Dumping data for table `inputs` 16.557 --- 16.558 - 16.559 -LOCK TABLES `inputs` WRITE; 16.560 -/*!40000 ALTER TABLE `inputs` DISABLE KEYS */; 16.561 -/*!40000 ALTER TABLE `inputs` ENABLE KEYS */; 16.562 -UNLOCK TABLES; 16.563 - 16.564 --- 16.565 --- Table structure for table `locks` 16.566 --- 16.567 - 16.568 -DROP TABLE IF EXISTS `locks`; 16.569 -SET @saved_cs_client = @@character_set_client; 16.570 -SET character_set_client = utf8; 16.571 -CREATE TABLE `locks` ( 16.572 - `HARDWARE_ID` int(11) NOT NULL, 16.573 - `ID` int(11) default NULL, 16.574 - `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 16.575 - PRIMARY KEY (`HARDWARE_ID`), 16.576 - KEY `SINCE` (`SINCE`) 16.577 -) ENGINE=MEMORY DEFAULT CHARSET=latin1; 16.578 -SET character_set_client = @saved_cs_client; 16.579 - 16.580 --- 16.581 --- Dumping data for table `locks` 16.582 --- 16.583 - 16.584 -LOCK TABLES `locks` WRITE; 16.585 -/*!40000 ALTER TABLE `locks` DISABLE KEYS */; 16.586 -/*!40000 ALTER TABLE `locks` ENABLE KEYS */; 16.587 -UNLOCK TABLES; 16.588 - 16.589 --- 16.590 --- Table structure for table `memories` 16.591 --- 16.592 - 16.593 -DROP TABLE IF EXISTS `memories`; 16.594 -SET @saved_cs_client = @@character_set_client; 16.595 -SET character_set_client = utf8; 16.596 -CREATE TABLE `memories` ( 16.597 - `ID` int(11) NOT NULL auto_increment, 16.598 - `HARDWARE_ID` int(11) NOT NULL, 16.599 - `CAPTION` varchar(255) default NULL, 16.600 - `DESCRIPTION` varchar(255) default NULL, 16.601 - `CAPACITY` varchar(255) default NULL, 16.602 - `PURPOSE` varchar(255) default NULL, 16.603 - `TYPE` varchar(255) default NULL, 16.604 - `SPEED` varchar(255) default NULL, 16.605 - `NUMSLOTS` smallint(6) default NULL, 16.606 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.607 - KEY `ID` (`ID`) 16.608 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.609 -SET character_set_client = @saved_cs_client; 16.610 - 16.611 --- 16.612 --- Dumping data for table `memories` 16.613 --- 16.614 - 16.615 -LOCK TABLES `memories` WRITE; 16.616 -/*!40000 ALTER TABLE `memories` DISABLE KEYS */; 16.617 -/*!40000 ALTER TABLE `memories` ENABLE KEYS */; 16.618 -UNLOCK TABLES; 16.619 - 16.620 --- 16.621 --- Table structure for table `modems` 16.622 --- 16.623 - 16.624 -DROP TABLE IF EXISTS `modems`; 16.625 -SET @saved_cs_client = @@character_set_client; 16.626 -SET character_set_client = utf8; 16.627 -CREATE TABLE `modems` ( 16.628 - `ID` int(11) NOT NULL auto_increment, 16.629 - `HARDWARE_ID` int(11) NOT NULL, 16.630 - `NAME` varchar(255) default NULL, 16.631 - `MODEL` varchar(255) default NULL, 16.632 - `DESCRIPTION` varchar(255) default NULL, 16.633 - `TYPE` varchar(255) default NULL, 16.634 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.635 - KEY `ID` (`ID`) 16.636 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.637 -SET character_set_client = @saved_cs_client; 16.638 - 16.639 --- 16.640 --- Dumping data for table `modems` 16.641 --- 16.642 - 16.643 -LOCK TABLES `modems` WRITE; 16.644 -/*!40000 ALTER TABLE `modems` DISABLE KEYS */; 16.645 -/*!40000 ALTER TABLE `modems` ENABLE KEYS */; 16.646 -UNLOCK TABLES; 16.647 - 16.648 --- 16.649 --- Table structure for table `monitors` 16.650 --- 16.651 - 16.652 -DROP TABLE IF EXISTS `monitors`; 16.653 -SET @saved_cs_client = @@character_set_client; 16.654 -SET character_set_client = utf8; 16.655 -CREATE TABLE `monitors` ( 16.656 - `ID` int(11) NOT NULL auto_increment, 16.657 - `HARDWARE_ID` int(11) NOT NULL, 16.658 - `MANUFACTURER` varchar(255) default NULL, 16.659 - `CAPTION` varchar(255) default NULL, 16.660 - `DESCRIPTION` varchar(255) default NULL, 16.661 - `TYPE` varchar(255) default NULL, 16.662 - `SERIAL` varchar(255) default NULL, 16.663 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.664 - KEY `ID` (`ID`) 16.665 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.666 -SET character_set_client = @saved_cs_client; 16.667 - 16.668 --- 16.669 --- Dumping data for table `monitors` 16.670 --- 16.671 - 16.672 -LOCK TABLES `monitors` WRITE; 16.673 -/*!40000 ALTER TABLE `monitors` DISABLE KEYS */; 16.674 -/*!40000 ALTER TABLE `monitors` ENABLE KEYS */; 16.675 -UNLOCK TABLES; 16.676 - 16.677 --- 16.678 --- Table structure for table `netmap` 16.679 --- 16.680 - 16.681 -DROP TABLE IF EXISTS `netmap`; 16.682 -SET @saved_cs_client = @@character_set_client; 16.683 -SET character_set_client = utf8; 16.684 -CREATE TABLE `netmap` ( 16.685 - `IP` varchar(15) NOT NULL, 16.686 - `MAC` varchar(17) NOT NULL, 16.687 - `MASK` varchar(15) NOT NULL, 16.688 - `NETID` varchar(15) NOT NULL, 16.689 - `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP, 16.690 - `NAME` varchar(255) default NULL, 16.691 - PRIMARY KEY (`MAC`), 16.692 - KEY `IP` (`IP`), 16.693 - KEY `NETID` (`NETID`) 16.694 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.695 -SET character_set_client = @saved_cs_client; 16.696 - 16.697 --- 16.698 --- Dumping data for table `netmap` 16.699 --- 16.700 - 16.701 -LOCK TABLES `netmap` WRITE; 16.702 -/*!40000 ALTER TABLE `netmap` DISABLE KEYS */; 16.703 -/*!40000 ALTER TABLE `netmap` ENABLE KEYS */; 16.704 -UNLOCK TABLES; 16.705 - 16.706 --- 16.707 --- Table structure for table `network_devices` 16.708 --- 16.709 - 16.710 -DROP TABLE IF EXISTS `network_devices`; 16.711 -SET @saved_cs_client = @@character_set_client; 16.712 -SET character_set_client = utf8; 16.713 -CREATE TABLE `network_devices` ( 16.714 - `ID` int(11) NOT NULL auto_increment, 16.715 - `DESCRIPTION` varchar(255) default NULL, 16.716 - `TYPE` varchar(255) default NULL, 16.717 - `MACADDR` varchar(255) default NULL, 16.718 - `USER` varchar(255) default NULL, 16.719 - PRIMARY KEY (`ID`), 16.720 - KEY `MACADDR` (`MACADDR`) 16.721 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.722 -SET character_set_client = @saved_cs_client; 16.723 - 16.724 --- 16.725 --- Dumping data for table `network_devices` 16.726 --- 16.727 - 16.728 -LOCK TABLES `network_devices` WRITE; 16.729 -/*!40000 ALTER TABLE `network_devices` DISABLE KEYS */; 16.730 -/*!40000 ALTER TABLE `network_devices` ENABLE KEYS */; 16.731 -UNLOCK TABLES; 16.732 - 16.733 --- 16.734 --- Table structure for table `networks` 16.735 --- 16.736 - 16.737 -DROP TABLE IF EXISTS `networks`; 16.738 -SET @saved_cs_client = @@character_set_client; 16.739 -SET character_set_client = utf8; 16.740 -CREATE TABLE `networks` ( 16.741 - `ID` int(11) NOT NULL auto_increment, 16.742 - `HARDWARE_ID` int(11) NOT NULL, 16.743 - `DESCRIPTION` varchar(255) default NULL, 16.744 - `TYPE` varchar(255) default NULL, 16.745 - `TYPEMIB` varchar(255) default NULL, 16.746 - `SPEED` varchar(255) default NULL, 16.747 - `MACADDR` varchar(255) default NULL, 16.748 - `STATUS` varchar(255) default NULL, 16.749 - `IPADDRESS` varchar(255) default NULL, 16.750 - `IPMASK` varchar(255) default NULL, 16.751 - `IPGATEWAY` varchar(255) default NULL, 16.752 - `IPSUBNET` varchar(255) default NULL, 16.753 - `IPDHCP` varchar(255) default NULL, 16.754 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.755 - KEY `MACADDR` (`MACADDR`), 16.756 - KEY `IPSUBNET` (`IPSUBNET`), 16.757 - KEY `ID` (`ID`) 16.758 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.759 -SET character_set_client = @saved_cs_client; 16.760 - 16.761 --- 16.762 --- Dumping data for table `networks` 16.763 --- 16.764 - 16.765 -LOCK TABLES `networks` WRITE; 16.766 -/*!40000 ALTER TABLE `networks` DISABLE KEYS */; 16.767 -/*!40000 ALTER TABLE `networks` ENABLE KEYS */; 16.768 -UNLOCK TABLES; 16.769 - 16.770 --- 16.771 --- Table structure for table `operators` 16.772 --- 16.773 - 16.774 -DROP TABLE IF EXISTS `operators`; 16.775 -SET @saved_cs_client = @@character_set_client; 16.776 -SET character_set_client = utf8; 16.777 -CREATE TABLE `operators` ( 16.778 - `ID` varchar(255) NOT NULL default '', 16.779 - `FIRSTNAME` varchar(255) default NULL, 16.780 - `LASTNAME` varchar(255) default NULL, 16.781 - `PASSWD` varchar(50) default NULL, 16.782 - `ACCESSLVL` int(11) default NULL, 16.783 - `COMMENTS` text, 16.784 - PRIMARY KEY (`ID`) 16.785 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.786 -SET character_set_client = @saved_cs_client; 16.787 - 16.788 --- 16.789 --- Dumping data for table `operators` 16.790 --- 16.791 - 16.792 -LOCK TABLES `operators` WRITE; 16.793 -/*!40000 ALTER TABLE `operators` DISABLE KEYS */; 16.794 -INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account'); 16.795 -/*!40000 ALTER TABLE `operators` ENABLE KEYS */; 16.796 -UNLOCK TABLES; 16.797 - 16.798 --- 16.799 --- Table structure for table `ports` 16.800 --- 16.801 - 16.802 -DROP TABLE IF EXISTS `ports`; 16.803 -SET @saved_cs_client = @@character_set_client; 16.804 -SET character_set_client = utf8; 16.805 -CREATE TABLE `ports` ( 16.806 - `ID` int(11) NOT NULL auto_increment, 16.807 - `HARDWARE_ID` int(11) NOT NULL, 16.808 - `TYPE` varchar(255) default NULL, 16.809 - `NAME` varchar(255) default NULL, 16.810 - `CAPTION` varchar(255) default NULL, 16.811 - `DESCRIPTION` varchar(255) default NULL, 16.812 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.813 - KEY `ID` (`ID`) 16.814 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.815 -SET character_set_client = @saved_cs_client; 16.816 - 16.817 --- 16.818 --- Dumping data for table `ports` 16.819 --- 16.820 - 16.821 -LOCK TABLES `ports` WRITE; 16.822 -/*!40000 ALTER TABLE `ports` DISABLE KEYS */; 16.823 -/*!40000 ALTER TABLE `ports` ENABLE KEYS */; 16.824 -UNLOCK TABLES; 16.825 - 16.826 --- 16.827 --- Table structure for table `printers` 16.828 --- 16.829 - 16.830 -DROP TABLE IF EXISTS `printers`; 16.831 -SET @saved_cs_client = @@character_set_client; 16.832 -SET character_set_client = utf8; 16.833 -CREATE TABLE `printers` ( 16.834 - `ID` int(11) NOT NULL auto_increment, 16.835 - `HARDWARE_ID` int(11) NOT NULL, 16.836 - `NAME` varchar(255) default NULL, 16.837 - `DRIVER` varchar(255) default NULL, 16.838 - `PORT` varchar(255) default NULL, 16.839 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.840 - KEY `ID` (`ID`) 16.841 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.842 -SET character_set_client = @saved_cs_client; 16.843 - 16.844 --- 16.845 --- Dumping data for table `printers` 16.846 --- 16.847 - 16.848 -LOCK TABLES `printers` WRITE; 16.849 -/*!40000 ALTER TABLE `printers` DISABLE KEYS */; 16.850 -/*!40000 ALTER TABLE `printers` ENABLE KEYS */; 16.851 -UNLOCK TABLES; 16.852 - 16.853 --- 16.854 --- Table structure for table `regconfig` 16.855 --- 16.856 - 16.857 -DROP TABLE IF EXISTS `regconfig`; 16.858 -SET @saved_cs_client = @@character_set_client; 16.859 -SET character_set_client = utf8; 16.860 -CREATE TABLE `regconfig` ( 16.861 - `ID` int(11) NOT NULL auto_increment, 16.862 - `NAME` varchar(255) default NULL, 16.863 - `REGTREE` int(11) default NULL, 16.864 - `REGKEY` text, 16.865 - `REGVALUE` varchar(255) default NULL, 16.866 - PRIMARY KEY (`ID`), 16.867 - KEY `NAME` (`NAME`) 16.868 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.869 -SET character_set_client = @saved_cs_client; 16.870 - 16.871 --- 16.872 --- Dumping data for table `regconfig` 16.873 --- 16.874 - 16.875 -LOCK TABLES `regconfig` WRITE; 16.876 -/*!40000 ALTER TABLE `regconfig` DISABLE KEYS */; 16.877 -/*!40000 ALTER TABLE `regconfig` ENABLE KEYS */; 16.878 -UNLOCK TABLES; 16.879 - 16.880 --- 16.881 --- Table structure for table `registry` 16.882 --- 16.883 - 16.884 -DROP TABLE IF EXISTS `registry`; 16.885 -SET @saved_cs_client = @@character_set_client; 16.886 -SET character_set_client = utf8; 16.887 -CREATE TABLE `registry` ( 16.888 - `ID` int(11) NOT NULL auto_increment, 16.889 - `HARDWARE_ID` int(11) NOT NULL, 16.890 - `NAME` varchar(255) default NULL, 16.891 - `REGVALUE` varchar(255) default NULL, 16.892 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.893 - KEY `NAME` (`NAME`), 16.894 - KEY `ID` (`ID`) 16.895 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.896 -SET character_set_client = @saved_cs_client; 16.897 - 16.898 --- 16.899 --- Dumping data for table `registry` 16.900 --- 16.901 - 16.902 -LOCK TABLES `registry` WRITE; 16.903 -/*!40000 ALTER TABLE `registry` DISABLE KEYS */; 16.904 -/*!40000 ALTER TABLE `registry` ENABLE KEYS */; 16.905 -UNLOCK TABLES; 16.906 - 16.907 --- 16.908 --- Table structure for table `slots` 16.909 --- 16.910 - 16.911 -DROP TABLE IF EXISTS `slots`; 16.912 -SET @saved_cs_client = @@character_set_client; 16.913 -SET character_set_client = utf8; 16.914 -CREATE TABLE `slots` ( 16.915 - `ID` int(11) NOT NULL auto_increment, 16.916 - `HARDWARE_ID` int(11) NOT NULL, 16.917 - `NAME` varchar(255) default NULL, 16.918 - `DESCRIPTION` varchar(255) default NULL, 16.919 - `DESIGNATION` varchar(255) default NULL, 16.920 - `PURPOSE` varchar(255) default NULL, 16.921 - `STATUS` varchar(255) default NULL, 16.922 - `PSHARE` tinyint(4) default NULL, 16.923 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.924 - KEY `ID` (`ID`) 16.925 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.926 -SET character_set_client = @saved_cs_client; 16.927 - 16.928 --- 16.929 --- Dumping data for table `slots` 16.930 --- 16.931 - 16.932 -LOCK TABLES `slots` WRITE; 16.933 -/*!40000 ALTER TABLE `slots` DISABLE KEYS */; 16.934 -/*!40000 ALTER TABLE `slots` ENABLE KEYS */; 16.935 -UNLOCK TABLES; 16.936 - 16.937 --- 16.938 --- Table structure for table `softwares` 16.939 --- 16.940 - 16.941 -DROP TABLE IF EXISTS `softwares`; 16.942 -SET @saved_cs_client = @@character_set_client; 16.943 -SET character_set_client = utf8; 16.944 -CREATE TABLE `softwares` ( 16.945 - `ID` int(11) NOT NULL auto_increment, 16.946 - `HARDWARE_ID` int(11) NOT NULL, 16.947 - `PUBLISHER` varchar(255) default NULL, 16.948 - `NAME` varchar(255) default NULL, 16.949 - `VERSION` varchar(255) default NULL, 16.950 - `FOLDER` text, 16.951 - `COMMENTS` text, 16.952 - `FILENAME` varchar(255) default NULL, 16.953 - `FILESIZE` int(11) default '0', 16.954 - `SOURCE` int(11) default NULL, 16.955 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.956 - KEY `NAME` (`NAME`), 16.957 - KEY `ID` (`ID`) 16.958 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.959 -SET character_set_client = @saved_cs_client; 16.960 - 16.961 --- 16.962 --- Dumping data for table `softwares` 16.963 --- 16.964 - 16.965 -LOCK TABLES `softwares` WRITE; 16.966 -/*!40000 ALTER TABLE `softwares` DISABLE KEYS */; 16.967 -/*!40000 ALTER TABLE `softwares` ENABLE KEYS */; 16.968 -UNLOCK TABLES; 16.969 - 16.970 --- 16.971 --- Table structure for table `sounds` 16.972 --- 16.973 - 16.974 -DROP TABLE IF EXISTS `sounds`; 16.975 -SET @saved_cs_client = @@character_set_client; 16.976 -SET character_set_client = utf8; 16.977 -CREATE TABLE `sounds` ( 16.978 - `ID` int(11) NOT NULL auto_increment, 16.979 - `HARDWARE_ID` int(11) NOT NULL, 16.980 - `MANUFACTURER` varchar(255) default NULL, 16.981 - `NAME` varchar(255) default NULL, 16.982 - `DESCRIPTION` varchar(255) default NULL, 16.983 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.984 - KEY `ID` (`ID`) 16.985 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.986 -SET character_set_client = @saved_cs_client; 16.987 - 16.988 --- 16.989 --- Dumping data for table `sounds` 16.990 --- 16.991 - 16.992 -LOCK TABLES `sounds` WRITE; 16.993 -/*!40000 ALTER TABLE `sounds` DISABLE KEYS */; 16.994 -/*!40000 ALTER TABLE `sounds` ENABLE KEYS */; 16.995 -UNLOCK TABLES; 16.996 - 16.997 --- 16.998 --- Table structure for table `storages` 16.999 --- 16.1000 - 16.1001 -DROP TABLE IF EXISTS `storages`; 16.1002 -SET @saved_cs_client = @@character_set_client; 16.1003 -SET character_set_client = utf8; 16.1004 -CREATE TABLE `storages` ( 16.1005 - `ID` int(11) NOT NULL auto_increment, 16.1006 - `HARDWARE_ID` int(11) NOT NULL, 16.1007 - `MANUFACTURER` varchar(255) default NULL, 16.1008 - `NAME` varchar(255) default NULL, 16.1009 - `MODEL` varchar(255) default NULL, 16.1010 - `DESCRIPTION` varchar(255) default NULL, 16.1011 - `TYPE` varchar(255) default NULL, 16.1012 - `DISKSIZE` int(11) default NULL, 16.1013 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.1014 - KEY `ID` (`ID`) 16.1015 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.1016 -SET character_set_client = @saved_cs_client; 16.1017 - 16.1018 --- 16.1019 --- Dumping data for table `storages` 16.1020 --- 16.1021 - 16.1022 -LOCK TABLES `storages` WRITE; 16.1023 -/*!40000 ALTER TABLE `storages` DISABLE KEYS */; 16.1024 -/*!40000 ALTER TABLE `storages` ENABLE KEYS */; 16.1025 -UNLOCK TABLES; 16.1026 - 16.1027 --- 16.1028 --- Table structure for table `subnet` 16.1029 --- 16.1030 - 16.1031 -DROP TABLE IF EXISTS `subnet`; 16.1032 -SET @saved_cs_client = @@character_set_client; 16.1033 -SET character_set_client = utf8; 16.1034 -CREATE TABLE `subnet` ( 16.1035 - `NETID` varchar(15) NOT NULL, 16.1036 - `NAME` varchar(255) default NULL, 16.1037 - `ID` int(11) default NULL, 16.1038 - `MASK` varchar(255) default NULL, 16.1039 - PRIMARY KEY (`NETID`) 16.1040 -) ENGINE=MyISAM DEFAULT CHARSET=latin1; 16.1041 -SET character_set_client = @saved_cs_client; 16.1042 - 16.1043 --- 16.1044 --- Dumping data for table `subnet` 16.1045 --- 16.1046 - 16.1047 -LOCK TABLES `subnet` WRITE; 16.1048 -/*!40000 ALTER TABLE `subnet` DISABLE KEYS */; 16.1049 -/*!40000 ALTER TABLE `subnet` ENABLE KEYS */; 16.1050 -UNLOCK TABLES; 16.1051 - 16.1052 --- 16.1053 --- Table structure for table `videos` 16.1054 --- 16.1055 - 16.1056 -DROP TABLE IF EXISTS `videos`; 16.1057 -SET @saved_cs_client = @@character_set_client; 16.1058 -SET character_set_client = utf8; 16.1059 -CREATE TABLE `videos` ( 16.1060 - `ID` int(11) NOT NULL auto_increment, 16.1061 - `HARDWARE_ID` int(11) NOT NULL, 16.1062 - `NAME` varchar(255) default NULL, 16.1063 - `CHIPSET` varchar(255) default NULL, 16.1064 - `MEMORY` varchar(255) default NULL, 16.1065 - `RESOLUTION` varchar(255) default NULL, 16.1066 - PRIMARY KEY (`HARDWARE_ID`,`ID`), 16.1067 - KEY `ID` (`ID`) 16.1068 -) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16.1069 -SET character_set_client = @saved_cs_client; 16.1070 - 16.1071 --- 16.1072 --- Dumping data for table `videos` 16.1073 --- 16.1074 - 16.1075 -LOCK TABLES `videos` WRITE; 16.1076 -/*!40000 ALTER TABLE `videos` DISABLE KEYS */; 16.1077 -/*!40000 ALTER TABLE `videos` ENABLE KEYS */; 16.1078 -UNLOCK TABLES; 16.1079 -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 16.1080 - 16.1081 -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 16.1082 -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 16.1083 -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 16.1084 -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 16.1085 -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 16.1086 -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 16.1087 -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 16.1088 - 16.1089 --- Dump completed on 2009-04-25 0:01:16
17.1 --- a/opencc-dev/receipt Thu Nov 02 09:44:39 2017 +0100 17.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 17.3 @@ -1,21 +0,0 @@ 17.4 -# SliTaz package receipt. 17.5 - 17.6 -PACKAGE="opencc-dev" 17.7 -VERSION="0.2.0" 17.8 -CATEGORY="development" 17.9 -SHORT_DESC="Development files for OpenCC" 17.10 -MAINTAINER="lufeng369@slitaz.org" 17.11 -LICENSE="Apache" 17.12 -WEB_SITE="http://code.google.com/p/opencc/" 17.13 -WANTED="opencc" 17.14 - 17.15 -DEPENDS="opencc pkg-config" 17.16 - 17.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 17.18 -genpkg_rules() 17.19 -{ 17.20 - mkdir -p $fs/usr/lib/pkgconfig/ 17.21 - cp -a $install/usr/include $fs/usr 17.22 - cp -a $install/usr/lib/*.so $fs/usr/lib/ 17.23 - cp -a $install/usr/lib/pkgconfig/*.pc $fs/usr/lib/pkgconfig/ 17.24 -}
18.1 --- a/opencc-tools/receipt Thu Nov 02 09:44:39 2017 +0100 18.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 18.3 @@ -1,19 +0,0 @@ 18.4 -# SliTaz package receipt. 18.5 - 18.6 -PACKAGE="opencc-tools" 18.7 -VERSION="0.2.0" 18.8 -CATEGORY="utilities" 18.9 -SHORT_DESC="Command line tools for OpenCC" 18.10 -MAINTAINER="lufeng369@slitaz.org" 18.11 -LICENSE="Apache" 18.12 -WEB_SITE="http://code.google.com/p/opencc/" 18.13 -WANTED="opencc" 18.14 - 18.15 -DEPENDS="opencc" 18.16 - 18.17 -# Rules to gen a SliTaz package suitable for Tazpkg. 18.18 -genpkg_rules() 18.19 -{ 18.20 - mkdir -p $fs/usr 18.21 - cp -a $install/usr/bin $fs/usr 18.22 -}
19.1 --- a/opencc/receipt Thu Nov 02 09:44:39 2017 +0100 19.2 +++ b/opencc/receipt Thu Nov 02 11:09:53 2017 +0100 19.3 @@ -1,7 +1,7 @@ 19.4 -# SliTaz package receipt. 19.5 +# SliTaz package receipt v2. 19.6 19.7 PACKAGE="opencc" 19.8 -VERSION="0.2.0" 19.9 +VERSION="0.4.3" 19.10 CATEGORY="misc" 19.11 SHORT_DESC="Libraries for Simplified-Traditional Chinese Conversion" 19.12 MAINTAINER="lufeng369@slitaz.org" 19.13 @@ -10,8 +10,8 @@ 19.14 WEB_SITE="http://code.google.com/p/opencc/" 19.15 WGET_URL="http://opencc.googlecode.com/files/$TARBALL" 19.16 19.17 -DEPENDS="" 19.18 BUILD_DEPENDS="cmake gettext" 19.19 +SPLIT="opencc opencc-dev opencc-tools" 19.20 19.21 # Rules to configure and make the package. 19.22 compile_rules() 19.23 @@ -27,7 +27,25 @@ 19.24 # Rules to gen a SliTaz package suitable for Tazpkg. 19.25 genpkg_rules() 19.26 { 19.27 - mkdir -p $fs/usr/lib/ $fs/usr/share/ 19.28 - cp -a $install/usr/lib/lib*.so.* $fs/usr/lib/ 19.29 - cp -a $install/usr/share/opencc/ $fs/usr/share/ 19.30 + case $PACKAGE in 19.31 + opencc) 19.32 + mkdir -p $fs/usr/lib/ $fs/usr/share/ 19.33 + cp -a $install/usr/lib/lib*.so.* $fs/usr/lib/ 19.34 + cp -a $install/usr/share/opencc/ $fs/usr/share/ 19.35 + ;; 19.36 + opencc-dev) 19.37 + CAT="development|Development files for OpenCC" 19.38 + DEPENDS="opencc pkg-config" 19.39 + mkdir -p $fs/usr/lib/pkgconfig/ 19.40 + cp -a $install/usr/include $fs/usr 19.41 + cp -a $install/usr/lib/*.so $fs/usr/lib/ 19.42 + cp -a $install/usr/lib/pkgconfig/*.pc $fs/usr/lib/pkgconfig/ 19.43 + ;; 19.44 + opencc-tools) 19.45 + CAT="utilities|Command line tools for OpenCC" 19.46 + DEPENDS="opencc" 19.47 + mkdir -p $fs/usr 19.48 + cp -a $install/usr/bin $fs/usr 19.49 + ;; 19.50 + esac 19.51 }