· 7 years ago · Jan 14, 2019, 09:46 PM
1SQLite 3 interfacing with AM1808 Embedded Linux
2const char *SQL_CREATE_ABCTABLE = "CREATE TABLE IF NOT EXISTS MilkCollection
3 ( MilkCollectionId INTEGER,
4 CollectionDate DATE,
5 CollectionShift UNSIGNED TINYINT,
6 MemberId INTEGER REFERENCES Member(MemberId) ON UPDATE RESTRICT ON DELETE RESTRICT,
7 SocietyId INTEGER REFERENCES Society(SocietyId) ON UPDATE RESTRICT ON DELETE RESTRICT,
8 SampleNo UNSIGNED INTEGER,
9 MilkType UNSIGNED TINYINT,
10 Qty FLOAT,
11 ActualQty FLOAT,
12 QtyType UNSIGNED TINYINT,
13 Fat FLOAT,
14 ActualFat FLOAT,
15 LRCLR FLOAT,
16 ActualLRCLR FLOAT,
17 SNF FLOAT,
18 ActualSNF FLOAT,
19 Solid FLOAT,
20 ActualSolid FLOAT,
21 Water FLOAT, // I have inserted this field
22 FatKG FLOAT,
23 ActualFatKG FLOAT,
24 SNFKG FLOAT,
25 ActualSNFKG FLOAT,
26 Rate FLOAT,
27 Amount FLOAT,
28 ActualAmount FLOAT,
29 CanNumber UNSIGNED INTEGER,
30 MemberCodeAuto UNSIGNED TINYINT,
31 WeightAuto UNSIGNED TINYINT,
32 FatAuto UNSIGNED TINYINT,
33 LRCLRAuto UNSIGNED TINYINT,
34 SNFAuto UNSIGNED TINYINT,
35 EntryMode UNSIGNED TINYINT,
36 CreatedBy INTEGER REFERENCES UserMaster(UsermasterId) ON UPDATE RESTRICT ON DELETE RESTRICT,
37 CreatedOn DATE,
38 UpdatedBy INTEGER REFERENCES UserMaster(UsermasterId) ON UPDATE RESTRICT ON DELETE RESTRICT,
39 UpdatedOn DATE,
40 FlagGSM UNSIGNED TINYINT,
41 FlagUSB UNSIGNED TINYINT,
42 PRIMARY KEY (MilkCollectionId) )";