· 8 years ago · Jul 17, 2018, 03:54 PM
1
2CREATE TABLE IF NOT EXISTS `bishop_hall_shark_100_meter` (
3 `time` datetime NOT NULL,
4 `error` int(11) default NULL,
5 `lowalarm` int(11) default NULL,
6 `highalarm` int(11) default NULL,
7 `Volts_A_N_Volts` float default NULL,
8 `Volts_B_N_Volts` float default NULL,
9 `Volts_C_N_Volts` float default NULL,
10 `Volts_A_B_Volts` float default NULL,
11 `Volts_B_C_Volts` float default NULL,
12 `Volts_C_A_Volts` float default NULL,
13 `Amps_A_Amps` float default NULL,
14 `Amps_B_Amps` float default NULL,
15 `Amps_C_Amps` float default NULL,
16 `Watts_3_Ph_total_kW` float default NULL,
17 `VARs_3_Ph_total_kVAR` float default NULL,
18 `VAs_3_Ph_total_kVA` float default NULL,
19 `Power_Factor_3_Ph_total` float default NULL,
20 `Frequency_Hz` float default NULL,
21 `Neutral_Current_Amps` float default NULL,
22 `W_hours_Received_kWh` float default NULL,
23 `W_hours_Delivered_kWh` float default NULL,
24 `W_hours_Net_kWh` float default NULL,
25 `W_hours_Total_kWh` float default NULL,
26 `VAR_hours_Positive_kVARh` float default NULL,
27 `VAR_hours_Negative_kVARh` float default NULL,
28 `VAR_hours_Net_kVARh` float default NULL,
29 `VAR_hours_Total_kVARh` float default NULL,
30 `VA_hours_Total_kVAh` float default NULL,
31 `Amps_A_Average_Amps` float default NULL,
32 `Amps_B_Average_Amps` float default NULL,
33 `Amps_C_Average_Amps` float default NULL,
34 `Positive_Watts_3_Ph_Average_kW` float default NULL,
35 `Positive_VARs_3_Ph_Average_kVAR` float default NULL,
36 `Negative_Watts_3_Ph_Average_kW` float default NULL,
37 `Negative_VARs_3_Ph_Average_kVAR` float default NULL,
38 `VAs_3_Ph_Average_kVA` float default NULL,
39 `Positive_PF_3_Ph_Average` float default NULL,
40 `Negative_PF_3_Ph_Average` float default NULL,
41 `Volts_A_N_Min_Volts` float default NULL,
42 `Volts_B_N_Min_Volts` float default NULL,
43 `Volts_C_N_Min_Volts` float default NULL,
44 `Volts_A_B_Min_Volts` float default NULL,
45 `Volts_B_C_Min_Volts` float default NULL,
46 `Volts_C_A_Min_Volts` float default NULL,
47 `Amps_A_Min_Avg_Demand_Amps` float default NULL,
48 `Amps_B_Min_Avg_Demand_Amps` float default NULL,
49 `Amps_C_Min_Avg_Demand_Amps` float default NULL,
50 `Positive_Watts_3_Ph_Min_Avg_Demand_kW` float default NULL,
51 `Positive_VARs_3_Ph_Min_Avg_Demand_kVAR` float default NULL,
52 `Negative_Watts_3_Ph_Min_Avg_Demand_kW` float default NULL,
53 `Negative_VARs_3_Ph_Min_Avg_Demand_kVAR` float default NULL,
54 `VAs_3_Ph_Min_Avg_Demand_kVA` float default NULL,
55 `Positive_PF_3_Ph_Min_Avg_Demand` float default NULL,
56 `Negative_PF_3_Ph_Min_Avg_Demand` float default NULL,
57 `Frequency_Min_Hz` float default NULL,
58 `Volts_A_N_Max_Volts` float default NULL,
59 `Volts_B_N_Max_Volts` float default NULL,
60 `Volts_C_N_Max_Volts` float default NULL,
61 `Volts_A_B_Max_Volts` float default NULL,
62 `Volts_B_C_Max_Volts` float default NULL,
63 `Volts_C_A_Max_Volts` float default NULL,
64 `Amps_A_Max_Avg_Demand_Amps` float default NULL,
65 `Amps_B_Max_Avg_Demand_Amps` float default NULL,
66 `Amps_C_Max_Avg_Demand_Amps` float default NULL,
67 `Positive_Watts_3_Ph_Max_Avg_Demand_kW` float default NULL,
68 `Positive_VARs_3_Ph_Max_Avg_Demand_kVAR` float default NULL,
69 `Negative_Watts_3_Ph_Max_Avg_Demand_kW` float default NULL,
70 `Negative_VARs_3_Ph_Max_Avg_Demand_kVAR` float default NULL,
71 `VAs_3_Ph_Max_Avg_Demand_kVA` float default NULL,
72 `Positive_PF_3_Ph_Max_Avg_Demand` float default NULL,
73 `Negative_PF_3_Ph_Max_Avg_Demand` float default NULL,
74 `Frequency_Max_Hz` float default NULL,
75 `Volts_A_N_THD` float default NULL,
76 `Volts_B_N_THD` float default NULL,
77 `Volts_C_N_THD` float default NULL,
78 `Volts_A_B_THD` float default NULL,
79 `Volts_B_C_THD` float default NULL,
80 `Volts_C_A_THD` float default NULL,
81 `Phase_A_Current_0th_harmonic_magnitude` float default NULL,
82 `Phase_A_Current_1st_harmonic_magnitude` float default NULL,
83 `Phase_A_Current_2nd_harmonic_magnitude` float default NULL,
84 `Phase_A_Current_3rd_harmonic_magnitude` float default NULL,
85 `Phase_A_Current_4th_harmonic_magnitude` float default NULL,
86 `Phase_A_Current_5th_harmonic_magnitude` float default NULL,
87 `Phase_A_Current_6th_harmonic_magnitude` float default NULL,
88 `Phase_A_Current_7th_harmonic_magnitude` float default NULL,
89 `Phase_A_Voltage_0th_harmonic_magnitude` float default NULL,
90 `Phase_A_Voltage_1st_harmonic_magnitude` float default NULL,
91 `Phase_A_Voltage_2nd_harmonic_magnitude` float default NULL,
92 `Phase_A_Voltage_3rd_harmonic_magnitude` float default NULL,
93 `Phase_B_Current_0th_harmonic_magnitude` float default NULL,
94 `Phase_B_Current_1st_harmonic_magnitude` float default NULL,
95 `Phase_B_Current_2nd_harmonic_magnitude` float default NULL,
96 `Phase_B_Current_3rd_harmonic_magnitude` float default NULL,
97 `Phase_B_Current_4th_harmonic_magnitude` float default NULL,
98 `Phase_B_Current_5th_harmonic_magnitude` float default NULL,
99 `Phase_B_Current_6th_harmonic_magnitude` float default NULL,
100 `Phase_B_Current_7th_harmonic_magnitude` float default NULL,
101 `Phase_B_Voltage_0th_harmonic_magnitude` float default NULL,
102 `Phase_B_Voltage_1st_harmonic_magnitude` float default NULL,
103 `Phase_B_Voltage_2nd_harmonic_magnitude` float default NULL,
104 `Phase_B_Voltage_3rd_harmonic_magnitude` float default NULL,
105 `Phase_C_Current_0th_harmonic_magnitude` float default NULL,
106 `Phase_C_Current_1st_harmonic_magnitude` float default NULL,
107 `Phase_C_Current_2nd_harmonic_magnitude` float default NULL,
108 `Phase_C_Current_3rd_harmonic_magnitude` float default NULL,
109 `Phase_C_Current_4th_harmonic_magnitude` float default NULL,
110 `Phase_C_Current_5th_harmonic_magnitude` float default NULL,
111 `Phase_C_Current_6th_harmonic_magnitude` float default NULL,
112 `Phase_C_Current_7th_harmonic_magnitude` float default NULL,
113 `Phase_C_Voltage_0th_harmonic_magnitude` float default NULL,
114 `Phase_C_Voltage_1st_harmonic_magnitude` float default NULL,
115 `Phase_C_Voltage_2nd_harmonic_magnitude` float default NULL,
116 `Phase_C_Voltage_3rd_harmonic_magnitude` float default NULL,
117 `Angle_Phase_A_Current_Degrees` float default NULL,
118 `Angle_Phase_B_Current_Degrees` float default NULL,
119 `Angle_Phase_C_Current_Degrees` float default NULL,
120 `Angle_Volts_A_B_Degrees` float default NULL,
121 `Angle_Volts_B_C_Degrees` float default NULL,
122 `Angle_Volts_C_A_Degrees` float default NULL,
123 PRIMARY KEY (`time`)
124) ENGINE=MyISAM DEFAULT CHARSET=latin1;