Changeset 265


Ignore:
Timestamp:
Jan 6, 2004, 1:00:01 AM (20 years ago)
Author:
z0rglub
Message:

2004.01.06_01h00 : auto commit

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/admin/phpwebgallery_structure.sql

    r149 r265  
    1 -- MySQL dump 8.21
    2 --
    3 -- Host: localhost    Database: devel
    4 ---------------------------------------------------------
    5 -- Server version       3.23.49-log
    6 
    7 --
    8 -- Table structure for table 'phpwebgallery_categories'
    9 --
    10 
    11 DROP TABLE IF EXISTS phpwebgallery_categories;
    12 CREATE TABLE phpwebgallery_categories (
    13   id smallint(5) unsigned NOT NULL auto_increment,
    14   date_last date default NULL,
    15   nb_images mediumint(8) unsigned NOT NULL default '0',
    16   name varchar(255) NOT NULL default '',
    17   id_uppercat smallint(5) unsigned default NULL,
    18   comment text,
    19   dir varchar(255) default NULL,
    20   rank tinyint(3) unsigned default NULL,
    21   status enum('public','private') NOT NULL default 'public',
    22   site_id tinyint(4) unsigned NOT NULL default '1',
    23   visible enum('true','false') NOT NULL default 'true',
    24   uploadable enum('true','false') NOT NULL default 'false',
    25   representative_picture_id mediumint(8) unsigned default NULL,
    26   PRIMARY KEY  (id)
    27 ) TYPE=MyISAM;
    28 
    29 --
    30 -- Table structure for table 'phpwebgallery_comments'
    31 --
    32 
    33 DROP TABLE IF EXISTS phpwebgallery_comments;
    34 CREATE TABLE phpwebgallery_comments (
    35   id int(11) unsigned NOT NULL auto_increment,
    36   image_id mediumint(8) unsigned NOT NULL default '0',
    37   date int(11) unsigned NOT NULL default '0',
    38   author varchar(255) default NULL,
    39   content longtext,
    40   validated enum('true','false') NOT NULL default 'false',
    41   PRIMARY KEY  (id)
    42 ) TYPE=MyISAM;
    43 
    44 --
    45 -- Table structure for table 'phpwebgallery_config'
    46 --
    47 
    48 DROP TABLE IF EXISTS phpwebgallery_config;
    49 CREATE TABLE phpwebgallery_config (
    50   prefix_thumbnail varchar(10) default 'TN-',
    51   webmaster varchar(255) NOT NULL default '',
    52   mail_webmaster varchar(255) NOT NULL default '',
    53   access enum('free','restricted') default 'free',
    54   session_id_size tinyint(3) unsigned NOT NULL default '4',
    55   session_keyword varchar(255) default NULL,
    56   session_time tinyint(3) unsigned NOT NULL default '30',
    57   max_user_listbox tinyint(3) unsigned NOT NULL default '10',
    58   show_comments enum('true','false') NOT NULL default 'true',
    59   nb_comment_page tinyint(4) NOT NULL default '10',
    60   upload_available enum('true','false') NOT NULL default 'false',
    61   upload_maxfilesize smallint(5) unsigned NOT NULL default '150',
    62   upload_maxwidth smallint(5) unsigned NOT NULL default '800',
    63   upload_maxheight smallint(5) unsigned NOT NULL default '600',
    64   upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150',
    65   upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100',
    66   log enum('true','false') NOT NULL default 'false',
    67   comments_validation enum('true','false') NOT NULL default 'false',
    68   comments_forall enum('true','false') NOT NULL default 'false',
    69   authorize_cookies enum('true','false') NOT NULL default 'false',
    70   mail_notification enum('true','false') NOT NULL default 'false'
    71 ) TYPE=MyISAM;
    72 
    73 --
    74 -- Table structure for table 'phpwebgallery_favorites'
    75 --
    76 
    77 DROP TABLE IF EXISTS phpwebgallery_favorites;
    78 CREATE TABLE phpwebgallery_favorites (
    79   user_id smallint(5) unsigned NOT NULL default '0',
    80   image_id mediumint(8) unsigned NOT NULL default '0',
    81   KEY user_id (user_id,image_id)
    82 ) TYPE=MyISAM;
    83 
    84 --
    85 -- Table structure for table 'phpwebgallery_group_access'
    86 --
    87 
    88 DROP TABLE IF EXISTS phpwebgallery_group_access;
    89 CREATE TABLE phpwebgallery_group_access (
    90   group_id smallint(5) unsigned NOT NULL default '0',
    91   cat_id smallint(5) unsigned NOT NULL default '0',
    92   PRIMARY KEY  (group_id,cat_id)
    93 ) TYPE=MyISAM;
    94 
    95 --
    96 -- Table structure for table 'phpwebgallery_groups'
    97 --
    98 
    99 DROP TABLE IF EXISTS phpwebgallery_groups;
    100 CREATE TABLE phpwebgallery_groups (
    101   id smallint(5) unsigned NOT NULL auto_increment,
    102   name varchar(255) NOT NULL default '',
    103   PRIMARY KEY  (id)
    104 ) TYPE=MyISAM;
    105 
    106 --
    107 -- Table structure for table 'phpwebgallery_history'
    108 --
    109 
    110 DROP TABLE IF EXISTS phpwebgallery_history;
    111 CREATE TABLE phpwebgallery_history (
    112   date int(11) NOT NULL default '0',
    113   login varchar(15) default NULL,
    114   IP varchar(50) NOT NULL default '',
    115   category varchar(150) default NULL,
    116   file varchar(50) default NULL,
    117   picture varchar(150) default NULL
    118 ) TYPE=MyISAM;
    119 
    120 --
    121 -- Table structure for table 'phpwebgallery_image_category'
    122 --
    123 
    124 DROP TABLE IF EXISTS phpwebgallery_image_category;
    125 CREATE TABLE phpwebgallery_image_category (
    126   image_id mediumint(8) unsigned NOT NULL default '0',
    127   category_id smallint(5) unsigned NOT NULL default '0',
    128   PRIMARY KEY  (image_id,category_id)
    129 ) TYPE=MyISAM;
    130 
    131 --
    132 -- Table structure for table 'phpwebgallery_images'
    133 --
    134 
    135 DROP TABLE IF EXISTS phpwebgallery_images;
    136 CREATE TABLE phpwebgallery_images (
    137   id mediumint(8) unsigned NOT NULL auto_increment,
    138   file varchar(255) NOT NULL default '',
    139   date_available date NOT NULL default '0000-00-00',
    140   date_creation date default NULL,
    141   tn_ext char(3) NOT NULL default 'jpg',
    142   name varchar(255) default NULL,
    143   comment text,
    144   author varchar(255) default NULL,
    145   hit int(10) unsigned NOT NULL default '0',
    146   filesize mediumint(9) unsigned default NULL,
    147   width smallint(9) unsigned default NULL,
    148   height smallint(9) unsigned default NULL,
    149   keywords varchar(255) default NULL,
    150   storage_category_id smallint(5) unsigned default NULL,
    151   PRIMARY KEY  (id),
    152   KEY storage_category_id (storage_category_id)
    153 ) TYPE=MyISAM;
    154 
    155 --
    156 -- Table structure for table 'phpwebgallery_sessions'
    157 --
    158 
    159 DROP TABLE IF EXISTS phpwebgallery_sessions;
    160 CREATE TABLE phpwebgallery_sessions (
    161   id varchar(255) binary NOT NULL default '',
    162   user_id smallint(5) unsigned NOT NULL default '0',
    163   expiration int(10) unsigned NOT NULL default '0',
    164   ip varchar(255) NOT NULL default '',
    165   PRIMARY KEY  (id)
    166 ) TYPE=MyISAM;
    167 
    168 --
    169 -- Table structure for table 'phpwebgallery_sites'
    170 --
    171 
    172 DROP TABLE IF EXISTS phpwebgallery_sites;
    173 CREATE TABLE phpwebgallery_sites (
    174   id tinyint(4) NOT NULL auto_increment,
    175   galleries_url varchar(255) NOT NULL default '',
    176   PRIMARY KEY  (id),
    177   UNIQUE KEY galleries_url (galleries_url)
    178 ) TYPE=MyISAM;
    179 
    180 --
    181 -- Table structure for table 'phpwebgallery_user_access'
    182 --
    183 
    184 DROP TABLE IF EXISTS phpwebgallery_user_access;
    185 CREATE TABLE phpwebgallery_user_access (
    186   user_id smallint(5) unsigned NOT NULL default '0',
    187   cat_id smallint(5) unsigned NOT NULL default '0',
    188   PRIMARY KEY  (user_id,cat_id)
    189 ) TYPE=MyISAM;
    190 
    191 --
    192 -- Table structure for table 'phpwebgallery_user_group'
    193 --
    194 
    195 DROP TABLE IF EXISTS phpwebgallery_user_group;
    196 CREATE TABLE phpwebgallery_user_group (
    197   user_id smallint(5) unsigned NOT NULL default '0',
    198   group_id smallint(5) unsigned NOT NULL default '0',
    199   PRIMARY KEY  (group_id,user_id)
    200 ) TYPE=MyISAM;
    201 
    202 --
    203 -- Table structure for table 'phpwebgallery_users'
    204 --
    205 
    206 DROP TABLE IF EXISTS phpwebgallery_users;
    207 CREATE TABLE phpwebgallery_users (
    208   id smallint(5) unsigned NOT NULL auto_increment,
    209   username varchar(20) binary NOT NULL default '',
    210   password varchar(255) NOT NULL default '',
    211   mail_address varchar(255) default NULL,
    212   nb_image_line tinyint(1) unsigned NOT NULL default '5',
    213   nb_line_page tinyint(3) unsigned NOT NULL default '3',
    214   status enum('admin','guest') NOT NULL default 'guest',
    215   language varchar(50) NOT NULL default 'english',
    216   maxwidth smallint(6) default NULL,
    217   maxheight smallint(6) default NULL,
    218   expand enum('true','false') NOT NULL default 'false',
    219   show_nb_comments enum('true','false') NOT NULL default 'false',
    220   short_period tinyint(3) unsigned NOT NULL default '7',
    221   long_period tinyint(3) unsigned NOT NULL default '14',
    222   template varchar(255) NOT NULL default 'default',
    223   PRIMARY KEY  (id),
    224   UNIQUE KEY username (username)
    225 ) TYPE=MyISAM;
    226 
    227 --
    228 -- Table structure for table 'phpwebgallery_waiting'
    229 --
    230 
    231 DROP TABLE IF EXISTS phpwebgallery_waiting;
    232 CREATE TABLE phpwebgallery_waiting (
    233   id int(10) unsigned NOT NULL auto_increment,
    234   storage_category_id smallint(5) unsigned NOT NULL default '0',
    235   file varchar(255) NOT NULL default '',
    236   username varchar(255) NOT NULL default '',
    237   mail_address varchar(255) NOT NULL default '',
    238   date int(10) unsigned NOT NULL default '0',
    239   tn_ext char(3) default NULL,
    240   validated enum('true','false') NOT NULL default 'false',
    241   infos text,
    242   PRIMARY KEY  (id)
    243 ) TYPE=MyISAM;
    244 
Note: See TracChangeset for help on using the changeset viewer.