[Phpslash-commit] CVS: phpslash-ft/tables/0.7 slash-all.sql,1.2,1.3 65_to_7.sql,1.3,1.4

[Joe S. <joe...@us...>]

Update of /cvsroot/phpslash/phpslash-ft/tables/0.7
In directory usw-pr-cvs1:/tmp/cvs-serv27461/phpslash-ft/tables/0.7

Modified Files:
	slash-all.sql 65_to_7.sql 
Log Message:
author_options

Index: slash-all.sql
===================================================================
RCS file: /cvsroot/phpslash/phpslash-ft/tables/0.7/slash-all.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** slash-all.sql	24 May 2002 15:26:36 -0000	1.2
--- slash-all.sql	31 May 2002 16:45:56 -0000	1.3
***************
*** 146,168 ****
  INSERT INTO db_sequence VALUES ('psl_author_group_lut_seq',26);
  
- 
- # --------------------------------------------------------
- #
- # Table structure for table 'psl_author'
- #
- 
  CREATE TABLE psl_author (
!    author_id int(11) unsigned DEFAULT '0' NOT NULL,
!    author_name varchar(50) NOT NULL,
!    author_realname varchar(60),
!    url varchar(50),
!    email varchar(50),
!    quote varchar(50),
!    password varchar(64) NOT NULL,
!    seclev int(11) DEFAULT '0' NOT NULL,
!    perms varchar(255),
!    PRIMARY KEY (author_id),
!    UNIQUE author_name (author_name)
! );
  
  #
--- 146,163 ----
  INSERT INTO db_sequence VALUES ('psl_author_group_lut_seq',26);
  
  CREATE TABLE psl_author (
!   author_id int(11) unsigned NOT NULL default '0',
!   author_name varchar(50) NOT NULL default '',
!   author_realname varchar(60) default NULL,
!   url varchar(50) default NULL,
!   email varchar(50) default NULL,
!   quote varchar(50) default NULL,
!   password varchar(64) NOT NULL default '',
!   seclev int(11) NOT NULL default '0',
!   perms varchar(255) default NULL,
!   author_options text,
!   PRIMARY KEY  (author_id),
!   UNIQUE KEY author_name (author_name)
! ) TYPE=MyISAM;
  
  #
***************
*** 170,174 ****
  #
  
! INSERT INTO psl_author (author_id, author_name, author_realname, url, email, quote, password, seclev, perms) VALUES ( '1', 'god', '', 'http://www.god.com', 'go...@he...', 'God doesn't need a 'quote'!', MD5('god:password'), '1000000', 'root,nobody,user,topic,comment,story,storyeditor,section,submission,block,poll,author,variable,glossary,mailinglist,logging');
  
  #
--- 165,169 ----
  #
  
! INSERT INTO psl_author (author_id, author_name, author_realname, url, email, quote, password, seclev, perms, author_options) VALUES ( '1', 'god', '', 'http://www.god.com', 'go...@he...', 'God doesn't need a 'quote'!', MD5('god:password'), '1000000', 'root,nobody,user,topic,comment,story,storyeditor,section,submission,block,poll,author,variable,glossary,mailinglist,logging','');
  
  #

Index: 65_to_7.sql
===================================================================
RCS file: /cvsroot/phpslash/phpslash-ft/tables/0.7/65_to_7.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** 65_to_7.sql	24 May 2002 15:26:36 -0000	1.3
--- 65_to_7.sql	31 May 2002 16:45:56 -0000	1.4
***************
*** 1,5 ****
  # ALTER TABLE psl_story ADD story_options TEXT;
  # ALTER TABLE psl_section ADD section_options TEXT;
! # ALTER TABLE psl_author ADD author_options TEXT;
  INSERT INTO db_sequence VALUES ('psl_permission_seq',80);
  INSERT INTO db_sequence VALUES ('psl_group_seq',27);
--- 1,5 ----
  # ALTER TABLE psl_story ADD story_options TEXT;
  # ALTER TABLE psl_section ADD section_options TEXT;
! ALTER TABLE psl_author ADD author_options TEXT;
  INSERT INTO db_sequence VALUES ('psl_permission_seq',80);
  INSERT INTO db_sequence VALUES ('psl_group_seq',27);