# --------------------------------------------------------
# Table structure for table 'Nodes'

CREATE TABLE Nodes (
   ID int(10) unsigned NOT NULL auto_increment,
   Date_Created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   Date_Modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   Status int(1) unsigned NOT NULL,
   Type int(1) unsigned NOT NULL,
   PRIMARY KEY (ID)
);

# --------------------------------------------------------
# Table structure for table 'Contacts'

CREATE TABLE Contacts (
   ID int(2) unsigned NOT NULL,
   FirstName varchar(48) NOT NULL,
   LastName varchar(48) NOT NULL,
   Company varchar(48) NOT NULL,
   Street1 varchar(48) NOT NULL,
   Street2 varchar(48) NOT NULL,
   City varchar(48) NOT NULL,
   State varchar(24) NOT NULL,
   Zip varchar(12) NOT NULL,
   Phone varchar(24) NOT NULL,
   Email varchar(48) NOT NULL,
   ContactPreference tinyint(3) unsigned NOT NULL,
   Subscribed char(1) NOT NULL,
   PRIMARY KEY (ID)
);

# --------------------------------------------------------
# Table structure for table 'Contact_Groups'

CREATE TABLE Contact_Groups (
   ID int(2) unsigned NOT NULL,
   Title varchar(128) NOT NULL,
   Description varchar(255),
   PRIMARY KEY (ID)
);

# --------------------------------------------------------
# Table structure for table 'Node_Relationships'

CREATE TABLE Node_Relationships (
   ThisID int(2) unsigned NOT NULL,
   ThatID int(2) unsigned NOT NULL,
   RelationshipType int(1) unsigned NOT NULL,
   SortIndex smallint(5) unsigned NOT NULL,
   PRIMARY KEY (ThisID, ThatID, RelationshipType)
);