Commits

dep4b  committed 829c925

Add sql scripts specific to propertyset

git-svn-id: http://svn.opensymphony.com/svn/propertyset/trunk@101bf3cbcdd-1c1a-0410-9a68-d6f521e3fa7b

  • Participants
  • Parent commits 4b36cd3

Comments (0)

Files changed (2)

File src/etc/deployment/jdbc/mckoi-hibernate.sql

+
+DROP TABLE IF EXISTS OS_PROPERTYENTRY;
+
+create table OS_PROPERTYENTRY (
+   entity_name VARCHAR(125) not null,
+   entity_id BIGINT not null,
+   entity_key VARCHAR(255) not null,
+   key_type INTEGER,
+   boolean_val BIT,
+   double_val DOUBLE,
+   string_val VARCHAR(255),
+   long_val BIGINT,
+   int_val INTEGER,
+   date_val DATE,
+   primary key (entity_name, entity_id, entity_key)
+);
+
+
+

File src/etc/deployment/jdbc/mckoi.sql

+
+DROP TABLE IF EXISTS OS_PROPERTYENTRY;
+
+CREATE TABLE OS_PROPERTYENTRY 
+(
+  GLOBAL_KEY varchar(255), 
+  ITEM_KEY varchar(255), 
+  ITEM_TYPE smallint, 
+  STRING_VALUE varchar(255), 
+  DATE_VALUE TIMESTAMP , 
+  DATA_VALUE varbinary(2000), 
+  FLOAT_VALUE float, 
+  NUMBER_VALUE numeric, 
+  primary key (GLOBAL_KEY, ITEM_KEY)
+);
+
+
+