56 lines
1.9 KiB
SQL
56 lines
1.9 KiB
SQL
-- LegacyWorlds Beta 5
|
|
-- PostgreSQL database scripts
|
|
--
|
|
-- beta5/structure/06-message-battle.sql
|
|
--
|
|
-- Beta 5 games:
|
|
-- Table to store battle reports
|
|
--
|
|
-- Copyright(C) 2004-2007, DeepClone Development
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
|
|
CREATE TABLE msg_battle (
|
|
id BIGINT NOT NULL REFERENCES message (id) ON DELETE CASCADE,
|
|
planet_id BIGINT NOT NULL REFERENCES planet (id),
|
|
planet VARCHAR(15) NOT NULL,
|
|
o_gaships INT NOT NULL DEFAULT 0,
|
|
o_fighters INT NOT NULL DEFAULT 0,
|
|
o_cruisers INT NOT NULL DEFAULT 0,
|
|
o_bcruisers INT NOT NULL DEFAULT 0,
|
|
o_power INT NOT NULL DEFAULT 0,
|
|
ol_gaships INT NOT NULL DEFAULT 0,
|
|
ol_fighters INT NOT NULL DEFAULT 0,
|
|
ol_cruisers INT NOT NULL DEFAULT 0,
|
|
ol_bcruisers INT NOT NULL DEFAULT 0,
|
|
ol_power INT NOT NULL DEFAULT 0,
|
|
a_gaships INT NOT NULL DEFAULT 0,
|
|
a_fighters INT NOT NULL DEFAULT 0,
|
|
a_cruisers INT NOT NULL DEFAULT 0,
|
|
a_bcruisers INT NOT NULL DEFAULT 0,
|
|
a_power INT NOT NULL DEFAULT 0,
|
|
al_gaships INT NOT NULL DEFAULT 0,
|
|
al_fighters INT NOT NULL DEFAULT 0,
|
|
al_cruisers INT NOT NULL DEFAULT 0,
|
|
al_bcruisers INT NOT NULL DEFAULT 0,
|
|
al_power INT NOT NULL DEFAULT 0,
|
|
e_gaships INT NOT NULL DEFAULT 0,
|
|
e_fighters INT NOT NULL DEFAULT 0,
|
|
e_cruisers INT NOT NULL DEFAULT 0,
|
|
e_bcruisers INT NOT NULL DEFAULT 0,
|
|
e_power INT NOT NULL DEFAULT 0,
|
|
el_gaships INT NOT NULL DEFAULT 0,
|
|
el_fighters INT NOT NULL DEFAULT 0,
|
|
el_cruisers INT NOT NULL DEFAULT 0,
|
|
el_bcruisers INT NOT NULL DEFAULT 0,
|
|
el_power INT NOT NULL DEFAULT 0,
|
|
turrets INT NOT NULL DEFAULT 0,
|
|
tpower INT NOT NULL DEFAULT 0,
|
|
l_turrets INT NOT NULL DEFAULT 0,
|
|
l_tpower INT NOT NULL DEFAULT 0,
|
|
tmode SMALLINT NOT NULL DEFAULT 0,
|
|
heroic_def INT NOT NULL CHECK(heroic_def >= -1 AND heroic_def <= 1)
|
|
);
|
|
CREATE INDEX msg_battle_planet ON msg_battle (planet_id);
|
|
GRANT INSERT,DELETE,SELECT ON msg_battle TO legacyworlds;
|