-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 10, 2006 at 05:06 PM
-- Server version: 4.1.21
-- PHP Version: 5.1.4
-- 
-- Database: `sieblus`
-- 

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

-- 
-- Table structure for table `acces`
-- 

CREATE TABLE IF NOT EXISTS `acces` (
  `utilizator` varchar(30) binary NOT NULL default '',
  `pass` varchar(32) binary NOT NULL default ''
) TYPE=MyISAM COMMENT='Parole de acces pt utilizatori SIEBLUS';

-- 
-- Dumping data for table `acces`
-- 

INSERT INTO `acces` (`utilizator`, `pass`) VALUES (0x61646d696e, 0x3338313735393636346536326537613833396166313631643566646664653936),
(0x7075626c6963, 0x3338313735393636346536326537613833396166313631643566646664653936),
(0x6269626c696f7465636172, 0x3338313735393636346536326537613833396166313631643566646664653936);

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

-- 
-- Table structure for table `adresa`
-- 

CREATE TABLE IF NOT EXISTS `adresa` (
  `adresa_id` int(10) unsigned NOT NULL auto_increment,
  `cititor_id` int(10) unsigned NOT NULL default '0',
  `strada_id` int(10) unsigned NOT NULL default '0',
  `adresa_nr` varchar(8) binary NOT NULL default '',
  `adresa_bloc` varchar(10) binary NOT NULL default '',
  `adresa_scara` varchar(2) binary NOT NULL default '',
  `adresa_ap` varchar(4) binary NOT NULL default '',
  `adresa_cp` varchar(6) binary NOT NULL default '',
  PRIMARY KEY  (`adresa_id`),
  KEY `cititor_id` (`cititor_id`),
  KEY `cititor_id_2` (`cititor_id`),
  KEY `strada_id` (`strada_id`)
) TYPE=MyISAM COMMENT='adrese - legata de tabela strada si cititor' AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `adresa`
-- 


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

-- 
-- Table structure for table `carte`
-- 

CREATE TABLE IF NOT EXISTS `carte` (
  `carte_id` int(10) unsigned NOT NULL auto_increment,
  `carte_titlu` varchar(50) binary NOT NULL default '',
  `carte_autor` varchar(50) binary NOT NULL default '',
  `editura_id` smallint(6) NOT NULL default '0',
  `gen_id` smallint(6) NOT NULL default '0',
  `carte_pret` float(4,2) NOT NULL default '0.00',
  `carte_ISBN` varchar(10) binary NOT NULL default '',
  `carte_data_ap` date NOT NULL default '0000-00-00',
  `carte_pagini` smallint(6) NOT NULL default '0',
  `carte_comentariu` text NOT NULL,
  PRIMARY KEY  (`carte_id`),
  KEY `carte_titlu` (`carte_titlu`,`carte_autor`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `carte`
-- 


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

-- 
-- Table structure for table `cititor`
-- 

CREATE TABLE IF NOT EXISTS `cititor` (
  `cititor_id` int(10) unsigned NOT NULL auto_increment,
  `cititor_nume` varchar(50) binary NOT NULL default '',
  `cititor_prenume` varchar(50) binary NOT NULL default '',
  `cititor_serieCI` varchar(2) binary NOT NULL default '',
  `cititor_numarCI` varchar(6) binary NOT NULL default '',
  `cititor_CNP` varchar(13) binary NOT NULL default '',
  `cititor_datades` date NOT NULL default '0000-00-00' COMMENT 'data deschiderii contului',
  PRIMARY KEY  (`cititor_id`),
  KEY `cititor_nume` (`cititor_nume`,`cititor_prenume`),
  KEY `cititor_datades` (`cititor_datades`)
) TYPE=MyISAM COMMENT='datele personale ale cititorilor' AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `cititor`
-- 


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

-- 
-- Table structure for table `editura`
-- 

CREATE TABLE IF NOT EXISTS `editura` (
  `editura_id` smallint(6) NOT NULL auto_increment,
  `editura_nume` varchar(20) binary NOT NULL default '',
  `editura_comentariu` varchar(50) binary NOT NULL default '',
  PRIMARY KEY  (`editura_id`),
  KEY `editura_nume` (`editura_nume`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `editura`
-- 


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

-- 
-- Table structure for table `fondcarte`
-- 

CREATE TABLE IF NOT EXISTS `fondcarte` (
  `fond_id` int(11) NOT NULL auto_increment,
  `carte_id` int(11) NOT NULL default '0',
  `fond_total` smallint(11) unsigned NOT NULL default '0',
  `fond_imprumut` smallint(11) unsigned NOT NULL default '0',
  `fond_raft` smallint(11) unsigned NOT NULL default '0',
  `fond_rezerva` smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fond_id`),
  KEY `carteid` (`carte_id`)
) TYPE=MyISAM COMMENT='total = imprumut + raft + rezerva(altele)' AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `fondcarte`
-- 


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

-- 
-- Table structure for table `fondcarteoperatii`
-- 

CREATE TABLE IF NOT EXISTS `fondcarteoperatii` (
  `fondoper_id` int(10) unsigned NOT NULL auto_increment,
  `carte_id` int(10) unsigned NOT NULL default '0',
  `fondoper_data` datetime NOT NULL default '0000-00-00 00:00:00',
  `fondoper_dataop` date NOT NULL default '0000-00-00',
  `fondoper_cat` smallint(5) unsigned NOT NULL default '0',
  `fondoper_deunde` varchar(10) binary NOT NULL default '',
  `fondoper_semn` char(1) binary NOT NULL default '',
  `fondoper_explicatii` varchar(50) binary NOT NULL default '' COMMENT 'explicatii operatiei efectuate',
  PRIMARY KEY  (`fondoper_id`),
  KEY `carte_id` (`carte_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `fondcarteoperatii`
-- 


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

-- 
-- Table structure for table `gen`
-- 

CREATE TABLE IF NOT EXISTS `gen` (
  `gen_id` smallint(6) NOT NULL auto_increment,
  `gen_nume` varchar(30) binary NOT NULL default '',
  `gen_comentariu` varchar(50) binary NOT NULL default '',
  PRIMARY KEY  (`gen_id`),
  KEY `categoria_nume` (`gen_nume`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `gen`
-- 


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

-- 
-- Table structure for table `imprumut`
-- 

CREATE TABLE IF NOT EXISTS `imprumut` (
  `imprumut_id` int(10) unsigned NOT NULL auto_increment,
  `carte_id` int(10) unsigned NOT NULL default '0',
  `cititor_id` int(10) unsigned NOT NULL default '0',
  `imprumut_datai` date NOT NULL default '0000-00-00' COMMENT 'Data imprumutului',
  `imprumut_datas` date NOT NULL default '0000-00-00' COMMENT 'Data scadenta',
  `imprumut_buc` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`imprumut_id`),
  KEY `carte_id` (`carte_id`,`cititor_id`)
) TYPE=MyISAM COMMENT='Tabela cu date despre imprumuturi de carti.' AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `imprumut`
-- 


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

-- 
-- Table structure for table `imprumut_temp`
-- 

CREATE TABLE IF NOT EXISTS `imprumut_temp` (
  `cititor_id` int(10) unsigned NOT NULL default '0',
  `carte_id` int(10) unsigned NOT NULL default '0',
  `bucati` smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='la imprumut pt stocarea temp a datelor inainte de scriere in';

-- 
-- Dumping data for table `imprumut_temp`
-- 


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

-- 
-- Table structure for table `meniu`
-- 

CREATE TABLE IF NOT EXISTS `meniu` (
  `meniu_id` int(11) NOT NULL auto_increment,
  `meniu_nume` varchar(30) binary NOT NULL default '',
  `meniu_ordine` smallint(5) unsigned NOT NULL default '0',
  `meniu_parinte` tinyint(4) NOT NULL default '0',
  `meniu_directie` varchar(50) binary NOT NULL default '',
  `meniu_user` varchar(10) binary NOT NULL default '',
  PRIMARY KEY  (`meniu_id`)
) TYPE=MyISAM AUTO_INCREMENT=42 COMMENT='Meniurile din stanga paginii' AUTO_INCREMENT=42 ;

-- 
-- Dumping data for table `meniu`
-- 

INSERT INTO `meniu` (`meniu_id`, `meniu_nume`, `meniu_ordine`, `meniu_parinte`, `meniu_directie`, `meniu_user`) VALUES (1, 0x43c48372c5a369, 1, 0, 0x63617274692e706870, 0x61646d696e),
(2, 0x43697469746f7269, 4, 0, 0x63697469746f72692e706870, 0x61646d696e),
(3, 0x45646974757269, 5, 0, 0x656469747572692e706870, 0x61646d696e),
(4, 0x47656e757269, 6, 0, 0x67656e7572692e706870, 0x61646d696e),
(5, 0x5061726f6c65206163636573, 7, 0, 0x7061726f6c652e706870, 0x61646d696e),
(6, 0x4945c59e495245, 8, 0, 0x736372697074732f6c6f676f75742e706870, 0x61646d696e),
(8, 0x4564697465617ac483, 1, 1, 0x63617274692e7068703f6f7065723d6564, 0x61646d696e),
(7, 0x4164617567c483, 2, 1, 0x63617274692e7068703f6f7065723d616464, 0x61646d696e),
(9, 0x4c697374c483, 3, 1, 0x63617274692e7068703f6f7065723d6c697374, 0x61646d696e),
(10, 0x466f6e64206361727465, 2, 0, 0x666f6e6463617274652e706870, 0x61646d696e),
(12, 0x4164617567c483206f70657261c5a36969, 1, 10, 0x666f6e6463617274652e7068703f6f7065723d6f70657261746969, 0x61646d696e),
(13, 0x4c697374c483206f70657261c5a36969, 2, 10, 0x666f6e6463617274652e7068703f6f7065723d6c697374, 0x61646d696e),
(14, 0x4164617567c483, 1, 2, 0x63697469746f72692e7068703f6f7065723d616464, 0x61646d696e),
(15, 0x416472657365, 3, 0, 0x6164726573652e706870, 0x61646d696e),
(16, 0x4164617567c483207374726164c483, 1, 15, 0x6164726573652e7068703f6f7065723d616464, 0x61646d696e),
(17, 0x4564697465617ac483, 2, 15, 0x6164726573652e7068703f6f7065723d6361757461, 0x61646d696e),
(18, 0x4564697465617ac483, 2, 2, 0x63697469746f72692e7068703f6f7065723d6361757461, 0x61646d696e),
(19, 0x4164617567c483, 1, 3, 0x656469747572692e7068703f6f7065723d616464, 0x61646d696e),
(20, 0x4564697465617ac483, 2, 3, 0x656469747572692e7068703f6f7065723d6361757461, 0x61646d696e),
(21, 0x4164617567c483, 1, 4, 0x67656e7572692e7068703f6f7065723d616464, 0x61646d696e),
(22, 0x4564697465617a61, 2, 4, 0x67656e7572692e7068703f6f7065723d6361757461, 0x61646d696e),
(23, 0xc38e6d7072756d7574757269, 3, 2, 0x696d7072756d75747572692e7068703f6f7065723d636175746163697469746f72, 0x61646d696e),
(24, 0x52657374697475697269, 4, 2, 0x726573746974756972692e7068703f6f7065723d636175746163697469746f72, 0x61646d696e),
(25, 0x4d6f6469666963617265, 1, 5, 0x7061726f6c652e7068703f6f7065723d6d6f64, 0x61646d696e),
(26, 0x43c48372c5a369, 1, 0, 0x63617274692e706870, 0x6269626c696f),
(27, 0x43697469746f7269, 2, 0, 0x63697469746f72692e706870, 0x6269626c696f),
(28, 0x5061726f6c65206163636573, 3, 0, 0x7061726f6c652e706870, 0x6269626c696f),
(29, 0x4945c59e495245, 6, 0, 0x736372697074732f6c6f676f75742e706870, 0x6269626c696f),
(30, 0x4564697465617ac483, 1, 26, 0x63617274692e7068703f6f7065723d6564, 0x6269626c696f),
(31, 0x4164617567c483, 2, 26, 0x63617274692e7068703f6f7065723d616464, 0x6269626c696f),
(32, 0x4c697374c483, 3, 26, 0x63617274692e7068703f6f7065723d6c697374, 0x6269626c696f),
(33, 0x4164617567c483, 1, 27, 0x63697469746f72692e7068703f6f7065723d616464, 0x6269626c696f),
(34, 0x4564697465617ac483, 2, 27, 0x63697469746f72692e7068703f6f7065723d6361757461, 0x6269626c696f),
(35, 0xc38e6d7072756d7574757269, 4, 27, 0x696d7072756d75747572692e7068703f6f7065723d636175746163697469746f72, 0x6269626c696f),
(36, 0x52657374697475697269, 4, 27, 0x726573746974756972692e7068703f6f7065723d636175746163697469746f72, 0x6269626c696f),
(37, 0x4d6f6469666963617265, 1, 28, 0x7061726f6c652e7068703f6f7065723d6d6f64, 0x6269626c696f),
(38, 0x43c48372c5a369, 1, 0, 0x63617274692e706870, 0x7075626c6963),
(39, 0x43c4837574617265, 1, 38, 0x63617274692e7068703f6f7065723d6361757461, 0x7075626c6963),
(40, 0x536368696d62c483207061726f6cc483, 2, 0, 0x7061726f6c652e7068703f6f7065723d6d6f64, 0x7075626c6963),
(41, 0x4945c59e495245, 3, 0, 0x736372697074732f6c6f676f75742e706870, 0x7075626c6963);

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

-- 
-- Table structure for table `strada`
-- 

CREATE TABLE IF NOT EXISTS `strada` (
  `strada_id` int(10) unsigned NOT NULL auto_increment,
  `strada_denumire` varchar(100) binary NOT NULL default '',
  PRIMARY KEY  (`strada_id`),
  KEY `strazi_denumire` (`strada_denumire`)
) TYPE=MyISAM COMMENT='tabela cu strazi - se foloseste cu tabela adrese' AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `strada`
--