Login | Register
My pages Projects Community openCollabNet

Discussions > cvs > CVS update: joist/sql/org/joist joist.sql

Project highlights: Architectural Overview

joist
Discussion topic

Back to topic list

CVS update: joist/sql/org/joist joist.sql

Author anoncvs
Full name anonymous CVS access
Date 2000-09-12 14:30:33 PDT
Message User: jrobbins
  Date: 00/09/12 14:30:33

  Added: sql/org/joist joist.sql
  Log:
  initial checkin
  
  Revision Changes Path
  1.1 joist/sql/org/joist/joist.sql
  
  Index: joist.sql
  ====================​====================​====================​=======
  #
  # SourceXchange Database Schema
  #
  #
  #
  # Copyright (C) 1999 DataWeb Systems, Inc. All Rights reserved.
  #
  
  drop table if exists Dual;
  
  create table Dual (nothing char(1));
  
  
  
  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
  );
  
  
  
  drop table if exists Message;
  
  create table Message (
      messageID char (4) PRIMARY KEY,
      messageText varchar (150)
  );
  
  
  
  drop table if exists Permission;
  
  create table Permission (
      permissionID integer AUTO_INCREMENT PRIMARY KEY,
      name varchar (99) NOT NULL,
      UNIQUE (name)
  );
  
  
  
  
  
  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
  );
  
  
  
  drop table if exists Role;
  
  create table Role (
      roleID integer AUTO_INCREMENT PRIMARY KEY,
      name varchar (99) NOT NULL,
      UNIQUE (name)
  );
  
  
  
  drop table if exists RolePermission;
  
  create table RolePermission (
      roleID integer NOT NULL,
      permissionID integer NOT NULL,
      PRIMARY KEY (roleID, permissionID)
  );
  
  create index RolePermission_permissionID on RolePermission (permissionID);
  
  
  
  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,
      UNIQUE (loginID)
  );
  
  
  
  drop table if exists UserRole;
  
  create table UserRole (
      userID integer NOT NULL,
      roleID integer NOT NULL,
      PRIMARY KEY (userID, roleID)
  );
  
  create index UserRole_roleID on UserRole (roleID);

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

Messages

Show all messages in topic

CVS update: joist/sql/org/joist joist.sql anoncvs anonymous CVS access 2000-09-12 14:30:33 PDT
Messages per page: