28 lines
642 B
SQL
28 lines
642 B
SQL
-- LegacyWorlds Beta 5
|
|
-- PostgreSQL database scripts
|
|
--
|
|
-- beta5/structure/00-ecm-eccm.sql
|
|
--
|
|
-- Beta 5 games:
|
|
-- Tables that store ECM and ECCM settings
|
|
--
|
|
-- Copyright(C) 2004-2007, DeepClone Development
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
CREATE TABLE eccm (
|
|
eccm_level SMALLINT NOT NULL,
|
|
gain SMALLINT NOT NULL,
|
|
probability SMALLINT NOT NULL,
|
|
PRIMARY KEY (eccm_level, gain)
|
|
);
|
|
|
|
CREATE TABLE ecm (
|
|
ecm_level SMALLINT NOT NULL,
|
|
info_level SMALLINT NOT NULL,
|
|
probability SMALLINT NOT NULL,
|
|
PRIMARY KEY (ecm_level, info_level)
|
|
);
|
|
|
|
GRANT SELECT ON eccm TO legacyworlds;
|
|
GRANT SELECT ON ecm TO legacyworlds;
|