-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 14, 2009 at 11:51 PM
-- Server version: 5.0.18
-- PHP Version: 5.1.1
-- 
-- DATABASE STRUCTURE OF DeltaXML DATABASE
-- 

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

-- 
-- Table structure for table `attr`
-- 

CREATE TABLE `attr` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `item_id` varchar(10) collate latin1_general_ci NOT NULL,
  `char_id` varchar(10) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `item_id` (`item_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `attrval`
-- 

CREATE TABLE `attrval` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `attr_id` varchar(10) collate latin1_general_ci NOT NULL,
  `logic` varchar(10) collate latin1_general_ci NOT NULL,
  `value` varchar(10) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `attr_id` (`attr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

-- 
-- Table structure for table `char`
-- 

CREATE TABLE `char` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `seq` smallint(6) NOT NULL,
  `charGroup_id` varchar(10) collate latin1_general_ci NOT NULL,
  `subgroup_id` varchar(10) collate latin1_general_ci NOT NULL,
  `type` varchar(25) collate latin1_general_ci NOT NULL,
  `states` smallint(6) NOT NULL,
  `implicitState` varchar(10) collate latin1_general_ci NOT NULL,
  `del` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `seq` (`seq`),
  KEY `charGroup_id` (`charGroup_id`),
  KEY `subgroup_id` (`subgroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

-- 
-- Table structure for table `chargroup`
-- 

CREATE TABLE `chargroup` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `parent_id` varchar(10) collate latin1_general_ci NOT NULL,
  `seq` smallint(6) NOT NULL,
  `style` varchar(100) collate latin1_general_ci NOT NULL,
  `del` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `seq` (`seq`),
  KEY `del` (`del`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `charlist`
-- 

CREATE TABLE `charlist` (
  `id` smallint(6) NOT NULL,
  `description` varchar(100) collate latin1_general_ci NOT NULL,
  `heading` varchar(100) collate latin1_general_ci NOT NULL,
  `charsNbr` smallint(6) NOT NULL,
  `stateMax` smallint(6) NOT NULL,
  `lang` varchar(20) collate latin1_general_ci NOT NULL,
  `revised` varchar(40) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `description`
-- 

CREATE TABLE `description` (
  `id` smallint(6) NOT NULL auto_increment,
  `item_id` varchar(10) collate latin1_general_ci NOT NULL,
  `lang` varchar(20) collate latin1_general_ci NOT NULL,
  `curGroup` smallint(6) NOT NULL,
  `curSubGroup` smallint(6) NOT NULL,
  `curChar` smallint(6) NOT NULL,
  `data` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `item`
-- 

CREATE TABLE `item` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `parent_id` varchar(10) collate latin1_general_ci NOT NULL,
  `rank` varchar(10) collate latin1_general_ci NOT NULL,
  `name` varchar(100) collate latin1_general_ci NOT NULL,
  `style` varchar(100) collate latin1_general_ci NOT NULL,
  `author` varchar(100) collate latin1_general_ci NOT NULL,
  `del` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `itemlist`
-- 

CREATE TABLE `itemlist` (
  `id` smallint(6) NOT NULL,
  `description` varchar(100) collate latin1_general_ci NOT NULL,
  `itemsNbr` smallint(6) NOT NULL,
  `link_to_data` varchar(20) collate latin1_general_ci NOT NULL,
  `lang` varchar(20) collate latin1_general_ci NOT NULL,
  `revised` varchar(40) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `state`
-- 

CREATE TABLE `state` (
  `id` varchar(10) collate latin1_general_ci NOT NULL,
  `seq` smallint(6) NOT NULL,
  `char_id` varchar(10) collate latin1_general_ci NOT NULL,
  `value` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `seq` (`seq`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

-- 
-- Table structure for table `text`
-- 

CREATE TABLE `text` (
  `id` smallint(6) NOT NULL auto_increment,
  `ref` varchar(10) collate latin1_general_ci NOT NULL,
  `type` varchar(20) collate latin1_general_ci NOT NULL,
  `lang` varchar(20) collate latin1_general_ci NOT NULL,
  `use` smallint(6) default NULL,
  `position` varchar(10) collate latin1_general_ci NOT NULL,
  `label` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ref` (`ref`),
  KEY `type` (`type`),
  KEY `position` (`position`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `vocabulary`
-- 

CREATE TABLE `vocabulary` (
  `id` smallint(6) NOT NULL auto_increment,
  `lang` varchar(20) collate latin1_general_ci NOT NULL,
  `operators` varchar(200) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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