diff options
Diffstat (limited to '')
| -rw-r--r-- | install/dbscheme.txt | 7 | ||||
| -rw-r--r-- | install/phpwebgallery_structure.sql | 13 |
2 files changed, 0 insertions, 20 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index 06c757949..2b9b8addd 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -11,7 +11,6 @@ table:images table:sessions table:sites table:user_access -table:user_category table:user_group table:users table:waiting @@ -75,10 +74,6 @@ column:id table:sites type:tinyint column:galleries_url table:sites type:varchar nullable:Y length:255 binary:N column:user_id table:user_access type:smallint nullable:Y length:5 signed:N column:cat_id table:user_access type:smallint nullable:Y length:5 signed:N -column:user_id table:user_category type:smallint nullable:Y length:5 signed:N -column:category_id table:user_category type:smallint nullable:Y length:5 signed:N -column:date_last table:user_category type:date nullable:N -column:nb_sub_categories table:user_category type:smallint nullable:Y length:5 signed:N column:user_id table:user_group type:smallint nullable:Y length:5 signed:N column:group_id table:user_group type:smallint nullable:Y length:5 signed:N column:id table:users type:smallint nullable:Y length:5 signed:N @@ -122,8 +117,6 @@ PK:sessions_pk table:sessions column:id PK:sites_pk table:sites column:id PK:user_access_pk table:user_access column:user_id PK:user_access_pk table:user_access column:cat_id -PK:user_category_pk table:user_category column:user_id -PK:user_category_pk table:user_category column:category_id PK:user_group_pk table:user_group column:group_id PK:user_group_pk table:user_group column:user_id PK:users_pk table:users column:id diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index a6d28e7be..603949488 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -176,19 +176,6 @@ CREATE TABLE phpwebgallery_user_access ( ) TYPE=MyISAM; -- --- Table structure for table 'phpwebgallery_user_category' --- - -DROP TABLE IF EXISTS phpwebgallery_user_category; -CREATE TABLE phpwebgallery_user_category ( - user_id smallint(5) unsigned NOT NULL default '0', - category_id smallint(5) unsigned NOT NULL default '0', - date_last date default NULL, - nb_sub_categories smallint(5) unsigned NOT NULL default '0', - PRIMARY KEY (user_id,category_id) -) TYPE=MyISAM; - --- -- Table structure for table 'phpwebgallery_user_group' -- |