Changeset 31875
- Timestamp:
- Jul 13, 2011, 2:35:34 PM (15 years ago)
- File:
-
- 1 edited
-
trunk/tools/czartool/CzarDb.pm (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/czartool/CzarDb.pm
r31826 r31875 1640 1640 1641 1641 # same shape as other stage tables to enable easy update 1642 my $query = $self->{_db}->prepare(<<SQL);1643 CREATE TABLE burntool (1644 timestamp TIMESTAMP DEFAULT NOW(),1645 label VARCHAR(128) DEFAULT "NONE",1646 pending BIGINT NOT NULL,1647 processed BIGINT NOT NULL,1648 faults BIGINT NOT NULL);1649 SQL1650 1651 $query->execute;1652 $query = $self->{_db}->prepare(<<SQL);1653 CREATE INDEX burntoolIndex ON burntool (timestamp, label);1654 SQL1655 1656 $query->execute;1642 #my $query = $self->{_db}->prepare(<<SQL); 1643 #CREATE TABLE burntool ( 1644 # timestamp TIMESTAMP DEFAULT NOW(), 1645 # label VARCHAR(128) DEFAULT "NONE", 1646 # pending BIGINT NOT NULL, 1647 # processed BIGINT NOT NULL, 1648 # faults BIGINT NOT NULL); 1649 #SQL 1650 1651 # $query->execute; 1652 # $query = $self->{_db}->prepare(<<SQL); 1653 # CREATE INDEX burntoolIndex ON burntool (timestamp, label); 1654 #SQL 1655 1656 # $query->execute; 1657 1657 1658 1658 $self->setRevision(11);
Note:
See TracChangeset
for help on using the changeset viewer.
