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
|
