-- $Id$

CREATE SEQUENCE flexinode_field_seq;
CREATE SEQUENCE flexinode_ctype_seq;

CREATE TABLE flexinode_field (
  field_id integer NOT NULL default nextval('flexinode_field_seq'),
  ctype_id integer NOT NULL default nextval('flexinode_ctype_seq'),
  label varchar(255) NOT NULL default '',
  default_value text NOT NULL default '',
  weight integer NOT NULL default '0',
  required integer NOT NULL default '0',
  show_teaser integer NOT NULL default '0',
  show_table integer NOT NULL default '0',
  rows integer NOT NULL default '0',
  field_type varchar(255) NOT NULL default '',
  options text NOT NULL default '',
  description varchar(255) NOT NULL default '',
  UNIQUE ( field_id, ctype_id ),
  PRIMARY KEY (field_id)
);

CREATE TABLE flexinode_type (
  ctype_id integer NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  help text NOT NULL default '',
  PRIMARY KEY (ctype_id)
);

CREATE TABLE flexinode_data (
  nid integer NOT NULL default '0',
  field_id integer NOT NULL default '0',
  textual_data text NOT NULL default '',
  numeric_data integer NOT NULL default '0',
  serialized_data text NOT NULL default '',
  PRIMARY KEY (nid,field_id)
);