While looking through the SQLite database scheme I found two things which could be removed by my opinion.
First thing is the size value of fields. SQLite totally ignores them. I can understand that it was kept for consistency, but it just makes the scheme bigger for SQLite.
The second thing, which I would need to check again is the INTEGER PRIMARY KEY NOT NULL thing. As far as I'm aware of, if you define an integer primary key, then you don't need to write >NOT NULL< as SQLite will not allow to insert an empty value into it because of the primary key constraint. (Except if you insert a row with NULL as the primary key value it will get the highest available row number + 1.)
SQLite Database scheme
Discuss general development subjects that are not specific to a particular version like the versioning control system we use or other infrastructure.
Post Reply
1 post
• Page 1 of 1
Return to “General Development Discussion”
Jump to
- www.phpbb.com/community/
- General Development Discussion
- phpBB 4.x Development
- ↳ [4.x] Discussion
- ↳ [4.x] Tickets Discussion
- ↳ [4.x] Style Development
- phpBB 3.x Development
- ↳ [3.x] Discussion
- ↳ [3.x] Tickets Discussion
- ↳ [3.x] Style Development
- ↳ [3.x][Archive] RFCs
- ↳ [3.x] Event Requests
- ↳ [3.1/Ascraeus] Merged RFCs
- ↳ [3.1/Ascraeus] Merged Event Requests
- ↳ [3.2/Rhea] Merged RFCs
- ↳ [3.x] Rejected RFCs
- ↳ [3.x] Rejected Event Requests
- Everything Else
- ↳ Chit Chat
- ↳ Testing subforum
- ↳ Subforum
- ↳ A "category" subforum in the Testing subforum
- ↳ A sub-sub-forum
- ↳ Passworded Forum
- ↳ Archive of phpBB related forums
- ↳ phpBB 3.0.x Support
- ↳ phpBB 3.0.x MOD/Style Support
- ↳ EasyMOD for 2.0.x
- ↳ Download EasyMOD
- ↳ Announcements and News
- ↳ General EM Discussion
- ↳ Installing EasyMOD
- ↳ Installing MODs with EasyMOD
- ↳ SQL Parser
- ↳ EMC Discussion
- ↳ Bug Tracker
- ↳ Feature Requests
- ↳ Stable Branch: phpBB "Olympus" 3.0
- ↳ [3.0/Olympus] Discussion
- ↳ [3.0/Olympus] New features discussion
- ↳ [3.0/Olympus] Styling