diff options
| author | Nils Adermann <naderman@naderman.de> | 2011-09-20 21:26:37 +0200 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2011-09-20 21:26:37 +0200 |
| commit | 4e8e31c10b11972a073a79fbbd7865a1195ef456 (patch) | |
| tree | ca0578de1e67d065004f770d3881b37482c8bae9 /phpBB/install/schemas/postgres_schema.sql | |
| parent | f31d32dd89e5d01e08f0ae09b43042377bfdfc0c (diff) | |
| parent | 3e76f7468864f5e5d8c3f805745c44e422ae817c (diff) | |
| download | forums-4e8e31c10b11972a073a79fbbd7865a1195ef456.tar forums-4e8e31c10b11972a073a79fbbd7865a1195ef456.tar.gz forums-4e8e31c10b11972a073a79fbbd7865a1195ef456.tar.bz2 forums-4e8e31c10b11972a073a79fbbd7865a1195ef456.tar.xz forums-4e8e31c10b11972a073a79fbbd7865a1195ef456.zip | |
Merge remote-tracking branch 'github-cyberalien/feature/remove-imagesets' into develop
* github-cyberalien/feature/remove-imagesets:
[feature/remove-imagesets] Script for converting imageset to css
[feature/remove-imagesets] Changing subsilver
[feature/remove-imagesets] Changing prosilver
[feature/remove-imagesets] Adjustments to php files
[feature/remove-imagesets] Changing admin control panel styles module
[feature/remove-imagesets] Changing database structure
[feature/remove-imagesets] Removing imageset files
[feature/remove-imagesets] Moving images
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 35 |
1 files changed, 0 insertions, 35 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 1aa47b4d61..13a00d2ebc 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -983,14 +983,12 @@ CREATE TABLE phpbb_styles ( style_active INT2 DEFAULT '1' NOT NULL CHECK (style_active >= 0), template_id INT4 DEFAULT '0' NOT NULL CHECK (template_id >= 0), theme_id INT4 DEFAULT '0' NOT NULL CHECK (theme_id >= 0), - imageset_id INT4 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0), PRIMARY KEY (style_id) ); CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name); CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id); CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id); -CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id); /* Table: 'phpbb_styles_template' @@ -1044,39 +1042,6 @@ CREATE TABLE phpbb_styles_theme ( CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name); /* - Table: 'phpbb_styles_imageset' -*/ -CREATE SEQUENCE phpbb_styles_imageset_seq; - -CREATE TABLE phpbb_styles_imageset ( - imageset_id INT4 DEFAULT nextval('phpbb_styles_imageset_seq'), - imageset_name varchar(255) DEFAULT '' NOT NULL, - imageset_copyright varchar(255) DEFAULT '' NOT NULL, - imageset_path varchar(100) DEFAULT '' NOT NULL, - PRIMARY KEY (imageset_id) -); - -CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name); - -/* - Table: 'phpbb_styles_imageset_data' -*/ -CREATE SEQUENCE phpbb_styles_imageset_data_seq; - -CREATE TABLE phpbb_styles_imageset_data ( - image_id INT4 DEFAULT nextval('phpbb_styles_imageset_data_seq'), - image_name varchar(200) DEFAULT '' NOT NULL, - image_filename varchar(200) DEFAULT '' NOT NULL, - image_lang varchar(30) DEFAULT '' NOT NULL, - image_height INT2 DEFAULT '0' NOT NULL CHECK (image_height >= 0), - image_width INT2 DEFAULT '0' NOT NULL CHECK (image_width >= 0), - imageset_id INT4 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0), - PRIMARY KEY (image_id) -); - -CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id); - -/* Table: 'phpbb_topics' */ CREATE SEQUENCE phpbb_topics_seq; |