-- MySQL dump 9.11
--
-- Host: localhost    Database: vendor
-- ------------------------------------------------------
-- Server version	4.0.22-log

--
-- Table structure for table `access`
--

CREATE TABLE access (
  aid tinyint(10) NOT NULL auto_increment,
  mask varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  status tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (aid)
) TYPE=MyISAM;

--
-- Table structure for table `accesslog`
--

CREATE TABLE accesslog (
  title varchar(255) default NULL,
  path varchar(255) default NULL,
  url varchar(255) default NULL,
  hostname varchar(128) default NULL,
  uid int(10) unsigned default '0',
  timestamp int(11) unsigned NOT NULL default '0',
  KEY accesslog_timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table `aggregator_category`
--

CREATE TABLE aggregator_category (
  cid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  block tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (cid),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table `aggregator_category_feed`
--

CREATE TABLE aggregator_category_feed (
  fid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  PRIMARY KEY  (fid,cid)
) TYPE=MyISAM;

--
-- Table structure for table `aggregator_category_item`
--

CREATE TABLE aggregator_category_item (
  iid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  PRIMARY KEY  (iid,cid)
) TYPE=MyISAM;

--
-- Table structure for table `aggregator_feed`
--

CREATE TABLE aggregator_feed (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  refresh int(10) NOT NULL default '0',
  checked int(10) NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  image longtext NOT NULL,
  etag varchar(255) NOT NULL default '',
  modified int(10) NOT NULL default '0',
  block tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (fid),
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table `aggregator_item`
--

CREATE TABLE aggregator_item (
  iid int(10) NOT NULL auto_increment,
  fid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  author varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  timestamp int(11) default NULL,
  PRIMARY KEY  (iid)
) TYPE=MyISAM;

--
-- Table structure for table `authmap`
--

CREATE TABLE authmap (
  aid int(10) unsigned NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  authname varchar(128) NOT NULL default '',
  module varchar(128) NOT NULL default '',
  PRIMARY KEY  (aid),
  UNIQUE KEY authname (authname)
) TYPE=MyISAM;

--
-- Table structure for table `blocks`
--

CREATE TABLE blocks (
  module varchar(64) NOT NULL default '',
  delta varchar(32) NOT NULL default '0',
  status tinyint(2) NOT NULL default '0',
  weight tinyint(1) NOT NULL default '0',
  region tinyint(1) NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  custom tinyint(2) NOT NULL default '0',
  throttle tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table `book`
--

CREATE TABLE book (
  nid int(10) unsigned NOT NULL default '0',
  parent int(10) NOT NULL default '0',
  weight tinyint(3) NOT NULL default '0',
  log longtext,
  PRIMARY KEY  (nid),
  KEY parent (parent)
) TYPE=MyISAM;

--
-- Table structure for table `boxes`
--

CREATE TABLE boxes (
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
  body longtext,
  info varchar(128) NOT NULL default '',
  format int(4) NOT NULL default '0',
  PRIMARY KEY  (bid),
  UNIQUE KEY title (title),
  UNIQUE KEY info (info)
) TYPE=MyISAM;

--
-- Table structure for table `buddylist`
--

CREATE TABLE buddylist (
  uid int(10) unsigned NOT NULL default '0',
  buddy int(10) unsigned NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  received tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (uid,buddy)
) TYPE=MyISAM;

--
-- Table structure for table `cache`
--

CREATE TABLE cache (
  cid varchar(255) NOT NULL default '',
  data longtext,
  expire int(11) NOT NULL default '0',
  created int(11) NOT NULL default '0',
  headers text,
  PRIMARY KEY  (cid),
  KEY expire (expire)
) TYPE=MyISAM;

--
-- Table structure for table `comments`
--

CREATE TABLE comments (
  cid int(10) NOT NULL auto_increment,
  pid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  subject varchar(64) NOT NULL default '',
  comment longtext NOT NULL,
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  score mediumint(9) NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
  format int(4) NOT NULL default '0',
  thread varchar(255) NOT NULL default '',
  users longtext,
  name varchar(60) default NULL,
  mail varchar(64) default NULL,
  homepage varchar(255) default NULL,
  PRIMARY KEY  (cid),
  KEY lid (nid)
) TYPE=MyISAM;

--
-- Table structure for table `contact`
--

CREATE TABLE contact (
  nid int(10) unsigned NOT NULL default '0',
  hash varchar(32) NOT NULL default '',
  mail varchar(64) NOT NULL default '',
  mail_preference enum('optin','optout','not_specified') NOT NULL default 'optin',
  mail_preference_csid int(10) unsigned NOT NULL default '0',
  mail_type enum('text','html','not_specified') NOT NULL default 'text',
  mail_type_csid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid),
  UNIQUE KEY hash (hash),
  KEY mail (mail),
  KEY hash_2 (hash)
) TYPE=MyISAM;

--
-- Table structure for table `contact_data`
--

CREATE TABLE contact_data (
  nid int(10) unsigned NOT NULL default '0',
  csid int(10) unsigned NOT NULL default '0',
  ffid int(10) unsigned NOT NULL default '0',
  active tinyint(1) unsigned NOT NULL default '0',
  data text NOT NULL,
  PRIMARY KEY  (nid,csid,ffid),
  KEY active (active),
  KEY data (data(16))
) TYPE=MyISAM;

--
-- Table structure for table `contact_search`
--

CREATE TABLE contact_search (
  sid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  type enum('search','permission') NOT NULL default 'search',
  edit text NOT NULL,
  PRIMARY KEY  (sid),
  KEY name (name),
  KEY type (type)
) TYPE=MyISAM;

--
-- Table structure for table `contact_sources`
--

CREATE TABLE contact_sources (
  csid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  weight tinyint(2) unsigned NOT NULL default '0',
  active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (csid),
  KEY name (name),
  KEY weight (weight),
  KEY active (active)
) TYPE=MyISAM;

--
-- Table structure for table `directory`
--

CREATE TABLE directory (
  link varchar(255) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  mail varchar(128) NOT NULL default '',
  slogan longtext NOT NULL,
  mission longtext NOT NULL,
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (link)
) TYPE=MyISAM;

--
-- Table structure for table `event`
--

CREATE TABLE event (
  nid int(10) unsigned NOT NULL default '0',
  start int(10) unsigned NOT NULL default '0',
  galleries varchar(255) NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY start (start)
) TYPE=MyISAM;

--
-- Table structure for table `event_field_data`
--

CREATE TABLE event_field_data (
  name varchar(128) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  data text NOT NULL,
  PRIMARY KEY  (name,nid)
) TYPE=MyISAM;

--
-- Table structure for table `event_item`
--

CREATE TABLE event_item (
  iid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  latitude decimal(10,6) NOT NULL default '0.000000',
  longitude decimal(10,6) NOT NULL default '0.000000',
  PRIMARY KEY  (iid),
  UNIQUE KEY nid (nid),
  KEY latitude (latitude),
  KEY longitude (longitude)
) TYPE=MyISAM;

--
-- Table structure for table `files`
--

CREATE TABLE files (
  fid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  filepath varchar(255) NOT NULL default '',
  filemime varchar(255) NOT NULL default '',
  filesize int(10) unsigned NOT NULL default '0',
  list tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

--
-- Table structure for table `filter_formats`
--

CREATE TABLE filter_formats (
  format int(4) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  roles varchar(255) NOT NULL default '',
  cache tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (format)
) TYPE=MyISAM;

--
-- Table structure for table `filters`
--

CREATE TABLE filters (
  format int(4) NOT NULL default '0',
  module varchar(64) NOT NULL default '',
  delta tinyint(2) NOT NULL default '0',
  weight tinyint(2) NOT NULL default '0',
  KEY weight (weight)
) TYPE=MyISAM;

--
-- Table structure for table `flexinode_data`
--

CREATE TABLE flexinode_data (
  nid int(10) unsigned NOT NULL default '0',
  field_id int(10) unsigned NOT NULL default '0',
  textual_data mediumtext NOT NULL,
  numeric_data int(10) unsigned NOT NULL default '0',
  serialized_data mediumtext NOT NULL,
  PRIMARY KEY  (nid,field_id)
) TYPE=MyISAM;

--
-- Table structure for table `flexinode_field`
--

CREATE TABLE flexinode_field (
  field_id int(10) unsigned NOT NULL default '0',
  ctype_id int(10) unsigned NOT NULL default '0',
  label varchar(255) NOT NULL default '',
  default_value mediumtext NOT NULL,
  weight int(10) NOT NULL default '0',
  required int(1) NOT NULL default '0',
  show_teaser int(1) NOT NULL default '0',
  show_table int(1) NOT NULL default '0',
  rows int(10) unsigned NOT NULL default '0',
  field_type varchar(255) NOT NULL default '',
  options text NOT NULL,
  description varchar(255) NOT NULL default '',
  PRIMARY KEY  (field_id),
  KEY ctype_id (ctype_id)
) TYPE=MyISAM;

--
-- Table structure for table `flexinode_type`
--

CREATE TABLE flexinode_type (
  ctype_id int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  help text NOT NULL,
  PRIMARY KEY  (ctype_id)
) TYPE=MyISAM;

--
-- Table structure for table `form_fields`
--

CREATE TABLE form_fields (
  ffid int(10) unsigned NOT NULL auto_increment,
  fid int(10) unsigned NOT NULL default '0',
  title varchar(255) default NULL,
  name varchar(128) default NULL,
  explanation text,
  page varchar(255) default NULL,
  type varchar(128) default NULL,
  weight tinyint(1) NOT NULL default '0',
  required tinyint(1) NOT NULL default '0',
  flags text,
  validation text,
  options text,
  multiple tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ffid),
  UNIQUE KEY fid (fid,name)
) TYPE=MyISAM;

--
-- Table structure for table `forms`
--

CREATE TABLE forms (
  fid int(10) unsigned NOT NULL default '0',
  type varchar(16) NOT NULL default '',
  created int(10) NOT NULL default '0',
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

--
-- Table structure for table `forum`
--

CREATE TABLE forum (
  nid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY tid (tid)
) TYPE=MyISAM;

--
-- Table structure for table `history`
--

CREATE TABLE history (
  uid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (uid,nid)
) TYPE=MyISAM;

--
-- Table structure for table `htmlarea`
--

CREATE TABLE htmlarea (
  textarea varchar(255) NOT NULL default '',
  status tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (textarea)
) TYPE=MyISAM;

--
-- Table structure for table `image`
--

CREATE TABLE image (
  nid int(10) unsigned NOT NULL default '0',
  image_path varchar(255) NOT NULL default '',
  thumb_path varchar(255) NOT NULL default '',
  preview_path varchar(255) NOT NULL default '',
  image_list longtext,
  format varchar(255) NOT NULL default '',
  width int(10) unsigned NOT NULL default '0',
  height int(10) unsigned NOT NULL default '0',
  filesize int(10) unsigned NOT NULL default '0',
  iptc text,
  exif text,
  personal tinyint(4) NOT NULL default '0',
  weight tinyint(4) NOT NULL default '0',
  KEY nid (nid)
) TYPE=MyISAM;

--
-- Table structure for table `interwiki`
--

CREATE TABLE interwiki (
  iw_prefix char(32) NOT NULL default '',
  iw_url char(127) NOT NULL default '',
  iw_local tinyint(1) NOT NULL default '0',
  UNIQUE KEY iw_prefix (iw_prefix)
) TYPE=MyISAM;

--
-- Table structure for table `listhandler`
--

CREATE TABLE listhandler (
  lid int(10) unsigned NOT NULL auto_increment,
  msgid varchar(255) NOT NULL default '',
  nid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  pid int(10) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  mid int(10) NOT NULL default '0',
  tid int(10) NOT NULL default '0',
  PRIMARY KEY  (lid),
  KEY lid (lid)
) TYPE=MyISAM;

--
-- Table structure for table `locales_meta`
--

CREATE TABLE locales_meta (
  locale varchar(12) NOT NULL default '',
  name varchar(64) NOT NULL default '',
  enabled int(2) NOT NULL default '0',
  isdefault int(2) NOT NULL default '0',
  plurals int(1) NOT NULL default '0',
  formula varchar(128) NOT NULL default '',
  PRIMARY KEY  (locale)
) TYPE=MyISAM;

--
-- Table structure for table `locales_source`
--

CREATE TABLE locales_source (
  lid int(11) NOT NULL auto_increment,
  location varchar(128) NOT NULL default '',
  source blob NOT NULL,
  PRIMARY KEY  (lid)
) TYPE=MyISAM;

--
-- Table structure for table `locales_target`
--

CREATE TABLE locales_target (
  lid int(11) NOT NULL default '0',
  translation blob NOT NULL,
  locale varchar(12) NOT NULL default '',
  plid int(11) NOT NULL default '0',
  plural int(1) NOT NULL default '0',
  KEY lid (lid),
  KEY lang (locale),
  KEY plid (plid),
  KEY plural (plural)
) TYPE=MyISAM;

--
-- Table structure for table `mailhandler`
--

CREATE TABLE mailhandler (
  mid int(10) unsigned NOT NULL auto_increment,
  mail varchar(255) NOT NULL default '',
  domain varchar(255) NOT NULL default '',
  port int(5) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  pass varchar(255) NOT NULL default '',
  security tinyint(3) unsigned NOT NULL default '0',
  mime varchar(128) default NULL,
  replies tinyint(3) unsigned NOT NULL default '1',
  fromheader varchar(128) default NULL,
  commands text,
  sigseparator varchar(128) default NULL,
  enabled tinyint(4) default NULL,
  folder varchar(255) NOT NULL default '',
  imap tinyint(3) unsigned NOT NULL default '0',
  mailto varchar(255) NOT NULL default '',
  delete_after_read tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (mid),
  KEY mail (mail)
) TYPE=MyISAM;

--
-- Table structure for table `menu`
--

CREATE TABLE menu (
  mid int(10) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  weight tinyint(4) NOT NULL default '0',
  type int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (mid)
) TYPE=MyISAM;

--
-- Table structure for table `moderation_filters`
--

CREATE TABLE moderation_filters (
  fid int(10) unsigned NOT NULL auto_increment,
  filter varchar(255) NOT NULL default '',
  minimum smallint(6) NOT NULL default '0',
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

--
-- Table structure for table `moderation_roles`
--

CREATE TABLE moderation_roles (
  rid int(10) unsigned NOT NULL default '0',
  mid int(10) unsigned NOT NULL default '0',
  value tinyint(4) NOT NULL default '0',
  KEY idx_rid (rid),
  KEY idx_mid (mid)
) TYPE=MyISAM;

--
-- Table structure for table `moderation_votes`
--

CREATE TABLE moderation_votes (
  mid int(10) unsigned NOT NULL auto_increment,
  vote varchar(255) default NULL,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (mid)
) TYPE=MyISAM;

--
-- Table structure for table `node`
--

CREATE TABLE node (
  nid int(10) unsigned NOT NULL auto_increment,
  type varchar(16) NOT NULL default '',
  title varchar(128) NOT NULL default '',
  score int(11) NOT NULL default '0',
  votes int(11) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  status int(4) NOT NULL default '1',
  created int(11) NOT NULL default '0',
  changed int(11) NOT NULL default '0',
  comment int(2) NOT NULL default '0',
  promote int(2) NOT NULL default '0',
  moderate int(2) NOT NULL default '0',
  users longtext NOT NULL,
  teaser longtext NOT NULL,
  body longtext NOT NULL,
  revisions longtext NOT NULL,
  sticky int(2) NOT NULL default '0',
  format int(4) NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY node_type (type(4)),
  KEY node_title_type (title,type(4)),
  KEY status (status),
  KEY uid (uid),
  KEY node_moderate (moderate),
  KEY node_promote_status (promote,status),
  KEY node_created (created),
  KEY node_changed (changed),
  KEY node_status_type (status,type,nid)
) TYPE=MyISAM;

--
-- Table structure for table `node_access`
--

CREATE TABLE node_access (
  nid int(10) unsigned NOT NULL default '0',
  gid int(10) unsigned NOT NULL default '0',
  realm varchar(255) NOT NULL default '',
  grant_view tinyint(1) unsigned NOT NULL default '0',
  grant_update tinyint(1) unsigned NOT NULL default '0',
  grant_delete tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid,gid,realm)
) TYPE=MyISAM;

--
-- Table structure for table `node_comment_statistics`
--

CREATE TABLE node_comment_statistics (
  nid int(10) unsigned NOT NULL auto_increment,
  cid int(10) unsigned NOT NULL default '0',
  last_comment_timestamp int(11) NOT NULL default '0',
  last_comment_name varchar(60) default NULL,
  last_comment_uid int(10) NOT NULL default '0',
  comment_count int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY node_comment_timestamp (last_comment_timestamp)
) TYPE=MyISAM;

--
-- Table structure for table `node_counter`
--

CREATE TABLE node_counter (
  nid int(11) NOT NULL default '0',
  totalcount bigint(20) unsigned NOT NULL default '0',
  daycount mediumint(8) unsigned NOT NULL default '0',
  timestamp int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY totalcount (totalcount),
  KEY daycount (daycount),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table `node_import_mappings`
--

CREATE TABLE node_import_mappings (
  type varchar(16) NOT NULL default '',
  csv_headers text NOT NULL,
  mapping text NOT NULL,
  KEY type (type)
) TYPE=MyISAM;

--
-- Table structure for table `notify`
--

CREATE TABLE notify (
  uid int(10) unsigned NOT NULL default '0',
  status tinyint(2) NOT NULL default '0',
  node tinyint(2) NOT NULL default '0',
  comment tinyint(2) NOT NULL default '0',
  attempts tinyint(4) NOT NULL default '0',
  teasers tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

--
-- Table structure for table `page`
--

CREATE TABLE page (
  nid int(10) unsigned NOT NULL default '0',
  link varchar(128) NOT NULL default '',
  description varchar(128) NOT NULL default '',
  PRIMARY KEY  (nid)
) TYPE=MyISAM;

--
-- Table structure for table `permission`
--

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
  perm longtext,
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_config`
--

CREATE TABLE phplist_config (
  item varchar(35) NOT NULL default '',
  value longtext,
  editable tinyint(4) default '1',
  type varchar(25) default NULL,
  PRIMARY KEY  (item)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_contact_searches`
--

CREATE TABLE phplist_contact_searches (
  csid int(10) unsigned NOT NULL default '0',
  lid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (csid,lid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_list`
--

CREATE TABLE phplist_list (
  public tinyint(1) NOT NULL default '0',
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description text,
  entered datetime default NULL,
  listorder int(11) default NULL,
  prefix varchar(10) default NULL,
  rssfeed varchar(255) default NULL,
  modified timestamp(14) NOT NULL,
  active tinyint(4) default NULL,
  owner int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_listmessage`
--

CREATE TABLE phplist_listmessage (
  id int(11) NOT NULL auto_increment,
  messageid int(11) NOT NULL default '0',
  listid int(11) NOT NULL default '0',
  entered datetime default NULL,
  modified timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY messageid (messageid,listid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_listuser`
--

CREATE TABLE phplist_listuser (
  userid int(11) NOT NULL default '0',
  listid int(11) NOT NULL default '0',
  entered datetime default NULL,
  modified timestamp(14) NOT NULL,
  PRIMARY KEY  (userid,listid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_message`
--

CREATE TABLE phplist_message (
  id int(11) NOT NULL auto_increment,
  subject varchar(255) NOT NULL default '',
  fromfield varchar(255) NOT NULL default '',
  tofield varchar(255) NOT NULL default '',
  replyto varchar(255) NOT NULL default '',
  message text,
  textmessage text,
  footer text,
  entered datetime default NULL,
  modified timestamp(14) NOT NULL,
  embargo datetime default NULL,
  repeatinterval int(11) default NULL,
  repeatuntil datetime default NULL,
  status enum('submitted','inprocess','sent','cancelled','prepared','draft') default NULL,
  userselection text,
  sent datetime default NULL,
  htmlformatted tinyint(4) default '0',
  sendformat varchar(20) default NULL,
  template int(11) default NULL,
  processed mediumint(8) unsigned default '0',
  astext int(11) default '0',
  ashtml int(11) default '0',
  astextandhtml int(11) default '0',
  aspdf int(11) default '0',
  astextandpdf int(11) default '0',
  viewed int(11) default '0',
  bouncecount int(11) default '0',
  sendstart datetime default NULL,
  rsstemplate varchar(100) default NULL,
  owner int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_messagedata`
--

CREATE TABLE phplist_messagedata (
  name varchar(100) NOT NULL default '',
  id int(11) NOT NULL default '0',
  data text,
  PRIMARY KEY  (name,id)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_rssitem`
--

CREATE TABLE phplist_rssitem (
  id int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  link varchar(100) NOT NULL default '',
  source varchar(255) default NULL,
  list int(11) default NULL,
  added datetime default NULL,
  processed mediumint(8) unsigned default '0',
  astext int(11) default '0',
  ashtml int(11) default '0',
  PRIMARY KEY  (id),
  KEY title (title,link)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_sendprocess`
--

CREATE TABLE phplist_sendprocess (
  id int(11) NOT NULL auto_increment,
  started datetime default NULL,
  modified timestamp(14) NOT NULL,
  alive int(11) default '1',
  ipaddress varchar(50) default NULL,
  page varchar(100) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_sessiontable`
--

CREATE TABLE phplist_sessiontable (
  sessionid varchar(32) NOT NULL default '',
  lastactive int(11) NOT NULL default '0',
  data longtext,
  PRIMARY KEY  (sessionid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_user_attribute`
--

CREATE TABLE phplist_user_attribute (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  type varchar(30) default NULL,
  listorder int(11) default NULL,
  default_value varchar(255) default NULL,
  required tinyint(4) default NULL,
  tablename varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_user_blacklist`
--

CREATE TABLE phplist_user_blacklist (
  email varchar(255) NOT NULL default '',
  added datetime default NULL,
  UNIQUE KEY email (email)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_user_blacklist_data`
--

CREATE TABLE phplist_user_blacklist_data (
  email varchar(255) NOT NULL default '',
  name varchar(100) default NULL,
  data text,
  UNIQUE KEY email (email)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_user_rss`
--

CREATE TABLE phplist_user_rss (
  userid int(11) NOT NULL default '0',
  last datetime default NULL,
  PRIMARY KEY  (userid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_user_user`
--

CREATE TABLE phplist_user_user (
  id int(11) NOT NULL auto_increment,
  drupalid int(10) unsigned NOT NULL default '0',
  email varchar(255) NOT NULL default '',
  confirmed tinyint(4) default '0',
  bouncecount int(11) default '0',
  entered datetime default NULL,
  modified timestamp(14) NOT NULL,
  uniqid varchar(255) default NULL,
  htmlemail tinyint(4) default '0',
  subscribepage int(11) default NULL,
  rssfrequency varchar(100) default NULL,
  password varchar(255) default NULL,
  passwordchanged date default NULL,
  disabled tinyint(4) default '0',
  extradata text,
  foreignkey varchar(100) default NULL,
  blacklisted tinyint(4) default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY email (email),
  KEY idx_phplist_user_user_uniqid (uniqid)
) TYPE=MyISAM;

--
-- Table structure for table `phplist_usermessage`
--

CREATE TABLE phplist_usermessage (
  messageid int(11) NOT NULL default '0',
  userid int(11) NOT NULL default '0',
  entered datetime default NULL,
  viewed datetime default NULL,
  status varchar(255) default NULL,
  PRIMARY KEY  (userid,messageid)
) TYPE=MyISAM;

--
-- Table structure for table `poll`
--

CREATE TABLE poll (
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
  voters longtext NOT NULL,
  active int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid)
) TYPE=MyISAM;

--
-- Table structure for table `poll_choices`
--

CREATE TABLE poll_choices (
  chid int(10) unsigned NOT NULL auto_increment,
  nid int(10) unsigned NOT NULL default '0',
  chtext varchar(128) NOT NULL default '',
  chvotes int(6) NOT NULL default '0',
  chorder int(2) NOT NULL default '0',
  PRIMARY KEY  (chid),
  KEY nid (nid)
) TYPE=MyISAM;

--
-- Table structure for table `privatemsg`
--

CREATE TABLE privatemsg (
  id int(10) unsigned NOT NULL auto_increment,
  author int(10) unsigned NOT NULL default '0',
  recipient int(10) unsigned NOT NULL default '0',
  subject varchar(64) NOT NULL default '',
  message text,
  timestamp int(11) unsigned NOT NULL default '0',
  new tinyint(3) unsigned NOT NULL default '0',
  hostname varchar(255) NOT NULL default '',
  folder int(10) unsigned NOT NULL default '0',
  author_del tinyint(3) unsigned NOT NULL default '0',
  recipient_del tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY recipient (recipient),
  KEY folder (folder)
) TYPE=MyISAM;

--
-- Table structure for table `privatemsg_archive`
--

CREATE TABLE privatemsg_archive (
  id int(10) unsigned NOT NULL auto_increment,
  author int(10) unsigned NOT NULL default '0',
  recipient int(10) unsigned NOT NULL default '0',
  subject varchar(64) NOT NULL default '',
  message text NOT NULL,
  timestamp int(11) unsigned NOT NULL default '0',
  hostname varchar(255) NOT NULL default '',
  folder int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY recipient (recipient)
) TYPE=MyISAM;

--
-- Table structure for table `privatemsg_folder`
--

CREATE TABLE privatemsg_folder (
  fid int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

--
-- Table structure for table `profile_fields`
--

CREATE TABLE profile_fields (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) default NULL,
  name varchar(128) default NULL,
  explanation text,
  category varchar(255) default NULL,
  page varchar(255) default NULL,
  type varchar(128) default NULL,
  weight tinyint(1) NOT NULL default '0',
  required tinyint(1) NOT NULL default '0',
  register tinyint(1) NOT NULL default '0',
  visibility tinyint(1) NOT NULL default '0',
  options text,
  PRIMARY KEY  (fid),
  UNIQUE KEY name (name),
  KEY category (category)
) TYPE=MyISAM;

--
-- Table structure for table `profile_values`
--

CREATE TABLE profile_values (
  fid int(11) unsigned default '0',
  uid int(11) unsigned default '0',
  value text,
  KEY uid (uid),
  KEY fid (fid)
) TYPE=MyISAM;

--
-- Table structure for table `role`
--

CREATE TABLE role (
  rid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  PRIMARY KEY  (rid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

--
-- Table structure for table `rsvp`
--

CREATE TABLE rsvp (
  rid int(10) unsigned NOT NULL auto_increment,
  nid int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  name varchar(128) default '',
  invite_text text,
  blind int(3) unsigned NOT NULL default '0',
  list_email int(3) unsigned NOT NULL default '0',
  allow_invite int(3) unsigned NOT NULL default '0',
  timestamp int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (rid,uid,nid)
) TYPE=MyISAM;

--
-- Table structure for table `rsvp_event`
--

CREATE TABLE rsvp_event (
  type enum('reminder','update') default NULL,
  rid int(10) unsigned NOT NULL default '0',
  content text,
  trigger_date int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (rid)
) TYPE=MyISAM;

--
-- Table structure for table `rsvp_to_user`
--

CREATE TABLE rsvp_to_user (
  response enum('yes','no','maybe','none') NOT NULL default 'none',
  rid int(10) unsigned NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  email varchar(128) NOT NULL default '',
  hash varchar(255) NOT NULL default '',
  invited int(10) unsigned NOT NULL default '0',
  received int(10) unsigned NOT NULL default '0',
  timestamp int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (rid,email,uid)
) TYPE=MyISAM;

--
-- Table structure for table `rsvp_user_prefs`
--

CREATE TABLE rsvp_user_prefs (
  require_login int(4) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  notification int(4) unsigned NOT NULL default '0',
  blind int(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

--
-- Table structure for table `search_index`
--

CREATE TABLE search_index (
  word varchar(50) NOT NULL default '',
  lno int(10) unsigned NOT NULL default '0',
  type varchar(16) default NULL,
  count int(10) unsigned default NULL,
  KEY lno (lno),
  KEY word (word)
) TYPE=MyISAM;

--
-- Table structure for table `sequences`
--

CREATE TABLE sequences (
  name varchar(255) NOT NULL default '',
  id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Table structure for table `sessions`
--

CREATE TABLE sessions (
  uid int(10) unsigned NOT NULL default '0',
  sid varchar(32) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  session longtext,
  KEY uid (uid),
  KEY sid (sid),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table `story_item`
--

CREATE TABLE story_item (
  iid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (iid),
  UNIQUE KEY nid (nid)
) TYPE=MyISAM;

--
-- Table structure for table `survey`
--

CREATE TABLE survey (
  nid int(11) unsigned NOT NULL default '0',
  fid int(11) NOT NULL default '0',
  email text,
  result_page text,
  PRIMARY KEY  (nid)
) TYPE=MyISAM;

--
-- Table structure for table `survey_fields`
--

CREATE TABLE survey_fields (
  rid int(11) unsigned NOT NULL default '0',
  ffid int(11) NOT NULL default '0',
  value text,
  PRIMARY KEY  (rid,ffid)
) TYPE=MyISAM;

--
-- Table structure for table `survey_responses`
--

CREATE TABLE survey_responses (
  rid int(11) unsigned NOT NULL default '0',
  nid int(11) unsigned NOT NULL default '0',
  uid int(11) unsigned NOT NULL default '0',
  created int(11) NOT NULL default '0',
  PRIMARY KEY  (rid)
) TYPE=MyISAM;

--
-- Table structure for table `system`
--

CREATE TABLE system (
  filename varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  status int(2) NOT NULL default '0',
  throttle tinyint(1) NOT NULL default '0',
  bootstrap int(2) NOT NULL default '0',
  PRIMARY KEY  (filename)
) TYPE=MyISAM;

--
-- Table structure for table `term_data`
--

CREATE TABLE term_data (
  tid int(10) unsigned NOT NULL auto_increment,
  vid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description longtext,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY vid (vid)
) TYPE=MyISAM;

--
-- Table structure for table `term_hierarchy`
--

CREATE TABLE term_hierarchy (
  tid int(10) unsigned NOT NULL default '0',
  parent int(10) unsigned NOT NULL default '0',
  KEY tid (tid),
  KEY parent (parent)
) TYPE=MyISAM;

--
-- Table structure for table `term_node`
--

CREATE TABLE term_node (
  nid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default '0',
  KEY nid (nid),
  KEY tid (tid)
) TYPE=MyISAM;

--
-- Table structure for table `term_relation`
--

CREATE TABLE term_relation (
  tid1 int(10) unsigned NOT NULL default '0',
  tid2 int(10) unsigned NOT NULL default '0',
  KEY tid1 (tid1),
  KEY tid2 (tid2)
) TYPE=MyISAM;

--
-- Table structure for table `term_synonym`
--

CREATE TABLE term_synonym (
  tid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  KEY tid (tid),
  KEY name (name(3))
) TYPE=MyISAM;

--
-- Table structure for table `trackback_node`
--

CREATE TABLE trackback_node (
  nid int(10) unsigned NOT NULL default '0',
  awaiting_cron tinyint(1) NOT NULL default '0',
  can_receive tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (nid)
) TYPE=MyISAM;

--
-- Table structure for table `trackback_received`
--

CREATE TABLE trackback_received (
  nid int(10) unsigned NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  trid int(10) unsigned NOT NULL default '0',
  created int(11) NOT NULL default '0',
  site varchar(255) NOT NULL default '',
  name varchar(60) default NULL,
  subject varchar(64) NOT NULL default '',
  excerpt varchar(255) NOT NULL default '',
  PRIMARY KEY  (trid)
) TYPE=MyISAM;

--
-- Table structure for table `trackback_sent`
--

CREATE TABLE trackback_sent (
  nid int(10) unsigned NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  successful tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (nid,url)
) TYPE=MyISAM;

--
-- Table structure for table `url_alias`
--

CREATE TABLE url_alias (
  pid int(10) unsigned NOT NULL auto_increment,
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
  PRIMARY KEY  (pid),
  UNIQUE KEY dst (dst)
) TYPE=MyISAM;

--
-- Table structure for table `users`
--

CREATE TABLE users (
  uid int(10) unsigned NOT NULL default '0',
  name varchar(60) NOT NULL default '',
  pass varchar(32) NOT NULL default '',
  mail varchar(64) default '',
  mode tinyint(1) NOT NULL default '0',
  sort tinyint(1) default '0',
  threshold tinyint(1) default '0',
  theme varchar(255) NOT NULL default '',
  signature varchar(255) NOT NULL default '',
  created int(11) NOT NULL default '0',
  changed int(11) NOT NULL default '0',
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
  language varchar(12) NOT NULL default '',
  picture varchar(255) NOT NULL default '',
  init varchar(64) default '',
  data longtext,
  contact_nid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid),
  UNIQUE KEY name (name),
  KEY changed (changed)
) TYPE=MyISAM;

--
-- Table structure for table `users_roles`
--

CREATE TABLE users_roles (
  uid int(10) unsigned NOT NULL default '0',
  rid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,rid)
) TYPE=MyISAM;

--
-- Table structure for table `variable`
--

CREATE TABLE variable (
  name varchar(48) NOT NULL default '',
  value longtext NOT NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Table structure for table `vocabulary`
--

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description longtext,
  help varchar(255) NOT NULL default '',
  relations tinyint(3) unsigned NOT NULL default '0',
  hierarchy tinyint(3) unsigned NOT NULL default '0',
  multiple tinyint(3) unsigned NOT NULL default '0',
  required tinyint(3) unsigned NOT NULL default '0',
  nodes longtext,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

--
-- Table structure for table `volunteer`
--

CREATE TABLE volunteer (
  eid int(10) unsigned NOT NULL default '0',
  wanted int(3) default '2',
  uid int(11) default NULL,
  message_approve text,
  message_deny text,
  message_wait text,
  message_reminder text,
  message_follow_up text,
  PRIMARY KEY  (eid)
) TYPE=MyISAM;

--
-- Table structure for table `volunteer_contact_event`
--

CREATE TABLE volunteer_contact_event (
  cid int(10) unsigned NOT NULL default '0',
  rating int(2) default NULL,
  comments text,
  eid int(10) unsigned NOT NULL default '0',
  stage int(2) unsigned default NULL
) TYPE=MyISAM;

--
-- Table structure for table `watchdog`
--

CREATE TABLE watchdog (
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  type varchar(16) NOT NULL default '',
  message longtext NOT NULL,
  link varchar(255) NOT NULL default '',
  location varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (wid)
) TYPE=MyISAM;

--
-- Insert some default values
--

INSERT INTO blocks VALUES ('user','0',0,0,0,'',0,0);
INSERT INTO blocks VALUES ('user','1',1,0,0,'',0,0);

INSERT INTO contact_sources VALUES (0,'verified user account',21,0);
INSERT INTO contact_sources VALUES (1,'unverified user account',0,0);

INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
INSERT INTO filter_formats VALUES (2,'PHP code','',0);
INSERT INTO filter_formats VALUES (3,'Full HTML','',1);

INSERT INTO filters VALUES (1,'filter',0,0);
INSERT INTO filters VALUES (1,'filter',2,1);
INSERT INTO filters VALUES (2,'filter',1,0);
INSERT INTO filters VALUES (3,'filter',2,0);

INSERT INTO interwiki VALUES ('kos','http://www.dkosopedia.com/index.php/$1',1);
INSERT INTO interwiki VALUES ('w','http://en.wikipedia.org/wiki/$1',1);
INSERT INTO interwiki VALUES ('dis','http://www.disinfopedia.org/wiki.phtml?title=$1',1);

INSERT INTO locales_meta VALUES ('en','English',1,1,0,'');

INSERT INTO node_access VALUES (0,0,'all',1,0,0);

INSERT INTO permission VALUES (1,'access content',0);
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);

INSERT INTO privatemsg_folder VALUES (1,0,'Sent');

INSERT INTO role VALUES (1,'anonymous user');
INSERT INTO role VALUES (2,'authenticated user');

INSERT INTO sequences VALUES ('menu_mid',1);
INSERT INTO sequences VALUES ('contact_sources_csid',1);

INSERT INTO system VALUES ('modules/admin.module','admin','module','',1,0,0);
INSERT INTO system VALUES ('modules/block.module','block','module','',1,0,0);
INSERT INTO system VALUES ('modules/comment.module','comment','module','',1,0,0);
INSERT INTO system VALUES ('modules/help.module','help','module','',1,0,0);
INSERT INTO system VALUES ('modules/node.module','node','module','',1,0,0);
INSERT INTO system VALUES ('modules/page.module','page','module','',1,0,0);
INSERT INTO system VALUES ('modules/story.module','story','module','',1,0,0);
INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1,0,0);
INSERT INTO system VALUES ('themes/democratica/page.tpl.php','democratica','theme','themes/engines/phptemplate/phptemplate.engine',1,0,0);
INSERT INTO system VALUES ('themes/engines/phptemplate/phptemplate.engine','phptemplate','theme_engine','',1,0,0);
INSERT INTO system VALUES ('modules/forms/forms.module','forms','module','',1,0,0);
INSERT INTO system VALUES ('modules/configure/configure.module','configure','module','',1,0,0);

INSERT INTO users VALUES (0,'','','',0,0,0,'','',0,0,0,NULL,'','','',NULL,0);

INSERT INTO users_roles VALUES (0,1);

INSERT INTO variable VALUES ('update_start','s:10:\"2004-10-18;\"');
INSERT INTO variable VALUES ('theme_default','s:11:\"democratica\";');
INSERT INTO variable VALUES ('filter_html_1','i:1;');
INSERT INTO variable VALUES ('node_promote_contact','s:1:\"0\";');
INSERT INTO variable VALUES ('phptemplate_extra_templates','a:1:{s:18:\"themes/democratica\";a:1:{s:31:\"themes/democratica/page.tpl.php\";O:8:\"stdClass\":2:{s:8:\"filename\";s:31:\"themes/democratica/page.tpl.php\";s:4:\"name\";s:8:\"page.tpl\";}}}');
INSERT INTO variable VALUES ('phptemplate_extra_logic','a:1:{s:31:\"themes/democratica/template.php\";s:31:\"themes/democratica/template.php\";}');
INSERT INTO variable VALUES ('site_name','s:10:\"CivicSpace\";');
INSERT INTO variable VALUES ('theme_democratica_settings','a:9:{s:12:\"default_logo\";s:1:\"0\";s:9:\"logo_path\";s:0:\"\";s:11:\"toggle_name\";s:1:\"1\";s:13:\"toggle_slogan\";s:1:\"0\";s:14:\"toggle_mission\";s:1:\"1\";s:20:\"toggle_primary_links\";s:1:\"1\";s:22:\"toggle_secondary_links\";s:1:\"1\";s:24:\"toggle_node_user_picture\";s:1:\"0\";s:27:\"toggle_comment_user_picture\";s:1:\"0\";}');
INSERT INTO variable VALUES ('site_frontpage','s:9:\"configure\";');
INSERT INTO variable VALUES ('image_default_path','s:13:\"files/images/\";');
INSERT INTO variable VALUES ('image_default_thumb_path','s:20:\"files/images/thumbs/\";');
INSERT INTO variable VALUES ('image_temp_path','s:16:\"files/images/tmp\";');
INSERT INTO variable VALUES ('drupal_server','s:36:\"http://civicspacelabs.org/xmlrpc.php\";');