Location: PHPKode > projects > Rilke CMS > rilkecms_095b_release/db_schema/sql_changes_095.txt
SQL Schema Changes

rilkecms_090  
  archives
  auth
  bbbook
  images
  langprefs
  linktable
  specialauth
  themes
  tmparchives
  
  --------------
  
   rilkecms_095  
  archives
  auth [**]
  bbbook 
  contactinfo [*]
  images 
  langprefs
  linktable [*]
  pubcontactinfo [*]
  rssfeeds [*]
  specialauth
  themes
  tmparchives
  
  ** structure changed
  * new tables added
  
  -------------
  
#
# Table structure for table `auth`
#

CREATE TABLE auth (
  userid int(11) NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  contactid int(11) NOT NULL default '0',
  userlevel tinyint(4) NOT NULL default '2',
  KEY userid (userid)
) TYPE=MyISAM

#
# Dumping data for table `auth`
#
# INSERT INTO auth VALUES (userid, 'username', password, contactid, userlevel);
# Replace userid and contactid with appropriate values
# Use the new user admin screen in the "more" section of the admin panel to add new users

 INSERT INTO auth VALUES ('1', 'myusername', md5('mypassword'), '1', 4);
 
 # #####################################################################
 
#
# Table structure for table `contactinfo`
#

CREATE TABLE contactinfo (
  ciid int(11) NOT NULL auto_increment,
  ciname varchar(255) NOT NULL default '',
  ciemail varchar(255) NOT NULL default '',
  citel varchar(255) default NULL,
  cicompany varchar(255) default NULL,
  ciaddress varchar(255) default NULL,
  cicity varchar(255) default NULL,
  cistate varchar(255) default NULL,
  cicountry varchar(255) default NULL,
  cicomment varchar(255) default NULL,
  cipersonalsite varchar(255) default NULL,
  cicompanysite varchar(255) default NULL,
  ciblogsite varchar(255) default NULL,
  KEY ciid (ciid)
) TYPE=MyISAM

#
# Dumping data for table `contactinfo`
#

INSERT INTO contactinfo VALUES (1, 'John Doe', 'hide@address.com', '555 555 5555', 'Company', '123 Elm St.', 'Brooklyn', 'NY', 'USA', 'no comments at this time', 'http://www.mycoolblog.com', 'http://www.myradcompany.com', '');

# #####################################################################

#
# Table structure for table `pubcontactinfo`
#

CREATE TABLE pubcontactinfo (
  pubciid int(11) NOT NULL auto_increment,
  matchciid int(11) NOT NULL default '0',
  KEY pubciid (pubciid)
) TYPE=MyISAM

#
# Dumping data for table `pubcontactinfo`
#

# Display the contact info of the first user publicly

INSERT INTO pubcontactinfo VALUES (1, 1)

# #####################################################################

#
# Table structure for table `linktable`
#

CREATE TABLE linktable (
  linkid int(11) NOT NULL auto_increment,
  linkdesc varchar(255) NOT NULL default '',
  linkurl varchar(255) NOT NULL default '',
  linktype varchar(255) NOT NULL default '',
  KEY linkid (linkid)
) TYPE=MyISAM

#
# Dumping data for table `linktable`
#

INSERT INTO linktable VALUES (1, 'Browse ...', 'none', 'navmenutitle');
INSERT INTO linktable VALUES (2, 'Rilke CMS News', 'http://www.rilkecms.com/rilkecms/', 'stdurl');
# #####################################################################

#
# Table structure for table `rssfeeds`
#

CREATE TABLE rssfeeds (
  feedid int(11) NOT NULL auto_increment,
  feedtitle varchar(255) NOT NULL default '',
  feedurl varchar(255) NOT NULL default '',
  feeddesc varchar(255) default '[a description of this feed]',
  websiteurl varchar(255) default '[this feed''s website url]',
  fenabled tinyint(4) NOT NULL default '1',
  KEY feedid (feedid)
) TYPE=MyISAM

#
# Dumping data for table `rssfeeds`
#

INSERT INTO rssfeeds VALUES (1, 'Rilke CMS News', 'http://www.rilkecms.com/rilkecms/rss.php', 'Rilke CMS News Feed', 'http://www.rilkecms.com/', 1)
Return current item: Rilke CMS