aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/dbscheme.txt7
-rw-r--r--install/phpwebgallery_structure.sql13
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'
--