# MySQL dump 6.0
#
# Host: localhost    Database: lucid
#--------------------------------------------------------
# Server version	3.22.25

#
# Table structure for table 'NodeReferences'
#
CREATE TABLE NodeReferences (
  NodeReferenceID int(16) DEFAULT '0' NOT NULL auto_increment,
  ReferringNodeID int(16) DEFAULT '0' NOT NULL,
  ReferenceType varchar(16) DEFAULT '' NOT NULL,
  RecipientNodeID int(16) DEFAULT '0' NOT NULL,
  PRIMARY KEY (NodeReferenceID)
);

#
# Table structure for table 'Nodes'
#
CREATE TABLE Nodes (
  NodeID int(16) DEFAULT '0' NOT NULL auto_increment,
  NodeTitle varchar(128) DEFAULT '' NOT NULL,
  NodeText text NOT NULL,
  lastViewed timestamp(14),
  HitCount int(16) DEFAULT '0',
  lastModified timestamp(14),
  PRIMARY KEY (NodeID)
);
#
# Table structure for table 'Pins'
#
CREATE TABLE Pins (
  PinID int(16) DEFAULT '0' NOT NULL auto_increment,
  NodeID int(16) DEFAULT '0' NOT NULL,
  Username varchar(32) DEFAULT '' NOT NULL,
  PRIMARY KEY (PinID)
);
#
# Table structure for table 'binary_data'
#
CREATE TABLE binary_data (
   dataID int(14) DEFAULT '0' NOT NULL auto_increment,
   NodeID int(14),
   description varchar(255),
   bin_data longblob,
   filename varchar(50),
   filesize varchar(50),
   filetype varchar(50),
   PRIMARY KEY (dataID)
);
#
# Insert a record into NodeReferences
#
INSERT INTO NodeReferences(ReferringNodeID,ReferenceType,RecipientNodeID)
	VALUES(
		1,
		'child',
		2
	);


#
# Insert a record into Nodes
#
INSERT INTO Nodes(NodeTitle,NodeText)
	VALUES(
		'Home Node','This is the home node. Feel free to change the text by clicking the pencil icon'
	);

INSERT INTO Nodes(NodeTitle,NodeText)
	VALUES(
		'Lucid License','Remember that Lucid is licensed under the GPL. Copyright Stephen Danic 2000'
	);


#
# Insert a record into Pins
#
INSERT INTO Pins(NodeID,Username)
	VALUES( 1, 'lucid');