attachment:cmd.py of MicroProj/2005-07-06

   1 cmds=[
   2 """CREATE TABLE [CaliHis] (
   3  [id] integer not null ,
   4  [mdate] datetime null ,
   5  [methodid] integer null ,
   6  [ele] varchar(2.0) null ,
   7  [useXiaoZheng] smallint null ,
   8  [dxielv] float null ,
   9  [djieju] float null 
  10   ) 
  11 """,
  12 """Alter TABLE [CaliHis]  ADD Primary Key([id] ) [PK_CaliHis]""",
  13 
  14 
  15 
  16 """CREATE TABLE [chanel] (
  17  [ele] varchar(50.0) null ,
  18  [id] integer not null ,
  19  [chanel] smallint null 
  20   ) 
  21 """,
  22 """Alter TABLE [chanel]  ADD Primary Key([id] ) [PK_chanel]""",
  23 
  24 
  25 
  26 """CREATE TABLE [curveData] (
  27  [methodid] integer null ,
  28  [standardid] integer null ,
  29  [eleArea] float null ,
  30  [eleInt] float null ,
  31  [ele] varchar(2.0) null ,
  32  [weight] float null ,
  33  [id] integer not null ,
  34  [calcconc] float null ,
  35  [sampleid] integer null ,
  36  [quan] float null ,
  37  [wlweight] float null 
  38   ) 
  39 """,
  40 """Alter TABLE [curveData]  ADD Primary Key([id] ) [PK_curveData]""",
  41 
  42 
  43 
  44 """CREATE TABLE [CurveHis] (
  45  [id] integer not null ,
  46  [methodid] integer null ,
  47  [mdate] datetime null ,
  48  [x0] float null ,
  49  [x1] float null ,
  50  [x2] float null ,
  51  [x3] float null ,
  52  [ele] varchar(2.0) null ,
  53  [r] float null ,
  54  [cishu] integer null ,
  55  [stderr] float null ,
  56  [LINExishu] real null ,
  57  [min] float null ,
  58  [max] float null 
  59   ) 
  60 """,
  61 """Alter TABLE [CurveHis]  ADD Primary Key([id] ) [PK_CurveHis]""",
  62 
  63 
  64 
  65 """CREATE TABLE [curveXishu] (
  66  [methodid] integer not null ,
  67  [x0] float null ,
  68  [x1] float null ,
  69  [x2] float null ,
  70  [x3] float null ,
  71  [ele] varchar(2.0) not null ,
  72  [xadd] float null ,
  73  [r] float null ,
  74  [fitMode] integer null ,
  75  [cishu] integer null ,
  76  [stderr] float null ,
  77  [LINExishu] real null ,
  78  [calcmode] smallint null ,
  79  [useXiaoZheng] smallint null ,
  80  [dxielv] float null ,
  81  [djieju] float null ,
  82  [UseInt] bit not null ,
  83  [min] float null ,
  84  [max] float null ,
  85  [blankarea] float null ,
  86  [must00] bit not null 
  87   ) 
  88 """,
  89 """Alter TABLE [curveXishu]  ADD Primary Key([methodid] ,[ele] ) [PK_curveXishu]""",
  90 
  91 
  92 
  93 """CREATE TABLE [doChanel] (
  94  [cname] varchar(50.0) null ,
  95  [id] integer not null ,
  96  [chanel] smallint null 
  97   ) 
  98 """,
  99 """Alter TABLE [doChanel]  ADD Primary Key([id] ) [PK_doChanel]""",
 100 
 101 
 102 
 103 """CREATE TABLE [doublestandard] (
 104  [ID] integer not null ,
 105  [standardid] integer not null ,
 106  [methodid] integer not null ,
 107  [ele] varchar(2.0) not null ,
 108  [calcConc] float null ,
 109  [high] bit not null ,
 110  [eleArea] float null ,
 111  [weight] float null 
 112   ) 
 113 """,
 114 """Alter TABLE [doublestandard]  ADD Primary Key([standardid] ,[methodid] ,[ele] ) [PK_doublestandard]""",
 115 
 116 
 117 
 118 """CREATE TABLE [method] (
 119  [ID] integer not null ,
 120  [user] varchar(50.0) not null ,
 121  [name] varchar(50.0) not null ,
 122  [power] integer null ,
 123  [zerovalue] real null ,
 124  [useJiaozheng] bit not null ,
 125  [cswitch] float null ,
 126  [sswitch] float null ,
 127  [smoothnum] smallint null ,
 128  [sampletime] integer null ,
 129  [flushtime] integer null 
 130   ) 
 131 """,
 132 """Alter TABLE [method]  ADD Primary Key([user] ,[name] ) [PK_method]""",
 133 
 134 
 135 
 136 """CREATE TABLE [muser] (
 137  [ID] integer not null ,
 138  [mname] varchar(50.0) not null ,
 139  [autoweight] bit not null ,
 140  [mpassword] varchar(10.0) null ,
 141  [method] varchar(50.0) null ,
 142  [methodid] integer null 
 143   ) 
 144 """,
 145 """Alter TABLE [muser]  ADD Primary Key([mname] ) [PK_muser]""",
 146 
 147 
 148 
 149 """CREATE TABLE [mytmp] (
 150  [methodid] integer null ,
 151  [standardid] integer null ,
 152  [eleArea] float null ,
 153  [eleInt] float null ,
 154  [ele] varchar(2.0) null ,
 155  [weight] float null ,
 156  [calcconc] float null ,
 157  [sampleid] integer null 
 158   ) 
 159 """,
 160 """CREATE INDEX [] on [mytmp]() """,
 161 
 162 
 163 
 164 """CREATE TABLE [netSet] (
 165  [ip] varchar(50.0) null ,
 166  [port] integer null ,
 167  [prot] bit not null ,
 168  [id] integer not null 
 169   ) 
 170 """,
 171 """Alter TABLE [netSet]  ADD Primary Key([id] ) [PK_netSet]""",
 172 
 173 
 174 
 175 """CREATE TABLE [program] (
 176  [tablehead1] varchar(50.0) null ,
 177  [tablehead2] varchar(50.0) null ,
 178  [id] integer not null ,
 179  [sampleId] integer null ,
 180  [isON] bit not null ,
 181  [xuhao] smallint null ,
 182  [sessionid] integer null ,
 183  [lastUser] varchar(50.0) null ,
 184  [autoLogon] bit not null 
 185   ) 
 186 """,
 187 """Alter TABLE [program]  ADD Primary Key([id] ) [PK_program]""",
 188 
 189 
 190 
 191 """CREATE TABLE [sample] (
 192  [ID] integer not null ,
 193  [name] varchar(50.0) null ,
 194  [cArea] float null ,
 195  [c] real null ,
 196  [sArea] float null ,
 197  [s] real null ,
 198  [mdate] datetime null ,
 199  [user] varchar(50.0) null ,
 200  [weight] float null ,
 201  [method] varchar(50.0) null ,
 202  [methodid] integer null ,
 203  [isHc] bit not null ,
 204  [isHs] bit not null ,
 205  [sessionid] integer null ,
 206  [sampleid] integer null ,
 207  [anaxuhao] integer null ,
 208  [cInt] float null ,
 209  [sInt] float null ,
 210  [sIndex] integer null ,
 211  [cIndex] integer null ,
 212  [standardid] integer null ,
 213  [sIndex2] integer null ,
 214  [cIndex2] integer null ,
 215  [wlweight] float null 
 216   ) 
 217 """,
 218 """Alter TABLE [sample]  ADD Primary Key([ID] ) [PK_sample]""",
 219 
 220 
 221 
 222 """CREATE TABLE [SampleAve] (
 223  [sessionid] integer null ,
 224  [sampleid] integer not null ,
 225  [c] real null ,
 226  [s] real null ,
 227  [mdate] datetime null ,
 228  [name] varchar(255.0) null ,
 229  [user] varchar(20.0) null ,
 230  [methodid] integer null ,
 231  [num] smallint null ,
 232  [cstd] float null ,
 233  [sstd] float null 
 234   ) 
 235 """,
 236 """Alter TABLE [SampleAve]  ADD Primary Key([sampleid] ) [PK_SampleAve]""",
 237 
 238 
 239 
 240 """CREATE TABLE [SingleStandard] (
 241  [ID] integer not null ,
 242  [standardid] integer null ,
 243  [eleArea] float null ,
 244  [weight] float null ,
 245  [methodid] integer null ,
 246  [ele] varchar(2.0) null ,
 247  [IsBlank] bit not null ,
 248  [xishu] float null ,
 249  [calcConc] float null 
 250   ) 
 251 """,
 252 """Alter TABLE [SingleStandard]  ADD Primary Key([ID] ) [PK_SingleStandard]""",
 253 
 254 
 255 
 256 """CREATE TABLE [standard] (
 257  [ID] integer not null ,
 258  [name] varchar(50.0) null ,
 259  [cconc] real null ,
 260  [sconc] real null ,
 261  [description] varchar(50.0) null ,
 262  [userid] integer null 
 263   ) 
 264 """,
 265 """Alter TABLE [standard]  ADD Primary Key([ID] ) [PK_standard]""",
 266 
 267 
 268 
 269 """CREATE TABLE [tmp] (
 270  [methodid] integer null ,
 271  [standardid] integer null ,
 272  [sampleid] integer null ,
 273  [ele] varchar(2.0) null ,
 274  [elearea] float null ,
 275  [weight] float null ,
 276  [quan] float null 
 277   ) 
 278 """,
 279 """CREATE INDEX [] on [tmp]() """,
 280 
 281 
 282 
 283 """CREATE TABLE [tmpid] (
 284  [sampleid] integer not null 
 285   ) 
 286 """,
 287 """Alter TABLE [tmpid]  ADD Primary Key([sampleid] ) [PK_tmpid]""",
 288 
 289 
 290 
 291 """CREATE TABLE [tmpReport] (
 292  [id] integer not null ,
 293  [sessionid] integer null ,
 294  [sampleid] integer null ,
 295  [c] real null ,
 296  [s] real null ,
 297  [mdate] datetime null ,
 298  [name] varchar(255.0) null ,
 299  [user] varchar(20.0) null ,
 300  [methodid] integer null ,
 301  [num] smallint null ,
 302  [cstd] float null ,
 303  [sstd] float null 
 304   ) 
 305 """,
 306 """Alter TABLE [tmpReport]  ADD Primary Key([id] ) [PK_tmpReport]""",
 307 
 308 
 309 
 310 """CREATE TABLE [usehistory] (
 311  [ID] integer not null ,
 312  [user] varchar(50.0) null ,
 313  [starttime] datetime null ,
 314  [endtime] datetime null 
 315   ) 
 316 """,
 317 """Alter TABLE [usehistory]  ADD Primary Key([ID] ) [PK_usehistory]""",
 318 
 319 
 320 
 321 """CREATE TABLE [volt] (
 322  [mtime] float null ,
 323  [cvolt] float null ,
 324  [svolt] float null ,
 325  [sampleid] integer null ,
 326  [id] integer not null ,
 327  [c2volt] float null ,
 328  [s2volt] float null 
 329   ) 
 330 """,
 331 """CREATE Unique INDEX [id1] on [volt]([id] ) """,
 332 
 333 
 334 
 335 """CREATE TABLE [VoltNew] (
 336  [sampleid] integer not null ,
 337  [mtimeArr] text null ,
 338  [cvoltArr] text null ,
 339  [svoltArr] text null ,
 340  [c2voltArr] text null ,
 341  [s2voltArr] text null ,
 342  [xn] integer null ,
 343  [yn0] integer null ,
 344  [yn1] integer null ,
 345  [yn2] integer null ,
 346  [yn3] integer null 
 347   ) 
 348 """,
 349 """Alter TABLE [VoltNew]  ADD Primary Key([sampleid] ) [PK_VoltNew]""",
 350 
 351 
 352 
 353 """CREATE TABLE [weight] (
 354  [id] integer not null ,
 355  [time] datetime null ,
 356  [name] varchar(50.0) null ,
 357  [weight] float null 
 358   ) 
 359 """,
 360 """Alter TABLE [weight]  ADD Primary Key([id] ) [PK_weight]""",
 361 
 362 
 363 ]