diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-03-21 22:43:07 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-03-21 22:43:07 +0000 |
| commit | a4e51c9699c7a09bea32ad832a9818abba008801 (patch) | |
| tree | 42feb7021db4bd9cb9334e65b23260d491d3b131 /phpBB/install/schemas/postgres_schema.sql | |
| parent | 68b7397da8197d23dae07fc0e7927697cb1e3492 (diff) | |
| download | forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.gz forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.bz2 forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.xz forums-a4e51c9699c7a09bea32ad832a9818abba008801.zip | |
- first try to break things...
git-svn-id: file:///svn/phpbb/trunk@5108 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 0de7a6421a..dc9e5dad9e 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -847,25 +847,25 @@ CREATE TABLE phpbb_sitelist ( SELECT SETVAL('phpbb_sitelist_site_id_seq',(select case when max(site_id)>0 then max(site_id)+1 else 1 end from phpbb_sitelist)); /* Table: phpbb_smilies */ -CREATE SEQUENCE phpbb_smilies_smile_id_seq; +CREATE SEQUENCE phpbb_smilies_smiley_id_seq; CREATE TABLE phpbb_smilies ( - smile_id INT2 DEFAULT nextval('phpbb_smilies_smile_id_seq'), + smiley_id INT2 DEFAULT nextval('phpbb_smilies_smiley_id_seq'), code char(10), - emoticon char(50), - smile_url char(50), - smile_width INT2 NOT NULL, - smile_height INT2 NOT NULL, - smile_order INT2 NOT NULL, + smiley char(50), + smiley_url char(50), + smiley_width INT2 NOT NULL, + smiley_height INT2 NOT NULL, + smiley_order INT2 NOT NULL, display_on_posting INT2 DEFAULT '1' NOT NULL, - PRIMARY KEY (smile_id), - CHECK (smile_width>=0), - CHECK (smile_height>=0), - CHECK (smile_order>=0), + PRIMARY KEY (smiley_id), + CHECK (smiley_width>=0), + CHECK (smiley_height>=0), + CHECK (smiley_order>=0), CHECK (display_on_posting>=0) ); -SELECT SETVAL('phpbb_smilies_smile_id_seq',(select case when max(smile_id)>0 then max(smile_id)+1 else 1 end from phpbb_smilies)); +SELECT SETVAL('phpbb_smilies_smiley_id_seq',(select case when max(smiley_id)>0 then max(smiley_id)+1 else 1 end from phpbb_smilies)); /* Table: phpbb_styles */ CREATE SEQUENCE phpbb_styles_style_id_seq; |