IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 5488


Ignore:
Timestamp:
Nov 8, 2005, 2:49:44 PM (21 years ago)
Author:
jhoblitt
Message:

drop database scheme as it is a duplicate of Nebulous::Server::SQL

Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/Nebulous-Server/docs/database_setup.txt

    r5479 r5488  
    11# Copyright (C) 2004  Joshua Hoblitt
    22#
    3 # $Id: database_setup.txt,v 1.6 2005-11-05 02:46:32 jhoblitt Exp $
     3# $Id: database_setup.txt,v 1.7 2005-11-09 00:49:44 jhoblitt Exp $
    44
    55### Database Setup
    … …  
    1313FLUSH PRIVILEGES;
    1414USE nebulous;
    15 
    16 DROP TABLE IF EXISTS storage_object;
    17 CREATE TABLE storage_object (
    18     so_id BIGINT NOT NULL AUTO_INCREMENT,
    19     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
    20     PRIMARY KEY(so_id),
    21     KEY(ext_id(64)),
    22 ) ENGINE=innodb;
    23 
    24 DROP TABLE IF EXISTS storage_attr ;
    25 CREATE TABLE storage_attr (
    26     so_id BIGINT NOT NULL AUTO_INCREMENT,
    27     class_id TINYINT NOT NULL,
    28     comment VARCHAR(255),
    29     read_lock TINYINT DEFAULT 0 NOT NULL,
    30     write_lock ENUM( 'write' ),
    31     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    32     mtime TIMESTAMP,
    33     PRIMARY KEY(so_id),
    34     KEY(class_id)
    35 ) ENGINE=innodb;
    36 
    37 DROP TABLE IF EXISTS instance;
    38 CREATE TABLE instance (
    39     ins_id BIGINT NOT NULL AUTO_INCREMENT,
    40     so_id BIGINT NOT NULL,
    41     uri VARCHAR(255) BINARY NOT NULL,
    42     sha1sum CHAR(40) ASCII,
    43     assigned_location BOOL,
    44     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    45     mtime TIMESTAMP,
    46     PRIMARY KEY(ins_id),
    47     KEY(so_id),
    48     KEY(uri(64))
    49 ) ENGINE=innodb;
    50 
    51 DROP TABLE IF EXISTS lock_record;
    52 CREATE TABLE lock_record (
    53         so_id BIGINT NOT NULL,
    54         type ENUM( 'read', 'write' ) NOT NULL,
    55         epoch TIMESTAMP,
    56         KEY(so_ID)
    57     ) ENGINE=innodb;
    58 
    59 DROP TABLE IF EXISTS volume;
    60 CREATE TABLE volume (
    61         vol_id INT NOT NULL AUTO_INCREMENT,
    62         name VARCHAR(255) UNIQUE BINARY NOT NULL,
    63         uri VARCHAR(255) BINARY NOT NULL,
    64         key(vol_id)
    65     ) ENGINE=innodb;
    66 
    67 DROP TABLE IF EXISTS class;
    68 CREATE TABLE class (
    69         class_id TINYINT NOT NULL AUTO_INCREMENT,
    70         instance TINYINT NOT NULL,
    71         priority TINYINT,
    72         comment VARCHAR(255),
    73         key(class_id)
    74     ) ENGINE=innodb;
    75 
    76 DROP TABLE IF EXISTS log;
    77 CREATE TABLE log (
    78     timestamp TIMESTAMP,
    79     hostname VARCHAR(255),
    80     level VARCHAR(255),
    81     sub VARCHAR(255),   
    82     message VARCHAR(2048) NOT NULL,
    83     PRIMARY KEY(timestamp)
    84 ) ENGINE=innodb;
    85 
    8615
    8716### Initialization

  • trunk/Nebulous/docs/database_setup.txt

    r5479 r5488  
    11# Copyright (C) 2004  Joshua Hoblitt
    22#
    3 # $Id: database_setup.txt,v 1.6 2005-11-05 02:46:32 jhoblitt Exp $
     3# $Id: database_setup.txt,v 1.7 2005-11-09 00:49:44 jhoblitt Exp $
    44
    55### Database Setup
    … …  
    1313FLUSH PRIVILEGES;
    1414USE nebulous;
    15 
    16 DROP TABLE IF EXISTS storage_object;
    17 CREATE TABLE storage_object (
    18     so_id BIGINT NOT NULL AUTO_INCREMENT,
    19     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
    20     PRIMARY KEY(so_id),
    21     KEY(ext_id(64)),
    22 ) ENGINE=innodb;
    23 
    24 DROP TABLE IF EXISTS storage_attr ;
    25 CREATE TABLE storage_attr (
    26     so_id BIGINT NOT NULL AUTO_INCREMENT,
    27     class_id TINYINT NOT NULL,
    28     comment VARCHAR(255),
    29     read_lock TINYINT DEFAULT 0 NOT NULL,
    30     write_lock ENUM( 'write' ),
    31     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    32     mtime TIMESTAMP,
    33     PRIMARY KEY(so_id),
    34     KEY(class_id)
    35 ) ENGINE=innodb;
    36 
    37 DROP TABLE IF EXISTS instance;
    38 CREATE TABLE instance (
    39     ins_id BIGINT NOT NULL AUTO_INCREMENT,
    40     so_id BIGINT NOT NULL,
    41     uri VARCHAR(255) BINARY NOT NULL,
    42     sha1sum CHAR(40) ASCII,
    43     assigned_location BOOL,
    44     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    45     mtime TIMESTAMP,
    46     PRIMARY KEY(ins_id),
    47     KEY(so_id),
    48     KEY(uri(64))
    49 ) ENGINE=innodb;
    50 
    51 DROP TABLE IF EXISTS lock_record;
    52 CREATE TABLE lock_record (
    53         so_id BIGINT NOT NULL,
    54         type ENUM( 'read', 'write' ) NOT NULL,
    55         epoch TIMESTAMP,
    56         KEY(so_ID)
    57     ) ENGINE=innodb;
    58 
    59 DROP TABLE IF EXISTS volume;
    60 CREATE TABLE volume (
    61         vol_id INT NOT NULL AUTO_INCREMENT,
    62         name VARCHAR(255) UNIQUE BINARY NOT NULL,
    63         uri VARCHAR(255) BINARY NOT NULL,
    64         key(vol_id)
    65     ) ENGINE=innodb;
    66 
    67 DROP TABLE IF EXISTS class;
    68 CREATE TABLE class (
    69         class_id TINYINT NOT NULL AUTO_INCREMENT,
    70         instance TINYINT NOT NULL,
    71         priority TINYINT,
    72         comment VARCHAR(255),
    73         key(class_id)
    74     ) ENGINE=innodb;
    75 
    76 DROP TABLE IF EXISTS log;
    77 CREATE TABLE log (
    78     timestamp TIMESTAMP,
    79     hostname VARCHAR(255),
    80     level VARCHAR(255),
    81     sub VARCHAR(255),   
    82     message VARCHAR(2048) NOT NULL,
    83     PRIMARY KEY(timestamp)
    84 ) ENGINE=innodb;
    85 
    8615
    8716### Initialization
Note: See TracChangeset for help on using the changeset viewer.