comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 31
- 58f78f0142e8
- parent 20
- bd1a76c91d5b
- child 36
- 0f4f8f255c32
equal
deleted
inserted
replaced
| 30:fb30f7b78f9b | 31:58f78f0142e8 |
|---|---|
| 2 -- | 2 -- |
| 3 | 3 |
| 4 create table lpitcore_module ( | 4 create table lpitcore_module ( |
| 5 modid serial primary key, | 5 modid serial primary key, |
| 6 classname varchar(100) not null unique, | 6 classname varchar(100) not null unique, |
| 7 visible boolean not null default(true) | 7 visible boolean not null default(true), |
| 8 priority integer not null default(1000) | |
| 8 ); | 9 ); |
| 9 | 10 |
| 10 create table lpitcore_user ( | 11 create table lpitcore_user ( |
| 11 userid serial primary key, | 12 userid serial primary key, |
| 12 username varchar(50) not null unique, | 13 username varchar(50) not null unique, |
