Changeset 347 for trunk/admin


Ignore:
Timestamp:
Feb 3, 2004, 1:00:01 AM (21 years ago)
Author:
z0rglub
Message:

2004.02.03_01h00 : auto commit

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/phpwebgallery_structure.sql

    r345 r347  
    11-- MySQL dump 8.21
    22--
    3 -- Host: localhost    Database: perfs_test
     3-- Host: localhost    Database: devel
    44---------------------------------------------------------
    55-- Server version       3.23.49-log
     
    2424  uploadable enum('true','false') NOT NULL default 'false',
    2525  representative_picture_id mediumint(8) unsigned default NULL,
    26   uppercats varchar(255) NOT NULL default '',
    27   PRIMARY KEY  (id),
    28   KEY id (id),
    29   KEY id_uppercat (id_uppercat)
     26  PRIMARY KEY  (id)
    3027) TYPE=MyISAM;
    3128
     
    129126  image_id mediumint(8) unsigned NOT NULL default '0',
    130127  category_id smallint(5) unsigned NOT NULL default '0',
    131   PRIMARY KEY  (image_id,category_id),
    132   KEY category_id (category_id),
    133   KEY image_id (image_id)
     128  PRIMARY KEY  (image_id,category_id)
    134129) TYPE=MyISAM;
    135130
     
    195190
    196191--
    197 -- Table structure for table 'phpwebgallery_user_category'
    198 --
    199 
    200 DROP TABLE IF EXISTS phpwebgallery_user_category;
    201 CREATE TABLE phpwebgallery_user_category (
    202   user_id smallint(5) unsigned NOT NULL default '0',
    203   category_id smallint(5) unsigned NOT NULL default '0',
    204   date_last date default NULL,
    205   nb_sub_categories smallint(5) unsigned NOT NULL default '0',
    206   PRIMARY KEY  (user_id,category_id)
    207 ) TYPE=MyISAM;
    208 
    209 --
    210192-- Table structure for table 'phpwebgallery_user_group'
    211193--
     
    239221  long_period tinyint(3) unsigned NOT NULL default '14',
    240222  template varchar(255) NOT NULL default 'default',
    241   forbidden_categories text,
    242223  PRIMARY KEY  (id),
    243224  UNIQUE KEY username (username)
Note: See TracChangeset for help on using the changeset viewer.