Changeset 858 for trunk/install/phpwebgallery_structure.sql

Timestamp:

Sep 3, 2005, 6:36:05 PM (19 years ago)

Author:

plg

Message:

• modification : less configuration parameters in administration screen. These parameters are move to include/config_default.inc.php.

• new : ability to add a single picture to caddie from picture.php

• new : contextual help, only a few pages are available.

• new : ability to delete users from admin/user_list

• modification : reorganization of configuration file

• new : configuration parameter use_exif_mapping

• improvement : MOD hidemail added to standard

File:

• trunk/install/phpwebgallery_structure.sql (modified) (9 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -78 +78 @@
 DROP TABLE IF EXISTS `phpwebgallery_favorites`;
 CREATE TABLE `phpwebgallery_favorites` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `image_id` mediumint(8) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`image_id`)
@@ -171 +171 @@
 DROP TABLE IF EXISTS `phpwebgallery_rate`;
 CREATE TABLE `phpwebgallery_rate` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `element_id` mediumint(8) unsigned NOT NULL default '0',
   `rate` tinyint(2) unsigned NOT NULL default '0',
@@ -184 +184 @@
 CREATE TABLE `phpwebgallery_sessions` (
   `id` varchar(255) binary NOT NULL default '',
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`)
@@ -207 +207 @@
 DROP TABLE IF EXISTS `phpwebgallery_user_access`;
 CREATE TABLE `phpwebgallery_user_access` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`cat_id`)
@@ -218 +218 @@
 DROP TABLE IF EXISTS `phpwebgallery_user_cache`;
 CREATE TABLE `phpwebgallery_user_cache` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `need_update` enum('true','false') NOT NULL default 'true',
   `forbidden_categories` text,
@@ -231 +231 @@
 CREATE TABLE `phpwebgallery_user_feed` (
   `id` varchar(50) binary NOT NULL default '',
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `last_check` datetime default NULL,
   PRIMARY KEY  (`id`)
@@ -242 +242 @@
 DROP TABLE IF EXISTS `phpwebgallery_user_group`;
 CREATE TABLE `phpwebgallery_user_group` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `group_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`group_id`,`user_id`)
@@ -253 +253 @@
 DROP TABLE IF EXISTS `phpwebgallery_user_infos`;
 CREATE TABLE `phpwebgallery_user_infos` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `nb_image_line` tinyint(1) unsigned NOT NULL default '5',
   `nb_line_page` tinyint(3) unsigned NOT NULL default '3',
@@ -274 +274 @@
 DROP TABLE IF EXISTS `phpwebgallery_users`;
 CREATE TABLE `phpwebgallery_users` (
-  `id` smallint(5) unsigned NOT NULL auto_increment,
+  `id` smallint(5) NOT NULL auto_increment,
   `username` varchar(20) binary NOT NULL default '',
   `password` varchar(32) default NULL,