[Openinteract-commits] CVS: SPOPS/eg users_groups_mysql.sql,1.3,1.4 users_groups_pgsql.sql,1.3,1.4 users_groups_tsql.sql,1.3,1.4

[Chris W. <la...@us...>]

Update of /cvsroot/openinteract/SPOPS/eg
In directory usw-pr-cvs1:/tmp/cvs-serv28096

Modified Files:
	users_groups_mysql.sql users_groups_pgsql.sql 
	users_groups_tsql.sql 
Log Message:
updated SQL to include the sample dummy object (doodad) table


Index: users_groups_mysql.sql
===================================================================
RCS file: /cvsroot/openinteract/SPOPS/eg/users_groups_mysql.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** users_groups_mysql.sql	2001/10/08 02:33:11	1.3
--- users_groups_mysql.sql	2001/10/15 04:25:04	1.4
***************
*** 38,39 ****
--- 38,50 ----
  );
  
+ 
+ CREATE TABLE spops_doodad (
+  doodad_id      int not null auto_increment,
+  name           varchar(100) not null,
+  description    text null,
+  unit_cost      numeric(10,2) default 0,
+  factory        varchar(50) not null,
+  created_by     int not null,
+  primary key    ( doodad_id ),
+  unique         ( name )
+ );
\ No newline at end of file

Index: users_groups_pgsql.sql
===================================================================
RCS file: /cvsroot/openinteract/SPOPS/eg/users_groups_pgsql.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** users_groups_pgsql.sql	2001/10/08 02:33:11	1.3
--- users_groups_pgsql.sql	2001/10/15 04:25:04	1.4
***************
*** 38,39 ****
--- 38,50 ----
  );
  
+ 
+ CREATE TABLE spops_doodad (
+  doodad_id      serial,
+  name           varchar(100) not null,
+  description    text null,
+  unit_cost      numeric(10,2) default 0,
+  factory        varchar(50) not null,
+  created_by     int not null,
+  primary key    ( doodad_id ),
+  unique         ( name )
+ );
\ No newline at end of file

Index: users_groups_tsql.sql
===================================================================
RCS file: /cvsroot/openinteract/SPOPS/eg/users_groups_tsql.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** users_groups_tsql.sql	2001/10/08 02:33:11	1.3
--- users_groups_tsql.sql	2001/10/15 04:25:04	1.4
***************
*** 1,4 ****
  CREATE TABLE spops_user (
!  user_id       numeric( 10, 0 ) identity not null,
   login_name    varchar(25) not null,
   password      varchar(30) not null,
--- 1,4 ----
  CREATE TABLE spops_user (
!  user_id       numeric(10,0) identity not null,
   login_name    varchar(25) not null,
   password      varchar(30) not null,
***************
*** 13,17 ****
  
  CREATE TABLE spops_group (
!  group_id      numeric( 10, 0 ) identity not null,
   name          varchar(30) not null,
   notes         text null,
--- 13,17 ----
  
  CREATE TABLE spops_group (
!  group_id      numeric(10,0) identity not null,
   name          varchar(30) not null,
   notes         text null,
***************
*** 21,26 ****
  
  CREATE TABLE spops_group_user (
!  group_id      numeric( 10, 0 ) not null,
!  user_id       numeric( 10, 0 ) not null,
   primary key   ( group_id, user_id )
  );
--- 21,26 ----
  
  CREATE TABLE spops_group_user (
!  group_id      numeric(10,0) not null,
!  user_id       numeric(10,0) not null,
   primary key   ( group_id, user_id )
  );
***************
*** 28,32 ****
  
  CREATE TABLE spops_security (
!  sid            numeric( 10, 0 ) identity not null,
   class          varchar(60) not null,
   object_id      varchar(150) default '0',
--- 28,32 ----
  
  CREATE TABLE spops_security (
!  sid            numeric(10,0) identity not null,
   class          varchar(60) not null,
   object_id      varchar(150) default '0',
***************
*** 38,39 ****
--- 38,50 ----
  );
  
+ 
+ CREATE TABLE spops_doodad (
+  doodad_id      numeric(10,0) identity not null,
+  name           varchar(100) not null,
+  description    text null,
+  unit_cost      numeric(10,2) default 0,
+  factory        varchar(50) not null,
+  created_by     int not null,
+  primary key    ( doodad_id ),
+  unique         ( name )
+ );
\ No newline at end of file