projects
/
mir.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
no message
[mir.git]
/
dbscripts
/
create_pg.sql
diff --git
a/dbscripts/create_pg.sql
b/dbscripts/create_pg.sql
index
9173fdf
..
c893655
100755
(executable)
--- a/
dbscripts/create_pg.sql
+++ b/
dbscripts/create_pg.sql
@@
-333,6
+333,8
@@
CREATE TABLE "uploaded_media" (
CREATE TABLE "images" (
"image_data" oid,
"icon_data" oid,
CREATE TABLE "images" (
"image_data" oid,
"icon_data" oid,
+ "icon_is_produced" boolean DEFAULT '0' NOT NULL,
+ "icon_path" character varying(255),
"year" character varying(40),
"img_width" smallint,
"img_height" smallint,
"year" character varying(40),
"img_width" smallint,
"img_height" smallint,
@@
-343,7
+345,7
@@
CREATE TABLE "images" (
"icon_width" smallint,
"icon_height" smallint
)
"icon_width" smallint,
"icon_height" smallint
)
-INHERITS ("
uploaded_
media");
+INHERITS ("media");
--
-- TOC Entry ID 29 (OID 29338)
--
-- TOC Entry ID 29 (OID 29338)