-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1-Debian-1ubuntu1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 09, 2007 at 09:21 PM
-- Server version: 4.1.12
-- PHP Version: 4.4.0-3ubuntu2
--
-- Database: `consider`
--
-- --------------------------------------------------------
--
-- Table structure for table `attribute`
--
CREATE TABLE `attribute` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`type` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `data`
--
CREATE TABLE `data` (
`id` int(10) NOT NULL auto_increment,
`nodeid` int(10) NOT NULL default '0',
`attributeid` int(10) NOT NULL default '0',
`blob` blob,
`text` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `node`
--
CREATE TABLE `node` (
`id` int(10) NOT NULL auto_increment,
`label` varchar(60) NOT NULL default '',
`templateid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `template`
--
CREATE TABLE `template` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `templateattribute`
--
CREATE TABLE `templateattribute` (
`templateid` int(10) NOT NULL default '0',
`attributeid` int(10) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
