Login | Register
My pages Projects Community openCollabNet

Discussions > cvs > CVS update: joist/sql/org/joist INSTALL.LoadOrder.lst create_DeletedUser.sql create_Message.sql create_Permission.sql create_Request.sql create_Role.sql create_RolePermission.sql create_User.sql create_UserRole.sql

Project highlights: Architectural Overview

joist
Discussion topic

Back to topic list

CVS update: joist/sql/org/joist INSTALL.LoadOrder.lst create_DeletedUser.sql create_Message.sql create_Permission.sql create_Request.sql create_Role.sql create_RolePermission.sql create_User.sql create_UserRole.sql

Author thom
Full name Thom Wood
Date 2000-11-07 15:17:22 PST
Message User: thom
  Date: 00/11/07 15:17:22

  Added: sql/org/joist INSTALL.LoadOrder.lst create_DeletedUser.sql
                        create_Message.sql create_Permission.sql
                        create_Request.sql create_Role.sql
                        create_RolePermission.sql create_User.sql
                        create_UserRole.sql
  Log:
  split joist.sql and added an install list in prep for new create script
  
  Revision Changes Path
  1.1 joist/sql/org/joist/​INSTALL.LoadOrder.ls​t
  
  Index: INSTALL.LoadOrder.lst
  ====================​====================​====================​=======
  #####################
  ##
  ## this assume we wish to keep nothing
  ##
  ####################
  
  #
  # We must load the table definitions
  #
  create_DeletedUser.sql
  create_Message.sql
  create_Permission.sql
  create_Request.sql
  create_Role.sql
  create_RolePermission.sql
  create_User.sql
  create_UserRole.sql
  
  
  
  1.1 joist/sql/org/joist/​create_DeletedUser.s​ql
  
  Index: create_DeletedUser.sql
  ====================​====================​====================​=======
  drop table if exists DeletedUser;
  
  create table DeletedUser (
      userID integer NOT NULL, # retain the userID
      loginID varchar (32) NOT NULL,
      password varchar (32),
      name varchar (99) NOT NULL,
      address1 varchar (32),
      address2 varchar (32),
      city varchar (32),
      state varchar (32),
      postalCode varchar (32),
      country varchar (32),
      phone varchar (32),
      altPhone varchar (32),
      fax varchar (32),
      cell varchar (32),
      pager varchar (32),
      created datetime,
      modified datetime,
      lastLogin datetime,
      deleted timestamp
  );
  
  
  
  1.1 joist/sql/org/joist/​create_Message.sql
  
  Index: create_Message.sql
  ====================​====================​====================​=======
  
  drop table if exists Message;
  
  create table Message (
      messageID char (4) PRIMARY KEY,
      messageText varchar (150)
  );
  
  
  
  1.1 joist/sql/org/joist/​create_Permission.sq​l
  
  Index: create_Permission.sql
  ====================​====================​====================​=======
  drop table if exists Permission;
  
  create table Permission (
      permissionID integer AUTO_INCREMENT PRIMARY KEY,
      name varchar (99) NOT NULL,
      UNIQUE (name)
  );
  
  
  
  1.1 joist/sql/org/joist/​create_Request.sql
  
  Index: create_Request.sql
  ====================​====================​====================​=======
  drop table if exists Request;
  
  create table Request (
      servlet varchar (99) NOT NULL,
      action varchar (32),
      subject varchar (32),
      subjectID integer,
      sessionID varchar (32),
      userID integer,
      created timestamp
  );
  
  
  
  1.1 joist/sql/org/joist/​create_Role.sql
  
  Index: create_Role.sql
  ====================​====================​====================​=======
  drop table if exists Role;
  
  create table Role (
      roleID integer AUTO_INCREMENT PRIMARY KEY,
      name varchar (99) NOT NULL,
      UNIQUE (name)
  );
  
  
  
  1.1 joist/sql/org/joist/​create_RolePermissio​n.sql
  
  Index: create_RolePermission.sql
  ====================​====================​====================​=======
  drop table if exists RolePermission;
  
  create table RolePermission (
      roleID integer NOT NULL,
      permissionID integer NOT NULL,
      PRIMARY KEY (roleID, permissionID)
  );
  
  create index permissionID on RolePermission (permissionID);
  
  
  
  1.1 joist/sql/org/joist/​create_User.sql
  
  Index: create_User.sql
  ====================​====================​====================​=======
  
  drop table if exists User;
  
  create table User (
      userID integer AUTO_INCREMENT PRIMARY KEY,
      loginID varchar (32) NOT NULL,
      password varchar (32),
      name varchar (99) NOT NULL,
      address1 varchar (32),
      address2 varchar (32),
      city varchar (32),
      state varchar (32),
      postalCode varchar (32),
      country varchar (32),
      citizenship varchar (32),
      phone varchar (32),
      altPhone varchar (32),
      fax varchar (32),
      cell varchar (32),
      pager varchar (32),
      email varchar (99),
      modified timestamp,
      created timestamp,
      type enum('base', 'group', 'host', 'domain', 'nobody') NOT NULL,
      UNIQUE (loginID)
  );
  
  create index type on User (type);
  
  
  
  1.1 joist/sql/org/joist/​create_UserRole.sql
  
  Index: create_UserRole.sql
  ====================​====================​====================​=======
  drop table if exists UserRole;
  
  create table UserRole (
      userID integer NOT NULL,
      roleID integer NOT NULL,
      PRIMARY KEY (userID, roleID)
  );
  
  create index userID on UserRole (userID);

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

CVS update: joist/sql/org/joist INSTALL.LoadOrder.lst create_DeletedUser.sql create_Message.sql create_Permission.sql create_Request.sql create_Role.sql create_RolePermission.sql create_User.sql creat... thom Thom Wood 2000-11-07 15:17:22 PST
Messages per page: