19 lines
483 B
SQL
19 lines
483 B
SQL
DROP TABLE IF EXISTS rlarp.plcore;
|
|
|
|
CREATE TABLE rlarp.plcore (
|
|
stlc text
|
|
,coltier text
|
|
,branding text
|
|
,accs text
|
|
,suff text
|
|
,uomp text
|
|
,vol_uom text
|
|
,vol_qty numeric
|
|
,vol_price numeric
|
|
,listcode text
|
|
,orig_row numeric
|
|
,orig_col numeric
|
|
);
|
|
|
|
--CREATE UNIQUE INDEX plcore_pk ON rlarp.plcore (stlc, coltier, branding, accs, suff, uomp, listcode);
|