|
From: Chris W. <la...@us...> - 2001-10-15 04:25:07
|
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 |