[fuwiki-cvs] fuwiki_1_0/install tables.sql,1.2,1.3

[Mutwin K. <mu...@us...>]

Update of /cvsroot/fuwiki/fuwiki_1_0/install
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv561/install

Modified Files:
	tables.sql 
Log Message:
up-to-date with fuckupwiki codebase

Index: tables.sql
===================================================================
RCS file: /cvsroot/fuwiki/fuwiki_1_0/install/tables.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** tables.sql	7 Nov 2004 12:00:35 -0000	1.2
--- tables.sql	13 Feb 2005 21:28:31 -0000	1.3
***************
*** 1,92 ****
! CREATE TABLE `messages` (
!   `id` int(11) NOT NULL auto_increment,
!   `senderid` int(11) default '0',
!   `receiverid` int(11) NOT NULL default '0',
!   `message` text NOT NULL,
!   `date` varchar(14) NOT NULL default '',
!   `has_read` set('true','false') NOT NULL default 'false',
!   PRIMARY KEY  (`id`),
!   KEY `senderid` (`senderid`,`receiverid`,`date`),
!   KEY `read` (`has_read`)
  );
  
! CREATE TABLE `restrictions` (
!   `id` int(11) NOT NULL default '0',
!   `name` varchar(255) NOT NULL default '',
!   `priv` char(2) NOT NULL default 'rw',
!   PRIMARY KEY  (`id`),
!   UNIQUE KEY `name` (`name`)
  );
  
! CREATE TABLE `stats` (
!   `id` bigint(20) NOT NULL auto_increment,
!   `name` varchar(255) NOT NULL default '',
!   `value` varchar(255) NOT NULL default '',
!   `date` varchar(14) default NULL,
!   PRIMARY KEY  (`id`),
!   KEY `name` (`name`)
  );
  
! CREATE TABLE `user_priv` (
!   `id` int(11) NOT NULL auto_increment,
!   `user_id` int(11) NOT NULL default '0',
!   `is_admin` set('true','false') NOT NULL default 'false',
!   `can_move` set('true','false') NOT NULL default 'false',
!   `can_delete` set('true','false') NOT NULL default 'false',
!   `can_makeadmin` set('true','false') NOT NULL default 'false',
!   `can_changeprivs` set('true','false') NOT NULL default 'false',
!   `can_postnews` set('true','false') NOT NULL default 'false',
!   `can_lock` set('true','false') NOT NULL default 'false',
!   PRIMARY KEY  (`id`)
  );
  
! CREATE TABLE `user_settings` (
!   `uid` int(11) NOT NULL default '0',
!   `show_footer` set('true','false') NOT NULL default 'true',
!   `show_commentbox` set('true','false') NOT NULL default 'true',
!   `show_commentbox_signature` set('true','false') NOT NULL default 'true',
!   `show_loginbox` set('true','false') NOT NULL default 'true',
!   `show_userpages` set('true','false') NOT NULL default 'false',
!   `show_searchbox` set('true','false') NOT NULL default 'true',
!   `show_comments` set('true','false') NOT NULL default 'true',
!   `show_commentbox_upload` set('true','false') NOT NULL default 'false',
!   UNIQUE KEY `uid` (`uid`)
  );
  
! CREATE TABLE `users` (
!   `id` int(11) NOT NULL auto_increment,
!   `name` varchar(255) NOT NULL default '',
!   `date_joined` timestamp(14) NOT NULL,
!   `password` varchar(255) default NULL,
!   `email` tinytext,
!   `layout` varchar(255) default NULL,
!   `style` varchar(255) default 'default',
!   `language` varchar(255) default 'en',
!   `signature` tinytext,
!   PRIMARY KEY  (`id`),
!   UNIQUE KEY `name` (`name`)
  );
  
! CREATE TABLE `votes` (
!   `id` int(11) NOT NULL auto_increment,
!   `creatorid` int(11) NOT NULL default '0',
!   `headline` text NOT NULL,
!   `options` text NOT NULL,
!   `results` text,
!   `signerids` text,
!   `date` varchar(14) NOT NULL default '',
!   PRIMARY KEY  (`id`),
!   KEY `creatorid` (`creatorid`),
!   KEY `date` (`date`)
  );
  
! CREATE TABLE `wikis` (
!   `id` bigint(20) NOT NULL auto_increment,
!   `date` varchar(14) default NULL,
!   `creator_id` int(11) NOT NULL default '0',
!   `revision` int(11) default '0',
!   `name` tinytext,
!   `text` longtext,
!   PRIMARY KEY  (`id`)
  );
  
--- 1,109 ----
! CREATE TABLE html_cache (
!   id bigint(20) NOT NULL auto_increment,
!   revision int(11) default '0',
!   name tinytext,
!   text longtext,
!   lang char(2) NOT NULL default '',
!   PRIMARY KEY  (id)
  );
  
! CREATE TABLE images (
!   id bigint(20) NOT NULL auto_increment,
!   uploader_id int(11) NOT NULL default '0',
!   pagename tinytext NOT NULL,
!   name tinytext NOT NULL,
!   upload_time varchar(14) NOT NULL default '',
!   filetype varchar(10) default NULL,
!   KEY id (id)
  );
  
! CREATE TABLE messages (
!   id int(11) NOT NULL auto_increment,
!   senderid int(11) default '0',
!   receiverid int(11) NOT NULL default '0',
!   message text NOT NULL,
!   date varchar(14) NOT NULL default '',
!   has_read set('true','false') NOT NULL default 'false',
!   PRIMARY KEY  (id)
  );
  
! CREATE TABLE restrictions (
!   id int(11) NOT NULL auto_increment,
!   name varchar(255) NOT NULL default '',
!   priv char(2) NOT NULL default 'rw',
!   PRIMARY KEY  (id),
!   UNIQUE KEY name (name)
  );
  
! CREATE TABLE stats (
!   id bigint(20) NOT NULL auto_increment,
!   name varchar(255) NOT NULL default '',
!   value varchar(255) NOT NULL default '',
!   date varchar(14) default NULL,
!   PRIMARY KEY  (id),
!   KEY name (name)
  );
  
! CREATE TABLE user_priv (
!   id int(11) NOT NULL auto_increment,
!   user_id int(11) NOT NULL default '0',
!   is_admin set('true','false') NOT NULL default 'false',
!   can_move set('true','false') NOT NULL default 'false',
!   can_delete set('true','false') NOT NULL default 'false',
!   can_makeadmin set('true','false') NOT NULL default 'false',
!   can_changeprivs set('true','false') NOT NULL default 'false',
!   can_postnews set('true','false') NOT NULL default 'false',
!   can_lock set('true','false') NOT NULL default 'false',
!   PRIMARY KEY  (id)
  );
  
! CREATE TABLE user_settings (
!   uid int(11) NOT NULL default '0',
!   show_footer set('true','false') NOT NULL default 'true',
!   show_commentbox set('true','false') NOT NULL default 'true',
!   show_commentbox_signature set('true','false') NOT NULL default 'true',
!   show_loginbox set('true','false') NOT NULL default 'true',
!   show_userpages set('true','false') NOT NULL default 'false',
!   show_searchbox set('true','false') NOT NULL default 'false',
!   show_comments set('true','false') NOT NULL default 'true',
!   show_commentbox_upload set('true','false') NOT NULL default 'false',
!   UNIQUE KEY uid (uid)
  );
  
! CREATE TABLE users (
!   id int(11) NOT NULL auto_increment,
!   name varchar(255) NOT NULL default '',
!   date_joined timestamp(14) NOT NULL,
!   password varchar(255) default NULL,
!   email tinytext,
!   layout varchar(255) default NULL,
!   style varchar(255) NOT NULL default 'default',
!   language varchar(255) default 'en',
!   signature tinytext,
!   PRIMARY KEY  (id),
!   UNIQUE KEY name (name)
! );
! 
! CREATE TABLE votes (
!   id int(11) NOT NULL auto_increment,
!   creatorid int(11) NOT NULL default '0',
!   headline text NOT NULL,
!   options text NOT NULL,
!   results text,
!   signerids text,
!   date varchar(14) NOT NULL default '',
!   PRIMARY KEY  (id),
!   KEY creatorid (creatorid),
!   KEY date (date)
! );
! 
! CREATE TABLE wikis (
!   id bigint(20) NOT NULL auto_increment,
!   date varchar(14) default NULL,
!   creator_id int(11) NOT NULL default '0',
!   revision int(11) default '0',
!   name tinytext,
!   text longtext,
!   PRIMARY KEY  (id)
  );