OrgGrid: ogm.sql

File ogm.sql, 5.1 kB (added by teleyinex, 2 weeks ago)

Data Base

Line 
1 -- phpMyAdmin SQL Dump
2 -- version 2.11.3deb1ubuntu1
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: localhost
6 -- Generation Time: Aug 11, 2008 at 02:43 PM
7 -- Server version: 5.0.51
8 -- PHP Version: 5.2.4-2ubuntu5.3
9
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12 --
13 -- Database: `ogm`
14 --
15
16 -- --------------------------------------------------------
17
18 --
19 -- Table structure for table `host`
20 --
21
22 CREATE TABLE IF NOT EXISTS `host` (
23   `id` int(11) NOT NULL auto_increment,
24   `poolid` int(11) default NULL,
25   `supplier` varchar(255) collate utf8_bin NOT NULL,
26   `CPID` varchar(255) collate utf8_bin default NULL,
27   `host_cpid` varchar(255) collate utf8_bin NOT NULL,
28   `venue` varchar(254) collate utf8_bin default NULL,
29   `p_ncpus` int(11) NOT NULL,
30   `p_vendor` varchar(255) collate utf8_bin NOT NULL,
31   `p_model` varchar(255) collate utf8_bin NOT NULL,
32   `p_fpops` float NOT NULL,
33   `p_iops` float NOT NULL,
34   `os_name` varchar(255) collate utf8_bin NOT NULL,
35   `os_version` varchar(255) collate utf8_bin NOT NULL,
36   PRIMARY KEY  (`id`),
37   KEY `poolid` (`poolid`),
38   KEY `CPID` (`CPID`)
39 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
40
41 -- --------------------------------------------------------
42
43 --
44 -- Table structure for table `pool`
45 --
46
47 CREATE TABLE IF NOT EXISTS `pool` (
48   `id` int(11) NOT NULL auto_increment,
49   `name` varchar(255) collate utf8_bin NOT NULL,
50   `supplier` varchar(255) collate utf8_bin NOT NULL,
51   `start_hour` varchar(5) collate utf8_bin NOT NULL default '0.0',
52   `end_hour` varchar(5) collate utf8_bin NOT NULL default '0.0',
53   `suspend_while_on_batteries` tinyint(1) NOT NULL default '1',
54   `suspend_if_user_active` tinyint(1) NOT NULL default '1',
55   `idle_time_to_run` int(11) NOT NULL default '3',
56   `suspend_if_no_recent_input` int(11) NOT NULL default '0',
57   `leave_apps_in_memory` tinyint(1) NOT NULL default '0',
58   `cpu_scheduling_period_minutes` int(11) NOT NULL default '60',
59   `max_cpus` int(11) NOT NULL default '16',
60   `max_ncpus_pct` int(11) NOT NULL default '100',
61   `cpu_usage_limit` int(11) NOT NULL default '100',
62   `disk_max_used_gb` float NOT NULL default '100',
63   `disk_min_free_gb` float NOT NULL default '0.001',
64   `disk_max_used_pct` int(11) NOT NULL default '50',
65   `disk_interval` int(11) NOT NULL default '60',
66   `vm_max_used_pct` int(11) NOT NULL default '75',
67   `ram_max_used_busy_pct` int(11) NOT NULL default '50',
68   `ram_max_used_idle_pct` int(11) NOT NULL default '90',
69   `work_buf_min_days` int(11) NOT NULL default '0',
70   `work_buf_additional_days` float NOT NULL default '0.25',
71   `confirm_before_connecting` tinyint(1) NOT NULL default '0',
72   `hangup_if_dialed` tinyint(1) NOT NULL default '0',
73   `max_bytes_sec_down` float NOT NULL default '0',
74   `max_bytes_sec_up` float NOT NULL default '0',
75   `net_start_hour` varchar(5) collate utf8_bin NOT NULL default '0.0',
76   `net_end_hour` varchar(5) collate utf8_bin NOT NULL default '0.0',
77   `dont_verify_images` tinyint(1) NOT NULL default '0',
78   PRIMARY KEY  (`id`),
79   KEY `department` (`supplier`)
80 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=24 ;
81
82 -- --------------------------------------------------------
83
84 --
85 -- Table structure for table `project`
86 --
87
88 CREATE TABLE IF NOT EXISTS `project` (
89   `id` int(11) NOT NULL auto_increment,
90   `name` varchar(255) collate utf8_bin NOT NULL,
91   `url` varchar(255) collate utf8_bin NOT NULL,
92   `signature` varchar(1000) collate utf8_bin NOT NULL,
93   `authenticator` varchar(255) collate utf8_bin NOT NULL,
94   `share` tinyint(4) NOT NULL,
95   `detach` tinyint(1) NOT NULL default '0',
96   `update` tinyint(1) NOT NULL default '0',
97   PRIMARY KEY  (`id`)
98 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=38 ;
99
100 -- --------------------------------------------------------
101
102 --
103 -- Table structure for table `stats_host`
104 --
105
106 CREATE TABLE IF NOT EXISTS `stats_host` (
107   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
108   `id` int(11) NOT NULL,
109   `host_cpid` varchar(255) collate utf8_bin NOT NULL,
110   `supplier` varchar(255) collate utf8_bin NOT NULL,
111   `project` varchar(255) collate utf8_bin NOT NULL,
112   `total_credit` float NOT NULL,
113   `expavg_credit` float NOT NULL,
114   `expavg_time` float NOT NULL
115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
116
117 -- --------------------------------------------------------
118
119 --
120 -- Table structure for table `stats_user`
121 --
122
123 CREATE TABLE IF NOT EXISTS `stats_user` (
124   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
125   `project` varchar(255) collate utf8_bin NOT NULL,
126   `total_credit` float NOT NULL,
127   `expavg_credit` float NOT NULL,
128   `expavg_time` float NOT NULL
129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
130
131 -- --------------------------------------------------------
132
133 --
134 -- Table structure for table `user`
135 --
136
137 CREATE TABLE IF NOT EXISTS `user` (
138   `id` int(11) NOT NULL auto_increment,
139   `name` varchar(255) collate utf8_bin NOT NULL,
140   `password` varchar(32) collate utf8_bin NOT NULL,
141   `role` varchar(255) collate utf8_bin NOT NULL,
142   `supplier` varchar(255) collate utf8_bin NOT NULL,
143   `supp_auth` varchar(255) collate utf8_bin NOT NULL,
144   PRIMARY KEY  (`id`)
145 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=9 ;
If this page is incomplete or incorrect, please edit it or add it to the wiki to-do list. To do this, you must be logged in; click Login or Register above.