Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
tree: faf8b52dd9
Fetching contributors…

Cannot retrieve contributors at this time

150 lines (147 sloc) 71.089 kb
DROP TABLE IF EXISTS `%PREFIX%AccessControl`;
DROP TABLE IF EXISTS `%PREFIX%CommentEntries`;
DROP TABLE IF EXISTS `%PREFIX%ExampleCustomers`;
DROP TABLE IF EXISTS `%PREFIX%ExampleEmployees`;
DROP TABLE IF EXISTS `%PREFIX%FriendInformation`;
DROP TABLE IF EXISTS `%PREFIX%FriendPing`;
DROP TABLE IF EXISTS `%PREFIX%Janitor`;
DROP TABLE IF EXISTS `%PREFIX%JournalEntries`;
DROP TABLE IF EXISTS `%PREFIX%LocalTokens`;
DROP TABLE IF EXISTS `%PREFIX%NetworkCache`;
DROP TABLE IF EXISTS `%PREFIX%NetworkNodes`;
DROP TABLE IF EXISTS `%PREFIX%friendCircles`;
DROP TABLE IF EXISTS `%PREFIX%friendCirclesList`;
DROP TABLE IF EXISTS `%PREFIX%groupContent`;
DROP TABLE IF EXISTS `%PREFIX%NotificationsIncoming`;
DROP TABLE IF EXISTS `%PREFIX%NotificationsOutgoing`;
DROP TABLE IF EXISTS `%PREFIX%NotificationsUpdated`;
DROP TABLE IF EXISTS `%PREFIX%PageLinks`;
DROP TABLE IF EXISTS `%PREFIX%PagePosts`;
DROP TABLE IF EXISTS `%PREFIX%PageReferences`;
DROP TABLE IF EXISTS `%PREFIX%Photos`;
DROP TABLE IF EXISTS `%PREFIX%PrivacySettings`;
DROP TABLE IF EXISTS `%PREFIX%RemoteTokens`;
DROP TABLE IF EXISTS `%PREFIX%SchemaVersions`;
DROP TABLE IF EXISTS `%PREFIX%SearchIndexes`;
DROP TABLE IF EXISTS `%PREFIX%SearchResults`;
DROP TABLE IF EXISTS `%PREFIX%SystemUpdate`;
DROP TABLE IF EXISTS `%PREFIX%authSessions`;
DROP TABLE IF EXISTS `%PREFIX%authTokens`;
DROP TABLE IF EXISTS `%PREFIX%authVerification`;
DROP TABLE IF EXISTS `%PREFIX%cacheNodes`;
DROP TABLE IF EXISTS `%PREFIX%commentInformation`;
DROP TABLE IF EXISTS `%PREFIX%contentNodes`;
DROP TABLE IF EXISTS `%PREFIX%contentPages`;
DROP TABLE IF EXISTS `%PREFIX%groupInformation`;
DROP TABLE IF EXISTS `%PREFIX%groupMembers`;
DROP TABLE IF EXISTS `%PREFIX%messageAttachments`;
DROP TABLE IF EXISTS `%PREFIX%messageInformation`;
DROP TABLE IF EXISTS `%PREFIX%messageLabelList`;
DROP TABLE IF EXISTS `%PREFIX%messageLabels`;
DROP TABLE IF EXISTS `%PREFIX%messageNotification`;
DROP TABLE IF EXISTS `%PREFIX%messageRecipient`;
DROP TABLE IF EXISTS `%PREFIX%messageStore`;
DROP TABLE IF EXISTS `%PREFIX%photoInformation`;
DROP TABLE IF EXISTS `%PREFIX%photoPrivacy`;
DROP TABLE IF EXISTS `%PREFIX%photoSets`;
DROP TABLE IF EXISTS `%PREFIX%systemConfig`;
DROP TABLE IF EXISTS `%PREFIX%systemLogs`;
DROP TABLE IF EXISTS `%PREFIX%systemMaintenance`;
DROP TABLE IF EXISTS `%PREFIX%systemOptions`;
DROP TABLE IF EXISTS `%PREFIX%tagInformation`;
DROP TABLE IF EXISTS `%PREFIX%tagList`;
DROP TABLE IF EXISTS `%PREFIX%userAccess`;
DROP TABLE IF EXISTS `%PREFIX%userAnswers`;
DROP TABLE IF EXISTS `%PREFIX%userBlocks`;
DROP TABLE IF EXISTS `%PREFIX%userGroups`;
DROP TABLE IF EXISTS `%PREFIX%userIcons`;
DROP TABLE IF EXISTS `%PREFIX%userInformation`;
DROP TABLE IF EXISTS `%PREFIX%userInvites`;
DROP TABLE IF EXISTS `%PREFIX%userPreferences`;
DROP TABLE IF EXISTS `%PREFIX%userPrivacy`;
DROP TABLE IF EXISTS `%PREFIX%userProfile`;
DROP TABLE IF EXISTS `%PREFIX%userQuestions`;
DROP TABLE IF EXISTS `%PREFIX%userSessions`;
DROP TABLE IF EXISTS `%PREFIX%userSettings`;
DROP TABLE IF EXISTS `%PREFIX%userAuthorization`;
CREATE TABLE `%PREFIX%userAuthorization` ( `uID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL DEFAULT '', `Pass` varchar(144) DEFAULT NULL, `Verification` int(1) DEFAULT NULL, `Standing` int(1) DEFAULT NULL, PRIMARY KEY (`uID`), UNIQUE KEY `%PREFIX%userAuthorization_index` (`Username`)) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%photoSets` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `sID` int(10) unsigned DEFAULT NULL, `Name` varchar(128) DEFAULT NULL, `Directory` varchar(128) DEFAULT NULL, `Description` text, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%photoSets_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%photoSets_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%AccessControl` ( `Access_PK` int(10) unsigned NOT NULL AUTO_INCREMENT, `Account` varchar(255) NOT NULL, `Location` varchar(128) NOT NULL DEFAULT '', `Read` tinyint(1) DEFAULT '0', `Write` tinyint(1) DEFAULT '0', `Admin` tinyint(1) DEFAULT '0', `Inheritance` tinyint(1) DEFAULT '0', PRIMARY KEY (`Access_PK`)) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%CommentEntries` ( `Entry_PK` int(10) unsigned NOT NULL AUTO_INCREMENT, `Context` varchar(32) DEFAULT NULL, `Context_FK` int(10) unsigned NOT NULL, `Parent_ID` int(10) unsigned DEFAULT NULL, `Body` text, `Created` datetime DEFAULT NULL, `Owner` varchar(128) NOT NULL DEFAULT '', `Address` varchar(16) DEFAULT '0.0.0.0', `Status` tinyint(1) DEFAULT '1', PRIMARY KEY (`Entry_PK`)) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%ExampleCustomers` ( `Customer_PK` int(11) NOT NULL AUTO_INCREMENT, `CustomerName` varchar(50) NOT NULL, `ContactLastName` varchar(50) NOT NULL, `ContactFirstName` varchar(50) NOT NULL, `Phone` varchar(50) NOT NULL, `AddressLine1` varchar(50) NOT NULL, `AddressLine2` varchar(50) DEFAULT NULL, `City` varchar(50) NOT NULL, `State` varchar(50) DEFAULT NULL, `PostalCode` varchar(15) DEFAULT NULL, `Country` varchar(50) NOT NULL, `Employee_FK` int(11) DEFAULT NULL, `CreditLimit` double DEFAULT NULL, PRIMARY KEY (`Customer_PK`)) ENGINE=MyISAM AUTO_INCREMENT=498 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%ExampleEmployees` ( `Employee_PK` int(11) NOT NULL AUTO_INCREMENT, `LastName` varchar(50) DEFAULT NULL, `FirstName` varchar(50) DEFAULT NULL, `extension` varchar(10) NOT NULL, `email` varchar(100) NOT NULL, `officeCode` varchar(20) NOT NULL, `reportsTo` int(11) DEFAULT NULL, `jobTitle` varchar(50) NOT NULL, PRIMARY KEY (`Employee_PK`)) ENGINE=MyISAM AUTO_INCREMENT=1703 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%FriendInformation` ( `Friend_PK` int(10) unsigned NOT NULL AUTO_INCREMENT, `Owner_FK` int(10) unsigned NOT NULL, `Username` varchar(128) DEFAULT NULL, `Domain` varchar(128) DEFAULT NULL, `Verification` int(1) DEFAULT NULL, `Created` datetime DEFAULT NULL, PRIMARY KEY (`Friend_PK`), KEY `%PREFIX%friendInformation_FKIndex1` (`Owner_FK`)) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%FriendPing` ( `Ping_PK` int(11) NOT NULL AUTO_INCREMENT, `Sender` char(128) DEFAULT NULL, `Recipient` char(128) DEFAULT NULL, `Created` datetime DEFAULT NULL, `Status` tinyint(1) DEFAULT '0', PRIMARY KEY (`Ping_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%Janitor` ( `Updated` datetime DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `%PREFIX%JournalEntries` ( `Entry_PK` int(11) NOT NULL AUTO_INCREMENT, `Owner_FK` int(11) DEFAULT NULL, `Title` char(200) DEFAULT NULL, `Body` text, `Identifier` char(32) DEFAULT NULL, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, PRIMARY KEY (`Entry_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%LocalTokens` ( `Token_PK` int(11) NOT NULL AUTO_INCREMENT, `Token` varchar(64) DEFAULT NULL, `Username` varchar(255) DEFAULT NULL, `Target` varchar(255) NOT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`Token_PK`)) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%NetworkCache` ( `Request` varchar(512) DEFAULT NULL, `Response` text, `Created` datetime DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%NetworkNodes` ( `Node_PK` int(11) NOT NULL AUTO_INCREMENT, `Description` char(200) DEFAULT NULL, `Domain` char(128) DEFAULT NULL, `Trust` enum('blocked','discovered','trusted') DEFAULT 'discovered', `Source` char(128) DEFAULT NULL, `Access` enum('public','trusted','private') DEFAULT 'private', `Inherit` tinyint(1) DEFAULT NULL, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, `Contacted` datetime DEFAULT NULL, `Expires` datetime DEFAULT '0000-00-00 00:00:00', `Methods` char(100) DEFAULT NULL, `Version` char(8) DEFAULT NULL, `Status` tinyint(1) DEFAULT '0', PRIMARY KEY (`Node_PK`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%NotificationsIncoming` ( `Incoming_PK` int(11) NOT NULL AUTO_INCREMENT, `Owner_FK` int(11) NOT NULL, `ActionOwner` char(128) DEFAULT NULL, `Action` char(32) DEFAULT NULL, `ActionLink` char(255) DEFAULT NULL, `SubjectOwner` char(128) DEFAULT NULL, `ContextOwner` char(128) DEFAULT NULL, `Context` char(32) DEFAULT NULL, `ContextLink` char(255) DEFAULT NULL, `Icon` char(255) DEFAULT NULL, `Comment` text, `Description` text, `Identifier` char(32) DEFAULT NULL, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Feedback` mediumint(9) DEFAULT '0', `Comments` mediumint(9) DEFAULT '0', PRIMARY KEY (`Incoming_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%NotificationsOutgoing` ( `Outgoing_PK` int(11) NOT NULL AUTO_INCREMENT, `Recipient` char(128) DEFAULT NULL, `Owner_FK` int(11) NOT NULL, `ActionOwner` char(128) DEFAULT NULL, `Action` char(32) DEFAULT NULL, `ActionLink` char(255) DEFAULT NULL, `SubjectOwner` char(128) DEFAULT NULL, `ContextOwner` char(128) DEFAULT NULL, `Context` char(32) DEFAULT NULL, `ContextLink` char(255) DEFAULT NULL, `Icon` char(255) DEFAULT NULL, `Comment` text, `Description` text, `Identifier` char(32) DEFAULT NULL, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Feedback` mediumint(9) DEFAULT '0', `Comments` mediumint(9) DEFAULT '0', PRIMARY KEY (`Outgoing_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%NotificationsUpdated` ( `Updated_PK` int(11) NOT NULL AUTO_INCREMENT, `Owner_FK` int(11) DEFAULT NULL, `Friend` char(128) DEFAULT NULL, `Updated` datetime DEFAULT NULL, PRIMARY KEY (`Updated_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%PageLinks` ( `Link_PK` int(11) NOT NULL AUTO_INCREMENT, `User_FK` int(11) DEFAULT NULL, `Owner` char(64) DEFAULT NULL, `Identifier` char(32) DEFAULT NULL, `Content` text, `Link` char(255) DEFAULT NULL, `Title` char(64) DEFAULT NULL, `Description` text, `Thumb` char(255) DEFAULT NULL, PRIMARY KEY (`Link_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%PagePosts` ( `Post_PK` int(11) NOT NULL AUTO_INCREMENT, `User_FK` int(11) NOT NULL, `Owner` char(64) DEFAULT NULL, `Identifier` char(32) DEFAULT NULL, `Content` text, `Current` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Post_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%PageReferences` ( `Reference_PK` int(11) NOT NULL AUTO_INCREMENT, `User_FK` int(11) NOT NULL, `Identifier` char(32) DEFAULT NULL, `Type` char(16) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`Reference_PK`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `%PREFIX%Photos` ( `Photo_PK` int(11) NOT NULL AUTO_INCREMENT, `Owner_FK` int(11) DEFAULT NULL, `Set_FK` int(11) DEFAULT NULL, `Identifier` char(32) DEFAULT NULL, `Filename` char(128) DEFAULT NULL, `Description` text, `Profile` tinyint(1) DEFAULT '0', `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, PRIMARY KEY (`Photo_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%PrivacySettings` ( `Setting_PK` int(11) NOT NULL AUTO_INCREMENT, `User_FK` int(11) NOT NULL, `Circle_FK` int(11) DEFAULT NULL, `Type` char(32) DEFAULT NULL, `Identifier` char(32) DEFAULT NULL, `Everybody` tinyint(1) DEFAULT NULL, `Friends` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Setting_PK`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `%PREFIX%RemoteTokens` ( `Token_PK` int(11) NOT NULL AUTO_INCREMENT, `Token` varchar(64) DEFAULT NULL, `Username` varchar(255) DEFAULT NULL, `Source` varchar(255) NOT NULL, `Address` varchar(255) DEFAULT NULL, `Host` varchar(255) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`Token_PK`)) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%SchemaVersions` ( `Schema_PK` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Version` char(16) DEFAULT NULL, `Notes` text, PRIMARY KEY (`Schema_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%SearchIndexes` ( `Index_PK` int(11) NOT NULL AUTO_INCREMENT, `Context` char(16) DEFAULT NULL, `Context_FK` int(11) DEFAULT NULL, `Keywords` text, `Created` datetime DEFAULT NULL, `Updated` datetime DEFAULT NULL, PRIMARY KEY (`Index_PK`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `%PREFIX%SearchResults` ( `Result_PK` int(11) NOT NULL AUTO_INCREMENT, `User_FK` int(11) DEFAULT NULL, `Source` char(128) DEFAULT NULL, `Keywords` text, `Title` char(255) DEFAULT NULL, `Link` char(255) DEFAULT NULL, `Icon` char(255) DEFAULT NULL, `Owner` char(128) DEFAULT NULL, `Description` text, `Stamp` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, PRIMARY KEY (`Result_PK`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%SystemUpdate` ( `Server_PK` int(11) NOT NULL AUTO_INCREMENT, `Server` varchar(255) NOT NULL, `Default` tinyint(1) DEFAULT '0', PRIMARY KEY (`Server_PK`), UNIQUE KEY `Server` (`Server`)) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%authSessions` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL DEFAULT '', `Domain` varchar(128) NOT NULL DEFAULT '', `Identifier` varchar(32) DEFAULT '00000000000000000000000000000000', `Stamp` datetime DEFAULT NULL, `Address` varchar(16) DEFAULT '0.0.0.0', `Host` varchar(128) DEFAULT NULL, `Fullname` varchar(64) DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%authTokens` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL DEFAULT '', `Domain` varchar(128) NOT NULL DEFAULT '', `Token` varchar(32) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, `Source` int(11) DEFAULT NULL, `Address` varchar(16) DEFAULT NULL, `Host` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%authVerification` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL DEFAULT '', `Domain` varchar(128) NOT NULL DEFAULT '', `Verified` int(1) DEFAULT NULL, `Address` varchar(16) DEFAULT '0.0.0.0', `Host` varchar(128) DEFAULT NULL, `Active` int(1) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%cacheNodes` ( `Domain` varchar(128) DEFAULT NULL, `Version` varchar(8) DEFAULT NULL, `Stamp` datetime DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%commentInformation` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `rID` int(10) unsigned zerofill DEFAULT NULL, `Context` varchar(32) DEFAULT NULL, `parent_tID` int(10) unsigned DEFAULT NULL, `Subject` varchar(128) DEFAULT NULL, `Body` text, `Stamp` datetime DEFAULT NULL, `Owner_Username` varchar(32) NOT NULL DEFAULT '', `Owner_Domain` varchar(128) NOT NULL DEFAULT '', `Owner_Icon` varchar(32) NOT NULL DEFAULT '', `Owner_Address` varchar(16) DEFAULT '0.0.0.0', PRIMARY KEY (`tID`), KEY `%PREFIX%commentInformation_referenceIndex` (`rID`,`Context`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%contentNodes` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Domain` varchar(255) DEFAULT NULL, `Summary` varchar(128) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, `Users` int(10) unsigned DEFAULT NULL, `Verification` int(11) DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%contentPages` ( `tID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `Title` varchar(128) DEFAULT NULL, `Output` text, `Formatting` int(1) DEFAULT NULL, `Location` varchar(128) DEFAULT NULL, `Template` varchar(32) DEFAULT NULL, `Language` char(2) DEFAULT NULL, `Context` varchar(32) DEFAULT NULL, `Style` text, PRIMARY KEY (`tID`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%friendCircles` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `sID` int(10) unsigned DEFAULT NULL, `Name` varchar(32) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `Private` tinyint(1) DEFAULT NULL, `Protected` tinyint(1) DEFAULT NULL, `Shared` tinyint(1) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%Circles_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%friendCirclesList` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `friendCircles_tID` int(10) unsigned NOT NULL DEFAULT '0', `friendInformation_tID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tID`), KEY `%PREFIX%friendCirclesList_FKIndex1` (`friendInformation_tID`), KEY `%PREFIX%friendCirclesList_FKIndex2` (`friendCircles_tID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%groupContent` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `groupInformation_tID` int(10) unsigned NOT NULL DEFAULT '0', `parent_tID` int(10) unsigned DEFAULT NULL, `Subject` varchar(128) DEFAULT NULL, `Body` text, `Stamp` datetime DEFAULT NULL, `Owner_Username` varchar(32) DEFAULT NULL, `Owner_Domain` varchar(128) DEFAULT NULL, `Owner_Icon` varchar(32) DEFAULT NULL, `Owner_Address` varchar(16) DEFAULT NULL, `Views` int(10) unsigned DEFAULT NULL, `Tags` varchar(128) DEFAULT NULL, `la%PREFIX%tID` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%groupPost_FKIndex1` (`groupInformation_tID`), KEY `%PREFIX%groupPost_FKIndex2` (`userAuth_uID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%groupInformation` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Name` varchar(32) DEFAULT NULL, `Fullname` varchar(128) DEFAULT NULL, `Description` text, `Stamp` datetime DEFAULT NULL, `Access` int(10) unsigned DEFAULT NULL, `Tags` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%groupInformation_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%groupMembers` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `groupInformation_tID` int(10) unsigned NOT NULL DEFAULT '0', `Username` varchar(64) DEFAULT NULL, `Domain` varchar(128) DEFAULT NULL, `Verification` int(10) unsigned DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%groupMembers_FKIndex1` (`groupInformation_tID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageAttachments` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `messageStore_tID` int(10) unsigned NOT NULL, `Filename` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%messageAttachments_FKIndex1` (`messageStore_tID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageInformation` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Sender_Username` varchar(32) DEFAULT NULL, `Sender_Domain` varchar(128) DEFAULT NULL, `Identifier` varchar(128) DEFAULT NULL, `Subject` varchar(128) DEFAULT NULL, `Body` text, `Sent_Stamp` datetime DEFAULT NULL, `Received_Stamp` datetime DEFAULT NULL, `Standing` int(10) unsigned DEFAULT NULL, `Location` int(11) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%messageInformation_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageLabelList` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `messageLabels_tID` int(10) unsigned NOT NULL DEFAULT '0', `Identifier` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%messageLabelList_FKIndex1` (`messageLabels_tID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageLabels` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Label` varchar(32) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%two_messageLabels_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageNotification` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Sender_Username` varchar(32) DEFAULT NULL, `Sender_Domain` varchar(128) DEFAULT NULL, `Identifier` varchar(128) DEFAULT NULL, `Subject` varchar(128) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, `Standing` int(10) unsigned DEFAULT NULL, `Location` int(11) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%messageNotification_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageRecipient` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `messageStore_tID` int(10) unsigned NOT NULL, `userAuth_uID` int(10) unsigned zerofill NOT NULL, `Identifier` varchar(128) DEFAULT NULL, `Username` varchar(128) DEFAULT NULL, `Domain` varchar(128) DEFAULT NULL, `Standing` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%two_messageRecipients_FKIndex1` (`userAuth_uID`), KEY `%PREFIX%two_messageRecipients_FKIndex2` (`messageStore_tID`)) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%messageStore` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL, `Subject` varchar(128) DEFAULT NULL, `Body` text, `Stamp` datetime DEFAULT NULL, `Location` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%messageStore_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%photoInformation` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `photoSets_tID` int(10) unsigned NOT NULL DEFAULT '0', `sID` int(10) unsigned NOT NULL DEFAULT '0', `Filename` varchar(64) DEFAULT NULL, `Height` int(10) unsigned DEFAULT NULL, `Width` int(10) unsigned DEFAULT NULL, `Description` text, `Stamp` datetime DEFAULT NULL, `Hint` varchar(6) DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`,`photoSets_tID`), KEY `%PREFIX%photoList_FKIndex1` (`photoSets_tID`,`userAuth_uID`), CONSTRAINT `%PREFIX%photoInformation_ibfk_1` FOREIGN KEY (`photoSets_tID`, `userAuth_uID`) REFERENCES `%PREFIX%photoSets` (`tID`, `userAuth_uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%photoPrivacy` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `photoSets_tID` int(10) unsigned NOT NULL DEFAULT '0', `friendCircles_sID` int(11) DEFAULT NULL, `Access` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`,`photoSets_tID`), KEY `%PREFIX%photoPrivacy_FKIndex1` (`photoSets_tID`,`userAuth_uID`), CONSTRAINT `%PREFIX%photoPrivacy_ibfk_1` FOREIGN KEY (`photoSets_tID`, `userAuth_uID`) REFERENCES `%PREFIX%photoSets` (`tID`, `userAuth_uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%systemConfig` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Concern` varchar(32) DEFAULT NULL, `Value` varchar(255) DEFAULT '0', PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%systemLogs` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Entry` varchar(255) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, `Severity` int(1) DEFAULT '0', `Location` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%systemActivityLog_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%systemLogs_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%systemMaintenance` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Action` varchar(64) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, `Time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%systemOptions` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Concern` varchar(255) DEFAULT NULL, `Label` varchar(255) DEFAULT NULL, `Value` varchar(16) DEFAULT NULL, `Chosen` int(1) DEFAULT '0', `Language` char(2) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%systemOptions_index` (`Concern`)) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%tagInformation` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(32) DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%tagList` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL, `tagInformation_tID` int(10) unsigned NOT NULL, `rID` int(10) unsigned DEFAULT NULL, `Context` varchar(16) DEFAULT NULL, `Username` varchar(32) DEFAULT NULL, `Domain` varchar(64) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%tagList_FKIndex1` (`tagInformation_tID`), KEY `%PREFIX%tagList_FKIndex2` (`userAuth_uID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userAccess` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Location` varchar(128) NOT NULL DEFAULT '', `r` tinyint(1) DEFAULT '0', `w` tinyint(1) DEFAULT '0', `a` tinyint(1) DEFAULT '0', `Inheritance` tinyint(1) DEFAULT '0', `e` tinyint(1) DEFAULT '0', PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%userAccess_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userAccess_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userBlocks` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `uID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%Blocks_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userBlocks_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userGroups` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Name` varchar(32) DEFAULT NULL, `Domain` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`), KEY `%PREFIX%userGroups_FKIndex1` (`userAuth_uID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userIcons` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Filename` varchar(64) NOT NULL DEFAULT '', `Keyword` varchar(32) DEFAULT NULL, `Comments` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%Icons_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userIcons_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userInformation` ( `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Views` int(10) unsigned DEFAULT NULL, `FirstLogin` datetime DEFAULT NULL, `LastLogin` datetime DEFAULT NULL, `MessageStamp` datetime DEFAULT NULL, `FriendStamp` datetime DEFAULT NULL, `OnlineStamp` datetime DEFAULT NULL, PRIMARY KEY (`userAuth_uID`), KEY `%PREFIX%Information_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userInformation_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userInvites` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Value` varchar(32) DEFAULT NULL, `Active` int(1) DEFAULT NULL, `Recipient` varchar(128) DEFAULT NULL, `Stamp` datetime DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%userInvites_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userInvites_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userPreferences` ( `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Theme` int(2) DEFAULT '0', `DefaultProfilePage` int(2) DEFAULT NULL, PRIMARY KEY (`userAuth_uID`), KEY `%PREFIX%Preferences_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userPreferences_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userPrivacy` ( `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `ShowEmail` int(1) DEFAULT NULL, `Visibility` int(1) DEFAULT NULL, PRIMARY KEY (`userAuth_uID`), KEY `%PREFIX%Privacy_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userPrivacy_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userProfile` ( `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Email` varchar(128) NOT NULL DEFAULT '', `Fullname` varchar(64) DEFAULT 'Unknown', `Description` text, `Gender` int(1) DEFAULT NULL, `Birthday` datetime DEFAULT '1980-10-31 10:15:15', `Zipcode` varchar(12) DEFAULT NULL, `Alias` varchar(64) DEFAULT NULL, PRIMARY KEY (`userAuth_uID`), UNIQUE KEY `%PREFIX%PREFIX%userProfile_index` (`Email`), KEY `%PREFIX%Profile_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userProfile_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userQuestions` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `FullQuestion` varchar(255) DEFAULT NULL, `ShortQuestion` varchar(64) DEFAULT NULL, `TypeOf` int(2) DEFAULT NULL, `Language` char(2) DEFAULT NULL, `Concern` varchar(255) DEFAULT NULL, `Visible` int(1) DEFAULT NULL, PRIMARY KEY (`tID`)) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userAnswers` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `userQuestions_tID` int(10) unsigned NOT NULL DEFAULT '0', `Answer` text, PRIMARY KEY (`tID`,`userAuth_uID`,`userQuestions_tID`), KEY `%PREFIX%Answers_FKIndex1` (`userAuth_uID`), KEY `%PREFIX%userAnswers_FKIndex2` (`userQuestions_tID`), CONSTRAINT `%PREFIX%userAnswers_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `%PREFIX%userAnswers_ibfk_2` FOREIGN KEY (`userQuestions_tID`) REFERENCES `%PREFIX%userQuestions` (`tID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userSessions` ( `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Identifier` varchar(32) DEFAULT '00000000000000000000000000000000', `Stamp` datetime DEFAULT NULL, `Address` varchar(16) DEFAULT '0.0.0.0', `Host` varchar(128) DEFAULT NULL, PRIMARY KEY (`userAuth_uID`), KEY `%PREFIX%Sessions_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userSessions_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `%PREFIX%userSettings` ( `tID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userAuth_uID` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `Identifier` varchar(32) NOT NULL DEFAULT '', `Value` varchar(128) DEFAULT NULL, PRIMARY KEY (`tID`,`userAuth_uID`), KEY `%PREFIX%Preferences_FKIndex1` (`userAuth_uID`), CONSTRAINT `%PREFIX%userSettings_ibfk_1` FOREIGN KEY (`userAuth_uID`) REFERENCES `%PREFIX%userAuthorization` (`uID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
INSERT INTO `%PREFIX%userAuthorization` VALUES (0000000001,'admin','0f3d36193ce0d839b3c01d48daab47ac0fdb9ee5fa1a0a0759bf02c003a6b9f6f76b3d1132faa90e3b05017275889f22a035764b2ca5b528fb352ffd94a5072007843cec1d9a3a0c',0,0);
INSERT INTO `%PREFIX%AccessControl` VALUES (1,'admin','/',1,1,1,1);
INSERT INTO `%PREFIX%ExampleCustomers` VALUES (103,'Atelier graphique','Schmitt','Carine ','40.32.2555','54, rue Royale',NULL,'Nantes',NULL,'44000','France',1370,21000),(112,'Signal Gift Stores','King','Sue','7025551838','8489 Strong St.',NULL,'Las Vegas','NV','83030','USA',1166,71800),(114,'Australian Collectors, Co.','Ferguson','Peter','03 9520 4555','636 St Kilda Road','Level 3','Melbourne','Victoria','3004','Australia',1611,117300),(119,'La Rochelle Gifts','Labrune','Janine ','40.67.8555','67, rue des Cinquante Otages',NULL,'Nantes',NULL,'44000','France',1370,118200),(121,'Baane Mini Imports','Bergulfsen','Jonas ','07-98 9555','Erling Skakkes gate 78',NULL,'Stavern',NULL,'4110','Norway',1504,81700),(124,'Mini Gifts Distributors Ltd.','Nelson','Valarie','4155551450','5677 Strong St.',NULL,'San Rafael','CA','97562','USA',1165,210500),(125,'Havel & Zbyszek Co','Piestrzeniewicz','Zbyszek ','(26) 642-7555','ul. Filtrowa 68',NULL,'Warszawa',NULL,'01-012','Poland',NULL,0),(128,'Blauer See Auto, Co.','Keitel','Roland','+49 69 66 90 2555','Lyonerstr. 34',NULL,'Frankfurt',NULL,'60528','Germany',1504,59700),(129,'Mini Wheels Co.','Murphy','Julie','6505555787','5557 North Pendale Street',NULL,'San Francisco','CA','94217','USA',1165,64600),(131,'Land of Toys Inc.','Yu','Kwai','2125557818','897 Long Airport Avenue',NULL,'NYC','NY','10022','USA',1323,114900),(141,'Euro+ Shopping Channel','Freyre','Diego ','(91) 555 94 44','C/ Moralzarzal, 86',NULL,'Madrid',NULL,'28034','Spain',1370,227600),(144,'Volvo Model Replicas, Co','Berglund','Christina ','0921-12 3555','BerguvsvŠgen 8',NULL,'LuleŒ',NULL,'S-958 22','Sweden',1504,53100),(145,'Danish Wholesale Imports','Petersen','Jytte ','31 12 3555','Vinb¾ltet 34',NULL,'Kobenhavn',NULL,'1734','Denmark',1401,83400),(146,'Saveley & Henriot, Co.','Saveley','Mary ','78.32.5555','2, rue du Commerce',NULL,'Lyon',NULL,'69004','France',1337,123900),(148,'Dragon Souveniers, Ltd.','Natividad','Eric','+65 221 7555','Bronz Sok., Bronz Apt. 3/6 Tesvikiye',NULL,'Singapore',NULL,'079903','Singapore',1621,103800),(151,'Muscle Machine Inc','Young','Jeff','2125557413','4092 Furth Circle','Suite 400','NYC','NY','10022','USA',1286,138500),(157,'Diecast Classics Inc.','Yu','Kyung','2155551555','7586 Pompton St.',NULL,'Allentown','PA','70267','USA',1216,100600),(161,'Technics Stores Inc.','Hirano','Juri','6505556809','9408 Furth Circle',NULL,'Burlingame','CA','94217','USA',1165,84600),(166,'Handji Gifts& Co','Victorino','Wendy','+65 224 1555','Village Close - 106 Linden Road Sandown','2nd Floor','Singapore',NULL,'069045','Singapore',1612,97900),(167,'Herkku Gifts','Oeztan','Veysel','+47 2267 3215','Drammen 121, PR 744 Sentrum',NULL,'Bergen',NULL,'N 5804','Norway ',1504,96800),(168,'American Souvenirs Inc','Franco','Sue','2035557845','149 Spinnaker Dr.','Suite 101','New Haven','CT','97823','USA',1286,0),(169,'Porto Imports Co.','de Castro','Isabel ','(1) 356-5555','Estrada da saœde n. 58',NULL,'Lisboa',NULL,'1756','Portugal',NULL,0),(171,'Daedalus Designs Imports','RancŽ','Martine ','20.16.1555','184, chaussŽe de Tournai',NULL,'Lille',NULL,'59000','France',1370,82900),(172,'La Corne D\'abondance, Co.','Bertrand','Marie','(1) 42.34.2555','265, boulevard Charonne',NULL,'Paris',NULL,'75012','France',1337,84300),(173,'Cambridge Collectables Co.','Tseng','Kyung','6175555555','4658 Baden Av.',NULL,'Cambridge','MA','51247','USA',1188,43400),(175,'Gift Depot Inc.','King','Julie','2035552570','25593 South Bay Ln.',NULL,'Bridgewater','CT','97562','USA',1323,84300),(177,'Osaka Souveniers Co.','Kentary','Mory','+81 06 6342 5555','Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku',NULL,'Osaka','Osaka',' 530-0003','Japan',1621,81200),(181,'Vitachrome Inc.','Frick','Michael','2125551500','2678 Kingston Rd.','Suite 101','NYC','NY','10022','USA',1286,76400),(186,'Toys of Finland, Co.','Karttunen','Matti','90-224 8555','Keskuskatu 45',NULL,'Helsinki',NULL,'21240','Finland',1501,96500),(187,'AV Stores, Co.','Ashworth','Victoria','(171) 555-1555','Fauntleroy Circus',NULL,'Manchester',NULL,'EC2 5NT','UK',1501,136800),(189,'Clover Collections, Co.','Cassidy','Dean','+353 1862 1555','25 Maiden Lane','Floor No. 4','Dublin',NULL,'2','Ireland',1504,69400),(198,'Auto-Moto Classics Inc.','Taylor','Leslie','6175558428','16780 Pompton St.',NULL,'Brickhaven','MA','58339','USA',1216,23000),(201,'UK Collectables, Ltd.','Devon','Elizabeth','(171) 555-2282','Berkeley Gardens 12 Brewery',NULL,'Liverpool',NULL,'WX1 6LT','UK',1501,92700),(202,'Canadian Gift Exchange Network','Tannamuri','Yoshi ','(604) 555-3392','1900 Oak St.',NULL,'Vancouver','BC','V3F 2K1','Canada',1323,90300),(204,'Online Mini Collectables','Barajas','Miguel','6175557555','7635 Spinnaker Dr.',NULL,'Brickhaven','MA','58339','USA',1188,68700),(205,'Toys4GrownUps.com','Young','Julie','6265557265','78934 Hillside Dr.',NULL,'Pasadena','CA','90003','USA',1166,90700),(206,'Asian Shopping Network, Co','Walker','Brydey','+612 9411 1555','Penthouse Level, Suntec Tower Three, 8 Temasek',NULL,'Singapore',NULL,'038988','Singapore',NULL,0),(209,'Mini Caravy','Citeaux','Frederique ','','24, place Kleber','','Strasbourg','','67000','France',0,53800),(211,'King Kong Collectables, Co.','Sunwoo','Michael','+852 2251 1555','Bank of China Tower, 1 Garden Road','Level 25','Central Hong Kong',NULL,'','Hong Kong',1621,58600),(216,'Enaco Distributors','Saavedra','Eduardo ','(93) 203 4555','Rambla de Catalu–a, 23',NULL,'Barcelona',NULL,'08022','Spain',1702,60300),(219,'Boards & Toys Co.','Young','Leslie','3105552373','4097 Douglas Av.',NULL,'Glendale','CA','92561','USA',1166,11000),(223,'NatŸrlich Autos','Kloss','Horst ','0372-555188','Taucherstra§e 10',NULL,'Cunewalde',NULL,'01307','Germany',NULL,0),(227,'Heintze Collectables','Ibsen','Palle','86 21 3555','Smagsloget 45',NULL,'rhus',NULL,'8200','Denmark',1401,120800),(233,'QuŽbec Home Shopping Network','Fresnire','Jean ','(514) 555-8054','43 rue St. Laurent',NULL,'MontrŽal','QuŽbec','H1J 1C3','Canada',1286,48700),(237,'ANG Resellers','Camino','Alejandra ','(91) 745 6555','Gran V’a, 1',NULL,'Madrid',NULL,'28001','Spain',NULL,0),(239,'Collectable Mini Designs Co.','Thompson','Valarie','7605558146','361 Furth Circle',NULL,'San Diego','CA','91217','USA',1166,105000),(240,'giftsbymail.co.uk','Bennett','Helen ','(198) 555-8888','Garden House Crowther Way',NULL,'Cowes','Isle of Wight','PO31 7PJ','UK',1501,93900),(242,'Alpha Cognac','Roulet','Annette ','61.77.6555','1 rue Alsace-Lorraine',NULL,'Toulouse',NULL,'31000','France',1370,61100),(247,'Messner Shopping Network','Messner','Renate ','069-0555984','Magazinweg 7',NULL,'Frankfurt',NULL,'60528','Germany',NULL,0),(249,'Amica Models & Co.','Accorti','Paolo ','011-4988555','Via Monte Bianco 34',NULL,'Torino',NULL,'10100','Italy',1401,113000),(250,'Lyon Souveniers','Da Cunha','Daniel','+33 1 46 62 7555','27 rue du Colonel Pierre Avia',NULL,'Paris',NULL,'75508','France',1337,68100),(256,'Auto AssociŽs & Cie.','Tonini','Daniel ','30.59.8555','67, avenue de l\'Europe',NULL,'Versailles',NULL,'78000','France',1370,77900),(259,'Toms SpezialitŠten, Ltd','Pfalzheim','Henriette ','0221-5554327','Mehrheimerstr. 369',NULL,'Kšln',NULL,'50739','Germany',1504,120400),(260,'Royal Canadian Collectables, Ltd.','Lincoln','Elizabeth ','(604) 555-4555','23 Tsawassen Blvd.',NULL,'Tsawassen','BC','T2F 8M4','Canada',1323,89600),(273,'Franken Gifts, Co','Franken','Peter ','089-0877555','Berliner Platz 43',NULL,'MŸnchen',NULL,'80805','Germany',NULL,0),(276,'Anna\'s Decorations, Ltd','O\'Hara','Anna','02 9936 8555','201 Miller Street','Level 15','North Sydney','NSW','2060','Australia',1611,107800),(278,'Rovelli Gifts','Rovelli','Giovanni ','035-640555','Via Ludovico il Moro 22',NULL,'Bergamo',NULL,'24100','Italy',1401,119600),(282,'Souveniers And Things Co.','Huxley','Adrian','+61 2 9495 8555','Monitor Money Building, 815 Pacific Hwy','Level 6','Chatswood','NSW','2067','Australia',1611,93300),(286,'Marta\'s Replicas Co.','Hernandez','Marta','6175558555','39323 Spinnaker Dr.',NULL,'Cambridge','MA','51247','USA',1216,123700),(293,'BG&E Collectables','Pon','Ed','+41 26 425 50 01','Rte des Arsenaux 41 ',NULL,'Fribourg',NULL,'1700','Switzerland',NULL,0),(298,'Vida Sport, Ltd','Holz','Michael ','0897-034555','Grenzacherweg 237',NULL,'Genve',NULL,'1203','Switzerland',1702,141300),(299,'Norway Gifts By Mail, Co.','Klaeboe','Jan','+47 2212 1555','Drammensveien 126 A, PB 744 Sentrum',NULL,'Oslo',NULL,'N 0106','Norway ',1504,95100),(303,'Schuyler Imports','Schuyler','Bradley','+31 20 491 9555','Kingsfordweg 151',NULL,'Amsterdam',NULL,'1043 GR','Netherlands',NULL,0),(307,'Der Hund Imports','Anders','Maria ','030-0074555','Obere Str. 57',NULL,'Berlin',NULL,'12209','Germany',NULL,0),(311,'Oulu Toy Supplies, Inc.','Koskitalo','Pirkko','981-443655','Torikatu 38',NULL,'Oulu',NULL,'90110','Finland',1501,90500),(314,'Petit Auto','Dewey','Catherine ','(02) 5554 67','Rue Joseph-Bens 532',NULL,'Bruxelles',NULL,'B-1180','Belgium',1401,79900),(319,'Mini Classics','Frick','Steve','9145554562','3758 North Pendale Street',NULL,'White Plains','NY','24067','USA',1323,102700),(320,'Mini Creations Ltd.','Tam','Wing C','5085559555','4575 Hillside Dr.',NULL,'New Bedford','MA','50553','USA',1188,94500),(321,'Corporate Gift Ideas Co.','Brown','Julie','6505551386','7734 Strong St.',NULL,'San Francisco','CA','94217','USA',1165,105000),(323,'Down Under Souveniers, Inc','Graham','Mike','+64 9 312 5555','162-164 Grafton Road','Level 2','Auckland ',NULL,'','New Zealand',1612,88000),(324,'Stylish Desk Decors, Co.','Brown','Ann ','(171) 555-0297','35 King George',NULL,'London',NULL,'WX3 6FW','UK',1501,77000),(328,'Tekni Collectables Inc.','Brown','William','2015559350','7476 Moss Rd.',NULL,'Newark','NJ','94019','USA',1323,44100),(333,'Australian Gift Network, Co','Calaghan','Tony','61-7-3844-6555','31 Duncan St. West End',NULL,'South Brisbane','Queensland','4101','Australia',1611,51600),(334,'Suominen Souveniers','Suominen','Kalle','+358 9 8045 555','Software Engineering Center, SEC Oy',NULL,'Espoo',NULL,'FIN-02271','Finland',1501,98800),(335,'Cramer SpezialitŠten, Ltd','Cramer','Philip ','0555-09555','Maubelstr. 90',NULL,'Brandenburg',NULL,'14776','Germany',NULL,0),(339,'Classic Gift Ideas, Inc','Cervantes','Francisca','2155554695','782 First Street',NULL,'Philadelphia','PA','71270','USA',1188,81100),(344,'CAF Imports','Fernandez','Jesus','+34 913 728 555','Merchants House, 27-30 Merchant\'s Quay',NULL,'Madrid',NULL,'28023','Spain',1702,59600),(347,'Men \'R\' US Retailers, Ltd.','Chandler','Michael','2155554369','6047 Douglas Av.',NULL,'Los Angeles','CA','91003','USA',1166,57700),(348,'Asian Treasures, Inc.','McKenna','Patricia ','2967 555','8 Johnstown Road',NULL,'Cork','Co. Cork',NULL,'Ireland',NULL,0),(350,'Marseille Mini Autos','Lebihan','Laurence ','91.24.4555','12, rue des Bouchers',NULL,'Marseille',NULL,'13008','France',1337,65000),(353,'Reims Collectables','Henriot','Paul ','26.47.1555','59 rue de l\'Abbaye',NULL,'Reims',NULL,'51100','France',1337,81100),(356,'SAR Distributors, Co','Kuger','Armand','+27 21 550 3555','Century City-Montague Gardens PO Box 37177',NULL,'Chempet',NULL,' 7442','South Africa',NULL,0),(357,'GiftsForHim.com','MacKinlay','Wales','64-9-3763555','199 Great North Road',NULL,'Auckland',NULL,'','New Zealand',1612,77700),(361,'Kommission Auto','Josephs','Karin','0251-555259','Luisenstr. 48',NULL,'MŸnster',NULL,'44087','Germany',NULL,0),(362,'Gifts4AllAges.com','Yoshido','Juri','6175559555','8616 Spinnaker Dr.',NULL,'Boston','MA','51003','USA',1216,41900),(363,'Online Diecast Creations Co.','Young','Valarie','6035558647','2304 Long Airport Avenue',NULL,'Nashua','NH','62005','USA',1216,114200),(369,'Lisboa Souveniers, Inc','Rodriguez','Lino ','(1) 354-2555','Jardim das rosas n. 32',NULL,'Lisboa',NULL,'1675','Portugal',NULL,0),(376,'Precious Collectables','Wang','Yang ','0452-076555','Hauptstr. 29',NULL,'Bern',NULL,'3012','Switzerland',1702,0),(379,'Collectables For Less Inc.','Nelson','Allen','6175558555','7825 Douglas Av.',NULL,'Brickhaven','MA','58339','USA',1188,70700),(381,'Royale Belge','Cartrain','Pascale ','(071) 23 67 2555','Boulevard Tirou, 255',NULL,'Charleroi',NULL,'B-6000','Belgium',1401,23500),(382,'Salzburg Collectables','Pipps','Georg ','6562-9555','Geislweg 14',NULL,'Salzburg',NULL,'5020','Austria',1401,71700),(385,'Cruz & Sons Co.','Cruz','Arnold','+63 2 555 3587','15 McCallum Street - NatWest Center #13-03',NULL,'Makati City',NULL,'1227 MM','Philippines',1621,81500),(386,'L\'ordine Souveniers','Moroni','Maurizio ','0522-556555','Strada Provinciale 124',NULL,'Reggio Emilia',NULL,'42100','Italy',1401,121400),(398,'Tokyo Collectables, Ltd','Shimamura','Akiko','+81 3 3584 0555','2-2-8 Roppongi',NULL,'Minato-ku','Tokyo','106-0032','Japan',1621,94400),(406,'Auto Canal+ Petit','Perrier','Dominique','(1) 47.55.6555','25, rue Lauriston',NULL,'Paris',NULL,'75016','France',1337,95000),(409,'Stuttgart Collectable Exchange','MŸller','Rita ','0711-555361','Adenauerallee 900',NULL,'Stuttgart',NULL,'70563','Germany',NULL,0),(412,'Extreme Desk Decorations, Ltd','McRoy','Sarah','04 499 9555','101 Lambton Quay','Level 11','Wellington',NULL,'','New Zealand',1612,86800),(415,'Bavarian Collectables Imports, Co.','Donnermeyer','Michael',' +49 89 61 08 9555','Hansastr. 15',NULL,'Munich',NULL,'80686','Germany',1504,77000),(424,'Classic Legends Inc.','Hernandez','Maria','2125558493','5905 Pompton St.','Suite 750','NYC','NY','10022','USA',1286,67500),(443,'Feuer Online Stores, Inc','Feuer','Alexander ','0342-555176','Heerstr. 22',NULL,'Leipzig',NULL,'04179','Germany',NULL,0),(447,'Gift Ideas Corp.','Lewis','Dan','2035554407','2440 Pompton St.',NULL,'Glendale','CT','97561','USA',1323,49700),(448,'Scandinavian Gift Ideas','Larsson','Maria ','0695-34 6555','kergatan 24',NULL,'BrŠcke',NULL,'S-844 67','Sweden',1504,116400),(450,'The Sharp Gifts Warehouse','Frick','Sue','4085553659','3086 Ingle Ln.',NULL,'San Jose','CA','94217','USA',1165,77600),(452,'Mini Auto Werke','Mendel','Roland ','7675-3555','Kirchgasse 6',NULL,'Graz',NULL,'8010','Austria',1401,45300),(455,'Super Scale Inc.','Murphy','Leslie','2035559545','567 North Pendale Street',NULL,'New Haven','CT','97823','USA',1286,95400),(456,'Microscale Inc.','Kuo','Kee','2125551957','5290 North Pendale Street','Suite 200','NYC','NY','10022','USA',1286,39800),(458,'Corrida Auto Replicas, Ltd','Sommer','Mart’n ','(91) 555 22 82','C/ Araquil, 67',NULL,'Madrid',NULL,'28023','Spain',1702,104600),(459,'Warburg Exchange','Ottlieb','Sven ','0241-039123','Walserweg 21',NULL,'Aachen',NULL,'52066','Germany',NULL,0),(462,'FunGiftIdeas.com','Benitez','Violeta','5085552555','1785 First Street',NULL,'New Bedford','MA','50553','USA',1216,85800),(465,'Anton Designs, Ltd.','Anton','Carmen','+34 913 728555','c/ Gobelas, 19-1 Urb. La Florida',NULL,'Madrid',NULL,'28023','Spain',NULL,0),(471,'Australian Collectables, Ltd','Connery','Sean','61-9-3844-6555','7 Allen Street',NULL,'Glen Waverly','Victoria','3150','Australia',1611,60300),(473,'Frau da Collezione','Ricotti','Franco','+39 022515555','20093 Cologno Monzese, via Alessandro Volta 16',NULL,'Milan',NULL,'','Italy',1401,34800),(475,'West Coast Collectables Co.','Thompson','Steve','3105553722','3675 Furth Circle',NULL,'Burbank','CA','94019','USA',1166,55400),(477,'Mit VergnŸgen & Co.','Moos','Hanna ','0621-08555','Forsterstr. 57',NULL,'Mannheim',NULL,'68306','Germany',NULL,0),(480,'Kremlin Collectables, Co.','Semenov','Alexander ','+7 812 293 0521','2 Pobedy Square',NULL,'Saint Petersburg',NULL,'196143','Russia',NULL,0),(481,'Raanan Stores, Inc','Altagar,G M','Raanan','+ 972 9 959 8555','3 Hagalim Blv.,',NULL,'Herzlia',NULL,'47625','Israel',NULL,0),(484,'Iberia Gift Imports, Corp.','Roel','JosŽ Pedro ','(95) 555 82 82','C/ Romero, 33',NULL,'Sevilla',NULL,'41101','Spain',1702,65700),(486,'Motor Mint Distributors Inc.','Hernandez','Rosa','2155559857','11328 Douglas Av.',NULL,'Philadelphia','PA','71270','USA',1323,72600),(487,'Signal Collectibles Ltd.','Taylor','Sue','4155554312','2793 Furth Circle',NULL,'Brisbane','CA','94217','USA',1165,60300),(489,'Double Decker Gift Stores, Ltd','Hardy','Thomas ','(171) 555-7555','120 Hanover Sq.',NULL,'London',NULL,'WA1 1DP','UK',1501,43300),(495,'Diecast Collectables','Franco','Valarie','6175552555','6251 Ingle Ln.',NULL,'Boston','MA','51003','USA',1188,85100),(496,'Kelly\'s Gift Shop','Snowden','Tony','+64 9 5555500','Arenales 1938 3\'A\'',NULL,'Auckland ',NULL,'','New Zealand',1612,110000);
INSERT INTO `%PREFIX%Janitor` VALUES (NOW());
INSERT INTO `%PREFIX%NetworkNodes` VALUES (1,'Official beta test site for the Appleseed Project: The first open source, fully decentralized social networking software.','appleseedproject.org','trusted','','public',1,'2011-01-09 15:20:27','2011-01-09 15:20:27','2011-01-09 15:20:27','0000-00-00 00:00:00','http','QS/0.1.1',1);
INSERT INTO `%PREFIX%SchemaVersions` VALUES ('2011-01-09 21:20:27','0.7.9','+PageLinks +NotificationsOutgoing.Title +NotificationsIncoming.Title -journalPrivacy -journalPost +JournalEntries -contentArticles +SearchIndexes +NotificationsOutgoing.Feedback +NotificationsOutgoing.Comments +NotificationsIncoming.Feedback +NotificationsIncoming.Comments +FriendPing +NetworkNodes >NetworkNodes.Domain=\"appleseedproject.org\" +SchemaVersions >SchemaVersions.Version=\"0.7.9\" ');
INSERT INTO `%PREFIX%SystemUpdate` VALUES (4,'update.appleseedproject.org',1);
INSERT INTO `%PREFIX%contentPages` VALUES (0000000001,'Frequently Asked Questions','<p><b>FAQ</b> is an <a href=\"/wiki/Abbreviation\" title=\"Abbreviation\">abbreviation</a> for \"Frequently Asked Question(s)\". The term refers to listed questions and answers, all supposed to be frequently asked in some context, and pertaining to a particular topic. \r\n\r\nSince the <a href=\"/wiki/Acronym\" title=\"Acronym\">acronym</a> originated in textual media, its <a href=\"/wiki/Pronunciation\" title=\"Pronunciation\">pronunciation</a> varies; both \"fak\" and \"F.A.Q.\" are commonly heard (and therefore, when used with an indefinite article, it is either \"a FAQ\" or \"an FAQ\"). \r\n\r\nDepending on usage, the term may refer specifically to a single frequently-asked question, or to an assembled list of many questions and their answers. An alternative suggestion is that FAQ is actually a clumsily-constructed <a href=\"/wiki/Three_letter_acronym\" title=\"Three letter acronym\">three letter acronym</a> purported to have come from computer IT specialists, frustrated with answering over and over again the same, perceived stupid questions from computer users, and which secretly stands for the pronunciation \"fah-queue\". \r\n\r\nFor example: \"Please read the FAQ list to ensure your question has not already been answered before bothering the overworked IT department\".</p>',2,'faq','Default_Template.atpl','en','content.faq','#content #faq #container {\r\n width:562px;\r\n float:left;\r\n position:relative;\r\n left:-75px;\r\n clear:both;\r\n}\r\n\r\n#content #faq #caption {\r\n position:relative;\r\n width:562px;\r\n float:left;\r\n left:-75px;\r\n clear:both;\r\n font-size:14px;\r\n font-weight:bold;\r\n}'),(0000000003,'About Us','(More information available at <a href=\'http://opensource.appleseedproject.org\'>opensource.appleseedproject.org</a>)\r\n\r\n <h1>PROJECT OVERVIEW</h1>\r\n <br />\r\n\r\n The Appleseed Project is an effort to create open source \r\n <a href=\'http://en.wikipedia.org/wiki/Social_networking\'>Social Networking</a> \r\n software that is based on a distributed model. For instance, a profile on one \r\n Appleseed website could \"friend\" a profile on another Appleseed website, and \r\n the two profiles could interact with each other.\r\n \r\n <br /><br />\r\n\r\n Apart from being distributed, Appleseed will also have a strong focus on\r\n privacy and security, as well as a commitment to seeing the user as an\r\n online citizen, as opposed to a consumer to be targetted. This is in\r\n stark contrast to current social networking websites, who rely heavily on\r\n ad placement and data mining of their users.\r\n \r\n <br /><br /> \r\n\r\n The first goal is to create a codebase for basic interaction, such as \r\n creating profiles, creating and participating in message groups, journals and\r\n comments, etc.\r\n\r\n <br /><br />\r\n\r\n Eventually, Appleseed will encompass many different aspects, from mail to\r\n messaging to journals/blogs to photo uploads and management. A module\r\n architecture is also in the works for even greater extensibility.\r\n\r\n <br /><br />\r\n\r\n Development currently uses Object Oriented PHP4, MySQL (InnoDB), XHTML, \r\n Javascript, and CSS2. Mozilla/Firefox will be the target platform.\r\n\r\n <br /><br />\r\n <h1>PROGRESS - 40% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n + + + + . . . . . . . . . . . . . . . </h1>\r\n\r\n April 09, 2006\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp;\r\n\r\n (unreleased)\r\n <br /><br />\r\n\r\n I\'ve completed the bulk of the Journaling and Messaging subsystems. A new\r\n release is coming very soon. The test site (<a href=\'http://www.appleseedproject.org\'>www.appleseedproject.org</a>)\r\n has been updated with the new features.\r\n <br /><br />\r\n Next comes a huge code clean, and then the fun part: Adding friends to your\r\n friends list.\r\n \r\n <br /><br />\r\n <h1>PROGRESS - 21% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n + + + + . . . . . . . . . . . . . . . </h1>\r\n\r\n January 13, 2006\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp;\r\n\r\n (version 0.2.1 beta)\r\n <br /><br />\r\n\r\n Appleseed 0.2.1 Beta has been released. You can download the source\r\n from the <a href=\'http://sourceforge.net/projects/appleseed/\'>Appleseed\r\n Sourceforge Project Page</a>.<br /><br />\r\n\r\n You can also download the file directly here:<br /><br />\r\n <center><a href=\'http://prdownloads.sourceforge.net/appleseed/appleseed-0.2.1-beta.tar.gz?download\'>appleseed-0.2.1-beta.tar.gz</a></center>\r\n <br /><br />\r\n\r\n This version includes a lot of cleanups, and invites and registering an account.\r\n Version 0.3 is soon to come.\r\n\r\n <br /><br />\r\n A test site has also been set up at <a href=\'http://www.appleseedproject.org\'>www.appleseedproject.org</a>. If you would like to help test,\r\n please send an email to <a href=\'mailto:michael.chisari@gmail.com\'>michael.chisari@gmail.com</a>\r\n \r\n <br /><br />\r\n <h1>PROGRESS - 20% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n + + + + . . . . . . . . . . . . . . . </h1>\r\n\r\n October 03, 2005\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp;\r\n\r\n (initial source release)\r\n <br /><br />\r\n\r\n Appleseed 0.2.0 Beta has been released. You can download the source\r\n from the <a href=\'http://sourceforge.net/projects/appleseed/\'>Appleseed\r\n Sourceforge Project Page</a>.<br /><br />\r\n\r\n You can also download the file directly here:<br /><br />\r\n <center><a href=\'http://prdownloads.sourceforge.net/appleseed/appleseed-0.2.0.beta.tar.gz?download\'>appleseed-0.2.0.beta.tar.gz</a></center>\r\n \r\n <br /><br />\r\n\r\n <h1>PROGRESS - 18% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n + + + + . . . . . . . . . . . . . . . </h1>\r\n\r\n September 21, 2005\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp;\r\n\r\n (source unreleased)\r\n <br /><br />\r\n \r\n Photo management has been added. You can now create and manage photo albums,\r\n and upload and manage photos. A privacy system (for restricting access to\r\n photo albums, and later, journals and other areas) has been implemented as \r\n well, and, while still in it\'s infancy, is looking pretty good. The \r\n commenting subsystem is also working.\r\n <br /><br />\r\n\r\n We\'re looking at a source release very soon now. I\'ll be finishing up the\r\n commenting subsystem, cleaning up the code, and giving it a good once-over\r\n so as not to completely embarrass myself. And then the fun begins. I\'m\r\n also going to be setting up an invite-only site for beta testers.\r\n\r\n <br /><br />\r\n\r\n Stay tuned...\r\n \r\n <br /><br />\r\n <h1>PROGRESS - 15% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n + + + . . . . . . . . . . . . . . . . </h1>\r\n\r\n July 20, 2005\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n (source unreleased)\r\n <br /><br />\r\n\r\n \r\n Work has resumed. I\'ve added the beginnings of an invite system, and you can\r\n upload a new profile photo and icons. The foundation for photo management is\r\n slowly being built as well.\r\n <br /><br />\r\n\r\n Due to the recent <a href=\'http://slashdot.org/article.pl?sid=05/07/19/179201\'>acquisition</a> of <a href=\'http://www.myspace.com\'>MySpace</a> by\r\n <a href=\'http://en.wikipedia.org/wiki/Rupert_Murdoch\'>Rupert Murdoch</a>, a\r\n lot of interest in Appleseed has been sparked. Given that, I\'m doing my best\r\n to stop myself from adding features and do a code review so that I can release\r\n the source much sooner than anticipated. Stay tuned.\r\n \r\n <br /><br />\r\n <h1>PROGRESS - 10% \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;\r\n\r\n + + . . . . . . . . . . . . . . . . . </h1>\r\n May 15, 2005\r\n &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \r\n (source unreleased)\r\n <br /><br />\r\n\r\n \r\n This is just an estimate, definitely nothing scientific. A good amount\r\n of the foundation has been built and tested, so development is going a lot\r\n faster now. The security system has been completed, \"themes\" are in place,\r\n user logins are working, and profiles can be configured. \r\n\r\n <br /><br />\r\n\r\n Work right now is focused on going through and commenting and cleaning up\r\n code before moving on to the next step, which will be adding and managing\r\n friends. At first, only local friends will be able to be added, but the\r\n hooks are there to add friends from a remote Appleseed site.',5,'about','Default_Template.atpl','en','content.about','#content #about #container {\r\n width:562px;\r\n float:left;\r\n position:relative;\r\n left:-75px;\r\n clear:both;\r\n}\r\n\r\n#content #about #caption {\r\n position:relative;\r\n width:562px;\r\n float:left;\r\n left:-75px;\r\n clear:both;\r\n font-size:14px;\r\n font-weight:bold;\r\n}');
INSERT INTO `%PREFIX%systemConfig` VALUES (1,'Theme','default'),(2,'Framework','default'),(3,'CascadeStrings','ON'),(4,'CascadeTooltips','ON'),(5,'UseInvites','YES'),(6,'InviteAmount','5'),(7,'StorageLimit','50'),(8,'Language','en'),(9,'NodeSummary','<asd id=\'global\' name=\'SITEDOMAIN\' case=\'proper\' /> is a new <a href=\'http://opensource.appleseedproject.org\'>Appleseed</a> node.'),(10,'Shutdown','NO');
INSERT INTO `%PREFIX%systemMaintenance` VALUES (1,'UPDATE_NODE_NETWORK','2010-11-11 08:37:03',120),(2,'VERIFY_NODE_NETWORK','2010-11-11 08:37:03',120),(3,'CLEAR_EXPIRED_TOKENS_AND_SESSIONS','2010-11-11 08:37:03',240);
INSERT INTO `%PREFIX%systemOptions` VALUES (1,'FORMATTING','No Formatting','0',0,NULL),(2,'FORMATTING','ASD Tags Only','1',1,NULL),(3,'FORMATTING','Basic HTML','2',0,NULL),(4,'FORMATTING','Extended HTML','3',0,NULL),(5,'FORMATTING','Secure HTML','4',0,NULL),(6,'FORMATTING','Unprocessed','5',0,NULL),(7,'FORMATTING','Viewable','6',0,NULL),(8,'BOOLEAN','True','1',0,NULL),(9,'BOOLEAN','False','0',1,NULL),(10,'LANGUAGE','English','en',0,NULL),(11,'LANGUAGE','Espanol','es',0,NULL),(12,'LANGUAGE','Francais','fr',0,NULL),(24,'QUESTIONTYPE','Menu','0',1,NULL),(25,'QUESTIONTYPE','Checklist','1',0,NULL),(26,'QUESTIONTYPE','String','2',0,NULL),(31,'QUESTIONVISIBILITY','Yes','1',1,NULL),(32,'QUESTIONVISIBILITY','No','0',0,NULL),(33,'QUESTIONVISIBILITY','Logged In','2',0,NULL),(34,'QUESTIONTYPE','Web Link','3',0,NULL),(35,'QUESTIONTYPE','Linked String','4',0,NULL),(36,'GENDER','No Answer','',1,NULL),(37,'GENDER','Female','0',0,NULL),(38,'GENDER','Male','1',0,NULL),(39,'GENDER','Transgender','2',0,NULL),(40,'MONTH','January','1',1,NULL),(41,'MONTH','February','2',0,NULL),(42,'MONTH','March','3',0,NULL),(43,'MONTH','April','4',0,NULL),(44,'MONTH','May','5',0,NULL),(45,'MONTH','June','6',0,NULL),(46,'MONTH','July','7',0,NULL),(47,'MONTH','August','8',0,NULL),(48,'MONTH','September','9',0,NULL),(49,'MONTH','October','10',0,NULL),(50,'MONTH','November','11',0,NULL),(51,'MONTH','December','12',0,NULL),(53,'QIMSERVICE','No Answer','',1,NULL),(54,'QIMSERVICE','AOL IM','0',0,NULL),(55,'QIMSERVICE','Yahoo! IM','1',0,NULL),(56,'QIMSERVICE','MSN Messenger','2',0,NULL),(57,'QIMSERVICE','Jabber','3',0,NULL),(58,'QSTATUS','No Answer','',1,NULL),(59,'QSTATUS','Single','0',0,NULL),(60,'QSTATUS','Single (Not Looking)','1',0,NULL),(61,'QSTATUS','In A Relationship','2',0,NULL),(62,'QSTATUS','Open Relationship','3',0,NULL),(63,'QSTATUS','Married','4',0,NULL),(64,'QSTATUS','Divorced','5',0,NULL),(65,'QSTATUS','Widowed/Widower','6',0,NULL),(66,'QBODYTYPE','No Answer','',1,NULL),(67,'QBODYTYPE','Slim / Slender','0',0,NULL),(68,'QBODYTYPE','Athletic','1',0,NULL),(69,'QBODYTYPE','Average','2',0,NULL),(70,'QBODYTYPE','A little extra.','3',0,NULL),(71,'QBODYTYPE','More to love!','4',0,NULL),(72,'QASTROSIGN','No Answer','',1,NULL),(73,'QASTROSIGN','Aries','0',0,NULL),(74,'QASTROSIGN','Taurus','1',0,NULL),(75,'QASTROSIGN','Gemini','2',0,NULL),(76,'QASTROSIGN','Cancer','3',0,NULL),(77,'QASTROSIGN','Leo','4',0,NULL),(78,'QASTROSIGN','Virgo','5',0,NULL),(79,'QASTROSIGN','Libra','6',0,NULL),(80,'QASTROSIGN','Scorpio','7',0,NULL),(81,'QASTROSIGN','Sagittarius','8',0,NULL),(82,'QASTROSIGN','Capricorn','9',0,NULL),(83,'QASTROSIGN','Aquarius','10',0,NULL),(84,'QASTROSIGN','Pisces','11',0,NULL),(85,'QSMOKER','No Answer','',1,NULL),(86,'QSMOKER','Yes','0',0,NULL),(87,'QSMOKER','No','1',0,NULL),(88,'QSMOKER','Occasionally','2',0,NULL),(89,'QDRINKER','No Answer','',1,NULL),(90,'QDRINKER','Yes','0',0,NULL),(91,'QDRINKER','No','1',0,NULL),(92,'QDRINKER','Occasionally','2',0,NULL),(93,'QHEREFOR','Friends','0',1,NULL),(94,'QHEREFOR','Networking','1',0,NULL),(95,'QHEREFOR','Dating','2',0,NULL),(96,'QHEREFOR','Serious Relationship','3',0,NULL),(103,'QBLOODTYPE','No Answer','',1,NULL),(104,'QBLOODTYPE','A','A',0,NULL),(105,'QBLOODTYPE','B','B',0,NULL),(106,'QBLOODTYPE','AB','AB',0,NULL),(107,'QBLOODTYPE','O','O',0,NULL),(108,'QBLOODTYPE','Looking for a donor','LOOKING',0,NULL),(109,'QBLOODTYPE','A+','A+',0,NULL),(110,'QBLOODTYPE','B+','B+',0,NULL),(111,'QBLOODTYPE','A-','A-',0,NULL),(112,'QBLOODTYPE','B-','B-',0,NULL),(113,'QBLOODTYPE','O+','O+',0,NULL),(114,'QBLOODTYPE','O-','O-',0,NULL),(115,'ACCOUNTSTANDING','Active','0',1,NULL),(116,'ACCOUNTSTANDING','Inactive','1',0,NULL),(117,'ACCOUNTSTANDING','Suspended','2',0,NULL),(118,'ACCOUNTSTANDING','Deleted','3',0,NULL),(119,'ACCOUNTVERIFICATION','Verified','0',1,NULL),(120,'ACCOUNTVERIFICATION','Pending','1',0,NULL),(121,'ACCOUNTVERIFICATION','Denied','2',0,NULL),(124,'PRIVACY','Allowed','0',1,NULL),(125,'PRIVACY','Screened','1',0,NULL),(126,'PRIVACY','Restricted','2',0,NULL),(127,'PRIVACY','Blocked','3',0,NULL),(128,'RESTRICTIONS','Unrestricted','0',1,NULL),(129,'RESTRICTIONS','No Anonymous','1',0,NULL),(130,'RESTRICTIONS','Friends Only','2',0,NULL),(131,'PHOTOLISTING','Default View','1',1,NULL),(132,'PHOTOLISTING','All','2',0,'en'),(133,'PHOTOLISTING','Compact','3',0,'en'),(134,'PHOTOLISTING','Standard','4',0,'en'),(136,'PHOTOLISTING','Full','5',0,'en'),(137,'PHOTOLISTINGEDITOR','Default View','1',1,NULL),(139,'PHOTOLISTINGEDITOR','All','2',0,'en'),(140,'PHOTOLISTINGEDITOR','Compact','3',0,'en'),(141,'PHOTOLISTINGEDITOR','Standard','4',0,'en'),(143,'PHOTOLISTINGEDITOR','Full','5',0,'en'),(144,'VISIBILITY','Visible','0',1,NULL),(145,'VISIBILITY','Hidden','1',0,NULL),(146,'COMMENTVIEW','Default View','1',1,NULL),(147,'COMMENTVIEW','Nested','2',0,NULL),(148,'COMMENTVIEW','Threaded','3',0,NULL),(149,'COMMENTVIEW','Flat','4',0,NULL),(150,'COMMENTVIEW','Compact','5',0,NULL),(151,'COMMENTVIEWADMIN','Editor View','1',1,NULL),(152,'COMMENTVIEWADMIN','Nested','2',0,NULL),(153,'COMMENTVIEWADMIN','Threaded','3',0,NULL),(154,'COMMENTVIEWADMIN','Flat','4',0,NULL),(155,'COMMENTVIEWADMIN','Compact','5',0,NULL),(156,'QIMSERVICE','Google Talk','4',0,NULL),(165,'JOURNALVIEW','Default View','1',1,NULL),(166,'JOURNALVIEW','Single','2',0,NULL),(167,'JOURNALVIEW','Multiple','3',0,NULL),(168,'JOURNALVIEW','Listing','4',0,NULL),(169,'JOURNALVIEWADMIN','Default View','1',0,NULL),(170,'JOURNALVIEWADMIN','Single','2',0,NULL),(171,'JOURNALVIEWADMIN','Multiple','3',0,NULL),(172,'JOURNALVIEWADMIN','Listing','4',0,NULL),(173,'JOURNALVIEWADMIN','Editor View','5',1,NULL),(174,'QSTATUS','It\'s Complicated.','7',0,NULL),(175,'LANGUAGE','Italiano','it',0,NULL),(176,'QSTATUS','Engaged','8',0,NULL),(177,'PHOTOLISTINGEDITOR','Editor View','6',0,'en'),(178,'VERIFICATION','Pending','0',1,NULL),(179,'VERIFICATION','Approved','1',0,NULL),(180,'VERIFICATION','Rejected','2',0,NULL),(181,'NOTIFICATION','On','1',1,NULL),(182,'NOTIFICATION','Off','2',0,NULL),(183,'GROUPMEMBERSHIP','Open To Public','1',1,NULL),(184,'GROUPMEMBERSHIP','Approval Required','2',0,NULL),(185,'GROUPMEMBERSHIP','Invite Only','3',0,NULL),(187,'GROUPMEMBERACTION','(no action)','0',1,'en'),(188,'GROUPMEMBERACTION','Remove Member','2',0,'en'),(189,'GROUPPENDINGACTION','(no action)','0',1,'en'),(190,'GROUPPENDINGACTION','Approve Member','1',0,'en'),(191,'GROUPPENDINGACTION','Remove Member','2',0,'en'),(192,'GROUPVIEW','Default View','1',1,'en'),(193,'GROUPVIEW','Nested','2',0,'en'),(194,'GROUPVIEW','Threaded','3',0,'en'),(195,'GROUPVIEW','Flat','4',0,'en'),(196,'GROUPVIEW','Compact','5',0,'en'),(197,'GROUPVIEWADMIN','Editor View','1',1,'en'),(198,'GROUPVIEWADMIN','Nested','2',0,'en'),(199,'GROUPVIEWADMIN','Threaded','3',0,'en'),(200,'GROUPVIEWADMIN','Flat','4',0,'en'),(201,'GROUPVIEWADMIN','Compact','5',0,'en'),(202,'GROUPACCESS','Open','10',1,'en'),(203,'GROUPACCESS','Open (Private)','20',0,'en'),(204,'GROUPACCESS','Approval Required (Public)','30',0,'en'),(205,'GROUPACCESS','Approval Required (Private)','40',0,'en'),(206,'GROUPACCESS','Invite Only (Public)','50',0,'en'),(207,'GROUPACCESS','Invite Only (Private)','60',0,'en'),(208,'TRUST','Trusted','10',1,'en'),(209,'TRUST','Blocked','20',0,'en'),(210,'SHARE','Public','10',1,'en'),(211,'SHARE','Trusted','20',0,'en'),(212,'SHARE','Private','30',0,'en'),(213,'INHERIT','True','1',1,'en'),(214,'INHERIT','False','0',0,'en'),(215,'CALLBACK','True','1',1,'en'),(216,'CALLBACK','False','0',0,'en'),(217,'CIRCLESUBVIEW','Default','10',1,'en'),(218,'CIRCLESUBVIEW','Icons','20',1,'en'),(219,'CIRCLESUBVIEW','Info','30',0,'en'),(220,'CIRCLESUBVIEW','Journals','40',0,'en'),(221,'CIRCLESUBVIEW','Photos','50',0,'en');
INSERT INTO `%PREFIX%userAccess` VALUES (1,0000000001,'/',1,1,1,1,1);
INSERT INTO `%PREFIX%userIcons` VALUES (1,0000000001,'__noicon__','(no icon)',NULL);
INSERT INTO `%PREFIX%userProfile` VALUES (0000000001,'admin@localhost','Administrator','<center><b>I am root!</b></center>',NULL,'1969-10-31 00:00:00','11111',NULL);
INSERT INTO `%PREFIX%userQuestions` VALUES (1,'Where are you located?','LOCATION:',4,'en','',1),(2,'What is your screen name?','SCREEN NAME:',2,'en',NULL,1),(3,'What Instant Messaging service do you use?','IM TYPE:',0,'en','QIMSERVICE',1),(4,'What\'s your website address?','WEBSITE:',3,'en','',1),(5,'What is your relationship status?','STATUS:',0,'en','QSTATUS',1),(6,'What kind of relationship are you looking for?','HERE FOR:',1,'en','QHEREFOR',1),(7,'What\'s your hometown?','HOMETOWN:',2,'en','',1),(8,'How tall are you?','HEIGHT:',2,'en','',1),(9,'Describe your body type:','BODY TYPE:',0,'en','QBODYTYPE',1),(10,'What\'s your astrological sign?','SIGN:',0,'en','QASTROSIGN',1),(11,'Are you a smoker?','SMOKER:',0,'en','QSMOKER',1),(12,'Do you drink?','DRINKER:',0,'en','QDRINKER',1),(13,'What is your blood type?','BLOOD TYPE:',0,'en','QBLOODTYPE',1),(14,'Describe your occupation:','OCCUPATON:',2,'en','',1),(15,'List some of your general interests (seperated by commas):','GENERAL:',4,'en','',1),(16,'List some of your favorite music groups:','MUSIC:',4,'en','',1),(17,'List some of your favorite movies:','MOVIES:',4,'en','',1),(18,'List some of your favorite books:','BOOKS:',4,'en','',1);
Jump to Line
Something went wrong with that request. Please try again.