Mercurial > hg > LightPIT / file diff

--- a/setup/postgres/psql_create_tables.sql	Sun May 10 10:11:10 2020 +0200
+++ b/setup/postgres/psql_create_tables.sql	Sun May 10 10:11:37 2020 +0200
@@ -1,28 +1,9 @@
 -- This script creates the module management tables
 --
 
-create table lpitcore_module (
-    modid       serial          primary key,
-    classname   varchar(100)    not null unique,
-    visible     boolean         not null default(true),
-    priority    integer         not null default(1000)
-);
-
 create table lpitcore_user (
     userid          serial          primary key,
     username        varchar(50)     not null unique,
     lastname        varchar(50),
     givenname       varchar(50)
 );
-
-create table lpitcore_authorization (
-    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
-    userid          integer         not null references lpitcore_user(userid) on delete cascade,
-    power           integer         not null check(power >= 0)
-);
-
-create table lpitcore_menu (
-    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
-    userid          integer         not null references lpitcore_user(userid) on delete cascade,
-    seq             integer         not null
-);