text:
<?php

namespace Populator\Tests\DataType;

use Populator\DataType\TimeDataType;
use Populator\Structure\Column;

class TimeDataTypeTest extends AbstractDataTypeTest
{
    public function testNoSettingsColumn(): void
    {
        $column = new Column('column', 'time');
        $dataType = new TimeDataType($this->faker);
        for ($i = 0; $i < 10; ++$i) {
            $populatedData = $dataType->populate($column);
            $this->assertTrue(is_string($populatedData));
            $this->assertEquals(8, strlen($populatedData));
            $this->assertMatchesRegularExpression('/^[0-9]{2}:[0-9]{2}:[0-9]{2}$/', $populatedData);
        }
    }
}


text:
package org.uberfire.ext.wires.bayesian.network.client.shapes;

import java.util.List;
import java.util.Map;

import com.ait.lienzo.client.core.shape.Rectangle;
import com.ait.lienzo.client.core.shape.Text;
import com.google.common.collect.Maps;
import org.uberfire.ext.wires.bayesian.network.client.utils.BayesianUtils;
import org.uberfire.ext.wires.bayesian.network.parser.client.model.BayesVariable;
import org.uberfire.ext.wires.core.api.shapes.OverridesFactoryDescription;
import org.uberfire.ext.wires.core.api.shapes.WiresBaseShape;
import org.uberfire.ext.wires.core.client.util.ShapesUtils;

public class EditableBayesianNode extends WiresBaseShape implements OverridesFactoryDescription {

    private static final int BOUNDARY_SIZE = 10;

    private Rectangle header;
    private Text textHeader;
    private Map<Text, List<Rectangle>> porcentualBars;

    private final Rectangle rectangle;
    private final Rectangle bounding;

    private final BayesVariable variable;

    public EditableBayesianNode() {
        this( 0,
              0,
              0,
              0,
              "" );
    }

    public EditableBayesianNode( final Rectangle shape ) {
        this( shape.getWidth(),
              shape.getHeight(),
              shape.getX(),
              shape.getY(),
              BayesianUtils.getNodeColors()[ 0 ][ 0 ] );
    }

    public EditableBayesianNode( final double width,
                                 final double height,
                                 final double positionXNode,
                                 final double positionYNode,
                                 final String fillColor ) {
        this( width,
              height,
              positionXNode,
              positionYNode,
              fillColor,
              new BayesVariable() );
    }

    public EditableBayesianNode( final double width,
                                 final double height,
                                 final double positionXNode,
                                 final double positionYNode,
                                 final String fillColor,
                                 final BayesVariable variable ) {
        this.variable = variable;

        rectangle = new Rectangle( width,
                                   height );
        rectangle.setStrokeColor( ShapesUtils.RGB_STROKE_SHAPE );
        rectangle.setStrokeWidth( ShapesUtils.RGB_STROKE_WIDTH_SHAPE );
        rectangle.setFillColor( fillColor );

        bounding = new Rectangle( width + BOUNDARY_SIZE,
                                  height + BOUNDARY_SIZE,
                                  rectangle.getCornerRadius() );
        bounding.setX( getX() - ( BOUNDARY_SIZE / 2 ) );
        bounding.setY( getY() - ( BOUNDARY_SIZE / 2 ) );
        bounding.setStrokeWidth( BOUNDARY_SIZE );
        bounding.setAlpha( 0.1 );

        add( rectangle );

        setX( positionXNode );
        setY( positionYNode );

        this.porcentualBars = Maps.newHashMap();
    }

    @Override
    public void setSelected( final boolean isSelected ) {
        if ( isSelected ) {
            add( bounding );
        } else {
            remove( bounding );
        }
    }

    @Override
    public boolean contains( double cx,
                             double cy ) {
        //We don't have any ControlPoints so no need to worry about whether we contain a given point
        return false;
    }

    public void buildNode() {
        add( this.header );
        add( this.textHeader );
        for ( Map.Entry<Text, List<Rectangle>> porcenualBar : this.porcentualBars.entrySet() ) {
            for ( Rectangle rec : porcenualBar.getValue() ) {
                add( rec );
            }
            add( porcenualBar.getKey() );
        }
    }

    public Rectangle getParentNode() {
        return rectangle;
    }

    public Rectangle getHeader() {
        return header;
    }

    public void setHeader( final Rectangle header ) {
        this.header = header;
    }

    public Text getTextHeader() {
        return textHeader;
    }

    public void setTextHeader( final Text textHeader ) {
        this.textHeader = textHeader;
    }

    public Map<Text, List<Rectangle>> getPorcentualsBar() {
        return porcentualBars;
    }

    public void setPorcentualBars( final Map<Text, List<Rectangle>> porcentualBars ) {
        this.porcentualBars = porcentualBars;
    }

    public double getWidth() {
        return rectangle.getWidth();
    }

    public BayesVariable getVariable() {
        return variable;
    }

    @Override
    public String getDescription() {
        return variable.getName();
    }
}

redpajama_set_name: RedPajamaGithub


text:
@interface CISProgressWindowController ()

@end

@implementation CISProgressWindowController

- (id)init
{
    return [super initWithWindowNibName:@"CISProgressWindow"];
}

- (void)windowDidLoad
{
    [super windowDidLoad];
    NSLog(@"Progress window did load");
}

- (void) setMessage:(NSString *)message
{
    self.messageField.stringValue = message;
}

@end


text:
{-# LANGUAGE FlexibleInstances #-}
{-# LANGUAGE FunctionalDependencies #-}
{-# LANGUAGE MultiParamTypeClasses #-}
{-# LANGUAGE TupleSections #-}

-- |Monadic Iteratees:
-- incremental input parsers, processors and transformers
--
-- Support for IO enumerators

module Data.Iteratee.Base.ReadableChunk (
  ReadableChunk (..)
)
where

import Prelude hiding (head, tail, dropWhile, length, splitAt )

import Control.Applicative
import Control.Arrow (first)
import qualified Data.ByteString as B
import qualified Data.ByteString.Internal as B
import qualified Data.ByteString.Lazy as L
import Data.Monoid
import Data.Word
import Foreign.C
import Foreign.ForeignPtr  (withForeignPtr, mallocForeignPtrBytes)
import Foreign.Ptr
import Foreign.Storable
import Foreign.Marshal.Array
import Foreign.Marshal.Alloc

-- |Class of streams which can be filled from a 'Ptr'.  Typically these
-- are streams which can be read from a file, @Handle@, or similar resource.
--
-- instances must implement 'readFromPtr' and optionally 'fillFromCallback'.
-- if available, 'fillFromCallback' results in less copying.
class (Monoid s, Storable el) => ReadableChunk s el | s -> el where
  readFromPtr :: Ptr el
              -> Int -- ^ The pointer must not be used after @readFromPtr@ completes.
              -> IO s -- ^ The Int parameter is the length of the data in *bytes*.
  fillFromCallback :: Int -> (Ptr el -> Int -> IO Int) -> IO (s,Int)
  fillFromCallback sz cb = allocaBytes sz $ \p -> do
          nRead <- cb p sz
          (,nRead) <$> readFromPtr p nRead
  empty :: s
  empty = mempty

{-# DEPRECATED readFromPtr "use fillFromCallback" #-}

instance ReadableChunk [Char] Char where
  readFromPtr buf l = peekCAStringLen (castPtr buf, l)

instance ReadableChunk [Word8] Word8 where
  readFromPtr buf l = peekArray l buf
instance ReadableChunk [Word16] Word16 where
  readFromPtr buf l = peekArray l buf
instance ReadableChunk [Word32] Word32 where
  readFromPtr buf l = peekArray l buf
instance ReadableChunk [Word] Word where
  readFromPtr buf l = peekArray l buf

instance ReadableChunk B.ByteString Word8 where
  readFromPtr buf l = B.packCStringLen (castPtr buf, l)
  fillFromCallback sz cb = do
      fp <- mallocForeignPtrBytes sz
      numFill <- withForeignPtr fp $ \p -> cb p sz
      return $ (B.PS fp 0 numFill, numFill)

instance ReadableChunk L.ByteString Word8 where
  readFromPtr buf l = return . L.fromChunks . (:[]) =<< readFromPtr buf l
  fillFromCallback sz cb = first (L.fromChunks . (:[])) <$> fillFromCallback sz cb


text:
_MixR_ is a framework for integrating multiple sentential and diagrammatic theorem provers, as well as informal tools from arbitrary domains (such as image processing, natural language processing, amongst others) into one heterogeneous reasoning system.

MixR is a conglomeration of modules built for the [NetBeans Platform](http://netbeans.org/features/platform/). It integrates well with [I3P](http://www-pu.informatik.uni-tuebingen.de/i3p/) (an interactive interface for the Isabelle prover).

This project is related to (but not dependent on) [Speedith](https://gitorious.org/speedith) (a diagrammatic theorem prover for spider diagrams).

Speedith and [Isabelle](http://www.cl.cam.ac.uk/research/hvg/Isabelle/) (through I3P) are the first supported theorem provers to be integrated into the MixR framework--resulting in the _Diabelli Heterogeneous Reasoning System_. With Diabelli it is possible to use spider diagrams while performing proofs in Isabelle. Isabelle formulae are automatically translated to spider diagrams if possible. The user can then reason on the spider diagram and then return the result of reasoning with the spider-diagrammatic representation back to Isabelle.

We provide two further examples of heterogeneous reasoning with MixR:

1.   NatLang: demonstrates how reasoning with natural languages can be performed in a general-purpose sentential and formal theorem prover (in this case, Isabelle).
2.   PicProc: demonstrates how one can reason about bitmap images within Isabelle.

Both of the examples above use the novel concept of _placeholders_ to insert natural language sentences and images into Isabelle's formulae.

## Installation procedure

1.  Download the NetBeans IDE with Java SE support from this location (currently we support NetBeans 7.3):

    https://netbeans.org/downloads/

2.  Install Maven:

    http://maven.apache.org/download.cgi

3.  Clone this repository repository:

        git clone https://github.com/urbas/mixr.git

4.  This is enough just to build the MixR framework (without any plugins!). This means that none of the examples (Isabelle, Speedith, NatLang, PicProc, and TPTP will work).

    To build MixR framework (MixR core), open the `devel/MixRFramework` project in NetBeans.

    To build Diabelli (with Isabelle, Speedith, NatLang, PicProc, and TPTP support), proceed as follows:

5.  Download and unpack Isabelle 2012  into the `~/bin/Isabelle2012` folder. Isabelle 2012 can be downloaded from:

    http://isabelle.in.tum.de/website-Isabelle2012/index.html

    On Mac Isabelle might need Java 6. You can get it from here: http://www.oracle.com/technetwork/java/javase/archive-139210.html

    or here: http://support.apple.com/kb/dl1573

6.  Clone the Speedith and iCircles repositories (follow their installation instructions from README.md):

        git clone https://github.com/urbas/speedith.git
        git clone https://github.com/urbas/iCircles.git

    The `Speedith` and `iCircles` folders must be siblings to the `mixr` folder.

7.  Go to the `mixr` folder and run the following:

      mvn install

8.  Clone I3P from here (you'll need [Mercurial](http://mercurial.selenic.com/downloads) for this):

        hg clone https://urbas@bitbucket.org/urbas/i3p

9.  Open the `Diabelli` project (`devel/Diabelli`) within NetBeans and make sure all dependencies are resolved. Try to build and run.

    Feel free to contact developers in case the build fails.

## Licence

MixR is an open source project. It's sources are freely available under the [MIT License](http://en.wikipedia.org/wiki/Mit_license).

The full text of the licence is in the following file:

>   `<repository root>/LICENSE`


text:
package apollo.datastore;

import com.google.appengine.api.datastore.Key;

import java.io.Serializable;
import java.util.Date;

@SuppressWarnings("serial")
public class ChangeEmailAddressRequestBean implements Serializable {

    private Key key;
    private String requestId;
    private Key userKey;
    private String emailAddress;
    private Date dateRequested;

    public ChangeEmailAddressRequestBean(ChangeEmailAddressRequest changeEmailAddressRequest) {
        this.key = changeEmailAddressRequest.getKey();
        this.requestId = changeEmailAddressRequest.getRequestId();
        this.userKey = changeEmailAddressRequest.getUserKey();
        this.emailAddress = changeEmailAddressRequest.getEmailAddress();
        this.dateRequested = changeEmailAddressRequest.getDateRequested();
    }

    public ChangeEmailAddressRequestBean() {
        this.key = null;
        this.requestId = "";
        this.userKey = null;
        this.emailAddress = "";
        this.dateRequested = new Date();
    }

    public Key getKey() {
        return this.key;
    }

    public String getRequestId() {
        return this.requestId;
    }

    public Key getUserKey() {
        return this.userKey;
    }

    public String getEmailAddress() {
        return this.emailAddress;
    }

    public Date getDateRequested() {
        return this.dateRequested;
    }
}


text:
var shell = require("gulp-shell");

module.exports = function (gulp) {
  return gulp.task('jsdoc', shell.task('./node_modules/.bin/jsdoc ./src -c ./jsdoc.config.json -R ./docs/README.md'));
};


text:
<?php

namespace Zilf\Security\Hashids;

use Illuminate\Support\ServiceProvider;
use Zilf\System\Zilf;

class HashidsServiceProvider extends ServiceProvider
{
    /**
     * Indicates if loading of the provider is deferred.
     *
     * @var bool
     */
    protected $defer = true;

    /**
     * Register the service provider.
     *
     * @throws \Exception
     */
    public function register()
    {
        Zilf::$app->singleton('hashids', function (){
            return new Hashids();
        });
    }

    /**
     * Get the services provided by the provider.
     *
     * @return array
     */
    public function provides()
    {
        return ['hashids'];
    }
}


text:
import Vue from 'vue'

import QBtn from '../btn/QBtn.js'
import QIcon from '../icon/QIcon.js'
import QSpinner from '../spinner/QSpinner.js'
import QCircularProgress from '../circular-progress/QCircularProgress.js'

import FileMixin from '../../mixins/file.js'
import DarkMixin from '../../mixins/dark.js'

import { stop } from '../../utils/event.js'
import { humanStorageSize } from '../../utils/format.js'
import cache from '../../utils/private/cache.js'

export default Vue.extend({
  name: 'QUploaderBase',

  mixins: [ DarkMixin, FileMixin ],

  props: {
    label: String,

    color: String,
    textColor: String,

    square: Boolean,
    flat: Boolean,
    bordered: Boolean,

    noThumbnails: Boolean,
    autoUpload: Boolean,
    hideUploadBtn: Boolean,

    disable: Boolean,
    readonly: Boolean
  },

  provide () {
    return {
      __qUploaderGetInput: this.__getInputControl
    }
  },

  data () {
    return {
      files: [],
      queuedFiles: [],
      uploadedFiles: [],
      dnd: false,
      expanded: false,

      uploadSize: 0,
      uploadedSize: 0
    }
  },

  watch: {
    isUploading (newVal, oldVal) {
      if (oldVal === false && newVal === true) {
        this.$emit('start')
      }
      else if (oldVal === true && newVal === false) {
        this.$emit('finish')
      }
    }
  },

  computed: {
    /*
     * When extending:
     *   Required : isUploading
     *   Optional: isBusy
     */

    canUpload () {
      return this.editable === true &&
        this.isBusy !== true &&
        this.isUploading !== true &&
        this.queuedFiles.length > 0
    },

    canAddFiles () {
      return (
        this.editable === true &&
        this.isUploading !== true &&
        // if single selection and no files are queued:
        (this.multiple === true || this.queuedFiles.length === 0) &&
        // if max-files is set and current number of files does not exceeds it:
        (this.maxFiles === void 0 || this.files.length < this.maxFilesNumber) &&
        // if max-total-size is set and current upload size does not exceeds it:
        (this.maxTotalSize === void 0 || this.uploadSize < this.maxTotalSizeNumber)
      )
    },

    uploadProgress () {
      return this.uploadSize === 0
        ? 0
        : this.uploadedSize / this.uploadSize
    },

    uploadProgressLabel () {
      return this.__getProgressLabel(this.uploadProgress)
    },

    uploadedSizeLabel () {
      return humanStorageSize(this.uploadedSize)
    },

    uploadSizeLabel () {
      return humanStorageSize(this.uploadSize)
    },

    colorClass () {
      const cls = []
      this.color !== void 0 && cls.push(`bg-${this.color}`)
      this.textColor !== void 0 && cls.push(`text-${this.textColor}`)
      return cls.join(' ')
    },

    editable () {
      return this.disable !== true && this.readonly !== true
    }
  },

  methods: {
    reset () {
      if (!this.disable) {
        this.abort()
        this.uploadedSize = 0
        this.uploadSize = 0
        this.__revokeImgURLs()
        this.files = []
        this.queuedFiles = []
        this.uploadedFiles = []
      }
    },

    removeUploadedFiles () {
      this.__removeFiles([ 'uploaded' ], () => {
        this.uploadedFiles = []
      })
    },

    removeQueuedFiles () {
      this.__removeFiles([ 'idle', 'failed' ], ({ size }) => {
        this.uploadSize -= size
        this.queuedFiles = []
      })
    },

    __removeFiles (statusList, cb) {
      if (this.disable === true) {
        return
      }

      const removed = {
        files: [],
        size: 0
      }

      const files = this.files.filter(f => {
        if (statusList.indexOf(f.__status) === -1) {
          return true
        }

        removed.size += f.size
        removed.files.push(f)

        f.__img !== void 0 && window.URL.revokeObjectURL(f.__img.src)

        return false
      })

      if (removed.files.length > 0) {
        this.files = files
        cb !== void 0 && cb(removed)
        this.$emit('removed', removed.files)
      }
    },

    removeFile (file) {
      if (this.disable) { return }

      if (file.__status === 'uploaded') {
        this.uploadedFiles = this.uploadedFiles.filter(f => f.__key !== file.__key)
      }
      else if (file.__status === 'uploading') {
        file.__abort()
      }
      else {
        this.uploadSize -= file.size
      }

      this.files = this.files.filter(f => {
        if (f.__key !== file.__key) {
          return true
        }

        f.__img !== void 0 && window.URL.revokeObjectURL(f.__img.src)

        return false
      })
      this.queuedFiles = this.queuedFiles.filter(f => f.__key !== file.__key)
      this.$emit('removed', [ file ])
    },

    __revokeImgURLs () {
      this.files.forEach(f => {
        f.__img !== void 0 && window.URL.revokeObjectURL(f.__img.src)
      })
    },

    __getFileInput () {
      return this.$refs.input ||
        this.$el.getElementsByClassName('q-uploader__input')[0]
    },

    __getProgressLabel (p) {
      return (p * 100).toFixed(2) + '%'
    },

    __updateFile (file, status, uploadedSize) {
      file.__status = status

      if (status === 'idle') {
        file.__uploaded = 0
        file.__progress = 0
        file.__sizeLabel = humanStorageSize(file.size)
        file.__progressLabel = '0.00%'
        return
      }
      if (status === 'failed') {
        this.$forceUpdate()
        return
      }

      file.__uploaded = status === 'uploaded'
        ? file.size
        : uploadedSize

      file.__progress = status === 'uploaded'
        ? 1
        : Math.min(0.9999, file.__uploaded / file.size)

      file.__progressLabel = this.__getProgressLabel(file.__progress)
      this.$forceUpdate()
    },

    __addFiles (e, fileList) {
      const localFiles = this.__processFiles(e, fileList, this.files, true)
      const fileInput = this.__getFileInput()

      if (fileInput !== void 0) {
        fileInput.value = ''
      }

      if (localFiles === void 0) { return }

      localFiles.forEach(file => {
        this.__updateFile(file, 'idle')
        this.uploadSize += file.size

        if (this.noThumbnails !== true && file.type.toUpperCase().startsWith('IMAGE')) {
          const img = new Image()
          img.src = window.URL.createObjectURL(file)
          file.__img = img
        }
      })

      this.files = this.files.concat(localFiles)
      this.queuedFiles = this.queuedFiles.concat(localFiles)
      this.$emit('added', localFiles)
      this.autoUpload === true && this.upload()
    },

    __getBtn (h, show, icon, fn) {
      if (show === true) {
        return h(QBtn, {
          props: {
            type: 'a',
            icon: this.$q.iconSet.uploader[icon],
            flat: true,
            dense: true
          },
          on: { click: icon === 'add' ? this.pickFiles : fn }
        }, icon === 'add' ? this.__getInputControl(h) : null)
      }
    },

    __getInputControl (h) {
      return [
        h('input', {
          key: 'input',
          ref: 'input',
          staticClass: 'q-uploader__input overflow-hidden absolute-full',
          attrs: {
            tabindex: -1,
            type: 'file',
            title: '', // try to remove default tooltip
            accept: this.accept,
            capture: this.capture,
            ...(this.multiple === true ? { multiple: true } : {})
          },
          on: cache(this, 'input', {
            mousedown: stop, // need to stop refocus from QBtn
            click: this.pickFiles,
            change: this.__addFiles
          })
        })
      ]
    },

    __getHeader (h) {
      if (this.$scopedSlots.header !== void 0) {
        return this.$scopedSlots.header(this)
      }

      return [
        h('div', {
          staticClass: 'q-uploader__header-content column'
        }, [
          h('div', {
            staticClass: 'flex flex-center no-wrap q-gutter-xs'
          }, [
            this.__getBtn(h, this.queuedFiles.length > 0, 'removeQueue', this.removeQueuedFiles),
            this.__getBtn(h, this.uploadedFiles.length > 0, 'removeUploaded', this.removeUploadedFiles),

            this.isUploading === true
              ? h(QSpinner, { staticClass: 'q-uploader__spinner' })
              : null,

            h('div', { staticClass: 'col column justify-center' }, [
              this.label !== void 0
                ? h('div', { staticClass: 'q-uploader__title' }, [ this.label ])
                : null,

              h('div', { staticClass: 'q-uploader__subtitle' }, [
                this.uploadSizeLabel + ' / ' + this.uploadProgressLabel
              ])
            ]),

            this.__getBtn(h, this.canAddFiles, 'add', this.pickFiles),
            this.__getBtn(h, this.hideUploadBtn === false && this.canUpload === true, 'upload', this.upload),
            this.__getBtn(h, this.isUploading, 'clear', this.abort)
          ])
        ])
      ]
    },

    __getList (h) {
      if (this.$scopedSlots.list !== void 0) {
        return this.$scopedSlots.list(this)
      }

      return this.files.map(file => h('div', {
        key: file.__key,
        staticClass: 'q-uploader__file relative-position',
        class: {
          'q-uploader__file--img': this.noThumbnails !== true && file.__img !== void 0,
          'q-uploader__file--failed': file.__status === 'failed',
          'q-uploader__file--uploaded': file.__status === 'uploaded'
        },
        style: this.noThumbnails !== true && file.__img !== void 0 ? {
          backgroundImage: 'url("' + file.__img.src + '")'
        } : null
      }, [
        h('div', {
          staticClass: 'q-uploader__file-header row flex-center no-wrap'
        }, [
          file.__status === 'failed'
            ? h(QIcon, {
              staticClass: 'q-uploader__file-status',
              props: {
                name: this.$q.iconSet.type.negative,
                color: 'negative'
              }
            })
            : null,

          h('div', { staticClass: 'q-uploader__file-header-content col' }, [
            h('div', { staticClass: 'q-uploader__title' }, [ file.name ]),
            h('div', {
              staticClass: 'q-uploader__subtitle row items-center no-wrap'
            }, [
              file.__sizeLabel + ' / ' + file.__progressLabel
            ])
          ]),

          file.__status === 'uploading'
            ? h(QCircularProgress, {
              props: {
                value: file.__progress,
                min: 0,
                max: 1,
                indeterminate: file.__progress === 0
              }
            })
            : h(QBtn, {
              props: {
                round: true,
                dense: true,
                flat: true,
                icon: this.$q.iconSet.uploader[file.__status === 'uploaded' ? 'done' : 'clear']
              },
              on: {
                click: () => { this.removeFile(file) }
              }
            })
        ])
      ]))
    }
  },

  beforeDestroy () {
    this.isUploading === true && this.abort()
    this.files.length > 0 && this.__revokeImgURLs()
  },

  render (h) {
    const children = [
      h('div', {
        staticClass: 'q-uploader__header',
        class: this.colorClass
      }, this.__getHeader(h)),

      h('div', {
        staticClass: 'q-uploader__list scroll'
      }, this.__getList(h)),

      this.__getDnd(h, 'uploader')
    ]

    this.isBusy === true && children.push(
      h('div', {
        staticClass: 'q-uploader__overlay absolute-full flex flex-center'
      }, [ h(QSpinner) ])
    )

    return h('div', {
      key: 'drag',
      staticClass: 'q-uploader column no-wrap',
      class: {
        [`q-uploader--${this.darkSuffix} q-${this.darkSuffix}`]: true,
        'q-uploader--bordered': this.bordered,
        'q-uploader--square no-border-radius': this.square,
        'q-uploader--flat no-shadow': this.flat,
        'disabled q-uploader--disabled': this.disable,
        'q-uploader--dnd': this.dnd
      },
      on: this.canAddFiles === true
        ? cache(this, 'drag', {
          dragover: this.__onDragOver,
          dragleave: this.__onDragLeave
        })
        : null
    }, children)
  }
})


text:
<!DOCTYPE html>

    <title>Farmacia Rivers and Galvez</title>

<form name="form1" method="post" action="">

        Seleccione una Opcion :

         <select name="opcion" onchange="location = this.value">
             <option value="comunes">comunes </option>
             <option value="cabeza">cabeza </option>
             <option value="torso">torso</option>
             <input type="submit" name="Submit" value="Enviar">
        </select>
         </select>

¿Dudas?

</form>
Volver al inicio


text:
//-----------------------------------NOTICE----------------------------------//
// Some of this file is automatically filled in by a Python script.  Only    //
// add custom code in the designated areas or it will be overwritten during  //
// the next update.                                                          //
//-----------------------------------NOTICE----------------------------------//

//--BEGIN FILE HEAD CUSTOM CODE--//
//--END CUSTOM CODE--//

#include "../../include/FixLink.h"
#include "../../include/ObjectRegistry.h"
#include "../../include/NIF_IO.h"
#include "../../include/obj/NiRollController.h"
#include "../../include/obj/NiFloatData.h"
using namespace Niflib;

//Definition of TYPE constant
const Type NiRollController::TYPE("NiRollController", &NiSingleInterpController::TYPE );

NiRollController::NiRollController() : data(NULL) {
	//--BEGIN CONSTRUCTOR CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

NiRollController::~NiRollController() {
	//--BEGIN DESTRUCTOR CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

const Type & NiRollController::GetType() const {
	return TYPE;
}

NiObject * NiRollController::Create() {
	return new NiRollController;
}

void NiRollController::Read( istream& in, list<unsigned int> & link_stack, const NifInfo & info ) {
	//--BEGIN PRE-READ CUSTOM CODE--//
	//--END CUSTOM CODE--//

	unsigned int block_num;
	NiSingleInterpController::Read( in, link_stack, info );
	NifStream( block_num, in, info );
	link_stack.push_back( block_num );

	//--BEGIN POST-READ CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

void NiRollController::Write( ostream& out, const map<NiObjectRef,unsigned int> & link_map, list<NiObject *> & missing_link_stack, const NifInfo & info ) const {
	//--BEGIN PRE-WRITE CUSTOM CODE--//
	//--END CUSTOM CODE--//

	NiSingleInterpController::Write( out, link_map, missing_link_stack, info );
	if ( info.version < VER_3_3_0_13 ) {
		WritePtr32( &(*data), out );
	} else {
		if ( data != NULL ) {
			map<NiObjectRef,unsigned int>::const_iterator it = link_map.find( StaticCast<NiObject>(data) );
			if (it != link_map.end()) {
				NifStream( it->second, out, info );
				missing_link_stack.push_back( NULL );
			} else {
				NifStream( 0xFFFFFFFF, out, info );
				missing_link_stack.push_back( data );
			}
		} else {
			NifStream( 0xFFFFFFFF, out, info );
			missing_link_stack.push_back( NULL );
		}
	}

	//--BEGIN POST-WRITE CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

std::string NiRollController::asString( bool verbose ) const {
	//--BEGIN PRE-STRING CUSTOM CODE--//
	//--END CUSTOM CODE--//

	stringstream out;
	out << NiSingleInterpController::asString();
	out << "  Data:  " << data << endl;
	return out.str();

	//--BEGIN POST-STRING CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

void NiRollController::FixLinks( const map<unsigned int,NiObjectRef> & objects, list<unsigned int> & link_stack, list<NiObjectRef> & missing_link_stack, const NifInfo & info ) {
	//--BEGIN PRE-FIXLINKS CUSTOM CODE--//
	//--END CUSTOM CODE--//

	NiSingleInterpController::FixLinks( objects, link_stack, missing_link_stack, info );
	data = FixLink<NiFloatData>( objects, link_stack, missing_link_stack, info );

	//--BEGIN POST-FIXLINKS CUSTOM CODE--//
	//--END CUSTOM CODE--//
}

std::list<NiObjectRef> NiRollController::GetRefs() const {
	list<Ref<NiObject> > refs;
	refs = NiSingleInterpController::GetRefs();
	if ( data != NULL )
		refs.push_back(StaticCast<NiObject>(data));
	return refs;
}

std::list<NiObject *> NiRollController::GetPtrs() const {
	list<NiObject *> ptrs;
	ptrs = NiSingleInterpController::GetPtrs();
	return ptrs;
}

/***Begin Example Naive Implementation****

Ref<NiFloatData > NiRollController::GetData() const {
	return data;
}

void NiRollController::SetData( Ref<NiFloatData > value ) {
	data = value;
}

****End Example Naive Implementation***/

//--BEGIN MISC CUSTOM CODE--//
//--END CUSTOM CODE--//


text:
require 'rubygems/test_case'
require 'rubygems/commands/query_command'

class TestGemCommandsQueryCommand < Gem::TestCase

  def setup
    super

    @cmd = Gem::Commands::QueryCommand.new

    util_setup_fake_fetcher
    util_clear_gems
    util_setup_spec_fetcher @a1, @a2, @pl1, @a3a

    @fetcher.data["#{@gem_repo}Marshal.#{Gem.marshal_version}"] = proc do
      raise Gem::RemoteFetcher::FetchError
    end
  end

  def test_execute
    @cmd.handle_options %w[-r]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (2)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_platform
    @a1r = @a1.dup

    @a1.platform = 'x86-linux'
    @a2.platform = 'universal-darwin'

    util_clear_gems
    util_setup_spec_fetcher @a1, @a1r, @a2, @b2, @pl1

    @cmd.handle_options %w[-r -a]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (2 universal-darwin, 1 ruby x86-linux)
b (2)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_all
    @cmd.handle_options %w[-r --all]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (2, 1)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_all_prerelease
    @cmd.handle_options %w[-r --all --prerelease]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (3.a, 2, 1)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_details
    @a2.summary = 'This is a lot of text. ' * 4
    @a2.authors = ['Abraham Lincoln', 'Hirohito']
    @a2.homepage = 'http://a.example.com/'

    util_clear_gems
    util_setup_spec_fetcher @a1, @a2, @pl1

    @cmd.handle_options %w[-r -d]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (2)
    Authors: Abraham Lincoln, Hirohito
    Homepage: http://a.example.com/

    This is a lot of text. This is a lot of text. This is a lot of text.
    This is a lot of text.

pl (1)
    Platform: i386-linux
    Author: A User
    Homepage: http://example.com

    this is a summary
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_details_platform
    @a1.platform = 'x86-linux'

    @a2.summary = 'This is a lot of text. ' * 4
    @a2.authors = ['Abraham Lincoln', 'Hirohito']
    @a2.homepage = 'http://a.example.com/'
    @a2.platform = 'universal-darwin'

    util_clear_gems
    util_setup_spec_fetcher @a1, @a2, @pl1

    @cmd.handle_options %w[-r -d]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (2, 1)
    Platforms:
        1: x86-linux
        2: universal-darwin
    Authors: Abraham Lincoln, Hirohito
    Homepage: http://a.example.com/

    This is a lot of text. This is a lot of text. This is a lot of text.
    This is a lot of text.

pl (1)
    Platform: i386-linux
    Author: A User
    Homepage: http://example.com

    this is a summary
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_installed
    @cmd.handle_options %w[-n a --installed]

    assert_raises Gem::MockGemUi::SystemExitException do
      use_ui @ui do
        @cmd.execute
      end
    end

    assert_equal "true\n", @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_installed_no_name
    @cmd.handle_options %w[--installed]

    e = assert_raises Gem::MockGemUi::TermError do
      use_ui @ui do
        @cmd.execute
      end
    end

    assert_equal '', @ui.output
    assert_equal "ERROR:  You must specify a gem name\n", @ui.error

    assert_equal 4, e.exit_code
  end

  def test_execute_installed_not_installed
    @cmd.handle_options %w[-n not_installed --installed]

    e = assert_raises Gem::MockGemUi::TermError do
      use_ui @ui do
        @cmd.execute
      end
    end

    assert_equal "false\n", @ui.output
    assert_equal '', @ui.error

    assert_equal 1, e.exit_code
  end

  def test_execute_installed_version
    @cmd.handle_options %w[-n a --installed --version 2]

    assert_raises Gem::MockGemUi::SystemExitException do
      use_ui @ui do
        @cmd.execute
      end
    end

    assert_equal "true\n", @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_installed_version_not_installed
    @cmd.handle_options %w[-n c --installed --version 2]

    e = assert_raises Gem::MockGemUi::TermError do
      use_ui @ui do
        @cmd.execute
      end
    end

    assert_equal "false\n", @ui.output
    assert_equal '', @ui.error

    assert_equal 1, e.exit_code
  end

  def test_execute_local_notty
    @cmd.handle_options %w[]

    @ui.outs.tty = false

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF
a (3.a, 2, 1)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_no_versions
    @cmd.handle_options %w[-r --no-versions]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a
pl
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_notty
    @cmd.handle_options %w[-r]

    @ui.outs.tty = false

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF
a (2)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_prerelease
    @cmd.handle_options %w[-r --prerelease]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** REMOTE GEMS ***

a (3.a)
    EOF

    assert_equal expected, @ui.output
    assert_equal '', @ui.error
  end

  def test_execute_prerelease_local
    @cmd.handle_options %w[-l --prerelease]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** LOCAL GEMS ***

a (3.a, 2, 1)
pl (1 i386-linux)
    EOF

    assert_equal expected, @ui.output
    assert_equal "WARNING:  prereleases are always shown locally\n", @ui.error
  end

  def test_execute_local_details
    @a1.platform = 'x86-linux'

    @a2.summary = 'This is a lot of text. ' * 4
    @a2.authors = ['Abraham Lincoln', 'Hirohito']
    @a2.homepage = 'http://a.example.com/'
    @a2.platform = 'universal-darwin'

    util_clear_gems
    util_setup_spec_fetcher @a1, @a2, @pl1

    @cmd.handle_options %w[-l -d]

    use_ui @ui do
      @cmd.execute
    end

    str = @ui.output

    str.gsub!(/\(\d\): [^\n]*/, "-")
    str.gsub!(/at: [^\n]*/, "at: -")

    expected = <<-EOF
*** LOCAL GEMS ***

a (2, 1)
    Platforms:
        1: x86-linux
        2: universal-darwin
    Authors: Abraham Lincoln, Hirohito
    Homepage: http://a.example.com/
    Installed at -
                 -

    This is a lot of text. This is a lot of text. This is a lot of text.
    This is a lot of text.

pl \(1\)
    Platform: i386-linux
    Author: A User
    Homepage: http://example.com
    Installed at: -

    this is a summary
    EOF

    assert_match expected, @ui.output
  end

  def test_execute_default_details
    default_gem_dir = Gem::Specification.default_specifications_dir
    @a1.loaded_from =
      File.join default_gem_dir, @a1.spec_name

    @cmd.handle_options %w[-l -d]

    use_ui @ui do
      @cmd.execute
    end

    expected = <<-EOF

*** LOCAL GEMS ***

a (3.a, 2, 1)
    Author: A User
    Homepage: http://example.com
    Installed at (3.a): #{@gemhome}
                 (2): #{@gemhome}
                 (1, default): #{@a1.base_dir}

    this is a summary

pl \(1\)
    Platform: i386-linux
    Author: A User
    Homepage: http://example.com
    Installed at: #{@gemhome}

    this is a summary
    EOF

    assert_equal expected, @ui.output
  end

  def test_make_entry
    @fetcher.data.delete \
      "#{@gem_repo}quick/Marshal.#{Gem.marshal_version}/#{@a2.original_name}.gemspec.rz"

    entry_tuples = [
      [Gem::NameTuple.new(@a2.name, @a2.version, @a2.platform),
       Gem.sources.first],
    ]

    platforms = { @a2.version => [@a2.platform] }

    entry = @cmd.send :make_entry, entry_tuples, platforms

    assert_equal 'a (2)', entry
  end

end


text:
#ifndef HOBO_GUI_TRIGGERHUD_H
#define HOBO_GUI_TRIGGERHUD_H

#include <memory>

class Panel;

enum TriggerHUDIndicator
{
	Boost30TriggerHUDIndicator,
	Boost45TriggerHUDIndicator,
	Boost60TriggerHUDIndicator,
	SlowTriggerHUDIndicator,
	AngleTriggerHUDIndicator,
	StopTriggerHUDIndicator,
	BlockTriggerHUDIndicator,
	NoneTriggerHUDIndicator,
};

class TriggerHUD final
{
public:

	TriggerHUD(std::shared_ptr<Panel> container);

	void SetIndicators(
		TriggerHUDIndicator first,
		TriggerHUDIndicator second,
		TriggerHUDIndicator third);

private:

	void RemoveIndicator(TriggerHUDIndicator indicator);
	void AddIndicator(TriggerHUDIndicator indicator);
	std::shared_ptr<Panel> GetIndicatorPanel(
		TriggerHUDIndicator indicator) const;

	std::shared_ptr<Panel> m_indicators;

	std::shared_ptr<Panel> m_boost30Panel;
	std::shared_ptr<Panel> m_boost45Panel;
	std::shared_ptr<Panel> m_boost60Panel;
	std::shared_ptr<Panel> m_slowPanel;
	std::shared_ptr<Panel> m_anglePanel;
	std::shared_ptr<Panel> m_stopPanel;
	std::shared_ptr<Panel> m_blockPanel;

	TriggerHUDIndicator m_first;
	TriggerHUDIndicator m_second;
	TriggerHUDIndicator m_third;
};

#endif // HOBO_GUI_COMBOHUD_H


text:
import whitespace from "./whitespace";
import * as parens from "./parentheses";
import each from "lodash/collection/each";
import some from "lodash/collection/some";
import * as t from "../../types";

var find = function (obj, node, parent) {
  if (!obj) return;
  var result;

  var types = Object.keys(obj);
  for (var i = 0; i < types.length; i++) {
    var type = types[i];

    if (t.is(type, node)) {
      var fn = obj[type];
      result = fn(node, parent);
      if (result != null) break;
    }
  }

  return result;
};

export default class Node {
  constructor(node, parent) {
    this.parent = parent;
    this.node   = node;
  }

  static isUserWhitespacable(node) {
    return t.isUserWhitespacable(node);
  }

  static needsWhitespace(node, parent, type) {
    if (!node) return 0;

    if (t.isExpressionStatement(node)) {
      node = node.expression;
    }

    var linesInfo = find(whitespace.nodes, node, parent);

    if (!linesInfo) {
      var items = find(whitespace.list, node, parent);
      if (items) {
        for (var i = 0; i < items.length; i++) {
          linesInfo = Node.needsWhitespace(items[i], node, type);
          if (linesInfo) break;
        }
      }
    }

    return (linesInfo && linesInfo[type]) || 0;
  }

  static needsWhitespaceBefore(node, parent) {
    return Node.needsWhitespace(node, parent, "before");
  }

  static needsWhitespaceAfter(node, parent) {
    return Node.needsWhitespace(node, parent, "after");
  }

  static needsParens(node, parent) {
    if (!parent) return false;

    if (t.isNewExpression(parent) && parent.callee === node) {
      if (t.isCallExpression(node)) return true;

      var hasCall = some(node, function (val) {
        return t.isCallExpression(val);
      });
      if (hasCall) return true;
    }

    return find(parens, node, parent);
  }

  static needsParensNoLineTerminator(node, parent) {
    if (!parent) return false;

    // no comments
    if (!node.leadingComments || !node.leadingComments.length) {
      return false;
    }

    return t.isTerminatorless(parent);
  }
}

each(Node, function (fn, key) {
  Node.prototype[key] = function () {
    // Avoid leaking arguments to prevent deoptimization
    var args = new Array(arguments.length + 2);

    args[0] = this.node;
    args[1] = this.parent;

    for (var i = 0; i < args.length; i++) {
      args[i + 2] = arguments[i];
    }

    return Node[key].apply(null, args);
  };
});


text:
from unittest import TestCase

from edge.generator import GraphGenerator

class GraphGeneratorTest(TestCase):
    def test_graph(self):
        expected = 4

        g = GraphGenerator(n=expected).graph()
        self.assertEqual(g.number_of_nodes(), expected)

    def test_euclidean_graph(self):
        expected = 4

        g = GraphGenerator(n=expected).euclidean_graph()
        self.assertEqual(g.number_of_nodes(), expected)


text:
using NDatabase.Api;
using NDatabase.Btree;
using NDatabase.Exceptions;

namespace NDatabase.Core.Query.List
{
    /// <summary>
    ///   An ordered Collection to hold values (not objects) based on a BTree implementation.
    /// </summary>
    /// <remarks>
    ///   An ordered Collection to hold values (not objects) based on a BTree implementation. It holds all values in memory.
    /// </remarks>
    internal sealed class InMemoryBTreeCollectionForValues : AbstractBTreeCollection<IObjectValues>, IInternalValues
    {
        public InMemoryBTreeCollectionForValues(OrderByConstants orderByType) : base(orderByType)
        {
        }

        #region IValues Members

        public IObjectValues NextValues()
        {
            return Next();
        }

        public new void AddOid(OID oid)
        {
            throw new OdbRuntimeException(NDatabaseError.InternalError.AddParameter("Add Oid not implemented "));
        }

        #endregion

        protected override IBTree BuildTree(int degree)
        {
            return new InMemoryBTreeMultipleValuesPerKey(degree);
        }
    }
}


text:
-- MySQL dump 10.11
--
-- Host: localhost    Database: rkom
-- ------------------------------------------------------
-- Server version	5.0.51a-24+lenny1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ContentViewer`
--

DROP TABLE IF EXISTS `ContentViewer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ContentViewer` (
  `id` int(11) NOT NULL auto_increment,
  `wappId` int(11) NOT NULL default '1',
  `modul` varchar(10) NOT NULL,
  `viewer` varchar(50) NOT NULL,
  `entity` varchar(20) default NULL,
  `refCode` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `viewer` (`viewer`),
  KEY `wappId` (`wappId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSAnlegg`
--

DROP TABLE IF EXISTS `EOSAnlegg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSAnlegg` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `nr` varchar(30) default NULL,
  `beskr` varchar(200) default NULL,
  `adresse1` varchar(30) default NULL,
  `adresse2` varchar(30) default NULL,
  `postnr` char(6) default NULL,
  `poststed` varchar(30) default NULL,
  `land` varchar(30) default NULL,
  `tlfNo1` varchar(20) default NULL,
  `tlfNo2` varchar(20) default NULL,
  `faks` varchar(20) default NULL,
  `email` varchar(100) default NULL,
  `oppvAreal` int(11) default NULL,
  `vTaxmData` smallint(6) NOT NULL default '1',
  `pincode` varchar(10) default NULL,
  `typeId` int(11) NOT NULL default '1',
  `bkatId` int(11) NOT NULL default '1',
  `kundeId` int(11) NOT NULL,
  `nettId` int(11) NOT NULL,
  `worgId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `typeId` (`typeId`),
  KEY `bkatId` (`bkatId`),
  KEY `kundeId` (`kundeId`),
  KEY `nettId` (`nettId`),
  KEY `worgId` (`worgId`)
) ENGINE=MyISAM AUTO_INCREMENT=656 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSAnleggOversikt`
--

DROP TABLE IF EXISTS `EOSAnleggOversikt`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSAnleggOversikt` (
  `id` int(11) NOT NULL auto_increment,
  `eanlId` int(11) NOT NULL,
  `navn` varchar(50) NOT NULL,
  `ovType` char(1) NOT NULL default 'P',
  `forvalgt` int(11) NOT NULL default '0',
  `beskr` varchar(250) default NULL,
  `areal` int(11) default NULL,
  `maxEffekt` int(11) default NULL,
  `fvlMetode` int(11) default NULL,
  `sommerFra` varchar(5) default NULL,
  `sommerTil` varchar(5) default NULL,
  `vinterFra` varchar(5) default NULL,
  `vinterTil` varchar(5) default NULL,
  `varselPrct` int(11) default NULL,
  `tempId` int(11) default NULL,
  `anMeter1` int(11) default NULL,
  `anMeter2` int(11) default NULL,
  `orgId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `eanlId` (`eanlId`),
  KEY `tempId` (`tempId`)
) ENGINE=MyISAM AUTO_INCREMENT=359 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSAnleggType`
--

DROP TABLE IF EXISTS `EOSAnleggType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSAnleggType` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSBeregninsperiode`
--

DROP TABLE IF EXISTS `EOSBeregninsperiode`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSBeregninsperiode` (
  `id` int(11) NOT NULL auto_increment,
  `hccId` int(11) NOT NULL,
  `sesong` int(11) NOT NULL default '1',
  `startDato` date NOT NULL,
  `sluttDato` date NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `hccId` (`hccId`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSByggKategori`
--

DROP TABLE IF EXISTS `EOSByggKategori`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSByggKategori` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSDoegnData`
--

DROP TABLE IF EXISTS `EOSDoegnData`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSDoegnData` (
  `id` int(11) NOT NULL auto_increment,
  `emalId` int(11) NOT NULL default '0',
  `dato` date NOT NULL default '0000-00-00',
  `time_1` float(10,3) default NULL,
  `time_2` float(10,3) default NULL,
  `time_3` float(10,3) default NULL,
  `time_4` float(10,3) default NULL,
  `time_5` float(10,3) default NULL,
  `time_6` float(10,3) default NULL,
  `time_7` float(10,3) default NULL,
  `time_8` float(10,3) default NULL,
  `time_9` float(10,3) default NULL,
  `time_10` float(10,3) default NULL,
  `time_11` float(10,3) default NULL,
  `time_12` float(10,3) default NULL,
  `time_13` float(10,3) default NULL,
  `time_14` float(10,3) default NULL,
  `time_15` float(10,3) default NULL,
  `time_16` float(10,3) default NULL,
  `time_17` float(10,3) default NULL,
  `time_18` float(10,3) default NULL,
  `time_19` float(10,3) default NULL,
  `time_20` float(10,3) default NULL,
  `time_21` float(10,3) default NULL,
  `time_22` float(10,3) default NULL,
  `time_23` float(10,3) default NULL,
  `time_24` float(10,3) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `emalId` (`emalId`,`dato`)
) ENGINE=MyISAM AUTO_INCREMENT=24898924 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSEnergiEnhet`
--

DROP TABLE IF EXISTS `EOSEnergiEnhet`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSEnergiEnhet` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `eanlId` int(11) NOT NULL,
  `inMalerId` int(11) default NULL,
  `diffMalerId` int(11) default NULL,
  `utMalerId` int(11) default NULL,
  `vproId` int(11) default NULL,
  `beskr` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `eanlId` (`eanlId`),
  KEY `inMalerId` (`inMalerId`),
  KEY `utMalerId` (`utMalerId`),
  KEY `vproId` (`vproId`)
) ENGINE=MyISAM AUTO_INCREMENT=967 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSKategori`
--

DROP TABLE IF EXISTS `EOSKategori`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSKategori` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(30) NOT NULL,
  `beskr` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSKunde`
--

DROP TABLE IF EXISTS `EOSKunde`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSKunde` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(120) NOT NULL,
  `kundeNr` varchar(40) default NULL,
  `orgNr` varchar(40) default NULL,
  `adresse1` varchar(50) default NULL,
  `adresse2` varchar(50) default NULL,
  `postnr` char(6) default NULL,
  `poststed` varchar(30) default NULL,
  `land` varchar(30) default NULL,
  `tlfNo1` varchar(20) default NULL,
  `tlfNo2` varchar(20) default NULL,
  `faks` varchar(20) default NULL,
  `email` varchar(100) default NULL,
  `kommentar` text,
  `ekatId` int(11) NOT NULL,
  `worgId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `ekatId` (`ekatId`),
  KEY `worgId` (`worgId`)
) ENGINE=MyISAM AUTO_INCREMENT=565 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSKundeKontakt`
--

DROP TABLE IF EXISTS `EOSKundeKontakt`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSKundeKontakt` (
  `id` int(11) NOT NULL auto_increment,
  `kundeId` int(11) NOT NULL,
  `persNavn` varchar(50) NOT NULL,
  `epostAdr` varchar(50) default NULL,
  `mobilNr` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `kundeId` (`kundeId`)
) ENGINE=MyISAM AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSLagretBeregning`
--

DROP TABLE IF EXISTS `EOSLagretBeregning`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSLagretBeregning` (
  `id` int(11) NOT NULL auto_increment,
  `anovId` int(11) NOT NULL,
  `metode` int(11) NOT NULL default '1',
  `opprettet` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `anovId` (`anovId`)
) ENGINE=MyISAM AUTO_INCREMENT=255 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSMaler`
--

DROP TABLE IF EXISTS `EOSMaler`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSMaler` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `serialId` varchar(30) default NULL,
  `beskr` varchar(80) default NULL,
  `gruppe` varchar(10) default NULL,
  `enhet` varchar(10) default NULL,
  `instYtelse` int(11) default NULL,
  `startTellerstand` float(10,3) NOT NULL default '0.000',
  `startTidspunkt` datetime default NULL,
  `stoppTellerstand` float(10,3) default NULL,
  `stoppTidspunkt` datetime default NULL,
  `datakilde` smallint(6) NOT NULL default '0',
  `opplosning` smallint(6) NOT NULL default '0',
  `xFaktor` float(10,3) NOT NULL default '1.000',
  `aFaktor` float(10,3) NOT NULL default '0.000',
  `impPrKWh` float(10,3) default NULL,
  `info1` varchar(10) default NULL,
  `info2` varchar(10) default NULL,
  `info3` varchar(10) default NULL,
  `info4` varchar(10) default NULL,
  `notater` text,
  `limitMin` int(11) default NULL,
  `limitMax` int(11) default NULL,
  `mtypId` int(11) NOT NULL,
  `eanlId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `mtypId` (`mtypId`),
  KEY `eanlId` (`eanlId`)
) ENGINE=MyISAM AUTO_INCREMENT=1253 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSMalerType`
--

DROP TABLE IF EXISTS `EOSMalerType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSMalerType` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSOppsettBeregning`
--

DROP TABLE IF EXISTS `EOSOppsettBeregning`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSOppsettBeregning` (
  `id` int(11) NOT NULL auto_increment,
  `anovId` int(11) NOT NULL,
  `vinterTemp1` float(6,2) default NULL,
  `vinterTemp2` float(6,2) default NULL,
  `sommerTemp1` float(6,2) default NULL,
  `sommerTemp2` float(6,2) default NULL,
  `et_A` float(8,2) NOT NULL,
  `et_B` float(8,2) NOT NULL,
  `p11` float(6,2) NOT NULL,
  `p12` float(6,2) NOT NULL,
  `p21` float(6,2) NOT NULL,
  `p22` float(6,2) NOT NULL,
  `q11` float(6,2) NOT NULL,
  `q12` float(6,2) NOT NULL,
  `q21` float(6,2) NOT NULL,
  `q22` float(6,2) NOT NULL,
  `rVal` float(6,2) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `anovId` (`anovId`)
) ENGINE=MyISAM AUTO_INCREMENT=376 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSOversiktEnhet`
--

DROP TABLE IF EXISTS `EOSOversiktEnhet`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSOversiktEnhet` (
  `id` int(11) NOT NULL auto_increment,
  `anovId` int(11) NOT NULL,
  `eunitId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `anovId` (`anovId`,`eunitId`),
  KEY `eunitId` (`eunitId`)
) ENGINE=MyISAM AUTO_INCREMENT=969 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSRekurLagret`
--

DROP TABLE IF EXISTS `EOSRekurLagret`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSRekurLagret` (
  `id` int(11) NOT NULL auto_increment,
  `rccId` int(11) NOT NULL,
  `vinterStart` date NOT NULL,
  `vinterSlutt` date NOT NULL,
  `sommerStart` date NOT NULL,
  `sommerSlutt` date NOT NULL,
  `opprettet` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `rccId` (`rccId`)
) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSRekursivBeregning`
--

DROP TABLE IF EXISTS `EOSRekursivBeregning`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSRekursivBeregning` (
  `id` int(11) NOT NULL auto_increment,
  `anovId` int(11) NOT NULL,
  `aktiv` smallint(6) NOT NULL default '1',
  `startDato` date default NULL,
  `oppdatert` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `anovId` (`anovId`)
) ENGINE=MyISAM AUTO_INCREMENT=244 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSTellerstand`
--

DROP TABLE IF EXISTS `EOSTellerstand`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSTellerstand` (
  `id` int(11) NOT NULL auto_increment,
  `emalId` int(11) NOT NULL,
  `tidspunkt` datetime NOT NULL,
  `tellerstand` double(15,3) NOT NULL,
  `sesjon` varchar(16) default NULL,
  PRIMARY KEY  (`id`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=428 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSTempMaler`
--

DROP TABLE IF EXISTS `EOSTempMaler`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSTempMaler` (
  `id` int(11) NOT NULL auto_increment,
  `eanlId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `eanlId` (`eanlId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSTimeKonstanter`
--

DROP TABLE IF EXISTS `EOSTimeKonstanter`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSTimeKonstanter` (
  `id` int(11) NOT NULL auto_increment,
  `tempIdx` int(11) NOT NULL,
  `profil` int(11) NOT NULL,
  `dagTime` int(11) NOT NULL,
  `et_A` float(6,2) NOT NULL,
  `et_B` float(6,2) NOT NULL,
  `p11` float(6,2) NOT NULL,
  `p12` float(6,2) NOT NULL,
  `p21` float(6,2) NOT NULL,
  `p22` float(6,2) NOT NULL,
  `antall` int(11) NOT NULL default '0',
  `dato` date default NULL,
  `rccId` int(11) default NULL,
  `hccId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `rccId` (`rccId`),
  KEY `hccId` (`hccId`)
) ENGINE=MyISAM AUTO_INCREMENT=162269 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSVGProfil`
--

DROP TABLE IF EXISTS `EOSVGProfil`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSVGProfil` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `mtypId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `mtypId` (`mtypId`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EOSVirkningsgrader`
--

DROP TABLE IF EXISTS `EOSVirkningsgrader`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EOSVirkningsgrader` (
  `id` int(11) NOT NULL auto_increment,
  `vproId` int(11) NOT NULL,
  `effekt` float(3,2) NOT NULL,
  `vgrad` float(3,2) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `vproId` (`vproId`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ESSAnleggTaxameter`
--

DROP TABLE IF EXISTS `ESSAnleggTaxameter`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ESSAnleggTaxameter` (
  `id` int(11) NOT NULL auto_increment,
  `eanlId` int(11) NOT NULL,
  `alias` varchar(20) NOT NULL,
  `vTaxmData` smallint(6) NOT NULL default '1',
  `pincode` varchar(10) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `alias` (`alias`),
  KEY `eanlId` (`eanlId`)
) ENGINE=MyISAM AUTO_INCREMENT=144 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ESSAnleggTjenester`
--

DROP TABLE IF EXISTS `ESSAnleggTjenester`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ESSAnleggTjenester` (
  `id` int(11) NOT NULL auto_increment,
  `eanlId` int(11) NOT NULL,
  `tjenesteId` int(11) NOT NULL,
  `vAktiv` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `eanlId` (`eanlId`,`tjenesteId`),
  KEY `tjenesteId` (`tjenesteId`)
) ENGINE=MyISAM AUTO_INCREMENT=411 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ESSTaxmOppsett`
--

DROP TABLE IF EXISTS `ESSTaxmOppsett`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ESSTaxmOppsett` (
  `id` int(11) NOT NULL auto_increment,
  `eanlId` int(11) NOT NULL,
  `vTaxmData` smallint(6) NOT NULL default '1',
  `pincode` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ESSTjeneste`
--

DROP TABLE IF EXISTS `ESSTjeneste`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ESSTjeneste` (
  `id` int(11) NOT NULL auto_increment,
  `kode` varchar(20) NOT NULL,
  `navn` varchar(50) NOT NULL,
  `tag` char(2) NOT NULL,
  `beskr` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `kode` (`kode`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EntityLabels`
--

DROP TABLE IF EXISTS `EntityLabels`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EntityLabels` (
  `id` int(11) NOT NULL auto_increment,
  `langCode` char(5) NOT NULL,
  `modul` varchar(10) NOT NULL,
  `entityName` varchar(20) NOT NULL,
  `entityId` int(11) NOT NULL,
  `label` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `GroupMembers`
--

DROP TABLE IF EXISTS `GroupMembers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `GroupMembers` (
  `id` int(11) NOT NULL auto_increment,
  `wgrpId` int(11) NOT NULL default '0',
  `wusrId` int(11) NOT NULL default '0',
  `role` varchar(30) default NULL,
  `accessCode` varchar(30) default NULL,
  PRIMARY KEY  (`id`),
  KEY `wgrpId` (`wgrpId`),
  KEY `wusrId` (`wusrId`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `HL3Logg`
--

DROP TABLE IF EXISTS `HL3Logg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `HL3Logg` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL default '0',
  `serverTid` datetime NOT NULL default '0000-00-00 00:00:00',
  `terminalTid` datetime NOT NULL default '0000-00-00 00:00:00',
  `temp` tinyint(3) NOT NULL default '0',
  `severity` tinyint(3) unsigned default NULL,
  `event` tinyint(3) unsigned default NULL,
  `value` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`)
) ENGINE=MyISAM AUTO_INCREMENT=7053563 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `HitDocRefs`
--

DROP TABLE IF EXISTS `HitDocRefs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `HitDocRefs` (
  `refId` int(11) NOT NULL,
  `vCount` int(11) NOT NULL default '1',
  `refType` smallint(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `IPBlackList`
--

DROP TABLE IF EXISTS `IPBlackList`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `IPBlackList` (
  `ip` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSBryterMelding`
--

DROP TABLE IF EXISTS `LMSBryterMelding`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSBryterMelding` (
  `id` int(11) NOT NULL auto_increment,
  `lprodId` int(11) NOT NULL,
  `lastgId` int(11) default NULL,
  `gruppeId` int(11) default NULL,
  `status` smallint(6) NOT NULL,
  `startSekv` datetime NOT NULL,
  `startTid` datetime NOT NULL,
  `startTS` datetime NOT NULL,
  `varighet` int(11) NOT NULL,
  `varsling` int(11) NOT NULL,
  `stoppTid` datetime default NULL,
  `statusTekst` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `lprodId` (`lprodId`)
) ENGINE=MyISAM AUTO_INCREMENT=15055 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSDriftsPersonell`
--

DROP TABLE IF EXISTS `LMSDriftsPersonell`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSDriftsPersonell` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `telefon` varchar(20) NOT NULL,
  `epostAdr` varchar(50) NOT NULL,
  `varsling` smallint(6) NOT NULL default '1',
  `statusAvs` smallint(6) default '9',
  `limitTerm` smallint(6) default '2',
  `limitTimer` smallint(6) default '2',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSEffektRapport`
--

DROP TABLE IF EXISTS `LMSEffektRapport`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSEffektRapport` (
  `id` int(11) NOT NULL auto_increment,
  `lastgId` int(11) NOT NULL,
  `intervall` smallint(6) NOT NULL,
  `antRunder` smallint(6) NOT NULL,
  `antEnheter` smallint(6) NOT NULL,
  `tidspunkt` datetime NOT NULL,
  `startTid` datetime default NULL,
  `sluttTid` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `lastgId` (`lastgId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSEffektRptLinje`
--

DROP TABLE IF EXISTS `LMSEffektRptLinje`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSEffektRptLinje` (
  `id` int(11) NOT NULL auto_increment,
  `erptId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  `runde` smallint(6) NOT NULL,
  `effekt` int(11) default NULL,
  `statusTekst` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `erptId` (`erptId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSEffektStatus`
--

DROP TABLE IF EXISTS `LMSEffektStatus`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSEffektStatus` (
  `id` int(11) NOT NULL auto_increment,
  `srptId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  `effekt` int(11) default NULL,
  `statusTekst` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `srptId` (`srptId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=2726 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSGruppeSnr`
--

DROP TABLE IF EXISTS `LMSGruppeSnr`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSGruppeSnr` (
  `nr` int(11) NOT NULL auto_increment,
  `lastgId` int(11) NOT NULL,
  `tidstempel` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`nr`)
) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSIOPortStatus`
--

DROP TABLE IF EXISTS `LMSIOPortStatus`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSIOPortStatus` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `srptId` int(11) NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`),
  KEY `srptId` (`srptId`)
) ENGINE=MyISAM AUTO_INCREMENT=24821 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSKontrakt`
--

DROP TABLE IF EXISTS `LMSKontrakt`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSKontrakt` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `kategori` smallint(6) NOT NULL default '0',
  `tilgang` smallint(6) NOT NULL default '1',
  `ant_utkobl_dag` smallint(6) default NULL,
  `ant_utkobl_uke` smallint(6) default NULL,
  `utkoblIntervall` int(11) default NULL,
  `varighetUtkobl` int(11) default NULL,
  `tillattFra` time default NULL,
  `tillattTil` time default NULL,
  `varslingstid` int(11) default NULL,
  `kommentarer` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSKontraktGruppe`
--

DROP TABLE IF EXISTS `LMSKontraktGruppe`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSKontraktGruppe` (
  `id` int(11) NOT NULL auto_increment,
  `kontrId` int(11) NOT NULL,
  `lastgId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kontrId` (`kontrId`),
  KEY `lastgId` (`lastgId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSLastGruppe`
--

DROP TABLE IF EXISTS `LMSLastGruppe`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSLastGruppe` (
  `id` int(11) NOT NULL auto_increment,
  `eierId` int(11) NOT NULL,
  `kontrId` int(11) NOT NULL,
  `navn` varchar(50) NOT NULL,
  `kommentarer` text,
  `sendVarsel` smallint(6) NOT NULL,
  `vEmneEpost` varchar(255) default NULL,
  `vAktivEpost` text,
  `vDeaktivEpost` text,
  `vAktivSMS` varchar(255) default NULL,
  `vDeaktivSMS` varchar(255) default NULL,
  `effektLimit1` int(11) default NULL,
  `effektLimit2` int(11) default '0',
  `limitTimer` smallint(6) default '2',
  `vTelefonListe` varchar(200) default NULL,
  `erptAktiv` smallint(6) NOT NULL default '0',
  `erptInterval` smallint(6) default NULL,
  `erptVarighet` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `kontrId` (`kontrId`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSLastProdukt`
--

DROP TABLE IF EXISTS `LMSLastProdukt`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSLastProdukt` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `kontrId` int(11) NOT NULL,
  `lastgId` int(11) default NULL,
  `kundeId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  `portIO` char(2) NOT NULL default 'DO',
  `portNr` smallint(6) NOT NULL,
  `effektLimit` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`),
  KEY `kontrId` (`kontrId`),
  KEY `lastgId` (`lastgId`),
  KEY `kundeId` (`kundeId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=1261 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSMalServiceMsg`
--

DROP TABLE IF EXISTS `LMSMalServiceMsg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSMalServiceMsg` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `melding` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSMalerInput`
--

DROP TABLE IF EXISTS `LMSMalerInput`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSMalerInput` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  `input` char(2) NOT NULL,
  `portNr` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `termId` (`termId`,`emalId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=1286 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSOperator`
--

DROP TABLE IF EXISTS `LMSOperator`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSOperator` (
  `id` int(11) NOT NULL auto_increment,
  `wgrpId` int(11) NOT NULL,
  `telefonNr` varchar(20) default NULL,
  `epostAdr` varchar(50) default NULL,
  `epostSmtp` varchar(30) default NULL,
  `epostEmne` varchar(200) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `wgrpId` (`wgrpId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSProdRapport`
--

DROP TABLE IF EXISTS `LMSProdRapport`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSProdRapport` (
  `id` int(11) NOT NULL auto_increment,
  `operId` int(11) NOT NULL,
  `navn` varchar(50) NOT NULL,
  `vTimeData` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `operId` (`operId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSProdRptEnhet`
--

DROP TABLE IF EXISTS `LMSProdRptEnhet`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSProdRptEnhet` (
  `id` int(11) NOT NULL auto_increment,
  `prptId` int(11) NOT NULL,
  `eunitId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `prptId` (`prptId`,`eunitId`),
  KEY `eunitId` (`eunitId`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSProsessLogg`
--

DROP TABLE IF EXISTS `LMSProsessLogg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSProsessLogg` (
  `id` int(11) NOT NULL auto_increment,
  `prosId` int(11) NOT NULL,
  `tidspunkt` datetime NOT NULL,
  `tilstandStr` varchar(250) NOT NULL,
  `tilstandVal` int(11) NOT NULL,
  `varsUUID` varchar(100) default NULL,
  PRIMARY KEY  (`id`),
  KEY `prosId` (`prosId`)
) ENGINE=MyISAM AUTO_INCREMENT=129583 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSProsesstilstand`
--

DROP TABLE IF EXISTS `LMSProsesstilstand`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSProsesstilstand` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `prosess` varchar(50) NOT NULL,
  `portIO` char(2) NOT NULL default 'DI',
  `portNr` smallint(6) NOT NULL,
  `delay` smallint(6) NOT NULL,
  `tilst0` varchar(250) default NULL,
  `tilst1` varchar(250) default NULL,
  `tilst0val` int(11) default '0',
  `tilst1val` int(11) default '1',
  `pvType` smallint(6) default '1',
  `vDeaktiv` smallint(6) default '0',
  `emalId` int(11) default NULL,
  `lastgId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`),
  KEY `emalId` (`emalId`),
  KEY `lastgId` (`lastgId`)
) ENGINE=MyISAM AUTO_INCREMENT=1014 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSPulsTeller`
--

DROP TABLE IF EXISTS `LMSPulsTeller`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSPulsTeller` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL default '0',
  `emalId` int(11) NOT NULL default '0',
  `portIO` char(2) NOT NULL default '',
  `portNr` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `termId` (`termId`,`emalId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=1145 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSServiceMsg`
--

DROP TABLE IF EXISTS `LMSServiceMsg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSServiceMsg` (
  `id` int(11) NOT NULL auto_increment,
  `tmsgId` int(11) NOT NULL,
  `eanlId` int(11) NOT NULL,
  `emalId` int(11) NOT NULL,
  `tidspunkt` time NOT NULL,
  `regel` varchar(10) NOT NULL,
  `weekDays` char(7) default NULL,
  `weekRef` int(11) default NULL,
  `months` char(12) default NULL,
  `dayNr` int(11) default NULL,
  `startDato` date default NULL,
  `tsSent` datetime default NULL,
  `tittel` varchar(100) default NULL,
  `tekst` text,
  PRIMARY KEY  (`id`),
  KEY `tmsgId` (`tmsgId`),
  KEY `eanlId` (`eanlId`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSStatusRapport`
--

DROP TABLE IF EXISTS `LMSStatusRapport`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSStatusRapport` (
  `id` int(11) NOT NULL auto_increment,
  `tidspunkt` datetime NOT NULL,
  `lastgId` int(11) NOT NULL,
  `rptType` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `lastgId` (`lastgId`)
) ENGINE=MyISAM AUTO_INCREMENT=442 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSTellerstand`
--

DROP TABLE IF EXISTS `LMSTellerstand`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSTellerstand` (
  `id` int(11) NOT NULL auto_increment,
  `emalId` int(11) NOT NULL default '0',
  `klientTid` varchar(10) NOT NULL default '',
  `serverTid` datetime NOT NULL default '0000-00-00 00:00:00',
  `tellerstand` bigint(20) NOT NULL default '0',
  `tidsstempel` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `emalId` (`emalId`)
) ENGINE=MyISAM AUTO_INCREMENT=26306289 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSTerminal`
--

DROP TABLE IF EXISTS `LMSTerminal`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSTerminal` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(50) NOT NULL,
  `adresse` varchar(50) default NULL,
  `oppslagId` varchar(30) default NULL,
  `ip_adresse` varchar(30) default NULL,
  `gsm_nr` varchar(30) default NULL,
  `brukernavn` varchar(30) default NULL,
  `passord` varchar(30) default NULL,
  `rtypId` int(11) NOT NULL,
  `eanlId` int(11) NOT NULL,
  `vpStart` datetime default NULL,
  `vpSlutt` datetime default NULL,
  `vpReg` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `rtypId` (`rtypId`),
  KEY `eanlId` (`eanlId`)
) ENGINE=MyISAM AUTO_INCREMENT=777 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSTerminalIO`
--

DROP TABLE IF EXISTS `LMSTerminalIO`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSTerminalIO` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `IOId` int(11) default NULL,
  `IOType` int(11) default NULL,
  `navn` varchar(10) NOT NULL,
  `beskrivelse` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSTerminalStatus`
--

DROP TABLE IF EXISTS `LMSTerminalStatus`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSTerminalStatus` (
  `id` int(11) NOT NULL auto_increment,
  `termId` int(11) NOT NULL,
  `srptId` int(11) NOT NULL,
  `serverTid` datetime NOT NULL,
  `klientTid` varchar(15) default NULL,
  `signalReal` int(11) default NULL,
  `signalMax` int(11) default NULL,
  `signalMin` int(11) default NULL,
  `antPowerUp` int(11) default NULL,
  `antReset` int(11) default NULL,
  `channel` int(11) default NULL,
  `dBm` int(11) default NULL,
  `RS` int(11) default NULL,
  `cell` int(11) default NULL,
  `statusTekst` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `termId` (`termId`),
  KEY `srptId` (`srptId`)
) ENGINE=MyISAM AUTO_INCREMENT=8862 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSTerminalType`
--

DROP TABLE IF EXISTS `LMSTerminalType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSTerminalType` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(20) NOT NULL,
  `itermCls` varchar(50) NOT NULL,
  `pulsInngRX` int(11) default NULL,
  `pulsInngRY` int(11) default NULL,
  `digitUtgRX` int(11) default NULL,
  `digitUtgRY` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSVarselLogg`
--

DROP TABLE IF EXISTS `LMSVarselLogg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSVarselLogg` (
  `id` int(11) NOT NULL auto_increment,
  `varsId` int(11) NOT NULL,
  `mottakerAdr` varchar(50) NOT NULL,
  `mottakerNavn` varchar(50) NOT NULL,
  `statusTekst` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `varsId` (`varsId`)
) ENGINE=MyISAM AUTO_INCREMENT=61675 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSVarsling`
--

DROP TABLE IF EXISTS `LMSVarsling`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSVarsling` (
  `id` int(11) NOT NULL auto_increment,
  `operId` int(11) NOT NULL,
  `eanlId` int(11) NOT NULL,
  `status` smallint(6) NOT NULL,
  `tidspunkt` datetime NOT NULL,
  `UUID` varchar(100) NOT NULL,
  `refId` varchar(30) NOT NULL,
  `kode` varchar(20) NOT NULL,
  `tittel` varchar(20) default NULL,
  `mailSubj` varchar(100) default NULL,
  `mailTekst` text,
  `smsTekst` text,
  `systemTS` datetime default NULL,
  `event` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `operId` (`operId`),
  KEY `eanlId` (`eanlId`)
) ENGINE=MyISAM AUTO_INCREMENT=35062 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LMSVarslingsPerson`
--

DROP TABLE IF EXISTS `LMSVarslingsPerson`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LMSVarslingsPerson` (
  `id` int(11) NOT NULL auto_increment,
  `kunkId` int(11) NOT NULL,
  `eanlId` int(11) NOT NULL,
  `varsling` char(1) NOT NULL default 'E',
  `vRkom` smallint(6) NOT NULL default '0',
  `vTariff` smallint(6) NOT NULL default '0',
  `vSpot` smallint(6) NOT NULL default '0',
  `vProsess` smallint(6) NOT NULL default '0',
  `vEffekt` smallint(6) NOT NULL default '0',
  `vTaxam` smallint(6) NOT NULL default '0',
  `vService` smallint(6) NOT NULL default '0',
  `vAvvik` smallint(6) NOT NULL default '0',
  `vProsess2` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `kunkId` (`kunkId`),
  KEY `eanlId` (`eanlId`)
) ENGINE=MyISAM AUTO_INCREMENT=1339 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LoginAttempts`
--

DROP TABLE IF EXISTS `LoginAttempts`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LoginAttempts` (
  `userName` varchar(30) NOT NULL,
  `date` datetime NOT NULL,
  `status` varchar(50) NOT NULL,
  `traceText` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ModuleFeature`
--

DROP TABLE IF EXISTS `ModuleFeature`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ModuleFeature` (
  `id` int(11) NOT NULL auto_increment,
  `modul` varchar(10) NOT NULL,
  `nr` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `label` varchar(50) NOT NULL,
  `href` varchar(100) default NULL,
  `enabled` smallint(6) NOT NULL default '1',
  `accLevel` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `modul` (`modul`,`nr`),
  UNIQUE KEY `modul_2` (`modul`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ModuleFolders`
--

DROP TABLE IF EXISTS `ModuleFolders`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ModuleFolders` (
  `id` int(11) NOT NULL auto_increment,
  `wappId` int(11) NOT NULL default '1',
  `wmodId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `objName` varchar(20) NOT NULL,
  `entity` varchar(20) NOT NULL,
  `fPublic` smallint(6) NOT NULL default '1',
  `entityCls` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `wmodId` (`wmodId`,`entity`),
  KEY `wappId` (`wappId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ModuleMembers`
--

DROP TABLE IF EXISTS `ModuleMembers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ModuleMembers` (
  `id` int(11) NOT NULL auto_increment,
  `wmodId` int(11) NOT NULL,
  `wusrId` int(11) NOT NULL,
  `accLevel` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `wmodId` (`wmodId`,`wusrId`),
  KEY `wusrId` (`wusrId`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ModuleProperty`
--

DROP TABLE IF EXISTS `ModuleProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ModuleProperty` (
  `id` int(11) NOT NULL auto_increment,
  `modul` varchar(10) NOT NULL,
  `name` varchar(40) NOT NULL,
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `modul` (`modul`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ServiceDefs`
--

DROP TABLE IF EXISTS `ServiceDefs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ServiceDefs` (
  `id` int(11) NOT NULL auto_increment,
  `module` varchar(10) NOT NULL,
  `name` varchar(20) NOT NULL,
  `clsName` varchar(200) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `module` (`module`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `UserCookies`
--

DROP TABLE IF EXISTS `UserCookies`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `UserCookies` (
  `id` int(11) NOT NULL auto_increment,
  `wusrId` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `value` varchar(80) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `wusrId` (`wusrId`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WFSActionHooks`
--

DROP TABLE IF EXISTS `WFSActionHooks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WFSActionHooks` (
  `id` int(11) NOT NULL auto_increment,
  `docType` varchar(20) NOT NULL,
  `modul` varchar(10) NOT NULL,
  `code` varchar(20) NOT NULL,
  `handler` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WFSFolder`
--

DROP TABLE IF EXISTS `WFSFolder`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WFSFolder` (
  `id` int(11) NOT NULL auto_increment,
  `librId` int(11) NOT NULL,
  `modul` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `path` varchar(100) NOT NULL,
  `status` smallint(6) NOT NULL default '0',
  `autoSync` smallint(6) NOT NULL default '1',
  `sindex` smallint(6) NOT NULL default '0',
  `refKey` varchar(20) default NULL,
  `iconImage` varchar(255) default NULL,
  `maxSize` int(11) default NULL,
  `maxDim` int(11) default NULL,
  `prefDim` int(11) default NULL,
  `thumbDim` int(11) default NULL,
  `createdBy` varchar(40) default NULL,
  `createdDate` datetime default NULL,
  `dirDate` date default NULL,
  PRIMARY KEY  (`id`),
  KEY `librId` (`librId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WFSLibrary`
--

DROP TABLE IF EXISTS `WFSLibrary`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WFSLibrary` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `docType` varchar(20) NOT NULL,
  `path` varchar(100) NOT NULL,
  `wappId` int(11) NOT NULL default '1',
  `maxSize` int(11) default NULL,
  `maxDim` int(11) default NULL,
  `prefDim` int(11) default NULL,
  `thumbDim` int(11) default NULL,
  `tagLabel1` varchar(50) default NULL,
  `tagLabel2` varchar(50) default NULL,
  `tagLabel3` varchar(50) default NULL,
  `tagLabel4` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  KEY `wappId` (`wappId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebAppl`
--

DROP TABLE IF EXISTS `WebAppl`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebAppl` (
  `id` int(11) NOT NULL auto_increment,
  `webBase` varchar(100) NOT NULL,
  `baseDir` varchar(150) NOT NULL,
  `mediaDir` varchar(20) NOT NULL,
  `appName` varchar(50) default NULL,
  `appVersion` varchar(10) default NULL,
  `context` varchar(20) default NULL,
  `locale` varchar(10) default NULL,
  `smtpServer` varchar(80) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebFiles`
--

DROP TABLE IF EXISTS `WebFiles`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebFiles` (
  `id` int(11) NOT NULL auto_increment,
  `wappId` int(11) NOT NULL default '1',
  `ownerId` int(11) NOT NULL,
  `librId` int(11) NOT NULL,
  `fileLen` int(11) NOT NULL default '0',
  `urlPath` varchar(100) NOT NULL,
  `relPath` varchar(10) default '',
  `fname` varchar(100) NOT NULL,
  `modul` varchar(10) NOT NULL,
  `descr` varchar(200) default NULL,
  `href` varchar(200) default NULL,
  `thumb` varchar(200) default NULL,
  `tagTxt1` varchar(100) default NULL,
  `tagTxt2` varchar(100) default NULL,
  `tagTxt3` varchar(100) default NULL,
  `tagTxt4` varchar(100) default NULL,
  `owner` varchar(40) default NULL,
  `createdBy` varchar(40) default NULL,
  `createdDate` datetime default NULL,
  `modifiedBy` varchar(40) default NULL,
  `modifiedDate` datetime default NULL,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  `foldId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `librId` (`librId`),
  KEY `wappId` (`wappId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebGroups`
--

DROP TABLE IF EXISTS `WebGroups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebGroups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `descr` varchar(100) default NULL,
  `defRole` varchar(50) default NULL,
  `modul` varchar(10) default NULL,
  `worgId` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebHitCount`
--

DROP TABLE IF EXISTS `WebHitCount`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebHitCount` (
  `vYear` smallint(6) NOT NULL,
  `vMonth` smallint(6) NOT NULL,
  `vDay` smallint(6) NOT NULL,
  `vCount` int(11) NOT NULL default '1',
  `langCode` char(5) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebHitEntity`
--

DROP TABLE IF EXISTS `WebHitEntity`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebHitEntity` (
  `entity` varchar(40) NOT NULL,
  `refId` int(11) NOT NULL,
  `vCount` int(11) NOT NULL default '1',
  UNIQUE KEY `refId` (`refId`,`entity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebHitHosts`
--

DROP TABLE IF EXISTS `WebHitHosts`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebHitHosts` (
  `vID` varchar(40) NOT NULL,
  `vDate` date default NULL,
  UNIQUE KEY `vID` (`vID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebLangs`
--

DROP TABLE IF EXISTS `WebLangs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebLangs` (
  `id` int(11) NOT NULL auto_increment,
  `code` char(5) NOT NULL,
  `name` varchar(20) NOT NULL,
  `active` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebModules`
--

DROP TABLE IF EXISTS `WebModules`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebModules` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(10) NOT NULL,
  `label` varchar(40) default NULL,
  `clsName` varchar(100) default NULL,
  `visible` smallint(6) default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebOrg`
--

DROP TABLE IF EXISTS `WebOrg`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebOrg` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `address` varchar(120) default NULL,
  `zipCode` varchar(10) default NULL,
  `zipCity` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `refPerson` varchar(100) default NULL,
  `eMail` varchar(80) default NULL,
  `homePage` varchar(120) default NULL,
  `logoHref` varchar(100) default NULL,
  `phoneNr1` varchar(20) default NULL,
  `phoneNr2` varchar(20) default NULL,
  `faxNr` varchar(20) default NULL,
  `orgNr` varchar(20) default NULL,
  `refNr1` varchar(20) default NULL,
  `refNr2` varchar(20) default NULL,
  `ownerId` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebOrgRoles`
--

DROP TABLE IF EXISTS `WebOrgRoles`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebOrgRoles` (
  `id` int(11) NOT NULL auto_increment,
  `worgId` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `wusrId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `worgId` (`worgId`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebProperty`
--

DROP TABLE IF EXISTS `WebProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebProperty` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `value` varchar(30) NOT NULL,
  `title` varchar(200) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `WebUsers`
--

DROP TABLE IF EXISTS `WebUsers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WebUsers` (
  `id` int(11) NOT NULL auto_increment,
  `userName` varchar(100) NOT NULL,
  `passWd` varchar(200) NOT NULL default '',
  `screenName` varchar(100) default NULL,
  `email` varchar(100) default NULL,
  `userNr` varchar(10) default NULL,
  `phoneNr` varchar(20) default NULL,
  `startDate` datetime default NULL,
  `endDate` datetime default NULL,
  `lastLogin` datetime default NULL,
  `accessLevel` smallint(6) NOT NULL default '0',
  `defModule` varchar(10) default NULL,
  `loginRedir` varchar(50) default NULL,
  `numLogins` int(11) default '0',
  `groupId` int(11) default NULL,
  `worgId` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userName` (`userName`),
  KEY `worgId` (`worgId`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-02-04 15:23:45