-- HyperLeda database installation, by Igor Chilingarian, Sternberg institute
--   build the indices for LEDA tables

VACUUM FULL; 
VACUUM ANALYZE; 

-- CREATE VIEW meandata AS
--    SELECT m000.pgc, m000.objname, m000.objtype, m000.al1950, m000.de1950, m000.al2000, m000.de2000, m000.l2, m000.b2, m000.sgl, m000.sgb, m000."type", m000.bar, m000.ring, m000.multiple, m000.compactness, m000.t, m000.e_t, m000.lc, m000.e_lc, m000.logd25, m000.e_logd25, m000.logr25, m000.e_logr25, m000.pa, m000.brief, m000.e_brief, m000.bt, m000.e_bt, m000.it, m000.e_it, m000.ubt, m000.bvt, m000.ube, m000.bve, m000.w20, m000.e_w20, m000.w50, m000.e_w50, m000.dvmsini, m000.logs, m000.e_logs, m000.m21, m000.e_m21, m000.mfir, m000.vrad, m000.e_vrad, m000.vopt, m000.e_vopt, m000.v, m000.e_v, m000.lgg, m000.ag, m000.ai, m000.incl, m000.a21, m000.lambda, m000.logdc, m000.btc, m000.itc, m000.ubtc, m000.bvtc, m000.bri25, m000.logvm, m000.e_logvm, m000.logvmha, m000.e_logvmha, m000.logavmm, m000.e_logavmm, m000.m21c, m000.hic, m000.vlg, m000.vgsr, m000.vvir, m000.v3k, m000.mucin, m000.mup, m000.mabs FROM m000;

-- end -- 

