[Dcmms-devel] dcmms/script create_dcmms_ddl.sql,1.40,1.41

[<sdt...@us...>]

Update of /cvsroot/dcmms/dcmms/script
In directory sc8-pr-cvs1:/tmp/cvs-serv13720

Modified Files:
	create_dcmms_ddl.sql 
Log Message:
2003-10-30  Steffen Macke <Ste...@do...>

	* doc/development/data_model.vsd:
	* script/create_dcmms_ddl.sql: added DcmmsUser class. AdministrativeArea 
	is used now in DcmmsUser, Workorder, Team and CostCenter

Index: create_dcmms_ddl.sql
===================================================================
RCS file: /cvsroot/dcmms/dcmms/script/create_dcmms_ddl.sql,v
retrieving revision 1.40
retrieving revision 1.41
diff -C2 -d -r1.40 -r1.41
*** create_dcmms_ddl.sql	28 Oct 2003 16:06:13 -0000	1.40
--- create_dcmms_ddl.sql	30 Oct 2003 12:34:06 -0000	1.41
***************
*** 30,34 ****
  drop table Workorder cascade;
  drop table Village cascade;
! drop table center cascade;
  
  -- Drop subtype tables
--- 30,35 ----
  drop table Workorder cascade;
  drop table Village cascade;
! drop table center cascade
! drop table DcmmsUser cascade;
  
  -- Drop subtype tables
***************
*** 140,144 ****
    enDescript varchar(128),
    ArDescript varchar(128),
!   FrDescript varchar(128)
  );
  create table LeakLocation (
--- 141,146 ----
    enDescript varchar(128),
    ArDescript varchar(128),
!   FrDescript varchar(128),
!   AdministrativeArea integer
  );
  create table LeakLocation (
***************
*** 146,150 ****
    Description varchar(128)
  );
!   
  -- Create class tables
  create table Landmark (
--- 148,157 ----
    Description varchar(128)
  );
! 
! create table DcmmsUser (
!   Name varchar(64) primary key,
!   AdministrativeArea integer
! );
! 
  -- Create class tables
  create table Landmark (
***************
*** 176,180 ****
    Status integer references WorkorderStatus(CodedValue),
    ReceivedDate timestamp,
!   Note varchar(128)
  );
  select AddGeometryColumn('dcmms', 'workorder', 'areaofinterest', -1, 
--- 183,189 ----
    Status integer references WorkorderStatus(CodedValue),
    ReceivedDate timestamp,
!   Note varchar(128),
!   AdministrativeArea integer,
!   DcmmsUser varchar(64)
  );
  select AddGeometryColumn('dcmms', 'workorder', 'areaofinterest', -1, 
***************
*** 205,209 ****
    CostCenter varchar(32) primary key,
    EnDescription varchar(128),
!   ArDescription varchar(128)
  );
  
--- 214,220 ----
    CostCenter varchar(32) primary key,
    EnDescription varchar(128),
!   ArDescription varchar(128),
!   FrDescription varchar(128),
!   AdministrativeArea integer
  );
  
***************
*** 229,232 ****
--- 240,246 ----
  ) inherits(Resource);
  
+ insert into DcmmsUser values('dcmms', 1);
+ insert into DcmmsUser values('admin', 1);
+ 
  -- insert subtypes
  
***************
*** 308,342 ****
  insert into CauseDomain values(0, 'Other');
  
! insert into Team values(1, 'Complaint office', 'Complaint office', '');
! insert into Team values(2, 'Majdi Namneh','Majdi Namneh', '');
! insert into Team values(3, 'Aref Bani Hani', 'Aref Bani Hani', '');
! insert into Team values(4, 'Naief Bataineh', 'Naief Bataineh', '');
! insert into Team values(5, 'Khaled Mohawesh', 'Khaled Mohawesh', '');
! insert into Team values(6, 'Khaled Sheiab', 'Khaled Sheiab', '');
! insert into Team values(7, 'Fouad Ghazalin', 'Fouad Ghazalin', '');
! insert into Team values(8, 'Zeiad Bani Hani', 'Zeiad Bani Hani', '');
! insert into Team values(9, 'Fakhri Jaradat', 'Fakhri Jaradat', '');
! insert into Team values(10, 'South Team', 'South Team', '');
! insert into Team values(11, 'North Team', 'North Team', '');
! insert into Team values(12, 'Qasabat Jerash Team/In Morning', 
!   'Qasabat Jerash Team/Morning', '');
! insert into Team values(13, 'Qasabat Jerash Team/Evening', 
!   'Qasabat Jerash Team/In Evning', '');
! insert into Team values(14, 'West Team', 'West Team', '');
! insert into Team values(15, 'Middle Team', 'Middle Team', '');
! insert into Team values(16, 'West Jerash Team', 'West Jerash Team', '');
! insert into Team values(17, 'Emergency and Welding Team', 
!   'Emergency and Welding Team', '');
! insert into Team values(18, 'Mohammad Khalil/Hatem Zobi-Koura', 
!   'Mohammad Khalil/Hatem Zobi-Koura', '');
! insert into Team values(19, 'Abed Elmajid abu elnaj/Mohammad hassan', 
!   'Abed Elmajid abu elnaj/Mohammad hassan','');
! insert into Team values(20, 'Fisal zoabi/Ali zoabi-Koura', 
!   'Fisal zoabi/Ali zoabi-koura', '');
! insert into Team values(21, 'Ateieh/Abdel qader rason-Koura', 
!   'Ateieh/Abdel qader rason-Koura', '');
! insert into Team values(22, 'Abu hamzeh/Aiesh-Koura', 
!   'Abu hamzeh/Aiesh-Koura', '');
! 
  
  insert into LeakLocation values(1, 'On fitting');
--- 322,326 ----
  insert into CauseDomain values(0, 'Other');
  
! insert into Team values(1, 'Team 1', 'Team 1', 'Team 1', 1);
  
  insert into LeakLocation values(1, 'On fitting');
***************
*** 403,408 ****
    (5, 'Pipe welder', 'working hour');
  
- 
-   
  insert into EquipmentSubtype (Subtype, Description, Unit) values 
    (1, 'Backhoe', 'hour');
--- 387,390 ----
***************
*** 412,417 ****
    (3, 'Welding Machine', 'hour');
  
! insert into CostCenter values('100','100','100');
! insert into CostCenter values('101','101','101');  
    
  -- permissions
--- 394,399 ----
    (3, 'Welding Machine', 'hour');
  
! insert into CostCenter values('100', '100', '100', 1);
! insert into CostCenter values('101', '101', '101', 1);  
    
  -- permissions
***************
*** 447,449 ****
--- 429,432 ----
  grant all on Staff to group dcmmsuser;
  grant all on center to group dcmmsuser;
+ grant all on DcmmsUser to group dcmmsuser;