Dear CJ, On 30.09.2013, at 19:17, CJ Keist <[email protected]> wrote:
> Could someone send me the the table structure for oc_preferneces? For some > reason my database doesn't have it. We use the MySQL backend. You can use the mysql commandline tool to take a closer look at the database: mysql> use owncloud; mysql> describe oc_preferences; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | userid | varchar(64) | NO | MUL | | | | appid | varchar(32) | NO | | | | | configkey | varchar(64) | NO | | | | | configvalue | longtext | YES | | NULL | | +-------------+-------------+------+-----+---------+-------+ However, the script of my previous mail is probably more suitable for your problem. Warm regards, Stefan On 30.09.2013, at 19:17, CJ Keist <[email protected]> wrote: > Could someone send me the the table structure for oc_preferneces? For some > reason my database doesn't have it. > > On 9/27/13 4:18 PM, Stefan Vollmar wrote: >> Dear CJ Keist, >> >> On 27.09.2013, at 22:28, CJ Keist <[email protected]> wrote: >> >>> The web interface doesn't look to have the ability to list thousands of >>> users on my owncloud system. So there is no way for me to set custom disk >>> quotas for users that are not displayed on the web interface. I have tried >>> the search function on the page but that doesn't work. >>> So I tried to see where disk quota settings are stored on the mysql >>> database but have not had any luck finding where that value is set per user >>> account. Could someone direct me on how I can set default disk quota for >>> users on my system? >> >> I am not sure that this is the "official" way of doing things but I would >> suggest a different approach: if you use the MySQL backend, it seems to be >> pretty straightforward to set all sorts of parameters with a few lines of >> SQL code. In fact, this is similar to our own automated method of creating a >> large number of users in OwnCloud and sending automatically generated >> E-mails with activation links (tokens). >> >> With OwnCloud 5, you can look up user data in the oc_user table (here: >> "aeinstein" is the "uid" of "Albert Einstein"), you can then set a quota of >> 10 GB like this: >> >> INSERT INTO `oc_preferences` VALUES >> ('aeinstein','files','quota','10 GB'); >> >> If you have a list of uids it is very easy to repeat that line as often as >> required. >> >> Warm regards, >> Stefan >> >>> >>> >>> -- >>> C. J. Keist Email: [email protected] >>> Systems Group Manager Solaris 10 OS (SAI) >>> Engineering Network Services Phone: 970-491-0630 >>> College of Engineering, CSU Fax: 970-491-5569 >>> Ft. Collins, CO 80523-1301 >>> >>> All I want is a chance to prove 'Money can't buy happiness' >>> >>> _______________________________________________ >>> Owncloud mailing list >>> [email protected] >>> https://mail.kde.org/mailman/listinfo/owncloud >> > > -- > C. J. Keist Email: [email protected] > Systems Group Manager Solaris 10 OS (SAI) > Engineering Network Services Phone: 970-491-0630 > College of Engineering, CSU Fax: 970-491-5569 > Ft. Collins, CO 80523-1301 > > All I want is a chance to prove 'Money can't buy happiness' -- Dr. Stefan Vollmar, Dipl.-Phys. Head of IT group Max-Planck-Institut für neurologische Forschung Gleueler Str. 50, 50931 Köln, Germany Tel.: +49-221-4726-213 FAX +49-221-4726-298 Tel.: +49-221-478-5713 Mobile: 0160-93874279 E-Mail: [email protected] http://www.nf.mpg.de
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
