-- phpMyAdmin SQL Dump
-- version 2.10.3deb1ubuntu0.2
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Lun 09 Juin 2008 à 23:26
-- Version du serveur: 5.0.45
-- Version de PHP: 5.2.3-1ubuntu6.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Base de données: `caisse`
-- 

-- --------------------------------------------------------

-- 
-- Structure de la table `family`
-- 

CREATE TABLE IF NOT EXISTS `family` (
  `Fam` int(2) NOT NULL auto_increment,
  `nameFam` varchar(56) collate utf8_bin NOT NULL COMMENT 'Nom de famille',
  PRIMARY KEY  (`Fam`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Famille d''articles' AUTO_INCREMENT=7 ;

-- 
-- Contenu de la table `family`
-- 

INSERT INTO `family` (`Fam`, `nameFam`) VALUES 
(1, 0x4a4f5552),
(2, 0x534f4952),
(3, 0x5350c3894349414c4954c38953),
(4, 0x454e5452c3894553204d494449),
(5, 0x50c382544553204d494449),
(6, 0x5649414e444553204d494449);

-- --------------------------------------------------------

-- 
-- Structure de la table `gestion_buttons`
-- 

CREATE TABLE IF NOT EXISTS `gestion_buttons` (
  `ref` tinyint(2) NOT NULL auto_increment,
  `groups` int(1) NOT NULL,
  `label` varchar(24) collate utf8_bin NOT NULL,
  `pos` tinyint(1) NOT NULL COMMENT 'button position',
  `valid` set('0','1','2') collate utf8_bin NOT NULL default '0' COMMENT 'button actif(1) or not(0)',
  PRIMARY KEY  (`ref`),
  KEY `groups` (`groups`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='fixe button''s page' AUTO_INCREMENT=29 ;

-- 
-- Contenu de la table `gestion_buttons`
-- 

INSERT INTO `gestion_buttons` (`ref`, `groups`, `label`, `pos`, `valid`) VALUES 
(1, 0, 0x424152, 0, 0x30),
(2, 0, 0x425241535345524945, 1, 0x31),
(3, 0, 0x534e41434b, 2, 0x30),
(4, 0, 0x52455354415552414e543c62723e4d494449, 3, 0x32),
(5, 0, 0x52455354415552414e543c62723e534f4952, 4, 0x30),
(6, 0, 0x43415645, 5, 0x30),
(7, 0, 0x434f4d50544f4952, 6, 0x30),
(8, 1, 0x43414c43554c, 0, 0x31),
(9, 1, 0x464f4e4354494f4e53, 1, 0x30),
(10, 1, 0x524543484552434845, 2, 0x30),
(11, 1, 0x4d45535341474520c38943524954, 3, 0x30),
(12, 1, 0x434f4d4d454e544149524553, 4, 0x30),
(13, 1, 0x4741524e495455524553, 5, 0x30),
(14, 1, 0x535550504cc3894d454e5453, 6, 0x30),
(15, 2, 0x5245544f5552, 0, 0x31),
(16, 2, 0x414e4e554c4154494f4e53, 1, 0x31),
(17, 2, 0x4f464645525453, 2, 0x31),
(18, 2, 0x444956455253, 3, 0x31),
(19, 2, 0x52c389474c454d454e5453, 4, 0x31),
(20, 2, 0x5452414e534645525453, 5, 0x31),
(21, 2, 0x41564543202d2053414e533c62723e5449434b455453, 6, 0x31),
(22, 3, 0x41444d494e, 0, 0x30),
(23, 3, 0x494d5052494d414e544553, 1, 0x30),
(24, 3, 0x5345525645555253, 2, 0x30),
(25, 3, 0x4c45435455524553, 3, 0x30),
(26, 3, 0x5449434b455453, 4, 0x30),
(27, 3, 0x434f44452056454e44455552, 5, 0x30),
(28, 3, 0x5449524f4952, 6, 0x30);

-- --------------------------------------------------------

-- 
-- Structure de la table `gestion_groups`
-- 

CREATE TABLE IF NOT EXISTS `gestion_groups` (
  `ref` tinyint(1) NOT NULL auto_increment,
  `pos` tinyint(1) NOT NULL,
  `nameGroups` varchar(52) collate utf8_bin NOT NULL,
  `access` set('0','1','2','3') collate utf8_bin NOT NULL default '3',
  PRIMARY KEY  (`ref`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Gestion Area' AUTO_INCREMENT=5 ;

-- 
-- Contenu de la table `gestion_groups`
-- 

INSERT INTO `gestion_groups` (`ref`, `pos`, `nameGroups`, `access`) VALUES 
(1, 0, 0x50616765732028706167657329, 0x30),
(2, 1, 0x536f75732046616d696c6c652028756e64657266616d696c7929, 0x30),
(3, 2, 0x6f7074696f6e73, 0x32),
(4, 3, 0x636f6e666967, 0x33);

-- --------------------------------------------------------

-- 
-- Structure de la table `label`
-- 

CREATE TABLE IF NOT EXISTS `label` (
  `ref` int(6) NOT NULL auto_increment,
  `pos` int(2) NOT NULL COMMENT 'button area',
  `pages` tinyint(1) NOT NULL default '0' COMMENT 'Page Group',
  `label` varchar(56) collate utf8_bin NOT NULL COMMENT 'Name of art or group',
  `layer` set('0','1','2','3') collate utf8_bin NOT NULL COMMENT 'art, or layer et level',
  `price` double NOT NULL,
  UNIQUE KEY `ref` (`ref`),
  KEY `pos` (`pos`),
  KEY `pages` (`pages`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables des articles' AUTO_INCREMENT=6 ;

-- 
-- Contenu de la table `label`
-- 

INSERT INTO `label` (`ref`, `pos`, `pages`, `label`, `layer`, `price`) VALUES 
(1, 2, 4, 0x456e74726563c3b47465, 0x30, 15),
(2, 3, 4, 0x456e74726563c3b47465207361756365, 0x31, 15.2),
(3, 14, 4, 0x476c61636573, 0x31, 8.92),
(4, 8, 2, 0x4a75732044274162726963c3b474, 0x31, 1.6),
(5, 13, 2, 0x50657272696572, 0x31, 3);
