CREATE TABLE gui_modules (
  id int(11) NOT NULL default '0',
  module blob NOT NULL,
  PRIMARY KEY  (id)
);


CREATE TABLE hub_modules (
  id int(11) NOT NULL default '0',
  module blob NOT NULL,
  PRIMARY KEY  (id)
);

CREATE TABLE modules (
  id int(11) NOT NULL,
  name varchar(255) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (id),
  KEY name (name)
) AUTO_INCREMENT=1 ;

CREATE TABLE net_member_nodes (
  net_id int(11) NOT NULL default '0',
  node_id int(11) NOT NULL default '0'
);

INSERT INTO `net_member_nodes` VALUES (1, 1);

CREATE TABLE networks (
  id int(11) NOT NULL,
  name varchar(255) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (id),
  KEY name (name)
) AUTO_INCREMENT=5 ;


INSERT INTO `networks` VALUES (1, 'test', 'testeestes');
INSERT INTO `networks` VALUES (4, 'test 2', '');

CREATE TABLE node_modules (
  id int(11) NOT NULL default '0',
  module blob NOT NULL,
  PRIMARY KEY  (id)
);

CREATE TABLE nodes (
  id int(11) NOT NULL,
  ident varchar(255) NOT NULL default '',
  status int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ident (ident,status)
) AUTO_INCREMENT=2 ;


INSERT INTO `nodes` VALUES (1, 'test', 0);